Output data from test scripts

diff --git a/test/t0001.errors b/test/t0001.errors
new file mode 100644 (file)
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 (file)
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 (file)
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 (file)
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 (file)
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 (file)
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 (file)
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 (file)
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 (file)
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 (file)
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 (file)
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 (file)
index 0000000..00a325f
--- /dev/null
+++ b/test/t0008.expect
@@ -0,0 +1,54 @@
+X-Powered-By: PHP/4.1.2\r
+Content-type: text/html\r
+\r
+<br>
+<b>Warning</b>:  PostgreSQL query failed:  ERROR:  parser: parse error at or near ""
+ in <b>/src/gnucomo/src/phpclasses/db.postgres.php</b> on line <b>79</b><br>
+Query error in ALTER TABLE log_adv_kernel_network DROP COLUMN hw_address
+<br>
+<b>Warning</b>:  PostgreSQL query failed:  ERROR:  ALTER TABLE: column name "hw_address" already exists in table "log_adv_kernel_network"
+ in <b>/src/gnucomo/src/phpclasses/db.postgres.php</b> on line <b>79</b><br>
+Query error in ALTER TABLE log_adv_kernel_network ADD COLUMN hw_address TEXT
+<br>
+<b>Warning</b>:  PostgreSQL query failed:  ERROR:  CREATE GROUP: group name "view" already exists
+ in <b>/src/gnucomo/src/phpclasses/db.postgres.php</b> on line <b>79</b><br>
+Query error in CREATE GROUP view
+<br>
+<b>Warning</b>:  PostgreSQL query failed:  ERROR:  CREATE GROUP: group name "ops" already exists
+ in <b>/src/gnucomo/src/phpclasses/db.postgres.php</b> on line <b>79</b><br>
+Query error in CREATE GROUP ops
+<br>
+<b>Warning</b>:  PostgreSQL query failed:  ERROR:  CREATE GROUP: group name "admin" already exists
+ in <b>/src/gnucomo/src/phpclasses/db.postgres.php</b> on line <b>79</b><br>
+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),