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 r...@localhost and not
nag...@localhost in the collectd.log file even after specifying it in
the collectd.conf file.
Please suggest/guide.
Thanks,
Kaushal
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[email protected]
