[SOLVED]Admin login problems

snacktime · Post by **snacktime** » Mon 6. Dec 2004, 07:30

I checked all the obvious stuff. When I login, the system is logging me in, then immediately updating the database twice and marking me as not logged in. Sample database session below follows. Note that the main query checking the password succeeds.

SELECT * FROM phpwcms_user WHERE usr_login='admin' AND (usr_pass=PASSWORD('XXXXXXX') OR usr_pass='4e49a339
57c6e88cbf4b4fd280d07861') AND usr_aktiv=1
233 Query SELECT COUNT(*) FROM phpwcms_userlog WHERE logged_user='admin' AND logged_in=1
233 Query INSERT INTO phpwcms_userlog (logged_user, logged_username, logged_start, logged_change, logged_in, logged_
ip) VALUES ('admin', 'phpwcms webmaster', 1102314564, 1102314564, 1, '4.43.174.203')
233 Quit
234 Connect wcms@mailserver1.paymentonline.com on
234 Init DB wcms
234 Query UPDATE phpwcms_userlog SET logged_in = 0, logged_change = UNIX_TIMESTAMP( NOW( ) ) WHERE logged_in = 1 AND
( UNIX_TIMESTAMP( NOW( ) ) - logged_change ) > 1800
234 Query SELECT COUNT(*) FROM phpwcms_userlog WHERE logged_user='admin' AND logged_in=1
234 Quit
235 Connect wcms@mailserver1.paymentonline.com on
235 Init DB wcms
235 Query UPDATE phpwcms_userlog SET logged_in = 0, logged_change = UNIX_TIMESTAMP( NOW( ) ) WHERE logged_in = 1 AND
( UNIX_TIMESTAMP( NOW( ) ) - logged_change ) > 1800
235 Query SELECT logged_user FROM phpwcms_userlog WHERE logged_in=1
235 Quit
041205 22:22:01 177 Quit

snacktime · Post by **snacktime** » Mon 6. Dec 2004, 07:37

Found the problem. The time on the database server was different then on the webserver.

oldfolk · Post by **oldfolk** » Mon 6. Dec 2004, 15:33

Well how did you correct it? 'cause I'm pulling my hair out with this same issue. I've deleted and reloaded I don't know how many times and still the same problem