Strange problem with Mysql agent
Hi, I am facing a strange problem using mysql veritas agent. My environment is the following one: Infoscale 7 enterprise in redhat 6.5 VRTS agent for mysql: 7.0.0.0 ACClib : 6.2.0.0 After lot of...
Forum Discussion
Yes, I saw that issue, but why with command is not complaining about that? The path is correctly owned by mysql user [root@msql01 mysql]# ls -altr total 12 drwxr-xr-x. 30 root root 4096 Feb 12 15:29 .. drwxr-xr-x. 3 root root 4096 Feb 12 15:29 . drwxr-xr-x. 2 mysql mysql 4096 Apr 29 17:16 pisdata [root@msql01 mysql]# pwd /opt/mysql If it is due to an user problem in the Mysql configuration part for Mysql resource there is one attribute called MySQLUSer and it is mysql. I don't know why it is not showing in the configuration... MySQL pis_mysql_res ( MySQLAdminPasswd = GQKsMSlKKsOSoUImI BaseDir = "/usr" DataDir = "/opt/mysql/pisdata" HostName @msql01 = msql01 HostName @msql02 = msql02 )
Attached is the log file, if you see the complete command is when it says the following:
Now going to run complete command line [/bin/su mysql -c 'cd /usr ;/usr/bin/mysqld_safe --datadir=/opt/mysql/pisdata --user=mysql ']
If I run this command manually, database starts and resource becomes online after some time due to monitor scritp, but if I online with gui interface it does not work...
[root@msql01 ~]# /bin/su mysql -c 'cd /usr ;/usr/bin/mysqld_safe --datadir=/opt/mysql/pisdata --user=mysql ' &
[1] 30726
[root@msql01 ~]# 2017-05-09T09:32:05.442027Z mysqld_safe Logging to '/var/log/mysqld.log'.
2017-05-09T09:32:05.447169Z mysqld_safe Logging to '/var/log/mysqld.log'.
2017-05-09T09:32:05.490017Z mysqld_safe Starting mysqld daemon with databases from /opt/mysql/pisdata
[root@msql01 ~]# ps -fea | grep mysql
root 30726 28146 0 12:32 pts/0 00:00:00 /bin/su mysql -c cd /usr ;/usr/bin/mysqld_safe --datadir=/opt/mysql/pisdata --user=mysql
mysql 30727 30726 0 12:32 ? 00:00:00 bash -c cd /usr ;/usr/bin/mysqld_safe --datadir=/opt/mysql/pisdata --user=mysql
mysql 30728 30727 0 12:32 ? 00:00:00 /bin/sh /usr/bin/mysqld_safe --datadir=/opt/mysql/pisdata --user=mysql
mysql 30898 30728 1 12:32 ? 00:00:00 /usr/bin/mysqld --basedir=/usr --datadir=/opt/mysql/pisdata --plugin-dir=/usr/lib64/mysql/plugin --log-error=/var/log/mysqld.log --pid-file=/var/run/mysqld/mysqld.pid --socket=/var/lib/mysql/mysql.sock
root 30935 28146 0 12:32 pts/0 00:00:00 grep mysql
[root@msql01 ~]#
