Install ISPConfig multiserver - Postfix - MariaDB

Hi soulmates of the ISPConfig community,
Currently, I have running several servers but want to change to 1 web- server, 1 mail server and 1 MariaDB server.
Also, I want to expand to other regions with the webserver and the MariaDB server, but that is for later. First getting this ready in the Sâo Paulo region.
I have my servers on AMAZON and they have an already installed MariaDB server, but I think that I should build another instance with MariaDB.

I need to know how to get these servers working together from the web server where I have installed ISPConfig server. I found some pieces here and there but still have some questions before I start. These Amazon instances are expensive.

Kind regards,

EckyBrazzz

 

Well, I followed the guide but got stuck on the part that you have to add the other server mysqladmin. I did it from the shell, but I first installed ISPCONG and used de dbispconfig to add the other servers. What is the correct db to use ?

Code:

root@cpanel:~# mysql -u root -p
Enter password:
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 37
Server version: 10.0.29-MariaDB-0ubuntu0.16.04.1 Ubuntu 16.04

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

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

MariaDB [(none)]> show databases;
Current database: *** NONE ***

+--------------------+
| Database           |
+--------------------+
| dbispconfig        |
| information_schema |
| mysql              |
| performance_schema |
| phpmyadmin         |
+--------------------+
5 rows in set (0.00 sec)

MariaDB [(none)]> use dbispconfig
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
MariaDB [dbispconfig]> CREATE USER 'root'@'34.3xxxxxxxxxxx' IDENTIFIED BY 'YCxXXXXXXXXXXXXXYm3';
Query OK, 0 rows affected (0.00 sec)

MariaDB [dbispconfig]> GRANT ALL PRIVILEGES ON * . * TO 'root'@'34.xxxxxxxxxxxxx IDENTIFIED BY 'YXXXXXXXXXXXXXYm3'
    -> WITH GRANT OPTION MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0
    -> MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0 ;
Query OK, 0 rows affected (0.00 sec)

 

you have to create the root-users for other servers in the db mysql and not in dbispconfg. You can also read https://www.howtoforge.com/tutorial...abase-cluster-on-debian-8.4-with-ispconfig-3/ how to update the mysql-tables.

 

I have followed the guide but afterwards i am unable to get the servers into the main server. I don´t know what I did wrong.


And


Thanks for looking into it.

 

Gona try it, just 2 seconds before your response I deleted the servers...... :-(

 

Well, didn't work out. Got errors when installing ISPconfig

Code:

root@db:/tmp# tar xfz ISPConfig-3-stable.tar.gz
root@db:/tmp# cd ispconfig3_install/install/
root@db:/tmp/ispconfig3_install/install# php -q install.php


--------------------------------------------------------------------------------
_____ ___________   _____              __ _         ____
|_   _/  ___| ___ \ /  __ \            / _(_)       /__  \
  | | \ `--.| |_/ / | /  \/ ___  _ __ | |_ _  __ _    _/ /
  | |  `--. \  __/  | |    / _ \| '_ \|  _| |/ _` |  |_ |
_| |_/\__/ / |     | \__/\ (_) | | | | | | | (_| | ___\ \
\___/\____/\_|      \____/\___/|_| |_|_| |_|\__, | \____/
                                              __/ |
                                             |___/
--------------------------------------------------------------------------------


>> Initial configuration

Operating System: Ubuntu 16.04.2 LTS (Xenial Xerus)

    Following will be a few questions for primary configuration so be careful.
    Default values are in [brackets] and can be accepted with <ENTER>.
    Tap in "quit" (without the quotes) to stop the installer.


Select language (en,de) [en]: en

Installation mode (standard,expert) [standard]: expert

Full qualified hostname (FQDN) of the server, eg server1.domain.tld  [db.techlabshost.com]:

MySQL server hostname [localhost]:

MySQL server port [3306]:

MySQL root username [root]:

MySQL root password []: YCxxxxxxxxxxxxxxxxxxxx

MySQL database to create [dbispconfig]:

MySQL charset [utf8]:

The next two questions are about the internal ISPConfig database user and password.
It is recommended to accept the defaults which are 'ispconfig' as username and a random password.
If you use a different password, use only numbers and chars for the password.

ISPConfig mysql database username [ispconfig]:

ISPConfig mysql database password [965165e11d51be84b92d671c0acdfc8c]: fxxxxxxxxxxxxx

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

MySQL master server hostname []: 34.xxx.xxx.xxx

MySQL master server port []: 3306

MySQL master server root username [root]:

MySQL master server root password []: Yxxxxxxxxxxxxx3

MySQL master server database name [dbispconfig]:

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
root@db:/tmp/ispconfig3_install/install#

 

Resolved. Missing :
apt-get install php7.0-mysql php7.0-cgi php7.0-mcrypt mcrypt php-mbstring
Now checking out if it works