Adding more servers to Multi server set up

Discussion in 'ISPConfig 3 Priority Support' started by abintipl, Jul 5, 2013.

  1. abintipl

    abintipl Member

    Hi,

    I have latest Ispconfig on Debian 6 with OpenVz Multi Server set-up & it's running fine.

    My Initial set up is One one Dedicated server with six vps & are used as under;

    NS - 2
    Web - 3
    DB - one

    Since I have extra VPS and trying to add more vps to the existing set-up by adding oneMail as well as 3 more web servers.

    I have followed same Instructions but when during the set up of Mail or web servers I get an ERROR

    Unable to connect

    I am giving correct root password

    Please advice

    Further, do I need to stop any services before adding more servers

    Thanks & regards,

    Abin
     
  2. till

    till Super Moderator Staff Member ISPConfig Developer

    This means that mysql on the master is not reachable from this server. Possible reasons are:

    - no new root user for IP and hostname of the slave was added in the master
    - mysql not restarted or flush privileges not executed after adding the user
    - Firewall problems


    No.
     
  3. abintipl

    abintipl Member

    Dear Sir,

    Thank you so much for your prompt reply.

    After restarting mysql, I could able to connect.

    While the installation was in progress, by mistake had to stop the installation when I was on below step

    >> Initial configuration

    Operating System: Debian 6.0 (Squeeze/Sid) or compatible

    Shall this server join an existing ISPConfig multiserver setup (y,n) [n]: y

    MySQL master server hostname []: webmain.mydomain.com

    MySQL master server root username [root]:

    MySQL master server root password []: Server Password

    MySQL master server database name [dbispconfig]:

    ERROR: Stopped: Database already contains some tables.

    If I run Update then get this Error

    >> Update

    Operating System: Debian 6.0 (Squeeze/Sid) or compatible

    PHP Warning: include_once(/usr/local/ispconfig/server/lib/config.inc.php): failed to open stream: No such file or directory in /tmp/ispconfig3_install/install/ update.php on line 75
    PHP Warning: include_once(): Failed opening '/usr/local/ispconfig/server/lib/config.inc.php' for inclusion (include_path='.:/usr/share/php:/usr/share/pear') in
    /tmp/ispconfig3_install/install/update.php on line 75
    PHP Notice: Undefined variable: conf in /tmp/ispconfig3_install/install/update.php on line 76

    My Question is

    Which table/record I should remove from Main Server(webmain)DB of "dbispconfig" to solve

    ERROR: Stopped: Database already contains some tables.

    How to so I run & complete mail server set up

    Thanks & regards,

    Abin
     
  4. till

    till Super Moderator Staff Member ISPConfig Developer

    The error is not about the master server, the error means that there is already a local ispconfig installation and database. Run the uninstall.php script on the new slave server to remove ispconfig and the use the install.php script to install it again.
     
  5. abintipl

    abintipl Member

    Sir,

    Thank you for your reply.

    If I run php -q uninstall.php

    Output is as under;

    >> Uninstall

    PHP Warning: require(/usr/local/ispconfig/server/lib/config.inc.php): failed to
    open stream: No such file or directory in /tmp/ispconfig3_install/install/unins
    tall.php on line 50
    PHP Fatal error: require(): Failed opening required '/usr/local/ispconfig/serve
    r/lib/config.inc.php' (include_path='.:/usr/share/php:/usr/share/pear') in /tmp/
    ispconfig3_install/install/uninstall.php on line 50
    root@mail:/tmp/ispconfig3_install/install#

    If I run php -q install.php then the output;

    ..............

    Shall this server join an existing ISPConfig multiserver setup (y,n) [n]: y

    MySQL master server hostname []: webpanel.mydomian.com

    MySQL master server root username [root]:

    MySQL master server root password []: Password

    MySQL master server database name [dbispconfig]:

    ERROR: Stopped: Database already contains some tables.

    Thank you in advance for your help.

    Regards,

    Abin
     
  6. till

    till Super Moderator Staff Member ISPConfig Developer

    Ok, the unistaller does not work as the installer was interrupted after creating the db but before he could write the config file. Please delete the dbispconfig database on the slave server, with phpmyadmin or the mysql commandline tool. As alternative you can do this (as it is a myisam table) as quick and dirty method:

    /etc/init.d/mysql stop
    rm -rf /var/lib/mysql/dbispconfig
    /etc/init.d/mysql start

    and then try the install again.
     
  7. abintipl

    abintipl Member

    Thank you so much!

    It worked for me to complete my Mail server( slave) installation

    When I checked my Master Server, I could see earlier Mail server Record for which installation got interrupted under System>Server

    I deleted this old record from Main Server

    Thank you so much for your help

    warm regards,

    Abin
     

Share This Page