From: arjen Date: Wed, 3 Sep 2003 13:46:29 +0000 (+0000) Subject: Output data from test scripts X-Git-Tag: V0_0_8~5 X-Git-Url: http://www.andromeda.nl/gitweb/?p=gnucomo.git;a=commitdiff_plain;h=62e87535e4e3bcfb1fadc6737de43af8993f0640 Output data from test scripts --- diff --git a/test/t0001.errors b/test/t0001.errors new file mode 100644 index 0000000..89867e7 --- /dev/null +++ b/test/t0001.errors @@ -0,0 +1,12 @@ +psql:src/database/create.sql:555: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index 'object_statistics_pkey' for table 'object_statistics' +psql:src/database/create.sql:591: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index 'parameter_pkey' for table 'parameter' +psql:src/database/create.sql:611: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index 'parameter_class_pkey' for table 'parameter_class' +psql:src/database/create.sql:625: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index 'parameter_notification_pkey' for table 'parameter_notification' +psql:src/database/create.sql:656: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index 'property_pkey' for table 'property' +psql:src/database/create.sql:794: ERROR: CREATE GROUP: group name "view" already exists +psql:src/database/create.sql:795: ERROR: CREATE GROUP: group name "ops" already exists +psql:src/database/create.sql:796: ERROR: CREATE GROUP: group name "admin" already exists +psql:src/database/destroy.sql:67: ERROR: table "object_system_user" does not exist +psql:src/database/destroy.sql:92: ERROR: sequence "unprocessed_l_unprocessedid_seq" does not exist +psql:src/database/destroy.sql:94: ERROR: table "unprocessed_log" does not exist +psql:src/database/destroy.sql:96: ERROR: table "user_gnucomo" does not exist diff --git a/test/t0001.expect b/test/t0001.expect new file mode 100644 index 0000000..7ae921f --- /dev/null +++ b/test/t0001.expect @@ -0,0 +1,11 @@ + statuscode +------------ + new + opn + pen + ver + rej + cls + inv +(7 rows) + diff --git a/test/t0002a.errors b/test/t0002a.errors new file mode 100644 index 0000000..89867e7 --- /dev/null +++ b/test/t0002a.errors @@ -0,0 +1,12 @@ +psql:src/database/create.sql:555: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index 'object_statistics_pkey' for table 'object_statistics' +psql:src/database/create.sql:591: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index 'parameter_pkey' for table 'parameter' +psql:src/database/create.sql:611: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index 'parameter_class_pkey' for table 'parameter_class' +psql:src/database/create.sql:625: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index 'parameter_notification_pkey' for table 'parameter_notification' +psql:src/database/create.sql:656: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index 'property_pkey' for table 'property' +psql:src/database/create.sql:794: ERROR: CREATE GROUP: group name "view" already exists +psql:src/database/create.sql:795: ERROR: CREATE GROUP: group name "ops" already exists +psql:src/database/create.sql:796: ERROR: CREATE GROUP: group name "admin" already exists +psql:src/database/destroy.sql:67: ERROR: table "object_system_user" does not exist +psql:src/database/destroy.sql:92: ERROR: sequence "unprocessed_l_unprocessedid_seq" does not exist +psql:src/database/destroy.sql:94: ERROR: table "unprocessed_log" does not exist +psql:src/database/destroy.sql:96: ERROR: table "user_gnucomo" does not exist diff --git a/test/t0002a.expect b/test/t0002a.expect new file mode 100644 index 0000000..c1d233c --- /dev/null +++ b/test/t0002a.expect @@ -0,0 +1,37 @@ + objectid | objectname | objectcode | scp_enabled | scp_inet | mail_enabled | mail_from | sms_enabled | sms_number | fax_enabled | fax_number | object_description | object_owner | physical_location | timezone | remark | os | os_version | log_count | notification_count | parameter_count +----------+----------------------+------------+-------------+----------+--------------+-----------+-------------+------------+-------------+------------+--------------------+--------------+-------------------+----------+--------+----+------------+-----------+--------------------+----------------- + 1 | kithira.andromeda.nl | | | | | | | | | | | | | | | | | | | +(1 row) + + logid | objectid | original_filename | servicecode | object_timestamp | timestamp | rawdata | processed | recognized +-------+----------+-------------------+-------------+------------------------+------------------------+---------------------------------------------------------------------------------------------------------+-----------+------------ + 1 | 1 | | syslogd | 2002-09-01 04:02:51+02 | 2002-09-05 20:30:45+02 | Sep 1 04:02:51 kithira syslogd 1.4.1: restart. | f | f + 2 | 1 | | CROND | 2002-09-01 04:10:00+02 | 2002-09-05 20:30:45+02 | Sep 1 04:10:00 kithira CROND[17405]: (root) CMD ( /sbin/lsmod >/var/log/lsmod.log; /sbin/rmmod -as) | f | f + 3 | 1 | | kernel | 2002-09-01 04:11:07+02 | 2002-09-05 20:30:45+02 | Sep 1 04:11:07 kithira kernel: isdn_net: local hangup ippp0 | f | f + 4 | 1 | | kernel | 2002-09-01 04:11:07+02 | 2002-09-05 20:30:45+02 | Sep 1 04:11:07 kithira kernel: ippp0: Chargesum is 0 | f | f + 5 | 1 | | ipppd | 2002-09-01 04:11:07+02 | 2002-09-05 20:30:45+02 | Sep 1 04:11:07 kithira ipppd[1513]: Modem hangup | f | f + 6 | 1 | | ipppd | 2002-09-01 04:11:07+02 | 2002-09-05 20:30:45+02 | Sep 1 04:11:07 kithira ipppd[1513]: Connection terminated. | f | f + 7 | 1 | | ipppd | 2002-09-01 04:11:07+02 | 2002-09-05 20:30:45+02 | Sep 1 04:11:07 kithira ipppd[1513]: taking down PHASE_DEAD link 0, linkunit: 0 | f | f + 8 | 1 | | ipppd | 2002-09-01 04:11:07+02 | 2002-09-05 20:30:45+02 | Sep 1 04:11:07 kithira ipppd[1513]: closing fd 7 from unit 0 | f | f + 9 | 1 | | ipppd | 2002-09-01 04:11:07+02 | 2002-09-05 20:30:45+02 | Sep 1 04:11:07 kithira ipppd[1513]: link 0 closed , linkunit: 0 | f | f + 10 | 1 | | ipppd | 2002-09-01 04:11:07+02 | 2002-09-05 20:30:45+02 | Sep 1 04:11:07 kithira ipppd[1513]: reinit_unit: 0 | f | f + 11 | 1 | | ipppd | 2002-09-01 04:11:07+02 | 2002-09-05 20:30:45+02 | Sep 1 04:11:07 kithira ipppd[1513]: Connect[0]: /dev/ippp0, fd: 7 | f | f + 12 | 1 | | CROND | 2002-09-01 04:15:00+02 | 2002-09-05 20:30:45+02 | Sep 1 04:15:00 kithira CROND[17423]: (uucp) CMD (/usr/sbin/uucico -r1) | f | f + 13 | 1 | | CROND | 2002-09-01 04:20:00+02 | 2002-09-05 20:30:45+02 | Sep 1 04:20:00 kithira CROND[17581]: (root) CMD ( /sbin/lsmod >/var/log/lsmod.log; /sbin/rmmod -as) | f | f + 14 | 1 | | kernel | 2002-09-01 04:20:00+02 | 2002-09-05 20:30:45+02 | Sep 1 04:20:00 kithira kernel: solo1: unloading | f | f + 15 | 1 | | kernel | 2002-09-01 04:20:00+02 | 2002-09-05 20:30:45+02 | Sep 1 04:20:00 kithira kernel: Uniform CD-ROM driver unloaded | f | f + 16 | 1 | | kernel | 2002-09-01 04:20:01+02 | 2002-09-05 20:30:45+02 | Sep 1 04:20:01 kithira kernel: ide-floppy driver 0.99.newide | f | f + 17 | 1 | | kernel | 2002-09-01 04:20:02+02 | 2002-09-05 20:30:45+02 | Sep 1 04:20:02 kithira kernel: hdb: ATAPI 40X CD-ROM drive, 128kB Cache, DMA | f | f + 18 | 1 | | kernel | 2002-09-01 04:20:02+02 | 2002-09-05 20:30:45+02 | Sep 1 04:20:02 kithira kernel: Uniform CD-ROM driver Revision: 3.12 | f | f + 19 | 1 | | kernel | 2002-09-01 04:20:02+02 | 2002-09-05 20:30:45+02 | Sep 1 04:20:02 kithira kernel: Attached scsi CD-ROM sr0 at scsi0, channel 0, id 4, lun 0 | f | f + 20 | 1 | | kernel | 2002-09-01 04:20:02+02 | 2002-09-05 20:30:45+02 | Sep 1 04:20:02 kithira kernel: sr0: scsi3-mmc drive: 20x/20x writer cd/rw xa/form2 cdda tray | f | f + 21 | 1 | | CROND | 2002-09-01 04:22:00+02 | 2002-09-05 20:30:45+02 | Sep 1 04:22:00 kithira CROND[17587]: (root) CMD (run-parts /etc/cron.weekly) | f | f + 22 | 1 | | anacron | 2002-09-01 04:22:00+02 | 2002-09-05 20:30:45+02 | Sep 1 04:22:00 kithira anacron[17591]: Error opening /etc/anacrontab: No such file or directory | f | f + 23 | 1 | | anacron | 2002-09-01 04:22:00+02 | 2002-09-05 20:30:45+02 | Sep 1 04:22:00 kithira anacron[17591]: Aborted | f | f + 24 | 1 | | CROND | 2002-09-01 04:30:00+02 | 2002-09-05 20:30:45+02 | Sep 1 04:30:00 kithira CROND[27975]: (root) CMD ( /sbin/lsmod >/var/log/lsmod.log; /sbin/rmmod -as) | f | f + 25 | 1 | | su | 2002-09-01 04:30:51+02 | 2002-09-05 20:30:45+02 | Sep 1 04:30:51 kithira su(pam_unix)[27979]: session opened for user news by (uid=0) | f | f + 26 | 1 | | su | 2002-09-01 04:30:51+02 | 2002-09-05 20:30:45+02 | Sep 1 04:30:51 kithira su(pam_unix)[27979]: session closed for user news | f | f + 27 | 1 | | named | 2002-09-01 04:31:03+02 | 2002-09-05 20:30:45+02 | Sep 1 04:31:03 kithira named[996]: listening on IPv4 interface ippp0, 195.121.198.124#53 | f | f + 28 | 1 | | named | 2002-09-01 04:31:03+02 | 2002-09-05 20:30:45+02 | Sep 1 04:31:03 kithira named[996]: no longer listening on 195.121.198.217#53 | f | f +(28 rows) + diff --git a/test/t0003.errors b/test/t0003.errors new file mode 100644 index 0000000..a52c6a4 --- /dev/null +++ b/test/t0003.errors @@ -0,0 +1,15 @@ +psql:src/database/create.sql:555: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index 'object_statistics_pkey' for table 'object_statistics' +psql:src/database/create.sql:591: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index 'parameter_pkey' for table 'parameter' +psql:src/database/create.sql:611: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index 'parameter_class_pkey' for table 'parameter_class' +psql:src/database/create.sql:625: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index 'parameter_notification_pkey' for table 'parameter_notification' +psql:src/database/create.sql:656: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index 'property_pkey' for table 'property' +psql:src/database/create.sql:794: ERROR: CREATE GROUP: group name "view" already exists +psql:src/database/create.sql:795: ERROR: CREATE GROUP: group name "ops" already exists +psql:src/database/create.sql:796: ERROR: CREATE GROUP: group name "admin" already exists +gcm_input WARNING: Not a valid line: nearly empty line +gcm_input WARNING: Not a valid line: Jun 5 04:02:16 vd +gcm_input WARNING: Not a valid line: +psql:src/database/destroy.sql:67: ERROR: table "object_system_user" does not exist +psql:src/database/destroy.sql:92: ERROR: sequence "unprocessed_l_unprocessedid_seq" does not exist +psql:src/database/destroy.sql:94: ERROR: table "unprocessed_log" does not exist +psql:src/database/destroy.sql:96: ERROR: table "user_gnucomo" does not exist diff --git a/test/t0003.expect b/test/t0003.expect new file mode 100644 index 0000000..963611c --- /dev/null +++ b/test/t0003.expect @@ -0,0 +1,36 @@ + objectid | objectname | objectcode | scp_enabled | scp_inet | mail_enabled | mail_from | sms_enabled | sms_number | fax_enabled | fax_number | object_description | object_owner | physical_location | timezone | remark | os | os_version | log_count | notification_count | parameter_count +----------+--------------+------------+-------------+----------+--------------+-----------+-------------+------------+-------------+------------+--------------------+--------------+-------------------+----------+--------+----+------------+-----------+--------------------+----------------- + 1 | vd.wt.tno.nl | | | | | | | | | | | | | | | | | | | +(1 row) + + logid | objectid | original_filename | servicecode | object_timestamp | timestamp | rawdata | processed | recognized +-------+----------+-------------------+-------------+------------------------+------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------+-----------+------------ + 1 | 1 | | syslogd | 2002-06-02 04:02:17+02 | 2002-09-05 20:30:45+02 | Jun 2 04:02:17 vd syslogd 1.4.1: restart. | f | f + 2 | 1 | | syslogd | 2002-06-03 04:02:03+02 | 2002-09-05 20:30:45+02 | Jun 3 04:02:03 vd syslogd 1.4.1: restart. | f | f + 3 | 1 | | syslogd | 2002-06-04 04:02:08+02 | 2002-09-05 20:30:45+02 | Jun 4 04:02:08 vd syslogd 1.4.1: restart. | f | f + 4 | 1 | | sshd | 2002-06-04 08:30:28+02 | 2002-09-05 20:30:45+02 | Jun 4 08:30:28 vd sshd(pam_unix)[9380]: session opened for user ebusp by (uid=0) | f | f + 5 | 1 | | sshd | 2002-06-04 08:32:57+02 | 2002-09-05 20:30:45+02 | Jun 4 08:32:57 vd sshd(pam_unix)[9380]: session closed for user ebusp | f | f + 6 | 1 | | sshd | 2002-06-04 12:39:58+02 | 2002-09-05 20:30:45+02 | Jun 4 12:39:58 vd sshd(pam_unix)[9644]: session opened for user victorsd by (uid=0) | f | f + 7 | 1 | | sshd | 2002-06-04 12:43:39+02 | 2002-09-05 20:30:45+02 | Jun 4 12:43:39 vd sshd(pam_unix)[9689]: session opened for user victorsd by (uid=0) | f | f + 8 | 1 | | sshd | 2002-06-04 12:44:51+02 | 2002-09-05 20:30:45+02 | Jun 4 12:44:51 vd sshd(pam_unix)[9689]: session closed for user victorsd | f | f + 9 | 1 | | sshd | 2002-06-04 12:45:47+02 | 2002-09-05 20:30:45+02 | Jun 4 12:45:47 vd sshd(pam_unix)[9722]: session opened for user victorsd by (uid=0) | f | f + 10 | 1 | | sshd | 2002-06-04 12:58:26+02 | 2002-09-05 20:30:45+02 | Jun 4 12:58:26 vd sshd(pam_unix)[9722]: session closed for user victorsd | f | f + 11 | 1 | | sshd | 2002-06-04 14:09:04+02 | 2002-09-05 20:30:45+02 | Jun 4 14:09:04 vd sshd(pam_unix)[9874]: authentication failure; logname= uid=0 euid=0 tty=NODEVssh ruser= rhost=wt4050.wt.tno.nl user=victorsd | f | f + 12 | 1 | | sshd | 2002-06-04 14:09:10+02 | 2002-09-05 20:30:45+02 | Jun 4 14:09:10 vd sshd(pam_unix)[9874]: session opened for user victorsd by (uid=0) | f | f + 13 | 1 | | sshd | 2002-06-04 14:25:08+02 | 2002-09-05 20:30:45+02 | Jun 4 14:25:08 vd sshd(pam_unix)[9644]: session closed for user victorsd | f | f + 14 | 1 | | sshd | 2002-06-04 15:10:25+02 | 2002-09-05 20:30:45+02 | Jun 4 15:10:25 vd sshd(pam_unix)[9874]: session closed for user victorsd | f | f + 15 | 1 | | sshd | 2002-06-04 16:40:52+02 | 2002-09-05 20:30:45+02 | Jun 4 16:40:52 vd sshd(pam_unix)[10056]: session opened for user arjen by (uid=0) | f | f + 16 | 1 | | sshd | 2002-06-04 16:40:53+02 | 2002-09-05 20:30:45+02 | Jun 4 16:40:53 vd sshd(pam_unix)[10056]: session closed for user arjen | f | f + 17 | 1 | | sshd | 2002-06-04 16:41:04+02 | 2002-09-05 20:30:45+02 | Jun 4 16:41:04 vd sshd(pam_unix)[10058]: session opened for user arjen by (uid=0) | f | f + 18 | 1 | | su | 2002-06-04 16:42:01+02 | 2002-09-05 20:30:45+02 | Jun 4 16:42:01 vd su(pam_unix)[10090]: session opened for user root by arjen(uid=504) | f | f + 19 | 1 | | su | 2002-06-04 16:42:42+02 | 2002-09-05 20:30:45+02 | Jun 4 16:42:42 vd su(pam_unix)[10090]: session closed for user root | f | f + 20 | 1 | | sshd | 2002-06-04 16:42:44+02 | 2002-09-05 20:30:45+02 | Jun 4 16:42:44 vd sshd(pam_unix)[10058]: session closed for user arjen | f | f + 21 | 1 | | syslogd | 2002-06-06 04:02:05+02 | 2002-09-05 20:30:45+02 | Jun 6 04:02:05 vd syslogd 1.4.1: restart. | f | f + 22 | 1 | | sshd | 2002-06-06 09:22:44+02 | 2002-09-05 20:30:45+02 | Jun 6 09:22:44 vd sshd(pam_unix)[13090]: session opened for user ebusp by (uid=0) | f | f + 23 | 1 | | sshd | 2002-06-06 09:25:32+02 | 2002-09-05 20:30:45+02 | Jun 6 09:25:32 vd sshd(pam_unix)[13090]: session closed for user ebusp | f | f + 24 | 1 | | sshd | 2002-06-06 11:20:31+02 | 2002-09-05 20:30:45+02 | Jun 6 11:20:31 vd sshd(pam_unix)[13242]: session opened for user verhoeff by (uid=0) | f | f + 25 | 1 | | sshd | 2002-06-06 11:26:09+02 | 2002-09-05 20:30:45+02 | Jun 6 11:26:09 vd sshd(pam_unix)[13242]: session closed for user verhoeff | f | f + 26 | 1 | | syslogd | 2002-06-07 04:02:08+02 | 2002-09-05 20:30:45+02 | Jun 7 04:02:08 vd syslogd 1.4.1: restart. | f | f + 27 | 1 | | syslogd | 2002-06-08 04:02:09+02 | 2002-09-05 20:30:45+02 | Jun 8 04:02:09 vd syslogd 1.4.1: restart. | f | f +(27 rows) + diff --git a/test/t0004.errors b/test/t0004.errors new file mode 100644 index 0000000..9511562 --- /dev/null +++ b/test/t0004.errors @@ -0,0 +1,13 @@ +psql:src/database/create.sql:555: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index 'object_statistics_pkey' for table 'object_statistics' +psql:src/database/create.sql:591: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index 'parameter_pkey' for table 'parameter' +psql:src/database/create.sql:611: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index 'parameter_class_pkey' for table 'parameter_class' +psql:src/database/create.sql:625: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index 'parameter_notification_pkey' for table 'parameter_notification' +psql:src/database/create.sql:656: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index 'property_pkey' for table 'property' +psql:src/database/create.sql:794: ERROR: CREATE GROUP: group name "view" already exists +psql:src/database/create.sql:795: ERROR: CREATE GROUP: group name "ops" already exists +psql:src/database/create.sql:796: ERROR: CREATE GROUP: group name "admin" already exists +Can not determine the hostname where the message came from. +psql:src/database/destroy.sql:67: ERROR: table "object_system_user" does not exist +psql:src/database/destroy.sql:92: ERROR: sequence "unprocessed_l_unprocessedid_seq" does not exist +psql:src/database/destroy.sql:94: ERROR: table "unprocessed_log" does not exist +psql:src/database/destroy.sql:96: ERROR: table "user_gnucomo" does not exist diff --git a/test/t0004.expect b/test/t0004.expect new file mode 100644 index 0000000..23fe66f --- /dev/null +++ b/test/t0004.expect @@ -0,0 +1,9 @@ + objectid | objectname | objectcode | scp_enabled | scp_inet | mail_enabled | mail_from | sms_enabled | sms_number | fax_enabled | fax_number | object_description | object_owner | physical_location | timezone | remark | os | os_version | log_count | notification_count | parameter_count +----------+----------------------+------------+-------------+----------+--------------+-----------+-------------+------------+-------------+------------+--------------------+--------------+-------------------+----------+--------+----+------------+-----------+--------------------+----------------- + 1 | kithira.andromeda.nl | | | | | | | | | | | | | | | | | | | +(1 row) + + logid | objectid | original_filename | servicecode | object_timestamp | timestamp | rawdata | processed | recognized +-------+----------+-------------------+-------------+------------------+-----------+---------+-----------+------------ +(0 rows) + diff --git a/test/t0005.errors b/test/t0005.errors new file mode 100644 index 0000000..89867e7 --- /dev/null +++ b/test/t0005.errors @@ -0,0 +1,12 @@ +psql:src/database/create.sql:555: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index 'object_statistics_pkey' for table 'object_statistics' +psql:src/database/create.sql:591: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index 'parameter_pkey' for table 'parameter' +psql:src/database/create.sql:611: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index 'parameter_class_pkey' for table 'parameter_class' +psql:src/database/create.sql:625: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index 'parameter_notification_pkey' for table 'parameter_notification' +psql:src/database/create.sql:656: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index 'property_pkey' for table 'property' +psql:src/database/create.sql:794: ERROR: CREATE GROUP: group name "view" already exists +psql:src/database/create.sql:795: ERROR: CREATE GROUP: group name "ops" already exists +psql:src/database/create.sql:796: ERROR: CREATE GROUP: group name "admin" already exists +psql:src/database/destroy.sql:67: ERROR: table "object_system_user" does not exist +psql:src/database/destroy.sql:92: ERROR: sequence "unprocessed_l_unprocessedid_seq" does not exist +psql:src/database/destroy.sql:94: ERROR: table "unprocessed_log" does not exist +psql:src/database/destroy.sql:96: ERROR: table "user_gnucomo" does not exist diff --git a/test/t0005.expect b/test/t0005.expect new file mode 100644 index 0000000..ed503f5 --- /dev/null +++ b/test/t0005.expect @@ -0,0 +1,37 @@ + objectid | objectname | objectcode | scp_enabled | scp_inet | mail_enabled | mail_from | sms_enabled | sms_number | fax_enabled | fax_number | object_description | object_owner | physical_location | timezone | remark | os | os_version | log_count | notification_count | parameter_count +----------+----------------------+------------+-------------+----------+--------------+-----------+-------------+------------+-------------+------------+--------------------+--------------+-------------------+----------+--------+----+------------+-----------+--------------------+----------------- + 1 | kithira.andromeda.nl | | | | | | | | | | | | | | | | | | | +(1 row) + + logid | objectid | original_filename | servicecode | object_timestamp | timestamp | rawdata | processed | recognized +-------+----------+-------------------+-------------+------------------------+------------------------+---------------------------------------------------------------------------------------------------------+-----------+------------ + 1 | 1 | | syslogd | 2002-09-01 04:02:51+02 | 2002-09-05 00:00:00+02 | Sep 1 04:02:51 kithira syslogd 1.4.1: restart. | f | f + 2 | 1 | | CROND | 2002-09-01 04:10:00+02 | 2002-09-05 00:00:00+02 | Sep 1 04:10:00 kithira CROND[17405]: (root) CMD ( /sbin/lsmod >/var/log/lsmod.log; /sbin/rmmod -as) | f | f + 3 | 1 | | kernel | 2002-09-01 04:11:07+02 | 2002-09-05 00:00:00+02 | Sep 1 04:11:07 kithira kernel: isdn_net: local hangup ippp0 | f | f + 4 | 1 | | kernel | 2002-09-01 04:11:07+02 | 2002-09-05 00:00:00+02 | Sep 1 04:11:07 kithira kernel: ippp0: Chargesum is 0 | f | f + 5 | 1 | | ipppd | 2002-09-01 04:11:07+02 | 2002-09-05 00:00:00+02 | Sep 1 04:11:07 kithira ipppd[1513]: Modem hangup | f | f + 6 | 1 | | ipppd | 2002-09-01 04:11:07+02 | 2002-09-05 00:00:00+02 | Sep 1 04:11:07 kithira ipppd[1513]: Connection terminated. | f | f + 7 | 1 | | ipppd | 2002-09-01 04:11:07+02 | 2002-09-05 00:00:00+02 | Sep 1 04:11:07 kithira ipppd[1513]: taking down PHASE_DEAD link 0, linkunit: 0 | f | f + 8 | 1 | | ipppd | 2002-09-01 04:11:07+02 | 2002-09-05 00:00:00+02 | Sep 1 04:11:07 kithira ipppd[1513]: closing fd 7 from unit 0 | f | f + 9 | 1 | | ipppd | 2002-09-01 04:11:07+02 | 2002-09-05 00:00:00+02 | Sep 1 04:11:07 kithira ipppd[1513]: link 0 closed , linkunit: 0 | f | f + 10 | 1 | | ipppd | 2002-09-01 04:11:07+02 | 2002-09-05 00:00:00+02 | Sep 1 04:11:07 kithira ipppd[1513]: reinit_unit: 0 | f | f + 11 | 1 | | ipppd | 2002-09-01 04:11:07+02 | 2002-09-05 00:00:00+02 | Sep 1 04:11:07 kithira ipppd[1513]: Connect[0]: /dev/ippp0, fd: 7 | f | f + 12 | 1 | | CROND | 2002-09-01 04:15:00+02 | 2002-09-05 00:00:00+02 | Sep 1 04:15:00 kithira CROND[17423]: (uucp) CMD (/usr/sbin/uucico -r1) | f | f + 13 | 1 | | CROND | 2002-09-01 04:20:00+02 | 2002-09-05 00:00:00+02 | Sep 1 04:20:00 kithira CROND[17581]: (root) CMD ( /sbin/lsmod >/var/log/lsmod.log; /sbin/rmmod -as) | f | f + 14 | 1 | | kernel | 2002-09-01 04:20:00+02 | 2002-09-05 00:00:00+02 | Sep 1 04:20:00 kithira kernel: solo1: unloading | f | f + 15 | 1 | | kernel | 2002-09-01 04:20:00+02 | 2002-09-05 00:00:00+02 | Sep 1 04:20:00 kithira kernel: Uniform CD-ROM driver unloaded | f | f + 16 | 1 | | kernel | 2002-09-01 04:20:01+02 | 2002-09-05 00:00:00+02 | Sep 1 04:20:01 kithira kernel: ide-floppy driver 0.99.newide | f | f + 17 | 1 | | kernel | 2002-09-01 04:20:02+02 | 2002-09-05 00:00:00+02 | Sep 1 04:20:02 kithira kernel: hdb: ATAPI 40X CD-ROM drive, 128kB Cache, DMA | f | f + 18 | 1 | | kernel | 2002-09-01 04:20:02+02 | 2002-09-05 00:00:00+02 | Sep 1 04:20:02 kithira kernel: Uniform CD-ROM driver Revision: 3.12 | f | f + 19 | 1 | | kernel | 2002-09-01 04:20:02+02 | 2002-09-05 00:00:00+02 | Sep 1 04:20:02 kithira kernel: Attached scsi CD-ROM sr0 at scsi0, channel 0, id 4, lun 0 | f | f + 20 | 1 | | kernel | 2002-09-01 04:20:02+02 | 2002-09-05 00:00:00+02 | Sep 1 04:20:02 kithira kernel: sr0: scsi3-mmc drive: 20x/20x writer cd/rw xa/form2 cdda tray | f | f + 21 | 1 | | CROND | 2002-09-01 04:22:00+02 | 2002-09-05 00:00:00+02 | Sep 1 04:22:00 kithira CROND[17587]: (root) CMD (run-parts /etc/cron.weekly) | f | f + 22 | 1 | | anacron | 2002-09-01 04:22:00+02 | 2002-09-05 00:00:00+02 | Sep 1 04:22:00 kithira anacron[17591]: Error opening /etc/anacrontab: No such file or directory | f | f + 23 | 1 | | anacron | 2002-09-01 04:22:00+02 | 2002-09-05 00:00:00+02 | Sep 1 04:22:00 kithira anacron[17591]: Aborted | f | f + 24 | 1 | | CROND | 2002-09-01 04:30:00+02 | 2002-09-05 00:00:00+02 | Sep 1 04:30:00 kithira CROND[27975]: (root) CMD ( /sbin/lsmod >/var/log/lsmod.log; /sbin/rmmod -as) | f | f + 25 | 1 | | su | 2002-09-01 04:30:51+02 | 2002-09-05 00:00:00+02 | Sep 1 04:30:51 kithira su(pam_unix)[27979]: session opened for user news by (uid=0) | f | f + 26 | 1 | | su | 2002-09-01 04:30:51+02 | 2002-09-05 00:00:00+02 | Sep 1 04:30:51 kithira su(pam_unix)[27979]: session closed for user news | f | f + 27 | 1 | | named | 2002-09-01 04:31:03+02 | 2002-09-05 00:00:00+02 | Sep 1 04:31:03 kithira named[996]: listening on IPv4 interface ippp0, 195.121.198.124#53 | f | f + 28 | 1 | | named | 2002-09-01 04:31:03+02 | 2002-09-05 00:00:00+02 | Sep 1 04:31:03 kithira named[996]: no longer listening on 195.121.198.217#53 | f | f +(28 rows) + diff --git a/test/t0008.errors b/test/t0008.errors new file mode 100644 index 0000000..3d1b7c5 --- /dev/null +++ b/test/t0008.errors @@ -0,0 +1,24 @@ +psql:test/create_v1.sql:382: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index 'parameter_pkey' for table 'parameter' +psql:test/create_v1.sql:417: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index 'property_pkey' for table 'property' +NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index 'parameter_notification_pkey' for table 'parameter_notification' + +NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index 'parameter_class_pkey' for table 'parameter_class' + +NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index 'object_statistics_pkey' for table 'object_statistics' + +psql:src/database/destroy.sql:67: ERROR: table "object_system_user" does not exist +psql:src/database/destroy.sql:92: ERROR: sequence "unprocessed_l_unprocessedid_seq" does not exist +psql:src/database/destroy.sql:94: ERROR: table "unprocessed_log" does not exist +psql:src/database/destroy.sql:96: ERROR: table "user_gnucomo" does not exist +psql:src/database/create.sql:555: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index 'object_statistics_pkey' for table 'object_statistics' +psql:src/database/create.sql:591: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index 'parameter_pkey' for table 'parameter' +psql:src/database/create.sql:611: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index 'parameter_class_pkey' for table 'parameter_class' +psql:src/database/create.sql:625: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index 'parameter_notification_pkey' for table 'parameter_notification' +psql:src/database/create.sql:656: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index 'property_pkey' for table 'property' +psql:src/database/create.sql:794: ERROR: CREATE GROUP: group name "view" already exists +psql:src/database/create.sql:795: ERROR: CREATE GROUP: group name "ops" already exists +psql:src/database/create.sql:796: ERROR: CREATE GROUP: group name "admin" already exists +psql:src/database/destroy.sql:67: ERROR: table "object_system_user" does not exist +psql:src/database/destroy.sql:92: ERROR: sequence "unprocessed_l_unprocessedid_seq" does not exist +psql:src/database/destroy.sql:94: ERROR: table "unprocessed_log" does not exist +psql:src/database/destroy.sql:96: ERROR: table "user_gnucomo" does not exist diff --git a/test/t0008.expect b/test/t0008.expect new file mode 100644 index 0000000..00a325f --- /dev/null +++ b/test/t0008.expect @@ -0,0 +1,54 @@ +X-Powered-By: PHP/4.1.2 +Content-type: text/html + +
+Warning: PostgreSQL query failed: ERROR: parser: parse error at or near "" + in /src/gnucomo/src/phpclasses/db.postgres.php on line 79
+Query error in ALTER TABLE log_adv_kernel_network DROP COLUMN hw_address +
+Warning: PostgreSQL query failed: ERROR: ALTER TABLE: column name "hw_address" already exists in table "log_adv_kernel_network" + in /src/gnucomo/src/phpclasses/db.postgres.php on line 79
+Query error in ALTER TABLE log_adv_kernel_network ADD COLUMN hw_address TEXT +
+Warning: PostgreSQL query failed: ERROR: CREATE GROUP: group name "view" already exists + in /src/gnucomo/src/phpclasses/db.postgres.php on line 79
+Query error in CREATE GROUP view +
+Warning: PostgreSQL query failed: ERROR: CREATE GROUP: group name "ops" already exists + in /src/gnucomo/src/phpclasses/db.postgres.php on line 79
+Query error in CREATE GROUP ops +
+Warning: PostgreSQL query failed: ERROR: CREATE GROUP: group name "admin" already exists + in /src/gnucomo/src/phpclasses/db.postgres.php on line 79
+Query error in CREATE GROUP admin + +679,681c679,681 +< "detailed_table" text +< "device_in" text, +< "device_out" text, +--- +> "detailed_table" character varying(75) +> "device_in" character varying(15), +> "device_out" character varying(15), +802c802 +< "hw_address" text, +--- +> "hw_address" macaddr, +826a827 +> log_servicecheck 0 +886c887 +< "prec_bit" text, +--- +> "prec_bit" character varying(5), +894c895 +< "protocol" text, +--- +> "protocol" character varying(5), +907c908 +< "res" text, +--- +> "res" character varying(5), +997c998 +< "tos_bit" text, +--- +> "tos_bit" character varying(5),