Zabbix die after few seconds
I Have zabbix 1.1 installed on a RedHat9.
configured with:
./configure --enable-server --with-mysql --with-net-snmp
When i start it i have this log .. and die after 2-3 seconds:
[root@localhost zabbix]# cat /tmp/zabbix_server.log
018397:20060606:120603 Starting zabbix_server. ZABBIX 1.1.
018397:20060606:120603 Executing query:select refresh_unsupported from config
018397:20060606:120603 In DBupdate_triggers_after_restart()
018397:20060606:120603 SQL [select distinct t.triggerid,t.value from hosts h,items i,triggers t,functions f where f.triggerid=t.triggerid and f.itemid=i.itemid and h.hostid=i.hostid and i.nextcheck+i.delay<1149588363 and i.key_<>'status' and h.status not in (4,3)]
018397:20060606:120603 Executing query:select distinct t.triggerid,t.value from hosts h,items i,triggers t,functions f where f.triggerid=t.triggerid and f.itemid=i.itemid and h.hostid=i.hostid and i.nextcheck+i.delay<1149588363 and i.key_<>'status' and h.status not in (4,3)
018397:20060606:120603 End of DBupdate_triggers_after_restart()
018399:20060606:120603 server #1 started [Alerter]
018399:20060606:120603 Executing query:select a.alertid,a.mediatypeid,a.sendto,a.subject,a.messa ge,a.status,a.retries,mt.mediatypeid,mt.type,mt.de scription,mt.smtp_server,mt.smtp_helo,mt.smtp_emai l,mt.exec_path,a.delay,mt.gsm_modem from alerts a,media_type mt where a.status=0 and a.retries<3 and (a.repeats<a.maxrepeats or a.maxrepeats=0) and a.nextcheck<=1149588363 and a.mediatypeid=mt.mediatypeid order by a.clock
018401:20060606:120603 server #2 started [Timer]
018401:20060606:120603 Executing query:select distinct i.itemid,i.key_,h.host,h.port,i.delay,i.descriptio n,i.nextcheck,i.type,i.snmp_community,i.snmp_oid,h .useip,h.ip,i.history,i.lastvalue,i.prevvalue,i.ho stid,h.status,i.value_type,h.errors_from,i.snmp_po rt,i.delta,i.prevorgvalue,i.lastclock,i.units,i.mu ltiplier,i.snmpv3_securityname,i.snmpv3_securityle vel,i.snmpv3_authpassphrase,i.snmpv3_privpassphras e,i.formula,h.available,i.status,i.trapper_hosts,i .logtimefmt,i.valuemapid from hosts h, items i, functions f where h.hostid=i.hostid and h.status=0 and i.status=0 and f.function in ('nodata','date','dayofweek','time','now') and i.itemid=f.itemid
018403:20060606:120603 server #3 started [ICMP pinger]
018407:20060606:120603 In child_main()
018407:20060606:120603 server #6 started [Trapper]
018407:20060606:120603 Before DBconnect()
018407:20060606:120603 After DBconnect()
018407:20060606:120603 Before accept()
018409:20060606:120603 In child_main()
018409:20060606:120603 server #7 started [Trapper]
018409:20060606:120603 Before DBconnect()
018409:20060606:120603 After DBconnect()
018409:20060606:120603 Before accept()
018403:20060606:120603 In create_host_file()
018403:20060606:120603 Executing query:select distinct h.ip from hosts h,items i where i.hostid=h.hostid and (h.status=0 or (h.status=0 and h.available=2 and h.disable_until<=1149588363)) and (i.key_='icmpping' or i.key_='icmppingsec') and i.type=3 and i.status=0 and h.useip=1
018403:20060606:120603 Executing query:select distinct h.host from hosts h,items i where i.hostid=h.hostid and (h.status=0 or (h.status=0 and h.available=2 and h.disable_until<=1149588363)) and (i.key_='icmpping' or i.key_='icmppingsec') and i.type=3 and i.status=0 and h.useip=0
018403:20060606:120603 In do_ping()
018411:20060606:120603 In child_main()
018411:20060606:120603 server #8 started [Trapper]
018411:20060606:120603 Before DBconnect()
018411:20060606:120603 After DBconnect()
018411:20060606:120603 Before accept()
018416:20060606:120603 In child_main()
018416:20060606:120603 server #9 started [Trapper]
018416:20060606:120603 Before DBconnect()
018416:20060606:120603 After DBconnect()
018416:20060606:120603 Before accept()
018418:20060606:120603 In child_main()
018418:20060606:120603 server #10 started [Trapper]
018418:20060606:120603 Before DBconnect()
018397:20060606:120603 server #0 started [Housekeeper]
018397:20060606:120603 0. PID=[18399]
018397:20060606:120603 1. PID=[18401]
018397:20060606:120603 2. PID=[18403]
018397:20060606:120603 3. PID=[18405]
018397:20060606:120603 4. PID=[18406]
018397:20060606:120603 5. PID=[18407]
018397:20060606:120603 6. PID=[18409]
018397:20060606:120603 7. PID=[18411]
018397:20060606:120603 8. PID=[18416]
018397:20060606:120603 9. PID=[18418]
018397:20060606:120603 ZABBIX server is up.
018397:20060606:120603 In housekeeping_process_log()
018397:20060606:120603 Executing query:select housekeeperid, tablename, field, value from housekeeper order by tablename
018397:20060606:120603 In housekeeping_alarms(1149588363)
018397:20060606:120603 Executing query:select alarm_history from config
018397:20060606:120603 Executing query:select alarmid from alarms where clock<1118052363
018397:20060606:120603 In housekeeping_alerts(1149588363)
018397:20060606:120603 Executing query:select alert_history from config
018397:20060606:120603 Executing query:delete from alerts where clock<1118052363
018397:20060606:120603 Deleted [0] records from table [alerts]
018397:20060606:120603 In housekeeping_sessions(1149588363)
018397:20060606:120603 Executing query:delete from sessions where lastaccess<1149501963
018397:20060606:120603 Deleted [0] records from table [sessions]
018397:20060606:120603 Sleeping for 1 hours
018418:20060606:120603 After DBconnect()
018418:20060606:120603 Before accept()
018397:20060606:120608 One server process died. Shutting down...
018397:20060606:120608 0. Killing PID=[18399]
018397:20060606:120608 1. Killing PID=[18401]
018397:20060606:120608 2. Killing PID=[18403]
018397:20060606:120608 3. Killing PID=[18405]
018397:20060606:120608 4. Killing PID=[18406]
018397:20060606:120608 5. Killing PID=[18407]
018397:20060606:120608 6. Killing PID=[18409]
018397:20060606:120608 7. Killing PID=[18411]
018397:20060606:120608 8. Killing PID=[18416]
018397:20060606:120608 9. Killing PID=[18418]
018397:20060606:120608 ZABBIX server is down.
018399:20060606:120608 Server [1]. Got QUIT or INT or TERM or PIPE signal. Exiting...
018401:20060606:120608 Server [2]. Got QUIT or INT or TERM or PIPE signal. Exiting...
018403:20060606:120608 Server [3]. Got QUIT or INT or TERM or PIPE signal. Exiting...
018407:20060606:120608 Server [6]. Got QUIT or INT or TERM or PIPE signal. Exiting...
018409:20060606:120608 Server [7]. Got QUIT or INT or TERM or PIPE signal. Exiting...
018411:20060606:120608 Server [8]. Got QUIT or INT or TERM or PIPE signal. Exiting...
018416:20060606:120608 Server [9]. Got QUIT or INT or TERM or PIPE signal. Exiting...
018418:20060606:120608 Server [10]. Got QUIT or INT or TERM or PIPE signal. Exiting...
018405:20060606:120608 Server [4]. Got QUIT or INT or TERM or PIPE signal. Exiting...
My Sql tables are OK:
[root@localhost bin]# mysqlcheck -uroot -p zabbix
Enter password:
zabbix.acknowledges OK
zabbix.actions OK
zabbix.alarms OK
zabbix.alerts OK
zabbix.applications OK
zabbix.auditlog OK
zabbix.autoreg OK
zabbix.conditions OK
zabbix.config OK
zabbix.functions OK
zabbix.graphs OK
zabbix.graphs_items OK
zabbix.groups OK
zabbix.help_items OK
zabbix.history OK
zabbix.history_log OK
zabbix.history_str OK
zabbix.history_text OK
zabbix.history_uint OK
zabbix.hosts OK
zabbix.hosts_groups OK
zabbix.hosts_profiles OK
zabbix.hosts_templates OK
zabbix.housekeeper OK
zabbix.images OK
zabbix.items OK
zabbix.items_applications OK
zabbix.mappings OK
zabbix.media OK
zabbix.media_type OK
zabbix.profiles OK
zabbix.rights OK
zabbix.screens OK
zabbix.screens_items OK
zabbix.service_alarms OK
zabbix.services OK
zabbix.services_links OK
zabbix.sessions OK
zabbix.sysmaps OK
zabbix.sysmaps_elements OK
zabbix.sysmaps_links OK
zabbix.trends OK
zabbix.trigger_depends OK
zabbix.triggers OK
zabbix.users OK
zabbix.users_groups OK
zabbix.usrgrp OK
zabbix.valuemaps OK
Please help me :-)
Thanks
configured with:
./configure --enable-server --with-mysql --with-net-snmp
When i start it i have this log .. and die after 2-3 seconds:
[root@localhost zabbix]# cat /tmp/zabbix_server.log
018397:20060606:120603 Starting zabbix_server. ZABBIX 1.1.
018397:20060606:120603 Executing query:select refresh_unsupported from config
018397:20060606:120603 In DBupdate_triggers_after_restart()
018397:20060606:120603 SQL [select distinct t.triggerid,t.value from hosts h,items i,triggers t,functions f where f.triggerid=t.triggerid and f.itemid=i.itemid and h.hostid=i.hostid and i.nextcheck+i.delay<1149588363 and i.key_<>'status' and h.status not in (4,3)]
018397:20060606:120603 Executing query:select distinct t.triggerid,t.value from hosts h,items i,triggers t,functions f where f.triggerid=t.triggerid and f.itemid=i.itemid and h.hostid=i.hostid and i.nextcheck+i.delay<1149588363 and i.key_<>'status' and h.status not in (4,3)
018397:20060606:120603 End of DBupdate_triggers_after_restart()
018399:20060606:120603 server #1 started [Alerter]
018399:20060606:120603 Executing query:select a.alertid,a.mediatypeid,a.sendto,a.subject,a.messa ge,a.status,a.retries,mt.mediatypeid,mt.type,mt.de scription,mt.smtp_server,mt.smtp_helo,mt.smtp_emai l,mt.exec_path,a.delay,mt.gsm_modem from alerts a,media_type mt where a.status=0 and a.retries<3 and (a.repeats<a.maxrepeats or a.maxrepeats=0) and a.nextcheck<=1149588363 and a.mediatypeid=mt.mediatypeid order by a.clock
018401:20060606:120603 server #2 started [Timer]
018401:20060606:120603 Executing query:select distinct i.itemid,i.key_,h.host,h.port,i.delay,i.descriptio n,i.nextcheck,i.type,i.snmp_community,i.snmp_oid,h .useip,h.ip,i.history,i.lastvalue,i.prevvalue,i.ho stid,h.status,i.value_type,h.errors_from,i.snmp_po rt,i.delta,i.prevorgvalue,i.lastclock,i.units,i.mu ltiplier,i.snmpv3_securityname,i.snmpv3_securityle vel,i.snmpv3_authpassphrase,i.snmpv3_privpassphras e,i.formula,h.available,i.status,i.trapper_hosts,i .logtimefmt,i.valuemapid from hosts h, items i, functions f where h.hostid=i.hostid and h.status=0 and i.status=0 and f.function in ('nodata','date','dayofweek','time','now') and i.itemid=f.itemid
018403:20060606:120603 server #3 started [ICMP pinger]
018407:20060606:120603 In child_main()
018407:20060606:120603 server #6 started [Trapper]
018407:20060606:120603 Before DBconnect()
018407:20060606:120603 After DBconnect()
018407:20060606:120603 Before accept()
018409:20060606:120603 In child_main()
018409:20060606:120603 server #7 started [Trapper]
018409:20060606:120603 Before DBconnect()
018409:20060606:120603 After DBconnect()
018409:20060606:120603 Before accept()
018403:20060606:120603 In create_host_file()
018403:20060606:120603 Executing query:select distinct h.ip from hosts h,items i where i.hostid=h.hostid and (h.status=0 or (h.status=0 and h.available=2 and h.disable_until<=1149588363)) and (i.key_='icmpping' or i.key_='icmppingsec') and i.type=3 and i.status=0 and h.useip=1
018403:20060606:120603 Executing query:select distinct h.host from hosts h,items i where i.hostid=h.hostid and (h.status=0 or (h.status=0 and h.available=2 and h.disable_until<=1149588363)) and (i.key_='icmpping' or i.key_='icmppingsec') and i.type=3 and i.status=0 and h.useip=0
018403:20060606:120603 In do_ping()
018411:20060606:120603 In child_main()
018411:20060606:120603 server #8 started [Trapper]
018411:20060606:120603 Before DBconnect()
018411:20060606:120603 After DBconnect()
018411:20060606:120603 Before accept()
018416:20060606:120603 In child_main()
018416:20060606:120603 server #9 started [Trapper]
018416:20060606:120603 Before DBconnect()
018416:20060606:120603 After DBconnect()
018416:20060606:120603 Before accept()
018418:20060606:120603 In child_main()
018418:20060606:120603 server #10 started [Trapper]
018418:20060606:120603 Before DBconnect()
018397:20060606:120603 server #0 started [Housekeeper]
018397:20060606:120603 0. PID=[18399]
018397:20060606:120603 1. PID=[18401]
018397:20060606:120603 2. PID=[18403]
018397:20060606:120603 3. PID=[18405]
018397:20060606:120603 4. PID=[18406]
018397:20060606:120603 5. PID=[18407]
018397:20060606:120603 6. PID=[18409]
018397:20060606:120603 7. PID=[18411]
018397:20060606:120603 8. PID=[18416]
018397:20060606:120603 9. PID=[18418]
018397:20060606:120603 ZABBIX server is up.
018397:20060606:120603 In housekeeping_process_log()
018397:20060606:120603 Executing query:select housekeeperid, tablename, field, value from housekeeper order by tablename
018397:20060606:120603 In housekeeping_alarms(1149588363)
018397:20060606:120603 Executing query:select alarm_history from config
018397:20060606:120603 Executing query:select alarmid from alarms where clock<1118052363
018397:20060606:120603 In housekeeping_alerts(1149588363)
018397:20060606:120603 Executing query:select alert_history from config
018397:20060606:120603 Executing query:delete from alerts where clock<1118052363
018397:20060606:120603 Deleted [0] records from table [alerts]
018397:20060606:120603 In housekeeping_sessions(1149588363)
018397:20060606:120603 Executing query:delete from sessions where lastaccess<1149501963
018397:20060606:120603 Deleted [0] records from table [sessions]
018397:20060606:120603 Sleeping for 1 hours
018418:20060606:120603 After DBconnect()
018418:20060606:120603 Before accept()
018397:20060606:120608 One server process died. Shutting down...
018397:20060606:120608 0. Killing PID=[18399]
018397:20060606:120608 1. Killing PID=[18401]
018397:20060606:120608 2. Killing PID=[18403]
018397:20060606:120608 3. Killing PID=[18405]
018397:20060606:120608 4. Killing PID=[18406]
018397:20060606:120608 5. Killing PID=[18407]
018397:20060606:120608 6. Killing PID=[18409]
018397:20060606:120608 7. Killing PID=[18411]
018397:20060606:120608 8. Killing PID=[18416]
018397:20060606:120608 9. Killing PID=[18418]
018397:20060606:120608 ZABBIX server is down.
018399:20060606:120608 Server [1]. Got QUIT or INT or TERM or PIPE signal. Exiting...
018401:20060606:120608 Server [2]. Got QUIT or INT or TERM or PIPE signal. Exiting...
018403:20060606:120608 Server [3]. Got QUIT or INT or TERM or PIPE signal. Exiting...
018407:20060606:120608 Server [6]. Got QUIT or INT or TERM or PIPE signal. Exiting...
018409:20060606:120608 Server [7]. Got QUIT or INT or TERM or PIPE signal. Exiting...
018411:20060606:120608 Server [8]. Got QUIT or INT or TERM or PIPE signal. Exiting...
018416:20060606:120608 Server [9]. Got QUIT or INT or TERM or PIPE signal. Exiting...
018418:20060606:120608 Server [10]. Got QUIT or INT or TERM or PIPE signal. Exiting...
018405:20060606:120608 Server [4]. Got QUIT or INT or TERM or PIPE signal. Exiting...
My Sql tables are OK:
[root@localhost bin]# mysqlcheck -uroot -p zabbix
Enter password:
zabbix.acknowledges OK
zabbix.actions OK
zabbix.alarms OK
zabbix.alerts OK
zabbix.applications OK
zabbix.auditlog OK
zabbix.autoreg OK
zabbix.conditions OK
zabbix.config OK
zabbix.functions OK
zabbix.graphs OK
zabbix.graphs_items OK
zabbix.groups OK
zabbix.help_items OK
zabbix.history OK
zabbix.history_log OK
zabbix.history_str OK
zabbix.history_text OK
zabbix.history_uint OK
zabbix.hosts OK
zabbix.hosts_groups OK
zabbix.hosts_profiles OK
zabbix.hosts_templates OK
zabbix.housekeeper OK
zabbix.images OK
zabbix.items OK
zabbix.items_applications OK
zabbix.mappings OK
zabbix.media OK
zabbix.media_type OK
zabbix.profiles OK
zabbix.rights OK
zabbix.screens OK
zabbix.screens_items OK
zabbix.service_alarms OK
zabbix.services OK
zabbix.services_links OK
zabbix.sessions OK
zabbix.sysmaps OK
zabbix.sysmaps_elements OK
zabbix.sysmaps_links OK
zabbix.trends OK
zabbix.trigger_depends OK
zabbix.triggers OK
zabbix.users OK
zabbix.users_groups OK
zabbix.usrgrp OK
zabbix.valuemaps OK
Please help me :-)
Thanks