Tom Smith | 26 Nov 05:33 2015

restrict user view/access by items


I need to setup a user so he can view only a particular item latest data for a host or host group. without seeing or changing anything else.

Is there a way to do this. So far all permission docs I see are to restrict access
by hostgroup.

Thanks in advance.
Go from Idea to Many App Stores Faster with Intel(R) XDK
Give your users amazing mobile app experiences with Intel(R) XDK.
Use one codebase in this all-in-one HTML5 development environment.
Design, debug & build mobile apps & 2D/3D high-impact games for multiple OSs.
Zabbix-users mailing list
Zabbix-users <at>
Nicolas C. | 22 Nov 10:53 2015

Poor performances with MySQL 5.7


I'm using Zabbix 2.4.7 with MySQL Community Server 5.6.27 on a Debian 
Jessie virtual machine, we currently have 740 NVPS (roughly 60 millions 
rows per day).

We use MySQL partitioning 
( : hourly for 
"history" and "history_uint" and daily for the others tables.

We tried upgrading MySQL to 5.7.9 and we experienced very poor 
performances with the database :

  - intensive reads on the database, even when nobody was on the 
frontend (didn't happen with MySQL 5.6)

  - Dashboard very slow when the filter is disabled (a few minutes to 
display the page)

  - Peaks of "history syncer processes", 100% during several minutes. 
With MySQL 5.6 the average is 1% busy with the default value 

  - Drops in "free history write cache". With MySQL 5.6 and 
HistoryCacheSize=128M we have 99.94% free history write cache on average.

All this issues happened on a Saturday with no particular activity on 
the storage and the server. We switched back to 5.6 and everything was 
back to normal.

Before upgrading on the production server, we tested on a Zabbix 
installation with less NVPS and MySQL 5.7 was working fine.

For information, we tweaked your MySQL configuration with the percona 
guide :

max_connections = 500

sync_binlog = 0
query_cache_size = 0
query_cache_type = 0

innodb_flush_method = O_DIRECT
innodb_buffer_pool_instances = 8
innodb_file_per_table = 1
innodb_buffer_pool_size = 8G
innodb_flush_log_at_trx_commit = 0
innodb_io_capacity = 800

Is anyone using MySQL 5.7 as database for Zabbix ? Any idea why it works 
normally on a test server with 40NVPS but not on a production server 
with 740NVPS ?



Pedro Roger | 19 Nov 15:43 2015

Monitor active connections per database in a single graph

Hello all!

My objective is build a graph to display the connections per individual postgresql database and total connections as well.

I call a script via zabbix agent that have the following text as output:

database1: 114
database2: 170
database3: 130
database4: 274
Total: 688

I know i can create a item to each database, and plot them in a single graph, but can i  get the values dynamically via a item (text type)?.

Pedro Roger Magalhães Vasconcelos
Zabbix-users mailing list
Zabbix-users <at>
Kodai Terashima | 18 Nov 03:34 2015

Re: Zabbix 2.4.7 missing packages for Jessie

Hi Florent,

I found a problem in build & release automation script.
I fixed it, and release jessie packages. Please confirm.


> On 2015 Nov 17, at 00:40, Florent B <florent <at>> wrote:
> Hi,
> Since Zabbix Server 2.4.7 was released, Jessie packages are missing for
> this version.
> Wheezy packages are available.
> Thank you.
> Florent
> ------------------------------------------------------------------------------
> Presto, an open source distributed SQL query engine for big data, initially
> developed by Facebook, enables you to easily query your data on Hadoop in a 
> more interactive manner. Teradata is also now providing full enterprise
> support for Presto. Download a free open source copy now.
> _______________________________________________
> Zabbix-users mailing list
> Zabbix-users <at>

Wolfgang Schnerring | 9 Nov 17:05 2015

Parameters: quoting of special characters


says, "if the key parameter is a quoted string, any Unicode character is
allowed, and included double quotes must be backslash escaped."

But then this happens:
  $ zabbix_get -s localhost -k 'solr.query_count["myfield:$(echo example)"]'
  ZBX_NOTSUPPORTED: special characters "\, ', ", `, *, ?, [, ], {, }, ~, $,
!, &, ;, (, ), <, >, |, #,  <at> , 0x0a" are not allowed in the parameters

Which leaves me totally stumped. I quoted the parameter that contains the
evil $, did I not? What am I missing?

Thanks for your help,

PS: For completeness, the "solr.query_count" is defined like this:
  UserParameter=solr.query_count[*],/etc/zabbix/checks/ "$1"

Presto, an open source distributed SQL query engine for big data, initially
developed by Facebook, enables you to easily query your data on Hadoop in a 
more interactive manner. Teradata is also now providing full enterprise
support for Presto. Download a free open source copy now.
Nicolas C. | 4 Nov 14:43 2015

PSA : MySQL partitioning on ext4 and thin-provisioning storage


FYI, if you're using Zabbix with MySQL partitioning on thin-provisioned 
storage, ext4 might not be the best file-system.

ext4 tends to allocate new blocks instead of using "old" ones:

This is not an issue on traditional storage, but on a SAN with 
thin-provisioning and tiering capabilities, this is counterproductive. 
The solution is to switch to XFS or ext3.

Here is a real-life example on our Zabbix server (Debian Jessie) where 
the occupation of /var/lib/mysql is stable around 75G thanks to 
partitioning but the amount of blocks really allocated on the storage 
keeps increasing :

If anyone knows how to get the allocation strategy of XFS on ext4, I'm 



Sophie Loewenthal | 3 Nov 14:28 2015

How could I reduce size of table history_uint with 94Gb and rows 822574588 on mysql ?


    Mysql table zabbix.history_uint table has grown to 94Gb of disc space with many rows.  All my queries against this table result with extremely high mysqld usage and Zabbix web front end reports time outs and cannot connect during this period.  So far I have had to kill the query.

How could I trim this file down to a reasonable size?

mysql> show table status like 'history_uint' \G; *************************** 1. row *************************** Name: history_uint Engine: InnoDB Version: 10 Row_format: Compact Rows: 822574588 Avg_row_length: 68 Data_length: 56494145536 Max_data_length: 0 Index_length: 41846669312 Data_free: 138412032 Auto_increment: NULL Create_time: 2013-06-12 10:11:01 Update_time: NULL Check_time: NULL Collation: utf8_general_ci Checksum: NULL Create_options: Comment: 1 row in set (0.03 sec)

Zabbix 2.2.3-0 on CentOS 6.2 with Percona-Server-server-55-5.5.30-rel30.2.508.rhel6.x86_64


I've googled and found lots of queries but they all hang Zabbix. 

Example queries:

Trying to create a new table with trimmed history that I could replace table history_uint with,
CREATE TABLE history_uint_new LIKE history_uint; INSERT INTO history_uint_new SELECT * FROM history_uint WHERE clock > '1383474850';
Trying to remove orphaned data
DELETE FROM history_uint WHERE itemid NOT IN (SELECT itemid FROM items);

Kind regards,

Zabbix-users mailing list
Zabbix-users <at>
Tom Smith | 30 Oct 21:49 2015

monitor windows event


I saw some examples of monitor Windows eventlog using
active agent. mode, which requests Zabbix server to listen
on the port and allow client systems initiate connection
to server, something undezirable due to security concern.

is there a way to monitor with passive agent mode?
meaning zabbix would initiate and poll for Windows events.

Thanks in Advance
Zabbix-users mailing list
Zabbix-users <at>
Arash Shams | 25 Oct 13:09 2015

define userparameter and got ZBX_NOTSUPPORTED

i want to ping an external ip from all of my servers that running zabbix agent.
i searched and find some articles about zabbix user parameters.
so in /etc/zabbix/zabbix_agentd.conf.d/ i create a file named userparameter_ping.conf with following content :
UserParameter=checkip[*],ping -c4 && echo 0 || echo 1

now i create an item named checkip in zabbix server with a graph but got no data .
in another digging i found zabbix_get and test my userparameter so i got error : ZBX_NOTSUPPORTED

# zabbix_get -s -p 10050 -k checkip

any suggestion ?

<!-- .hmmessage P { margin:0px; padding:0px } body.hmmessage { font-size: 12pt; font-family:Calibri } -->
Zabbix-users mailing list
Zabbix-users <at>
Keith | 23 Oct 22:00 2015

PG Partman 2.2.0 now supports epoch partitioning in PostgreSQ

I'm the author of pg_partman and I've had many Zabbix users ask if my extension can be used with it (It's even mentioned in one of your wikis Until recently the answer had been no because I did not have a means to partition by epoch (an integer column partitioned by time). I recently released version 2.2.0 which now supports this! 

Keep in mind that it does have a minimum requirement of PostgreSQL 9.4, which is currently the latest major release. This is mainly due to the fact that it now also contains a background worker to automatically run maintenance from within the database and no longer requires an external scheduler. 

If you have any issues or feedback, please feel free to post to the Github Issues tracker in the repo. Zabbix was the main reason I put the work into including this feature, so I hope you find it useful.

Zabbix-users mailing list
Zabbix-users <at>
Manish Singh3 | 11 Oct 14:13 2015

Xenserver VM discovery

Hi All

Any way to put Virtual machine discovery in zabbix for Xenserver monitoring.

Manish Singh
Zabbix-users mailing list
Zabbix-users <at>