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)
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.
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!
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
I cant get passed this error. What am I doing wrong? <code> 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 root@db:/tmp/ispconfig3-stable-3.1-87b3ba1458f9bfac31057a334414b65ef010c96a/install# ps ax | grep mysql^C root@db:/tmp/ispconfig3-stable-3.1-87b3ba1458f9bfac31057a334414b65ef010c96a/install# ^C root@db:/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/mysqld.pid --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 root@db:/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/hostname.sh 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 https://git.ispconfig.org/ispconfig/ispconfig3/r 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 https://git.ispconfig.org/ispconfig/ispconfig3/r epository/archive.tar.gz?ref=stable-3.1
