OpenNMS › OpenNMS - discuss

MYSQL MONITORING WITH OPENNMS

Classic

List

Threaded

24 messages Options

Kashif Hameed-2

MYSQL MONITORING WITH OPENNMS

Dear All,

Anybody monitor mysql in opennms. If anybody have done it please let me give all steps. I have already checked opennms wiki documentation but jetty server is not running php file so that how this document work please advise.

http://www.opennms.org/wiki/Monitoring_MySQL

Shruthi have u done mysql monitoring. Any idea

Thanks

------------------------------------------------------------------------------
Learn how Oracle Real Application Clusters (RAC) One Node allows customers
to consolidate database storage, standardize their database environment, and,
should the need arise, upgrade to a full multi-node Oracle RAC database
without downtime or disruption
http://p.sf.net/sfu/oracle-sfdevnl
_______________________________________________
Please read the OpenNMS Mailing List FAQ:
http://www.opennms.org/index.php/Mailing_List_FAQ

opennms-discuss mailing list

To *unsubscribe* or change your subscription options, see the bottom of this page:
https://lists.sourceforge.net/lists/listinfo/opennms-discuss

Klaus Steden

Re: MYSQL MONITORING WITH OPENNMS

RE: [opennms-discuss] MYSQL MONITORING WITH OPENNMS

I've done this with the HTTP monitor.

What I did in a nutshell was write a quick PHP script to do a direct MySQL status query, set that up as a vhost on my MySQL server, and then instructed OpenNMS how to parse the output using varbinds. There's a more comprehensive document (which I used as reference) on the Wiki.

hth,
Klaus

-----Original Message-----
From: Kashif Hameed [[hidden email]]
Sent: Thu 12/23/2010 11:32 PM
To: [hidden email]
Cc: [hidden email]
Subject: [opennms-discuss] MYSQL MONITORING WITH OPENNMS

Dear All,

Anybody monitor mysql in opennms. If anybody have done it please let me give
all steps. I have already checked opennms wiki documentation but jetty
server is not running php file so that how this document work please advise.

http://www.opennms.org/wiki/Monitoring_MySQL

Shruthi have u done mysql monitoring. Any idea

Thanks

Shruthi

Re: MYSQL MONITORING WITH OPENNMS

In reply to this post by Kashif Hameed-2

Yes i monitor MySQL in OpenNMS

i did the following changes in the following files.
1. capsd-configuration.xml

<protocol-plugin protocol="MySQL" class-name="org.opennms.netmgt.capsd.plugins.TcpPlugin" scan="on">
<property key="banner" value="*" />
<property key="port" value="3306" /> (TCP port in which MySQL is Running..By Default-3306)
<property key="timeout" value="3000" />
<property key="retry" value="1" />
</protocol-plugin>

2.poller-configuration.xml

<service name="MySQL" interval="300000" user-defined="false" status="on">
<parameter key="retry" value="1" />
<parameter key="timeout" value="3000" />
<parameter key="port" value="3306" />
<parameter key="banner" value="*" />
</service>
'
'
'
'
<monitor service="MySQL" class-name="org.opennms.netmgt.poller.monitors.TcpMonitor" />

3.Restart OpenNMS & Rescan the device.

This is all that i did to monitor MySQL.

Regards,
Shruthi Hegde
IMSG,
Reliance Tech Services,
DAKC, Navi Mumbai
Ph:022-30382970

3G services now launched in Delhi, Mumbai, Kolkata and Chandigarh...

"Kashif Hameed-2 [via OpenNMS]" <[hidden email]>

12-24-10 07:50 PM

To	Shruthi <[hidden email]>
cc
Subject	MYSQL MONITORING WITH OPENNMS

Dear All,

http://www.opennms.org/wiki/Monitoring_MySQL

Shruthi have u done mysql monitoring. Any idea

Thanks

View message @ http://opennms.530661.n2.nabble.com/MYSQL-MONITORING-WITH-OPENNMS-tp5865036p5865036.html
To start a new topic under OpenNMS, email [hidden email]
To unsubscribe from OpenNMS, click here.

The information contained in this e-mail message is intended only for the use of the individual or entity to which it is addressed. If you are not the intended recipient, you should return it to the sender immediately. Please note that while we scan all e-mails for viruses we cannot guarantee that any e-mail is virus-free and accept no liability for any damage caused by any virus transmitted by this email.

kashif hameed

Re: MYSQL MONITORING WITH OPENNMS

From: Shruthi <[hidden email]>
Subject: Re: [opennms-discuss] MYSQL MONITORING WITH OPENNMS
To: [hidden email]
Date: Sunday, December 26, 2010, 9:03 PM

Yes i monitor MySQL in OpenNMS

i did the following changes in the following files.
1. capsd-configuration.xml

<protocol-plugin protocol="MySQL" class-name="org.opennms.netmgt.capsd.plugins.TcpPlugin" scan="on">
<property key="banner" value="*" />
<property key="port" value="3306" /> (TCP port in which MySQL is Running..By Default-3306)
<property key="timeout" value="3000" />
<property key="retry" value="1" />
</protocol-plugin>

2.poller-configuration.xml

<service name="MySQL" interval="300000" user-defined="false" status="on">
<parameter key="retry" value="1" />
<parameter key="timeout" value="3000" />
<parameter key="port" value="3306" />
<parameter key="banner" value="*" />
</service>
'
'
'
'
<monitor service="MySQL" class-name="org.opennms.netmgt.poller.monitors.TcpMonitor" />

3.Restart OpenNMS & Rescan the device.

This is all that i did to monitor MySQL.

Regards,
Shruthi Hegde
IMSG,
Reliance Tech Services,
DAKC, Navi Mumbai
Ph:022-30382970

3G services now launched in Delhi, Mumbai, Kolkata and Chandigarh...

"Kashif Hameed-2 [via OpenNMS]" <[hidden email]>
12-24-10 07:50 PM
To
Shruthi <[hidden email]>
cc

Subject
MYSQL MONITORING WITH OPENNMS

<style>  </style>
Dear All,

Anybody monitor mysql in opennms. If anybody have done it please let me give all steps. I have already checked opennms wiki documentation but jetty server is not running php file so that how this document work please advise.

http://www.opennms.org/wiki/Monitoring_MySQL

Shruthi have u done mysql monitoring. Any idea

Thanks

------------------------------------------------------------------------------
Learn how Oracle Real Application Clusters (RAC) One Node allows customers
to consolidate database storage, standardize their database environment, and,
should the need arise, upgrade to a full multi-node Oracle RAC database
without downtime or disruption
http://p.sf.net/sfu/oracle-sfdevnl
_______________________________________________
Please read the OpenNMS Mailing List FAQ:
http://www.opennms.org/index.php/Mailing_List_FAQ

opennms-discuss mailing list

To *unsubscribe* or change your subscription options, see the bottom of this page:
https://lists.sourceforge.net/lists/listinfo/opennms-discuss

View message @ http://opennms.530661.n2.nabble.com/MYSQL-MONITORING-WITH-OPENNMS-tp5865036p5865036.html
To start a new topic under OpenNMS, email [hidden email]
To unsubscribe from OpenNMS, click here.

The information contained in this e-mail message is intended only for the use of the individual or entity to which it is addressed. If you are not the intended recipient, you should return it to the sender immediately. Please note that while we scan all e-mails for viruses we cannot guarantee that any e-mail is virus-free and accept no liability for any damage caused by any virus transmitted by this email.

View this message in context: Re: MYSQL MONITORING WITH OPENNMS
Sent from the OpenNMS - discuss mailing list archive at Nabble.com.

-----Inline Attachment Follows-----

------------------------------------------------------------------------------
Learn how Oracle Real Application Clusters (RAC) One Node allows customers
to consolidate database storage, standardize their database environment, and,
should the need arise, upgrade to a full multi-node Oracle RAC database
without downtime or disruption
http://p.sf.net/sfu/oracle-sfdevnl

-----Inline Attachment Follows-----

_______________________________________________
Please read the OpenNMS Mailing List FAQ:
http://www.opennms.org/index.php/Mailing_List_FAQ

opennms-discuss mailing list

To *unsubscribe* or change your subscription options, see the bottom of this page:
https://lists.sourceforge.net/lists/listinfo/opennms-discuss

kashif hameed

Re: MYSQL MONITORING WITH OPENNMS

In reply to this post by Klaus Steden

Thanks man i want to monitor mysql so could you help me that how can i do this please send me all etc files in which you have made changes

Thanks

--- On Fri, 12/24/10, Klaus Steden <[hidden email]> wrote:

From: Klaus Steden <[hidden email]>
Subject: Re: [opennms-discuss] MYSQL MONITORING WITH OPENNMS
To: "General OpenNMS Discussion" <[hidden email]>, [hidden email]
Cc: [hidden email]
Date: Friday, December 24, 2010, 2:18 PM

RE: [opennms-discuss] MYSQL MONITORING WITH OPENNMS

I've done this with the HTTP monitor.

What I did in a nutshell was write a quick PHP script to do a direct MySQL status query, set that up as a vhost on my MySQL server, and then instructed OpenNMS how to parse the output using varbinds. There's a more comprehensive document (which I used as reference) on the Wiki.

hth,
Klaus

-----Original Message-----
From: Kashif Hameed [[hidden email]]
Sent: Thu 12/23/2010 11:32 PM
To: [hidden email]
Cc: [hidden email]
Subject: [opennms-discuss] MYSQL MONITORING WITH OPENNMS

Dear All,

Anybody monitor mysql in opennms. If anybody have done it please let me give
all steps. I have already checked opennms wiki documentation but jetty
server is not running php file so that how this document work please advise.

http://www.opennms.org/wiki/Monitoring_MySQL

Shruthi have u done mysql monitoring. Any idea

Thanks

-----Inline Attachment Follows-----

------------------------------------------------------------------------------
Learn how Oracle Real Application Clusters (RAC) One Node allows customers
to consolidate database storage, standardize their database environment, and,
should the need arise, upgrade to a full multi-node Oracle RAC database
without downtime or disruption
http://p.sf.net/sfu/oracle-sfdevnl

-----Inline Attachment Follows-----

_______________________________________________
Please read the OpenNMS Mailing List FAQ:
http://www.opennms.org/index.php/Mailing_List_FAQ

opennms-discuss mailing list

To *unsubscribe* or change your subscription options, see the bottom of this page:
https://lists.sourceforge.net/lists/listinfo/opennms-discuss

Shruthi

Re: MYSQL MONITORING WITH OPENNMS

In reply to this post by kashif hameed

The code snippet given below is to monitor MySQL service.Changes has to be made in XML files.
Below link you have given in which changes had to be made xml files like

1 .capsd-configuration.xml
2 .http-datacollection-config.xml
3 .collectd-configuration.xml

These changes are made to get snmp-graphs to monitor MySQL.I have not yet implemented that.

Regards,
Shruthi Hegde
IMSG,
Reliance Tech Services,
DAKC, Navi Mumbai
Ph:022-30382970

3G services now launched in Delhi, Mumbai, Kolkata and Chandigarh...

"kashif hameed [via OpenNMS]" <[hidden email]>

12-28-10 10:36 AM

To	Shruthi <[hidden email]>
cc
Subject	Re: MYSQL MONITORING WITH OPENNMS

Shruthi thanks for your email but how could you monitor this because if you see wiki document on opennms documentation it will show that php pages but if you are using opennms and default web server for opennms is jetty server so jetty is not supported php files so how could you integerate php with jetty or you are using apache tomcat external server.

Thanks

--- On Sun, 12/26/10, Shruthi <[hidden email]> wrote:

From: Shruthi <[hidden email]>
Subject: Re: [opennms-discuss] MYSQL MONITORING WITH OPENNMS
To: [hidden email]
Date: Sunday, December 26, 2010, 9:03 PM

Yes i monitor MySQL in OpenNMS

i did the following changes in the following files.
1. capsd-configuration.xml

<protocol-plugin protocol="MySQL" class-name="org.opennms.netmgt.capsd.plugins.TcpPlugin" scan="on">
<property key="banner" value="*" />
<property key="port" value="3306" /> (TCP port in which MySQL is Running..By Default-3306)
<property key="timeout" value="3000" />
<property key="retry" value="1" />
</protocol-plugin>

2.poller-configuration.xml

<service name="MySQL" interval="300000" user-defined="false" status="on">
<parameter key="retry" value="1" />
<parameter key="timeout" value="3000" />
<parameter key="port" value="3306" />
<parameter key="banner" value="*" />
</service>
'
'
'
'
<monitor service="MySQL" class-name="org.opennms.netmgt.poller.monitors.TcpMonitor" />

3.Restart OpenNMS & Rescan the device.

This is all that i did to monitor MySQL.

Regards,
Shruthi Hegde
IMSG,
Reliance Tech Services,
DAKC, Navi Mumbai
Ph:022-30382970

3G services now launched in Delhi, Mumbai, Kolkata and Chandigarh...

"Kashif Hameed-2 [via OpenNMS]" <[hidden email]>

12-24-10 07:50 PM

To	Shruthi <[hidden email]>
cc
Subject	MYSQL MONITORING WITH OPENNMS

Dear All,

http://www.opennms.org/wiki/Monitoring_MySQL

Shruthi have u done mysql monitoring. Any idea

Thanks

View message @ http://opennms.530661.n2.nabble.com/MYSQL-MONITORING-WITH-OPENNMS-tp5865036p5865036.html
To start a new topic under OpenNMS, email [hidden email]
href="https://lists.sourceforge.net/lists/listinfo/opennms-discuss" target="_blank" rel="nofollow" link="external">https://lists.sourceforge.net/lists/listinfo/opennms-discuss

View message @ http://opennms.530661.n2.nabble.com/MYSQL-MONITORING-WITH-OPENNMS-tp5865036p5871128.html
To start a new topic under OpenNMS, email [hidden email]
To unsubscribe from OpenNMS, click here.

The information contained in this e-mail message is intended only for the use of the individual or entity to which it is addressed. If you are not the intended recipient, you should return it to the sender immediately. Please note that while we scan all e-mails for viruses we cannot guarantee that any e-mail is virus-free and accept no liability for any damage caused by any virus transmitted by this email.

kashif hameed

Re: MYSQL MONITORING WITH OPENNMS

In reply to this post by kashif hameed

From: kashif hameed <[hidden email]>
Subject: Re: [opennms-discuss] MYSQL MONITORING WITH OPENNMS
To: "General OpenNMS Discussion" <[hidden email]>
Date: Monday, December 27, 2010, 9:02 PM

Shruthi thanks for your email but how could you monitor this because if you see wiki document on opennms documentation it will show that php pages but if you are using opennms and default web server for opennms is jetty server so jetty is not supported php files so how could you integerate php with jetty or you are using apache tomcat external server.

Thanks

--- On Sun, 12/26/10, Shruthi <[hidden email]> wrote:

From: Shruthi <[hidden email]>
Subject: Re: [opennms-discuss] MYSQL MONITORING WITH OPENNMS
To: [hidden email]
Date: Sunday, December 26, 2010, 9:03 PM

Yes i monitor MySQL in OpenNMS

i did the following changes in the following files.
1. capsd-configuration.xml

<protocol-plugin protocol="MySQL" class-name="org.opennms.netmgt.capsd.plugins.TcpPlugin" scan="on">
<property key="banner" value="*" />
<property key="port" value="3306" /> (TCP port in which MySQL is Running..By Default-3306)
<property key="timeout" value="3000" />
<property key="retry" value="1" />
</protocol-plugin>

2.poller-configuration.xml

<service name="MySQL" interval="300000" user-defined="false" status="on">
<parameter key="retry" value="1" />
<parameter key="timeout" value="3000" />
<parameter key="port" value="3306" />
<parameter key="banner" value="*" />
</service>
'
'
'
'
<monitor service="MySQL" class-name="org.opennms.netmgt.poller.monitors.TcpMonitor" />

3.Restart OpenNMS & Rescan the device.

This is all that i did to monitor MySQL.

Regards,
Shruthi Hegde
IMSG,
Reliance Tech Services,
DAKC, Navi Mumbai
Ph:022-30382970

3G services now launched in Delhi, Mumbai, Kolkata and Chandigarh...

"Kashif Hameed-2 [via OpenNMS]" <[hidden email]>
12-24-10 07:50 PM
To
Shruthi <[hidden email]>
cc

Subject
MYSQL MONITORING WITH OPENNMS

<style>  </style>
Dear All,

Anybody monitor mysql in opennms. If anybody have done it please let me give all steps. I have already checked opennms wiki documentation but jetty server is not running php file so that how this document work please advise.

http://www.opennms.org/wiki/Monitoring_MySQL

Shruthi have u done mysql monitoring. Any idea

Thanks

------------------------------------------------------------------------------
Learn how Oracle Real Application Clusters (RAC) One Node allows customers
to consolidate database storage, standardize their database environment, and,
should the need arise, upgrade to a full multi-node Oracle RAC database
without downtime or disruption
http://p.sf.net/sfu/oracle-sfdevnl
_______________________________________________
Please read the OpenNMS Mailing List FAQ:
http://www.opennms.org/index.php/Mailing_List_FAQ

opennms-discuss mailing list

To *unsubscribe* or change your subscription options, see the bottom of this page:
https://lists.sourceforge.net/lists/listinfo/opennms-discuss

View message @ http://opennms.530661.n2.nabble.com/MYSQL-MONITORING-WITH-OPENNMS-tp5865036p5865036.html
To start a new topic under OpenNMS, email [hidden email]
To unsubscribe from OpenNMS, click here.

The information contained in this e-mail message is intended only for the use of the individual or entity to which it is addressed. If you are not the intended recipient, you should return it to the sender immediately. Please note that while we scan all e-mails for viruses we cannot guarantee that any e-mail is virus-free and accept no liability for any damage caused by any virus transmitted by this email.

View this message in context: Re: MYSQL MONITORING WITH OPENNMS
Sent from the OpenNMS - discuss mailing list archive at Nabble.com.

-----Inline Attachment Follows-----

------------------------------------------------------------------------------
Learn how Oracle Real Application Clusters (RAC) One Node allows customers
to consolidate database storage, standardize their database environment, and,
should the need arise, upgrade to a full multi-node Oracle RAC database
without downtime or disruption
http://p.sf.net/sfu/oracle-sfdevnl

-----Inline Attachment Follows-----

_______________________________________________
Please read the OpenNMS Mailing List FAQ:
http://www.opennms.org/index.php/Mailing_List_FAQ

opennms-discuss mailing list

To *unsubscribe* or change your subscription options, see the bottom of this page:
https://lists.sourceforge.net/lists/listinfo/opennms-discuss

-----Inline Attachment Follows-----

------------------------------------------------------------------------------
Learn how Oracle Real Application Clusters (RAC) One Node allows customers
to consolidate database storage, standardize their database environment, and,
should the need arise, upgrade to a full multi-node Oracle RAC database
without downtime or disruption
http://p.sf.net/sfu/oracle-sfdevnl

-----Inline Attachment Follows-----

_______________________________________________
Please read the OpenNMS Mailing List FAQ:
http://www.opennms.org/index.php/Mailing_List_FAQ

opennms-discuss mailing list

To *unsubscribe* or change your subscription options, see the bottom of this page:
https://lists.sourceforge.net/lists/listinfo/opennms-discuss

Shruthi

Re: MYSQL MONITORING WITH OPENNMS

Just the service :(

3G services now launched in Delhi, Mumbai, Kolkata and Chandigarh...

"kashif hameed [via OpenNMS]" <[hidden email]>

12-28-10 11:35 AM

To	Shruthi <[hidden email]>
cc
Subject	Re: MYSQL MONITORING WITH OPENNMS

shruti i have done this but this is not requirment. In order to do this it is only monitiring the service of mysql. I also want to know which what is current status of DB, and how much load on DB.

So u have monitored these kind of things or just monitiored service

Thanks

--- On Mon, 12/27/10, kashif hameed <[hidden email]> wrote:

From: kashif hameed <[hidden email]>
Subject: Re: [opennms-discuss] MYSQL MONITORING WITH OPENNMS
To: "General OpenNMS Discussion" <[hidden email]>
Date: Monday, December 27, 2010, 9:02 PM

"Kashif Hameed-2 [via OpenNMS]" <[hidden email]>

12-24-10 07:50 PM

To	Shruthi <[hidden email]>
cc
Subject	MYSQL MONITORING WITH OPENNMS

Dear All,

http://www.opennms.org/wiki/Monitoring_MySQL

Shruthi have u done mysql monitoring. Any idea

Thanks

View message @ http://opennms.530661.n2.nabble.com/MYSQL-MONITORING-WITH-OPENNMS-tp5865036p5865036.html
To start a new topic under OpenNMS, email [hidden email]
subscription options, see the bottom of this page:
https://lists.sourceforge.net/lists/listinfo/opennms-discuss

-----Inline Attachment Follows-----

------------------------------------------------------------------------------
Learn how Oracle Real Application Clusters (RAC) One Node allows customers
to consolidate database storage, standardize their database environment, and,
should the need arise, upgrade to a full multi-node Oracle RAC database
without downtime or disruption
http://p.sf.net/sfu/oracle-sfdevnl

-----Inline Attachment Follows-----

_______________________________________________
Please read the OpenNMS Mailing List FAQ:
http://www.opennms.org/index.php/Mailing_List_FAQ

opennms-discuss mailing list

To *unsubscribe* or change your subscription options, see the bottom of this page:
https://lists.sourceforge.net/lists/listinfo/opennms-discuss

View message @ http://opennms.530661.n2.nabble.com/MYSQL-MONITORING-WITH-OPENNMS-tp5865036p5871188.html
To start a new topic under OpenNMS, email [hidden email]
To unsubscribe from OpenNMS, click here.

The information contained in this e-mail message is intended only for the use of the individual or entity to which it is addressed. If you are not the intended recipient, you should return it to the sender immediately. Please note that while we scan all e-mails for viruses we cannot guarantee that any e-mail is virus-free and accept no liability for any damage caused by any virus transmitted by this email.

kashif hameed

Re: MYSQL MONITORING WITH OPENNMS

Shruthi is there any exact document man in which we can monitor all required things of mysql in opeenms any your friend who have done this and second question

It is also very important

Q) Have u monitor logs in opeenms. Suppose i want to monitor http logs and every 5 min opennms will check /var/logs/messages file and check if kashif word is found in this file this will fire trigered and send me email. Have u dont this in opeenms

Thanks

--- On Mon, 12/27/10, Shruthi <[hidden email]> wrote:

From: Shruthi <[hidden email]>
Subject: Re: [opennms-discuss] MYSQL MONITORING WITH OPENNMS
To: [hidden email]
Date: Monday, December 27, 2010, 10:56 PM

Just the service :(

3G services now launched in Delhi, Mumbai, Kolkata and Chandigarh...

"kashif hameed [via OpenNMS]" <[hidden email]>
12-28-10 11:35 AM
To
Shruthi <[hidden email]>
cc

Subject
Re: MYSQL MONITORING WITH OPENNMS

shruti i have done this but this is not requirment. In order to do this it is only monitiring the service of mysql. I also want to know which what is current status of DB, and how much load on DB.

So u have monitored these kind of things or just monitiored service

Thanks

--- On Mon, 12/27/10, kashif hameed <[hidden email]> wrote:

From: kashif hameed <[hidden email]>
Subject: Re: [opennms-discuss] MYSQL MONITORING WITH OPENNMS
To: "General OpenNMS Discussion" <[hidden email]>
Date: Monday, December 27, 2010, 9:02 PM

Shruthi thanks for your email but how could you monitor this because if you see wiki document on opennms documentation it will show that php pages but if you are using opennms and default web server for opennms is jetty server so jetty is not supported php files so how could you integerate php with jetty or you are using apache tomcat external server.

Thanks

--- On Sun, 12/26/10, Shruthi <[hidden email]> wrote:

From: Shruthi <[hidden email]>
Subject: Re: [opennms-discuss] MYSQL MONITORING WITH OPENNMS
To: [hidden email]
Date: Sunday, December 26, 2010, 9:03 PM

Yes i monitor MySQL in OpenNMS

i did the following changes in the following files.
1. capsd-configuration.xml

<protocol-plugin protocol="MySQL" class-name="org.opennms.netmgt.capsd.plugins.TcpPlugin" scan="on">
<property key="banner" value="*" />
<property key="port" value="3306" /> (TCP port in which MySQL is Running..By Default-3306)
<property key="timeout" value="3000" />
<property key="retry" value="1" />
</protocol-plugin>

2.poller-configuration.xml

<service name="MySQL" interval="300000" user-defined="false" status="on">
<parameter key="retry" value="1" />
<parameter key="timeout" value="3000" />
<parameter key="port" value="3306" />
<parameter key="banner" value="*" />
</service>
'
'
'
'
<monitor service="MySQL" class-name="org.opennms.netmgt.poller.monitors.TcpMonitor" />

3.Restart OpenNMS & Rescan the device.

This is all that i did to monitor MySQL.

Regards,
Shruthi Hegde
IMSG,
Reliance Tech Services,
DAKC, Navi Mumbai
Ph:022-30382970

3G services now launched in Delhi, Mumbai, Kolkata and Chandigarh...

"Kashif Hameed-2 [via OpenNMS]" <[hidden email]>
12-24-10 07:50 PM

To
Shruthi <[hidden email]>
cc

Subject
MYSQL MONITORING WITH OPENNMS

<style>  </style>
Dear All,

Anybody monitor mysql in opennms. If anybody have done it please let me give all steps. I have already checked opennms wiki documentation but jetty server is not running php file so that how this document work please advise.

http://www.opennms.org/wiki/Monitoring_MySQL

Shruthi have u done mysql monitoring. Any idea

Thanks

------------------------------------------------------------------------------
Learn how Oracle Real Application Clusters (RAC) One Node allows customers
to consolidate database storage, standardize their database environment, and,
should the need arise, upgrade to a full multi-node Oracle RAC database
without downtime or disruption
http://p.sf.net/sfu/oracle-sfdevnl
_______________________________________________
Please read the OpenNMS Mailing List FAQ:
http://www.opennms.org/index.php/Mailing_List_FAQ

opennms-discuss mailing list

To *unsubscribe* or change your subscription options, see the bottom of this page:
https://lists.sourceforge.net/lists/listinfo/opennms-discuss

View message @ http://opennms.530661.n2.nabble.com/MYSQL-MONITORING-WITH-OPENNMS-tp5865036p5865036.html
To start a new topic under OpenNMS, email [hidden email]
subscription options, see the bottom of this page:
https://lists.sourceforge.net/lists/listinfo/opennms-discuss

-----Inline Attachment Follows-----

------------------------------------------------------------------------------
Learn how Oracle Real Application Clusters (RAC) One Node allows customers
to consolidate database storage, standardize their database environment, and,
should the need arise, upgrade to a full multi-node Oracle RAC database
without downtime or disruption
http://p.sf.net/sfu/oracle-sfdevnl

-----Inline Attachment Follows-----

_______________________________________________
Please read the OpenNMS Mailing List FAQ:
http://www.opennms.org/index.php/Mailing_List_FAQ

opennms-discuss mailing list

To *unsubscribe* or change your subscription options, see the bottom of this page:
https://lists.sourceforge.net/lists/listinfo/opennms-discuss

------------------------------------------------------------------------------
Learn how Oracle Real Application Clusters (RAC) One Node allows customers
to consolidate database storage, standardize their database environment, and,
should the need arise, upgrade to a full multi-node Oracle RAC database
without downtime or disruption
http://p.sf.net/sfu/oracle-sfdevnl
_______________________________________________
Please read the OpenNMS Mailing List FAQ:
http://www.opennms.org/index.php/Mailing_List_FAQ

opennms-discuss mailing list

To *unsubscribe* or change your subscription options, see the bottom of this page:
https://lists.sourceforge.net/lists/listinfo/opennms-discuss

View message @ http://opennms.530661.n2.nabble.com/MYSQL-MONITORING-WITH-OPENNMS-tp5865036p5871188.html
To start a new topic under OpenNMS, email [hidden email]
To unsubscribe from OpenNMS, click here.

The information contained in this e-mail message is intended only for the use of the individual or entity to which it is addressed. If you are not the intended recipient, you should return it to the sender immediately. Please note that while we scan all e-mails for viruses we cannot guarantee that any e-mail is virus-free and accept no liability for any damage caused by any virus transmitted by this email.

View this message in context: Re: MYSQL MONITORING WITH OPENNMS
Sent from the OpenNMS - discuss mailing list archive at Nabble.com.

-----Inline Attachment Follows-----

------------------------------------------------------------------------------
Learn how Oracle Real Application Clusters (RAC) One Node allows customers
to consolidate database storage, standardize their database environment, and,
should the need arise, upgrade to a full multi-node Oracle RAC database
without downtime or disruption
http://p.sf.net/sfu/oracle-sfdevnl

-----Inline Attachment Follows-----

_______________________________________________
Please read the OpenNMS Mailing List FAQ:
http://www.opennms.org/index.php/Mailing_List_FAQ

opennms-discuss mailing list

To *unsubscribe* or change your subscription options, see the bottom of this page:
https://lists.sourceforge.net/lists/listinfo/opennms-discuss

Michael Sievers

Re: MYSQL MONITORING WITH OPENNMS

In reply to this post by Shruthi

Hello,

I am using openms to monitor MySQL. What I know about it is wtitten up here:

http://www.opennms.org/wiki/JDBC_Data_Collection

Bye,
Michael

"Shruthi" <[hidden email]> schrieb:

>
>Just the service :(
>
>3G services now launched in Delhi, Mumbai, Kolkata and Chandigarh...
>
>
>
>
>"kashif hameed [via OpenNMS]"
><[hidden email]>
>12-28-10 11:35 AM
>
>To
>Shruthi <[hidden email]>
>cc
>
>Subject
>Re: MYSQL MONITORING WITH OPENNMS
>
>
>
>
>
>
>
>shruti i have done this but this is not requirment. In order to do this
>it
>is only monitiring the service of mysql. I also want to know which what
>is
>current status of DB, and how much load on DB.
>
>So u have monitored these kind of things or just monitiored service
>
>Thanks
>
>
>--- On Mon, 12/27/10, kashif hameed <[hidden email]> wrote:
>
>From: kashif hameed <[hidden email]>
>Subject: Re: [opennms-discuss] MYSQL MONITORING WITH OPENNMS
>To: "General OpenNMS Discussion" <[hidden email]>
>Date: Monday, December 27, 2010, 9:02 PM
>
>
>Shruthi thanks for your email but how could you monitor this because if
>
>you see wiki document on opennms documentation it will show that php
>pages
>but if you are using opennms and default web server for opennms is
>jetty
>server so jetty is not supported php files so how could you integerate
>php
>with jetty or you are using apache tomcat external server.
>
>Thanks
>
>
>--- On Sun, 12/26/10, Shruthi <[hidden email]> wrote:
>
>From: Shruthi <[hidden email]>
>Subject: Re: [opennms-discuss] MYSQL MONITORING WITH OPENNMS
>To: [hidden email]
>Date: Sunday, December 26, 2010, 9:03 PM
>
>Yes i monitor MySQL in OpenNMS
>
>i did the following changes in the following files.
>1. capsd-configuration.xml
>
> <protocol-plugin protocol="MySQL"
>class-name="org.opennms.netmgt.capsd.plugins.TcpPlugin" scan="on">
> <property key="banner" value="*" />
> <property key="port" value="3306" /> (TCP port in which MySQL is
>Running..By Default-3306)
> <property key="timeout" value="3000" />
> <property key="retry" value="1" />
> </protocol-plugin>
>
>2.poller-configuration.xml
>
> <service name="MySQL" interval="300000" user-defined="false"
>status="on">
> <parameter key="retry" value="1" />
> <parameter key="timeout" value="3000" />
> <parameter key="port" value="3306" />
> <parameter key="banner" value="*" />
> </service>
>'
>'
>'
>'
><monitor service="MySQL"
>class-name="org.opennms.netmgt.poller.monitors.TcpMonitor" />
>
>3.Restart OpenNMS & Rescan the device.
>
>This is all that i did to monitor MySQL.
>
>Regards,
>Shruthi Hegde
>IMSG,
>Reliance Tech Services,
>DAKC, Navi Mumbai
>Ph:022-30382970
>
>3G services now launched in Delhi, Mumbai, Kolkata and Chandigarh...
>
>
>
>
>
>
>"Kashif Hameed-2 [via OpenNMS]" <[hidden email]>
>12-24-10 07:50 PM
>
>
>To
>Shruthi <[hidden email]>
>cc
>
>Subject
>MYSQL MONITORING WITH OPENNMS
>
>
>
>
>
>
>
>
><style> 
></style>
>Dear All,
>
>Anybody monitor mysql in opennms. If anybody have done it please let me
>
>give all steps. I have already checked opennms wiki documentation but
>jetty server is not running php file so that how this document work
>please
>advise.
>
>http://www.opennms.org/wiki/Monitoring_MySQL
>
>Shruthi have u done mysql monitoring. Any idea
>
>Thanks
>
>
>------------------------------------------------------------------------------
>
>
>Learn how Oracle Real Application Clusters (RAC) One Node allows
>customers
>
>to consolidate database storage, standardize their database
>environment,
>and,
>should the need arise, upgrade to a full multi-node Oracle RAC database
>
>without downtime or disruption
>http://p.sf.net/sfu/oracle-sfdevnl
>_______________________________________________
>Please read the OpenNMS Mailing List FAQ:
>http://www.opennms.org/index.php/Mailing_List_FAQ
>
>opennms-discuss mailing list
>
>To *unsubscribe* or change your subscription options, see the bottom of
>
>this page:
>https://lists.sourceforge.net/lists/listinfo/opennms-discuss
>
>
>View message @
>http://opennms.530661.n2.nabble.com/MYSQL-MONITORING-WITH-OPENNMS-tp5865036p5865036.html
>
>To start a new topic under OpenNMS, email [hidden email]
>subscription options, see the bottom of this page:
>https://lists.sourceforge.net/lists/listinfo/opennms-discuss
>
>
>-----Inline Attachment Follows-----
>
>------------------------------------------------------------------------------
>Learn how Oracle Real Application Clusters (RAC) One Node allows
>customers
>to consolidate database storage, standardize their database
>environment,
>and,
>should the need arise, upgrade to a full multi-node Oracle RAC database
>
>without downtime or disruption
>http://p.sf.net/sfu/oracle-sfdevnl
>
>-----Inline Attachment Follows-----
>
>_______________________________________________
>Please read the OpenNMS Mailing List FAQ:
>http://www.opennms.org/index.php/Mailing_List_FAQ
>
>opennms-discuss mailing list
>
>To *unsubscribe* or change your subscription options, see the bottom of
>
>this page:
>https://lists.sourceforge.net/lists/listinfo/opennms-discuss
>
>
>------------------------------------------------------------------------------
>
>
>Learn how Oracle Real Application Clusters (RAC) One Node allows
>customers
>
>to consolidate database storage, standardize their database
>environment,
>and,
>should the need arise, upgrade to a full multi-node Oracle RAC database
>
>without downtime or disruption
>http://p.sf.net/sfu/oracle-sfdevnl
>_______________________________________________
>Please read the OpenNMS Mailing List FAQ:
>http://www.opennms.org/index.php/Mailing_List_FAQ
>
>opennms-discuss mailing list
>
>To *unsubscribe* or change your subscription options, see the bottom of
>
>this page:
>https://lists.sourceforge.net/lists/listinfo/opennms-discuss
>
>
>View message @
>http://opennms.530661.n2.nabble.com/MYSQL-MONITORING-WITH-OPENNMS-tp5865036p5871188.html
>
>To start a new topic under OpenNMS, email
>[hidden email]
>To unsubscribe from OpenNMS, click here.
>
>
>
>
>The information contained in this e-mail message is intended only for
>the use of the individual or entity to which it is addressed. If you
>are not the intended recipient, you should return it to the sender
>immediately. Please note that while we scan all e-mails for viruses we
>cannot guarantee that any e-mail is virus-free and accept no liability
>for any damage caused by any virus transmitted by this email.
>
>--
>View this message in context:
>http://opennms.530661.n2.nabble.com/MYSQL-MONITORING-WITH-OPENNMS-tp5865036p5871236.html
>Sent from the OpenNMS - discuss mailing list archive at Nabble.com.
>------------------------------------------------------------------------------
>Learn how Oracle Real Application Clusters (RAC) One Node allows
>customers
>to consolidate database storage, standardize their database
>environment, and,
>should the need arise, upgrade to a full multi-node Oracle RAC database
>
>without downtime or disruption
>http://p.sf.net/sfu/oracle-sfdevnl_______________________________________________
>Please read the OpenNMS Mailing List FAQ:
>http://www.opennms.org/index.php/Mailing_List_FAQ
>
>opennms-discuss mailing list
>
>To *unsubscribe* or change your subscription options, see the bottom of
>this page:
>https://lists.sourceforge.net/lists/listinfo/opennms-discuss

kashif hameed

Re: MYSQL MONITORING WITH OPENNMS

Have u done this document or nor if yes then send me your configuration files i will check and configured them accordingly.

I am going to attach the node graph in your email. Please check it here is the resource graph which is in my opennms. NOCSERVER is the node name and in this node mysql is running kindly like this you send me that how your node is seeing in resource graph. please send me as soon as

U have skype id can u comeonline right now i am online oin skype if you have time just come online. my skype is = kashhhhhhh

Please send me scan image of your node plz

Thanks

--- On Mon, 12/27/10, Michael Sievers <[hidden email]> wrote:

From: Michael Sievers <[hidden email]>
Subject: Re: [opennms-discuss] MYSQL MONITORING WITH OPENNMS
To: "General OpenNMS Discussion" <[hidden email]>
Date: Monday, December 27, 2010, 11:42 PM

Hello,

I am using openms to monitor MySQL. What I know about it is wtitten up here:

http://www.opennms.org/wiki/JDBC_Data_Collection

Bye,
Michael

"Shruthi" <shruthi.b.hegde@...> schrieb:

>
>Just the service :(
>
>3G services now launched in Delhi, Mumbai, Kolkata and Chandigarh...
>
>
>
>
>"kashif hameed [via OpenNMS]"
><ml-node+5871188-408923121-124059@...>
>12-28-10 11:35 AM
>
>To
>Shruthi <shruthi.b.hegde@...>
>cc
>
>Subject
>Re: MYSQL MONITORING WITH OPENNMS
>
>
>
>
>
>
>
>shruti i have done this but this is not requirment. In order to do this
>it
>is only monitiring the service of mysql. I also want to know which what
>is
>current status of DB, and how much load on DB.
>
>So u have monitored these kind of things or just monitiored service
>
>Thanks
>
>
>--- On Mon, 12/27/10, kashif hameed <[hidden email]> wrote:
>
>From: kashif hameed <[hidden email]>
>Subject: Re: [opennms-discuss] MYSQL MONITORING WITH OPENNMS
>To: "General OpenNMS Discussion" <[hidden email]>
>Date: Monday, December 27, 2010, 9:02 PM
>
>
>Shruthi thanks for your email but how could you monitor this because if
>
>you see wiki document on opennms documentation it will show that php
>pages
>but if you are using opennms and default web server for opennms is
>jetty
>server so jetty is not supported php files so how could you integerate
>php
>with jetty or you are using apache tomcat external server.
>
>Thanks
>
>
>--- On Sun, 12/26/10, Shruthi <[hidden email]> wrote:
>
>From: Shruthi <[hidden email]>
>Subject: Re: [opennms-discuss] MYSQL MONITORING WITH OPENNMS
>To: [hidden email]
>Date: Sunday, December 26, 2010, 9:03 PM
>
>Yes i monitor MySQL in OpenNMS
>
>i did the following changes in the following files.
>1. capsd-configuration.xml
>
> <protocol-plugin protocol="MySQL"
>class-name="org.opennms.netmgt.capsd.plugins.TcpPlugin" scan="on">
> <property key="banner" value="*" />
> <property key="port" value="3306" /> (TCP port in which MySQL is
>Running..By Default-3306)
> <property key="timeout" value="3000" />
> <property key="retry" value="1" />
> </protocol-plugin>
>
>2.poller-configuration.xml
>
> <service name="MySQL" interval="300000" user-defined="false"
>status="on">
> <parameter key="retry" value="1" />
> <parameter key="timeout" value="3000" />
> <parameter key="port" value="3306" />
> <parameter key="banner" value="*" />
> </service>
>'
>'
>'
>'
><monitor service="MySQL"
>class-name="org.opennms.netmgt.poller.monitors.TcpMonitor" />
>
>3.Restart OpenNMS & Rescan the device.
>
>This is all that i did to monitor MySQL.
>
>Regards,
>Shruthi Hegde
>IMSG,
>Reliance Tech Services,
>DAKC, Navi Mumbai
>Ph:022-30382970
>
>3G services now launched in Delhi, Mumbai, Kolkata and Chandigarh...
>
>
>
>
>
>
>"Kashif Hameed-2 [via OpenNMS]" <[hidden email]>
>12-24-10 07:50 PM
>
>
>To
>Shruthi <[hidden email]>
>cc
>
>Subject
>MYSQL MONITORING WITH OPENNMS
>
>
>
>
>
>
>
>
><style> 
></style>
>Dear All,
>
>Anybody monitor mysql in opennms. If anybody have done it please let me
>
>give all steps. I have already checked opennms wiki documentation but
>jetty server is not running php file so that how this document work
>please
>advise.
>
>http://www.opennms.org/wiki/Monitoring_MySQL
>
>Shruthi have u done mysql monitoring. Any idea
>
>Thanks
>
>
>------------------------------------------------------------------------------
>
>
>Learn how Oracle Real Application Clusters (RAC) One Node allows
>customers
>
>to consolidate database storage, standardize their database
>environment,
>and,
>should the need arise, upgrade to a full multi-node Oracle RAC database
>
>without downtime or disruption
>http://p.sf.net/sfu/oracle-sfdevnl
>_______________________________________________
>Please read the OpenNMS Mailing List FAQ:
>http://www.opennms.org/index.php/Mailing_List_FAQ
>
>opennms-discuss mailing list
>
>To *unsubscribe* or change your subscription options, see the bottom of
>
>this page:
>https://lists.sourceforge.net/lists/listinfo/opennms-discuss
>
>
>View message @
>http://opennms.530661.n2.nabble.com/MYSQL-MONITORING-WITH-OPENNMS-tp5865036p5865036.html
>
>To start a new topic under OpenNMS, email [hidden email]
>subscription options, see the bottom of this page:
>https://lists.sourceforge.net/lists/listinfo/opennms-discuss
>
>
>-----Inline Attachment Follows-----
>
>------------------------------------------------------------------------------
>Learn how Oracle Real Application Clusters (RAC) One Node allows
>customers
>to consolidate database storage, standardize their database
>environment,
>and,
>should the need arise, upgrade to a full multi-node Oracle RAC database
>
>without downtime or disruption
>http://p.sf.net/sfu/oracle-sfdevnl
>
>-----Inline Attachment Follows-----
>
>_______________________________________________
>Please read the OpenNMS Mailing List FAQ:
>http://www.opennms.org/index.php/Mailing_List_FAQ
>
>opennms-discuss mailing list
>
>To *unsubscribe* or change your subscription options, see the bottom of
>
>this page:
>https://lists.sourceforge.net/lists/listinfo/opennms-discuss
>
>
>------------------------------------------------------------------------------
>
>
>Learn how Oracle Real Application Clusters (RAC) One Node allows
>customers
>
>to consolidate database storage, standardize their database
>environment,
>and,
>should the need arise, upgrade to a full multi-node Oracle RAC database
>
>without downtime or disruption
>http://p.sf.net/sfu/oracle-sfdevnl
>_______________________________________________
>Please read the OpenNMS Mailing List FAQ:
>http://www.opennms.org/index.php/Mailing_List_FAQ
>
>opennms-discuss mailing list
>
>To *unsubscribe* or change your subscription options, see the bottom of
>
>this page:
>https://lists.sourceforge.net/lists/listinfo/opennms-discuss
>
>
>View message @
>http://opennms.530661.n2.nabble.com/MYSQL-MONITORING-WITH-OPENNMS-tp5865036p5871188.html
>
>To start a new topic under OpenNMS, email
>ml-node+530661-181856423-124059@...
>To unsubscribe from OpenNMS, click here.
>
>
>
>
>The information contained in this e-mail message is intended only for
>the use of the individual or entity to which it is addressed. If you
>are not the intended recipient, you should return it to the sender
>immediately. Please note that while we scan all e-mails for viruses we
>cannot guarantee that any e-mail is virus-free and accept no liability
>for any damage caused by any virus transmitted by this email.
>
>--
>View this message in context:
>http://opennms.530661.n2.nabble.com/MYSQL-MONITORING-WITH-OPENNMS-tp5865036p5871236.html
>Sent from the OpenNMS - discuss mailing list archive at Nabble.com.
>------------------------------------------------------------------------------
>Learn how Oracle Real Application Clusters (RAC) One Node allows
>customers
>to consolidate database storage, standardize their database
>environment, and,
>should the need arise, upgrade to a full multi-node Oracle RAC database
>
>without downtime or disruption
>http://p.sf.net/sfu/oracle-sfdevnl_______________________________________________
>Please read the OpenNMS Mailing List FAQ:
>http://www.opennms.org/index.php/Mailing_List_FAQ
>
>opennms-discuss mailing list
>
>To *unsubscribe* or change your subscription options, see the bottom of
>this page:
>https://lists.sourceforge.net/lists/listinfo/opennms-discuss

------------------------------------------------------------------------------
Learn how Oracle Real Application Clusters (RAC) One Node allows customers
to consolidate database storage, standardize their database environment, and,
should the need arise, upgrade to a full multi-node Oracle RAC database
without downtime or disruption
http://p.sf.net/sfu/oracle-sfdevnl
_______________________________________________
Please read the OpenNMS Mailing List FAQ:
http://www.opennms.org/index.php/Mailing_List_FAQ

opennms-discuss mailing list

To *unsubscribe* or change your subscription options, see the bottom of this page:
https://lists.sourceforge.net/lists/listinfo/opennms-discuss

Michael Sievers

Re: MYSQL MONITORING WITH OPENNMS

Hello,

My config files are included in the wiki page (please follow the link at the bottom where it says “configuration files for MySQL“). Really, what I know about the subject is in the wiki page and I'm afraid I'm at work so I can't get more involved right now.

Bye,
Michael

"kashif hameed" <[hidden email]> schrieb:

>Have u done this document or nor if yes then send me your configuration
>files i will check and configured them accordingly.
>
>I am going to attach the node graph in your email. Please check it here
>is the resource graph which is in my opennms. NOCSERVER is the node
>name and in this node mysql is running kindly like this you send me
>that how your node is seeing in resource graph. please send me as soon
>as
>
>U have skype id can u comeonline right now i am online oin skype if you
>have time just come online. my skype is = kashhhhhhh
>
>Please send me scan image of your node plz
>
>Thanks
>
>
>--- On Mon, 12/27/10, Michael Sievers <[hidden email]> wrote:
>
>From: Michael Sievers <[hidden email]>
>Subject: Re: [opennms-discuss] MYSQL MONITORING WITH OPENNMS
>To: "General OpenNMS Discussion"
><[hidden email]>
>Date: Monday, December 27, 2010, 11:42 PM
>
>Hello,
>
>I am using openms to monitor MySQL. What I know about it is wtitten up
>here:
>
>http://www.opennms.org/wiki/JDBC_Data_Collection
>
>Bye,
>Michael
>
>
>
>"Shruthi" <[hidden email]> schrieb:
>
>>
>>Just the service :(
>>
>>3G services now launched in Delhi, Mumbai, Kolkata and
>Chandigarh...
>>
>>
>>
>>
>>"kashif hameed [via OpenNMS]"
>><[hidden email]>
>>12-28-10 11:35 AM
>>
>>To
>>Shruthi <[hidden email]>
>>cc
>>
>>Subject
>>Re: MYSQL MONITORING WITH OPENNMS
>>
>>
>>
>>
>>
>>
>>
>>shruti i have done this but this is not requirment. In order to do
>this
>>it
>>is only monitiring the service of mysql. I also want to know which
>what
>>is
>>current status of DB, and how much load on DB.
>>
>>So u have monitored these kind of things or just monitiored service
>>
>>Thanks
>>
>>
>>--- On Mon, 12/27/10, kashif hameed <[hidden email]> wrote:
>>
>>From: kashif hameed <[hidden email]>
>>Subject: Re: [opennms-discuss] MYSQL MONITORING WITH OPENNMS
>>To: "General OpenNMS Discussion" <[hidden email]>
>>Date: Monday, December 27, 2010, 9:02 PM
>>
>>
>>Shruthi thanks for your email but how could you monitor this because
>if
>>
>>you see wiki document on opennms documentation it will show that php
>>pages
>>but if you are using opennms and default web server for opennms is
>>jetty
>>server so jetty is not supported php files so how could you integerate
>>php
>>with jetty or you are using apache tomcat external server.
>>
>>Thanks
>>
>>
>>--- On Sun, 12/26/10, Shruthi <[hidden email]> wrote:
>>
>>From: Shruthi <[hidden email]>
>>Subject: Re: [opennms-discuss] MYSQL MONITORING WITH OPENNMS
>>To: [hidden email]
>>Date: Sunday, December 26, 2010, 9:03 PM
>>
>>Yes i monitor MySQL in OpenNMS
>>
>>i did the following changes in the following files.
>>1. capsd-configuration.xml
>>
>> <protocol-plugin protocol="MySQL"
>>class-name="org.opennms.netmgt.capsd.plugins.TcpPlugin" scan="on">
>> <property key="banner" value="*" />
>> <property key="port" value="3306" /> (TCP port in which MySQL is
>
>>Running..By Default-3306)
>> <property key="timeout" value="3000" />
>> <property key="retry" value="1" />
>> </protocol-plugin>
>>
>>2.poller-configuration.xml
>>
>> <service name="MySQL" interval="300000" user-defined="false"
>>status="on">
>> <parameter key="retry" value="1" />
>> <parameter key="timeout" value="3000" />
>> <parameter key="port" value="3306" />
>> <parameter key="banner" value="*" />
>> </service>
>>'
>>'
>>'
>>'
>><monitor service="MySQL"
>>class-name="org.opennms.netmgt.poller.monitors.TcpMonitor" />
>>
>>3.Restart OpenNMS & Rescan the device.
>>
>>This is all that i did to monitor MySQL.
>>
>>Regards,
>>Shruthi Hegde
>>IMSG,
>>Reliance Tech Services,
>>DAKC, Navi Mumbai
>>Ph:022-30382970
>>
>>3G services now launched in Delhi, Mumbai, Kolkata and
>Chandigarh...
>>
>>
>>
>>
>>
>>
>>"Kashif Hameed-2 [via OpenNMS]" <[hidden email]>
>>12-24-10 07:50 PM
>>
>>
>>To
>>Shruthi <[hidden email]>
>>cc
>>
>>Subject
>>MYSQL MONITORING WITH OPENNMS
>>
>>
>>
>>
>>
>>
>>
>>
>><style> 
>></style>
>>Dear All,
>>
>>Anybody monitor mysql in opennms. If anybody have done it please let
>me
>>
>>give all steps. I have already checked opennms wiki documentation but
>
>>jetty server is not running php file so that how this document work
>>please
>>advise.
>>
>>http://www.opennms.org/wiki/Monitoring_MySQL
>>
>>Shruthi have u done mysql monitoring. Any idea
>>
>>Thanks
>>
>>
>>------------------------------------------------------------------------------
>>
>>
>>Learn how Oracle Real Application Clusters (RAC) One Node allows
>>customers
>>
>>to consolidate database storage, standardize their database
>>environment,
>>and,
>>should the need arise, upgrade to a full multi-node Oracle RAC
>database
>>
>>without downtime or disruption
>>http://p.sf.net/sfu/oracle-sfdevnl
>>_______________________________________________
>>Please read the OpenNMS Mailing List FAQ:
>>http://www.opennms.org/index.php/Mailing_List_FAQ
>>
>>opennms-discuss mailing list
>>
>>To *unsubscribe* or change your subscription options, see the bottom
>of
>>
>>this page:
>>https://lists.sourceforge.net/lists/listinfo/opennms-discuss
>>
>>
>>View message @
>>http://opennms.530661.n2.nabble.com/MYSQL-MONITORING-WITH-OPENNMS-tp5865036p5865036.html
>>
>>To start a new topic under OpenNMS, email [hidden email]
>>subscription options, see the bottom of this page:
>>https://lists.sourceforge.net/lists/listinfo/opennms-discuss
>>
>>
>>-----Inline Attachment Follows-----
>>
>>------------------------------------------------------------------------------
>>Learn how Oracle Real Application Clusters (RAC) One Node allows
>>customers
>>to consolidate database storage, standardize their database
>>environment,
>>and,
>>should the need arise, upgrade to a full multi-node Oracle RAC
>database
>>
>>without downtime or disruption
>>http://p.sf.net/sfu/oracle-sfdevnl
>>
>>-----Inline Attachment Follows-----
>>
>>_______________________________________________
>>Please read the OpenNMS Mailing List FAQ:
>>http://www.opennms.org/index.php/Mailing_List_FAQ
>>
>>opennms-discuss mailing list
>>
>>To *unsubscribe* or change your subscription options, see the bottom
>of
>>
>>this page:
>>https://lists.sourceforge.net/lists/listinfo/opennms-discuss
>>
>>
>>------------------------------------------------------------------------------
>>
>>
>>Learn how Oracle Real Application Clusters (RAC) One Node allows
>>customers
>>
>>to consolidate database storage, standardize their database
>>environment,
>>and,
>>should the need arise, upgrade to a full multi-node Oracle RAC
>database
>>
>>without downtime or disruption
>>http://p.sf.net/sfu/oracle-sfdevnl
>>_______________________________________________
>>Please read the OpenNMS Mailing List FAQ:
>>http://www.opennms.org/index.php/Mailing_List_FAQ
>>
>>opennms-discuss mailing list
>>
>>To *unsubscribe* or change your subscription options, see the bottom
>of
>>
>>this page:
>>https://lists.sourceforge.net/lists/listinfo/opennms-discuss
>>
>>
>>View message @
>>http://opennms.530661.n2.nabble.com/MYSQL-MONITORING-WITH-OPENNMS-tp5865036p5871188.html
>>
>>To start a new topic under OpenNMS, email
>>[hidden email]
>>To unsubscribe from OpenNMS, click here.
>>
>>
>>
>>
>>The information contained in this e-mail message is intended only for
>>the use of the individual or entity to which it is addressed. If you
>>are not the intended recipient, you should return it to the sender
>>immediately. Please note that while we scan all e-mails for viruses we
>>cannot guarantee that any e-mail is virus-free and accept no liability
>>for any damage caused by any virus transmitted by this email.
>>
>>--
>>View this message in context:
>>http://opennms.530661.n2.nabble.com/MYSQL-MONITORING-WITH-OPENNMS-tp5865036p5871236.html
>>Sent from the OpenNMS - discuss mailing list archive at Nabble.com.
>>------------------------------------------------------------------------------
>>Learn how Oracle Real Application Clusters (RAC) One Node allows
>>customers
>>to consolidate database storage, standardize their database
>>environmen

kashif hameed

Re: MYSQL MONITORING WITH OPENNMS

ok u mean to say that if i will change these settings in my opennms then should i able to see the graph of mysql database am i right.

And kindly tell me which documents i should follow
--- On Tue, 12/28/10, Michael Sievers <[hidden email]> wrote:

From: Michael Sievers <[hidden email]>
Subject: Re: [opennms-discuss] MYSQL MONITORING WITH OPENNMS
To: "General OpenNMS Discussion" <[hidden email]>
Date: Tuesday, December 28, 2010, 1:59 AM

Hello,

My config files are included in the wiki page (please follow the link at the bottom where it says “configuration files for MySQL“). Really, what I know about the subject is in the wiki page and I'm afraid I'm at work so I can't get more involved right now.

Bye,
Michael

"kashif hameed" <kashifhameed_2003@...> schrieb:

>Have u done this document or nor if yes then send me your configuration
>files i will check and configured them accordingly.
>
>I am going to attach the node graph in your email. Please check it here
>is the resource graph which is in my opennms. NOCSERVER is the node
>name and in this node mysql is running kindly like this you send me
>that how your node is seeing in resource graph. please send me as soon
>as
>
>U have skype id can u comeonline right now i am online oin skype if you
>have time just come online. my skype is = kashhhhhhh
>
>Please send me scan image of your node plz
>
>Thanks
>
>
>--- On Mon, 12/27/10, Michael Sievers <michael@...> wrote:
>
>From: Michael Sievers <michael@...>
>Subject: Re: [opennms-discuss] MYSQL MONITORING WITH OPENNMS
>To: "General OpenNMS Discussion"
><opennms-discuss@...>
>Date: Monday, December 27, 2010, 11:42 PM
>
>Hello,
>
>I am using openms to monitor MySQL. What I know about it is wtitten up
>here:
>
>http://www.opennms.org/wiki/JDBC_Data_Collection
>
>Bye,
>Michael
>
>
>
>"Shruthi" <shruthi.b.hegde@...> schrieb:
>
>>
>>Just the service :(
>>
>>3G services now launched in Delhi, Mumbai, Kolkata and
>Chandigarh...
>>
>>
>>
>>
>>"kashif hameed [via OpenNMS]"
>><ml-node+5871188-408923121-124059@...>
>>12-28-10 11:35 AM
>>
>>To
>>Shruthi <shruthi.b.hegde@...>
>>cc
>>
>>Subject
>>Re: MYSQL MONITORING WITH OPENNMS
>>
>>
>>
>>
>>
>>
>>
>>shruti i have done this but this is not requirment. In order to do
>this
>>it
>>is only monitiring the service of mysql. I also want to know which
>what
>>is
>>current status of DB, and how much load on DB.
>>
>>So u have monitored these kind of things or just monitiored service
>>
>>Thanks
>>
>>
>>--- On Mon, 12/27/10, kashif hameed <[hidden email]> wrote:
>>
>>From: kashif hameed <[hidden email]>
>>Subject: Re: [opennms-discuss] MYSQL MONITORING WITH OPENNMS
>>To: "General OpenNMS Discussion" <[hidden email]>
>>Date: Monday, December 27, 2010, 9:02 PM
>>
>>
>>Shruthi thanks for your email but how could you monitor this because
>if
>>
>>you see wiki document on opennms documentation it will show that php
>>pages
>>but if you are using opennms and default web server for opennms is
>>jetty
>>server so jetty is not supported php files so how could you integerate
>>php
>>with jetty or you are using apache tomcat external server.
>>
>>Thanks
>>
>>
>>--- On Sun, 12/26/10, Shruthi <[hidden email]> wrote:
>>
>>From: Shruthi <[hidden email]>
>>Subject: Re: [opennms-discuss] MYSQL MONITORING WITH OPENNMS
>>To: [hidden email]
>>Date: Sunday, December 26, 2010, 9:03 PM
>>
>>Yes i monitor MySQL in OpenNMS
>>
>>i did the following changes in the following files.
>>1. capsd-configuration.xml
>>
>> <protocol-plugin protocol="MySQL"
>>class-name="org.opennms.netmgt.capsd.plugins.TcpPlugin" scan="on">
>> <property key="banner" value="*" />
>> <property key="port" value="3306" /> (TCP port in which MySQL is
>
>>Running..By Default-3306)
>> <property key="timeout" value="3000" />
>> <property key="retry" value="1" />
>> </protocol-plugin>
>>
>>2.poller-configuration.xml
>>
>> <service name="MySQL" interval="300000" user-defined="false"
>>status="on">
>> <parameter key="retry" value="1" />
>> <parameter key="timeout" value="3000" />
>> <parameter key="port" value="3306" />
>> <parameter key="banner" value="*" />
>> </service>
>>'
>>'
>>'
>>'
>><monitor service="MySQL"
>>class-name="org.opennms.netmgt.poller.monitors.TcpMonitor" />
>>
>>3.Restart OpenNMS & Rescan the device.
>>
>>This is all that i did to monitor MySQL.
>>
>>Regards,
>>Shruthi Hegde
>>IMSG,
>>Reliance Tech Services,
>>DAKC, Navi Mumbai
>>Ph:022-30382970
>>
>>3G services now launched in Delhi, Mumbai, Kolkata and
>Chandigarh...
>>
>>
>>
>>
>>
>>
>>"Kashif Hameed-2 [via OpenNMS]" <[hidden email]>
>>12-24-10 07:50 PM
>>
>>
>>To
>>Shruthi <[hidden email]>
>>cc
>>
>>Subject
>>MYSQL MONITORING WITH OPENNMS
>>
>>
>>
>>
>>
>>
>>
>>
>><style> 
>></style>
>>Dear All,
>>
>>Anybody monitor mysql in opennms. If anybody have done it please let
>me
>>
>>give all steps. I have already checked opennms wiki documentation but
>
>>jetty server is not running php file so that how this document work
>>please
>>advise.
>>
>>http://www.opennms.org/wiki/Monitoring_MySQL
>>
>>Shruthi have u done mysql monitoring. Any idea
>>
>>Thanks
>>
>>
>>------------------------------------------------------------------------------
>>
>>
>>Learn how Oracle Real Application Clusters (RAC) One Node allows
>>customers
>>
>>to consolidate database storage, standardize their database
>>environment,
>>and,
>>should the need arise, upgrade to a full multi-node Oracle RAC
>database
>>
>>without downtime or disruption
>>http://p.sf.net/sfu/oracle-sfdevnl
>>_______________________________________________
>>Please read the OpenNMS Mailing List FAQ:
>>http://www.opennms.org/index.php/Mailing_List_FAQ
>>
>>opennms-discuss mailing list
>>
>>To *unsubscribe* or change your subscription options, see the bottom
>of
>>
>>this page:
>>https://lists.sourceforge.net/lists/listinfo/opennms-discuss
>>
>>
>>View message @
>>http://opennms.530661.n2.nabble.com/MYSQL-MONITORING-WITH-OPENNMS-tp5865036p5865036.html
>>
>>To start a new topic under OpenNMS, email [hidden email]
>>subscription options, see the bottom of this page:
>>https://lists.sourceforge.net/lists/listinfo/opennms-discuss
>>
>>
>>-----Inline Attachment Follows-----
>>
>>------------------------------------------------------------------------------
>>Learn how Oracle Real Application Clusters (RAC) One Node allows
>>customers
>>to consolidate database storage, standardize their database
>>environment,
>>and,
>>should the need arise, upgrade to a full multi-node Oracle RAC
>database
>>
>>without downtime or disruption
>>http://p.sf.net/sfu/oracle-sfdevnl
>>
>>-----Inline Attachment Follows-----
>>
>>_______________________________________________
>>Please read the OpenNMS Mailing List FAQ:
>>http://www.opennms.org/index.php/Mailing_List_FAQ
>>
>>opennms-discuss mailing list
>>
>>To *unsubscribe* or change your subscription options, see the bottom
>of
>>
>>this page:
>>https://lists.sourceforge.net/lists/listinfo/opennms-discuss
>>
>>
>>------------------------------------------------------------------------------
>>
>>
>>Learn how Oracle Real Application Clusters (RAC) One Node allows
>>customers
>>
>>to consolidate database storage, standardize their database
>>environment,
>>and,
>>should the need arise, upgrade to a full multi-node Oracle RAC
>database
>>
>>without downtime or disruption
>>http://p.sf.net/sfu/oracle-sfdevnl
>>_______________________________________________
>>Please read the OpenNMS Mailing List FAQ:
>>http://www.opennms.org/index.php/Mailing_List_FAQ
>>
>>opennms-discuss mailing list
>>
>>To *unsubscribe* or change your subscription options, see the bottom
>of
>>
>>this page:
>>https://lists.sourceforge.net/lists/listinfo/opennms-discuss
>>
>>
>>View message @
>>http://opennms.530661.n2.nabble.com/MYSQL-MONITORING-WITH-OPENNMS-tp5865036p5871188.html
>>
>>To start a new topic under OpenNMS, email
>>ml-node+530661-181856423-124059@...
>>To unsubscribe from OpenNMS, click here.
>>
>>
>>
>>
>>The information contained in this e-mail message is intended only for
>>the use of the individual or entity to which it is addressed. If you
>>are not the intended recipient, you should return it to the sender
>>immediately. Please note that while we scan all e-mails for viruses we
>>cannot guarantee that any e-mail is virus-free and accept no liability
>>for any damage caused by any virus transmitted by this email.
>>
>>--
>>View this message in context:
>>http://opennms.530661.n2.nabble.com/MYSQL-MONITORING-WITH-OPENNMS-tp5865036p5871236.html
>>Sent from the OpenNMS - discuss mailing list archive at Nabble.com.
>>------------------------------------------------------------------------------
>>Learn how Oracle Real Application Clusters (RAC) One Node allows
>>customers
>>to consolidate database storage, standardize their database
>>environmen

------------------------------------------------------------------------------
Learn how Oracle Real Application Clusters (RAC) One Node allows customers
to consolidate database storage, standardize their database environment, and,
should the need arise, upgrade to a full multi-node Oracle RAC database
without downtime or disruption
http://p.sf.net/sfu/oracle-sfdevnl
_______________________________________________
Please read the OpenNMS Mailing List FAQ:
http://www.opennms.org/index.php/Mailing_List_FAQ

opennms-discuss mailing list

To *unsubscribe* or change your subscription options, see the bottom of this page:
https://lists.sourceforge.net/lists/listinfo/opennms-discuss

Michael Sievers

Re: MYSQL MONITORING WITH OPENNMS

Hello,

at the bottom of
http://www.opennms.org/wiki/JDBC_Data_Collection
there is a link to
http://www.opennms.org/wiki/JDBC_Collection_configuration_for_MySQL
which holds the xml-config-file:

jdbc-datacollection-config.xml

and a longish excerpt of my snmp-graph.properties, where the data collected via JDBCCollector/jdbc-datacollection.config.xml is actually transformed into resource graphs.

Bye,
Michael

----- Ursprüngliche Nachricht -----
Von:
General OpenNMS Discussion <[hidden email]>

An:
"General OpenNMS Discussion" <[hidden email]>
Cc:

Gesendet:
Tue, 28 Dec 2010 03:45:20 -0800 (PST)
Betreff:
Re: [opennms-discuss] MYSQL MONITORING WITH OPENNMS

ok u mean to say that if i will change these settings in my opennms then should i able to see the graph of mysql database am i right.

And kindly tell me which documents i should follow
--- On Tue, 12/28/10, Michael Sievers <[hidden email]> wrote:

From: Michael Sievers <[hidden email]>
Subject: Re: [opennms-discuss] MYSQL MONITORING WITH OPENNMS
To: "General OpenNMS Discussion" <[hidden email]>
Date: Tuesday, December 28, 2010, 1:59 AM

Hello,

My config files are included in the wiki page (please follow the link at the bottom where it says “configuration files for MySQL“) Really, what I know about the subject is in the wiki page and I'm afraid I'm at work so I can't get more involved right now.

Bye,
Michael

"kashif hameed" <kashifhameed_2003@...> schrieb:

>Have u done this document or nor if yes then send me your configuration
>files i will check and configured them accordingly.
>
>I am going to attach the node graph in your email. Please check it here
>is the resource graph which is in my opennms. NOCSERVER is the node
>name and in this node mysql is running kindly like this you send me
>that how your node is seeing in resource graph. please send me as soon
>as
>
>U have skype id can u comeonline right now i am online oin skype if you
>have time just come online. my skype is = kashhhhhhh
>
>Please send me scan image of your node plz
>
>Thanks
>
>
>--- On Mon, 12/27/10, Michael Sievers <michael@...> wrote:
>
>From: Michael Sievers <michael@...>
>Subject: Re: [opennms-discuss] MYSQL MONITORING WITH OPENNMS
>To: "General OpenNMS Discussion"
><opennms-discuss@...>
>Date: Monday, December 27, 2010, 11:42 PM
>
>Hello,
>
>I am using openms to monitor MySQL. What I know about it is wtitten up
>here:
>
>http://www.opennms.org/wiki/JDBC_Data_Collection
>
>Bye,
>Michael
>
>
>
>"Shruthi" <shruthi.b.hegde@...> schrieb:
>
>>
>>Just the service :(
>>
>>3G services now launched in Delhi, Mumbai, Kolkata and
>Chandigarh...
>>
>>
>>
>>
>>"kashif hameed [via OpenNMS]"
>><ml-node+5871188-408923121-124059@...>
>>12-28-10 11:35 AM
>>
>>To
>>Shruthi <shruthi.b.hegde@...>
>>cc
>>
>>Subject
>>Re: MYSQL MONITORING WITH OPENNMS
>>
>>
>>
>>
>>
>>
>>
>>shruti i have done this but this is not requirment. In order to do
>this
>>it
>>is only monitiring the service of mysql. I also want to know which
>what
>>is
>>current status of DB, and how much load on DB.
>>
>>So u have monitored these kind of things or just monitiored service
>>
>>Thanks
>>
>>
>>--- On Mon, 12/27/10, kashif hameed <[hidden email]> wrote:
>>
>>From: kashif hameed <[hidden email]>
>>Subject: Re: [opennms-discuss] MYSQL MONITORING WITH OPENNMS
>>To: "General OpenNMS Discussion" <[hidden email]>
>>Date: Monday, December 27, 2010, 9:02 PM
>>
>>
>>Shruthi thanks for your email but how could you monitor this because
>if
>>
>>you see wiki document on opennms documentation it will show that php
>>pages
>>but if you are using opennms and default web server for opennms is
>>jetty
>>server so jetty is not supported php files so how could you integerate
>>php
>>with jetty or you are using apache tomcat external server
>>
>>Thanks
>>
>>
>>--- On Sun, 12/26/10, Shruthi <[hidden email]> wrote:
>>
>>From: Shruthi <[hidden email]>
>>Subject: Re: [opennms-discuss] MYSQL MONITORING WITH OPENNMS
>>To: [hidden email]
>>Date: Sunday, December 26, 2010, 9:03 PM
>>
>>Yes i monitor MySQL in OpenNMS
>>
>>i did the following changes in the following files.
>>1. capsd-configuration.xml
>>
>> <protocol-plugin protocol="MySQL"
>>class-name="org.opennms.netmgt.capsd.plugins.TcpPlugin" scan="on">
>> <property key="banner" value="*" />
>> <property key="port" value="3306" /> (TCP port in which MySQL is
>
>>Running..By Default-3306)
>> <property key="timeout" value="3000" />
>> <property key="retry" value="1" />
>> </protocol-plugin>
>>
>>2.poller-configuration.xml
>>
>> <service name="MySQL" interval="300000" user-defined="false"
>>status="on">
>> <parameter key="retry" value="1" />
>> <parameter key="timeout" value="3000" />
>> <parameter key="port" value="3306" />
>> <parameter key="banner" value="*" />
>> </service>
>>'
>>'
>>'
>>'
>><monitor service="MySQL"
>>class-name="org.opennms.netmgt.poller.monitors.TcpMonitor" />
>>
>>3.Restart OpenNMS & Rescan the device.
>>
>>This is all that i did to monitor MySQL.
>>
>>Regards,
>>Shruthi Hegde
>>IMSG,
>>Reliance Tech Services,
>>DAKC, Navi Mumbai
>>Ph:022-30382970
>>
>>3G services now launched in Delhi, Mumbai, Kolkata and
>Chandigarh...
>>
>>
>>
>>
>>
>>
>>"Kashif Hameed-2 [via OpenNMS]" <[hidden email]>
>>12-24-10 07:50 PM
>>
>>
>>To
>>Shruthi <[hidden email]>
>>cc
>>
>>Subject
>>MYSQL MONITORING WITH OPENNMS
>>
>>
>>
>>
>>
>>
>>
>>
>><style> 
>></style>
>>Dear All,
>>
>>Anybody monitor mysql in opennms. If anybody have done it please let
>me
>>
>>give all steps. I have already checked opennms wiki documentation but
>
>>jetty server is not running php file so that how this document work
>>please
>>advise.
>>
>>http://www.opennms.org/wiki/Monitoring_MySQL
>>
>>Shruthi have u done mysql monitoring. Any idea
>>
>>Thanks
>>
>>
>>------------------------------------------------------------------------------
>>
>>
>>Learn how Oracle Real Application Clusters (RAC) One Node allows
>>customers
>>
>>to consolidate database storage, standardize their database
>>environment,
>>and,
>>should the need arise, upgrade to a full multi-node Oracle RAC
>database
>>
>>without downtime or disruption
>>http://p.sf.net/sfu/oracle-sfdevnl
>>_______________________________________________
>>Please read the OpenNMS Mailing List FAQ:
>>http://www.opennms.org/index.php/Mailing_List_FAQ
>>
>>opennms-discuss mailing list
>>
>>To *unsubscribe* or change your subscription options, see the bottom
>of
>>
>>this page:
>>https://lists.sourceforge.net/lists/listinfo/opennms-discuss
>>
>>
>>View message @
>>http://opennms.530661.n2.nabble.com/MYSQL-MONITORING-WITH-OPENNMS-tp5865036p5865036.html
>>
>>To start a new topic under OpenNMS, email [hidden email]
>>subscription options, see the bottom of this page:
>>https://lists.sourceforge.net/lists/listinfo/opennms-discuss
>>
>>
>>-----Inline Attachment Follows-----
>>
>>------------------------------------------------------------------------------
>>Learn how Oracle Real Application Clusters (RAC) One Node allows
>>customers
>>to consolidate database storage, standardize their database
>>environment,
>>and,
>>should the need arise, upgrade to a full multi-node Oracle RAC
>database
>>
>>without downtime or disruption
>>http://p.sf.net/sfu/oracle-sfdevnl
>>
>>-----Inline Attachment Follows-----
>>
>>_______________________________________________
>>Please read the OpenNMS Mailing List FAQ:
>>http://www.opennms.org/index.php/Mailing_List_FAQ
>>
>>opennms-discuss mailing list
>>
>>To *unsubscribe* or change your subscription options, see the bottom
>of
>>
>>this page:
>>https://lists.sourceforge.net/lists/listinfo/opennms-discuss
>>
>>
>>------------------------------------------------------------------------------
>>
>>
>>Learn how Oracle Real Application Clusters (RAC) One Node allows
>>customers
>>
>>to consolidate database storage, standardize their database
>>environment,
>>and,
>>should the need arise, upgrade to a full multi-node Oracle RAC
>database
>>
>>without downtime or disruption
>>http://p.sf.net/sfu/oracle-sfdevnl
>>_______________________________________________
>>Please read the OpenNMS Mailing List FAQ:
>>http://www.opennms.org/index.php/Mailing_List_FAQ
>>
>>opennms-discuss mailing list
>>
>>To *unsubscribe* or change your subscription options, see the bottom
>of
>>
>>this page:
>>https://lists.sourceforge.net/lists/listinfo/opennms-discuss
>>
>>
>>View message @
>>http://opennms.530661.n2.nabble.com/MYSQL-MONITORING-WITH-OPENNMS-tp5865036p5871188.html
>>
>>To start a new topic under OpenNMS, email
>>ml-node+530661-181856423-124059@...
>>To unsubscribe from OpenNMS, click here.
>>
>>
>>
>>
>>The information contained in this e-mail message is intended only for
>>the use of the individual or entity to which it is addressed. If you
>>are not the intended recipient, you should return it to the sender
>>immediately. Please note that while we scan all e-mails for viruses we
>>cannot guarantee that any e-mail is virus-free and accept no liability
>>for any damage caused by any virus transmitted by this email.
>>
>>--
>>View this message in context:
>>http://opennms.530661.n2.nabble.com/MYSQL-MONITORING-WITH-OPENNMS-tp5865036p5871236.html
>>Sent from the OpenNMS - discuss mailing list archive at Nabble.com.
>>------------------------------------------------------------------------------
>>Learn how Oracle Real Application Clusters (RAC) One Node allows
>>customers
>>to consolidate database storage, standardize their database
>>environmen

------------------------------------------------------------------------------
Learn how Oracle Real Application Clusters (RAC) One Node allows customers
to consolidate database storage, standardize their database environment, and,
should the need arise, upgrade to a full multi-node Oracle RAC database
without downtime or disruption
http://p.sf.net/sfu/oracle-sfdevnl
_______________________________________________
Please read the OpenNMS Mailing List FAQ:
http://www.opennms.org/index.php/Mailing_List_FAQ

opennms-discuss mailing list

To *unsubscribe* or change your subscription options, see the bottom of this page:
https://lists.sourceforge.net/lists/listinfo/opennms-discuss

Les Mikesell

Re: MYSQL MONITORING WITH OPENNMS

In reply to this post by kashif hameed

On 12/28/10 1:23 AM, kashif hameed wrote:

>
> Shruthi is there any exact document man in which we can monitor all required
> things of mysql in opeenms any your friend who have done this and second question
>
> It is also very important
>
> Q) Have u monitor logs in opeenms. Suppose i want to monitor http logs and every
> 5 min opennms will check /var/logs/messages file and check if kashif word is
> found in this file this will fire trigered and send me email. Have u dont this
> in opeenms

OpenNMS doesn't check any logs by itself except things that are sent via remote
syslog. If you want information that is not already available in SNMP you have
to do something to make it available to a poller in opennms. This could be an
extension to the snmp agent or a web page that shows what you want to check in a
way that the http poller can parse.

--
Les Mikesell
[hidden email]

------------------------------------------------------------------------------
Learn how Oracle Real Application Clusters (RAC) One Node allows customers
to consolidate database storage, standardize their database environment, and,
should the need arise, upgrade to a full multi-node Oracle RAC database
without downtime or disruption
http://p.sf.net/sfu/oracle-sfdevnl
_______________________________________________
Please read the OpenNMS Mailing List FAQ:
http://www.opennms.org/index.php/Mailing_List_FAQ

opennms-discuss mailing list

To *unsubscribe* or change your subscription options, see the bottom of this page:
https://lists.sourceforge.net/lists/listinfo/opennms-discuss

kashif hameed

Re: MYSQL MONITORING WITH OPENNMS

ok but how it is possible in my case example is that

suppose i want to monitor log which is located /var/logs/messages ok i want to locate the word 'kashif' in this file that whenever opennms will check the file it will send me the email if it sees. so how to parse in poller etc what ever you say how it is possible

Thanks

--- On Tue, 12/28/10, Les Mikesell <[hidden email]> wrote:

From: Les Mikesell <[hidden email]>
Subject: Re: [opennms-discuss] MYSQL MONITORING WITH OPENNMS
To: [hidden email]
Date: Tuesday, December 28, 2010, 8:21 AM

On 12/28/10 1:23 AM, kashif hameed wrote:

>
> Shruthi is there any exact document man in which we can monitor all required
> things of mysql in opeenms any your friend who have done this and second question
>
> It is also very important
>
> Q) Have u monitor logs in opeenms. Suppose i want to monitor http logs and every
> 5 min opennms will check /var/logs/messages file and check if kashif word is
> found in this file this will fire trigered and send me email. Have u dont this
> in opeenms

OpenNMS doesn't check any logs by itself except things that are sent via remote
syslog. If you want information that is not already available in SNMP you have
to do something to make it available to a poller in opennms. This could be an
extension to the snmp agent or a web page that shows what you want to check in a
way that the http poller can parse.

--
Les Mikesell
lesmikesell@...

------------------------------------------------------------------------------
Learn how Oracle Real Application Clusters (RAC) One Node allows customers
to consolidate database storage, standardize their database environment, and,
should the need arise, upgrade to a full multi-node Oracle RAC database
without downtime or disruption
http://p.sf.net/sfu/oracle-sfdevnl
_______________________________________________
Please read the OpenNMS Mailing List FAQ:
http://www.opennms.org/index.php/Mailing_List_FAQ

opennms-discuss mailing list

To *unsubscribe* or change your subscription options, see the bottom of this page:
https://lists.sourceforge.net/lists/listinfo/opennms-discuss

kashif hameed

Re: MYSQL MONITORING WITH OPENNMS

In reply to this post by Michael Sievers

hi michael,

Nice meeting you i have added the following lines in my capsd file

 <service name="MySQL" interval="300000" user-defined="false" status="on">
   <parameter key="retry" value="2"/>
   <parameter key="timeout" value="3000"/>
   <parameter key="collection" value="mysql"/>
   <parameter key="url" value="jdbc:mysql://OPENNMS_JDBC_HOSTNAME/information_schema"/>
   <parameter key="user" value="opennms"/>
   <parameter key="password" value="<password>"/>
   <parameter key="driver" value="com.mysql.jdbc.Driver"/>
 </service>

after adding these line i have restarted the opennms and it will give the error messages

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at
 sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:592)
        at org.opennms.bootstrap.Bootstrap$3.run(Bootstrap.java:353)
        at java.lang.Thread.run(Thread.java:595)
Caused by: org.springframework.beans.factory.access.BootstrapException: Unable to return specified BeanFactory instance: factory key [eventDaemonContext], from group with resource name [classpath*:beanRefContext.xml]; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'eventDaemonContext' defined in URL [jar:file:/opt/opennms/lib/opennms-services-1.9.2.jar!/beanRefContext.xml]: Cannot resolve reference to bean 'commonContext' while setting constructor argument; nested exception is org.springframework.beans.factory.BeanCreationException:
 Error creating bean with name 'commonContext' defined in URL [jar:file:/opt/opennms/lib/opennms-services-1.9.2.jar!/beanRefContext.xml]: Instantiation of bean failed; nested exception is org.springframework.beans.BeanInstantiationException: Could not instantiate bean class [org.springframework.context.support.ClassPathXmlApplicationContext]: Constructor threw exception; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'init-capsdConfig-factory' defined in class path resource [META-INF/opennms/applicationContext-commonConfigs.xml]: Invocation of init method failed; nested exception is org.exolab.castor.xml.MarshalException: unable to find FieldDescriptor for 'service' in ClassDescriptor of capsd-configuration{File: [not available]; line: 194; column: 74}
        at org.springframework.beans.factory.access.SingletonBeanFactoryLocator.useBeanFactory(SingletonBeanFactoryLocator.java:409)
      
  at org.opennms.core.utils.BeanUtils.getBeanFactory(BeanUtils.java:59)
        at org.opennms.core.utils.BeanUtils.getFactory(BeanUtils.java:101)
        at org.opennms.netmgt.daemon.AbstractSpringContextJmxServiceDaemon.init(AbstractSpringContextJmxServiceDaemon.java:109)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:592)
        at com.sun.jmx.mbeanserver.StandardMetaDataImpl.invoke(StandardMetaDataImpl.java:414)
        ... 15 more
Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'eventDaemonContext' defined in URL [jar:file:/opt/opennms/lib/opennms-services-1.9.2.jar!/beanRefContext.xml]: Cannot resolve reference
 to bean 'commonContext' while setting constructor argument; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'commonContext' defined in URL [jar:file:/opt/opennms/lib/opennms-services-1.9.2.jar!/beanRefContext.xml]: Instantiation of bean failed; nested exception is org.springframework.beans.BeanInstantiationException: Could not instantiate bean class [org.springframework.context.support.ClassPathXmlApplicationContext]: Constructor threw exception; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'init-capsdConfig-factory' defined in class path resource [META-INF/opennms/applicationContext-commonConfigs.xml]: Invocation of init method failed; nested exception is org.exolab.castor.xml.MarshalException: unable to find FieldDescriptor for 'service' in ClassDescriptor of capsd-configuration{File: [not available]; line: 194; column: 74}
     
   at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:328)
        at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:106)
        at org.springframework.beans.factory.support.ConstructorResolver.resolveConstructorArguments(ConstructorResolver.java:617)
        at org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:144)
        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:993)
        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:897)
        at
 org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:485)
        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:456)
        at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:291)
        at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222)
        at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:288)
        at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:194)
        at org.springframework.context.support.AbstractApplicationContext.getBean(AbstractApplicationContext.java:1049)
        at
 org.springframework.beans.factory.access.SingletonBeanFactoryLocator.useBeanFactory(SingletonBeanFactoryLocator.java:397)
        ... 23 more
Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'commonContext' defined in URL [jar:file:/opt/opennms/lib/opennms-services-1.9.2.jar!/beanRefContext.xml]: Instantiation of bean failed; nested exception is org.springframework.beans.BeanInstantiationException: Could not instantiate bean class [org.springframework.context.support.ClassPathXmlApplicationContext]: Constructor threw exception; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'init-capsdConfig-factory' defined in class path resource [META-INF/opennms/applicationContext-commonConfigs.xml]: Invocation of init method failed; nested exception is org.exolab.castor.xml.MarshalException: unable to find FieldDescriptor for 'service' in
 ClassDescriptor of capsd-configuration{File: [not available]; line: 194; column: 74}
        at org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:285)
        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:993)
        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:897)
        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:485)
        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:456)
        at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:291)
        at
 org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222)
        at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:288)
        at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:190)
        at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:322)
        ... 36 more
Caused by: org.springframework.beans.BeanInstantiationException: Could not instantiate bean class [org.springframework.context.support.ClassPathXmlApplicationContext]: Constructor threw exception; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'init-capsdConfig-factory' defined in class path resource [META-INF/opennms/applicationContext-commonConfigs.xml]: Invocation of init method
 failed; nested exception is org.exolab.castor.xml.MarshalException: unable to find FieldDescriptor for 'service' in ClassDescriptor of capsd-configuration{File: [not available]; line: 194; column: 74}
        at org.springframework.beans.BeanUtils.instantiateClass(BeanUtils.java:141)
        at org.springframework.beans.factory.support.SimpleInstantiationStrategy.instantiate(SimpleInstantiationStrategy.java:107)
        at org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:277)
        ... 45 more
Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'init-capsdConfig-factory' defined in class path resource [META-INF/opennms/applicationContext-commonConfigs.xml]: Invocation of init method failed; nested exception is org.exolab.castor.xml.MarshalException: unable to find FieldDescriptor for 'service' in ClassDescriptor of
 capsd-configuration{File: [not available]; line: 194; column: 74}
        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1412)
        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:519)
        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:456)
        at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:291)
        at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222)
        at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:288)
        at
 org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:190)
        at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:546)
        at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:872)
        at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:423)
        at org.springframework.context.support.ClassPathXmlApplicationContext.<init>(ClassPathXmlApplicationContext.java:139)
        at org.springframework.context.support.ClassPathXmlApplicationContext.<init>(ClassPathXmlApplicationContext.java:105)
        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
        at
 sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
        at java.lang.reflect.Constructor.newInstance(Constructor.java:501)
        at org.springframework.beans.BeanUtils.instantiateClass(BeanUtils.java:126)
        ... 47 more
Caused by: org.exolab.castor.xml.MarshalException: unable to find FieldDescriptor for 'service' in ClassDescriptor of capsd-configuration{File: [not available]; line: 194; column: 74}
        at org.exolab.castor.xml.Unmarshaller.convertSAXExceptionToMarshalException(Unmarshaller.java:755)
        at org.exolab.castor.xml.Unmarshaller.unmarshal(Unmarshaller.java:721)
        at org.opennms.netmgt.dao.castor.CastorUtils.unmarshal(CastorUtils.java:243)
        at org.opennms.netmgt.dao.castor.CastorUtils.unmarshal(CastorUtils.java:221)
        at
 org.opennms.netmgt.config.CapsdConfigManager.loadXml(CapsdConfigManager.java:176)
        at org.opennms.netmgt.config.DefaultCapsdConfigManager.update(DefaultCapsdConfigManager.java:128)
        at org.opennms.netmgt.config.CapsdConfigFactory.init(CapsdConfigFactory.java:115)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:592)
        at org.springframework.util.MethodInvoker.invoke(MethodInvoker.java:273)
        at org.springframework.beans.factory.config.MethodInvokingFactoryBean.doInvoke(MethodInvokingFactoryBean.java:162)
        at org.springframework.beans.factory.config.MethodInvokingFactoryBean.afterPropertiesSet(MethodInvokingFactoryBean.java:152)
     
   at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1469)
        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1409)
        ... 63 more
Caused by: org.xml.sax.SAXException: unable to find FieldDescriptor for 'service' in ClassDescriptor of capsd-configuration
        at org.exolab.castor.xml.UnmarshalHandler.startElement(UnmarshalHandler.java:1925)
        at org.exolab.castor.xml.UnmarshalHandler.startElement(UnmarshalHandler.java:1353)
        at org.apache.xerces.parsers.AbstractSAXParser.startElement(Unknown Source)
        at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanStartElement(Unknown Source)
        at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl$FragmentContentDispatcher.dispatch(Unknown Source)
        at
 org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanDocument(Unknown Source)
        at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source)
        at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source)
        at org.apache.xerces.parsers.XMLParser.parse(Unknown Source)
        at org.apache.xerces.parsers.AbstractSAXParser.parse(Unknown Source)
        at org.exolab.castor.xml.Unmarshaller.unmarshal(Unmarshaller.java:709)
        ... 77 more

so kindly suggest me where is the problem i have just added your one file.

Note: micheal i think in capsd there is a protocol plugins entry like this

<protocol-plugin protocol="Asterisk_SNMP" class-name="org.opennms.netmgt.capsd.plugins.SnmpPlugin" scan="on">
        <property key="vbname" value=".1.3.6.1.4.1.22736.1.1.1.0" />
        <property key="timeout" value="2000" />
        <property key="retry"
 value="1" />
        </protocol-plugin>

<protocol-plugin protocol="MySQL-4" class-name="org.opennms.netmgt.capsd.plugins.HttpPlugin"  scan="on" user-defined="false">
       <property key="port" value="80" />
       <property key="timeout" value="3000" />
       <property key="retry" value="2" />
       <property key="url" value="/mysql-status/" />
       </protocol-plugin>


<service name="MySQL" interval="300000" user-defined="false" status="on">
   <parameter key="retry" value="2"/>
   <parameter key="timeout" value="3000"/>
   <parameter key="collection" value="mysql"/>
   <parameter key="url" value="jdbc:mysql://OPENNMS_JDBC_HOSTNAME/information_schema"/>
   <parameter key="user" value="opennms"/>
   <parameter key="password" value="lahore"/>
   <parameter key="driver" value="com.mysql.jdbc.Driver"/>

 </service>

 <collector service="MySQL" class-name="org.opennms.netmgt.collectd.JdbcCollector"/>

so you see that in upper protocol plugins entry not a service entry so please check and suggest me what can i do now

Thanks


 <collector service="MySQL" class-name="org.opennms.netmgt.collectd.JdbcCollector"/>

--- On Tue, 12/28/10, [hidden email] <[hidden email]> wrote:

From: [hidden email] <[hidden email]>
Subject: Re: [opennms-discuss] MYSQL MONITORING WITH OPENNMS
To: "General OpenNMS Discussion" <[hidden email]>
Date: Tuesday, December 28, 2010, 5:05 AM

Hello,

at the bottom of
http://www.opennms.org/wiki/JDBC_Data_Collection
there is a link to
http://www.opennms.org/wiki/JDBC_Collection_configuration_for_MySQL
which holds the xml-config-file:
jdbc-datacollection-config.xml
and a longish excerpt of my snmp-graph.properties, where the data collected via JDBCCollector/jdbc-datacollection.config.xml is actually transformed into resource graphs.

Bye,
Michael

----- Ursprüngliche Nachricht -----
Von:
General OpenNMS Discussion <[hidden email]>

An:
"General OpenNMS Discussion" <[hidden email]>
Cc:

Gesendet:
Tue, 28 Dec 2010 03:45:20 -0800 (PST)
Betreff:
Re: [opennms-discuss] MYSQL MONITORING WITH OPENNMS

ok u mean to say that if i will change these settings in my opennms then should i able to see the graph of mysql database am i right.

And kindly tell me which documents i should follow
--- On Tue, 12/28/10, Michael Sievers <[hidden email]> wrote:

From: Michael Sievers <[hidden email]>
Subject: Re: [opennms-discuss] MYSQL MONITORING WITH OPENNMS
To: "General OpenNMS Discussion" <[hidden email]>
Date: Tuesday, December 28, 2010, 1:59 AM

Hello,

My config files are included in the wiki page (please follow the link at the bottom where it says “configuration files for MySQL“) Really, what I know about the subject is in the wiki page and I'm afraid I'm at work so I can't get more involved right now.

Bye,
Michael

"kashif hameed" <[hidden email]> schrieb:

>Have u done this document or nor if yes then send me your configuration
>files i will check and configured them accordingly.
>
>I am going to attach the node graph in your email. Please check it here
>is the resource graph which is in my opennms. NOCSERVER is the node
>name and in this node mysql is running kindly like this you send me
>that how your node is seeing in resource graph. please send me as soon
>as
>
>U have skype id can u comeonline right now i am online oin skype if you
>have time just come online. my skype is = kashhhhhhh
>
>Please send me scan image of your node plz
>
>Thanks
>
>
>--- On Mon, 12/27/10, Michael Sievers <[hidden email]> wrote:
>
>From: Michael Sievers <[hidden email]>
>Subject: Re: [opennms-discuss] MYSQL MONITORING WITH OPENNMS
>To: "General OpenNMS Discussion"
><[hidden email]>
>Date: Monday, December 27, 2010, 11:42 PM
>
>Hello,
>
>I am using openms to monitor MySQL. What I know about it is wtitten up
>here:
>
>http://www.opennms.org/wiki/JDBC_Data_Collection
>
>Bye,
>Michael
>
>
>
>"Shruthi" <[hidden email]> schrieb:
>
>>
>>Just the service :(
>>
>>3G services now launched in Delhi, Mumbai, Kolkata and
>Chandigarh...
>>
>>
>>
>>
>>"kashif hameed [via OpenNMS]"
>><ml-node+[hidden email]>
>>12-28-10 11:35 AM
>>
>>To
>>Shruthi <[hidden email]>
>>cc
>>
>>Subject
>>Re: MYSQL MONITORING WITH OPENNMS
>>
>>
>>
>>
>>
>>
>>
>>shruti i have done this but this is not requirment. In order to do
>this
>>it
>>is only monitiring the service of mysql. I also want to know which
>what
>>is
>>current status of DB, and how much load on DB.
>>
>>So u have monitored these kind of things or just monitiored service
>>
>>Thanks
>>
>>
>>--- On Mon, 12/27/10, kashif hameed <[hidden email]> wrote:
>>
>>From: kashif hameed <[hidden email]>
>>Subject: Re: [opennms-discuss] MYSQL MONITORING WITH OPENNMS
>>To: "General OpenNMS Discussion" <[hidden email]>
>>Date: Monday, December 27, 2010, 9:02 PM
>>
>>
>>Shruthi thanks for your email but how could you monitor this because
>if
>>
>>you see wiki document on opennms documentation it will show that php
>>pages
>>but if you are using opennms and default web server for opennms is
>>jetty
>>server so jetty is not supported php files so how could you integerate
>>php
>>with jetty or you are using apache tomcat external server
>>
>>Thanks
>>
>>
>>--- On Sun, 12/26/10, Shruthi <[hidden email]> wrote:
>>
>>From: Shruthi <[hidden email]>
>>Subject: Re: [opennms-discuss] MYSQL MONITORING WITH OPENNMS
>>To: [hidden email]
>>Date: Sunday, December 26, 2010, 9:03 PM
>>
>>Yes i monitor MySQL in OpenNMS
>>
>>i did the following changes in the following files.
>>1. capsd-configuration.xml
>>
>> <protocol-plugin protocol="MySQL"
>>class-name="org.opennms.netmgt.capsd.plugins.TcpPlugin" scan="on">
>> <property key="banner" value="*" />
>> <property key="port" value="3306" /> (TCP port in which MySQL is
>
>>Running..By Default-3306)
>> <property key="timeout" value="3000" />
>> <property key="retry" value="1" />
>> </protocol-plugin>
>>
>>2.poller-configuration.xml
>>
>> <service name="MySQL" interval="300000" user-defined="false"
>>status="on">
>> <parameter key="retry" value="1" />
>> <parameter key="timeout" value="3000" />
>> <parameter key="port" value="3306" />
>> <parameter key="banner" value="*" />
>> </service>
>>'
>>'
>>'
>>'
>><monitor service="MySQL"
>>class-name="org.opennms.netmgt.poller.monitors.TcpMonitor" />
>>
>>3.Restart OpenNMS & Rescan the device.
>>
>>This is all that i did to monitor MySQL.
>>
>>Regards,
>>Shruthi Hegde
>>IMSG,
>>Reliance Tech Services,
>>DAKC, Navi Mumbai
>>Ph:022-30382970
>>
>>3G services now launched in Delhi, Mumbai, Kolkata and
>Chandigarh...
>>
>>
>>
>>
>>
>>
>>"Kashif Hameed-2 [via OpenNMS]" <[hidden email]>
>>12-24-10 07:50 PM
>>
>>
>>To
>>Shruthi <[hidden email]>
>>cc
>>
>>Subject
>>MYSQL MONITORING WITH OPENNMS
>>
>>
>>
>>
>>
>>
>>
>>
>><style> 
>></style>
>>Dear All,
>>
>>Anybody monitor mysql in opennms. If anybody have done it please let
>me
>>
>>give all steps. I have already checked opennms wiki documentation but
>
>>jetty server is not running php file so that how this document work
>>please
>>advise.
>>
>>http://www.opennms.org/wiki/Monitoring_MySQL
>>
>>Shruthi have u done mysql monitoring. Any idea
>>
>>Thanks
>>
>>
>>------------------------------------------------------------------------------
>>
>>
>>Learn how Oracle Real Application Clusters (RAC) One Node allows
>>customers
>>
>>to consolidate database storage, standardize their database
>>environment,
>>and,
>>should the need arise, upgrade to a full multi-node Oracle RAC
>database
>>
>>without downtime or disruption
>>http://p.sf.net/sfu/oracle-sfdevnl
>>_______________________________________________
>>Please read the OpenNMS Mailing List FAQ:
>>http://www.opennms.org/index.php/Mailing_List_FAQ
>>
>>opennms-discuss mailing list
>>
>>To *unsubscribe* or change your subscription options, see the bottom
>of
>>
>>this page:
>>https://lists.sourceforge.net/lists/listinfo/opennms-discuss
>>
>>
>>View message @
>>http://opennms.530661.n2.nabble.com/MYSQL-MONITORING-WITH-OPENNMS-tp5865036p5865036.html
>>
>>To start a new topic under OpenNMS, email [hidden email]
>>subscription options, see the bottom of this page:
>>https://lists.sourceforge.net/lists/listinfo/opennms-discuss
>>
>>
>>-----Inline Attachment Follows-----
>>
>>------------------------------------------------------------------------------
>>Learn how Oracle Real Application Clusters (RAC) One Node allows
>>customers
>>to consolidate database storage, standardize their database
>>environment,
>>and,
>>should the need arise, upgrade to a full multi-node Oracle RAC
>database
>>
>>without downtime or disruption
>>http://p.sf.net/sfu/oracle-sfdevnl
>>
>>-----Inline Attachment Follows-----
>>
>>_______________________________________________
>>Please read the OpenNMS Mailing List FAQ:
>>http://www.opennms.org/index.php/Mailing_List_FAQ
>>
>>opennms-discuss mailing list
>>
>>To *unsubscribe* or change your subscription options, see the bottom
>of
>>
>>this page:
>>https://lists.sourceforge.net/lists/listinfo/opennms-discuss
>>
>>
>>------------------------------------------------------------------------------
>>
>>
>>Learn how Oracle Real Application Clusters (RAC) One Node allows
>>customers
>>
>>to consolidate database storage, standardize their database
>>environment,
>>and,
>>should the need arise, upgrade to a full multi-node Oracle RAC
>database
>>
>>without downtime or disruption
>>http://p.sf.net/sfu/oracle-sfdevnl
>>_______________________________________________
>>Please read the OpenNMS Mailing List FAQ:
>>http://www.opennms.org/index.php/Mailing_List_FAQ
>>
>>opennms-discuss mailing list
>>
>>To *unsubscribe* or change your subscription options, see the bottom
>of
>>
>>this page:
>>https://lists.sourceforge.net/lists/listinfo/opennms-discuss
>>
>>
>>View message @
>>http://opennms.530661.n2.nabble.com/MYSQL-MONITORING-WITH-OPENNMS-tp5865036p5871188.html
>>
>>To start a new topic under OpenNMS, email
>>ml-node+[hidden email]
>>To unsubscribe from OpenNMS, click here.
>>
>>
>>
>>
>>The information contained in this e-mail message is intended only for
>>the use of the individual or entity to which it is addressed. If you
>>are not the intended recipient, you should return it to the sender
>>immediately. Please note that while we scan all e-mails for viruses we
>>cannot guarantee that any e-mail is virus-free and accept no liability
>>for any damage caused by any virus transmitted by this email.
>>
>>--
>>View this message in context:
>>http://opennms.530661.n2.nabble.com/MYSQL-MONITORING-WITH-OPENNMS-tp5865036p5871236.html
>>Sent from the OpenNMS - discuss mailing list archive at Nabble.com.
>>------------------------------------------------------------------------------
>>Learn how Oracle Real Application Clusters (RAC) One Node allows
>>customers
>>to consolidate database storage, standardize their database
>>environmen

------------------------------------------------------------------------------
Learn how Oracle Real Application Clusters (RAC) One Node allows customers
to consolidate database storage, standardize their database environment, and,
should the need arise, upgrade to a full multi-node Oracle RAC database
without downtime or disruption
http://p.sf.net/sfu/oracle-sfdevnl
_______________________________________________
Please read the OpenNMS Mailing List FAQ:
http://www.opennms.org/index.php/Mailing_List_FAQ

opennms-discuss mailing list

To *unsubscribe* or change your subscription options, see the bottom of this page:
https://lists.sourceforge.net/lists/listinfo/opennms-discuss

-----Inline Attachment Follows-----

------------------------------------------------------------------------------
Learn how Oracle Real Application Clusters (RAC) One Node allows customers
to consolidate database storage, standardize their database environment, and,
should the need arise, upgrade to a full multi-node Oracle RAC database
without downtime or disruption
http://p.sf.net/sfu/oracle-sfdevnl

-----Inline Attachment Follows-----

_______________________________________________
Please read the OpenNMS Mailing List FAQ:
http://www.opennms.org/index.php/Mailing_List_FAQ

opennms-discuss mailing list

To *unsubscribe* or change your subscription options, see the bottom of this page:
https://lists.sourceforge.net/lists/listinfo/opennms-discuss

Les Mikesell

Re: MYSQL MONITORING WITH OPENNMS

In reply to this post by kashif hameed

On 12/28/10 10:32 PM, kashif hameed wrote:
> ok but how it is possible in my case example is that
>
> suppose i want to monitor log which is located /var/logs/messages ok i want to
> locate the word 'kashif' in this file that whenever opennms will check the file
> it will send me the email if it sees. so how to parse in poller etc what ever
> you say how it is possible

You either have to extend the snmp agent or write a web page with the results
you want to see. The first place to start is pick a programming language you
know to do the work. C or perl would work for snmp extensions, perl, php, java
(and some others) would be good for a web page.

--
Les Mikesell
[hidden email]

------------------------------------------------------------------------------
Learn how Oracle Real Application Clusters (RAC) One Node allows customers
to consolidate database storage, standardize their database environment, and,
should the need arise, upgrade to a full multi-node Oracle RAC database
without downtime or disruption
http://p.sf.net/sfu/oracle-sfdevnl
_______________________________________________
Please read the OpenNMS Mailing List FAQ:
http://www.opennms.org/index.php/Mailing_List_FAQ

opennms-discuss mailing list

To *unsubscribe* or change your subscription options, see the bottom of this page:
https://lists.sourceforge.net/lists/listinfo/opennms-discuss

kashif hameed

Re: MYSQL MONITORING WITH OPENNMS

hi les,

No man i dont think so that you are right because i have seen in opeenms there is a feature of configure trigers i have configured also let me check and give u feedback ok

Thanks

--- On Tue, 12/28/10, Les Mikesell <[hidden email]> wrote:

From: Les Mikesell <[hidden email]>
Subject: Re: [opennms-discuss] MYSQL MONITORING WITH OPENNMS
To: [hidden email]
Date: Tuesday, December 28, 2010, 9:25 PM

On 12/28/10 10:32 PM, kashif hameed wrote:
> ok but how it is possible in my case example is that
>
> suppose i want to monitor log which is located /var/logs/messages ok i want to
> locate the word 'kashif' in this file that whenever opennms will check the file
> it will send me the email if it sees. so how to parse in poller etc what ever
> you say how it is possible

You either have to extend the snmp agent or write a web page with the results
you want to see. The first place to start is pick a programming language you
know to do the work. C or perl would work for snmp extensions, perl, php, java
(and some others) would be good for a web page.

--
Les Mikesell
lesmikesell@...

------------------------------------------------------------------------------
Learn how Oracle Real Application Clusters (RAC) One Node allows customers
to consolidate database storage, standardize their database environment, and,
should the need arise, upgrade to a full multi-node Oracle RAC database
without downtime or disruption
http://p.sf.net/sfu/oracle-sfdevnl
_______________________________________________
Please read the OpenNMS Mailing List FAQ:
http://www.opennms.org/index.php/Mailing_List_FAQ

opennms-discuss mailing list

To *unsubscribe* or change your subscription options, see the bottom of this page:
https://lists.sourceforge.net/lists/listinfo/opennms-discuss

Michael Sievers

Re: MYSQL MONITORING WITH OPENNMS

In reply to this post by kashif hameed

Hello again,

I have not seen this message, so I'm afraid I cannot help you with that one.

Concerning one error message from a personal message you sent me:

/opt/opennms/etc/snmp-graph.properties:3: parser error : Start tag expected, '<' not found

A Start Tag ist what I'd expect from an XML file - could it be that OpenNMS 19.x is switching to an XML based snmp-graph.properties file? Please do check the original source code you downloaded. If it's in XML format you might have to extract the relavant configuration options from the properties file in the wiki article and translate it to the new syntax. If you do that and get it to work, it would be great if you could post your changes to the wiki, so others can profit from that. My knowledge is restricted to OpenNMS 1.8.3 in this area - I'll start looking at 1.9.x once it is labeled production ready instead of development.

To be sure that your only remaining issue is with graphing and not with data collection, you could check your nodes data directories for the relavant jrb files, they should have names like
/<..path_to_opennms_var_dir..>/opennms/rrd/snmp/740/MyTableCache.jrb

where you will have to find out where opennms stores its rrd directory under CentOS, and substitute 740 for the ID of one of your MySQL-Server-Node-IDs. Also, in the opennms log files, collectd.log should hold information for you if the MySQL Collection goes wrong.

Bye,
Michael

----- Ursprüngliche Nachricht -----
Von:
General OpenNMS Discussion <[hidden email]>

An:
"General OpenNMS Discussion" <[hidden email]>
Cc:

Gesendet:
Tue, 28 Dec 2010 21:22:57 -0800 (PST)
Betreff:
Re: [opennms-discuss] MYSQL MONITORING WITH OPENNMS
hi michael,

Nice meeting you i have added the following lines in my capsd file
 <service name="MySQL" interval="300000" user-defined="false" status="on">
   <parameter key="retry" value="2"/>
   <parameter key="timeout" value="3000"/>
   <parameter key="collection" value="mysql"/>
   <parameter key="url" value="jdbc:mysql://OPENNMS_JDBC_HOSTNAME/information_schema"/>
   <parameter key="user" value="opennms"/>
   <parameter key="password" value="<password>"/>
   <parameter key="driver" value="com.mysql.jdbc.Driver"/>
 </service>

after adding these line i have restarted the opennms and it will give the error messages

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at
 sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpljava:39)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:592)
        at org.opennms.bootstrap.Bootstrap$3.run(Bootstrap.java:353)
        at java.lang.Thread.run(Thread.java:595)
Caused by: org.springframework.beans.factory.access.BootstrapException: Unable to return specified BeanFactory instance: factory key [eventDaemonContext], from group with resource name [classpath*:beanRefContext.xml]; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'eventDaemonContext' defined in URL [jar:file:/opt/opennms/lib/opennms-services-1.9.2jar!/beanRefContext.xml]: Cannot resolve reference to bean 'commonContext' while setting constructor argument; nested exception is org.springframework.beans.factory.BeanCreationException:
 Error creating bean with name 'commonContext' defined in URL [jar:file:/opt/opennms/lib/opennms-services-1.9.2.jar!/beanRefContext.xml]: Instantiation of bean failed; nested exception is org.springframework.beans.BeanInstantiationException: Could not instantiate bean class [org.springframework.context.support.ClassPathXmlApplicationContext]: Constructor threw exception; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'init-capsdConfig-factory' defined in class path resource [META-INF/opennms/applicationContext-commonConfigs.xml]: Invocation of init method failed; nested exception is org.exolab.castor.xml.MarshalException: unable to find FieldDescriptor for 'service' in ClassDescriptor of capsd-configuration{File: [not available]; line: 194; column: 74}
        at org.springframework.beans.factory.access.SingletonBeanFactoryLocator.useBeanFactory(SingletonBeanFactoryLocator.java:409)
      
  at org.opennms.core.utils.BeanUtils.getBeanFactory(BeanUtils.java:59)
        at org.opennms.core.utils.BeanUtils.getFactory(BeanUtils.java:101)
        at org.opennms.netmgt.daemon.AbstractSpringContextJmxServiceDaemon.init(AbstractSpringContextJmxServiceDaemon.java:109)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:592)
        at com.sun.jmx.mbeanserver.StandardMetaDataImpl.invoke(StandardMetaDataImpl.java:414)
        ... 15 more
Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'eventDaemonContext' defined in URL [jar:file:/opt/opennms/lib/opennms-services-1.9.2.jar!/beanRefContext.xml]: Cannot resolve reference
 to bean 'commonContext' while setting constructor argument; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'commonContext' defined in URL [jar:file:/opt/opennms/lib/opennms-services-1.9.2.jar!/beanRefContext.xml]: Instantiation of bean failed; nested exception is org.springframework.beans.BeanInstantiationException: Could not instantiate bean class [org.springframework.context.support.ClassPathXmlApplicationContext]: Constructor threw exception; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'init-capsdConfig-factory' defined in class path resource [META-INF/opennms/applicationContext-commonConfigs.xml]: Invocation of init method failed; nested exception is org.exolab.castor.xml.MarshalException: unable to find FieldDescriptor for 'service' in ClassDescriptor of capsd-configuration{File: [not available]; line: 194; column: 74}
     
   at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:328)
        at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:106)
        at org.springframework.beans.factory.support.ConstructorResolver.resolveConstructorArguments(ConstructorResolver.java:617)
        at org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:144)
        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:993)
        at org.springframework.beans.factory.supportAbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:897)
        at
 org.springframework.beansfactory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:485)
        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:456)
        at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:291)
        at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222)
        at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:288)
        at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:194)
        at org.springframework.context.support.AbstractApplicationContext.getBean(AbstractApplicationContext.java:1049)
        at
 org.springframework.beans.factory.access.SingletonBeanFactoryLocator.useBeanFactory(SingletonBeanFactoryLocatorjava:397)
        ... 23 more
Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'commonContext' defined in URL [jar:file:/opt/opennms/lib/opennms-services-1.9.2.jar!/beanRefContext.xml]: Instantiation of bean failed; nested exception is org.springframework.beans.BeanInstantiationException: Could not instantiate bean class [org.springframework.context.support.ClassPathXmlApplicationContext]: Constructor threw exception; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'init-capsdConfig-factory' defined in class path resource [META-INF/opennms/applicationContext-commonConfigs.xml]: Invocation of init method failed; nested exception is org.exolab.castor.xml.MarshalException: unable to find FieldDescriptor for 'service' in
 ClassDescriptor of capsd-configuration{File: [not available]; line: 194; column: 74}
        at org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:285)
        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:993)
        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:897)
        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:485)
        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:456)
        at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:291)
        at
 org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222)
        at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:288)
        at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:190)
        at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:322)
        ... 36 more
Caused by: org.springframework.beans.BeanInstantiationException: Could not instantiate bean class [org.springframework.context.support.ClassPathXmlApplicationContext]: Constructor threw exception; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'init-capsdConfig-factory' defined in class path resource [META-INF/opennms/applicationContext-commonConfigs.xml]: Invocation of init method
 failed; nested exception is org.exolab.castor.xml.MarshalException: unable to find FieldDescriptor for 'service' in ClassDescriptor of capsd-configuration{File: [not available]; line: 194; column: 74}
        at org.springframework.beans.BeanUtils.instantiateClass(BeanUtils.java:141)
        at org.springframework.beans.factory.support.SimpleInstantiationStrategy.instantiate(SimpleInstantiationStrategy.java:107)
        at org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:277)
        ... 45 more
Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'init-capsdConfig-factory' defined in class path resource [META-INF/opennms/applicationContext-commonConfigs.xml]: Invocation of init method failed; nested exception is org.exolab.castor.xml.MarshalException: unable to find FieldDescriptor for 'service' in ClassDescriptor of
 capsd-configuration{File: [not available]; line: 194; column: 74}
        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1412)
        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:519)
        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:456)
        at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:291)
        at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222)
        at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:288)
        at
 org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:190)
        at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:546)
        at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:872)
        at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:423)
        at org.springframework.context.support.ClassPathXmlApplicationContext.<init>(ClassPathXmlApplicationContext.java:139)
        at org.springframework.context.support.ClassPathXmlApplicationContext.<init>(ClassPathXmlApplicationContext.java:105)
        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
        at
 sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
        at java.lang.reflect.Constructor.newInstance(Constructor.java:501)
        at org.springframework.beans.BeanUtils.instantiateClass(BeanUtils.java:126)
        ... 47 more
Caused by: org.exolab.castor.xml.MarshalException: unable to find FieldDescriptor for 'service' in ClassDescriptor of capsd-configuration{File: [not available]; line: 194; column: 74}
        at org.exolab.castor.xml.Unmarshaller.convertSAXExceptionToMarshalException(Unmarshaller.java:755)
        at org.exolab.castor.xml.Unmarshaller.unmarshal(Unmarshaller.java:721)
        at org.opennms.netmgt.dao.castor.CastorUtils.unmarshal(CastorUtils.java:243)
        at org.opennms.netmgt.dao.castor.CastorUtils.unmarshal(CastorUtils.java:221)
        at
 org.opennms.netmgt.config.CapsdConfigManager.loadXml(CapsdConfigManager.java:176)
        at org.opennms.netmgt.config.DefaultCapsdConfigManager.update(DefaultCapsdConfigManager.java:128)
        at org.opennms.netmgt.config.CapsdConfigFactory.init(CapsdConfigFactory.java:115)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:592)
        at org.springframework.util.MethodInvoker.invoke(MethodInvoker.java:273)
        at org.springframework.beans.factory.config.MethodInvokingFactoryBean.doInvoke(MethodInvokingFactoryBean.java:162)
        at org.springframework.beans.factory.config.MethodInvokingFactoryBean.afterPropertiesSet(MethodInvokingFactoryBean.java:152)
     
   at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1469)
        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1409)
        ... 63 more
Caused by: org.xml.sax.SAXException: unable to find FieldDescriptor for 'service' in ClassDescriptor of capsd-configuration
        at org.exolab.castor.xml.UnmarshalHandler.startElement(UnmarshalHandler.java:1925)
        at org.exolab.castor.xml.UnmarshalHandler.startElement(UnmarshalHandler.java:1353)
        at org.apache.xerces.parsers.AbstractSAXParser.startElement(Unknown Source)
        at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanStartElement(Unknown Source)
        at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl$FragmentContentDispatcher.dispatch(Unknown Source)
        at
 org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanDocument(Unknown Source)
        at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source)
        at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source)
        at org.apache.xerces.parsers.XMLParser.parse(Unknown Source)
        at org.apache.xerces.parsers.AbstractSAXParser.parse(Unknown Source)
        at org.exolab.castor.xml.Unmarshaller.unmarshal(Unmarshaller.java:709)
        ... 77 more

so kindly suggest me where is the problem i have just added your one file.

Note: micheal i think in capsd there is a protocol plugins entry like this

<protocol-plugin protocol="Asterisk_SNMP" class-name="org.opennms.netmgt.capsd.plugins.SnmpPlugin" scan="on">
        <property key="vbname" value=".1.3.6.1.4.1.22736.1.1.1.0" />
        <property key="timeout" value="2000" />
        <property key="retry"
 value="1" />
        </protocol-plugin>

<protocol-plugin protocol="MySQL-4" class-name="org.opennms.netmgt.capsd.plugins.HttpPlugin"  scan="on" user-defined="false">
       <property key="port" value="80" />
       <property key="timeout" value="3000" />
       <property key="retry" value="2" />
       <property key="url" value="/mysql-status/" />
       </protocol-plugin>


<service name="MySQL" interval="300000" user-defined="false" status="on">
   <parameter key="retry" value="2"/>
   <parameter key="timeout" value="3000"/>
   <parameter key="collection" value="mysql"/>
   <parameter key="url" value="jdbc:mysql://OPENNMS_JDBC_HOSTNAME/information_schema"/>
   <parameter key="user" value="opennms"/>
   <parameter key="password" value="lahore"/>
   <parameter key="driver" value="com.mysql.jdbc.Driver"/>

 </service>

 <collector service="MySQL" class-name="org.opennms.netmgt.collectd.JdbcCollector"/>

so you see that in upper protocol plugins entry not a service entry so please check and suggest me what can i do now

Thanks


 <collector service="MySQL" class-name="org.opennms.netmgt.collectd.JdbcCollector"/>
--- On Tue, 12/28/10, [hidden email] <[hidden email]> wrote:

From: [hidden email] <[hidden email]>
Subject: Re: [opennms-discuss] MYSQL MONITORING WITH OPENNMS
To: "General OpenNMS Discussion" <[hidden email]>
Date: Tuesday, December 28, 2010, 5:05 AM

Hello,

at the bottom of
http://www.opennms.org/wiki/JDBC_Data_Collection
there is a link to
http://www.opennms.org/wiki/JDBC_Collection_configuration_for_MySQL
which holds the xml-config-file:
jdbc-datacollection-config.xml
and a longish excerpt of my snmp-graph.properties, where the data collected via JDBCCollector/jdbc-datacollection.config.xml is actually transformed into resource graphs.

Bye,
Michael

----- Ursprüngliche Nachricht -----
Von:
General OpenNMS Discussion <[hidden email]>

An:
"General OpenNMS Discussion" <[hidden email]>
Cc:

Gesendet:
Tue, 28 Dec 2010 03:45:20 -0800 (PST)
Betreff:
Re: [opennms-discuss] MYSQL MONITORING WITH OPENNMS

ok u mean to say that if i will change these settings in my opennms then should i able to see the graph of mysql database am i right.

And kindly tell me which documents i should follow
--- On Tue, 12/28/10, Michael Sievers <[hidden email]> wrote:

From: Michael Sievers <[hidden email]>
Subject: Re: [opennms-discuss] MYSQL MONITORING WITH OPENNMS
To: "General OpenNMS Discussion" <[hidden email]>
Date: Tuesday, December 28, 2010, 1:59 AM

Hello,

My config files are included in the wiki page (please follow the link at the bottom where it says “configuration files for MySQL“) Really, what I know about the subject is in the wiki page and I'm afraid I'm at work so I can't get more involved right now.

Bye,
Michael

"kashif hameed" <[hidden email]> schrieb:

>Have u done this document or nor if yes then send me your configuration
>files i will check and configured them accordingly.
>
>I am going to attach the node graph in your email. Please check it here
>is the resource graph which is in my opennms. NOCSERVER is the node
>name and in this node mysql is running kindly like this you send me
>that how your node is seeing in resource graph. please send me as soon
>as
>
>U have skype id can u comeonline right now i am online oin skype if you
>have time just come online. my skype is = kashhhhhhh
>
>Please send me scan image of your node plz
>
>Thanks
>
>
>--- On Mon, 12/27/10, Michael Sievers <[hidden email]> wrote:
>
>From: Michael Sievers <[hidden email]>
>Subject: Re: [opennms-discuss] MYSQL MONITORING WITH OPENNMS
>To: "General OpenNMS Discussion"
><[hidden email]>
>Date: Monday, December 27, 2010, 11:42 PM
>
>Hello,
>
>I am using openms to monitor MySQL. What I know about it is wtitten up
>here:
>
>http://www.opennms.org/wiki/JDBC_Data_Collection
>
>Bye,
>Michael
>
>
>
>"Shruthi" <[hidden email]> schrieb:
>
>>
>>Just the service :(
>>
>>3G services now launched in Delhi, Mumbai, Kolkata and
>Chandigarh...
>>
>>
>>
>>
>>"kashif hameed [via OpenNMS]"
>><ml-node+[hidden email]>
>>12-28-10 11:35 AM
>>
>>To
>>Shruthi <[hidden email]>
>>cc
>>
>>Subject
>>Re: MYSQL MONITORING WITH OPENNMS
>>
>>
>>
>>
>>
>>
>>
>>shruti i have done this but this is not requirment. In order to do
>this
>>it
>>is only monitiring the service of mysql. I also want to know which
>what
>>is
>>current status of DB, and how much load on DB.
>>
>>So u have monitored these kind of things or just monitiored service
>>
>>Thanks
>>
>>
>>--- On Mon, 12/27/10, kashif hameed <[hidden email]> wrote:
>>
>>From: kashif hameed <[hidden email]>
>>Subject: Re: [opennms-discuss] MYSQL MONITORING WITH OPENNMS
>>To: "General OpenNMS Discussion" <[hidden email]>
>>Date: Monday, December 27, 2010, 9:02 PM
>>
>>
>>Shruthi thanks for your email but how could you monitor this because
>if
>>
>>you see wiki document on opennms documentation it will show that php
>>pages
>>but if you are using opennms and default web server for opennms is
>>jetty
>>server so jetty is not supported php files so how could you integerate
>>php
>>with jetty or you are using apache tomcat external server
>>
>>Thanks
>>
>>
>>--- On Sun, 12/26/10, Shruthi <[hidden email]> wrote:
>>
>>From: Shruthi <[hidden email]>
>>Subject: Re: [opennms-discuss] MYSQL MONITORING WITH OPENNMS
>>To: [hidden email]
>>Date: Sunday, December 26, 2010, 9:03 PM
>>
>>Yes i monitor MySQL in OpenNMS
>>
>>i did the following changes in the following files.
>>1. capsd-configuration.xml
>>
>> <protocol-plugin protocol="MySQL"
>>class-name="org.opennms.netmgt.capsd.plugins.TcpPlugin" scan="on">
>> <property key="banner" value="*" />
>> <property key="port" value="3306" /> (TCP port in which MySQL is
>
>>Running..By Default-3306)
>> <property key="timeout" value="3000" />
>> <property key="retry" value="1" />
>> </protocol-plugin>
>>
>>2.poller-configuration.xml
>>
>> <service name="MySQL" interval="300000" user-defined="false"
>>status="on">
>> <parameter key="retry" value="1" />
>> <parameter key="timeout" value="3000" />
>> <parameter key="port" value="3306" />
>> <parameter key="banner" value="*" />
>> </service>
>>'
>>'
>>'
>>'
>><monitor service="MySQL"
>>class-name="org.opennms.netmgt.poller.monitors.TcpMonitor" />
>>
>>3.Restart OpenNMS & Rescan the device.
>>
>>This is all that i did to monitor MySQL.
>>
>>Regards,
>>Shruthi Hegde
>>IMSG,
>>Reliance Tech Services,
>>DAKC, Navi Mumbai
>>Ph:022-30382970
>>
>>3G services now launched in Delhi, Mumbai, Kolkata and
>Chandigarh...
>>
>>
>>
>>
>>
>>
>>"Kashif Hameed-2 [via OpenNMS]" <[hidden email]>
>>12-24-10 07:50 PM
>>
>>
>>To
>>Shruthi <[hidden email]>
>>cc
>>
>>Subject
>>MYSQL MONITORING WITH OPENNMS
>>
>>
>>
>>
>>
>>
>>
>>
>><style> 
>></style>
>>Dear All,
>>
>>Anybody monitor mysql in opennms. If anybody have done it please let
>me
>>
>>give all steps. I have already checked opennms wiki documentation but
>
>>jetty server is not running php file so that how this document work
>>please
>>advise.
>>
>>http://www.opennms.org/wiki/Monitoring_MySQL
>>
>>Shruthi have u done mysql monitoring. Any idea
>>
>>Thanks
>>
>>
>>------------------------------------------------------------------------------
>>
>>
>>Learn how Oracle Real Application Clusters (RAC) One Node allows
>>customers
>>
>>to consolidate database storage, standardize their database
>>environment,
>>and,
>>should the need arise, upgrade to a full multi-node Oracle RAC
>database
>>
>>without downtime or disruption
>>http://p.sf.net/sfu/oracle-sfdevnl
>>_______________________________________________
>>Please read the OpenNMS Mailing List FAQ:
>>http://www.opennms.org/index.php/Mailing_List_FAQ
>>
>>opennms-discuss mailing list
>>
>>To *unsubscribe* or change your subscription options, see the bottom
>of
>>
>>this page:
>>https://lists.sourceforge.net/lists/listinfo/opennms-discuss
>>
>>
>>View message @
>>http://opennms.530661.n2.nabble.com/MYSQL-MONITORING-WITH-OPENNMS-tp5865036p5865036.html
>>
>>To start a new topic under OpenNMS, email [hidden email]
>>subscription options, see the bottom of this page:
>>https://lists.sourceforge.net/lists/listinfo/opennms-discuss
>>
>>
>>-----Inline Attachment Follows-----
>>
>>------------------------------------------------------------------------------
>>Learn how Oracle Real Application Clusters (RAC) One Node allows
>>customers
>>to consolidate database storage, standardize their database
>>environment,
>>and,
>>should the need arise, upgrade to a full multi-node Oracle RAC
>database
>>
>>without downtime or disruption
>>http://p.sf.net/sfu/oracle-sfdevnl
>>
>>-----Inline Attachment Follows-----
>>
>>_______________________________________________
>>Please read the OpenNMS Mailing List FAQ:
>>http://www.opennms.org/index.php/Mailing_List_FAQ
>>
>>opennms-discuss mailing list
>>
>>To *unsubscribe* or change your subscription options, see the bottom
>of
>>
>>this page:
>>https://lists.sourceforge.net/lists/listinfo/opennms-discuss
>>
>>
>>------------------------------------------------------------------------------
>>
>>
>>Learn how Oracle Real Application Clusters (RAC) One Node allows
>>customers
>>
>>to consolidate database storage, standardize their database
>>environment,
>>and,
>>should the need arise, upgrade to a full multi-node Oracle RAC
>database
>>
>>without downtime or disruption
>>http://p.sf.net/sfu/oracle-sfdevnl
>>_______________________________________________
>>Please read the OpenNMS Mailing List FAQ:
>>http://www.opennms.org/index.php/Mailing_List_FAQ
>>
>>opennms-discuss mailing list
>>
>>To *unsubscribe* or change your subscription options, see the bottom
>of
>>
>>this page:
>>https://lists.sourceforge.net/lists/listinfo/opennms-discuss
>>
>>
>>View message @
>>http://opennms.530661.n2.nabble.com/MYSQL-MONITORING-WITH-OPENNMS-tp5865036p5871188.html
>>
>>To start a new topic under OpenNMS, email
>>ml-node+[hidden email]
>>To unsubscribe from OpenNMS, click here.
>>
>>
>>
>>
>>The information contained in this e-mail message is intended only for
>>the use of the individual or entity to which it is addressed. If you
>>are not the intended recipient, you should return it to the sender
>>immediately. Please note that while we scan all e-mails for viruses we
>>cannot guarantee that any e-mail is virus-free and accept no liability
>>for any damage caused by any virus transmitted by this email.
>>
>>--
>>View this message in context:
>>http://opennms.530661.n2.nabble.com/MYSQL-MONITORING-WITH-OPENNMS-tp5865036p5871236.html
>>Sent from the OpenNMS - discuss mailing list archive at Nabble.com.
>>------------------------------------------------------------------------------
>>Learn how Oracle Real Application Clusters (RAC) One Node allows
>>customers
>>to consolidate database storage, standardize their database
>>environmen

------------------------------------------------------------------------------
Learn how Oracle Real Application Clusters (RAC) One Node allows customers
to consolidate database storage, standardize their database environment, and,
should the need arise, upgrade to a full multi-node Oracle RAC database
without downtime or disruption
http://p.sf.net/sfu/oracle-sfdevnl
_______________________________________________
Please read the OpenNMS Mailing List FAQ:
http://www.opennms.org/index.php/Mailing_List_FAQ

opennms-discuss mailing list

To *unsubscribe* or change your subscription options, see the bottom of this page:
https://lists.sourceforge.net/lists/listinfo/opennms-discuss

-----Inline Attachment Follows-----

------------------------------------------------------------------------------
Learn how Oracle Real Application Clusters (RAC) One Node allows customers
to consolidate database storage, standardize their database environment, and,
should the need arise, upgrade to a full multi-node Oracle RAC database
without downtime or disruption
http://p.sf.net/sfu/oracle-sfdevnl

-----Inline Attachment Follows-----

_______________________________________________
Please read the OpenNMS Mailing List FAQ:
http://www.opennms.org/index.php/Mailing_List_FAQ

opennms-discuss mailing list

To *unsubscribe* or change your subscription options, see the bottom of this page:
https://lists.sourceforge.net/lists/listinfo/opennms-discuss