Checking out http://www.observium.org/wiki/Application/MySQL#Requirementsand seems pretty straight forward.
I have my server running, added that box and see it collecting data now. php5-cli and php-mysql are installed on both the server and mysql server I wish to monitor, but nothing has been added and not sure how to force check, add, etc.
Docs are simple enough; I created the user with access on the remote server. Then the steps are simply;
*Copy* the mysql script *from scripts/agent-local/* in your observium install to */usr/local/check_mk_agent/local/* (/usr/lib/check_mk_agent/local/ on Debian systems) the *server* you wish to monitor.
The remote server is running ubuntu, so I create a folder; /usr/lib/check_mk_agent/local with 2 files; mysql (script) mysql.cnf
I can run the script locally and get a lot of data (here is a sample); root@mysql101:/usr/lib/check_mk_agent/local# ./mysql <<<mysql>>> a0:13362926 a1:50929 a2:4796992 a3:287789
So is it something on the server end I need to add/edit?
Tnx
enable agent checking for that host in the device's settings.
also make sure the agent is accessible from the observium server.
adam.
On Mon, 7 Jan 2013 16:42:30 -0500, Lance Raymond lraymond@weatherflow.com wrote:
Checking out http://www.observium.org/wiki/Application/MySQL#Requirementsand seems pretty straight forward.
I have my server running, added that box and see it collecting data now. php5-cli and php-mysql are installed on both the server and mysql server
I
wish to monitor, but nothing has been added and not sure how to force check, add, etc.
Docs are simple enough; I created the user with access on the remote server. Then the steps are simply;
*Copy* the mysql script *from scripts/agent-local/* in your observium install to */usr/local/check_mk_agent/local/* (/usr/lib/check_mk_agent/local/ on Debian systems) the *server* you wish to monitor.
The remote server is running ubuntu, so I create a folder; /usr/lib/check_mk_agent/local with 2 files; mysql (script) mysql.cnf
I can run the script locally and get a lot of data (here is a sample); root@mysql101:/usr/lib/check_mk_agent/local# ./mysql <<<mysql>>> a0:13362926 a1:50929 a2:4796992 a3:287789
So is it something on the server end I need to add/edit?
Tnx
(then, it should be detected on the next polling run)
On 7/01/2013 22:09, Adam Armstrong wrote:
enable agent checking for that host in the device's settings.
also make sure the agent is accessible from the observium server.
adam.
On Mon, 7 Jan 2013 16:42:30 -0500, Lance Raymond lraymond@weatherflow.com wrote:
Checking out http://www.observium.org/wiki/Application/MySQL#Requirementsand seems pretty straight forward.
I have my server running, added that box and see it collecting data now. php5-cli and php-mysql are installed on both the server and mysql server
I
wish to monitor, but nothing has been added and not sure how to force check, add, etc.
Docs are simple enough; I created the user with access on the remote server. Then the steps are simply;
*Copy* the mysql script *from scripts/agent-local/* in your observium install to */usr/local/check_mk_agent/local/* (/usr/lib/check_mk_agent/local/ on Debian systems) the *server* you wish to monitor.
The remote server is running ubuntu, so I create a folder; /usr/lib/check_mk_agent/local with 2 files; mysql (script) mysql.cnf
I can run the script locally and get a lot of data (here is a sample); root@mysql101:/usr/lib/check_mk_agent/local# ./mysql <<<mysql>>> a0:13362926 a1:50929 a2:4796992 a3:287789
So is it something on the server end I need to add/edit?
Tnx
observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
Thanks guys. Added that and now I do see an 'apps' section. Unfortunately, most of the graph's look like broken images, aside from the network traffic one which has the 4 graph templates, which says error drawing graph.
In parallel I also setup apache which is giving all graph templates, but all have the error drawing graph.
So how can I test from the observium server to the server I want to test. I would compare the question to initial testing using snmpwalk -c -v1 server, to confirm 161 was listening etc. I want to see where the issue resolves with both mysql, apache, etc. Apache I am sure it's just the mod-status, but mysql is more important right now for me to get working.
Thanks.
On Mon, Jan 7, 2013 at 4:54 PM, Tom Laermans tom.laermans@powersource.cxwrote:
(then, it should be detected on the next polling run)
On 7/01/2013 22:09, Adam Armstrong wrote:
enable agent checking for that host in the device's settings.
also make sure the agent is accessible from the observium server.
adam.
On Mon, 7 Jan 2013 16:42:30 -0500, Lance Raymond lraymond@weatherflow.com wrote:
Checking out http://www.observium.org/wiki/**Application/MySQL#**Requirementsandhttp://www.observium.org/wiki/Application/MySQL#Requirementsand seems pretty straight forward.
I have my server running, added that box and see it collecting data now. php5-cli and php-mysql are installed on both the server and mysql server
I
wish to monitor, but nothing has been added and not sure how to force check, add, etc.
Docs are simple enough; I created the user with access on the remote server. Then the steps are simply;
*Copy* the mysql script *from scripts/agent-local/* in your observium install to */usr/local/check_mk_agent/**local/* (/usr/lib/check_mk_agent/**local/ on Debian systems) the *server* you wish to monitor.
The remote server is running ubuntu, so I create a folder; /usr/lib/check_mk_agent/local with 2 files; mysql (script) mysql.cnf
I can run the script locally and get a lot of data (here is a sample); root@mysql101:/usr/lib/check_**mk_agent/local# ./mysql <<<mysql>>> a0:13362926 a1:50929 a2:4796992 a3:287789
So is it something on the server end I need to add/edit?
Tnx
______________________________**_________________ observium mailing list observium@observium.org http://postman.memetic.org/**cgi-bin/mailman/listinfo/**observiumhttp://postman.memetic.org/cgi-bin/mailman/listinfo/observium
______________________________**_________________ observium mailing list observium@observium.org http://postman.memetic.org/**cgi-bin/mailman/listinfo/**observiumhttp://postman.memetic.org/cgi-bin/mailman/listinfo/observium
Has it created RRDs for the applications?
They'll be reasonably obviously labelled in the device's subdirectory in the rrd directory.
adam.
On Mon, 7 Jan 2013 21:40:45 -0500, Lance Raymond lraymond@weatherflow.com wrote:
Thanks guys. Added that and now I do see an 'apps' section. Unfortunately, most of the graph's look like broken images, aside from the network traffic one which has the 4 graph templates, which says
error
drawing graph.
In parallel I also setup apache which is giving all graph templates, but all have the error drawing graph.
So how can I test from the observium server to the server I want to
test.
I would compare the question to initial testing using snmpwalk -c -v1 server, to confirm 161 was listening etc. I want to see where the
issue
resolves with both mysql, apache, etc. Apache I am sure it's just the mod-status, but mysql is more important right now for me to get working.
Thanks.
On Mon, Jan 7, 2013 at 4:54 PM, Tom Laermans tom.laermans@powersource.cxwrote:
(then, it should be detected on the next polling run)
On 7/01/2013 22:09, Adam Armstrong wrote:
enable agent checking for that host in the device's settings.
also make sure the agent is accessible from the observium server.
adam.
On Mon, 7 Jan 2013 16:42:30 -0500, Lance Raymond lraymond@weatherflow.com wrote:
Checking out
http://www.observium.org/wiki/**Application/MySQL#**Requirementsandhttp://www.observium.org/wiki/Application/MySQL#Requirementsand
seems pretty straight forward.
I have my server running, added that box and see it collecting data now. php5-cli and php-mysql are installed on both the server and mysql server
I
wish to monitor, but nothing has been added and not sure how to force check, add, etc.
Docs are simple enough; I created the user with access on the remote server. Then the steps are simply;
*Copy* the mysql script *from scripts/agent-local/* in your observium install to */usr/local/check_mk_agent/**local/* (/usr/lib/check_mk_agent/**local/ on Debian systems) the *server* you wish to monitor.
The remote server is running ubuntu, so I create a folder; /usr/lib/check_mk_agent/local with 2 files; mysql (script) mysql.cnf
I can run the script locally and get a lot of data (here is a
sample);
root@mysql101:/usr/lib/check_**mk_agent/local# ./mysql <<<mysql>>> a0:13362926 a1:50929 a2:4796992 a3:287789
So is it something on the server end I need to add/edit?
Tnx
______________________________**_________________ observium mailing list observium@observium.org
http://postman.memetic.org/**cgi-bin/mailman/listinfo/**observiumhttp://postman.memetic.org/cgi-bin/mailman/listinfo/observium
______________________________**_________________ observium mailing list observium@observium.org
http://postman.memetic.org/**cgi-bin/mailman/listinfo/**observiumhttp://postman.memetic.org/cgi-bin/mailman/listinfo/observium
I don't see any obvious ones in either the mysql or apache ones. The path I have is; /opt/observium/rrd/mysql1.domain.com
in there I have; hr_processes.rrd port-1.rrd ucd_ssCpuRawNice.rrd hr_users.rrd port-2.rrd ucd_ssCpuRawSoftIRQ.rrd ipSystemStats-ipv4.rrd processor-hr-768.rrd ucd_ssCpuRawSystem.rrd ipSystemStats-ipv6.rrd status.rrd ucd_ssCpuRawUser.rrd mempool-hrstorage-1.rrd storage-hrstorage-_.rrd ucd_ssCpuRawWait.rrd mempool-hrstorage-3.rrd ucd_cpu.rrd ucd_ssIORawReceived.rrd netstats-icmp.rrd ucd_diskio-xvda1.rrd ucd_ssIORawSent.rrd netstats-ip.rrd ucd_load.rrd ucd_ssRawContexts.rrd netstats-snmp.rrd ucd_mem.rrd ucd_ssRawInterrupts.rrd netstats-tcp.rrd ucd_ssCpuRawIdle.rrd ucd_ssRawSwapIn.rrd netstats-udp.rrd ucd_ssCpuRawInterrupt.rrd ucd_ssRawSwapOut.rrd ospf-statistics.rrd ucd_ssCpuRawKernel.rrd uptime.rrd
None of those yell out Mysql.
Tnx
On Mon, Jan 7, 2013 at 9:06 PM, Adam Armstrong adama@memetic.org wrote:
Has it created RRDs for the applications?
They'll be reasonably obviously labelled in the device's subdirectory in the rrd directory.
adam.
On Mon, 7 Jan 2013 21:40:45 -0500, Lance Raymond lraymond@weatherflow.com wrote:
Thanks guys. Added that and now I do see an 'apps' section. Unfortunately, most of the graph's look like broken images, aside from the network traffic one which has the 4 graph templates, which says
error
drawing graph.
In parallel I also setup apache which is giving all graph templates, but all have the error drawing graph.
So how can I test from the observium server to the server I want to
test.
I would compare the question to initial testing using snmpwalk -c -v1 server, to confirm 161 was listening etc. I want to see where the
issue
resolves with both mysql, apache, etc. Apache I am sure it's just the mod-status, but mysql is more important right now for me to get working.
Thanks.
On Mon, Jan 7, 2013 at 4:54 PM, Tom Laermans tom.laermans@powersource.cxwrote:
(then, it should be detected on the next polling run)
On 7/01/2013 22:09, Adam Armstrong wrote:
enable agent checking for that host in the device's settings.
also make sure the agent is accessible from the observium server.
adam.
On Mon, 7 Jan 2013 16:42:30 -0500, Lance Raymond lraymond@weatherflow.com wrote:
Checking out
http://www.observium.org/wiki/**Application/MySQL#**Requirementsand< http://www.observium.org/wiki/Application/MySQL#Requirementsand%3E
seems pretty straight forward.
I have my server running, added that box and see it collecting data now. php5-cli and php-mysql are installed on both the server and mysql server
I
wish to monitor, but nothing has been added and not sure how to force check, add, etc.
Docs are simple enough; I created the user with access on the remote server. Then the steps are simply;
*Copy* the mysql script *from scripts/agent-local/* in your observium install to */usr/local/check_mk_agent/**local/* (/usr/lib/check_mk_agent/**local/ on Debian systems) the *server* you wish to monitor.
The remote server is running ubuntu, so I create a folder; /usr/lib/check_mk_agent/local with 2 files; mysql (script) mysql.cnf
I can run the script locally and get a lot of data (here is a
sample);
root@mysql101:/usr/lib/check_**mk_agent/local# ./mysql <<<mysql>>> a0:13362926 a1:50929 a2:4796992 a3:287789
So is it something on the server end I need to add/edit?
Tnx
______________________________**_________________ observium mailing list observium@observium.org
http://postman.memetic.org/**cgi-bin/mailman/listinfo/**observium< http://postman.memetic.org/cgi-bin/mailman/listinfo/observium%3E
______________________________**_________________ observium mailing list observium@observium.org
http://postman.memetic.org/**cgi-bin/mailman/listinfo/**observium< http://postman.memetic.org/cgi-bin/mailman/listinfo/observium%3E
observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
participants (3)
-
Adam Armstrong -
Lance Raymond -
Tom Laermans