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, Vincent
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.
Hi, 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?
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.
Hi, I got it to work with a workaround mentioned here http://bugtracker.ispconfig.org/index.php?do=details&task_id=860 Problem: In /usr/local/ispconfig/server/lib/mysql_clientdb.conf $clientdb_host is set as localhost Change localhost to your mysql server Problem: 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.
