This is a post to help those who are going to use postgres SQL.

[rajeevtomar]

This is a post to help those who are going to use postgres SQL.

In schema.sql there is a syntax error (extra ",") in actions table creation.

Remove this and then do cat .

Rajeev

[iphigenie]

i also had a problem until i commented out in the zabbix configs the line which follows

# Experimental options. Use with care !

I kept getting the following error

041234:20051205:191838 zabbix_suckerd #1 started [Alerter]
041237:20051205:191838 zabbix_suckerd #4 started [Sucker. SNMP:ON]
041233:20051205:191838 zabbix_suckerd #0 started [Housekeeper]
041236:20051205:191838 zabbix_suckerd #3 started [ICMP pinger]
041234:20051205:191838 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_s
erver,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
041234:20051205:191838 Query failed:PGRES_FATAL_ERROR
041233:20051205:191838 One child process died. Exiting ...
041235:20051205:191838 Got QUIT or INT or TERM or PIPE signal. Exiting...
041237:20051205:191838 Got QUIT or INT or TERM or PIPE signal. Exiting...
041236:20051205:191838 Got QUIT or INT or TERM or PIPE signal. Exiting...

Even though the sql in there runs fine

[iphigenie]

One other thing:

The script does not seem to set the sequences properly, so you get an error whenever trying to insert something. How many times depends on how many preopulated rows there are in that table.

Of course you can go and set the sequences right, or try inserting until it works.

I haven't looked at the script to see why, must get all the zabbixx stuff running and then I'll have a look if someone hasnt done it first.