collectd 4.10.1

[Kaushal Shriyan]

On Sat, Nov 6, 2010 at 11:17 AM, Kaushal Shriyan
<kaushalshriyan at gmail.com> wrote:
> On Thu, Nov 4, 2010 at 4:55 PM, Kapil Thangavelu
> <kapil.thangavelu at canonical.com> wrote:
>> On Thu, 04 Nov 2010 01:36:08 -0400, Kaushal Shriyan
>> <kaushalshriyan at gmail.com> wrote:
>>
>>> On Wed, Nov 3, 2010 at 7:42 PM, Clint Byrum <clint at ubuntu.com> 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