Skip to main content

This site requires you to update your browser. Your browsing experience maybe affected by not having the most up to date version.

Installing SilverStripe /

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

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

Login problems, need DB expertise


Reply


6 Posts   1561 Views

Avatar
Oyster

Community Member, 17 Posts

16 January 2009 at 3:52am

Edited: 16/01/2009 3:53am

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 [url]http://doc.silverstripe.com/doku.php?id=publishing-to-web-server&s=upload%20server [/url]

Avatar
Nivanka

Community Member, 400 Posts

16 January 2009 at 6:20am

Edited: 16/01/2009 6:50am

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

Avatar
Oyster

Community Member, 17 Posts

16 January 2009 at 8:41am

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)

Avatar
Fuzz10

Community Member, 787 Posts

16 January 2009 at 9:09pm

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.....

Avatar
Oyster

Community Member, 17 Posts

17 January 2009 at 2:16am

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

Am I ever so thankful? Indeed. :-) I love this place....

Avatar
Nivanka

Community Member, 400 Posts

17 January 2009 at 2:20am

Sweet!

good stuff