Problems setting external database enroll/authentication

Re: Problems setting external database enroll/authentication

by Alex Legg -
Number of replies: 0
Hey,

Thanks for the response.

Below is the error I receive when testing the external database authentication.

Warning: mysqli_real_connect(): (HY000/2003): Can't connect to MySQL server on '46.101.0.124' (110) in /var/www/moodle/lib/adodb/drivers/adodb-mysqli.inc.php on line 113
Could't connect :
46.101.0.124: Can't connect to MySQL server on '46.101.0.124' (110)

In the external database authentication plugin settings I entered:
I set the Host to the external server public IP address.
        the Database to mysqli (on the external I use MySQL).
        Use sybase quotes to No
        The rest are obvious...

And on the external server I modified the mysql.conf.d:
         I commented out bind-address and skip-networking.

Lastly, on the external database in MySQL, I granted a user permissions with the IP address of my Moodle site.

Apparently it may be a php driver issue?