Page 1 of 1

cannot login anymore to my admin interface

Posted: Wed May 24, 2006 9:32 am
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

Re: cannot login anymore to my admin interface

Posted: Wed May 24, 2006 1:52 pm
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

Posted: Wed May 24, 2006 2:49 pm
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 :)

Posted: Wed May 24, 2006 3:20 pm
by garvinhicking
Hi!

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

Regards,
Garvin

Posted: Wed May 24, 2006 3:59 pm
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 :)