Jump to:

4952 Posts in 14417 Topics by 1491 members

Installing SilverStripe

SilverStripe Forums » Installing SilverStripe » Login problems, need DB expertise

Getting SilverStripe up and running on your computer and on your web server.

Moderators: martimiz, Sean, biapar, Willr, Ingo, swaiba, simon_w

Page: 1
Go to End
Author Topic: 1465 Views
  • Oyster
    Avatar
    Community Member
    17 Posts

    Login problems, need DB expertise Link to this post

    How do I reset login? My CMS will not accept my login info. The SMS login-data seem to be inconsistent on my installation here. I have done many, many attempts of installing - uninstalling - reinstalling without success, and my database seem to be mixed up. Can anyone help?

    I am installing SS on a live website, after having developed a project on a local wamp server. Install/upload is done according to instructions in SS tutorial on uploading to a server http://doc.silverstripe.com/doku.php?id=publishing-to-web-server&s=upload%20server

  • Nivanka
    Avatar
    Community Member
    395 Posts

    Re: Login problems, need DB expertise Link to this post

    Do you have access to the database? if so it will be nice.

    Open up the database and add a new user manually, but make sure the encrustations are correct
    Your SQL will be something like the following.

    INSERT INTO `Member` (`ID`, `ClassName`, `Created`, `LastEdited`, `FirstName`, `Surname`, `Email`, `Password`, `RememberLoginToken`, `NumVisit`, `LastVisited`, `Bounced`, `AutoLoginHash`, `AutoLoginExpired`, `BlacklistedEmail`, `PasswordEncryption`, `Salt`, `Locale`, `IdentityURL`) VALUES
    ('', 'Member', '2009-01-12 11:33:43', '2009-01-15 10:04:04', NULL, NULL, 'demo', 'r8gyl9x2ttwkwwgo00cw8k0sc048csk', NULL, 8, '2009-01-15 11:02:40', 0, NULL, NULL, 0, 'sha1', '3fpdtaxvqri8oc4cgcskwok8g8g8osk4g8wo8gg', NULL, NULL);

    if this is successful you will be able to login with these credentials

  • Oyster
    Avatar
    Community Member
    17 Posts

    Re: Login problems, need DB expertise Link to this post

    Thank you, Nivanka.

    Followed your suggestion, but it didn't solve it.

    The username and pw I used (after having altered the MEMBER-filed as you proposed, was the same as in the calendar demo. Is that correct?

    But some change is visible though: now the "login info is not correct"-message does NOT appear, as it did before. Now http://www.mysite.com/admin returns an empty cms-loginpage. (Empty: meaning with no credentials registered in the text input fields)

  • Fuzz10
    Avatar
    Community Member
    787 Posts

    Re: Login problems, need DB expertise Link to this post

    You can also add some default admin credentials to the _config.php :

    Security::setDefaultAdmin(’admin’,’password’);

    Check if you can enter the CMS that way.....

  • Oyster
    Avatar
    Community Member
    17 Posts

    Re: Login problems, need DB expertise Link to this post

    Yess!!! Thank, you very much! The_config.php- fix did the job!

    Am I ever so thankful? Indeed. I love this place....

  • Nivanka
    Avatar
    Community Member
    395 Posts

    Re: Login problems, need DB expertise Link to this post

    Sweet!

    good stuff

    1465 Views
Page: 1
Go to Top

Want to know more about the company that brought you SilverStripe? Then check out SilverStripe.com

Comments on this website? Please give feedback.