Raphael Rabelo de Oliveira | 9 Oct 03:05 2014
Picon

Re: Auto-Register by DNS name

Hi!

My servers has the same hostname than dns name.
I solved this using a script that change the 'interface' table, to set useip to '0' and get the name of host in table 'hosts'.

Here I set the column 'useip' to 0, this make zabbix use 'DNS' name of host to monitor, the except is because the server didn't the same hostname:

UPDATE interface i,hosts h
SET    i.useip = '0'
WHERE  i.hostid = h.hostid
       AND i.ip <> '127.0.0.1'
       AND i.dns IS NOT NULL
       AND h.name NOT LIKE 'ftp-server%'

And here, I get the 'name' of the host in 'hosts' tables and set in 'dns' column in 'interface' table:
-----------------------------------------------
UPDATE interface i,hosts h 
SET    i.dns = h.name 
WHERE  i.hostid = h.hostid 
       AND i.dns <> h.name
       AND i.ip <> '127.0.0.1'
       AND h.name NOT LIKE 'ftp-server%'


So, to view the result I used this:

SELECT h.hostid,i.useip,i.ip,h.name,h.host,i.dns
FROM hosts AS h
INNER JOIN interface AS i 
ON (h.hostid = i.hostid);

This work for me, I'm studing how to do this automatically when host is add.

Thanks for the help guys!! =D


2014-10-06 9:35 GMT-03:00 Jonathan Bayer <linuxgurugamer <at> gmail.com>:
Well, if you use the dns name instead of the ip address, and if the TTL on the DNS entries is short enough, wouldn't that take care of it for you?


JBB


On 10/6/2014 7:29 AM, Raphael Rabelo de Oliveira wrote:
Hello!

I have a zabbix server with a lot of servers monitoring and using active-check to auto-registration.

My problem is that auto-registration is using a IP address to connect with servers, but sometimes my servers changes the IP address and the monitoring was broken.

All of my server has a fixed DNS name, and them don't change, so there's someway to make zabbix include the servers using DNS in auto-registration by default ?

Thanks!

Raphael R.

-- 
Raphael R.


------------------------------------------------------------------------------ Slashdot TV. Videos for Nerds. Stuff that Matters. http://pubads.g.doubleclick.net/gampad/clk?id=160591471&iu=/4140/ostg.clktrk

_______________________________________________ Zabbix-users mailing list Zabbix-users <at> lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/zabbix-users




--
Raphael Rabelo de Oliveira
Red Hat Certified Enginner - RHCE
Cel: 11 96105-8257

------------------------------------------------------------------------------
Meet PCI DSS 3.0 Compliance Requirements with EventLog Analyzer
Achieve PCI DSS 3.0 Compliant Status with Out-of-the-box PCI DSS Reports
Are you Audit-Ready for PCI DSS 3.0 Compliance? Download White paper
Comply to PCI DSS 3.0 Requirement 10 and 11.5 with EventLog Analyzer
http://pubads.g.doubleclick.net/gampad/clk?id=154622311&iu=/4140/ostg.clktrk
_______________________________________________
Zabbix-users mailing list
Zabbix-users <at> lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/zabbix-users
Simon Vargas | 17 Sep 11:53 2014
Picon

Random outages on Zabbix graphs


Hello
 
I have some long term issue on 1 of my zabbix server that there are interruptions in the graphs.
 
http://i60.tinypic.com/35ixjev.jpg
 
It's related to the Zabbix server because the graphs get interrupted at the same time eg.:
server1s cpu usage, ups1 load, ping to server2. This is a small network with not too many events however the
Zabbix server itself runs in vmware.
 
What I did was to move it's mysql database to another machine, the issue still exist, randomly there are
outages in the graphs, so it's not because the database would be overloaded.
 
How should I proceed to debug this what causing the issue?
 
Zabbix is running with default configuration, no tunings are made in the configs.
 
Thanks

------------------------------------------------------------------------------
Want excitement?
Manually upgrade your production database.
When you want reliability, choose Perforce
Perforce version control. Predictably reliable.
http://pubads.g.doubleclick.net/gampad/clk?id=157508191&iu=/4140/ostg.clktrk
_______________________________________________
Zabbix-users mailing list
Zabbix-users <at> lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/zabbix-users
Joseph V J | 9 Sep 08:09 2014
Picon

Disable Initial Status Alert

Hi,

I've configured Zabbix(2.2.3) server with Debian GNU/Linux 7 in AWS and 'Auto Registration' is configured with it. So when new machine is added to the zabbix server to get it monitored, Zabbix server at once sends Alerts with 'OK' status with the checks associated with the new instance. Is it possible to disable this initial Triggers, as more than 1 instance will be added up to get monitored and numerous mails will be received at once with 'OK' status.

~Thanks
Joe
------------------------------------------------------------------------------
Want excitement?
Manually upgrade your production database.
When you want reliability, choose Perforce.
Perforce version control. Predictably reliable.
http://pubads.g.doubleclick.net/gampad/clk?id=157508191&iu=/4140/ostg.clktrk
_______________________________________________
Zabbix-users mailing list
Zabbix-users <at> lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/zabbix-users
Fiedler Roman | 3 Sep 11:53 2014
Picon

Zabbix server crash due to lib-curl NULL-pointer dereference in http poller

Hello List,

Just FYI:

Old libcurl3-gnutls before "V7.37.0 - May 21 2014" (e.g. Ubuntu Trusty
pool/main/c/curl/libcurl3-gnutls_7.35.0-1ubuntu2_i386.deb) is prone to
NULL-deref, taking the whole zabbix_server process down when doing
web-scenario tests on an Apache 2.4 server with SSL, wildcard-certificate,
intermediate-chain and SNI.

Workaround: disable SSL tests on newer servers while not fixed.

See also [1]

Roman

[1] https://bugs.launchpad.net/ubuntu/+bug/1304004
Attachment (smime.p7s): application/pkcs7-signature, 8 KiB
------------------------------------------------------------------------------
Slashdot TV.  
Video for Nerds.  Stuff that matters.
http://tv.slashdot.org/
_______________________________________________
Zabbix-users mailing list
Zabbix-users <at> lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/zabbix-users
Olivier Morel | 26 Aug 12:34 2014
Picon

lost configuration after restart server

hy
i can create a host,triger or graph or anything else, everything doing fine.
when i restart the server with zabbix i dont know why, i lost everything what i've added and i've nothing in the log ?

before to restart when i watch in mysql i can see my host or anything else.

do i need to remove or add a params to tell to zabbix to keep my configuration  ?


------------------------------------------------------------------------------
Slashdot TV.  
Video for Nerds.  Stuff that matters.
http://tv.slashdot.org/
_______________________________________________
Zabbix-users mailing list
Zabbix-users <at> lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/zabbix-users
Elliot Finley | 6 Aug 01:02 2014
Picon

Items not populating from Item Prototype based on external check LLD rule

  5269:20140801:161033.196 Starting Zabbix Server. Zabbix 2.2.4 (revision 46772).
  5269:20140801:161033.197 ****** Enabled features ******
  5269:20140801:161033.197 SNMP monitoring:           YES
  5269:20140801:161033.197 IPMI monitoring:           YES
  5269:20140801:161033.197 WEB monitoring:            YES
  5269:20140801:161033.197 VMware monitoring:         YES
  5269:20140801:161033.197 Jabber notifications:      YES
  5269:20140801:161033.197 Ez Texting notifications:  YES
  5269:20140801:161033.197 ODBC:                      YES
  5269:20140801:161033.197 SSH2 support:              YES
  5269:20140801:161033.197 IPv6 support:              YES
  5269:20140801:161033.197 ******************************
  5269:20140801:161033.197 using configuration file: /etc/zabbix/zabbix_server.conf
  5269:20140801:161033.659 current database version (mandatory/optional): 02020000/02020001
  5269:20140801:161033.659 required mandatory version: 02020000


[root <at> zabbix-server zabbix]# mysql -u zabbix_user
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 1272
Server version: 10.0.11-MariaDB MariaDB Server

Copyright (c) 2000, 2014, Oracle, SkySQL Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [(none)]> \s
--------------
mysql  Ver 15.1 Distrib 10.0.11-MariaDB, for Linux (x86_64) using readline 5.1

Connection id:          1272
Current database:
Current user:           zabbix_user <at> localhost
SSL:                    Not in use
Current pager:          stdout
Using outfile:          ''
Using delimiter:        ;
Server:                 MariaDB
Server version:         10.0.11-MariaDB MariaDB Server
Protocol version:       10
Connection:             Localhost via UNIX socket
Server characterset:    latin1
Db     characterset:    latin1
Client characterset:    utf8
Conn.  characterset:    utf8
UNIX socket:            /var/lib/mysql/mysql.sock
Uptime:                 80 days 23 hours 58 min 11 sec

Threads: 1  Questions: 5186  Slow queries: 0  Opens: 109  Flush tables: 1  Open tables: 117  Queries per second avg: 0.000
--------------

MariaDB [(none)]>



[root <at> zabbix-server zabbix]# uname -a
Linux zabbix-server.xxxxxxxx.com 2.6.32-431.17.1.el6.x86_64 #1 SMP Wed May 7 23:32:49 UTC 2014 x86_64 x86_64 x86_64 GNU/Linux

The Discovery Rule looks like this:

Name: Interfaces
Type: External check
Key: ifDiscover.rb[{$SNMP_COMMUNITY},{HOST.CONN}]

The ifDiscover.rb script looks like this:

#!/usr/bin/ruby
require 'rubygems'
require 'snmp'

File.open("/usr/lib/zabbix/externalscripts/ifDiscover.log", mode="a") do |f| f.puts ARGV end

unless ARGV.length == 2
  $stderr.puts "ex: #{$PROGRAM_NAME} <community> <ipaddress>"
  exit
end

community = ARGV[0]
ip = ARGV[1]

puts "{"
puts %("data":[)


ifTable_columns = ["ifIndex", "ifDescr", "ifAlias"]
SNMP::Manager.open(:Host => ip, :Community => community) do |manager|
  manager.walk(ifTable_columns) do |row|
    if row[2].value.is_a?(String)
      ifAlias = row[2].value.gsub('"','')
    else
      ifAlias = ''
    end
    puts %({ "{#SNMPINDEX}":"#{row[0].value}", "{#IFDESCR}":"#{row[1].value}", "{#IFALIAS}":"#{ifAlias}" },)
  end
end

puts "]"
puts "}"

It generates output that looks like this:

{
"data":[
{ "{#SNMPINDEX}":"1", "{#IFDESCR}":"GigabitEthernet1/1", "{#IFALIAS}":"26135AccessData VRF->Base" },
{ "{#SNMPINDEX}":"2", "{#IFDESCR}":"GigabitEthernet1/2", "{#IFALIAS}":"26135AccessData Base->VRF" },
{ "{#SNMPINDEX}":"3", "{#IFDESCR}":"GigabitEthernet1/3", "{#IFALIAS}":"12255/42190 - Standard Plumbing VRF->Base" },
{ "{#SNMPINDEX}":"4", "{#IFDESCR}":"GigabitEthernet1/4", "{#IFALIAS}":"12255/42190 - Standard Plumbing Base->VRF" },
{ "{#SNMPINDEX}":"5", "{#IFDESCR}":"GigabitEthernet1/5", "{#IFALIAS}":"30242LarkinMort VRF->Base" },
{ "{#SNMPINDEX}":"6", "{#IFDESCR}":"GigabitEthernet1/6", "{#IFALIAS}":"30242LarkinMort Base->VRF" },
{ "{#SNMPINDEX}":"7", "{#IFDESCR}":"GigabitEthernet1/7", "{#IFALIAS}":"53085 - Ingram Medical VRF->Base" },
{ "{#SNMPINDEX}":"8", "{#IFDESCR}":"GigabitEthernet1/8", "{#IFALIAS}":"53085 - Ingram Medical Base->VRF" },
{ "{#SNMPINDEX}":"9", "{#IFDESCR}":"GigabitEthernet1/9", "{#IFALIAS}":"53085 - Ingram Medical Pharmacies VRF->Base" },
{ "{#SNMPINDEX}":"10", "{#IFDESCR}":"GigabitEthernet1/10", "{#IFALIAS}":"53085 - Ingram Medical Pharmacies Base->VRF" },
]
}

My Item Prototype(s) look like this:

Name: Incoming traffic on $1:$2
Type: SNMPv2 agent
Key: ifInOctets[{#IFDESCR},{#IFALIAS}]
SNMP OID: IF-MIB::ifHCInOctets.{#SNMPINDEX}
SNMP community: {$SNMP_COMMUNITY}
Port: <left blank>
Type of information: Numeric (unsigned)
Data type: Decimal
Units: bps
Use customer multiplier: <checked> 8
Store value: Delta (speed per second)
Enabled: <checked>

But the Items never populate.  I've had this exact same LLD rule/script/item-prototype running on FreeBSD 9.x/zabbix 2.2.2/Postgres 9.x and it runs just fine.  In fact, this was mostly just copy-n-pasted from that setup.

I've verified that the external script is in fact getting ran with the correct parameters.

Can anyone see any problem with this configuration?  This is driving me NUTS!

Any help would be appreciated.

Thanks in advance,
Elliot

------------------------------------------------------------------------------
Infragistics Professional
Build stunning WinForms apps today!
Reboot your WinForms applications with our WinForms controls. 
Build a bridge from your legacy apps to the future.
http://pubads.g.doubleclick.net/gampad/clk?id=153845071&iu=/4140/ostg.clktrk
_______________________________________________
Zabbix-users mailing list
Zabbix-users <at> lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/zabbix-users
G9 - Nuno Pereira | 5 Aug 14:46 2014
Picon

Acknowledge of triggers with dependencies

Hello,

 

My zabbix is at version 2.0.12.

 

I have 4 triggers (name it A1, A2, B1 and B2) that depend on 2 other triggers (name it A3 and A3), in pairs: triggers A1 and A2 depend of A3, and triggers B1 and B2 depend of B3.

To note that the expression of the trigger A3 is something like

 

“expression of trigger A1” and “expression of trigger A2”

 

This means that it is in PROBLEM when both triggers A1 and A2 are in PROBLEM.

The configuration of the trigger B3 is similar to the one of A3: B3 is in PROBLEM if both triggers B1 and B2 are in PROBLEM.

 

Also it’s worth to mention that all of these triggers have associated actions that send messages every 6 hours if they’re not acknowledged.

 

 

In the weekend, all the triggers activated and I acknowledged the triggers A3 and B3, as they were the only ones visible in the dashboard.

The problem was that the other 4 triggers kept sending their messages every 6 hours, as they weren’t acknowledged, even if they depended on triggers that were acknowledged.

 

Was that supposed to happen? Is this a bug? Or have I something misconfigured?

 

Thank you,

 

Nuno Pereira

 

G9Telecom

We are a Deloitte Technology Fast 500 EMEA 2013
Tel.:  +351 707 45 00 00        Fax:  +351 707 45 00 09

Web: www.g9telecom.pt

------------------------------------------------

AVISO:

Esta mensagem (incluindo quaisquer anexos) pode conter informação confidencial para uso exclusivo do destinatário. Se não for o destinatário pretendido, não deverá usar, distribuir ou copiar este e-mail. Se recebeu esta mensagem por engano, por favor informe o emissor e elimine-a imediatamente.

Obrigado.

------------------------------------------------

 

Attachment (smime.p7s): application/pkcs7-signature, 8 KiB
------------------------------------------------------------------------------
Infragistics Professional
Build stunning WinForms apps today!
Reboot your WinForms applications with our WinForms controls. 
Build a bridge from your legacy apps to the future.
http://pubads.g.doubleclick.net/gampad/clk?id=153845071&iu=/4140/ostg.clktrk
_______________________________________________
Zabbix-users mailing list
Zabbix-users <at> lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/zabbix-users
Klemens Kittan | 5 Aug 13:52 2014
Picon

Hosts with multiple IP address

Hello,

our servers have at least two network interfaces. One for the management
and ssh and one where the services are offered. Now I would like to
monitor both interfaces, for example via ping. 

If I want to monitor both interfaces on the servers, can I create a 
template with two items icmpping[{HOST.CONN1}] and
icmpping[{HOST.CONN2}]? And how can I refer in the triggers on these
items? 

I have the same problem when I monitor our Web server with
net.tcp.service[http, 80]. On the web server, we have multiple IP-based
virtual host configured. I would like to monitor all network interfaces,
whether the port is in mode listen.

Is there a solution?

Gruß,
Klemens

------------------------------------------------------------------------------
Infragistics Professional
Build stunning WinForms apps today!
Reboot your WinForms applications with our WinForms controls. 
Build a bridge from your legacy apps to the future.
http://pubads.g.doubleclick.net/gampad/clk?id=153845071&iu=/4140/ostg.clktrk
_______________________________________________
Zabbix-users mailing list
Zabbix-users <at> lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/zabbix-users
Adrian Sevcenco | 1 Aug 10:25 2014
Picon
Picon

zabbix install :: web :: configure db connection - test failed

Hi! I try to install zabbix and i followed the steps on
https://www.zabbix.org/wiki/InstallOnCentOS_RHEL

at the step 3 from the web page access i have a failed test connection:
Error connecting to database: Access denied for user
'zabbix' <at> 'localhost' (using password: YES)

even if i can do
[root <at> monitor zabbix]# mysql -u zabbix -p
mysql> \s
--------------
mysql  Ver 14.14 Distrib 5.1.73, for redhat-linux-gnu (x86_64) using
readline 5.1

Connection id:          2060
Current database:
Current user:           zabbix <at> localhost
SSL:                    Not in use
Current pager:          stdout
Using outfile:          ''
Using delimiter:        ;
Server version:         5.1.73 Source distribution
Protocol version:       10
Connection:             Localhost via UNIX socket
Server characterset:    utf8
Db     characterset:    utf8
Client characterset:    latin1
Conn.  characterset:    latin1
UNIX socket:            /var/lib/mysql/mysql.sock
Uptime:                 145 days 23 hours 19 sec

Threads: 1  Questions: 36995  Slow queries: 0  Opens: 3480  Flush
tables: 1  Open tables: 64  Queries per second avg: 0.2

the password (DBPassword) was set up in zabbix_server.conf in quotes ''
SELinux is disabled

Any idea why i cannot connect to the database from the web page?
Thanks!
Adrian

Attachment (smime.p7s): application/pkcs7-signature, 3074 bytes
------------------------------------------------------------------------------
Want fast and easy access to all the code in your enterprise? Index and
search up to 200,000 lines of code with a free copy of Black Duck
Code Sight - the same software that powers the world's largest code
search on Ohloh, the Black Duck Open Hub! Try it now.
http://p.sf.net/sfu/bds
_______________________________________________
Zabbix-users mailing list
Zabbix-users <at> lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/zabbix-users
Adam Carrgilson (NBI | 30 Jul 12:02 2014
Picon

Zabbix Hostname Macro in SNMP OID

Hi all,

I'm running Zabbix 2.2.5 and I'm trying to create a template with a couple of SNMP items.

I want to setup my template such that it uses the hostname macro within the SNMP OID, however no matter which macro I try and use I can't seem to get Zabbix to correctly resolve it.

An example of the SNMP OID I'm trying to query is: NET-SNMP-EXTEND-MIB::nsExtendOutputFull.\"racka1-exhaust_temperature\"

Where the parent host of the item has the hostname: racka1

Where I manually specify the OID already including the hostname as above to test, I successfully return a value.

When I set the OID as follows, I get problems: NET-SNMP-EXTEND-MIB::nsExtendOutputFull.\"{HOST.NAME1}-exhaust_temperature\"

 

I've checked through the list of macro's and their usage locations but I can't judge which might cover SNMP OIDs, without looking through the source code.

I've got logging turned up to 4 in an effort to try and understand what is going on however I'm compounded in my testing by Zabbix setting the item to Not Supported and even though this check is set to run every 60 seconds, once I change the OID, I can't get Zabbix to quickly requeue the changed items.

Is it even possible to use a macro in a SNMP OID? If so which should I be using to mirror the hostname?

Many Thanks,
Adam.

 

---

Adam Carrgilson

Linux Support & Development

E Adam.Carrgilson <at> nbi.ac.uk

T +44 1603 450161

W jic.ac.uk ifr.ac.uk tgac.ac.uk tsl.ac.uk

 

Computing and Information Services Dept

NBI Partnership Ltd

Norwich Research Park

Norwich NR4 7UH

 

The NBI Partnership Ltd provides non-scientific services to the Institute of Food Research, the John Innes Centre, The Genome Analysis Centre and The Sainsbury Laboratory

------------------------------------------------------------------------------
Infragistics Professional
Build stunning WinForms apps today!
Reboot your WinForms applications with our WinForms controls. 
Build a bridge from your legacy apps to the future.
http://pubads.g.doubleclick.net/gampad/clk?id=153845071&iu=/4140/ostg.clktrk
_______________________________________________
Zabbix-users mailing list
Zabbix-users <at> lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/zabbix-users
ajh4711 | 29 Jul 15:36 2014
Picon

More than 100 rows in planetext

Hi,

I have a table configured there is showing a logfile with the planetext 100 rows of the logfile.
Now I like to show more rows.

is this possible?
The configurator tells me, that just 100 rows are possible.
But in the case of a logfile this don’t make sense.

thanks a lot for ideas :-)

cheers ajh

------------------------------------------------------------------------------
Infragistics Professional
Build stunning WinForms apps today!
Reboot your WinForms applications with our WinForms controls. 
Build a bridge from your legacy apps to the future.
http://pubads.g.doubleclick.net/gampad/clk?id=153845071&iu=/4140/ostg.clktrk

Gmane