List:General Discussion« Previous MessageNext Message »
From:Johnny Withers Date:December 30 2009 5:03pm
Subject:Re: MySQL Plugin
View as plain text  
You do realize this is a MySQL mailing list and not a collectd mailing list?

I suggest you try here: http://collectd.org/



On Tue, Dec 29, 2009 at 10:38 PM, Kaushal Shriyan
<kaushalshriyan@stripped>wrote:

> On Sun, Dec 27, 2009 at 10:40 AM, Kaushal Shriyan
> <kaushalshriyan@stripped> wrote:
> > On Wed, Dec 23, 2009 at 5:38 PM, Kaushal Shriyan
> > <kaushalshriyan@stripped> wrote:
> >> Hi
> >>
> >> I am running collectd
> >> (http://www.collectd.org/wiki/index.php/Plugin:MySQL) version 4.9.0 on
> >> Ubuntu Linux 8.04 (Hardy) Server.
> >>
> >>
>
> ############################################################################################
> >> <Plugin mysql>
> >>       <Database SMSPAY>
> >>               Host "localhost"
> >>               User "nagios"
> >>               Password ""
> >>               Database "smspay"
> >>               Socket "/var/run/mysqld/mysqld1.sock"
> >> #               MasterStats true
> >>       </Database>
> >> #
> >>       <Database SMSIN>
> >>               Host "localhost"
> >>               User "nagios"
> >>               Password ""
> >>               Database "smsin"
> >>               Socket "/var/run/mysql/mysqld2.sock"
> >> #               SlaveStats true
> >> #               SlaveNotifications true
> >>       </Database>
> >> </Plugin>
> >>
> >> # mysql -u nagios -h localhost -S /var/run/mysqld/mysqld1.sock
> >> Welcome to the MySQL monitor.  Commands end with ; or \g.
> >> Your MySQL connection id is 50
> >> Server version: 5.0.51a-3ubuntu5.4-log (Ubuntu)
> >>
> >> Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
> >>
> >> mysql> show databases;
> >> +--------------------+
> >> | Database           |
> >> +--------------------+
> >> | information_schema |
> >> | SMSPAY             |
> >> | mysql              |
> >> +--------------------+
> >> 3 rows in set (0.00 sec)
> >>
> >> mysql> quit
> >> Bye
> >> # mysql -u nagios -h localhost -S /var/run/mysqld/mysqld2.sock
> >> Welcome to the MySQL monitor.  Commands end with ; or \g.
> >> Your MySQL connection id is 23
> >> Server version: 5.0.51a-3ubuntu5.4-log (Ubuntu)
> >>
> >> Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
> >>
> >> mysql> show databases;
> >> +--------------------+
> >> | Database           |
> >> +--------------------+
> >> | information_schema |
> >> | SMSIN              |
> >> | mysql              |
> >> +--------------------+
> >> 3 rows in set (0.00 sec)
> >>
> >> mysql>
> >>
>
> ############################################################################################
> >>
> >> I get the below issue in the collectd.log
> >>
> >> [2009-12-21 03:12:22] mysql_real_connect failed: Access denied for
> >> user 'root'@'localhost' (using password: NO)
> >> [2009-12-21 03:12:22] read-function of plugin `mysql' failed. Will
> >> suspend it for 10 seconds.
> >>
> >> I am not able to figure out why i get root@localhost and not
> >> nagios@localhost in the collectd.log file even after specifying it in
> >> the collectd.conf file.
> >>
> >> Please suggest/guide.
> >>
> >> Thanks,
> >>
> >> Kaushal
> >>
> >
> > Hi Again,
> >
> > Any updates to my earlier post to this Mailing List ?
> >
> > Thanks,
> >
> > Kaushal
> >
>
> Hi Again,
>
> I have not got any reply for my query. Checking in again on this Mailing
> List.
>
> Thanks,
>
> Kaushal
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/mysql?unsub=1
>
>


-- 
-----------------------------
Johnny Withers
601.209.4985
johnny@stripped

Thread
MySQL PluginKaushal Shriyan23 Dec
  • Re: MySQL PluginKaushal Shriyan27 Dec
    • Re: MySQL PluginKaushal Shriyan30 Dec
      • Re: MySQL PluginJohnny Withers30 Dec