Serendipity Forums

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

dhrasmus wrote:I can access the database, and tried resetting my password in five different ways, none of which worked:

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.

YL

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

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!

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.

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.

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

garvinhicking wrote:Also this forum contains some links on how to reset passwords...

Even this thread does. That is why I asked which steps ihanna already tried, as stated in here...