Guus Snijders | 14 Dec 14:00 2015
Picon

Re: template import fails with Zabbix 2.4.7

2015-12-14 13:57 GMT+01:00 Guus Snijders <gsnijders <at> gmail.com>:

Hi there,

when attempting to import a template[1], the webpage gets corrupted;
instead of importing, about the second half of the XML contents are
added to the HTML page. I saved both 'versions' of the webpage and
will try to add them to this e-mail. Not sure if the list allows this,
though.
[Edit: attachment not allowed. I can publish both on dropbox if anyone
is interested]

Of course, tt could be a problem with the template itself, but it
looks a zabbix bug.
Curious if anyone else ran into issues with this version before
posting a bug report.

Versions: We've seen this happen with 2.4.7 and with the previous
version, Zabbix 2.4.6 (revision 54796).
We also have a 2.4.1 server running, that one has no problems
importing the same template.

[1]
https://share.zabbix.com/databases/microsoft-sql-server/template-app-ms-sql-database-discovery-lld

mvg,
     Guus Snijders

------------------------------------------------------------------------------
(Continue reading)

Tom Smith | 3 Dec 05:54 2015
Picon

windows event log id selection

Hi,

I am using the following

item.logeventid(^12$|^34$) = 0

to exclude some event ids. (in this example, exclude event id = 12 or 34)
but appears not working.

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.
http://pubads.g.doubleclick.net/gampad/clk?id=254741911&iu=/4140
_______________________________________________
Zabbix-users mailing list
Zabbix-users <at> lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/zabbix-users
Tom Smith | 26 Nov 05:33 2015
Picon

restrict user view/access by items

Hello:

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.
http://pubads.g.doubleclick.net/gampad/clk?id=254741551&iu=/4140
_______________________________________________
Zabbix-users mailing list
Zabbix-users <at> lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/zabbix-users
Nicolas C. | 22 Nov 10:53 2015
Picon

Poor performances with MySQL 5.7

Hello,

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 
(https://www.zabbix.org/wiki/Docs/howto/mysql_partition) : 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 
StartDBSyncers=4

  - 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 ?

Thanks,

Nicolas

------------------------------------------------------------------------------
Pedro Roger | 19 Nov 15:43 2015
Picon

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
http://www.proger.eti.br
------------------------------------------------------------------------------
_______________________________________________
Zabbix-users mailing list
Zabbix-users <at> lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/zabbix-users
Kodai Terashima | 18 Nov 03:34 2015
Picon
Gravatar

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.
http://repo.zabbix.com/zabbix/2.4/debian/pool/main/z/zabbix/

Thanks,
Kodai

> On 2015 Nov 17, at 00:40, Florent B <florent <at> coppint.com> 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.
> http://pubads.g.doubleclick.net/gampad/clk?id=250295911&iu=/4140
> _______________________________________________
> Zabbix-users mailing list
> Zabbix-users <at> lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/zabbix-users

------------------------------------------------------------------------------
Wolfgang Schnerring | 9 Nov 17:05 2015
Picon
Gravatar

Parameters: quoting of special characters

Hi,

<https://www.zabbix.com/documentation/2.4/manual/config/items/item/key>
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,
Wolfgang

PS: For completeness, the "solr.query_count" is defined like this:
  UserParameter=solr.query_count[*],/etc/zabbix/checks/count_solr_query.sh "$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.
http://pubads.g.doubleclick.net/gampad/clk?id=250295911&iu=/4140
Nicolas C. | 4 Nov 14:43 2015
Picon

PSA : MySQL partitioning on ext4 and thin-provisioning storage

Hello,

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:

http://www.ogris.de/blkalloc/

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 :

http://i.imgur.com/i8H64Cg.png

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

Regards,

Nicolas

------------------------------------------------------------------------------
Sophie Loewenthal | 3 Nov 14:28 2015

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

Hi,

    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

zabbix-java-gateway-remoting-lib-0.0.1-001.noarch
zabbix-web-2.2.3-0.el6.noarch
zabbix-get-2.2.3-0.el6.x86_64
pyzabbix-0.6-0.noarch
zabbix-2.2.3-0.el6.x86_64
zabbix-server-2.2.3-0.el6.x86_64
zabbix-web-mysql-2.2.3-0.el6.noarch
zabbix-java-gateway-2.2.3-0.el6.x86_64
zabbix-sender-2.2.3-0.el6.x86_64
zabbix-server-mysql-2.2.3-0.el6.x86_64
zabbix-agent-2.2.3-0.el6.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,
Sophie


------------------------------------------------------------------------------
_______________________________________________
Zabbix-users mailing list
Zabbix-users <at> lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/zabbix-users
Tom Smith | 30 Oct 21:49 2015
Picon

monitor windows event

Hello:

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> lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/zabbix-users
Arash Shams | 25 Oct 13:09 2015
Picon
Gravatar

define userparameter and got ZBX_NOTSUPPORTED

Hello
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 8.8.8.8 && 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 172.20.4.43 -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> lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/zabbix-users

Gmane