Problem updating mail_user table

Hi,
I had a system crash and since then any modifications I do for the email part do not get executed and stay in the jobqueue.
I have the following setup.
ISP1 ver 3.2.2 (Master) web/db
ISP2 ver 3.2.2 (Slave) email

Everything on the web side works, but nothing for the emails. I can still receive and send from accounts i have access.
But some accounts I cant access and no new modifications take place it always stays in the jobqueue.

I tried reinstalling dovecot and doing an ISPConfig update. Did not work.

Thanks in advance for the help.

 

If you are running ISPConfig you should post ISPConfig questions on the ISPConfig forum.
Follow these instructions:
https://www.howtoforge.com/community/threads/please-read-before-posting.58408/

 

Sorry my mistake.

Thanks.

 

If I had a DB connection issue, should other tasks be also affected ?
Because I have a master and slave does the slave have its own database ?
Where can I check to verify the problem and find the exact reason ?

 

Hi,
I followed the link instructions. Here are some details.
ISP1 Master (web/db)

ISPConfig - Log
2021-08-10 23:11 isp1 Debug Remove Lock: /usr/local/ispconfig/server/temp/.ispconfig_lock
2021-08-10 23:11 isp1 Debug Calling function 'check_phpini_changes' from plugin 'webserver_plugin' raised by action 'server_plugins_loaded'.

System Log
Aug 10 19:20:05 isp1 mariadbd[1037]: 2021-08-10 19:20:05 242765 [Warning] Aborted connection 242765 to db: 'unconnected' user: 'unauthenticated' host: 'localhost' (This connection closed normally without authentication)

That's all I found.
Christopher

 

On ISP1 Master
DB settings username and password works.
DB settings for master DB is half empty.

On ISP2 Slave
DB settings username and password dont work.
DB settings for master DB on ISP1 works

 

From ISP1 i tried:
mysqlcheck -r dbispconfig -u ispconfig -p

It answers:
note : The storage engine for the table doesn't support repair

 

So if I understand, even the slave server needs to have a local database to which needs access ?

 

I tested all database connections in config.inc.php from both ISP1 and ISP2.
They worked perfectly.
I still dont know why ISP2 wont accept any request from ISP1.

 

you may be fundamentally misunderstanding how changes are applied.
ISP2 does not, ever, receive any requests from ISP1.

ISP2 logs into the dbispconfig database on ISP1 and retrieves any updates applicable to itself from the sys_datalog table.

you need to check
1. the ispscrv# user from ISP2 can login to the mysql server on ISP1, and read from the sys_datalog table in the dbispconfig database.
2. the ispconfig user from ISP2 can login to the mysql server on ISP2 (localhost) and make changes to the dbispconfig database.
3. the server.sh script on ISP2 is running properly and not getting blocked by an existing lockfile.

from post #9 it sounds like 2. isn't working, and @Jesse Norell says in post #11, you need to fix that and then see if updates start getting applied.

 

Ok,
1. the ispscrv# user from ISP2 can login to the mysql server on ISP1, and read from the sys_datalog table in the dbispconfig database.
I was able to do a select * from sys_datalog;.
2. the ispconfig user from ISP2 can login to the mysql server on ISP2 (localhost) and make changes to the dbispconfig database.
I was able to modify in the server table.
3. the server.sh script on ISP2 is running properly and not getting blocked by an existing lockfile.
If i execure "php server.php" I get "finished server.php."

So I carefully tried all DB usernames and they all work.

 

Very thanks

 

Just to mention so that there is no confusion. My ISP2 is still non functional.
I cant send or receive emails nor I can make new connections.

Thanks in advance for your help.

 

On both servers (select server_name, updated from server; )
ISP1:
ISP1 557
ISP2 554
ISP2:
ISP2 567

On master ISP1 (select server_id, max(datalog_id) from sys_datalog group by server_id; )
0 455
1 557
2 560