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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
