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!

cPanel Cron job commands can't connect to Database ?!

Discussion in 'Database Discussion' started by jasonsmit, Oct 9, 2014.

  1. jasonsmit

    jasonsmit Member

    Joined:
    Jan 15, 2013
    Messages:
    7
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    Hello,

    I have receiving this following error messages from cpanel running hourly and daily Cronjobs :

    ---------------------
    error massege:
    PHP Warning: mysql_query(): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock

    or
    Critical Error : Could not connect to the database

    or

    ERROR OUTPUT:
    mysqldump: Got error: 1045: Access denied for user '***_user'@'localhost' (using password: YES) when trying to connect

    or ......


    ---------------------

    Note: my script can connect to database and mysql fine and no problem there ! and when running these command on root crons haven't problem and running fine there ,

    But php script command can not connect to database correctly under cpanel end user (normal account user) CronJobs, and send me that error messages,

    Please help me to fix ,

    Thanks to all
     
    #1 jasonsmit, Oct 9, 2014
  2. Scriptking

    Scriptking Registered

    Joined:
    Oct 10, 2014
    Messages:
    4
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    Newcastle, New South Wales, Australia
    cPanel Access Level:
    Root Administrator
    im having same issue, every day i wake up to sql server turned off... i need to login to WHM and re-start it.. its a real pain..

    this is the error i wake up to every day..

    /etc/cron.hourly/modsecparse.pl:

    DBI connect('modsec:localhost','modsec',...) failed: Lost connection to MySQL server at 'handshake: reading inital communication packet', system error: 104 at /etc/cron.hourly/modsecparse.pl line 20
    Unable to connect to mysql database at /etc/cron.hourly/modsecparse.pl line 20.
     
    #2 Scriptking, Oct 11, 2014
  3. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    43,887
    Likes Received:
    1,814
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Hello :)

    Check to see if the /tmp/mysql.sock symbolic link exists:

    Code:
    ll /tmp/mysql.sock
    If not, create it via:

    Code:
    ln -s /var/lib/mysql/mysql.sock /tmp/mysql.sock
    Thank you.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #3 cPanelMichael, Oct 13, 2014
  4. jasonsmit

    jasonsmit Member

    Joined:
    Jan 15, 2013
    Messages:
    7
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    Hello Michael,
    Thanks for Your reply

    Both files are exist on the server, but they are empty,

    Please Else solutions?

    Thank You.
     
    #4 jasonsmit, Oct 14, 2014
  5. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    43,887
    Likes Received:
    1,814
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    It's likely a limitation of the jailed shell/noshell access applied to the account. Do you experience the same issue when the account is assigned normal shell access?

    Thank you.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #5 cPanelMichael, Oct 14, 2014
(You must log in or sign up to post here.)
Loading...
Similar Threads - cPanel Cron commands
  1. swbrains

    In Progress [CPANEL-20345] eximstats_spam_check cron job always sends root notification

    swbrains, Apr 2, 2018, in forum: E-mail Discussion
    Replies:
    13
    Views:
    973
    cPanelMichael
    Jun 27, 2018
  2. sahostking

    Tweaking cPanel Servers for maintenance cronjob times

    sahostking, Mar 26, 2018, in forum: General Discussion
    Replies:
    1
    Views:
    110
    cPanelMichael
    Mar 26, 2018
  3. Chirag Aggarwal

    cPanel Cron API - linekey while removing

    Chirag Aggarwal, Jan 31, 2018, in forum: General Discussion
    Replies:
    1
    Views:
    158
    cPanelMichael
    Feb 1, 2018
  4. Daniel-ARg

    Cron <root@host> /usr/local/cpanel/bin/backup

    Daniel-ARg, Dec 11, 2017, in forum: Discusión en Español
    Replies:
    3
    Views:
    598
    cPanelMichael
    Dec 13, 2017
  5. Misiek

    Error with cpanel_dovecot_solr_maintenance cron

    Misiek, Jul 26, 2017, in forum: E-mail Discussion
    Replies:
    5
    Views:
    970
    cPanelMichael
    Aug 7, 2017

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.
    Accept Learn More...
    Dismiss Notice