MySQL Plugin
am 23.12.2009 13:08:05 von Kaushal Shriyan
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.
############################################################ ################################
Host "localhost"
User "nagios"
Password ""
Database "smspay"
Socket "/var/run/mysqld/mysqld1.sock"
# MasterStats true
#
Host "localhost"
User "nagios"
Password ""
Database "smsin"
Socket "/var/run/mysql/mysqld2.sock"
# SlaveStats true
# SlaveNotifications true
# 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
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org
Re: MySQL Plugin
am 27.12.2009 06:10:40 von Kaushal Shriyan
On Wed, Dec 23, 2009 at 5:38 PM, Kaushal Shriyan
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.
>
> ############################################################ #############=
###################
>
> =A0 =A0 =A0
> =A0 =A0 =A0 =A0 =A0 =A0 =A0 Host "localhost"
> =A0 =A0 =A0 =A0 =A0 =A0 =A0 User "nagios"
> =A0 =A0 =A0 =A0 =A0 =A0 =A0 Password ""
> =A0 =A0 =A0 =A0 =A0 =A0 =A0 Database "smspay"
> =A0 =A0 =A0 =A0 =A0 =A0 =A0 Socket "/var/run/mysqld/mysqld1.sock"
> # =A0 =A0 =A0 =A0 =A0 =A0 =A0 MasterStats true
> =A0 =A0 =A0
> #
> =A0 =A0 =A0
> =A0 =A0 =A0 =A0 =A0 =A0 =A0 Host "localhost"
> =A0 =A0 =A0 =A0 =A0 =A0 =A0 User "nagios"
> =A0 =A0 =A0 =A0 =A0 =A0 =A0 Password ""
> =A0 =A0 =A0 =A0 =A0 =A0 =A0 Database "smsin"
> =A0 =A0 =A0 =A0 =A0 =A0 =A0 Socket "/var/run/mysql/mysqld2.sock"
> # =A0 =A0 =A0 =A0 =A0 =A0 =A0 SlaveStats true
> # =A0 =A0 =A0 =A0 =A0 =A0 =A0 SlaveNotifications true
> =A0 =A0 =A0
>
>
> # mysql -u nagios -h localhost -S /var/run/mysqld/mysqld1.sock
> Welcome to the MySQL monitor. =A0Commands 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 =A0 =A0 =A0 =A0 =A0 |
> +--------------------+
> | information_schema |
> | SMSPAY =A0 =A0 =A0 =A0 =A0 =A0 |
> | mysql =A0 =A0 =A0 =A0 =A0 =A0 =A0|
> +--------------------+
> 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. =A0Commands 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 =A0 =A0 =A0 =A0 =A0 |
> +--------------------+
> | information_schema |
> | SMSIN =A0 =A0 =A0 =A0 =A0 =A0 =A0|
> | mysql =A0 =A0 =A0 =A0 =A0 =A0 =A0|
> +--------------------+
> 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
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dgcdmg-mysql-2@m.gmane.o rg
Re: MySQL Plugin
am 30.12.2009 05:38:45 von Kaushal Shriyan
On Sun, Dec 27, 2009 at 10:40 AM, Kaushal Shriyan
wrote:
> On Wed, Dec 23, 2009 at 5:38 PM, Kaushal Shriyan
> 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.
>>
>> ############################################################ ############=
####################
>>
>> =A0 =A0 =A0
>> =A0 =A0 =A0 =A0 =A0 =A0 =A0 Host "localhost"
>> =A0 =A0 =A0 =A0 =A0 =A0 =A0 User "nagios"
>> =A0 =A0 =A0 =A0 =A0 =A0 =A0 Password ""
>> =A0 =A0 =A0 =A0 =A0 =A0 =A0 Database "smspay"
>> =A0 =A0 =A0 =A0 =A0 =A0 =A0 Socket "/var/run/mysqld/mysqld1.sock"
>> # =A0 =A0 =A0 =A0 =A0 =A0 =A0 MasterStats true
>> =A0 =A0 =A0
>> #
>> =A0 =A0 =A0
>> =A0 =A0 =A0 =A0 =A0 =A0 =A0 Host "localhost"
>> =A0 =A0 =A0 =A0 =A0 =A0 =A0 User "nagios"
>> =A0 =A0 =A0 =A0 =A0 =A0 =A0 Password ""
>> =A0 =A0 =A0 =A0 =A0 =A0 =A0 Database "smsin"
>> =A0 =A0 =A0 =A0 =A0 =A0 =A0 Socket "/var/run/mysql/mysqld2.sock"
>> # =A0 =A0 =A0 =A0 =A0 =A0 =A0 SlaveStats true
>> # =A0 =A0 =A0 =A0 =A0 =A0 =A0 SlaveNotifications true
>> =A0 =A0 =A0
>>
>>
>> # mysql -u nagios -h localhost -S /var/run/mysqld/mysqld1.sock
>> Welcome to the MySQL monitor. =A0Commands 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 =A0 =A0 =A0 =A0 =A0 |
>> +--------------------+
>> | information_schema |
>> | SMSPAY =A0 =A0 =A0 =A0 =A0 =A0 |
>> | mysql =A0 =A0 =A0 =A0 =A0 =A0 =A0|
>> +--------------------+
>> 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. =A0Commands 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 =A0 =A0 =A0 =A0 =A0 |
>> +--------------------+
>> | information_schema |
>> | SMSIN =A0 =A0 =A0 =A0 =A0 =A0 =A0|
>> | mysql =A0 =A0 =A0 =A0 =A0 =A0 =A0|
>> +--------------------+
>> 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 Li=
st.
Thanks,
Kaushal
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dgcdmg-mysql-2@m.gmane.o rg
Re: MySQL Plugin
am 30.12.2009 18:03:31 von Johnny Withers
--0016e6d64b183e67a8047bf51eba
Content-Type: text/plain; charset=ISO-8859-1
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
wrote:
> On Sun, Dec 27, 2009 at 10:40 AM, Kaushal Shriyan
> wrote:
> > On Wed, Dec 23, 2009 at 5:38 PM, Kaushal Shriyan
> > 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.
> >>
> >>
> ############################################################ ################################
> >>
> >>
> >> Host "localhost"
> >> User "nagios"
> >> Password ""
> >> Database "smspay"
> >> Socket "/var/run/mysqld/mysqld1.sock"
> >> # MasterStats true
> >>
> >> #
> >>
> >> Host "localhost"
> >> User "nagios"
> >> Password ""
> >> Database "smsin"
> >> Socket "/var/run/mysql/mysqld2.sock"
> >> # SlaveStats true
> >> # SlaveNotifications true
> >>
> >>
> >>
> >> # 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=johnny@pixelated.net
>
>
--
-----------------------------
Johnny Withers
601.209.4985
johnny@pixelated.net
--0016e6d64b183e67a8047bf51eba--