mysql connection cron issue

[sreeninair]

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
------------------------------------

 

[cPanelMichael]

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.

 

[sreeninair]

Hello Michael,

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

Thanks
Sreenivas

 

[cPanelPeter]

Hello,

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