I've been locked out of my personal blog for quite some time and want to fix that. I just upgraded the software (admin page says "Powered by Serendipity 1.5.5 and PHP 5.2.17") and all looks good on main page (except for plugins, broken by an upgrade?)
I can access the database.
mysql> select username from serendipity_authors;
returns the user I set up. However, that username along with the password I thought was valid will not log me in at http://danrasmussen.org/blog/serendipity_admin.php
I can access the database, and tried resetting my password in five different ways, none of which worked:
UPDATE serendipity_authors SET password = sha1('newpassword') where username = "$USER";
UPDATE serendipity_authors SET password = md5('newpassword') where username = "$USER";
UPDATE serendipity_authors SET password = 'newpassword' where username = "$USER";
UPDATE serendipity_authors SET password = '' where username = "$USER";
UPDATE serendipity_authors SET password = '' where username = "$USER";
Any help getting back in would be greatly appreciated!
Thanks in advance,
Dan
Can't Log In
Re: Can't Log In
First of all, md5 should be used for the password in the db as far as I understand the respective section of Garvin's (German) s9y book. If you're absolutely positive you're entering the correct user/pw combination (correct as in: the one that's in the db now), make sure your browser accepts cookies. Another option is to deleted all saved cookies in the browser related to s9y and try again. Also, if your username/password contains special characters, this might cause issues as well.dhrasmus wrote:I can access the database, and tried resetting my password in five different ways, none of which worked:
YL
Re: Can't Log In
Recent s9y versions >1.5 no longer use MD5 hashing, but sha1 with a salted hash.
Please read about fix-YOUR-login and test-MAIN-users scripts here:
fixlogin.php http://board.s9y.org/viewtopic.php?f=1& ... #p10425053
testusers.php http://board.s9y.org/viewtopic.php?f=3& ... #p10424763
Please read about fix-YOUR-login and test-MAIN-users scripts here:
fixlogin.php http://board.s9y.org/viewtopic.php?f=1& ... #p10425053
testusers.php http://board.s9y.org/viewtopic.php?f=3& ... #p10424763
Regards,
Ian
Serendipity Styx Edition and additional_plugins @ https://ophian.github.io/ @ https://github.com/ophian
Ian
Serendipity Styx Edition and additional_plugins @ https://ophian.github.io/ @ https://github.com/ophian
Re: Can't Log In
Thanks, all! Got it working.
Here's what happened: somewhere along the way, it looks like an upgrade script wasn't run. I looked at my blog posts to figure out which version of s9y I'd been using (initially, 1.4). That's why the following line didn't work!
mysql> UPDATE serendipity_authors SET password = sha1('newpassword') where username = "$USER";
I'd read that s9y uses sha1 for passwords but was getting a warning (data truncated) from this, which should have set off an alarm.
So, I changed the version # of s9y back to "1.4" in "serendipity_config_local.inc.php" , went back to my blog URL, upgraded, ran the above SQL (which worked this time!) and I'm back in. Now to find out why a couple of plugins aren't working...
Thanks again!
Here's what happened: somewhere along the way, it looks like an upgrade script wasn't run. I looked at my blog posts to figure out which version of s9y I'd been using (initially, 1.4). That's why the following line didn't work!
mysql> UPDATE serendipity_authors SET password = sha1('newpassword') where username = "$USER";
I'd read that s9y uses sha1 for passwords but was getting a warning (data truncated) from this, which should have set off an alarm.
So, I changed the version # of s9y back to "1.4" in "serendipity_config_local.inc.php" , went back to my blog URL, upgraded, ran the above SQL (which worked this time!) and I'm back in. Now to find out why a couple of plugins aren't working...
Thanks again!
Re: Can't Log In
dhrasmus wrote:I've been locked out of my personal blog for quite some time and want to fix that. I just upgraded the software (admin page says "Powered by Serendipity 1.5.5 and PHP 5.2.17") and all looks good on main page (except for plugins, broken by an upgrade?)
I can access the database.
mysql> select username from serendipity_authors;
returns the user I set up. However, that username along with the password I thought was valid will not log me in at http://danrasmussen.org/blog/serendipity_admin.php
I can access the database, and tried resetting my password in five different ways, none of which worked:
UPDATE serendipity_authors SET password = sha1('newpassword') where username = "$USER";
UPDATE serendipity_authors SET password = md5('newpassword') where username = "$USER";
UPDATE serendipity_authors SET password = 'newpassword' where username = "$USER";
UPDATE serendipity_authors SET password = '' where username = "$USER";
UPDATE serendipity_authors SET password = '' where username = "$USER";
Any help getting back in would be greatly appreciated!
Thanks in advance,
Dan
Hey, I've been facing the same problem! I tried everyone's instruction here but I have no luck yet. Please help me.. I am doing this for a project in my English project. Can someone help me? I am facing some problems in logging in serendipity. Thanks! Getting really frustrated now.
Re: Can't Log In
Hi
Thats odd. Nothing to get frustrated.
Some more information would have been good to have...
- Which old Serendipity Version did you upgrade to which current version?
- What exactly happend in the upgrade process? What are the effects?
- Which steps did you take to workaround these effects exactly, as stated in this thread.
Thats odd. Nothing to get frustrated.
Some more information would have been good to have...
- Which old Serendipity Version did you upgrade to which current version?
- What exactly happend in the upgrade process? What are the effects?
- Which steps did you take to workaround these effects exactly, as stated in this thread.
Regards,
Ian
Serendipity Styx Edition and additional_plugins @ https://ophian.github.io/ @ https://github.com/ophian
Ian
Serendipity Styx Edition and additional_plugins @ https://ophian.github.io/ @ https://github.com/ophian
-
- Core Developer
- Posts: 30022
- Joined: Tue Sep 16, 2003 9:45 pm
- Location: Cologne, Germany
- Contact:
Re: Can't Log In
Also this forum contains some links on how to reset passwords...search for "hash" and "password" or something like that and you should find them. Make sure you find a recent thread, because about 2 years ago we changed from md5 to sha1.
Regards,
Garvin
Regards,
Garvin
# Garvin Hicking (s9y Developer)
# Did I help you? Consider making me happy: http://wishes.garv.in/
# or use my PayPal account "paypal {at} supergarv (dot) de"
# My "other" hobby: http://flickr.garv.in/
# Did I help you? Consider making me happy: http://wishes.garv.in/
# or use my PayPal account "paypal {at} supergarv (dot) de"
# My "other" hobby: http://flickr.garv.in/
Re: Can't Log In
Even this thread does. That is why I asked which steps ihanna already tried, as stated in here...garvinhicking wrote:Also this forum contains some links on how to reset passwords...
Regards,
Ian
Serendipity Styx Edition and additional_plugins @ https://ophian.github.io/ @ https://github.com/ophian
Ian
Serendipity Styx Edition and additional_plugins @ https://ophian.github.io/ @ https://github.com/ophian