On Sun, Dec 27, 2009 at 10:40 AM, Kaushal Shriyan <kaushalshri...@gmail.com> wrote: > On Wed, Dec 23, 2009 at 5:38 PM, Kaushal Shriyan > <kaushalshri...@gmail.com> wrote: >> Hi >> >> I am running collectd >> (http://www.collectd.org/wiki/index.php/Plugin:MySQL) version 4.9.0 on >> Ubuntu Linux 8.04 (Hardy) Server. >> >> ############################################################################################ >> <Plugin mysql> >> <Database SMSPAY> >> Host "localhost" >> User "nagios" >> Password "" >> Database "smspay" >> Socket "/var/run/mysqld/mysqld1.sock" >> # MasterStats true >> </Database> >> # >> <Database SMSIN> >> Host "localhost" >> User "nagios" >> Password "" >> Database "smsin" >> Socket "/var/run/mysql/mysqld2.sock" >> # SlaveStats true >> # SlaveNotifications true >> </Database> >> </Plugin> >> >> # mysql -u nagios -h localhost -S /var/run/mysqld/mysqld1.sock >> Welcome to the MySQL monitor. Commands end with ; or \g. >> Your MySQL connection id is 50 >> Server version: 5.0.51a-3ubuntu5.4-log (Ubuntu) >> >> Type 'help;' or '\h' for help. Type '\c' to clear the buffer. >> >> mysql> show databases; >> +--------------------+ >> | Database | >> +--------------------+ >> | information_schema | >> | SMSPAY | >> | mysql | >> +--------------------+ >> 3 rows in set (0.00 sec) >> >> mysql> quit >> Bye >> # mysql -u nagios -h localhost -S /var/run/mysqld/mysqld2.sock >> Welcome to the MySQL monitor. Commands end with ; or \g. >> Your MySQL connection id is 23 >> Server version: 5.0.51a-3ubuntu5.4-log (Ubuntu) >> >> Type 'help;' or '\h' for help. Type '\c' to clear the buffer. >> >> mysql> show databases; >> +--------------------+ >> | Database | >> +--------------------+ >> | information_schema | >> | SMSIN | >> | mysql | >> +--------------------+ >> 3 rows in set (0.00 sec) >> >> mysql> >> ############################################################################################ >> >> I get the below issue in the collectd.log >> >> [2009-12-21 03:12:22] mysql_real_connect failed: Access denied for >> user 'root'@'localhost' (using password: NO) >> [2009-12-21 03:12:22] read-function of plugin `mysql' failed. Will >> suspend it for 10 seconds. >> >> I am not able to figure out why i get r...@localhost and not >> nag...@localhost in the collectd.log file even after specifying it in >> the collectd.conf file. >> >> Please suggest/guide. >> >> Thanks, >> >> Kaushal >> > > Hi Again, > > Any updates to my earlier post to this Mailing List ? > > Thanks, > > Kaushal >
Hi Again, I have not got any reply for my query. Checking in again on this Mailing List. Thanks, Kaushal -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
