Xibo

Can not log in after reset password

Asked by Paul

Hi,

I've reset the xibo_admin password as decribed with question #67078. Then I cleared the cache of my browser and restarted the browser again. Unfortunately, my new password does not work.

Anyway, I did a update of Xibo (1.6.1 -> 1.6.2) hoping that upgrading would solve the problem. It did not...

Any suggestions, besides installing the software again?

Question information

Language:
English Edit question
Status:
Solved
For:
Xibo Edit question
Assignee:
No assignee Edit question
Solved by:
Dan Garner
Solved:
Last query:
Last reply:
Revision history for this message
Dan Garner (dangarner) said : 		#1

Those instructions are a little old - try this statement instead:

UPDATE `user` set `UserPassword` = MD5('password') CSPRNG = 0 WHERE `UserID` = 1 LIMIT 1;

Revision history for this message
Paul (p-paul-0) said : 		#2

Hi Dan,

Thanks for your prompt response, but the statement returns a syntax error (You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'CSPRNG = 0 WHERE `UserID` = 1 LIMIT 1' at line 1;)

Revision history for this message
Best Dan Garner (dangarner) said : 		#3

sorry :)
missed a comma

UPDATE `user` set `UserPassword` = MD5('password'), CSPRNG = 0 WHERE `UserID` = 1 LIMIT 1;

Revision history for this message
Paul (p-paul-0) said : 		#4

Hi Dan,

I can log in again. Thank you very much for helping me out!!

Best regards,
Paul