On Sat, Nov 6, 2010 at 11:17 AM, Kaushal Shriyan <[email protected]> wrote: > 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 >
Hi Got it fixed. Anyways thanks a lot for all the support. Kaushal -- ubuntu-server mailing list [email protected] https://lists.ubuntu.com/mailman/listinfo/ubuntu-server More info: https://wiki.ubuntu.com/ServerTeam
