collectd 4.10.1

[Kaushal Shriyan]

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