You do realize this is a MySQL mailing list and not a collectd mailing list?
I suggest you try here: http://collectd.org/ On Tue, Dec 29, 2009 at 10:38 PM, Kaushal Shriyan <kaushalshri...@gmail.com>wrote: > 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=joh...@pixelated.net > > -- ----------------------------- Johnny Withers 601.209.4985 joh...@pixelated.net