List:General Discussion« Previous MessageNext Message »
From:Kaushal Shriyan Date:December 30 2009 4:38am
Subject:Re: MySQL Plugin
View as plain text  
On Sun, Dec 27, 2009 at 10:40 AM, Kaushal Shriyan
<kaushalshriyan@stripped> wrote:
> 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
>

Hi Again,

I have not got any reply for my query. Checking in again on 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