I suppose postgres has restricted what a timestamp can be since this was created. However that doesn't make sense to make the insertion date default to the year 0000.
On 10 April 2013 16:49, David M Smith <sidic...@gmail.com> wrote: > Package: pmacct > Version: 0.14.0-1.1 > Severity: important > > Dear Maintainer, > *** Please consider answering these questions, where appropriate *** > > * What led up to the situation? > I was following the README and > /usr/share/doc/pmacct/sql/pmacct-create-table_v7.pgsql > throws an error that it cannot create the database table. > > > * What exactly did you do (or not do) that was effective (or > ineffective)? > I tried creating the table manually. > > * What was the outcome of this action? > Didn't work, it appears there is a problem with the table create statement. > > * What outcome did you expect instead? > I expected it to create the table. > > > pmacct=# CREATE TABLE acct_v7 ( > pmacct(# agent_id BIGINT NOT NULL DEFAULT 0, > pmacct(# class_id CHAR(16) NOT NULL DEFAULT ' ', > pmacct(# mac_src macaddr NOT NULL DEFAULT '0:0:0:0:0:0', > pmacct(# mac_dst macaddr NOT NULL DEFAULT '0:0:0:0:0:0', > pmacct(# vlan INT NOT NULL DEFAULT 0, > pmacct(# as_src BIGINT NOT NULL DEFAULT 0, > pmacct(# as_dst BIGINT NOT NULL DEFAULT 0, > pmacct(# ip_src inet NOT NULL DEFAULT '0.0.0.0', > pmacct(# ip_dst inet NOT NULL DEFAULT '0.0.0.0', > pmacct(# port_src INT NOT NULL DEFAULT 0, > pmacct(# port_dst INT NOT NULL DEFAULT 0, > pmacct(# tcp_flags SMALLINT NOT NULL DEFAULT 0, > pmacct(# ip_proto SMALLINT NOT NULL DEFAULT 0, > pmacct(# tos INT NOT NULL DEFAULT 0, > pmacct(# packets INT NOT NULL, > pmacct(# bytes BIGINT NOT NULL, > pmacct(# flows INT NOT NULL DEFAULT 0, > pmacct(# stamp_inserted timestamp without time zone NOT NULL > DEFAULT '0000-01-01 00:00:00', > pmacct(# stamp_updated timestamp without time zone, > pmacct(# CONSTRAINT acct_v7_pk PRIMARY KEY (agent_id, class_id, > mac_src, mac_dst, vlan, as_src, as_dst, ip_src, ip_dst, port_src, port_dst, > ip_proto, tos, stamp_inserted) > pmacct(# ); > ERROR: date/time field value out of range: "0000-01-01 00:00:00" > > *** End of the template - remove these lines *** > > > -- System Information: > Debian Release: 7.0 > APT prefers testing > APT policy: (500, 'testing') > Architecture: amd64 (x86_64) > > Kernel: Linux 3.2.0-4-amd64 (SMP w/1 CPU core) > Locale: LANG=en_GB, LC_CTYPE=en_GB (charmap=ISO-8859-1) > Shell: /bin/sh linked to /bin/bash > > Versions of packages pmacct depends on: > ii libc6 2.13-38 > ii libmysqlclient18 5.5.30+dfsg-1 > ii libpcap0.8 1.3.0-1 > ii libpq5 9.1.9-1 > ii libsqlite3-0 3.7.13-1 > ii net-tools 1.60-24.2 > ii psmisc 22.19-1+deb7u1 > ii zlib1g 1:1.2.7.dfsg-13 > > pmacct recommends no packages. > > pmacct suggests no packages. > > -- Configuration Files: > /etc/pmacct/pmacctd.conf changed [not included] > > -- no debconf information >