cannot login anymore to my admin interface

Found a bug? Tell us!!
Post Reply
Sander
Posts: 3
Joined: Wed May 24, 2006 9:16 am

cannot login anymore to my admin interface

Post by Sander »

Hello,

I have been using serendipity now for 2 months I think. I am using 1.0-beta2 (upgraded just now to 1.0-beta3 to see if that fixed the problem but it didnt). And I cannot login anymore on the admin interface.

At first I thought I just was so stupid to forget my password, but I resetted it and it doesnt work still.

When I login I get no error about a password what so ever and just return to the loginpage again.

I have resetted my password using mysql commandline interface using UPDATE serendipity_authors set password = md5('testpass');

I have changed the fullname of my user to the username of the user.

but all that didnt work. I have tried to add another user with admin rights by entering the line in the database but I couldnt login to that user either.

I have thought, maybe its internet explorer, but from 2 different computers with low restrictions it both didnt work. I even installed firefox to see if it was internet explorer, but the same thing happens there.

restarting apache didnt do the trick either.

Is there any way I can get my admin page back?

Any help would be greatly apreciated
garvinhicking
Core Developer
Posts: 30022
Joined: Tue Sep 16, 2003 9:45 pm
Location: Cologne, Germany
Contact:

Re: cannot login anymore to my admin interface

Post by garvinhicking »

Hi!

Is it possible that your Webserver environment changed, maybe that your PHP version was upgraded to 4.3.10 or any other buggy version?

When did the login stop working? You really don't see a "Password or username wrong" message on the login screen?

You could try to patch the s9y login process to see what's going on. Edit your include/functions_config.inc.php file and search for the function serendipity_login().

In the first line of that function, after "global $serendipity;" add this:

Code: Select all

echo "Login process called...<br />\n";
Then search for the serendipity_authenticate_author() function. There you should see a line like this:

Code: Select all

        $query = "SELECT DISTINCT
                    email, authorid, userlevel, right_publish
                  FROM
                    {$serendipity['dbPrefix']}authors
                  WHERE
                    username   = '" . serendipity_db_escape_string($username) . "'
                  AND password = '" . serendipity_db_escape_string($password) . "'";
        $row = serendipity_db_query($query, true, 'assoc');
After that line, add this:

Code: Select all

echo $query . " -- <br />\nRESULT: " . print_R($row, true) . "<br />\n";
And then see what the output is when you login.

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/
Sander
Posts: 3
Joined: Wed May 24, 2006 9:16 am

Post by Sander »

Thank you for your response

I dont login daily on my blog, and I do remember making some changes to the php.ini. Those were only to set the upload size larger then the standard value.

phpinfo returned PHP Version 4.3.10-16
This version came with apt-get. I am using debian sarge. I didnt change that version any time lately

The info you wanted me to enter returned this:

Code: Select all

Login process called...<br />
<br />
<b>Warning</b>:  Cannot modify header information - headers already sent by (output started at /var/www/blog/include/functions_config.inc.php:322) in <b>/var/www/blog/serendipity_admin.php</b> on line <b>11</b><br />
Login process called...<br />
I do remember I had a powersurge two weeks back. Is there a way to check the mysql database tables?

I ran apt-get today to see if there were any updates, and there was a mysql 4.1 update. Didnt change anything either :(


EDIT: changed the values I modified for an uploader tool back to the original ones (max_postsize max_upload_filesize and max_processmemory if I recall them correctly by head) and I do get some error that the pass is wrong now

your edits did show me what to set as a temppass in the database

thnx heaps, got it fixed now. I am logged in :)
garvinhicking
Core Developer
Posts: 30022
Joined: Tue Sep 16, 2003 9:45 pm
Location: Cologne, Germany
Contact:

Post by garvinhicking »

Hi!

Okay, great to know that. Even though in fact I don't know what went on here. ;)

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/
Sander
Posts: 3
Joined: Wed May 24, 2006 9:16 am

Post by Sander »

me neither

I have no clue why login would fail if I creased the max memory and upload size. But it got fixed :)
Post Reply