Xibo has database connection problem - MySQL password expired

Get Help
1

Running MySQL Server 5.7 with Xibo Server 1.4.1

All of a sudden our MySQL passwords expired, and I’m receiving the following event log message - "Your password has expired. To log in you must change it using a client that supports expired passwords."
I installed MySQL Workbench and was able to successfully change the root password with no issues. Looking further, Xibo is actually using the xibo user account to connect to the database. I had in my setup notes the username and password were both xibo. I attempted to create a SQL connection in MySQL Workbench using the xibo account, and received password errors. When attempting to change that password to xibo, I kept receiving additional errors about that password not being correct.

I need to know how to either unexpire the xibo user account, or change the xibo user password within the Xibo php settings so we can get our production environment back online. I did revert back to a snapshot, so currently our root password is only back online with the same password.

I need this resolved as soon as possible. Thanks in advance.

2

That’s a version from 2012, we’d highly recommend upgrade to 1.7.9

You should be able to upgrade it directly to 1.7 series, although you might consider updating to 1.6 first and then to 1.7.9.

3

Peter, thank you for the reply. I will be looking to upgrade very soon however need to get my current Xibo system back online first prior to making additional changes. Let me know what we can do to get our current environment back online with the above issues. Thank you

4

Making changes to MySQL user accounts is covered fairly extensively on Google - I won’t try to reproduce that content here as I am certain others have done a better job (perhaps?).

The user/password that Xibo uses is stored in the settings.php, which I believe was in the root of the installation folder in 1.4. You can open this in any text editor to find the account and change the password accordingly.

I hope that helps.

5

The following might be interesting to you…

6

I got it working now. Thank you all very much for the assistance.

7

Would you mind posting what you did to resolve it - to save the next person having to figure that out for themselves?

8

The easiest method:

  1. Install MySQL Workbench on the server. Any version will work.
  2. Locate the current xibo db_username and password in the C:\inetpub\wwwroot\xibo\settings.php file
  3. Log into the xibo database using the Xibo db_user credentials. There are two different accounts - the main root account, and a xibo user that Xibo uses to connect back to the database.
  4. It will prompt you to change the expired password.
  5. In my case I just set the new password the exact same as the old, however if it’s changed make sure you update the settings.php file.
2 Likes