Can't get it work. Help is needed

[winamp]

Hello!

I used zabbix 1.1.6 with postgresql. After hdd's with DB on it crashed I decided to upgrade to zabbix 1.4 with clear database. All looks fine except one fact - I can't get statistics from my cisco routers as I did earlier I attached two screenshots. After creation of new items they got status "Not Supported" about 3 minutes ago. From this server I can get stat from routers using command line and snmpget:
# snmpget -v1 -c public ip.ip.ip.ip .1.3.6.1.4.1.9.2.1.56.0
SNMPv2-SMI::enterprises.9.2.1.56.0 = INTEGER: 16

[Alexei]

I would be interested to see extract of ZABBIX server's log file to see why ZABBIX decided to make the item unsupported.

[winamp]

Here it is on DebugLevel=4:

  9049:20070620:201425 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.errors_from,i.snmp_port,i.delta,i.prevorgvalue,i.lastclock,i.units,i.multiplier,i.snmpv3_securityname,i.snmpv3_securitylevel,i.snmpv3_authpassphrase,i.snmpv3_privpassphrase,i.formula,h.available,i.status,i.trapper_hosts,i.logtimefmt,i.valuemapid,i.delay_flex,h.dns from hosts h, items i where i.nextcheck<=1182356065 and i.status in (0,3) and i.type not in (2,7,9) and h.status=0 and h.disable_until<=1182356065 and h.errors_from=0 and h.hostid=i.hostid and mod(i.itemid,5)=4 and i.key_ not in ('status','icmpping','icmppingsec','zabbix[log]') and  h.hostid>=100000000000000*0 and h.hostid<=(100000000000000*0+99999999999999)  order by i.nextcheck]
  9049:20070620:201425 End get_values()
  9049:20070620:201425 Spent 0 seconds while updating values
  9049:20070620:201425 Query [select count(*),min(nextcheck) from items i,hosts h where h.status=0 and h.disable_until<1182356065 and h.errors_from=0 and h.hostid=i.hostid and i.status in (0,3) and i.type not in (2,7,9) and mod(i.itemid,5)=4 and i.key_ not in ('status','icmpping','icmppingsec','zabbix[log]') and h.hostid>=100000000000000*0 and h.hostid<=(100000000000000*0+99999999999999) ]
  9049:20070620:201425 Nextcheck:1182356447 Time:1182356065
  9049:20070620:201425 Sleeping for 5 seconds
  9044:20070620:201425 In get_values()
  9044:20070620:201425 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.errors_from,i.snmp_port,i.delta,i.prevorgvalue,i.lastclock,i.units,i.multiplier,i.snmpv3_securityname,i.snmpv3_securitylevel,i.snmpv3_authpassphrase,i.snmpv3_privpassphrase,i.formula,h.available,i.status,i.trapper_hosts,i.logtimefmt,i.valuemapid,i.delay_flex,h.dns from hosts h, items i where i.nextcheck<=1182356065 and i.status in (0,3) and i.type not in (2,7,9) and h.status=0 and h.disable_until<=1182356065 and h.errors_from=0 and h.hostid=i.hostid and mod(i.itemid,5)=1 and i.key_ not in ('status','icmpping','icmppingsec','zabbix[log]') and  h.hostid>=100000000000000*0 and h.hostid<=(100000000000000*0+99999999999999)  order by i.nextcheck]
  9044:20070620:201425 End get_values()
  9044:20070620:201425 Spent 0 seconds while updating values
  9044:20070620:201425 Query [select count(*),min(nextcheck) from items i,hosts h where h.status=0 and h.disable_until<1182356065 and h.errors_from=0 and h.hostid=i.hostid and i.status in (0,3) and i.type not in (2,7,9) and mod(i.itemid,5)=1 and i.key_ not in ('status','icmpping','icmppingsec','zabbix[log]') and h.hostid>=100000000000000*0 and h.hostid<=(100000000000000*0+99999999999999) ]
  9044:20070620:201425 Nextcheck:1182356231 Time:1182356065
  9044:20070620:201425 Sleeping for 5 seconds
  9048:20070620:201425 In get_values()
  9048:20070620:201425 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.errors_from,i.snmp_port,i.delta,i.prevorgvalue,i.lastclock,i.units,i.multiplier,i.snmpv3_securityname,i.snmpv3_securitylevel,i.snmpv3_authpassphrase,i.snmpv3_privpassphrase,i.formula,h.available,i.status,i.trapper_hosts,i.logtimefmt,i.valuemapid,i.delay_flex,h.dns from hosts h, items i where i.nextcheck<=1182356065 and i.status in (0,3) and i.type not in (2,7,9) and h.status=0 and h.disable_until<=1182356065 and h.errors_from=0 and h.hostid=i.hostid and mod(i.itemid,5)=3 and i.key_ not in ('status','icmpping','icmppingsec','zabbix[log]') and  h.hostid>=100000000000000*0 and h.hostid<=(100000000000000*0+99999999999999)  order by i.nextcheck]
  9048:20070620:201425 End get_values()
  9048:20070620:201425 Spent 0 seconds while updating values
  9048:20070620:201425 Query [select count(*),min(nextcheck) from items i,hosts h where h.status=0 and h.disable_until<1182356065 and h.errors_from=0 and h.hostid=i.hostid and i.status in (0,3) and i.type not in (2,7,9) and mod(i.itemid,5)=3 and i.key_ not in ('status','icmpping','icmppingsec','zabbix[log]') and h.hostid>=100000000000000*0 and h.hostid<=(100000000000000*0+99999999999999) ]
  9048:20070620:201425 Nextcheck:1182356540 Time:1182356065
  9048:20070620:201425 Sleeping for 5 seconds
  9056:20070620:201425 In create_host_file()
  9056:20070620:201425 Query [select distinct h.ip from hosts h,items i where mod(h.hostid,1)=0 and i.hostid=h.hostid and h.status=0 and (i.key_='icmpping' or i.key_='icmppingsec') and i.type=3 and i.status=0 and h.useip=1 and h.hostid>=100000000000000*0 and h.hostid<=(100000000000000*0+99999999999999) ]
  9056:20070620:201425 Query [select distinct h.host from hosts h,items i where mod(h.hostid,1)=0 and i.hostid=h.hostid and h.status=0 and (i.key_='icmpping' or i.key_='icmppingsec') and i.type=3 and i.status=0 and h.useip=0 and h.hostid>=100000000000000*0 and h.hostid<=(100000000000000*0+99999999999999) ]
  9056:20070620:201425 In do_ping()
  9042:20070620:201426 In get_values()
  9042:20070620:201426 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.errors_from,i.snmp_port,i.delta,i.prevorgvalue,i.lastclock,i.units,i.multiplier,i.snmpv3_securityname,i.snmpv3_securitylevel,i.snmpv3_authpassphrase,i.snmpv3_privpassphrase,i.formula,h.available,i.status,i.trapper_hosts,i.logtimefmt,i.valuemapid,i.delay_flex,h.dns from hosts h, items i where i.nextcheck<=1182356066 and i.status in (0,3) and i.type not in (2,7,9) and h.status=0 and h.disable_until<=1182356066 and h.errors_from=0 and h.hostid=i.hostid and mod(i.itemid,5)=0 and i.key_ not in ('status','icmpping','icmppingsec','zabbix[log]') and  h.hostid>=100000000000000*0 and h.hostid<=(100000000000000*0+99999999999999)  order by i.nextcheck]
  9042:20070620:201426 End get_values()
  9042:20070620:201426 Spent 0 seconds while updating values
  9042:20070620:201426 Query [select count(*),min(nextcheck) from items i,hosts h where h.status=0 and h.disable_until<1182356066 and h.errors_from=0 and h.hostid=i.hostid and i.status in (0,3) and i.type not in (2,7,9) and mod(i.itemid,5)=0 and i.key_ not in ('status','icmpping','icmppingsec','zabbix[log]') and h.hostid>=100000000000000*0 and h.hostid<=(100000000000000*0+99999999999999) ]
  9042:20070620:201426 Nextcheck:1182356229 Time:1182356066
  9042:20070620:201426 Sleeping for 5 seconds
  9045:20070620:201428 In get_values()
  9045:20070620:201428 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.errors_from,i.snmp_port,i.delta,i.prevorgvalue,i.lastclock,i.units,i.multiplier,i.snmpv3_securityname,i.snmpv3_securitylevel,i.snmpv3_authpassphrase,i.snmpv3_privpassphrase,i.formula,h.available,i.status,i.trapper_hosts,i.logtimefmt,i.valuemapid,i.delay_flex,h.dns from hosts h, items i where i.nextcheck<=1182356068 and i.status in (0,3) and i.type not in (2,7,9) and h.status=0 and h.disable_until<=1182356068 and h.errors_from=0 and h.hostid=i.hostid and mod(i.itemid,5)=2 and i.key_ not in ('status','icmpping','icmppingsec','zabbix[log]') and  h.hostid>=100000000000000*0 and h.hostid<=(100000000000000*0+99999999999999)  order by i.nextcheck]
  9045:20070620:201428 End get_values()
  9045:20070620:201428 Spent 0 seconds while updating values
  9045:20070620:201428 Query [select count(*),min(nextcheck) from items i,hosts h where h.status=0 and h.disable_until<1182356068 and h.errors_from=0 and h.hostid=i.hostid and i.status in (0,3) and i.type not in (2,7,9) and mod(i.itemid,5)=2 and i.key_ not in ('status','icmpping','icmppingsec','zabbix[log]') and h.hostid>=100000000000000*0 and h.hostid<=(100000000000000*0+99999999999999) ]
  9045:20070620:201428 Nextcheck:1182356542 Time:1182356068
  9045:20070620:201428 Sleeping for 5 seconds
  9069:20070620:201428 In get_values()
  9069:20070620:201428 Query [select h.hostid,min(i.itemid) from hosts h,items i where mod(h.hostid,1)=0 and i.nextcheck<=1182356068 and i.status in (0) and i.type not in (2,7,9) and h.status=0 and h.disable_until<=1182356068 and h.errors_from!=0 and h.hostid=i.hostid and i.key_ not in ('status','icmpping','icmppingsec','zabbix[log]') and  h.hostid>=100000000000000*0 and h.hostid<=(100000000000000*0+99999999999999)  group by h.hostid]
  9069:20070620:201428 End get_values()
  9069:20070620:201428 Spent 0 seconds while updating values
  9069:20070620:201428 Query [select count(*),min(nextcheck) as nextcheck from items i,hosts h where mod(h.hostid,1)=0 and i.nextcheck<=1182356068 and i.status in (0) and i.type not in (2,7,9) and h.status=0 and h.disable_until<=1182356068 and h.errors_from!=0 and h.hostid=i.hostid and i.key_ not in ('status','icmpping','icmppingsec','zabbix[log]') and  h.hostid>=100000000000000*0 and h.hostid<=(100000000000000*0+99999999999999) order by nextcheck]
  9069:20070620:201428 Nextcheck:-1 Time:1182356068
  9069:20070620:201428 Sleeping for 5 seconds
  9074:20070620:201429 Starting sync with nodes
  9074:20070620:201429 In main_eventsender()
  9074:20070620:201429 In get_master_node(0)
  9074:20070620:201429 Query [select masterid from nodes where nodeid=0]
  9074:20070620:201429 In main_historysender()
  9074:20070620:201429 In get_master_node(0)
  9074:20070620:201429 Query [select masterid from nodes where nodeid=0]
  9074:20070620:201429 Sleeping 10 seconds

[Alexei]

Please set debug level to 3, enable this item and check for any new messages in the log file.

[winamp]

Switched to DebugLevel=3 and all items "became supported by agent" don't know what's the real reason, because I never changed any settings in conf file...
Anyway, thanks for your help