MySQL server on different host

Discussion in 'Installation/Configuration' started by vinbak, Feb 26, 2010.

  1. vinbak

    vinbak New Member

    Hi everybody,

    I have ISPconfig installed on a VPS and I'm able to access the admin section, but I have one problem,

    My MySQL server is on a different VPS. I have deselected the DB-server from the server settings, but now I am unable to add a new database to a website.

    How do I add my MySQL server as an available server from within ISPConfig?
    Should I add a new server IP?

    Thanks in advance,

  2. till

    till Super Moderator Staff Member ISPConfig Developer

    ISPConfig has to be installed on the dbserver as well. Install ispconfig on the database server in expert mode and choose to join the master server then.
  3. vinbak

    vinbak New Member


    I'm running a separate vps dedicated to MySQL. Do I really need to install the entire ISPConfig there as well?

    Can I not manual insert the server in ISPConfigs database?
  4. till

    till Super Moderator Staff Member ISPConfig Developer

    If you want to be able to add databases for clients in ispconfig, then yes.

    No, as the ispconfig server code and scripts must be installed and running on this server to enable ispconfi to add databases on it.
  5. vinbak

    vinbak New Member


    I got it to work with a workaround mentioned here

    In /usr/local/ispconfig/server/lib/mysql_clientdb.conf $clientdb_host is set as localhost

    Change localhost to your mysql server

    When creating a new database if remote access is disabled, new user is created with rights from localhost, but that is localhost to the db server, not ispconfig server

    I use a private ip to communicate with the mysql server, so I can enter it with remote access

    Creating databases from within ISPConfig and PHPMyAdmin now works.

Share This Page