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 Discussions' 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:
    38,165
    Likes Received:
    1,372
    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:
    38,165
    Likes Received:
    1,372
    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. Misiek

    Error with cpanel_dovecot_solr_maintenance cron

    Misiek, Jul 26, 2017, in forum: E-mail Discussions
    Replies:
    5
    Views:
    286
    cPanelMichael
    Aug 7, 2017
  2. internetbug256

    some cPanel update added jailshell to my crontabs

    internetbug256, Jun 27, 2017, in forum: General Discussion
    Replies:
    8
    Views:
    309
    cPanelMichael
    Jun 28, 2017
  3. trucmuche

    errors in /usr/local/cpanel/scripts/upcp --cron logfile

    trucmuche, Apr 20, 2017, in forum: General Discussion
    Replies:
    2
    Views:
    432
    trucmuche
    Apr 22, 2017
  4. mvandemar

    Error with cpanel_dovecot_solr_maintenance cron

    mvandemar, Apr 18, 2017, in forum: E-mail Discussions
    Replies:
    34
    Views:
    3,434
    Infopro
    Jun 29, 2017
  5. nitaish

    Log location for cron jobs set from cPanel

    nitaish, Dec 21, 2016, in forum: General Discussion
    Replies:
    2
    Views:
    683
    cPanelMichael
    Dec 22, 2016

Share This Page