4 # Test the log processing of gcm_daemon
5 # Create a database with one object and read a piece of sendmail log
7 # This tests problem report nr. 14
9 LD_LIBRARY_PATH=/usr/local/pqxx/lib
10 export LD_LIBRARY_PATH
14 if psql gnucomo_test -f src/database/create.sql -q >/dev/null
16 # Prepare the database
18 psql gnucomo_test -q -c "insert into object (objectname) values ('schiza.andromeda.nl')"
20 # read logs for both objects
22 src/gcm_input/gcm_input -c gnucomo_test -h schiza.andromeda.nl -d 'oct 26 2003 20:30:45' <test/log0010
25 src/gcm_daemon/gcm_daemon.php -c gnucomo_test
27 # Check the notifications.
29 psql gnucomo_test -c "select notificationid,objectid,type_of_issueid from notification"
33 psql gnucomo_test -f src/database/destroy.sql -q
37 echo Can not create test database