server dying upon startup

[zabbix_newb]

greetings and thanks in advance for any help.

the client starts and runs fine. mysql database appears in working order, popluated with the schema and data files

when the server starts, this is what gets logged with debug turned to 4

023436:20070301:144301 Starting zabbix_server. ZABBIX 1.1beta8.
023436:20070301:144301 Executing query:select refresh_unsupported from config
023436:20070301:144301 In DBnum_rows
023436:20070301:144301 Result of DBnum_rows [1]
023436:20070301:144301 In DBupdate_triggers_after_restart()
023436:20070301:144301 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<1172778181 and i.key_<>'status' and h.status not in (4,3)]
023436:20070301:144301 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<1172778181 and i.key_<>'status' and h.status not in (4,3)
023436:20070301:144301 In DBnum_rows
023436:20070301:144301 End of DBupdate_triggers_after_restart()
023438:20070301:144301 server #1 started [Alerter]
023438:20070301:144301 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 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<=1172778181 and a.mediatypeid=mt.mediatypeid order by a.clock
023439:20070301:144301 server #2 started [Timer]
023439:20070301:144301 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
023442:20070301:144301 server #3 started [ICMP pinger]
023438:20070301:144301 In DBnum_rows
023439:20070301:144301 In DBnum_rows
023444:20070301:144301 server #4 started [Escalator]
023444:20070301:144301 Selecting data from escalation_log
023447:20070301:144301 In child_main()
023447:20070301:144301 server #6 started [Trapper]
023447:20070301:144301 Before DBconnect()
023449:20070301:144301 In child_main()
023449:20070301:144301 server #7 started [Trapper]
023449:20070301:144301 Before DBconnect()
023447:20070301:144301 After DBconnect()
023447:20070301:144301 Before accept()
023449:20070301:144301 After DBconnect()
023449:20070301:144301 Before accept()
023444:20070301:144301 Executing query:select escalationlogid,triggerid, alarmid, escalationid, level, adminlevel, nextcheck, status from escalation_log where status=0 and nextcheck<=1172778181
023444:20070301:144301 In DBnum_rows
023442:20070301:144301 In create_host_file()
023442:20070301:144301 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<=1172778181)) and (i.key_='icmpping' or i.key_='icmppingsec') and i.type=3 and i.status=0 and h.useip=1
023442:20070301:144301 In DBnum_rows
023442:20070301:144301 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<=1172778181)) and (i.key_='icmpping' or i.key_='icmppingsec') and i.type=3 and i.status=0 and h.useip=0
023442:20070301:144301 In DBnum_rows
023442:20070301:144301 In do_ping()
023451:20070301:144301 In child_main()
023451:20070301:144301 server #8 started [Trapper]
023451:20070301:144301 Before DBconnect()
023451:20070301:144301 After DBconnect()
023451:20070301:144301 Before accept()
023456:20070301:144301 In child_main()
023456:20070301:144301 server #9 started [Trapper]
023456:20070301:144301 Before DBconnect()
023456:20070301:144301 After DBconnect()
023456:20070301:144301 Before accept()
023458:20070301:144301 In child_main()
023458:20070301:144301 server #10 started [Trapper]
023458:20070301:144301 Before DBconnect()
023458:20070301:144301 After DBconnect()
023458:20070301:144301 Before accept()
023436:20070301:144301 server #0 started [Housekeeper]
023436:20070301:144301 0. PID=[23438]
023436:20070301:144301 1. PID=[23439]
023436:20070301:144301 2. PID=[23442]
023436:20070301:144301 3. PID=[23444]
023436:20070301:144301 4. PID=[23445]
023436:20070301:144301 5. PID=[23447]
023436:20070301:144301 6. PID=[23449]
023436:20070301:144301 7. PID=[23451]
023436:20070301:144301 8. PID=[23456]
023436:20070301:144301 9. PID=[23458]
023436:20070301:144301 ZABBIX server is up.
023436:20070301:144301 One server process died. Shutting down...
023436:20070301:144301 0. Killing PID=[23438]
023438:20070301:144301 Server [1]. Got QUIT or INT or TERM or PIPE signal. Exiting...
023436:20070301:144301 1. Killing PID=[23439]
023436:20070301:144301 2. Killing PID=[23442]
023436:20070301:144301 3. Killing PID=[23444]
023436:20070301:144301 4. Killing PID=[23445]
023436:20070301:144301 5. Killing PID=[23447]
023436:20070301:144301 6. Killing PID=[23449]
023436:20070301:144301 7. Killing PID=[23451]
023436:20070301:144301 8. Killing PID=[23456]
023436:20070301:144301 9. Killing PID=[23458]
023436:20070301:144301 ZABBIX server is down.
023439:20070301:144301 Server [2]. Got QUIT or INT or TERM or PIPE signal. Exiting...
023442:20070301:144301 Server [3]. Got QUIT or INT or TERM or PIPE signal. Exiting...
023444:20070301:144301 Server [4]. Got QUIT or INT or TERM or PIPE signal. Exiting...
023447:20070301:144301 Server [6]. Got QUIT or INT or TERM or PIPE signal. Exiting...
023449:20070301:144301 Server [7]. Got QUIT or INT or TERM or PIPE signal. Exiting...
023451:20070301:144301 Server [8]. Got QUIT or INT or TERM or PIPE signal. Exiting...
023458:20070301:144301 Server [10]. Got QUIT or INT or TERM or PIPE signal. Exiting...
023456:20070301:144301 Server [9]. Got QUIT or INT or TERM or PIPE signal. Exiting...


########## here is the server config in etc



# This is config file for ZABBIX server process
# To get more information about ZABBIX,
# go http://www.zabbix.com

############ GENERAL PARAMETERS #################

# This defines which server this is.
# Default value 1
# This parameter must be between 1 and 255
Server=1

# Number of pre-forked instances of pollers
# Default value is 6
# This parameter must be between 5 and 255
StartSuckers=6

# Number of pre-forked instances of trappers
# Default value is 5
# This parameter must be between 2 and 255
StartTrappers=5

# Listen port for trapping. Default port number is 10051. This parameter
# must be between 1024 and 32767

ListenPort=10051

# How often ZABBIX will perform housekeeping procedure
# (in hours)
# Default value is 1 hour
# Housekeeping is removing unnecessary information from
# tables history, laert, and alarms
# This parameter must be between 1 and 24

HousekeepingFrequency=1

# How often ZABBIX will try to send unsent alerts
# (in seconds)
# Default value is 30 seconds
SenderFrequency=30

# Uncomment this line to disable housekeeping procedure

#DisableHousekeeping=1

# Specifies debug level
# 0 - debug is not created
# 1 - critical information
# 2 - error information
# 3 - warnings (default)
# 4 - for debugging (produces lots of information)

DebugLevel=4

# Specifies how long we wait for agent (in sec)
# Must be between 1 and 30
Timeout=30

# After how many seconds of unavailability treat a host as unavailable
UnavailablePeriod=20

# Name of PID file

PidFile=/var/tmp/zabbix_server.pid

# Name of log file
# If not set, syslog is used

LogFile=/var/log/zabbix_server.log

#Location for custom alert scripts
AlertScriptsPath=/home/zabbix/bin/

#Location of 'fping. Default is /usr/sbin/fping
#FpingLocation=/usr/sbin/fping

# Frequency of ICMP pings. Defauls is 30 second.
#PingerFrequency=30

# Database host name
# Default is localhost

#DBHost=localhost

# Database name

DBName=zabbix

# Database user

DBUser=root

# Database password
# Comment this line if no password used

#DBPassword=<password>

# Connect to MySQL using Unix socket?

DBSocket=/var/lib/mysql/mysql.sock

# Experimental options. Use with care !

# Get rid of sockets in TIME_WAIT state
# This will set socket option SO_LINGER
# NoTimeWait=1


any help would be appreciated. mysql version 5.0 running on redhat 3ES kernel 2.4

[Alexei]

Why do you use 1.1beta8? I would use latest stable 1.1.x instead.

[zabbix_newb]

I will try that to see if it makes a difference

i didnt see a 1.1 version for RedHat so I downloaded the beta for general Unix

edit >> i found the 1.1

thanks

[zabbix_newb]

downloaded and compiled zabbix.1.1.6

the server now starts as well as the agentd. installed/compiled all the mysql, apache, and php modules

imported the database .sql files (schema, images and data)
configured httpd.conf
configured /etc/services and /etc/zabbix files

restart all services and agents

i can now open and log into the zabbix interface as admin

created a group fine
added a host to it (local host).......fine i think because i have received 2 values for Host status with updated timestamp in the Last Check column

the problem I think is "activating" the Host i received a SQL error that says

Table 'zabbix.audit' doesnt exist
Query:insert into audit (userid,clock,action,resource,details) etc .....

i deleted the zaabix databse and created a new one, reimported the sql files and same thing happened

no data is being monitored

and the bottom of the web interface is reporting that I am using Zabbix 1.1 beta8 - even though i removed it, and all directories associated with it, before compiling 1.1.6 (i am positive 1.1.6 is what is running)


any suggestions / help ?

thanks
d

[zabbix_newb]

ok, i figured this out

apologies to anyone who may have pondered what was going on, but all i did was forget to update the public_htlm files after the new install and the correct version is being reported at the bottom of the browser

and as for the data updating, that seemed to correct itself too - just a matter of being patient

perhaps this will be able to take the place of mrtg, cacti and nagios all in 1 package !

thanks
and cheers

now if i can only find a zabbix tee shirt