You appear to have entered an invalid username or password

Having trouble installing serendipity?
mrprofit
Posts: 2
Joined: Tue Feb 10, 2009 2:28 pm

You appear to have entered an invalid username or password

Post by mrprofit »

You appear to have entered an invalid user name or password

I have tried all of your blog remedies, but nothing seems to work.

The site has been up since 1.41 working fine until a week ago. Now I can't login to the admin any more need help.
garvinhicking
Core Developer
Posts: 30022
Joined: Tue Sep 16, 2003 9:45 pm
Location: Cologne, Germany
Contact:

Re: You appear to have entered an invalid username or password

Post by garvinhicking »

Hi!

Maybe your server got hacked, the database is corruppted or something like that, did you check via FTP for recently modified files?

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/
accampbell
Regular
Posts: 138
Joined: Fri Jun 09, 2006 8:59 pm
Location: London, UK
Contact:

Re: You appear to have entered an invalid username or password

Post by accampbell »

I am getting the same problem. I had to reinstall, using 1.5.3. The site is visible but I can't login to administer it. I've reinstalled Serendipity a second time but the same thing happens.

I also tried resetting the password in the database but no luck
Anthony Campbell
garvinhicking
Core Developer
Posts: 30022
Joined: Tue Sep 16, 2003 9:45 pm
Location: Cologne, Germany
Contact:

Re: You appear to have entered an invalid username or password

Post by garvinhicking »

Hi!

Serendipity 1.5 has a new method of saving/storing passwords. How did you reset the password?

You can enter a md5'd password into the serendipity_authors DB table, but you must also set hashtype=0. If hashtype is not set to 0 it means that sha1 is used instead of md5.

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/
accampbell
Regular
Posts: 138
Joined: Fri Jun 09, 2006 8:59 pm
Location: London, UK
Contact:

Re: You appear to have entered an invalid username or password

Post by accampbell »

garvinhicking wrote:Hi!

Serendipity 1.5 has a new method of saving/storing passwords. How did you reset the password?

You can enter a md5'd password into the serendipity_authors DB table, but you must also set hashtype=0. If hashtype is not set to 0 it means that sha1 is used instead of md5.

Regards,
Garvin
I typed the password as usual during installation. When it didn't work I went to the mysql database and typed the password there, after which I converted it to md5. This may be all wrong - I know very little about mysql.

I'm sorry; I don't know what the serendipity authors DB table is or how to do what you suggest. Is it in serendipity or mysql?
Anthony Campbell
garvinhicking
Core Developer
Posts: 30022
Joined: Tue Sep 16, 2003 9:45 pm
Location: Cologne, Germany
Contact:

Re: You appear to have entered an invalid username or password

Post by garvinhicking »

Hi!

When you install serendipity over an existing installation ,it does not modify any passwords. An installation is only properly executed when done to a fresh database.
I typed the password as usual during installation. When it didn't work I went to the mysql database and typed the password there, after which I converted it to md5. This may be all wrong - I know very little about mysql.
It seems to me you performed an installation over an existing one, so in that case the old "hashtype" column will still be set to "1". Go to the serendipity_authors DB tabel again and set the password to your md5 value AND set hashtype = 0.

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/
accampbell
Regular
Posts: 138
Joined: Fri Jun 09, 2006 8:59 pm
Location: London, UK
Contact:

Re: You appear to have entered an invalid username or password

Post by accampbell »

garvinhicking wrote:Hi!

garvinhicking wrote:Hi!

When you install serendipity over an existing installation ,it does not modify any passwords. An installation is only properly executed when done to a fresh database.
I typed the password as usual during installation. When it didn't work I went to the mysql database and typed the password there, after which I converted it to md5. This may be all wrong - I know very little about mysql.
It seems to me you performed an installation over an existing one, so in that case the old "hashtype" column will still be set to "1". Go to the serendipity_authors DB tabel again and set the password to your md5 value AND set hashtype = 0.

HTH,
Garvin
I
Last edited by accampbell on Fri May 14, 2010 5:32 pm, edited 2 times in total.
Anthony Campbell
garvinhicking
Core Developer
Posts: 30022
Joined: Tue Sep 16, 2003 9:45 pm
Location: Cologne, Germany
Contact:

Re: You appear to have entered an invalid username or password

Post by garvinhicking »

Hi!

When you maintain your serendipity_authors database table, you should see those columns:

realname, username, password, authorid, mail_comments, mail_trackbacks, email, userlevel, right_publish, hashtype

When you edit a row, the dropdown next to "password" will be set to MD5, and next to the dropdown you enter your password. Now, BELOW the password you should see the input box for "hashtype", and this is where you enter "0" instead of "1" which would currently be there...

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/
accampbell
Regular
Posts: 138
Joined: Fri Jun 09, 2006 8:59 pm
Location: London, UK
Contact:

Re: You appear to have entered an invalid username or password

Post by accampbell »

garvinhicking wrote:Hi!

When you maintain your serendipity_authors database table, you should see those columns:

realname, username, password, authorid, mail_comments, mail_trackbacks, email, userlevel, right_publish, hashtype

When you edit a row, the dropdown next to "password" will be set to MD5, and next to the dropdown you enter your password. Now, BELOW the password you should see the input box for "hashtype", and this is where you enter "0" instead of "1" which would currently be there...

Regards,
Garvin
My setup is different.
1. I don't have "hashtype" after "rightpublish"; there is a dropdown menu offering md5 among other choices.
2. Idon't have "hashtype" in the password menu. I only have "md5" and "sha1"

This is the setup on my server:
Generated by: phpMyAdmin 2.9.1.1-Debian-10 / MySQL 5.0.32-Debian_7etch3
Anthony Campbell
garvinhicking
Core Developer
Posts: 30022
Joined: Tue Sep 16, 2003 9:45 pm
Location: Cologne, Germany
Contact:

Re: You appear to have entered an invalid username or password

Post by garvinhicking »

Hi!

If you don't have a "hashtype" column this means you did not properly upgrade your serendipity installation. From which version did you upgrade from? In any case, your upgrade did NOT perform the necessary database upgrades.

In the FAQ on www.s9y.org you can see a pointer on how to re-execute an upgrade properly.

The "hashtype" column was added in serendipity 1.5.0...

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/
accampbell
Regular
Posts: 138
Joined: Fri Jun 09, 2006 8:59 pm
Location: London, UK
Contact:

Re: You appear to have entered an invalid username or password

Post by accampbell »

garvinhicking wrote:Hi!

If you don't have a "hashtype" column this means you did not properly upgrade your serendipity installation. From which version did you upgrade from? In any case, your upgrade did NOT perform the necessary database upgrades.

In the FAQ on http://www.s9y.org you can see a pointer on how to re-execute an upgrade properly.

The "hashtype" column was added in serendipity 1.5.0...

Regards,
Garvin
I upgraded from 1.5.2 hecause something went wrong with my website. I deleted all the serendipity files from the server and uploaded those from 1.5.3. I thought this meant I was starting over from fresh but apparently not. Is there no way to do that?

I really don't know what to do now. I've read the docoumentation but it doesn't seem to address my problem. Could I downgrade to an earlier version of Serendipity and get things working again? Otherwise it looks as if my blog is dead!
Anthony Campbell
garvinhicking
Core Developer
Posts: 30022
Joined: Tue Sep 16, 2003 9:45 pm
Location: Cologne, Germany
Contact:

Re: You appear to have entered an invalid username or password

Post by garvinhicking »

Hi!

Then your 1.5.2 upgrade was faulty already! If you're missing the column, it's missing for quite some time, because in 1.5 the column was introduced.

By deleting only the files and not the database, you made it so that serendipity still does not properly upgrade your database strcuture.

According to the FAQ on www.s9y.org (http://www.s9y.org/11.html#A20), you should now edit your serendipity_config_local.inc.php file, set the "versionInstalled" string to "1.4" for example, and then save the file. Now when you go to your s9y panel, it should re-excute the upgrade procedure (and add the 'hashtype' column properly).

This situation should be resolvable soon, we're almost there. :-)

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/
accampbell
Regular
Posts: 138
Joined: Fri Jun 09, 2006 8:59 pm
Location: London, UK
Contact:

Re: You appear to have entered an invalid username or password

Post by accampbell »

garvinhicking wrote:Hi!

Then your 1.5.2 upgrade was faulty already! If you're missing the column, it's missing for quite some time, because in 1.5 the column was introduced.

By deleting only the files and not the database, you made it so that serendipity still does not properly upgrade your database strcuture.

According to the FAQ on http://www.s9y.org (http://www.s9y.org/11.html#A20), you should now edit your serendipity_config_local.inc.php file, set the "versionInstalled" string to "1.4" for example, and then save the file. Now when you go to your s9y panel, it should re-excute the upgrade procedure (and add the 'hashtype' column properly).

This situation should be resolvable soon, we're almost there. :-)

Regards,
Garvin
Last edited by accampbell on Fri May 14, 2010 5:33 pm, edited 1 time in total.
Anthony Campbell
accampbell
Regular
Posts: 138
Joined: Fri Jun 09, 2006 8:59 pm
Location: London, UK
Contact:

Re: You appear to have entered an invalid username or password

Post by accampbell »

accampbell wrote:
garvinhicking wrote:Hi!

Then your 1.5.2 upgrade was faulty already! If you're missing the column, it's missing for quite some time, because in 1.5 the column was introduced.

By deleting only the files and not the database, you made it so that serendipity still does not properly upgrade your database strcuture.

According to the FAQ on http://www.s9y.org (http://www.s9y.org/11.html#A20), you should now edit your serendipity_config_local.inc.php file, set the "versionInstalled" string to "1.4" for example, and then save the file. Now when you go to your s9y panel, it should re-excute the upgrade procedure (and add the 'hashtype' column properly).

This situation should be resolvable soon, we're almost there. :-)

Regards,
Garvin
OK, finally IT WORKS!! Many thanks for all your trouble, Gavin, and once again apologies for slowness in uptake.
Anthony Campbell
Post Reply