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 [email protected]
with a subject of "unsubscribe". Trouble? Contact [email protected]
