I had to install a new DNS server and when running the install for ISPconfig to install the slave to the master I get to here and I get an error and not sure what to look for . . . . MySQL master server database name [dbispconfig]: Unable to connect to mysql server Host '45.59.101.xx' is not allowed to connect to this MariaDB server MySQL master server hostname []: Host 45.59.101.xx is the slave server. Do I need to go into phpmyadmin and allow access from my Master Server? Thanks!
Changed the symptom. MySQL master server database name [dbispconfig]: Unable to connect to mysql server Access denied for user 'root'@'45.59.101.xx' to database 'dbispconfig' MySQL master server hostname []: I went to the master and using phpmyadmin tried adding to the privleges for dbispconfig but it gives me an error that i can not create user. I know I used this before and it never failed
Got past the above and now facing this MySQL master server database name [dbispconfig]: ERROR 2002 (HY000): Can't connect to server on 'localhost' (110) ERROR: Unable to load SQL-Dump into database table. root@dns3:/tmp/ispconfig3_install/install#
That last error was a firewall issue so everything is good. I do this so seldom I forget between adding slaves. Please close this request.
I thought I was home free. Slave and master are running same version ISPConfig 3.2.12p1 but my updates are stuck at 1348. This slave is a DNS server and it mirrors my ns1 server. Throws this error when I run server.sh at the slave: root@dns3:~# /usr/local/ispconfig/server/server.sh 06.12.2024-05:32 - WARNING - There is already a lockfile set, but no process running with this pid (1485). Continuing. PHP Fatal error: Uncaught mysqli_sql_exception: Data truncated for column 'limit_cron_type' at row 1 in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php:302 Stack trace: #0 /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php(302): mysqli_query() #1 /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php(339): db->_query() #2 /usr/local/ispconfig/server/lib/classes/modules.inc.php(171): db->query() #3 /usr/local/ispconfig/server/server.php(187): modules->processDatalog() #4 {main} thrown in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 302 Help?
Till, all nodes are not on 3.2.12p1. The master and this slave I'm installing had it but my primary nameserver which ther new slave was mirroring was one version back. Have over 25 slaves, thought I needed to update the master and the slave I was installing but the mirror requirement messed this up probably. Would it make even a bigger mess if I tried to remove the new slave from the multiserver setup and then retried to install after making the primary nameserver 3..2.12p1?
Till, I deleted the new slave and it removed the 1348 updated out of datalog. Will I need to update all 25 slaves to install this DNS slave or just make sure the master and the primary nameserver are all the same version. I will plan on updating all slaves to 3.2.12.p1 and in the future will plan on not updating versions everytime I add a slave but install the common version at the time.
