Zabbix configuring mysql

[jnagaraj]

Hi,
Would like to bring to your notice that I have installed zabbix -1.8. of the latest version using the predefined documentation

After extracting the zip file of zabbix receiving an error message MYSQL library files are missing?

I have installed mysql library files
(libmysqlclient16)
even though I am facing the same problem, is there any way to resolve this problem? Because of this I am not able to configure or make installation of zabbix?

[0siris]

I think you need the -dev versions as well.

[jnagaraj]

how to monitor apache in zabbix server?

First of all thanks for the wonderful zabbix software with enough features.

I have couple of questions while monitoring individual process in zabbix server

How do I monitor apache2 in zabbix server? As I have gone through the zabbix wiki I didn't get it properly.

I would need your assistance to help monitoring the apache2 in zabbix server..

[0siris]

I can't remember if a default zabbix installation has templates for monitoring operating system, but I think it does, so please have a look at them, you will find what you need. In short, create an item with key "proc.num[apache2]", and then create a trigger with name "Apache2 is not running on {HOSTNAME}" and expression "{Template_OS_Linuxroc.num[apache2].last(0)}<1".

This should be covered in the manual, so please let us know where you're stuck and what you have tried.

[jnagaraj]

Monitoring apache web server

First of all thank you very much for your feedback!!!

Well, I have tried by adding some information under Userparameter for zabbix_agentd report along with that template have been added in the zabbix host. Now if I need to have apache graph along with failure notification when it is down.

Sorry main thing forgot to ask you, how do I run apache2 in zabbix is there any command to run?


UserParameter=apache.accesses,wget --quiet -O - https://localhost/server-status?auto | head -n 9 | grep Accesses | cut -d " " -f 3

UserParameter=apache.totalkb,wget --quiet -O - https://localhost/server-status?auto | head -n 9 | grep kBytes | cut -d " " -f 3

UserParameter=apache.cpuload,wget --quiet -O - https://localhost/server-status?auto | head -n 9 | grep CPULoad | cut -d " " -f 2

UserParameter=apache.uptime,wget --quiet -O - https://localhost/server-status?auto | head -n 9 | grep Uptime | cut -d " " -f 2

UserParameter=apache.reqpersec,wget --quiet -O - https://localhost/server-status?auto | head -n 9 | grep ReqPerSec | cut -d " " -f 2

UserParameter=apache.bytespersec,wget --quiet -O - https://localhost/server-status?auto | head -n 9 | grep BytesPerSec | cut -d " " -f 2

UserParameter=apache.bytesperrec,wget --quiet -O - https://localhost/server-status?auto | head -n 9 | grep BytesPerReq | cut -d " " -f 2

UserParameter=apache.busywokers,wget --quiet -O - https://localhost/server-status?auto | head -n 9 | grep BusyWorkers | cut -d " " -f 2

UserParameter=apache.idleworkers,wget --quiet -O - https://localhost/server-status?auto | head -n 9 | grep IdleWorkers | cut -d " " -f 2

Would you please need your assistance in all these?

[0siris]

I don't understand your question about running apache2 in zabbix. Apart from that, it would work better if you explain what specifically is not working, instead of dumping a configfile, and asking for help without explaining what you want to do, what parts of your idea work, what parts don't, etcetera.

I think you're stuck on some very basic Zabbix ideas that need both reading in the manual, and trying for yourself.

[jnagaraj]

Monitoring apache web server

Hi 0siris,

Let me explain you more clearly about my clarification.

I have gone through zabbix wiki for apache monitoring.
here you go with site.
http://www.zabbix.com/wiki/templates/apache

I have followed method 1 instructions as per the wiki, but it didn't took me in the right path.

1) Downloaded fetch.py file in monitoring script folder.
2) Changed the permission to chmod +x fetch.py
3) * * * * * /usr/bin/python <some location>/ZabbixApacheUpdater.py -c host.being.monitored.com -z my.zabbix.server.com > /dev/null 2>&1 --> Not sure (some location) stands for.
4) Added server-status in the apache config.
5) Restarted the apache process.
6) Downloaded the zabbix_export.xml and changed the ip address and default port number was set in xml.
7) Link the Template_App_Apache_Stats into the hosts in question or link Template_App_Apache_Stats to Template_App_Apache. (not understood how exactly it should get linked)

In the zabbix web host I found that "Apache is not running on Zabbix server" as of now, but unable to identify where exactly the problem is.

sorry for the inconvenience.

[0siris]

<some location> means the location of the Python script where you've put it on the webserver.

Is Python installed on that webserver as well? What output do you get when you run that crontab command from the shell prompt as user "zabbix"? Did you reconfigure Apache correctly? If so, how are you sure that you did?

[jnagaraj]

Monitoring apache web server

There are 2 scripts have been attached in the wiki.
1) fetch.py
2) query_apachestats.py

I have considered the fetch.py script and have placed in the zabbix folder.
Yes python have been installed in the zabbix server

Along with this as per wiki there is another script called zapache to parse the apache, do I need to consider all 3 scripts and store it in external script folder? Correct me if I am wrong over here.

If I run a command nothing I can find.
* * * * * /usr/bin/python <some location>/ZabbixApacheUpdater.py -c this.machines.hostname.com -z my.zabbix.server.com > /dev/null 2>&1

Yes apache have been configured correctly and it's working fine.