Cannot add new server to multiserver system

Discussion in 'ISPConfig 3 Priority Support' started by muekno, Apr 3, 2019.

  1. muekno

    muekno Active Member HowtoForge Supporter

    Using lates ispconfig, tried to add server in expert mode. Steps
    Installed as usual debian 9 minimal server, followed then teh perfect server tutioal in combination the ispconfig manual, isnstall onlly web an postfix
    When installing ispconfig in expert mode I got the error "Unable to connect to mysql server Host 'servername.domain.de' is not allowed to connect to this MariaDB server"
    but
    root@servername:/tmp/ispconfig3_install/install# mysql -u root -p
    Enter password:
    Welcome to the MariaDB monitor. Commands end with ; or \g.
    Your MariaDB connection id is 1750
    Server version: 10.1.37-MariaDB-0+deb9u1 Debian 9.6

    Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

    Why does the install cannot connect, but the shell can using root as name and teh same password in both cases.
    thanks for any hint. mysql root password is the same on every server.

    Rainer
     
  2. till

    till Super Moderator Staff Member ISPConfig Developer

    You are using the wrong shell command for the test, you tested a connection to the local mysql database and not the master mysql server. To test a connection to the master server, the command is:

    mysql -h servername.domain.de -u root -p

    the result will be that you are not allowed to connect. Fix that (ensure that you added a mysal root user with permission to connect from the hostname and IP of the slave on the master server) and then start the ispconfig installation again.
     
  3. muekno

    muekno Active Member HowtoForge Supporter

    Thanks, Oh yes I forgot to add the permissions on the master database :-(
     

Share This Page