Problem with my.cnf

paszczak000

• December 25, 2015 08:16

I have file /root/.my.cnf:
[client] user=root password=PASS1 socket=/var/lib/mysql/mysql.sock [clientbackup] user=backup password=PASS2 socket=/var/lib/mysql/mysql.sock
Everything is working fine. I can login into MySQL without password but after few seconds everything stop working. I can see processes:
root 9742 0.3 0.1 103924 21800 ? S 14:55 0:00 tailwatchd - chkservd - mysql check root 9759 0.6 0.1 60184 16968 ? S 14:55 0:00 /usr/local/cpanel/scripts/restartsrv_mysql root 9763 1.4 0.1 109548 26252 ? S 14:55 0:00 /usr/local/cpanel/scripts/mysqlconnectioncheck root 9879 2.2 0.1 57940 16808 ? S 14:55 0:00 /usr/local/cpanel/scripts/restartsrv_mysql - waiting for lock root 10009 0.0 0.0 103300 896 pts/2 S+ 14:55 0:00 grep mysql
So I'm thinking that something is wrong with mysqlconnectioncheck. Can you suggest some soluton?

• 

  SysSachin

  • December 25, 2015 16:25

  Hello, Are you getting any error while restarting the MySQL service ?

  0
• 

  cPanelPeter cPanel Staff

  • December 25, 2015 23:46

  Hello, The /root/.my.cnf file should only contain your log in credentials. [client] user=root password=PASS1 All other MySQL configurations (such as socket) should be in /etc/my.cnf Please also review the /var/lib/mysql/$HOSTNAME.err log file to see what is happening with MySQL.

  0
• 

  paszczak000

  • December 26, 2015 06:49

  There is no error with MySQL. On standard instalation of MySQL everything is wokring fine. Problem is with CPanel setup. Your scripts don't like section for example [clientbackup].

  0
• 

  cPanelMichael

  • December 26, 2015 15:57

  Your scripts don't like section for example [clientbackup].

  
  Hello :) Backup authentication details are not supported if you are manually inputting them into the /root/.my.cnf file. Instead, if your goal is to automatically switch to different remote MySQL server in the event the first one is down, then you could setup a script that replaces the existing information in the /root/.my.cnf file. Thank you.

  0
• 

  paszczak000

  • December 26, 2015 18:37

  No, the problem is that some scripts in CPanel are reading .my.cnf credentials from wrong sections. Probably mysqlconnectioncheck is using details from [clientbackup] instead of [client] section where is user root.

  0
• 

  cPanelMichael

  • December 28, 2015 14:07

  There's no support for custom sections in the /root/.my.cnf file at this time. Could you elaborate on the purpose of the additional section so we can offer an alternative? Thank you.

  0
• 

  paszczak000

  • December 28, 2015 14:51

  Hi, can you add this support? We are using it for our additonal monitoring scripts and backups. We need this sections.

  0
• 

  cPanelMichael

  • February 02, 2016 20:35

  You can open a feature request for this via: Submit A Feature Request Thank you.

  0
• 

  paszczak000

  • February 06, 2016 17:20

  OK, but i don't have there Invite Code.

  0
• 

  cPanelMichael

  • February 08, 2016 19:14

  You can leave the "Invite Code" blank when creating the account. Thank you.

  0

Please sign in to leave a comment.