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.

mysql connection cron issue

Discussion in 'Database Discussions' started by sreeninair, Jan 20, 2014.

  1. sreeninair

    sreeninair Well-Known Member

    Joined:
    Dec 23, 2013
    Messages:
    100
    Likes Received:
    0
    Trophy Points:
    16
    cPanel Access Level:
    Root Administrator
    Hello,

    I am getting email of failed cron job. The cron is trying to access mysql. It is working fine when executing manually. Please let me know how to fix it

    -------------------------------------
    ~]# cat /etc/my.cnf
    [mysqld]
    #skip-innodb
    datadir=/var/lib/mysql
    set-variable = max_connections=250
    set-variable = max_user_connections=50
    local-infile=0
    wait_timeout = 150
    query_cache_size = 16M
    thread_cache_size = 16M
    ------------------------------------
     
  2. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,675
    Likes Received:
    648
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    Hello :)

    Do you have your MySQL data directory or one of it's parent directories on a separate mount or symlinked to a separate mount? If so, you may need to utilize the "/var/cpanel/jailshell-additional-mounts" file as documented here:

    How to Create Custom Jailed Shell (Jailshell) Mounts

    Thank you.
     
  3. sreeninair

    sreeninair Well-Known Member

    Joined:
    Dec 23, 2013
    Messages:
    100
    Likes Received:
    0
    Trophy Points:
    16
    cPanel Access Level:
    Root Administrator
    Hello Michael,

    I have created additional mounts and fixed this. Thanks for your time.

    Thanks
    Sreenivas
     
  4. cPanelPeter

    cPanelPeter Technical Analyst III
    Staff Member

    Joined:
    Sep 23, 2013
    Messages:
    569
    Likes Received:
    15
    Trophy Points:
    18
    cPanel Access Level:
    Root Administrator
    Twitter:
    Hello,

    Glad that worked. Thanks for updating this thread with the solution.
     
Loading...

Share This Page