-- C A U T I O N -- -- This is experimental "patch" for upgrading Zabbix database -- from 1.6 to 1.6.1. It applies cleanly on a fresh 1.6 database, -- so if you've changed some entries after installing 1.6, this -- patch might fail. Always do backups. You've been warned. -- -- changes in /branches/1.6/create/data/data.sql in SVN r6084 -- -- [change useipmi to 0 for some templates] UPDATE hosts SET useipmi=0 WHERE hostid > 10024 AND hostid < 10047; -- [modify some IPMI-related items for Template_IPMI_Sun_Fire_X4100_M2] UPDATE items SET type=12, snmp_community='', snmp_oid='', snmp_port=161, hostid=10042, description='Drive backplane temperature', key_='drive_backplane.temperature', delay=30, history=7, trends=365, nextcheck=0, lastvalue=NULL, lastclock=NULL, prevvalue=NULL, status=0, value_type=0, trapper_hosts='', units='°C', multiplier=0, delta=0, prevorgvalue=NULL, snmpv3_securityname='', snmpv3_securitylevel=0, snmpv3_authpassphrase='', snmpv3_privpassphrase='', formula='1', error='', lastlogsize=0, logtimefmt='', templateid=0, valuemapid=0, delay_flex='', params='', ipmi_sensor='io.t_amb' WHERE itemid=21811; UPDATE items SET type=12, snmp_community='', snmp_oid='', snmp_port=161, hostid=10042, description='Fan speed $1', key_='fan_cooling[ft0.fm0.f0]', delay=30, history=7, trends=365, nextcheck=0, lastvalue=NULL, lastclock=NULL, prevvalue=NULL, status=0, value_type=0, trapper_hosts='', units='RPM', multiplier=0, delta=0, prevorgvalue=NULL, snmpv3_securityname='', snmpv3_securitylevel=0, snmpv3_authpassphrase='', snmpv3_privpassphrase='', formula='1', error='', lastlogsize=0, logtimefmt='', templateid=0, valuemapid=0, delay_flex='', params='', ipmi_sensor='ft0.fm0.f0.speed' WHERE itemid=21812; UPDATE items SET type=12, snmp_community='', snmp_oid='', snmp_port=161, hostid=10042, description='Fan speed $1', key_='fan_cooling[ft0.fm0.f1]', delay=30, history=7, trends=365, nextcheck=0, lastvalue=NULL, lastclock=NULL, prevvalue=NULL, status=0, value_type=0, trapper_hosts='', units='RPM', multiplier=0, delta=0, prevorgvalue=NULL, snmpv3_securityname='', snmpv3_securitylevel=0, snmpv3_authpassphrase='', snmpv3_privpassphrase='', formula='1', error='', lastlogsize=0, logtimefmt='', templateid=0, valuemapid=0, delay_flex='', params='', ipmi_sensor='ft0.fm0.f1.speed' WHERE itemid=21813; UPDATE items SET type=12, snmp_community='', snmp_oid='', snmp_port=161, hostid=10042, description='Fan speed $1', key_='fan_cooling[ft0.fm1.f0]', delay=30, history=7, trends=365, nextcheck=0, lastvalue=NULL, lastclock=NULL, prevvalue=NULL, status=0, value_type=0, trapper_hosts='', units='RPM', multiplier=0, delta=0, prevorgvalue=NULL, snmpv3_securityname='', snmpv3_securitylevel=0, snmpv3_authpassphrase='', snmpv3_privpassphrase='', formula='1', error='', lastlogsize=0, logtimefmt='', templateid=0, valuemapid=0, delay_flex='', params='', ipmi_sensor='ft0.fm1.f0.speed' WHERE itemid=21814; UPDATE items SET type=12, snmp_community='', snmp_oid='', snmp_port=161, hostid=10042, description='Fan speed $1', key_='fan_cooling[ft0.fm1.f1]', delay=30, history=7, trends=365, nextcheck=0, lastvalue=NULL, lastclock=NULL, prevvalue=NULL, status=0, value_type=0, trapper_hosts='', units='RPM', multiplier=0, delta=0, prevorgvalue=NULL, snmpv3_securityname='', snmpv3_securitylevel=0, snmpv3_authpassphrase='', snmpv3_privpassphrase='', formula='1', error='', lastlogsize=0, logtimefmt='', templateid=0, valuemapid=0, delay_flex='', params='', ipmi_sensor='ft0.fm1.f1.speed' WHERE itemid=21815; UPDATE items SET type=12, snmp_community='', snmp_oid='', snmp_port=161, hostid=10042, description='Fan speed $1', key_='fan_cooling[ft0.fm2.f0]', delay=30, history=7, trends=365, nextcheck=0, lastvalue=NULL, lastclock=NULL, prevvalue=NULL, status=0, value_type=0, trapper_hosts='', units='RPM', multiplier=0, delta=0, prevorgvalue=NULL, snmpv3_securityname='', snmpv3_securitylevel=0, snmpv3_authpassphrase='', snmpv3_privpassphrase='', formula='1', error='', lastlogsize=0, logtimefmt='', templateid=0, valuemapid=0, delay_flex='', params='', ipmi_sensor='ft0.fm2.f0.speed' WHERE itemid=21816; UPDATE items SET type=12, snmp_community='', snmp_oid='', snmp_port=161, hostid=10042, description='Fan speed $1', key_='fan_cooling[ft0.fm2.f1]', delay=30, history=7, trends=365, nextcheck=0, lastvalue=NULL, lastclock=NULL, prevvalue=NULL, status=0, value_type=0, trapper_hosts='', units='RPM', multiplier=0, delta=0, prevorgvalue=NULL, snmpv3_securityname='', snmpv3_securitylevel=0, snmpv3_authpassphrase='', snmpv3_privpassphrase='', formula='1', error='', lastlogsize=0, logtimefmt='', templateid=0, valuemapid=0, delay_flex='', params='', ipmi_sensor='ft0.fm2.f1.speed' WHERE itemid=21817; UPDATE items SET type=12, snmp_community='', snmp_oid='', snmp_port=161, hostid=10042, description='Fan speed $1', key_='fan_cooling[ft1.fm0.f0]', delay=30, history=7, trends=365, nextcheck=0, lastvalue=NULL, lastclock=NULL, prevvalue=NULL, status=0, value_type=0, trapper_hosts='', units='RPM', multiplier=0, delta=0, prevorgvalue=NULL, snmpv3_securityname='', snmpv3_securitylevel=0, snmpv3_authpassphrase='', snmpv3_privpassphrase='', formula='1', error='', lastlogsize=0, logtimefmt='', templateid=0, valuemapid=0, delay_flex='', params='', ipmi_sensor='ft1.fm0.f0.speed' WHERE itemid=21818; UPDATE items SET type=12, snmp_community='', snmp_oid='', snmp_port=161, hostid=10042, description='Fan speed $1', key_='fan_cooling[ft1.fm0.f1]', delay=30, history=7, trends=365, nextcheck=0, lastvalue=NULL, lastclock=NULL, prevvalue=NULL, status=0, value_type=0, trapper_hosts='', units='RPM', multiplier=0, delta=0, prevorgvalue=NULL, snmpv3_securityname='', snmpv3_securitylevel=0, snmpv3_authpassphrase='', snmpv3_privpassphrase='', formula='1', error='', lastlogsize=0, logtimefmt='', templateid=0, valuemapid=0, delay_flex='', params='', ipmi_sensor='ft1.fm0.f1.speed' WHERE itemid=21819; UPDATE items SET type=12, snmp_community='', snmp_oid='', snmp_port=161, hostid=10042, description='Fan speed $1', key_='fan_cooling[ft1.fm1.f0]', delay=30, history=7, trends=365, nextcheck=0, lastvalue=NULL, lastclock=NULL, prevvalue=NULL, status=0, value_type=0, trapper_hosts='', units='RPM', multiplier=0, delta=0, prevorgvalue=NULL, snmpv3_securityname='', snmpv3_securitylevel=0, snmpv3_authpassphrase='', snmpv3_privpassphrase='', formula='1', error='', lastlogsize=0, logtimefmt='', templateid=0, valuemapid=0, delay_flex='', params='', ipmi_sensor='ft1.fm1.f0.speed' WHERE itemid=21820; UPDATE items SET type=12, snmp_community='', snmp_oid='', snmp_port=161, hostid=10042, description='Fan speed $1', key_='fan_cooling[ft1.fm1.f1]', delay=30, history=7, trends=365, nextcheck=0, lastvalue=NULL, lastclock=NULL, prevvalue=NULL, status=0, value_type=0, trapper_hosts='', units='RPM', multiplier=0, delta=0, prevorgvalue=NULL, snmpv3_securityname='', snmpv3_securitylevel=0, snmpv3_authpassphrase='', snmpv3_privpassphrase='', formula='1', error='', lastlogsize=0, logtimefmt='', templateid=0, valuemapid=0, delay_flex='', params='', ipmi_sensor='ft1.fm1.f1.speed' WHERE itemid=21821; UPDATE items SET type=12, snmp_community='', snmp_oid='', snmp_port=161, hostid=10042, description='Fan speed $1', key_='fan_cooling[ft1.fm2.f0]', delay=30, history=7, trends=365, nextcheck=0, lastvalue=NULL, lastclock=NULL, prevvalue=NULL, status=0, value_type=0, trapper_hosts='', units='RPM', multiplier=0, delta=0, prevorgvalue=NULL, snmpv3_securityname='', snmpv3_securitylevel=0, snmpv3_authpassphrase='', snmpv3_privpassphrase='', formula='1', error='', lastlogsize=0, logtimefmt='', templateid=0, valuemapid=0, delay_flex='', params='', ipmi_sensor='ft1.fm2.f0.speed' WHERE itemid=21822; UPDATE items SET type=12, snmp_community='', snmp_oid='', snmp_port=161, hostid=10042, description='Fan speed $1', key_='fan_cooling[ft1.fm2.f1]', delay=30, history=7, trends=365, nextcheck=0, lastvalue=NULL, lastclock=NULL, prevvalue=NULL, status=0, value_type=0, trapper_hosts='', units='RPM', multiplier=0, delta=0, prevorgvalue=NULL, snmpv3_securityname='', snmpv3_securitylevel=0, snmpv3_authpassphrase='', snmpv3_privpassphrase='', formula='1', error='', lastlogsize=0, logtimefmt='', templateid=0, valuemapid=0, delay_flex='', params='', ipmi_sensor='ft1.fm2.f1.speed' WHERE itemid=21823; UPDATE items SET type=12, snmp_community='', snmp_oid='', snmp_port=161, hostid=10042, description='Front panel board temperature', key_='front_panel_board.temperature', delay=30, history=7, trends=365, nextcheck=0, lastvalue=NULL, lastclock=NULL, prevvalue=NULL, status=0, value_type=0, trapper_hosts='', units='°C', multiplier=0, delta=0, prevorgvalue=NULL, snmpv3_securityname='', snmpv3_securitylevel=0, snmpv3_authpassphrase='', snmpv3_privpassphrase='', formula='1', error='', lastlogsize=0, logtimefmt='', templateid=0, valuemapid=0, delay_flex='', params='', ipmi_sensor='fp.t_amb' WHERE itemid=21824; UPDATE items SET type=12, snmp_community='', snmp_oid='', snmp_port=161, hostid=10042, description='Power', key_='power', delay=30, history=7, trends=365, nextcheck=0, lastvalue=NULL, lastclock=NULL, prevvalue=NULL, status=0, value_type=0, trapper_hosts='', units='', multiplier=0, delta=0, prevorgvalue=NULL, snmpv3_securityname='', snmpv3_securitylevel=0, snmpv3_authpassphrase='', snmpv3_privpassphrase='', formula='1', error='', lastlogsize=0, logtimefmt='', templateid=0, valuemapid=0, delay_flex='', params='', ipmi_sensor='power' WHERE itemid=21825; UPDATE items SET type=12, snmp_community='', snmp_oid='', snmp_port=161, hostid=10042, description='Power unit temperature', key_='power_unit.temperature', delay=30, history=7, trends=365, nextcheck=0, lastvalue=NULL, lastclock=NULL, prevvalue=NULL, status=0, value_type=0, trapper_hosts='', units='°C', multiplier=0, delta=0, prevorgvalue=NULL, snmpv3_securityname='', snmpv3_securitylevel=0, snmpv3_authpassphrase='', snmpv3_privpassphrase='', formula='1', error='', lastlogsize=0, logtimefmt='', templateid=0, valuemapid=0, delay_flex='', params='', ipmi_sensor='pdb.t_amb' WHERE itemid=21826; UPDATE items SET type=12, snmp_community='', snmp_oid='', snmp_port=161, hostid=10042, description='Processor$1 $2', key_='processor[0, delay=t_core]', history=30, trends=7, nextcheck=365, lastvalue=0, lastclock=NULL, prevvalue=NULL, status=NULL, value_type=0, trapper_hosts=0, units='', multiplier='°C', delta=0, prevorgvalue=0, snmpv3_securityname=NULL, snmpv3_securitylevel='', snmpv3_authpassphrase=0, snmpv3_privpassphrase='', formula='', error='1', lastlogsize='', logtimefmt=0, templateid='', valuemapid=0, delay_flex=0, params='', ipmi_sensor='' WHERE itemid=21827; UPDATE items SET type=12, snmp_community='', snmp_oid='', snmp_port=161, hostid=10042, description='Processor$1 $2', key_='processor[0, delay=v_vddio]', history=30, trends=7, nextcheck=365, lastvalue=0, lastclock=NULL, prevvalue=NULL, status=NULL, value_type=0, trapper_hosts=0, units='', multiplier='v', delta=0, prevorgvalue=0, snmpv3_securityname=NULL, snmpv3_securitylevel='', snmpv3_authpassphrase=0, snmpv3_privpassphrase='', formula='', error='1', lastlogsize='', logtimefmt=0, templateid='', valuemapid=0, delay_flex=0, params='', ipmi_sensor='' WHERE itemid=21828; UPDATE items SET type=12, snmp_community='', snmp_oid='', snmp_port=161, hostid=10042, description='Processor$1 $2', key_='processor[0, delay=v_vdd]', history=30, trends=7, nextcheck=365, lastvalue=0, lastclock=NULL, prevvalue=NULL, status=NULL, value_type=0, trapper_hosts=0, units='', multiplier='v', delta=0, prevorgvalue=0, snmpv3_securityname=NULL, snmpv3_securitylevel='', snmpv3_authpassphrase=0, snmpv3_privpassphrase='', formula='', error='1', lastlogsize='', logtimefmt=0, templateid='', valuemapid=0, delay_flex=0, params='', ipmi_sensor='' WHERE itemid=21829; UPDATE items SET type=12, snmp_community='', snmp_oid='', snmp_port=161, hostid=10042, description='Processor$1 $2', key_='processor[0, delay=v_vtt]', history=30, trends=7, nextcheck=365, lastvalue=0, lastclock=NULL, prevvalue=NULL, status=NULL, value_type=0, trapper_hosts=0, units='', multiplier='v', delta=0, prevorgvalue=0, snmpv3_securityname=NULL, snmpv3_securitylevel='', snmpv3_authpassphrase=0, snmpv3_privpassphrase='', formula='', error='1', lastlogsize='', logtimefmt=0, templateid='', valuemapid=0, delay_flex=0, params='', ipmi_sensor='' WHERE itemid=21830; UPDATE items SET type=12, snmp_community='', snmp_oid='', snmp_port=161, hostid=10042, description='Processor$1 $2', key_='processor[1, delay=t_core]', history=30, trends=7, nextcheck=365, lastvalue=0, lastclock=NULL, prevvalue=NULL, status=NULL, value_type=0, trapper_hosts=0, units='', multiplier='°C', delta=0, prevorgvalue=0, snmpv3_securityname=NULL, snmpv3_securitylevel='', snmpv3_authpassphrase=0, snmpv3_privpassphrase='', formula='', error='1', lastlogsize='', logtimefmt=0, templateid='', valuemapid=0, delay_flex=0, params='', ipmi_sensor='' WHERE itemid=21831; UPDATE items SET type=12, snmp_community='', snmp_oid='', snmp_port=161, hostid=10042, description='Processor$1 $2', key_='processor[1, delay=v_vddio]', history=30, trends=7, nextcheck=365, lastvalue=0, lastclock=NULL, prevvalue=NULL, status=NULL, value_type=0, trapper_hosts=0, units='', multiplier='v', delta=0, prevorgvalue=0, snmpv3_securityname=NULL, snmpv3_securitylevel='', snmpv3_authpassphrase=0, snmpv3_privpassphrase='', formula='', error='1', lastlogsize='', logtimefmt=0, templateid='', valuemapid=0, delay_flex=0, params='', ipmi_sensor='' WHERE itemid=21832; UPDATE items SET type=12, snmp_community='', snmp_oid='', snmp_port=161, hostid=10042, description='Processor$1 $2', key_='processor[1, delay=v_vdd]', history=30, trends=7, nextcheck=365, lastvalue=0, lastclock=NULL, prevvalue=NULL, status=NULL, value_type=0, trapper_hosts=0, units='', multiplier='v', delta=0, prevorgvalue=0, snmpv3_securityname=NULL, snmpv3_securitylevel='', snmpv3_authpassphrase=0, snmpv3_privpassphrase='', formula='', error='1', lastlogsize='', logtimefmt=0, templateid='', valuemapid=0, delay_flex=0, params='', ipmi_sensor='' WHERE itemid=21833; UPDATE items SET type=12, snmp_community='', snmp_oid='', snmp_port=161, hostid=10042, description='Processor$1 $2', key_='processor[1, delay=v_vtt]', history=30, trends=7, nextcheck=365, lastvalue=0, lastclock=NULL, prevvalue=NULL, status=NULL, value_type=0, trapper_hosts=0, units='', multiplier='v', delta=0, prevorgvalue=0, snmpv3_securityname=NULL, snmpv3_securitylevel='', snmpv3_authpassphrase=0, snmpv3_privpassphrase='', formula='', error='1', lastlogsize='', logtimefmt=0, templateid='', valuemapid=0, delay_flex=0, params='', ipmi_sensor='' WHERE itemid=21834; UPDATE items SET type=12, snmp_community='', snmp_oid='', snmp_port=161, hostid=10042, description='System board -12v', key_='system_board.-12v', delay=30, history=7, trends=365, nextcheck=0, lastvalue=NULL, lastclock=NULL, prevvalue=NULL, status=0, value_type=0, trapper_hosts='', units='v', multiplier=0, delta=0, prevorgvalue=NULL, snmpv3_securityname='', snmpv3_securitylevel=0, snmpv3_authpassphrase='', snmpv3_privpassphrase='', formula='1', error='', lastlogsize=0, logtimefmt='', templateid=0, valuemapid=0, delay_flex='', params='', ipmi_sensor='mb.v_-12v' WHERE itemid=21835; UPDATE items SET type=12, snmp_community='', snmp_oid='', snmp_port=161, hostid=10042, description='System board +1.2v core', key_='system_board.1.2v_core', delay=30, history=7, trends=365, nextcheck=0, lastvalue=NULL, lastclock=NULL, prevvalue=NULL, status=0, value_type=0, trapper_hosts='', units='v', multiplier=0, delta=0, prevorgvalue=NULL, snmpv3_securityname='', snmpv3_securitylevel=0, snmpv3_authpassphrase='', snmpv3_privpassphrase='', formula='1', error='', lastlogsize=0, logtimefmt='', templateid=0, valuemapid=0, delay_flex='', params='', ipmi_sensor='mb.v_+1v2core' WHERE itemid=21836; UPDATE items SET type=12, snmp_community='', snmp_oid='', snmp_port=161, hostid=10042, description='System board +1.5v core', key_='system_board.1.5v_core', delay=30, history=7, trends=365, nextcheck=0, lastvalue=NULL, lastclock=NULL, prevvalue=NULL, status=0, value_type=0, trapper_hosts='', units='v', multiplier=0, delta=0, prevorgvalue=NULL, snmpv3_securityname='', snmpv3_securitylevel=0, snmpv3_authpassphrase='', snmpv3_privpassphrase='', formula='1', error='', lastlogsize=0, logtimefmt='', templateid=0, valuemapid=0, delay_flex='', params='', ipmi_sensor='mb.v_+1v5core' WHERE itemid=21837; UPDATE items SET type=12, snmp_community='', snmp_oid='', snmp_port=161, hostid=10042, description='System board +12v', key_='system_board.12v', delay=30, history=7, trends=365, nextcheck=0, lastvalue=NULL, lastclock=NULL, prevvalue=NULL, status=0, value_type=0, trapper_hosts='', units='v', multiplier=0, delta=0, prevorgvalue=NULL, snmpv3_securityname='', snmpv3_securitylevel=0, snmpv3_authpassphrase='', snmpv3_privpassphrase='', formula='1', error='', lastlogsize=0, logtimefmt='', templateid=0, valuemapid=0, delay_flex='', params='', ipmi_sensor='mb.v_+12v' WHERE itemid=21838; UPDATE items SET type=12, snmp_community='', snmp_oid='', snmp_port=161, hostid=10042, description='System board +2.5v core', key_='system_board.2.5v_core', delay=30, history=7, trends=365, nextcheck=0, lastvalue=NULL, lastclock=NULL, prevvalue=NULL, status=0, value_type=0, trapper_hosts='', units='v', multiplier=0, delta=0, prevorgvalue=NULL, snmpv3_securityname='', snmpv3_securitylevel=0, snmpv3_authpassphrase='', snmpv3_privpassphrase='', formula='1', error='', lastlogsize=0, logtimefmt='', templateid=0, valuemapid=0, delay_flex='', params='', ipmi_sensor='mb.v_+2v5core' WHERE itemid=21839; UPDATE items SET type=12, snmp_community='', snmp_oid='', snmp_port=161, hostid=10042, description='System board +3.3v', key_='system_board.3.3v', delay=30, history=7, trends=365, nextcheck=0, lastvalue=NULL, lastclock=NULL, prevvalue=NULL, status=0, value_type=0, trapper_hosts='', units='v', multiplier=0, delta=0, prevorgvalue=NULL, snmpv3_securityname='', snmpv3_securitylevel=0, snmpv3_authpassphrase='', snmpv3_privpassphrase='', formula='1', error='', lastlogsize=0, logtimefmt='', templateid=0, valuemapid=0, delay_flex='', params='', ipmi_sensor='mb.v_+3v3' WHERE itemid=21840; UPDATE items SET type=12, snmp_community='', snmp_oid='', snmp_port=161, hostid=10042, description='System board +3.3v standby', key_='system_board.3.3v_stby', delay=30, history=7, trends=365, nextcheck=0, lastvalue=NULL, lastclock=NULL, prevvalue=NULL, status=0, value_type=0, trapper_hosts='', units='v', multiplier=0, delta=0, prevorgvalue=NULL, snmpv3_securityname='', snmpv3_securitylevel=0, snmpv3_authpassphrase='', snmpv3_privpassphrase='', formula='1', error='', lastlogsize=0, logtimefmt='', templateid=0, valuemapid=0, delay_flex='', params='', ipmi_sensor='mb.v_+3v3stby' WHERE itemid=21841; UPDATE items SET type=12, snmp_community='', snmp_oid='', snmp_port=161, hostid=10042, description='System board +5v', key_='system_board.5v', delay=30, history=7, trends=365, nextcheck=0, lastvalue=NULL, lastclock=NULL, prevvalue=NULL, status=0, value_type=0, trapper_hosts='', units='v', multiplier=0, delta=0, prevorgvalue=NULL, snmpv3_securityname='', snmpv3_securitylevel=0, snmpv3_authpassphrase='', snmpv3_privpassphrase='', formula='1', error='', lastlogsize=0, logtimefmt='', templateid=0, valuemapid=0, delay_flex='', params='', ipmi_sensor='mb.v_+5v' WHERE itemid=21842; UPDATE items SET type=12, snmp_community='', snmp_oid='', snmp_port=161, hostid=10042, description='System board temperature', key_='system_board.temperature', delay=30, history=7, trends=365, nextcheck=0, lastvalue=NULL, lastclock=NULL, prevvalue=NULL, status=0, value_type=0, trapper_hosts='', units='°C', multiplier=0, delta=0, prevorgvalue=NULL, snmpv3_securityname='', snmpv3_securitylevel=0, snmpv3_authpassphrase='', snmpv3_privpassphrase='', formula='1', error='', lastlogsize=0, logtimefmt='', templateid=0, valuemapid=0, delay_flex='', params='', ipmi_sensor='mb.t_amb' WHERE itemid=21843; UPDATE items SET type=12, snmp_community='', snmp_oid='', snmp_port=161, hostid=10042, description='System board battery', key_='system_board.v_bat', delay=30, history=7, trends=365, nextcheck=0, lastvalue=NULL, lastclock=NULL, prevvalue=NULL, status=0, value_type=0, trapper_hosts='', units='v', multiplier=0, delta=0, prevorgvalue=NULL, snmpv3_securityname='', snmpv3_securitylevel=0, snmpv3_authpassphrase='', snmpv3_privpassphrase='', formula='1', error='', lastlogsize=0, logtimefmt='', templateid=0, valuemapid=0, delay_flex='', params='', ipmi_sensor='mb.v_bat' WHERE itemid=21844; -- changes in /branches/1.6/create/data/data.sql in SVN r6239 [ZBX-586] -- -- [fix typo in tcp,port simple check help] UPDATE help_items SET description='Checks if TCP service is running and accepting connections on port 0 - the serivce on the port is down 1 - the service is running' WHERE key_='tcp,port' AND itemtype=3; -- [add short help for simple check tcp_perf,port] INSERT INTO help_items VALUES (3,'tcp_perf,port','Checks if TCP service is running and accepting connections on port 0 - the service on the port is down Otherwise, number of milliseconds spent connecting to TCP service');