Xibo install Error Message = [SQLSTATE[HY000] [1045]

Hello all we I have been trying to setup xibo on our server for a couple of days now and cannot get past this error message " Could not connect to MySQL with the administrator details. Please check and try again. Error Message = [SQLSTATE[HY000] [1045] Access denied for user ‘root’@‘localhost’ (using password: YES)] " We went with a fresh install of xibo with the latest version 1.7.6 I believe php was already installed on the server and MS SQL Server Management Studio as well but I followed the instructions and installed the MySQL listed setup everything for MySQL with the instructions from the guide only thing changed was the port from 3306 to 3307 because another app is using port 3306 I proceeded to add xibo to IIS and got to http://localhost/xibo and got all checkmarks done then when I advance is when I am getting that issue I am creating a new DB and using the password I created for root during the MySQL setup which was just a standard word no numbers or special characters and I cannot advance past the database page.

Can you try connecting via a terminal with (make sure you are in the directory that contains mysql):

mysql -u root -p

If that does not work then the problem should be the mysql configuration.

Also, port 3006, it is not being used by another instance of mysql is it?

You need to tell Xibo about the custom port you’re running MySQL on

So where it asks for the hostname for the database server, you’ll enter localhost:3307

Thanks for the response how do I do the first step not really familiar with all this. and port 3306 was the default port for the SQL setup but it is being used by another application.

It’s asking me that in the install.php when creating the new database I just changed it and first I get this message “Could not create a new user with the administrator details. Please check and try again. Error Message = [SQLSTATE[42000]: Syntax error or access violation: 1064 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 ‘% IDENTIFIED BY ‘software’’ at line 1]”

not sure why i’m not creating a user just a new database. If I hit next again the message changes to

“Could not create a new database with the administrator details [root]. Please check and try again. Error Message = [SQLSTATE[HY000]: General error: 1007 Can’t create database ‘xibo57’; database exists]”

If you choose the option to create a new database, Xibo takes your administrative credentials, creates a new database and then creates a new user for itself to access that database.

It does that because connecting Xibo to your MySQL server as the admin user is a bad idea. If there were some bug in Xibo that allowed people to run arbritraty SQL code, then if it’s connected as an admin it can damage any database on that server. If it’s running as it’s own user then it limits that to the Xibo database directly and nothing else.

So it looks like it managed to create a database but failed after that.

If you know how to, you could try creating an empty database yourself, and a user for Xibo to use. You need to grant Xibo’s user full permission on that database only, and then when you go through the installer choose the option to use an existing database. You then fill in the database name, and username and password of the user you created.

Sorry for the late response don’t work on weekends and have no access to the server to try. When you say create a user for Xibo to use do you mean create a local windows user account? and grant full permission on that database only through the MySQL command line? since the version that was linked in the walkthrough is a non Gui based application.

I mean create a user in MySQL.

MySQL is a command line based interface. Depending on what you’ve installed you may have something like PHPMyAdmin installed which is a graphical interface to it.

Alternatively try running through the installer again and ensure you give a simple unique database name and your administrative credentials, and Xibo should do the rest for you.

Alternatively, there are companies out there, including the project sponsors, who host Xibo at very reasonable prices and avoid you having to do any of this setup yourself.

I am going to try that. Also as I stated before when installing the MySQL server I had to switch port on the install to port 3307 instead of 3306 which is the default how can I go about changing that for xibo as well? I changed it on the php manager (Php.ini file) for myPhpAdmin to work because it wasn’t letting me login with my root credentials until I switched the port to 3307? I don’t seem to find where to configure it at and I have a feeling this could be the potential reason as to why it is not working since I connect to it just fine with phpmyadmin using root and the password I created.

As I explained in my previous reply, you need to change the mysql server host name from ‘localhost’ to ‘localhost:3307’ in the Xibo install wizard. Reconfiguring other applications that use PHP won’t affect Xibo

Try this on your webserver :

  1. Down the httpd service # service httpd stop
  2. setsebool httpd_can_network_connect 1

  3. setsebool httpd_can_network_connect_db 1

  4. Up the httpd service # service httpd start

It work’s fine for me when i got this error.

1 Like