08 January 2016, 21:57

Hi all,

I am getting this error on the server:

Mahara could not connect to the application database.

* If you are using Mahara, please wait a minute and try again
* If you are the administrator, please check your database settings and make sure your database is available

The error received was:
mysqli error: [2003: Can't connect to MySQL server on 'xxx.xx.xx.xx' (13)] in CONNECT(xxx, 'xxx', '****', lxxxx)

i can connect to the database server from the application server .

From application server:

mysql -u username -p -h sqlserver

connects.

15 January 2016, 14:08

Hi Hanan,

There isn't much I can add about this one. Like the error message says, Mahara wasn't able to connect to the MySQL server. You should look in your config.php file and check that the connection settings there are correct.

It is odd that you were able to connect using the mysql command-line client, but that PHP was unable to connect. You might consider double-checking for instance the port that it's connecting on. Or you could write up a quick PHP test script to try connecting with the mysqli_connect() function, to try to pin down what's going on.

Cheers,

Aaron