[collectd] MySQL Plugin

[Kaushal Shriyan]

On Tue, Dec 22, 2009 at 9:46 PM, Richard Shade <rshade at rightscale.com> 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 <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
>

Hi Richard,

I did edited it to SMSPAY and SMSIN too. it gave me the same issue.
Please suggest/guide

Thanks and Regards,

Kaushal