Add second DNS Server 2017

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

root@ns2:~# 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>

 

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

 

Is there an issue with the packages I installed from the tutorial? Do they match with ispconfig 3.1 on ubuntu 16.04? I'm doing the tutorial exactly the way it says. It worked for ispconfig 3.0.5.4 but I'm having trouble with 3.1.

https://www.howtoforge.com/how-to-r...-secondary-with-ispconfig-3-debian-squeeze-p2

 

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

 

Thank you. It worked. I installed packages from https://www.howtoforge.com/tutorial...l-pureftpd-bind-postfix-doveot-and-ispconfig/

 

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

 

Isnt that already in the tutorials?

 

Yes but it is based from php5 ubuntu 16.04 is php7. So I updated the packages to ubuntu 16.04.