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 Technical Support Community Manager
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    45,197
    Likes Received:
    1,936
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Twitter:
    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 Technical Support Community Manager
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    45,197
    Likes Received:
    1,936
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Twitter:
    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. baronn

    SOLVED [CPANEL-23812] update_db_cache cron job failing

    baronn, Nov 7, 2018, in forum: General Discussion
    Replies:
    5
    Views:
    147
    cPanelMichael
    Nov 13, 2018 at 2:46 PM
  2. HostXNow_Chris

    Cron emails (/usr/local/cpanel/scripts/fix-cpanel-perl;/usr/lo cal/cpanel/scripts/upcp --c

    HostXNow_Chris, Aug 15, 2018, in forum: General Discussion
    Replies:
    5
    Views:
    528
    cPanelLauren
    Sep 4, 2018
  3. CrazySerb

    SOLVED Cron jobs stopped working after cPanel to cPanel transfer to a new server

    CrazySerb, Aug 14, 2018, in forum: General Discussion
    Replies:
    3
    Views:
    197
    CrazySerb
    Aug 15, 2018
  4. swbrains

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

    swbrains, Apr 2, 2018, in forum: E-mail Discussion
    Replies:
    14
    Views:
    1,576
    cPanelMichael
    Aug 7, 2018
  5. sahostking

    Tweaking cPanel Servers for maintenance cronjob times

    sahostking, Mar 26, 2018, in forum: General Discussion
    Replies:
    1
    Views:
    188
    cPanelMichael
    Mar 26, 2018

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