Administator no longer with company and forgot password.

Asked by Becky Butler

Our administrator for Xibo is no longer with our company. Before he left he deleted all his file for our company. He doesn't remember his password to get me logged in. How can I log in and change the admin info?

Question information

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

You would need database access to do this.

Once you get that - you can run the following queries:

For 1.4 Series:

UPDATE `user` SET password = MD5('new_pass') WHERE username = 'xibo_admin'
LIMIT 1;

For 1.6 Series:

UPDATE `user` SET password = MD5('new_pass'), CSPRNG = 0 WHERE username =
'xibo_admin' LIMIT 1;

Your password will then be "new_pass".

Revision history for this message
Becky Butler (becky-butler) said :
#2

Thanks Dan!

Becky Butler
Administrative Assistant / Receptionist
Measurement Specialties, Inc.
2670 Indian Ripple Road
Dayton, OH 45440
Direct (937)427-1231 Ext. 4458
<email address hidden>
www.meas-spec.com

-----Original Message-----
From: <email address hidden> [mailto:<email address hidden>] On Behalf Of Dan Garner
Sent: Wednesday, July 23, 2014 5:32 AM
To: Butler, Becky
Subject: Re: [Question #252020]: Administator no longer with company and forgot password.

Your question #252020 on Xibo changed:
https://answers.launchpad.net/xibo/+question/252020

    Status: Open => Answered

Dan Garner proposed the following answer:
You would need database access to do this.

Once you get that - you can run the following queries:

For 1.4 Series:

UPDATE `user` SET password = MD5('new_pass') WHERE username = 'xibo_admin'
LIMIT 1;

For 1.6 Series:

UPDATE `user` SET password = MD5('new_pass'), CSPRNG = 0 WHERE username = 'xibo_admin' LIMIT 1;

Your password will then be "new_pass".

--
If this answers your question, please go to the following page to let us know that it is solved:
https://answers.launchpad.net/xibo/+question/252020/+confirm?answer_id=0

If you still need help, you can reply to this email or go to the following page to enter your feedback:
https://answers.launchpad.net/xibo/+question/252020

You received this question notification because you asked the question.

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

Great. Marking as solved.