Add second DNS Server 2017

Discussion in 'Installation/Configuration' started by zustudios, Jan 14, 2017.

  1. zustudios

    zustudios Member

    I did the command on the second server and I got:

    [email protected]:~# mysql -h ns1.sitetopic.com -u root -p Enter password:
    Welcome to the MySQL monitor. Commands end with ; or \g.
    Your MySQL connection id is 9916
    Server version: 5.5.5-10.0.28-MariaDB-0ubuntu0.16.04.1 Ubuntu 16.04

    Copyright (c) 2000, 2016, Oracle and/or its affiliates. All rights reserved.

    Oracle is a registered trademark of Oracle Corporation and/or its
    affiliates. Other names may be trademarks of their respective
    owners.

    Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

    mysql>
     
  2. till

    till Super Moderator Staff Member ISPConfig Developer

    Ok, fine, so the connection is fixed now. The next step is to install ispconfig on the slave server. If you installed ispconfig already, then uninstall it and then install it again.
     
  3. zustudios

    zustudios Member

    I got :

    MySQL master server database name [dbispconfig]:

    Wrong SQL-mode. You should use NO_ENGINE_SUBSTITUTION. Add

    sql-mode="NO_ENGINE_SUBSTITUTION"

    to the mysqld-section in your mysql-config and restart mysqld afterwards
     
  4. zustudios

    zustudios Member

  5. zustudios

    zustudios Member

    I tried with mariadb and I got:

    PHP Fatal error: Uncaught Error: Call to undefined function mb_detect_encoding() in /tmp/ispconfig3_install/install/lib/mysql.lib.php:445
    Stack trace:
    #0 /tmp/ispconfig3_install/install/lib/mysql.lib.php(146): db->escape('dbispconfig')
    #1 /tmp/ispconfig3_install/install/lib/mysql.lib.php(228): db->_build_query_string('CREATE DATABASE...', 'dbispconfig', 'utf8')
    #2 /tmp/ispconfig3_install/install/lib/mysql.lib.php(267): db->_query('CREATE DATABASE...', 'dbispconfig', 'utf8')
    #3 /tmp/ispconfig3_install/install/lib/installer_base.lib.php(237): db->query('CREATE DATABASE...', 'dbispconfig', 'utf8')
    #4 /tmp/ispconfig3_install/install/install.php(290): installer_base->configure_database()
    #5 {main}
    thrown in /tmp/ispconfig3_install/install/lib/mysql.lib.php on line 445
     
  6. till

    till Super Moderator Staff Member ISPConfig Developer

    You missed to install the php mbstring extension.
     
  7. zustudios

    zustudios Member

    Last edited: Jan 24, 2017
  8. zustudios

    zustudios Member

    I don't know if this helps but this is my update to the tutorial. What do you think?

    https://www.howtoforge.com/tutorial/ubuntu-minimal-server-install/
    https://www.howtoforge.com/tutorial...l-pureftpd-bind-postfix-doveot-and-ispconfig/
    https://www.howtoforge.com/how-to-r...and-secondary-with-ispconfig-3-debian-squeeze




    Setting Up server1.example.com (Primary DNS)
    #mysql -u root -p


    CREATE USER 'root'@'1.2.3.4' IDENTIFIED BY 'your password';
    GRANT ALL PRIVILEGES ON * . * TO 'root'@'1.2.3.4' IDENTIFIED BY 'your password' WITH GRANT OPTION MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0 ;

    CREATE USER 'root'@'server2.example.com' IDENTIFIED BY 'your password';
    GRANT ALL PRIVILEGES ON * . * TO 'root'@'sever2.example.com' IDENTIFIED BY 'your password' WITH GRANT OPTION MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0 ;


    FLUSH PRIVILEGES;

    quit;




    #cd /tmp
    wget -O ispconfig.tar.gz https://git.ispconfig.org/ispconfig/ispconfig3/repository/archive.tar.gz?ref=stable-3.1
    tar xfz ispconfig.tar.gz
    cd ispconfig3*/install/

    #php -q install.php



    Setting Up server2.example.com (Secondary DNS)
    #apt-get -y install ntp ntpdate
    #apt-get install -y mariadb-client mariadb-server
    #apt-get -y install php7.0 php7.0-cli php7.0-mysql php7.0-mcrypt mcrypt php7.0-mbstring
    #apt-get -y install bind9 dnsutils
    #cd /tmp
    wget -O ispconfig.tar.gz https://git.ispconfig.org/ispconfig/ispconfig3/repository/archive.tar.gz?ref=stable-3.1
    tar xfz ispconfig.tar.gz
    cd ispconfig3*/install/

    #php -q install.php
     
  9. Tuumke

    Tuumke Member

    Isnt that already in the tutorials? :)
     
  10. zustudios

    zustudios Member

    Yes but it is based from php5 ubuntu 16.04 is php7. So I updated the packages to ubuntu 16.04.
     
    till and Tuumke like this.

Share This Page