Xibo

HELP! someone change the xibo_admin user name

Asked by Scott wiltshire

Need some help big time guys.
One of my staff thought it was a great idea to rename the xibo_admin account to just admin, in xibo
Problem is I can not log in to Xibo at all now, I have tried look at some answers here with MySql and such and bascilly nothing works, each time i get, wrong username or password.
Any idea's now how I can get my xibo_admin log in back?
The change was made inside of Xibo uder the user parts, from what I understand he simply just deleted the xibo_ part out of the username and saved it.
I really do not want to reinstall and I have everything set up perfectly right now.
Im running on Ubuntu 11.10 and everything was working oerfectly before this mess up.

Cheers

Question information

Language:
English Edit question
Status:
Answered
For:
Xibo Edit question
Assignee:
No assignee Edit question
Last query:
Last reply:
Revision history for this message
Alex Harrington (alexharrington) said : 		#1

Are you comfortable using the MySQL command line?

If so, can you connect to your database and run the following SQL:

UPDATE user SET UserName = 'xibo_admin' where UserID = 1;

It's really important you don't rename the xibo_admin account otherwise you won't be able to do an upgrade.

Alex

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

The actual name of the user account will not effect logging in (assuming you are using the new name of "admin"). Your colleague probably changed the password too (by accident perhaps?!).

We can enhance Alex's SQL a little bit to recover the password too.

UPDATE `user` SET UserName = 'xibo_admin', UserPassword = MD5('newpassword') where UserID = 1;

Can you help with this problem?

Provide an answer of your own, or ask Scott wiltshire for more information if necessary.

To post a message you must log in.