-psql:src/database/create.sql:419: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "object_abuse_pkey" for table "object_abuse"
-psql:src/database/create.sql:493: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "object_statistics_pkey" for table "object_statistics"
-psql:src/database/create.sql:529: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "parameter_pkey" for table "parameter"
-psql:src/database/create.sql:549: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "parameter_class_pkey" for table "parameter_class"
-psql:src/database/create.sql:578: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "parameter_notification_pkey" for table "parameter_notification"
-psql:src/database/create.sql:609: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "property_pkey" for table "property"
-psql:src/database/create.sql:657: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "service_pattern_pkey" for table "service_pattern"
+NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "object_abuse_pkey" for table "object_abuse"
+NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "object_statistics_pkey" for table "object_statistics"
+NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "parameter_pkey" for table "parameter"
+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 "parameter_notification_pkey" for table "parameter_notification"
+NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "property_pkey" for table "property"
+NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "service_pattern_pkey" for table "service_pattern"
cd ..
-if psql gnucomo_test -f src/database/create.sql -q >/dev/null
+if psql gnucomo_test -q <src/database/create.sql >/dev/null
then
psql gnucomo_test -c 'select statuscode from status'
result=$?
-psql:src/database/create.sql:419: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "object_abuse_pkey" for table "object_abuse"
-psql:src/database/create.sql:493: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "object_statistics_pkey" for table "object_statistics"
-psql:src/database/create.sql:529: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "parameter_pkey" for table "parameter"
-psql:src/database/create.sql:549: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "parameter_class_pkey" for table "parameter_class"
-psql:src/database/create.sql:578: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "parameter_notification_pkey" for table "parameter_notification"
-psql:src/database/create.sql:609: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "property_pkey" for table "property"
-psql:src/database/create.sql:657: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "service_pattern_pkey" for table "service_pattern"
+NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "object_abuse_pkey" for table "object_abuse"
+NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "object_statistics_pkey" for table "object_statistics"
+NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "parameter_pkey" for table "parameter"
+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 "parameter_notification_pkey" for table "parameter_notification"
+NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "property_pkey" for table "property"
+NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "service_pattern_pkey" for table "service_pattern"
cd ..
-if psql gnucomo_test -f src/database/create.sql -q >/dev/null
+if psql gnucomo_test -q <src/database/create.sql >/dev/null
then
psql gnucomo_test -q -c "insert into object (objectname) values ('kithira.andromeda.nl')"
psql gnucomo_test -c "select * from object"
-psql:src/database/create.sql:419: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "object_abuse_pkey" for table "object_abuse"
-psql:src/database/create.sql:493: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "object_statistics_pkey" for table "object_statistics"
-psql:src/database/create.sql:529: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "parameter_pkey" for table "parameter"
-psql:src/database/create.sql:549: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "parameter_class_pkey" for table "parameter_class"
-psql:src/database/create.sql:578: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "parameter_notification_pkey" for table "parameter_notification"
-psql:src/database/create.sql:609: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "property_pkey" for table "property"
-psql:src/database/create.sql:657: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "service_pattern_pkey" for table "service_pattern"
+NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "object_abuse_pkey" for table "object_abuse"
+NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "object_statistics_pkey" for table "object_statistics"
+NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "parameter_pkey" for table "parameter"
+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 "parameter_notification_pkey" for table "parameter_notification"
+NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "property_pkey" for table "property"
+NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "service_pattern_pkey" for table "service_pattern"
gcm_input WARNING: Not a valid line: nearly empty line
gcm_input WARNING: Not a valid line: Jun 5 04:02:16 vd
cd ..
-if psql gnucomo_test -f src/database/create.sql -q >/dev/null
+if psql gnucomo_test -q <src/database/create.sql >/dev/null
then
psql gnucomo_test -q -c "insert into object (objectname) values ('vd.wt.tno.nl')"
psql gnucomo_test -c "select * from object"
-psql:src/database/create.sql:419: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "object_abuse_pkey" for table "object_abuse"
-psql:src/database/create.sql:493: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "object_statistics_pkey" for table "object_statistics"
-psql:src/database/create.sql:529: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "parameter_pkey" for table "parameter"
-psql:src/database/create.sql:549: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "parameter_class_pkey" for table "parameter_class"
-psql:src/database/create.sql:578: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "parameter_notification_pkey" for table "parameter_notification"
-psql:src/database/create.sql:609: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "property_pkey" for table "property"
-psql:src/database/create.sql:657: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "service_pattern_pkey" for table "service_pattern"
+NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "object_abuse_pkey" for table "object_abuse"
+NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "object_statistics_pkey" for table "object_statistics"
+NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "parameter_pkey" for table "parameter"
+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 "parameter_notification_pkey" for table "parameter_notification"
+NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "property_pkey" for table "property"
+NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "service_pattern_pkey" for table "service_pattern"
Can not determine the hostname where the message came from.
cd ..
-if psql gnucomo_test -f src/database/create.sql -q >/dev/null
+if psql gnucomo_test -q <src/database/create.sql >/dev/null
then
psql gnucomo_test -q -c "insert into object (objectname) values ('kithira.andromeda.nl')"
psql gnucomo_test -c "select * from object"
-psql:src/database/create.sql:419: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "object_abuse_pkey" for table "object_abuse"
-psql:src/database/create.sql:493: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "object_statistics_pkey" for table "object_statistics"
-psql:src/database/create.sql:529: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "parameter_pkey" for table "parameter"
-psql:src/database/create.sql:549: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "parameter_class_pkey" for table "parameter_class"
-psql:src/database/create.sql:578: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "parameter_notification_pkey" for table "parameter_notification"
-psql:src/database/create.sql:609: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "property_pkey" for table "property"
-psql:src/database/create.sql:657: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "service_pattern_pkey" for table "service_pattern"
+NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "object_abuse_pkey" for table "object_abuse"
+NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "object_statistics_pkey" for table "object_statistics"
+NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "parameter_pkey" for table "parameter"
+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 "parameter_notification_pkey" for table "parameter_notification"
+NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "property_pkey" for table "property"
+NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "service_pattern_pkey" for table "service_pattern"
cd ..
-if psql gnucomo_test -f src/database/create.sql -q >/dev/null
+if psql gnucomo_test -q <src/database/create.sql >/dev/null
then
psql gnucomo_test -q -c "insert into object (objectname) values ('kithira.andromeda.nl')"
psql gnucomo_test -c "select * from object"
-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"
-psql:src/database/create.sql:419: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "object_abuse_pkey" for table "object_abuse"
-psql:src/database/create.sql:493: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "object_statistics_pkey" for table "object_statistics"
-psql:src/database/create.sql:529: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "parameter_pkey" for table "parameter"
-psql:src/database/create.sql:549: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "parameter_class_pkey" for table "parameter_class"
-psql:src/database/create.sql:578: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "parameter_notification_pkey" for table "parameter_notification"
-psql:src/database/create.sql:609: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "property_pkey" for table "property"
-psql:src/database/create.sql:657: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "service_pattern_pkey" for table "service_pattern"
+NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "parameter_pkey" for table "parameter"
+NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "property_pkey" for table "property"
+NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "object_abuse_pkey" for table "object_abuse"
+NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "object_statistics_pkey" for table "object_statistics"
+NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "parameter_pkey" for table "parameter"
+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 "parameter_notification_pkey" for table "parameter_notification"
+NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "property_pkey" for table "property"
+NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "service_pattern_pkey" for table "service_pattern"
cd ..
-if psql gnucomo_test -f test/create_v1.sql -q >/dev/null
+if psql gnucomo_test <test/create_v1.sql -q >/dev/null
then
src/gcm_daemon/gcm_daemon.php -c gnucomo_test
pg_dump gnucomo_test |grep -v '^--' | sort >test/dump.upgraded.sql
psql gnucomo_test -f src/database/destroy.sql -q
- psql gnucomo_test -f src/database/create.sql -q >/dev/null
+ psql gnucomo_test <src/database/create.sql -q >/dev/null
pg_dump gnucomo_test |grep -v '^--' | sort >test/dump.latest.sql
psql gnucomo_test -f src/database/destroy.sql -q
-psql:src/database/create.sql:419: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "object_abuse_pkey" for table "object_abuse"
-psql:src/database/create.sql:493: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "object_statistics_pkey" for table "object_statistics"
-psql:src/database/create.sql:529: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "parameter_pkey" for table "parameter"
-psql:src/database/create.sql:549: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "parameter_class_pkey" for table "parameter_class"
-psql:src/database/create.sql:578: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "parameter_notification_pkey" for table "parameter_notification"
-psql:src/database/create.sql:609: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "property_pkey" for table "property"
-psql:src/database/create.sql:657: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "service_pattern_pkey" for table "service_pattern"
+NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "object_abuse_pkey" for table "object_abuse"
+NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "object_statistics_pkey" for table "object_statistics"
+NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "parameter_pkey" for table "parameter"
+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 "parameter_notification_pkey" for table "parameter_notification"
+NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "property_pkey" for table "property"
+NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "service_pattern_pkey" for table "service_pattern"
gcm_input WARNING: Not a valid line: nearly empty line
gcm_input WARNING: Not a valid line: Jun 5 04:02:16 vd
cd ..
-if psql gnucomo_test -f src/database/create.sql -q >/dev/null
+if psql gnucomo_test -q <src/database/create.sql >/dev/null
then
# Prepare the database
-psql:src/database/create.sql:419: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "object_abuse_pkey" for table "object_abuse"
-psql:src/database/create.sql:493: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "object_statistics_pkey" for table "object_statistics"
-psql:src/database/create.sql:529: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "parameter_pkey" for table "parameter"
-psql:src/database/create.sql:549: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "parameter_class_pkey" for table "parameter_class"
-psql:src/database/create.sql:578: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "parameter_notification_pkey" for table "parameter_notification"
-psql:src/database/create.sql:609: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "property_pkey" for table "property"
-psql:src/database/create.sql:657: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "service_pattern_pkey" for table "service_pattern"
+NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "object_abuse_pkey" for table "object_abuse"
+NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "object_statistics_pkey" for table "object_statistics"
+NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "parameter_pkey" for table "parameter"
+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 "parameter_notification_pkey" for table "parameter_notification"
+NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "property_pkey" for table "property"
+NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "service_pattern_pkey" for table "service_pattern"
Content-type: text/html\r
X-Powered-By: PHP/4.3.4\r
\r
-NOQUEUE abuses:
-
-SPAM abuses:
-
-203.67.201.40 is new.
-193.217.1.16 is new.
-4.65.63.46 is new.
-212.204.216.11 is new.
-212.204.216.11 will get 2 abuse points, Status was
-HTTP abuses:
-
-Mailing Notification for object id 1
+Processing logs...
+Last processed logid = 0
+Running service check from log id 0.
Gathering statistics for object 1
notificationid | objectid | type_of_issueid
----------------+----------+-----------------
- 1 | 1 | 6
-(1 row)
+ 1 | 1 | 8
+ 2 | 1 | 10
+ 3 | 1 | 11
+ 4 | 1 | 6
+(4 rows)
cd ..
-if psql gnucomo_test -f src/database/create.sql -q >/dev/null
+if psql gnucomo_test -q <src/database/create.sql >/dev/null
then
# Prepare the database
-psql:src/database/create.sql:419: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "object_abuse_pkey" for table "object_abuse"
-psql:src/database/create.sql:493: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "object_statistics_pkey" for table "object_statistics"
-psql:src/database/create.sql:529: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "parameter_pkey" for table "parameter"
-psql:src/database/create.sql:549: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "parameter_class_pkey" for table "parameter_class"
-psql:src/database/create.sql:578: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "parameter_notification_pkey" for table "parameter_notification"
-psql:src/database/create.sql:609: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "property_pkey" for table "property"
-psql:src/database/create.sql:657: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "service_pattern_pkey" for table "service_pattern"
+NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "object_abuse_pkey" for table "object_abuse"
+NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "object_statistics_pkey" for table "object_statistics"
+NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "parameter_pkey" for table "parameter"
+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 "parameter_notification_pkey" for table "parameter_notification"
+NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "property_pkey" for table "property"
+NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "service_pattern_pkey" for table "service_pattern"
cd ..
-if psql gnucomo_test -f src/database/create.sql -q >/dev/null
+if psql gnucomo_test -q <src/database/create.sql >/dev/null
then
psql gnucomo_test -q -c "insert into object (objectname) values ('vd.wt.tno.nl')"
psql gnucomo_test -c "select * from object"