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
There is this guide for multi-server setup that is a little dated: https://www.howtoforge.com/multiser...se-servers-on-debian-squeeze-with-ispconfig-3 There is apparently an updated version for Debian 8 in the manual, http://www.ispconfig.org/documentation/user-manual/ Those will cover the multi-server aspects, though nothing specific to amazon.
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: [email protected]:~# 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.
That looks ok for the users table; you might test that the second server can connect and login on mysql as root (mysql -u root -p -h ip.of.master.server). Once you can connect from the slave to the master you should be able to complete the ispconfig installation.
Well, didn't work out. Got errors when installing ISPconfig Code: [email protected]:/tmp# tar xfz ISPConfig-3-stable.tar.gz [email protected]:/tmp# cd ispconfig3_install/install/ [email protected]:/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 [email protected]:/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