On Tue, Dec 22, 2009 at 9:46 PM, Richard Shade <[email protected]> wrote: > Kaushal, I would start with your configuration being wrong. Database > "smspay" is not equal to Database "SMSPAY", which is what it should be from > your show tables command. Same thing for SMSIN. > > On Tue, Dec 22, 2009 at 6:38 AM, Kaushal Shriyan <[email protected]> > wrote: >> >> On Mon, Dec 21, 2009 at 4:53 PM, Kaushal Shriyan >> <[email protected]> wrote: >> > Hi >> > >> > I am running collectd version 4.9.0 on Ubuntu 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 [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. >> > >> > Please suggest/guide. >> > >> > Thanks, >> > >> > Kaushal >> > >> >> Hi Again, >> >> Any Updates for my earlier post to this Mailing List ? >> >> Thanks and Regards, >> >> Kaushal >> >> _______________________________________________ >> collectd mailing list >> [email protected] >> http://mailman.verplant.org/listinfo/collectd > > > > -- > Thanks, > > Richard Shade > Integration Engineer > RightScale - http://www.rightscale.com/ > phone: 8055004164x1018 > > RightScale User Meetup > Real Customers. Real Deployments. Real Benefits. NO HYPE! > November 2. Register Today: www.RightScale.com/meetup >
Hi Richard, I did edited it to SMSPAY and SMSIN too. it gave me the same issue. Please suggest/guide Thanks and Regards, Kaushal _______________________________________________ collectd mailing list [email protected] http://mailman.verplant.org/listinfo/collectd
