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. <br><br><div class="gmail_quote">
On Tue, Dec 22, 2009 at 6:38 AM, Kaushal Shriyan <span dir="ltr"><<a href="mailto:kaushalshriyan@gmail.com">kaushalshriyan@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
On Mon, Dec 21, 2009 at 4:53 PM, Kaushal Shriyan<br>
<<a href="mailto:kaushalshriyan@gmail.com">kaushalshriyan@gmail.com</a>> wrote:<br>
> Hi<br>
><br>
> I am running collectd version 4.9.0 on Ubuntu 8.04 Hardy Server.<br>
><br>
> ############################################################################################<br>
> <Plugin mysql><br>
> <Database smspay><br>
> Host "localhost"<br>
> User "nagios"<br>
> Password ""<br>
> Database "smspay"<br>
> Socket "/var/run/mysqld/mysqld1.sock"<br>
> # MasterStats true<br>
> </Database><br>
> #<br>
> <Database smsin><br>
> Host "localhost"<br>
> User "nagios"<br>
> Password ""<br>
> Database "smsin"<br>
> Socket "/var/run/mysql/mysqld2.sock"<br>
> # SlaveStats true<br>
> # SlaveNotifications true<br>
> </Database><br>
> </Plugin><br>
><br>
> # mysql -u nagios -h localhost -S /var/run/mysqld/mysqld1.sock<br>
> Welcome to the MySQL monitor. Commands end with ; or \g.<br>
> Your MySQL connection id is 50<br>
> Server version: 5.0.51a-3ubuntu5.4-log (Ubuntu)<br>
><br>
> Type 'help;' or '\h' for help. Type '\c' to clear the buffer.<br>
><br>
> mysql> show databases;<br>
> +--------------------+<br>
> | Database |<br>
> +--------------------+<br>
> | information_schema |<br>
> | SMSPAY |<br>
> | mysql |<br>
> +--------------------+<br>
> 3 rows in set (0.00 sec)<br>
><br>
> mysql> quit<br>
> Bye<br>
> # mysql -u nagios -h localhost -S /var/run/mysqld/mysqld2.sock<br>
> Welcome to the MySQL monitor. Commands end with ; or \g.<br>
> Your MySQL connection id is 23<br>
> Server version: 5.0.51a-3ubuntu5.4-log (Ubuntu)<br>
><br>
> Type 'help;' or '\h' for help. Type '\c' to clear the buffer.<br>
><br>
> mysql> show databases;<br>
> +--------------------+<br>
> | Database |<br>
> +--------------------+<br>
> | information_schema |<br>
> | SMSIN |<br>
> | mysql |<br>
> +--------------------+<br>
> 3 rows in set (0.00 sec)<br>
><br>
> mysql><br>
> ############################################################################################<br>
><br>
> I get [2009-12-21 03:12:22] mysql_real_connect failed: Access denied<br>
> for user 'root'@'localhost' (using password: NO)<br>
> [2009-12-21 03:12:22] read-function of plugin `mysql' failed. Will<br>
> suspend it for 10 seconds.<br>
><br>
> Please suggest/guide.<br>
><br>
> Thanks,<br>
><br>
> Kaushal<br>
><br>
<br>
Hi Again,<br>
<br>
Any Updates for my earlier post to this Mailing List ?<br>
<br>
Thanks and Regards,<br>
<br>
Kaushal<br>
<br>
_______________________________________________<br>
collectd mailing list<br>
<a href="mailto:collectd@verplant.org">collectd@verplant.org</a><br>
<a href="http://mailman.verplant.org/listinfo/collectd" target="_blank">http://mailman.verplant.org/listinfo/collectd</a><br>
</blockquote></div><br><br clear="all"><br>-- <br>Thanks, <br><br>Richard Shade<br>Integration Engineer<br>RightScale - <a href="http://www.rightscale.com/">http://www.rightscale.com/</a><br>phone: 8055004164x1018<br><br>
RightScale User Meetup<br>Real Customers. Real Deployments. Real Benefits. NO HYPE!<br>November 2. Register Today: <a href="http://www.RightScale.com/meetup">www.RightScale.com/meetup</a><br>