Problem updating mail_user table

Discussion in 'General' started by raziel00, Aug 5, 2021.

  1. raziel00

    raziel00 New Member

    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.
     
  2. Taleman

    Taleman Well-Known Member HowtoForge Supporter

  3. raziel00

    raziel00 New Member

    Sorry my mistake. :)

    Thanks.
     
  4. Jesse Norell

    Jesse Norell ISPConfig Developer Staff Member ISPConfig Developer

    Last edited: Aug 6, 2021
  5. raziel00

    raziel00 New Member

    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 ?
     
  6. Jesse Norell

    Jesse Norell ISPConfig Developer Staff Member ISPConfig Developer

    Go to the faq for debugging ispconfig (following the instructions above). Something is preventing your slave server from reading sys_datalog updates on the master.
     
  7. raziel00

    raziel00 New Member

    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
     
  8. Jesse Norell

    Jesse Norell ISPConfig Developer Staff Member ISPConfig Developer

    You would need to try debugging on the slave server, although it sounds like your master has a problem connecting to itself as well. You might try testing the db_* connection info (username, password and host) from /usr/local/ispconfig/server/lib/config.inc.php on both hosts, and the dbmaster_* connection info on the slave. You might try mysqlrepair on your master server as well.
     
  9. raziel00

    raziel00 New Member

    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
     
  10. raziel00

    raziel00 New Member

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

    It answers:
    note : The storage engine for the table doesn't support repair
     
  11. Jesse Norell

    Jesse Norell ISPConfig Developer Staff Member ISPConfig Developer

    You'll need to fix that; afterwards see if things work, and if not, post debug output from the slave. Was it the slave server which crashed?
     
  12. raziel00

    raziel00 New Member

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

    Jesse Norell ISPConfig Developer Staff Member ISPConfig Developer

    Yes.
     
  14. raziel00

    raziel00 New Member

    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.
     
  15. nhybgtvfr

    nhybgtvfr Well-Known Member HowtoForge Supporter

    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.
     
    Th0m and till like this.
  16. raziel00

    raziel00 New Member

    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.
     
  17. AC-News

    AC-News New Member

    Very thanks
     
  18. raziel00

    raziel00 New Member

    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.
     
  19. Jesse Norell

    Jesse Norell ISPConfig Developer Staff Member ISPConfig Developer

    Check the server.updated value for ISP2, maybe it thinks it's ahead of sys_datalog on the master; ie. compare
    Code:
    select server_name, updated from server;
    on both servers with
    Code:
    select server_id, max(datalog_id) from sys_datalog group by server_id;
    on the master.
     
  20. raziel00

    raziel00 New Member

    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
     

Share This Page