List:General Discussion« Previous MessageNext Message »
From:Kaushal Shriyan Date:December 27 2009 5:10am
Subject:Re: MySQL Plugin
View as plain text  
On Wed, Dec 23, 2009 at 5:38 PM, Kaushal Shriyan
<kaushalshriyan@stripped> 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 root@localhost and not
> nagios@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
Thread
MySQL PluginKaushal Shriyan23 Dec
  • Re: MySQL PluginKaushal Shriyan27 Dec
    • Re: MySQL PluginKaushal Shriyan30 Dec
      • Re: MySQL PluginJohnny Withers30 Dec