Re: [Observium] Adding mysql monitoring
The agent is not enabled for that host :-)
Lance Raymond lraymond@weatherflow.com wrote:
observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
BAM.
I thought by selecting the app, it pretty much said I want to do that (maybe a popup saying don't forget to enable unix-agent), but I won't forget that moving on.
So after enabling that, got an error saying the agent wasn't installed, so got that, opened 5665, images appeared, a few minutes later, data on the graph's.
Thanks for the patience and guidance ...
~ Lance
On 1/7/13 11:28 PM, Adam Armstrong wrote:
The agent is not enabled for that host :-)
Lance Raymond lraymond@weatherflow.com wrote:
Learning on the fly, but did a poller -h device -v and got;
mysql1.domain.com http://mysql1.domain.com 3 linux (unix) Module [ unix-agent ] disabled globally. Using hrSystemUptime (3:10:00:42.48) Uptime: 3 days, 10h 42s
Hardware: Generic x86 64-bit Version: 3.2.0-31-virtual Features: /usr/bin/distro: No such file or directory Serial: IPMI: Processor Intel Xeon E5430 @ 2.66GHz 1% Mempool Physical memory: 35.76% Mempool Virtual memory: 35.76% Storage /: 18% Polling Netstats: IP TCP UDP ICMP SNMP HR Stats: Processes Users Polling IP-MIB ipSystemStats ipv4 ipv6 Caching Oids: ifEntry ifXEntry dot3StatsDuplexStatusvalidvalid Port lo(1) HC HC VLAN == bps(0bps/0bps)bytes(0B/0B)pkts(0pps/0pps) Port eth0(2) HC HC VLAN == bps(2.5kbps/29.5kbps)bytes(10.6kB/126kB)pkts(4.6pps/3.83pps) Checking UCD DiskIO MIB: xvda1
OSPF: Processes: Areas: Ports: Neighbours:
Entity Physical: Applications: uptime netstat_ip netstat_ip_frag netstat_tcp netstat_udp netstat_icmp netstat_icmp_info netstat_snmp netstat_snmp_pkt hr_processes hr_users ucd_cpu ucd_swap_io ucd_io ucd_contexts ucd_interrupts ucd_memory ucd_load ipsystemstats_ipv4 ipsystemstats_ipv4_frag ipsystemstats_ipv6 ipsystemstats_ipv6_frag Polled in 2.781 seconds UPDATED!
MySQL: Cell[0/0s] Row[3/0s] Rows[25/0.01s] Column[0/0s] Update[7/0.02s] Insert[4/0.02s] Delete[0/0s]
On Mon, Jan 7, 2013 at 10:35 PM, Adam Armstrong <adama@memetic.org mailto:adama@memetic.org> wrote:
I just added apache/mysql agents to a clean install and it worked OK. Run the poller with -d Adam. Lance Raymond <lraymond@weatherflow.com <mailto:lraymond@weatherflow.com>> wrote: 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 <http://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 <mailto: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 <mailto: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.cx <mailto:tom.laermans@powersource.cx>>wrote: > >> (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 <mailto:lraymond@weatherflow.com>> >>> wrote: >>> >>>> Checking out >>>> http://www.observium.org/wiki/**Application/MySQL#**Requirementsand<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 <mailto:observium@observium.org> >>> http://postman.memetic.org/**cgi-bin/mailman/listinfo/**observium<http://postman.memetic.org/cgi-bin/mailman/listinfo/observium> >>> >> >> ______________________________**_________________ >> observium mailing list >> observium@observium.org <mailto:observium@observium.org> >> http://postman.memetic.org/**cgi-bin/mailman/listinfo/**observium<http://postman.memetic.org/cgi-bin/mailman/listinfo/observium> >> _______________________________________________ observium mailing list observium@observium.org <mailto:observium@observium.org> http://postman.memetic.org/cgi-bin/mailman/listinfo/observium -- *e*. lraymond@weatherflow.com <mailto:lraymond@weatherflow.com> *c.* 386.561.1509 <tel:386.561.1509> *f.*386.409.5178 <tel:386.409.5178> _______________________________________________ observium mailing list observium@observium.org <mailto:observium@observium.org> http://postman.memetic.org/cgi-bin/mailman/listinfo/observium--
*e*. lraymond@weatherflow.com mailto:lraymond@weatherflow.com *c.* 386.561.1509 *f.*386.409.5178
observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
You're lucky you didn't get the observium email list sarcasm!
-m
On Tue, Jan 8, 2013 at 6:31 AM, Lance Raymond lraymond@weatherflow.comwrote:
BAM.
I thought by selecting the app, it pretty much said I want to do that (maybe a popup saying don't forget to enable unix-agent), but I won't forget that moving on.
So after enabling that, got an error saying the agent wasn't installed, so got that, opened 5665, images appeared, a few minutes later, data on the graph's.
Thanks for the patience and guidance ...
~ Lance
On 1/7/13 11:28 PM, Adam Armstrong wrote:
The agent is not enabled for that host :-)
Lance Raymond lraymond@weatherflow.com lraymond@weatherflow.com wrote:
Learning on the fly, but did a poller -h device -v and got;
mysql1.domain.com 3 linux (unix) Module [ unix-agent ] disabled globally. Using hrSystemUptime (3:10:00:42.48) Uptime: 3 days, 10h 42s
Hardware: Generic x86 64-bit Version: 3.2.0-31-virtual Features: /usr/bin/distro: No such file or directory Serial: IPMI: Processor Intel Xeon E5430 @ 2.66GHz 1% Mempool Physical memory: 35.76% Mempool Virtual memory: 35.76% Storage /: 18% Polling Netstats: IP TCP UDP ICMP SNMP HR Stats: Processes Users Polling IP-MIB ipSystemStats ipv4 ipv6 Caching Oids: ifEntry ifXEntry dot3StatsDuplexStatusvalidvalid Port lo(1) HC HC VLAN == bps(0bps/0bps)bytes(0B/0B)pkts(0pps/0pps) Port eth0(2) HC HC VLAN == bps(2.5kbps/29.5kbps)bytes(10.6kB/126kB)pkts(4.6pps/3.83pps) Checking UCD DiskIO MIB: xvda1
OSPF: Processes: Areas: Ports: Neighbours:
Entity Physical: Applications: uptime netstat_ip netstat_ip_frag netstat_tcp netstat_udp netstat_icmp netstat_icmp_info netstat_snmp netstat_snmp_pkt hr_processes hr_users ucd_cpu ucd_swap_io ucd_io ucd_contexts ucd_interrupts ucd_memory ucd_load ipsystemstats_ipv4 ipsystemstats_ipv4_frag ipsystemstats_ipv6 ipsystemstats_ipv6_frag Polled in 2.781 seconds UPDATED!
MySQL: Cell[0/0s] Row[3/0s] Rows[25/0.01s] Column[0/0s] Update[7/0.02s] Insert[4/0.02s] Delete[0/0s]
On Mon, Jan 7, 2013 at 10:35 PM, Adam Armstrong adama@memetic.orgwrote:
I just added apache/mysql agents to a clean install and it worked OK.
Run the poller with -d
Adam.
Lance Raymond lraymond@weatherflow.com wrote:
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
--
*e*. lraymond@weatherflow.com *c.* 386.561.1509 *f.* 386.409.5178
observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
--
*e*. lraymond@weatherflow.com *c.* 386.561.1509 *f.* 386.409.5178
observium mailing listobservium@observium.orghttp://postman.memetic.org/cgi-bin/mailman/listinfo/observium
observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
:D Got that one my 1st post! I was pretty good at asking the questions correctly, IMO there should be certain things like if you add an app, it should either javascript pop to remind you to enable the unix-agent, etc. Not needing everything, I went to the app, looking here http://www.observium.org/wiki/Application/MySQL there is no mention at all about needing the agent which is why I posted.
Now, I am having an issue with the apache module, so look for a new thread shortly :)
~ Lr
On Tue, Jan 8, 2013 at 8:37 PM, Morgan McLean wrx230@gmail.com wrote:
You're lucky you didn't get the observium email list sarcasm!
-m
On Tue, Jan 8, 2013 at 6:31 AM, Lance Raymond lraymond@weatherflow.comwrote:
BAM.
I thought by selecting the app, it pretty much said I want to do that (maybe a popup saying don't forget to enable unix-agent), but I won't forget that moving on.
So after enabling that, got an error saying the agent wasn't installed, so got that, opened 5665, images appeared, a few minutes later, data on the graph's.
Thanks for the patience and guidance ...
~ Lance
On 1/7/13 11:28 PM, Adam Armstrong wrote:
The agent is not enabled for that host :-)
Lance Raymond lraymond@weatherflow.com lraymond@weatherflow.comwrote:
Learning on the fly, but did a poller -h device -v and got;
mysql1.domain.com 3 linux (unix) Module [ unix-agent ] disabled globally. Using hrSystemUptime (3:10:00:42.48) Uptime: 3 days, 10h 42s
Hardware: Generic x86 64-bit Version: 3.2.0-31-virtual Features: /usr/bin/distro: No such file or directory Serial: IPMI: Processor Intel Xeon E5430 @ 2.66GHz 1% Mempool Physical memory: 35.76% Mempool Virtual memory: 35.76% Storage /: 18% Polling Netstats: IP TCP UDP ICMP SNMP HR Stats: Processes Users Polling IP-MIB ipSystemStats ipv4 ipv6 Caching Oids: ifEntry ifXEntry dot3StatsDuplexStatusvalidvalid Port lo(1) HC HC VLAN == bps(0bps/0bps)bytes(0B/0B)pkts(0pps/0pps) Port eth0(2) HC HC VLAN == bps(2.5kbps/29.5kbps)bytes(10.6kB/126kB)pkts(4.6pps/3.83pps) Checking UCD DiskIO MIB: xvda1
OSPF: Processes: Areas: Ports: Neighbours:
Entity Physical: Applications: uptime netstat_ip netstat_ip_frag netstat_tcp netstat_udp netstat_icmp netstat_icmp_info netstat_snmp netstat_snmp_pkt hr_processes hr_users ucd_cpu ucd_swap_io ucd_io ucd_contexts ucd_interrupts ucd_memory ucd_load ipsystemstats_ipv4 ipsystemstats_ipv4_frag ipsystemstats_ipv6 ipsystemstats_ipv6_frag Polled in 2.781 seconds UPDATED!
MySQL: Cell[0/0s] Row[3/0s] Rows[25/0.01s] Column[0/0s] Update[7/0.02s] Insert[4/0.02s] Delete[0/0s]
On Mon, Jan 7, 2013 at 10:35 PM, Adam Armstrong adama@memetic.orgwrote:
I just added apache/mysql agents to a clean install and it worked OK.
Run the poller with -d
Adam.
Lance Raymond lraymond@weatherflow.com wrote:
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.orgwrote:
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
--
*e*. lraymond@weatherflow.com *c.* 386.561.1509 *f.* 386.409.5178
observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
--
*e*. lraymond@weatherflow.com *c.* 386.561.1509 *f.* 386.409.5178
observium mailing listobservium@observium.orghttp://postman.memetic.org/cgi-bin/mailman/listinfo/observium
observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
-- Thanks, Morgan
observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
participants (3)
-
Adam Armstrong -
Lance Raymond -
Morgan McLean