collectd 4.10.1

[Kapil Thangavelu]

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