issue upgrading from beta11 to 1.1 stable
Am I missing an integral step here? I'm going to list my install/upgraden steps so ya'll can point out some obvious item I am missing or applying incorrectly. This is on FC3.
1. Shutdown local server and agent processes
2. ./configure --prefix=/usr --with-mysql --with-net-snmp --enable-server --enable-agent
3. make
4. make install
5. mysql -uroot -p zabbix < patch.sql (for 11 to 12 beta)
6. mysql -uroot -p zabbix < patch.sql (for 12 to 1.1 stable)
7. verify server config file
8. copy over the new frontend and update the db.config php include
9. start zabbix_server
This is what I get in the server log:
032695:20060609:161041 server #1 started [Alerter]
032695:20060609:161041 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<=1149887441 and a.mediatypeid=mt.mediatypeid order by a.clock
032697:20060609:161041 server #2 started [Timer]
032697:20060609:161041 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
032699:20060609:161041 server #3 started [ICMP pinger]
032699:20060609:161041 In create_host_file()
032699:20060609:161041 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<=1149887441)) and (i.key_='icmpping' or i.key_='icmppingsec') and i.type=3 and i.status=0 and h.useip=1
032699:20060609:161041 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<=1149887441)) and (i.key_='icmpping' or i.key_='icmppingsec') and i.type=3 and i.status=0 and h.useip=0
032699:20060609:161041 In do_ping()
032708:20060609:161041 In child_main()
032708:20060609:161041 server #8 started [Trapper]
032708:20060609:161041 Before DBconnect()
032708:20060609:161041 After DBconnect()
032708:20060609:161041 Before accept()
032710:20060609:161041 In child_main()
032710:20060609:161041 server #9 started [Trapper]
032710:20060609:161041 Before DBconnect()
032710:20060609:161041 After DBconnect()
032710:20060609:161041 Before accept()
032712:20060609:161041 In child_main()
032712:20060609:161041 server #10 started [Trapper]
032712:20060609:161041 Before DBconnect()
032712:20060609:161041 After DBconnect()
032712:20060609:161041 Before accept()
032714:20060609:161041 In child_main()
032714:20060609:161041 server #11 started [Trapper]
032714:20060609:161041 Before DBconnect()
032714:20060609:161041 After DBconnect()
032714:20060609:161041 Before accept()
032716:20060609:161041 In child_main()
032716:20060609:161041 server #12 started [Trapper]
032716:20060609:161041 Before DBconnect()
032716:20060609:161041 After DBconnect()
032716:20060609:161041 Before accept()
032718:20060609:161041 In child_main()
032718:20060609:161041 server #13 started [Trapper]
032718:20060609:161041 Before DBconnect()
032718:20060609:161041 After DBconnect()
032718:20060609:161041 Before accept()
032693:20060609:161041 server #0 started [Housekeeper]
032693:20060609:161041 0. PID=[32695]
032693:20060609:161041 1. PID=[32697]
032693:20060609:161041 2. PID=[32699]
032693:20060609:161041 3. PID=[32704]
032693:20060609:161041 4. PID=[32705]
032693:20060609:161041 5. PID=[32706]
032693:20060609:161041 6. PID=[32707]
032693:20060609:161041 7. PID=[32708]
032693:20060609:161041 8. PID=[32710]
032693:20060609:161041 9. PID=[32712]
032693:20060609:161041 10. PID=[32714]
032693:20060609:161041 11. PID=[32716]
032693:20060609:161041 12. PID=[32718]
032693:20060609:161041 ZABBIX server is up.
032693:20060609:161041 In housekeeping_process_log()
032693:20060609:161041 Executing query:select housekeeperid, tablename, field, value from housekeeper order by tablename
032693:20060609:161041 One server process died. Shutting down...
032695:20060609:161041 Server [1]. Got QUIT or INT or TERM or PIPE signal. Exiting...
032693:20060609:161041 0. Killing PID=[32695]
032697:20060609:161041 Server [2]. Got QUIT or INT or TERM or PIPE signal. Exiting...
032693:20060609:161041 1. Killing PID=[32697]
032699:20060609:161041 Server [3]. Got QUIT or INT or TERM or PIPE signal. Exiting...
032693:20060609:161041 2. Killing PID=[32699]
032693:20060609:161041 3. Killing PID=[32704]
032693:20060609:161041 4. Killing PID=[32705]
032693:20060609:161041 5. Killing PID=[32706]
032693:20060609:161041 6. Killing PID=[32707]
032708:20060609:161041 Server [8]. Got QUIT or INT or TERM or PIPE signal. Exiting...
032693:20060609:161041 7. Killing PID=[32708]
032710:20060609:161041 Server [9]. Got QUIT or INT or TERM or PIPE signal. Exiting...
032693:20060609:161041 8. Killing PID=[32710]
032712:20060609:161041 Server [10]. Got QUIT or INT or TERM or PIPE signal. Exiting...
032693:20060609:161041 9. Killing PID=[32712]
032714:20060609:161041 Server [11]. Got QUIT or INT or TERM or PIPE signal. Exiting...
032693:20060609:161041 10. Killing PID=[32714]
032716:20060609:161041 Server [12]. Got QUIT or INT or TERM or PIPE signal. Exiting...
032693:20060609:161041 11. Killing PID=[32716]
032718:20060609:161041 Server [13]. Got QUIT or INT or TERM or PIPE signal. Exiting...
032693:20060609:161041 12. Killing PID=[32718]
032693:20060609:161041 ZABBIX server is down.
032707:20060609:161041 Server [7]. Got QUIT or INT or TERM or PIPE signal. Exiting...
Here is my conf file:
Server=1
StartPollers=8
StartTrappers=6
ListenPort=10051
HousekeepingFrequency=1
SenderFrequency=30
DebuLevel=4
Timeout=5
PidFile=/var/tmp/zabbix_server.pid
LogFile=/tmp/zabbix_server.log
AlertScript=/home/zabbix/scripts
PingerFrequency=30
DBHost=localhost
DBName=zabbix
DBuser=someuser
DBPassword=somepassword
DBSocket=/var/lib/mysql/mysql.sock
1. Shutdown local server and agent processes
2. ./configure --prefix=/usr --with-mysql --with-net-snmp --enable-server --enable-agent
3. make
4. make install
5. mysql -uroot -p zabbix < patch.sql (for 11 to 12 beta)
6. mysql -uroot -p zabbix < patch.sql (for 12 to 1.1 stable)
7. verify server config file
8. copy over the new frontend and update the db.config php include
9. start zabbix_server
This is what I get in the server log:
032695:20060609:161041 server #1 started [Alerter]
032695:20060609:161041 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<=1149887441 and a.mediatypeid=mt.mediatypeid order by a.clock
032697:20060609:161041 server #2 started [Timer]
032697:20060609:161041 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
032699:20060609:161041 server #3 started [ICMP pinger]
032699:20060609:161041 In create_host_file()
032699:20060609:161041 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<=1149887441)) and (i.key_='icmpping' or i.key_='icmppingsec') and i.type=3 and i.status=0 and h.useip=1
032699:20060609:161041 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<=1149887441)) and (i.key_='icmpping' or i.key_='icmppingsec') and i.type=3 and i.status=0 and h.useip=0
032699:20060609:161041 In do_ping()
032708:20060609:161041 In child_main()
032708:20060609:161041 server #8 started [Trapper]
032708:20060609:161041 Before DBconnect()
032708:20060609:161041 After DBconnect()
032708:20060609:161041 Before accept()
032710:20060609:161041 In child_main()
032710:20060609:161041 server #9 started [Trapper]
032710:20060609:161041 Before DBconnect()
032710:20060609:161041 After DBconnect()
032710:20060609:161041 Before accept()
032712:20060609:161041 In child_main()
032712:20060609:161041 server #10 started [Trapper]
032712:20060609:161041 Before DBconnect()
032712:20060609:161041 After DBconnect()
032712:20060609:161041 Before accept()
032714:20060609:161041 In child_main()
032714:20060609:161041 server #11 started [Trapper]
032714:20060609:161041 Before DBconnect()
032714:20060609:161041 After DBconnect()
032714:20060609:161041 Before accept()
032716:20060609:161041 In child_main()
032716:20060609:161041 server #12 started [Trapper]
032716:20060609:161041 Before DBconnect()
032716:20060609:161041 After DBconnect()
032716:20060609:161041 Before accept()
032718:20060609:161041 In child_main()
032718:20060609:161041 server #13 started [Trapper]
032718:20060609:161041 Before DBconnect()
032718:20060609:161041 After DBconnect()
032718:20060609:161041 Before accept()
032693:20060609:161041 server #0 started [Housekeeper]
032693:20060609:161041 0. PID=[32695]
032693:20060609:161041 1. PID=[32697]
032693:20060609:161041 2. PID=[32699]
032693:20060609:161041 3. PID=[32704]
032693:20060609:161041 4. PID=[32705]
032693:20060609:161041 5. PID=[32706]
032693:20060609:161041 6. PID=[32707]
032693:20060609:161041 7. PID=[32708]
032693:20060609:161041 8. PID=[32710]
032693:20060609:161041 9. PID=[32712]
032693:20060609:161041 10. PID=[32714]
032693:20060609:161041 11. PID=[32716]
032693:20060609:161041 12. PID=[32718]
032693:20060609:161041 ZABBIX server is up.
032693:20060609:161041 In housekeeping_process_log()
032693:20060609:161041 Executing query:select housekeeperid, tablename, field, value from housekeeper order by tablename
032693:20060609:161041 One server process died. Shutting down...
032695:20060609:161041 Server [1]. Got QUIT or INT or TERM or PIPE signal. Exiting...
032693:20060609:161041 0. Killing PID=[32695]
032697:20060609:161041 Server [2]. Got QUIT or INT or TERM or PIPE signal. Exiting...
032693:20060609:161041 1. Killing PID=[32697]
032699:20060609:161041 Server [3]. Got QUIT or INT or TERM or PIPE signal. Exiting...
032693:20060609:161041 2. Killing PID=[32699]
032693:20060609:161041 3. Killing PID=[32704]
032693:20060609:161041 4. Killing PID=[32705]
032693:20060609:161041 5. Killing PID=[32706]
032693:20060609:161041 6. Killing PID=[32707]
032708:20060609:161041 Server [8]. Got QUIT or INT or TERM or PIPE signal. Exiting...
032693:20060609:161041 7. Killing PID=[32708]
032710:20060609:161041 Server [9]. Got QUIT or INT or TERM or PIPE signal. Exiting...
032693:20060609:161041 8. Killing PID=[32710]
032712:20060609:161041 Server [10]. Got QUIT or INT or TERM or PIPE signal. Exiting...
032693:20060609:161041 9. Killing PID=[32712]
032714:20060609:161041 Server [11]. Got QUIT or INT or TERM or PIPE signal. Exiting...
032693:20060609:161041 10. Killing PID=[32714]
032716:20060609:161041 Server [12]. Got QUIT or INT or TERM or PIPE signal. Exiting...
032693:20060609:161041 11. Killing PID=[32716]
032718:20060609:161041 Server [13]. Got QUIT or INT or TERM or PIPE signal. Exiting...
032693:20060609:161041 12. Killing PID=[32718]
032693:20060609:161041 ZABBIX server is down.
032707:20060609:161041 Server [7]. Got QUIT or INT or TERM or PIPE signal. Exiting...
Here is my conf file:
Server=1
StartPollers=8
StartTrappers=6
ListenPort=10051
HousekeepingFrequency=1
SenderFrequency=30
DebuLevel=4
Timeout=5
PidFile=/var/tmp/zabbix_server.pid
LogFile=/tmp/zabbix_server.log
AlertScript=/home/zabbix/scripts
PingerFrequency=30
DBHost=localhost
DBName=zabbix
DBuser=someuser
DBPassword=somepassword
DBSocket=/var/lib/mysql/mysql.sock
Comment