Resync hangs

Thanks Jesse, but that's where the rub lies. I don't know what the password is on the webserver (unless it's in clear text, which I'm assuming it is not). So, if I reset the password in the master db, it's still not going to match the password stored in the webserver's db. Can I simply change the password using phpmyadmin in both databases? Do you know what hash MySQL uses for encrypting the password?

 

Copying and pasting password
didn't help resolve the issue. I found this article:
https://www.faqforge.com/linux/debugging-ispconfig-3-server-actions-in-case-of-a-failure/
When I attempted to set the debug level to Error, I received this message:

1. tmp-dir Path is empty.
   Invalid tmp-dir path.
   Log retention must be a number > 0

Found this article:
https://www.howtoforge.com/communit...ath-in-a-server-settings-fresh-install.78413/
still no help (and tmp-dir error is still 44there). Tried installing the git-stable and still no synchronization

 

Thanks Jesse. Still no luck. Here's what's been done:
1. There are several entries in the master db for the web server (spider)
2. I changed the user password on everyone of the ispc... users in the master db using the mysl cli.
3. I changed the ispc… one at a time to match the users in the master db. without changing the password.
4. Ran server.sh and in every instance received this error:

01.11.2018-12:47 - WARNING - There is already a lockfile set, but no process running with this pid (57275). Continuing.
PHP Warning: mysqli_real_connect(): (28000/1045): Access denied for user 'ispcsrv20'@'spider.domain'(using password: YES) in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 80
PHP Warning: mysqli_real_connect(): (28000/1045): Access denied for user 'ispcsrv20'@'spider.domain'(using password: YES) in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 83
PHP Warning: mysqli_real_connect(): (28000/1045): Access denied for user 'ispcsrv20'@'spider.domain'(using password: YES) in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 83
PHP Warning: mysqli_real_connect(): (28000/1045): Access denied for user 'ispcsrv20'@'spider.domain'(using password: YES) in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 83

I've truncated the error message because there are numerous messages that include other lines from the db_mysqli.inc.php file (line 198). However, there is one line:

DB::query -> reconnectUnable to load the server configuration from database.PHP Warning: mysqli_real_connect(): (28000/1045): Access denied for user 'ispcsrv20'@'spider.domain'(using password: YES) in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 80

 

I did not run flush privs. After doing so, errors stopped (thanks for the heads-up). However, the synch is still hung and I cannot connect to the master db from the slave using the creds saved in the config.inc.php file.

 

BTW, yes, there is an IP and hostname in the master and slave dbs.

 

Maybe a different approach. In the ISP Control Panel, the webserver's version is listed as 3.1.8p1. However, this was upgraded to ver 3.1.13 (which is when our problem started) and is correctly indicated in the confgi.inc.php file on the webserver.
Is there a way to find out which server in the master's database is running version 3.1.8p1? I am hoping that I can then determine whether or not I've got the correct username in the config file. I can only see one web server listed in dbispconfig.server table, identified as server_id 16. Not sure that that ties int the username of ispcsrv16. If it does, then we still have an issue somewhere else.

This is frustrating.

 

Thanks Till. My ispcsrv# and server id march, so that's not the issue. Any suggestions on where to go from here? Our clients are getting very annoyed because their changes are not propagating. Is there a way to uninstall and reinstall without losing everything?

 

I finally have the ispcsrv* user authenticating to MySQL (don't ask how or why, because I have no idea!). But syncs still are not going through.
root@spider:/usr/local/ispconfig/server/lib# mysql -u ispcsrv16 -p -h webadmin
Enter password:
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 1604732
Server version: 10.0.36-MariaDB-0+deb8u1 (Debian)

Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [(none)]>

Jesse, I cannot enable debug mode (see post from yesterday at 1:49PM). You mentioned checking the sys_datalog table, but I have no idea how to read what I'm seeing. In phpmyadmin, can I create a search that will help identify the pending jobs?