Can't Log In

Having trouble installing serendipity?
Post Reply
dhrasmus
Posts: 2
Joined: Wed Jun 15, 2011 9:56 pm

Can't Log In

Post by dhrasmus » Wed Jun 15, 2011 10:17 pm

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

User avatar
yellowled
Regular
Posts: 7056
Joined: Fri Jan 13, 2006 12:46 pm
Location: Eutin, Germany
Contact:

Re: Can't Log In

Post by yellowled » Thu Jun 16, 2011 12:57 am

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
amazon Wishlist - Serendipity-Podcast (German only, sorry)

User avatar
Timbalu
Regular
Posts: 4598
Joined: Sun May 02, 2004 3:04 pm

Re: Can't Log In

Post by Timbalu » Thu Jun 16, 2011 9:46 am

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
Regards,
Ian

Serendipity Styx Edition and additional_plugins @ https://ophian.github.io/ @ https://github.com/ophian

dhrasmus
Posts: 2
Joined: Wed Jun 15, 2011 9:56 pm

Re: Can't Log In

Post by dhrasmus » Sat Jun 18, 2011 9:30 pm

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!

ihanna
Posts: 1
Joined: Thu May 31, 2012 7:22 pm

Re: Can't Log In

Post by ihanna » Thu May 31, 2012 7:28 pm

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

User avatar
Timbalu
Regular
Posts: 4598
Joined: Sun May 02, 2004 3:04 pm

Re: Can't Log In

Post by Timbalu » Fri Jun 01, 2012 8:20 am

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.
Regards,
Ian

Serendipity Styx Edition and additional_plugins @ https://ophian.github.io/ @ https://github.com/ophian

User avatar
garvinhicking
Core Developer
Posts: 30020
Joined: Tue Sep 16, 2003 9:45 pm
Location: Cologne, Germany
Contact:

Re: Can't Log In

Post by garvinhicking » Fri Jun 01, 2012 4:51 pm

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
# 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/

User avatar
Timbalu
Regular
Posts: 4598
Joined: Sun May 02, 2004 3:04 pm

Re: Can't Log In

Post by Timbalu » Fri Jun 01, 2012 5:43 pm

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...
Regards,
Ian

Serendipity Styx Edition and additional_plugins @ https://ophian.github.io/ @ https://github.com/ophian

Post Reply