Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!

mysqluserstore script causes sql server restart every two hours

Discussion in 'Database Discussion' started by caxinte, May 27, 2019.

  1. caxinte

    caxinte Registered

    Joined:
    May 27, 2019
    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    Romania
    cPanel Access Level:
    Root Administrator
    after receiving email from chkservd with mysql service stopped and recovered I investigated and
    checked /var/log/cron and /var/lib/mysql/[host].err file, ant noticed that at the same time that mysqluserstore script is run sql server is restarting, every two hours, in the script comments we have:

    # We used to do this during restartsrv however that turned out to be
    # a problem because check_mysql_password_works_or_reset can restart
    # mysql if the password is wrong.

    also in mysql err log file I encounter:
    2019-05-27T21:42:04.329471Z 2 [Note] Access denied for user 'UNKNOWN_MYSQL_USER'@'localhost' (using password: NO)

    so it seems to be related to the above comment
     
  2. cPanelLauren

    cPanelLauren Forums Analyst II Staff Member

    Joined:
    Nov 14, 2017
    Messages:
    6,459
    Likes Received:
    503
    Trophy Points:
    263
    Location:
    Houston
    cPanel Access Level:
    DataCenter Provider
    Can you please open a ticket using the link in my signature? Once open please reply with the Ticket ID here so that we can update this thread with the resolution once the ticket is resolved.


    Thanks!
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  3. caxinte

    caxinte Registered

    Joined:
    May 27, 2019
    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    Romania
    cPanel Access Level:
    Root Administrator
    Your Support Request ID is: 12452205
     
  4. cPanelLauren

    cPanelLauren Forums Analyst II Staff Member

    Joined:
    Nov 14, 2017
    Messages:
    6,459
    Likes Received:
    503
    Trophy Points:
    263
    Location:
    Houston
    cPanel Access Level:
    DataCenter Provider
    Great, thank you for that I'm watching that ticket and I'll update here as soon as there's more information.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
Loading...

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice