Zabbix 1.6.4 & MySQL A.10.00-5.0.45.001 ; Frontend Problem

[mbrand5371]

Using Zabbix 1.6.4 on RHEL5 x86_64 ; php-5.1.6-23.el5
Using MySQL A.10.00-5.0.45.001 on HP-UX 11.23



Created new Template: "LSKN_Template_ICMP-Ping"
Selected Template: "Template_Standalone"
Checked Item: "ICMP Ping"
Pressed: "Copy selected to ..."
Checked Template: "LSKN_Template_ICMP-Ping" as target
Pressed: "Copy"

Screen will rebuild to Menu and Window history. Nothing more.
Database transaction:

090728  7:30:25    1267 Init DB     zabbix1p
                   1267 Query       SELECT * FROM nodes WHERE nodetype=1 ORDER BY nodeid
                   1267 Query       SELECT u.*,s.*  FROM sessions s,users u WHERE s.sessionid='d711dc38efbc3dea13f9c48875c19f82' AND s.status=0 AND s.userid=u.userid AND ((s.lastaccess+u.autologout>1248759025) OR (u.autologout=0)) AND  (u.userid div 100000000000000) in (0)
                   1267 Query       SELECT MAX(g.gui_access) as gui_access  FROM usrgrp g, users_groups ug  WHERE ug.userid=3 AND g.usrgrpid=ug.usrgrpid
                   1267 Query       SELECT g.usrgrpid  FROM usrgrp g, users_groups ug  WHERE ug.userid = 3 AND g.usrgrpid = ug.usrgrpid  AND g.users_status = 1 limit 1
                   1267 Query       UPDATE sessions SET lastaccess=1248759025 WHERE sessionid='d711dc38efbc3dea13f9c48875c19f82'
                   1267 Query       SELECT * FROM nodes WHERE nodeid=0
                   1267 Query       SELECT * FROM nodes WHERE nodeid=0
                   1267 Query       SELECT nodeid FROM nodes WHERE  (nodeid IN (-1))
                   1267 Query       SELECT value_id, value_int, value_str, type  FROM profiles  WHERE userid=3 AND idx='web.menu.view.last' ORDER BY profileid ASC
                   1267 Query       SELECT nodeid FROM nodes WHERE  (nodeid IN (-1))
                   1267 Query       SELECT value_id, value_int, value_str, type  FROM profiles  WHERE userid=3 AND idx='web.menu.cm.last' ORDER BY profileid ASC
                   1267 Query       SELECT nodeid FROM nodes WHERE  (nodeid IN (-1))
                   1267 Query       SELECT value_id, value_int, value_str, type  FROM profiles  WHERE userid=3 AND idx='web.menu.reports.last' ORDER BY profileid ASC
                   1267 Query       SELECT nodeid FROM nodes WHERE  (nodeid IN (-1))
                   1267 Query       SELECT profileid  FROM profiles  WHERE userid=3 AND idx='web.menu.config.last'
                   1267 Query       UPDATE profiles  SET value_id=0, value_int=0, value_str='items.php', type=3, source='' WHERE userid=3 AND idx='web.menu.config.last'
                   1267 Query       SELECT value_id, value_int, value_str, type  FROM profiles  WHERE userid=3 AND idx='web.menu.config.last' ORDER BY profileid ASC
                   1267 Query       SELECT nodeid FROM nodes WHERE  (nodeid IN (-1))
                   1267 Query       SELECT value_id, value_int, value_str, type  FROM profiles  WHERE userid=3 AND idx='web.menu.admin.last' ORDER BY profileid ASC
                   1267 Query       SELECT * FROM config WHERE  (configid div 100000000000000) in (0)
                   1267 Query       SELECT value_id,value_int,value_str,source,type  FROM profiles  WHERE userid=3 AND idx='web.history.0' ORDER BY profileid ASC
                   1267 Query       SELECT value_id,value_int,value_str,source,type  FROM profiles  WHERE userid=3 AND idx='web.history.1' ORDER BY profileid ASC
                   1267 Query       SELECT value_id,value_int,value_str,source,type  FROM profiles  WHERE userid=3 AND idx='web.history.2' ORDER BY profileid ASC
                   1267 Query       SELECT value_id,value_int,value_str,source,type  FROM profiles  WHERE userid=3 AND idx='web.history.3' ORDER BY profileid ASC
                   1267 Query       SELECT value_id,value_int,value_str,source,type  FROM profiles  WHERE userid=3 AND idx='web.history.4' ORDER BY profileid ASC
                   1267 Query       SELECT value_id, value_int, value_str, type  FROM profiles  WHERE userid=3 AND idx='web.items.showdisabled' ORDER BY profileid ASC
                   1267 Query       SELECT value_id, value_int, value_str, type  FROM profiles  WHERE userid=3 AND idx='web.items.php.sort' ORDER BY profileid ASC
                   1267 Query       SELECT value_id, value_int, value_str, type  FROM profiles  WHERE userid=3 AND idx='web.items.php.sortorder' ORDER BY profileid ASC
                   1267 Query       SELECT profileid  FROM profiles  WHERE userid=3 AND idx='web.items.php.sort'
                   1267 Query       UPDATE profiles  SET value_id=0, value_int=0, value_str='i.description', type=3, source='' WHERE userid=3 AND idx='web.items.php.sort'
                   1267 Query       SELECT profileid  FROM profiles  WHERE userid=3 AND idx='web.items.php.sortorder'
                   1267 Query       UPDATE profiles  SET value_id=0, value_int=0, value_str='ASC', type=3, source='' WHERE userid=3 AND idx='web.items.php.sortorder'
                   1267 Query       SELECT value_id, value_int, value_str, type  FROM profiles  WHERE userid=3 AND idx='web.items.filter.enabled' ORDER BY profileid ASC
                   1267 Query       SELECT value_id, value_int, value_str, type  FROM profiles  WHERE userid=3 AND idx='web.items.filter.selection_mode' ORDER BY profileid ASC
                   1267 Query       SELECT value_id, value_int, value_str, type  FROM profiles  WHERE userid=3 AND idx='web.items.filter.selection_mode' ORDER BY profileid ASC
                   1267 Query       SELECT value_id, value_int, value_str, type  FROM profiles  WHERE userid=3 AND idx='web.items.filter.host' ORDER BY profileid ASC
                   1267 Query       SELECT value_id, value_int, value_str, type  FROM profiles  WHERE userid=3 AND idx='web.items.filter.description' ORDER BY profileid ASC
                   1267 Query       SELECT value_id, value_int, value_str, type  FROM profiles  WHERE userid=3 AND idx='web.items.filter.key' ORDER BY profileid ASC
                   1267 Query       SELECT DISTINCT n.nodeid, n.name as node_name, h.hostid, h.host, min(r.permission) as permission, ug.userid  FROM hosts h  LEFT JOIN hosts_groups hg ON hg.hostid=h.hostid  LEFT JOIN groups g ON g.groupid=hg.groupid  LEFT JOIN rights r ON r.id=g.groupid  LEFT JOIN users_groups ug ON ug.usrgrpid=r.groupid and ug.userid=3 LEFT JOIN nodes n ON (h.hostid div 100000000000000)=n.nodeid  WHERE  (h.hostid div 100000000000000) in (0)  GROUP BY h.hostid,n.nodeid,n.name,h.host,ug.userid  ORDER BY n.name,n.nodeid, h.host, permission, ug.userid
                   1267 Query       SELECT profileid  FROM profiles  WHERE userid=3 AND idx='web.items.showdisabled'
                   1267 Query       UPDATE profiles  SET value_id=0, value_int=1, value_str='', type=2, source='' WHERE userid=3 AND idx='web.items.showdisabled'
                   1267 Query       begin
                   1267 Query       SELECT itemid,description,key_,hostid,delay,history,status,type,snmp_community,snmp_oid,value_type,trapper_hosts,snmp_port,units,multiplier,delta,snmpv3_securityname,snmpv3_securitylevel,snmpv3_authpassphrase,snmpv3_privpassphrase,formula,trends,logtimefmt,valuemapid,delay_flex,params,ipmi_sensor,templateid  FROM items  WHERE itemid=17371
                   1267 Query       SELECT DISTINCT app.applicationid as result  FROM applications app, items_applications ia  WHERE app.applicationid=ia.applicationid  AND  (ia.itemid IN (17371))

Database configuration:

[client]
port            = 3306
socket          = /tmp/mysql.sock
[mysql]
no-auto-rehash
[mysqld]
port            = 3306
socket          = /tmp/mysql.sock
datadir         = /doku1p/mysql.db/mysql
bind-address    = 0.0.0.0
key_buffer=16M
max_allowed_packet=1M
sort_buffer=512K
net_buffer_length=8K
myisam_sort_buffer_size=8M
log-error       = /doku1p/mysql.log/doku1p.err
innodb_data_home_dir = /doku1p/mysql.db/mysql
innodb_log_group_home_dir = /doku1p/mysql.db/mysql
innodb_flush_log_at_trx_commit=1
innodb_log_archive=0
query_cache_size=16M
tmp_table_size=64M
max_heap_table_size=32M
thread_cache_size=10
table_cache=128
innodb_buffer_pool_size=256M
innodb_additional_mem_pool_size=20M
innodb_lock_wait_timeout=180
innodb_file_io_threads=4
innodb_thread_concurrency=6
thread_concurrency=2
log = /doku1p/mysql.log/doku1p.log
[mysqld_safe]
datadir         = /doku1p/mysql.db/mysql
[mysqldump]
quick
set-variable    = max_allowed_packet=16M
[isamchk]
set-variable    = key_buffer=20M
set-variable    = sort_buffer=20M
set-variable    = read_buffer=2M
set-variable    = write_buffer=2M
[myisamchk]
set-variable    = key_buffer=20M
set-variable    = sort_buffer=20M
set-variable    = read_buffer=2M
set-variable    = write_buffer=2M
[mysqlhotcopy]
interactive-timeout

Seems, not all needed transactions send to database.

Following error message in httpd-log:

==> /service/zabbix1p/var/log/httpd/ssl_error.log <==
[Tue Jul 28 09:45:57 2009] [error] [client 10.100.195.57] PHP Fatal error:  Call to undefined function check_db_fields() in /service/zabbix1p/share/zabbix/include/items.inc.php on line 226, referer: https://zabbix1p.dmz.polizei.niedersachsen.de/items.php

Any ideas ?

[mbrand5371]

Found the solution.

There was an corrupt: /etc/zabbix/db.inc.php
Regards, Marcus