External Database

Discussion in 'Installation/Configuration' started by ChildOTK, Nov 7, 2019.

  1. ChildOTK

    ChildOTK New Member

    Hello all,

    I just setup a brand new server on Amazon AWS along with a MySQL RDS instance. Communication between the EC2 instance and the RDS instance are working properly. To confirm this I've done a telnet to the endpoint hostname on port 3306 and gotten a successful connection.

    I've installed ISPConfig on a Ubuntu Server 18.04 instance, this went through just fine. I used the RDS instance endpoint hostname and credentials when configuring the database information during the ISPConfig installation process.

    I am trying to login to ISPConfig but the page takes some time and then stops loading and just remains blank. Looking at the apache error log I am seeing some errors that essentially tells me that ISPConfig is trying to login to the local MySQL server instead of the remote RDS instance.

    For example:

    mod_fcgid: stderr: PHP Warning: mysqli_real_connect(): (HY000/1045): Access denied for user 'ispconfig'@'172.30.0.201' (using password: YES) in /usr/local/ispconfig/interface/lib/classes/db_mysql.inc.php on line 91

    172.30.0.201 is the private IP of the EC2 instance.

    I have checked various configuration files in /usr/local/ispconfig/interface/lib and /usr/local/ispconfig/server/lib, and both configuration files have the right database information setup for the RDS instance, but for some reason the interface is still trying to use the local MySQL server.

    The goal is to use the RDS instance for absolutely everything instead of the local MySQL server.

    Why is ISPConfig still trying to use localhost even though the configuration files are setup correctly?

    Any help with this is appreciated!
     
  2. till

    till Super Moderator Staff Member ISPConfig Developer

    If I interpret the error message correctly, then the connection is not to a mysql instance on the local server, it is from your server to another system. The message means a user named ispconfig from IP 172.30.0.201 tried to connect to a system and that failed. Test the connection from your server to the database instance with mysql command:

    mysql -h hostnameofmysqlserver -u ispconfig -p
     

Share This Page