List:General Discussion« Previous MessageNext Message »
From:Kaushal Shriyan Date:December 23 2009 12:08pm
Subject:MySQL Plugin
View as plain text  
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
Thread
MySQL PluginKaushal Shriyan23 Dec
  • Re: MySQL PluginKaushal Shriyan27 Dec
    • Re: MySQL PluginKaushal Shriyan30 Dec
      • Re: MySQL PluginJohnny Withers30 Dec