Install ISPConfig multiserver - Postfix - MariaDB

Discussion in 'Installation/Configuration' started by EckyBrazzz, Mar 15, 2017.

  1. EckyBrazzz

    EckyBrazzz New Member

    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
     
  2. Jesse Norell

    Jesse Norell Well-Known Member

  3. EckyBrazzz

    EckyBrazzz New Member

    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)
     
  4. florian030

    florian030 ISPConfig Developer ISPConfig Developer

  5. EckyBrazzz

    EckyBrazzz New Member

    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.
    [​IMG]

    And

    [​IMG]
    Thanks for looking into it.
     
  6. Jesse Norell

    Jesse Norell Well-Known Member

    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.
     
  7. EckyBrazzz

    EckyBrazzz New Member

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

    EckyBrazzz New Member

    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#
    
     
  9. EckyBrazzz

    EckyBrazzz New Member

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

Share This Page