[collectd] MySQL Plugin

[Richard Shade]

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
<kaushalshriyan at gmail.com>wrote:

> On Mon, Dec 21, 2009 at 4:53 PM, Kaushal Shriyan
> <kaushalshriyan at gmail.com> 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
> collectd at verplant.org
> 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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mailman.verplant.org/pipermail/collectd/attachments/20091222/5956bb3a/attachment.htm