Page 1 of 2
You appear to have entered an invalid username or password
Posted: Thu May 06, 2010 7:46 pm
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.
Re: You appear to have entered an invalid username or password
Posted: Thu May 06, 2010 8:42 pm
by kleinerChemiker
Re: You appear to have entered an invalid username or password
Posted: Fri May 07, 2010 9:41 am
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
Re: You appear to have entered an invalid username or password
Posted: Fri May 14, 2010 9:14 am
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
Re: You appear to have entered an invalid username or password
Posted: Fri May 14, 2010 9:57 am
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
Re: You appear to have entered an invalid username or password
Posted: Fri May 14, 2010 10:14 am
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?
Re: You appear to have entered an invalid username or password
Posted: Fri May 14, 2010 10:18 am
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
Re: You appear to have entered an invalid username or password
Posted: Fri May 14, 2010 10:41 am
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
Re: You appear to have entered an invalid username or password
Posted: Fri May 14, 2010 10:53 am
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
Re: You appear to have entered an invalid username or password
Posted: Fri May 14, 2010 11:23 am
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
Re: You appear to have entered an invalid username or password
Posted: Fri May 14, 2010 2:38 pm
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
Re: You appear to have entered an invalid username or password
Posted: Fri May 14, 2010 3:01 pm
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!
Re: You appear to have entered an invalid username or password
Posted: Fri May 14, 2010 3:05 pm
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
Re: You appear to have entered an invalid username or password
Posted: Fri May 14, 2010 4:44 pm
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
Re: You appear to have entered an invalid username or password
Posted: Fri May 14, 2010 5:31 pm
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.