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!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

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,298
    Likes Received:
    1,765
    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.
     
    #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,298
    Likes Received:
    1,765
    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.
     
    #5 cPanelMichael, Oct 14, 2014
(You must log in or sign up to post here.)
Loading...
Similar Threads - cPanel Cron commands
  1. sahostking

    Tweaking cPanel Servers for maintenance cronjob times

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

    cPanel Cron API - linekey while removing

    Chirag Aggarwal, Jan 31, 2018, in forum: General Discussion
    Replies:
    1
    Views:
    115
    cPanelMichael
    Feb 1, 2018
  3. 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:
    525
    cPanelMichael
    Dec 13, 2017
  4. Misiek

    Error with cpanel_dovecot_solr_maintenance cron

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

    some cPanel update added jailshell to my crontabs

    internetbug256, Jun 27, 2017, in forum: General Discussion
    Replies:
    8
    Views:
    1,230
    cPanelMichael
    Jun 28, 2017

Share This Page