Multiserver File server and MariaDB server

Discussion in 'Installation/Configuration' started by EckyBrazzz, Jan 23, 2018.

  1. EckyBrazzz

    EckyBrazzz Member

    Hi, soulmates,

    I have some difficulties with my SQL setup. I have one server as the ISPConfig server and another as the MariaDB server.
    The first problem is that the databases are created on the wrong server, the ISPConfig server.
    I only have one server in the Monitor part, so one is missing. That server monitor is red

    My second problem is my MariaDB, I can´t log in (*MySQL -u root -p) still works, that lets me in.
    But when I change a thing and want to save it comes with the famous 1045- Access denied for user "root"@'%' (Using password: YES)
  2. Taleman

    Taleman Well-Known Member HowtoForge Supporter

    If there is no data yet on those servers, I would ditch those and install ISPConfig multiserver again on empty servers. Follow closely the ISPConfig manual, that way ISPConfig has always worked for me.
    If this is not possible, ISPConfig Panel System | System Services sets what services are available on which hosts. But if the other host is not working, maybe the MySQL users and passwords you setup are wrong? Check also on both computesrs the /etc/hosts file, there should be IP-numbers for both hosts.
  3. EckyBrazzz

    EckyBrazzz Member

    There is data on the MariaDB server, but this is easy to transfer to another server with Navicat.
    It difficult to follow the manual, its old.
    What manual are you using btw?
    I am on Amazon AWS with my servers.

    Thanks for your response!
  4. Taleman

    Taleman Well-Known Member HowtoForge Supporter

  5. EckyBrazzz

    EckyBrazzz Member

    Your right, thats not so old. But I want NGINX and MARIADB so switching between the manuals.
    BTW, I discovered what I did wrong, I forgot to do the install of the servers to add them to the main server;););)
  6. EckyBrazzz

    EckyBrazzz Member

    I cant get passed this error. What am I doing wrong?

    ISPConfig mysql database username [ispconfig]:

    ISPConfig mysql database password [XXXXXXXXXXXXXXXXXXd373a]:

    Unable to connect to the specified MySQL server Can't connect to local MySQL server through socket '/dev/null' (111)
    MySQL server hostname [localhost]: ^C
    [email protected]:/tmp/ispconfig3-stable-3.1-87b3ba1458f9bfac31057a334414b65ef010c96a/install# ps ax | grep mysql^C
    [email protected]:/tmp/ispconfig3-stable-3.1-87b3ba1458f9bfac31057a334414b65ef010c96a/install# ^C
    [email protected]:/tmp/ispconfig3-stable-3.1-87b3ba1458f9bfac31057a334414b65ef010c96a/install# ps ax | grep mysql
    1346 ? S 0:00 /bin/bash /usr/bin/mysqld_safe
    1494 ? Sl 0:00 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib/mysql/plugin --user=mysql --skip-log-error --pid-file=/var/run/mysqld/ --socket=/var/run/mysqld/mysqld.sock --port=3306
    1495 ? S 0:00 logger -t mysqld -p daemon error
    2414 pts/0 S+ 0:00 grep --color=auto mysql
    [email protected]:/tmp/ispconfig3-stable-3.1-87b3ba1458f9bfac31057a334414b65ef010c96a/install#</code>

    1 nano /etc/ssh/sshd_config
    2 reboot
    3 nano /etc/hosts
    4 reboot
    5 /etc/init.d/ start
    6 apt-get update
    7 apt-get upgrade
    8 apt-get -y install ntp ntpdate
    9 apt-get install mariadb-client mariadb-server
    10 apt-get upgrade
    11 apt-get -y install ntp ntpdate
    12 apt-get install fail2ban
    13 cd /tmp
    14 wget -O ispconfig.tar.gz
    15 wget -O ispconfig.tar.gz epository/archive.tar.gz?ref=stable-3.1
    16 tar xfz ispconfig.tar.gz
    17 cd ispconfig3*/install/
    18 php -q install.php
    19 cd ispconfig3_install/install/
    20 php -q install.php
    21 cd ..
    22 reboot
    23 cd /tmp
    24 wget -O ispconfig.tar.gz epository/archive.tar.gz?ref=stable-3.1
    Last edited: Jan 23, 2018

Share This Page