When I reviewed the system log I encountered this error:
2009:06:05-00:58:02 OASIS system: database aggregation starting
2009:06:05-00:58:02 OASIS postgres[16666]: [3-1] ERROR: syntax error at or near "(" at character 173
2009:06:05-00:58:02 OASIS postgres[16666]: [3-2] STATEMENT: insert into accounting (ip_saddr, ip_daddr, ip_protocol, l4_dport, raw_in_pktlen, raw_in_pktcount, raw_out_pktlen,
2009:06:05-00:58:02 OASIS postgres[16666]: [3-3] raw_out_pktcount, flow_start_day, flow_duration, coalesce(_flow_count,1), flow_start_sec) select ip_saddr, ip_daddr,
2009:06:05-00:58:02 OASIS postgres[16666]: [3-4] ip_protocol, l4_dport, sum(raw_in_pktlen), sum(raw_in_pktcount), sum(raw_out_pktlen), sum(raw_out_pktcount), flow_start_day,
2009:06:05-00:58:02 OASIS postgres[16666]: [3-5] sum(flow_duration), sum(coalesce(_flow_count,1)), NULL from accounting where flow_start_day = $1 and flow_start_sec is not null
2009:06:05-00:58:02 OASIS postgres[16666]: [3-6] group by ip_saddr, ip_daddr, ip_protocol, l4_dport, flow_start_day
2009:06:05-00:58:02 OASIS system: INSERT failed in accounting (day 733563)
2009:06:05-00:58:02 OASIS system: database aggregation finished successfully
Looks like some scripting need to be edited. I have also noticed the web admin page is very slow, and has been since I did the initial install. At this point I am considering a reload of the software.
Jim[:O]
