yes when I check on the [STATUS OF ZABBIX] tab Is zabbix_suckerd running ? and Is zabbix_trapperd running ? shows the vaule as "NO".
I have checked the MySQL parameters and all are correct if not it will give error when suckerd or traperd start.
As u suggeted I enabled the debug mode in all the cobf files except for sukkered others are not giving any new info except that the service started.
In sukkered log I find lot of info But I am not able to make sense out of it.
I will paste a sample of it here Hope you would be able to identifiy the problem.
009714:20050426:114603 Executing query:select a.alertid,a.mediatypeid,a.sendto,a.subject,a.message,a.status,a.retries,mt.mediatypeid,mt.type,mt.description,mt.smtp_server,mt.smtp_helo,mt.smtp_email,mt.exec_path from alerts a,media_type mt where a.status=0 and a.retries<3 and a.mediatypeid=mt.mediatypeid order by a.clock
009714:20050426:114603 In DBnum_rows
009716:20050426:114603 Executing query:select distinct f.itemid,f.functionid,f.parameter from functions f, items i,hosts h where h.hostid=i.hostid and (h.status=0 or (h.status=2 and h.disable_until<1114541163)) and i.itemid=f.itemid and f.function='nodata' and i.lastclock+f.parameter<=1114541163 and i.status=0 and i.type=2 and f.lastvalue<>1
009716:20050426:114603 In DBnum_rows
009714:20050426:114633 Executing query:select a.alertid,a.mediatypeid,a.sendto,a.subject,a.message,a.status,a.retries,mt.mediatypeid,mt.type,mt.description,mt.smtp_server,mt.smtp_helo,mt.smtp_email,mt.exec_path from alerts a,media_type mt where a.status=0 and a.retries<3 and a.mediatypeid=mt.mediatypeid order by a.clock
009714:20050426:114633 In DBnum_rows
009716:20050426:114633 Executing query:select distinct f.itemid,f.functionid,f.parameter from functions f, items i,hosts h where h.hostid=i.hostid and (h.status=0 or (h.status=2 and h.disable_until<1114541193)) and i.itemid=f.itemid and f.function='nodata' and i.lastclock+f.parameter<=1114541193 and i.status=0 and i.type=2 and f.lastvalue<>1
009716:20050426:114633 In DBnum_rows
009723:20050426:114652 Executing query:select i.itemid,i.key_,h.host,h.port,i.delay,i.description,i.nextcheck,i.type,i.snmp_community,i.snmp_oid,h.useip,h.ip,i.history,i.lastvalue,i.prevvalue,i.hostid,h.status,i.value_type,h.network_errors,i.snmp_port,i.delta,i.prevorgvalue,i.lastclock from items i,hosts h where i.nextcheck<=1114541212 and i.status=0 and i.type not in (2) and (h.status=0 or (h.status=2 and h.disable_until<=1114541212)) and h.hostid=i.hostid and i.itemid%1=0 and i.key_<>'status' and i.key_<>'icmpping' and i.key_<>'icmppingsec' order by i.nextcheck
009723:20050426:114652 In DBnum_rows
009723:20050426:114652 Spent 0 seconds while updating values
009723:20050426:114652 Executing query:select count(*),min(nextcheck) from items i,hosts h where (h.status=0 or (h.status=2 and h.disable_until<1114541212)) and h.hostid=i.hostid and i.status=0 and i.type not in (2) and i.itemid%1=0 and i.key_<>'status' and i.key_<>'icmpping' and i.key_<>'icmppingsec'
009723:20050426:114652 In DBnum_rows
009723:20050426:114652 Result of DBnum_rows [1]
009723:20050426:114652 Nextcheck:-1 Time:1114541212
009723:20050426:114652 Sleeping for 60 seconds
009718:20050426:114652 In create_host_file()
009718:20050426:114652 Executing query:select distinct h.ip from hosts h,items i where i.hostid=h.hostid and (h.status=0 or (h.status=2 and h.disable_until<=1114541212)) and (i.key_='icmpping' or i.key_='icmppingsec') and i.type=3 and i.status=0 and h.useip=1
009718:20050426:114652 In DBnum_rows
009718:20050426:114652 Executing query:select distinct h.host from hosts h,items i where i.hostid=h.hostid and (h.status=0 or (h.status=2 and h.disable_until<=1114541212)) and (i.key_='icmpping' or i.key_='icmppingsec') and i.type=3 and i.status=0 and h.useip=0
009718:20050426:114652 In DBnum_rows
26 Replies
14248 Views