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 -- To UNSUBSCRIBE, email to debian-bugs-dist-requ...@lists.debian.org with a subject of "unsubscribe". Trouble? Contact listmas...@lists.debian.org