Forgot password !!!

Random stuff about serendipity. Discussion, Questions, Paraphernalia.
Post Reply
akashlal
Posts: 2
Joined: Wed Apr 02, 2008 7:59 am

Forgot password !!!

Post by akashlal »

Hi

Last time, I visited my blog, is more than 6 months. Now I for got my admin login password. Is there anyway I can recover my password? Please reply. Thanks.
garvinhicking
Core Developer
Posts: 30022
Joined: Tue Sep 16, 2003 9:45 pm
Location: Cologne, Germany
Contact:

Re: Forgot password !!!

Post by garvinhicking »

Hi!

You need to use a database tool like phpMyAdmin t access your serendipity_authors table.There you can edit your admin user's account and enter a newMD5-encoded password (enter your password and choose "Md5"from the function dropdown)l.

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/
Wizard
Regular
Posts: 103
Joined: Sat Aug 13, 2005 7:18 am
Location: Southern California
Contact:

Re: Forgot password !!!

Post by Wizard »

garvinhicking wrote:Hi!

You need to use a database tool like phpMyAdmin t access your serendipity_authors table.There you can edit your admin user's account and enter a newMD5-encoded password (enter your password and choose "Md5"from the function dropdown)l.

Regards,
Garvin
I tried this on one of my websites that I cannot get log on to. I even tried your "jackal" example, but still I can't get into the bolg admin pages. Any other clues?

I even tried inserting a new user directly using MyPHP ( I first verified that I could and it worked on my development system) but when I tried the same on the actual site, it still said that "You appear to have entered an invalid username or password". Could there be a lock somewhere?
Wizard
My WeBlog
garvinhicking
Core Developer
Posts: 30022
Joined: Tue Sep 16, 2003 9:45 pm
Location: Cologne, Germany
Contact:

Re: Forgot password !!!

Post by garvinhicking »

Hi!

In your serendipity_authors DB table, is the "hashtype" column set? If not, you probably did not execute the 1.5 upgrade... Serendipity 1.5 does no longer use MD5 hashes. You might want to search this board for "sha" and/or "hashtype" to see some threads about this.

HTH,
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/
Wizard
Regular
Posts: 103
Joined: Sat Aug 13, 2005 7:18 am
Location: Southern California
Contact:

Re: Forgot password !!!

Post by Wizard »

I performed an upgrade a while back. I'm now running Serendipity 1.5.2 and PHP 5.2.5 with a MySQL database Version 5. In the serendipity_authors table I don't see a hashtype column. I also used SHA1 (which is my only choice) to reset the password and yet I still can't log in. Any other ideas?
Wizard
My WeBlog
garvinhicking
Core Developer
Posts: 30022
Joined: Tue Sep 16, 2003 9:45 pm
Location: Cologne, Germany
Contact:

Re: Forgot password !!!

Post by garvinhicking »

Hi!

You need to re-execute the upgrade to 1.5 - you are missing the sql/db_update...sql files that would have added hashtype column!

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/
Wizard
Regular
Posts: 103
Joined: Sat Aug 13, 2005 7:18 am
Location: Southern California
Contact:

Re: Forgot password !!!

Post by Wizard »

Ok, I copied the files back over the existing files via FTP. But in hitting the site it doesn't prompt me to perform an upgrade like normal (I guess because I did it before). How do I force an upgrade?
Wizard
My WeBlog
Don Chambers
Regular
Posts: 3652
Joined: Mon Feb 13, 2006 2:40 am
Location: Chicago, IL, USA
Contact:

Re: Forgot password !!!

Post by Don Chambers »

Wizard wrote:How do I force an upgrade?
Via ftp, your site's root folder will have a file named serendipity_config_local.inc.php. Within that file, will be a line such as this:

Code: Select all

$serendipity['versionInstalled']  = '1.5.2';
Change that line to an earlier version of serendipity, ideally whatever you upgraded from, such as:

Code: Select all

$serendipity['versionInstalled']  = '1.4;
Save the file, and the next time you hit your site the upgrade will be initiated.
=Don=
Wizard
Regular
Posts: 103
Joined: Sat Aug 13, 2005 7:18 am
Location: Southern California
Contact:

Re: Forgot password !!!

Post by Wizard »

That did the trick! I had to also change the hashtype from NULL to 1 after the second upgrade, but I was now able to log in. Not sure how the first upgrade didn't add the tables, perhaps it didn't copy correctly. Glad I copied the files, not just ran the force upgrade, it would have probably been the same.

Thanks again!
Wizard
My WeBlog
Post Reply