On Thu, Nov 4, 2010 at 4:55 PM, Kapil Thangavelu <[email protected]> wrote: > On Thu, 04 Nov 2010 01:36:08 -0400, Kaushal Shriyan > <[email protected]> wrote: > >> On Wed, Nov 3, 2010 at 7:42 PM, Clint Byrum <[email protected]> wrote: >>> >>> On Wed, 2010-11-03 at 14:50 +0530, Kaushal Shriyan wrote: >>>> >>>> Hi, >>>> >>>> I am using collectd 4.10.1 on Ubuntu 8.04 server. I am following >>>> http://collectd.org/wiki/index.php/Plugin:MySQL. >>>> I get [2010-11-03 01:49:15] mysql_real_connect failed: Access denied >>>> for user 'root'@'localhost' (using password: NO) in the >>>> collectd-debug.log. Please advice. >>>> >>> >>> >>> If you read the message, it seems that the user its using is 'root', >>> despite that you've told it to use 'nagios'. >>> >>> Did you maybe forget to restart collectd after changing the config file? >>> >>> >>> >> >> Hi Clint, >> >> Have restarted the collectd service umpteen number of times, yet no luck. >> >> Please suggest further >> >> Kaushal >> > > From the error message, perhaps you should verify your mysql connection > details with a mysql client. > > cheers, > > Kapil >
Hi Kapil I have already posted my issue with details. I have been able to connect to the DB using MySQL Client. I am using collectd 4.10.1 on Ubuntu 8.04 server. I am following http://collectd.org/wiki/index.php/Plugin:MySQL. I get [2010-11-03 01:49:15] mysql_real_connect failed: Access denied for user 'root'@'localhost' (using password: NO) in the collectd-debug.log. Please advice. My configs are as below <Plugin "mysql"> <Database "SMSPAY"> User "nagios" Password "" Socket "/var/run/mysqld/mysqld1.sock" </Database> <Database "SMSIN"> User "nagios" Password "" Socket "/var/run/mysqld/mysqld2.sock" </Database> </Plugin> mysql -u nagios -S /var/run/mysqld/mysqld1.sock -DSMSPAY Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 89393 Server version: 5.0.51a-3ubuntu5.4-log (Ubuntu) Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> show tables; +-------------------+ | Tables_in_SMSPAY | +-------------------+ | ACCOUNTS | | AMT_MISMATCH_LOG | | APICALLAUDITTRAIL | | APPDEVELOPER | | APPINFO | | BANKS | | BILLING_LOG | | CASH_DETAILS | | CHEQUE_DETAILS | | DEPOSIT_DETAILS | | ITZCASH_DETAILS | | MIGRATE_LOG | | PAYSEAL_DETAILS | | PAYTRONIC_DETAILS | | TECHPRO_DETAILS | | TRANSACTIONS | | USERLOGIN | | USERS | | ZIPCASH_DETAILS | +-------------------+ 19 rows in set (0.00 sec) mysql> #mysql -u nagios -S /var/run/mysqld/mysqld2.sock -DSMSIN Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 92810 Server version: 5.0.51a-3ubuntu5.4-log (Ubuntu) Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> show tables; +-----------------+ | Tables_in_SMSIN | +-----------------+ | InURL | | InURLMapping | | InURLMappingOld | | MsgNew | | TmpMsgIn | +-----------------+ 5 rows in set (0.00 sec) mysql> Please suggest further Thanks Kaushal -- ubuntu-server mailing list [email protected] https://lists.ubuntu.com/mailman/listinfo/ubuntu-server More info: https://wiki.ubuntu.com/ServerTeam
