Zabbix 3.0.9

scottalanmiller

paging @dafyre and our resident Zabbix guy

dafyre

Can you post a screenshots of how you have your action configured?

Also, in the Zabbix Agent, you'll need to make sure that both the Server and ServerActive items are set to be the IP address of your zabbix server... and that Remote Commands are enabled.

/etc/zabbix/zabbix_agentd.conf

#IP Of Zabbix Server
Server = 192.168.200.10
ServerActive = 192.168.200.10

#Enable Remote Commands for restarting services
EnableRemoteCommands = 1

Ajin

@dafyre : both the Server and ServerActive items are set to the IP address of zabbix server.
Remote Commands are also enabled.

Attaching screenshot for action conditions & operations.

Mike Davis

@scottalanmiller said in Zabbix 3.0.9:

@wirestyle22 said in Zabbix 3.0.9:

paging @dafyre and our resident Zabbix guy

And @Mike-Davis

I've only set up the action to email. Never tried remote commands, but it gives me some ideas.

Ajin

@Mike-Davis : My Idea was to create a monitoring / alerting system and also minimize downtime for critical issue like Apache , Mysql and other critical server services which affects server perfomance, This action section actuality does it all since it can both send alerts via email and sms and also execute remote commands.

But of-course, only if it is configured correctly and works well

hobbit666

I'm going to be looking more at Zabbix over the next few months and exploring it's power and potential

Mike Davis

@Ajin said in Zabbix 3.0.9:

@Mike-Davis : My Idea was to create a monitoring / alerting system and also minimize downtime for critical issue like Apache , Mysql and other critical server services which affects server perfomance, This action section actuality does it all since it can both send alerts via email and sms and also execute remote commands.

But outsource, only if it is configured correctly and works well

It's a good idea. I haven't had a need yet, but I'm sure that day will come.

dafyre

@Ajin said in Zabbix 3.0.9:

@dafyre : both the Server and ServerActive items are set to the IP address of zabbix server.
Remote Commands are also enabled.

Attaching screenshot for action conditions & operations.

What if you set the Remote Command type to "Custom Script" and had it execute something like systemctl restart apache2 or httpd, whatever your distro uses...

0_1495114640947_upload-6dc12176-0deb-482e-b0a2-955dae73f93e

Ajin

@dafyre : Thankyou so Much because ..Yesssss That did the job ...Remote command got executed in the host when selected the TYPE as custom script and services which went down is restarting in 60 seconds as configured.

Another thing i am testing now is , Since the Action Section uses zabbix-agent to run the custom script type to execute remote command ; what if the zabbix-agent itself went down or had some issue and it coudnt respond to server checks ? . Here this scenario (Choosing the TYPE as custom script)will fail for all other Actions . IN that case i need to fix the Remote command execution via SSH and also Test the GLOBAL SCRIPT Type to check zabbix-agent service.

Since i am planning to Implement this Tool in my Production Environment , need to think and test every possible scenarios where server or its critical services can get screwed up !!! And now next global script and again ssh ..

wirestyle22

@Ajin Glad you got that working

dafyre

@dafyre said in Zabbix 3.0.9:

@Ajin said in Zabbix 3.0.9:

@dafyre : both the Server and ServerActive items are set to the IP address of zabbix server.
Remote Commands are also enabled.

Attaching screenshot for action conditions & operations.

What if you set the Remote Command type to "Custom Script" and had it execute something like systemctl restart apache2 or httpd, whatever your distro uses...

Glad that it worked for you!

dafyre

@Ajin said in Zabbix 3.0.9:

Another thing i am testing now is , Since the Action Section uses zabbix-agent to run the custom script type to execute remote command ; what if the zabbix-agent itself went down or had some issue and it coudnt respond to server checks ? . Here this scenario (Choosing the TYPE as custom script)will fail for all other Actions . IN that case i need to fix the Remote command execution via SSH and also Test the GLOBAL SCRIPT Type to check zabbix-agent service.
Since i am planning to Implement this Tool in my Production Environment , need to think and test every possible scenarios where server or its critical services can get screwed up And now next global script and again ssh ..

In this scenario, if the Zabbix agent goes down, the custom scripts won't run, I'd imagine.

I've never gone down the rabbit hole quite that far. I would assume if the Zabbix agent is not responding that you would have other issues (or set the Zabbix server to alert you that the Zabbix agent wasn't responding).

Ajin

@dafyre :Ran Into another problem Now.
Mysql service up/down status is not displayed in host status Tab. But in the graph part all mysql data is fetched from client machine and displayed in Zabbix server .like Mysql Bandwidth ,Mysql Uptime , Mysql operations ect .

Since the service up/down is not being displayed in host status , Cannot execute Actions (remote command & notifications)

All other services like Apache , ssh , telnet , cpu hike , Disk usage , Network usage .. every actions to the above said services are being fetched by zabbix-agent and displayed in zabbix-server GUI.

Checked the Zabbix-server log ,

Data for mysql services are being logged , But not displaying the service UP or down in server GUI.

LOG:
[root@Z3 ~]# tail -f /var/log/zabbix/zabbix_server.log | grep mysql
2259:20170521:151451.735 Sending [mysql.status[Questions]
2261:20170521:151452.738 In substitute_key_macros() data:'mysql.status[Slow_queries]'
2261:20170521:151452.738 End of substitute_key_macros():SUCCEED data:'mysql.status[Slow_queries]'
2261:20170521:151452.738 In get_value() key:'mysql.status[Slow_queries]'
2261:20170521:151452.738 In get_value_agent() host:'2.test.com' addr:'10.132.166.113' key:'mysql.status[Slow_queries]' conn:'unencrypted'
2261:20170521:151452.739 Sending [mysql.status[Slow_queries]
2262:20170521:151453.743 In substitute_key_macros() data:'mysql.status[Uptime]'
2262:20170521:151453.743 End of substitute_key_macros():SUCCEED data:'mysql.status[Uptime]'
2262:20170521:151453.744 In get_value() key:'mysql.status[Uptime]'
2262:20170521:151453.744 In get_value_agent() host:'2.test.com' addr:'10.132.166.113' key:'mysql.status[Uptime]' conn:'unencrypted'
2262:20170521:151453.744 Sending [mysql.status[Uptime]

dafyre

@Ajin said in Zabbix 3.0.9:

@dafyre :Ran Into another problem Now.
Mysql service up/down status is not displayed in host status Tab. But in the graph part all mysql data is fetched from client machine and displayed in Zabbix server .like Mysql Bandwidth ,Mysql Uptime , Mysql operations ect .

Since the service up/down is not being displayed in host status , Cannot execute Actions (remote command & notifications)

All other services like Apache , ssh , telnet , cpu hike , Disk usage , Network usage .. every actions to the above said services are being fetched by zabbix-agent and displayed in zabbix-server GUI.

Checked the Zabbix-server log ,

Data for mysql services are being logged , But not displaying the service UP or down in server GUI.

LOG:
[root@Z3 ~]# tail -f /var/log/zabbix/zabbix_server.log | grep mysql
2259:20170521:151451.735 Sending [mysql.status[Questions]
2261:20170521:151452.738 In substitute_key_macros() data:'mysql.status[Slow_queries]'
2261:20170521:151452.738 End of substitute_key_macros():SUCCEED data:'mysql.status[Slow_queries]'
2261:20170521:151452.738 In get_value() key:'mysql.status[Slow_queries]'
2261:20170521:151452.738 In get_value_agent() host:'2.test.com' addr:'10.132.166.113' key:'mysql.status[Slow_queries]' conn:'unencrypted'
2261:20170521:151452.739 Sending [mysql.status[Slow_queries]
2262:20170521:151453.743 In substitute_key_macros() data:'mysql.status[Uptime]'
2262:20170521:151453.743 End of substitute_key_macros():SUCCEED data:'mysql.status[Uptime]'
2262:20170521:151453.744 In get_value() key:'mysql.status[Uptime]'
2262:20170521:151453.744 In get_value_agent() host:'2.test.com' addr:'10.132.166.113' key:'mysql.status[Uptime]' conn:'unencrypted'
2262:20170521:151453.744 Sending [mysql.status[Uptime]

Do you mean that you cannot tell whether or not the MySQL Service is running?

JaredBusch

Do you even have MySQL? You might have MariaDB.

Ajin

@JaredBusch : yes , I have mariadb. (Server version: 5.5.52-MariaDB MariaDB Server)
Is there any compatibility issue with zabbbix-server and mariadb ?

JaredBusch

@Ajin said in Zabbix 3.0.9:

@JaredBusch : yes , I have mariadb. (Server version: 5.5.52-MariaDB MariaDB Server)
Is there any compatibility issue with zabbbix-server and mariadb ?

I mean on the box you are trying to get an alert from.

You are looking for the MySQL service, it does not exist if you are using MariaDB.

Ajin

@JaredBusch : Yea i agree but the only template present in Zabbix-server to monitor DB servers for Linux is "Template App MySQL".
Zabbix forums also says that "Template App MySQL". is used to monitor MariaDB databases.

dafyre

If you want to see it on a graph, you could Add a graph to the Template App MySQL... and then add the Template app MySQL to the MariaDB servers you have...

Your Graph would look something like:
0_1495518300608_upload-e3f0ab7a-817a-443d-8aa9-21fb920cb5c1

Ajin

@dafyre :Thanks a lot , Will test it out and post back