[collectd] mysql plugin

[Kaushal Shriyan]

On Thu, Nov 5, 2009 at 4:39 PM, Mirko Buffoni <briareos at eswat.org> wrote:
> At 15:43 05/11/2009 +0530, you wrote:
>>
>> On Wed, Nov 4, 2009 at 11:10 PM, Kaushal Shriyan
>> <kaushalshriyan at gmail.com> wrote:
>> > Hi,
>> >
>> > mysql plugin connects to the default socket (
>> > /var/run/mysqld/mysqld.sock ) even if not described in the
>> > collectd.conf file. I am using 4.8.1 version of collectd.
>> > I get [2009-11-04 01:49:07] mysql_real_connect failed: Can't connect
>> > to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
>> > in the collectd logs.
>> >
>> > Please suggest.
>> >
>> > Thanks,
>> >
>> > Kaushal
>> >
>>
>> Hi Again,
>>
>> Any updates on my issue posted earlier to this Mailing List.
>>
>> Thanks,
>
> What do you have in your /etc/my.conf
> look for any
>
> socket=
>
> line. It could be it's using the default socket.
>
> Mirko
>
>

Hi Mirko

I have this in my my.cnf file

[mysqld_safe]
socket          = /var/run/mysqld/mysqld.sock
nice            = 0
[mysqld]

Do I need to comment it out and re bounce both mysql and collectd
daemon in order to make it work. ?

Thanks,

Kaushal