Op 6-2-2013 21:09, Andrew Colin Kissa schreef:
On 06 Feb 2013, at 4:53 PM, Johan Hendriks wrote:
2013-02-06 15:49:08,607 INFO [baruwa.websetup] [MainThread] Populating initial
sql
That should create the views, if they are not there you should try creating
them via
psql as the baruwa user.
--
www.baruwa.org
_______________________________________________
Keep Baruwa FREE - http://pledgie.com/campaigns/12056
[root@baruwa2 ~]# psql -U baruwa baruwa
Welcome to psql 8.3.22, the PostgreSQL interactive terminal.
Type: \copyright for distribution terms
\h for help with SQL commands
\? for help with psql commands
\g or terminate with semicolon to execute query
\q to quit
baruwa=> \dv
List of relations
Schema | Name | Type | Owner
--------+-----------------+------+--------
public | current_domains | view | baruwa
public | ldaplookup | view | baruwa
public | mtasettings | view | baruwa
public | quickpeek | view | baruwa
public | relaydomains | view | baruwa
public | routedata | view | baruwa
(6 rows)
baruwa=>
Then try to insert the integration.sqlfile
baruwa=> \i
/usr/home/baruwa/px/lib/python2.7/site-packages/baruwa/config/sql/integration.sql
DROP VIEW
CREATE VIEW
DROP VIEW
CREATE VIEW
DROP VIEW
CREATE VIEW
DROP VIEW
CREATE VIEW
DROP VIEW
CREATE VIEW
DROP VIEW
CREATE VIEW
psql:/usr/home/baruwa/px/lib/python2.7/site-packages/baruwa/config/sql/integration.sql:83:
NOTICE: view "spamactions" does not exist, skipping
DROP VIEW
psql:/usr/home/baruwa/px/lib/python2.7/site-packages/baruwa/config/sql/integration.sql:100:
ERROR: syntax error at or near "ruleset"
LINE 5: WHEN spam_actions=3 THEN 'delete' END], ' ') ruleset fr...
^
psql:/usr/home/baruwa/px/lib/python2.7/site-packages/baruwa/config/sql/integration.sql:103:
NOTICE: view "highspamactions" does not exist, skipping
DROP VIEW
psql:/usr/home/baruwa/px/lib/python2.7/site-packages/baruwa/config/sql/integration.sql:120:
ERROR: syntax error at or near "ruleset"
LINE 5: ... WHEN highspam_actions=3 THEN 'delete' END], ' ') ruleset fr...
^
psql:/usr/home/baruwa/px/lib/python2.7/site-packages/baruwa/config/sql/integration.sql:123:
NOTICE: view "spamchecks" does not exist, skipping
DROP VIEW
psql:/usr/home/baruwa/px/lib/python2.7/site-packages/baruwa/config/sql/integration.sql:136:
ERROR: syntax error at or near "ruleset"
LINE 3: ...CT ARRAY_TO_STRING(ARRAY['To:', name, 'no'], ' ') ruleset fr...
^
psql:/usr/home/baruwa/px/lib/python2.7/site-packages/baruwa/config/sql/integration.sql:139:
NOTICE: view "approvedlistinner" does not exist, skipping
DROP VIEW
psql:/usr/home/baruwa/px/lib/python2.7/site-packages/baruwa/config/sql/integration.sql:165:
ERROR: syntax error at or near "ruleset"
LINE 3: ..._STRING(ARRAY['From:', from_address, 'yes'], ' ') ruleset, 1...
^
psql:/usr/home/baruwa/px/lib/python2.7/site-packages/baruwa/config/sql/integration.sql:168:
NOTICE: view "approvedlist" does not exist, skipping
DROP VIEW
psql:/usr/home/baruwa/px/lib/python2.7/site-packages/baruwa/config/sql/integration.sql:176:
ERROR: relation "approvedlistinner" does not exist
psql:/usr/home/baruwa/px/lib/python2.7/site-packages/baruwa/config/sql/integration.sql:179:
NOTICE: view "bannedlistinner" does not exist, skipping
DROP VIEW
psql:/usr/home/baruwa/px/lib/python2.7/site-packages/baruwa/config/sql/integration.sql:205:
ERROR: syntax error at or near "ruleset"
LINE 3: ..._STRING(ARRAY['From:', from_address, 'yes'], ' ') ruleset, 1...
^
psql:/usr/home/baruwa/px/lib/python2.7/site-packages/baruwa/config/sql/integration.sql:208:
NOTICE: view "bannedlist" does not exist, skipping
DROP VIEW
psql:/usr/home/baruwa/px/lib/python2.7/site-packages/baruwa/config/sql/integration.sql:214:
ERROR: relation "bannedlistinner" does not exist
psql:/usr/home/baruwa/px/lib/python2.7/site-packages/baruwa/config/sql/integration.sql:217:
NOTICE: view "virusscan" does not exist, skipping
DROP VIEW
psql:/usr/home/baruwa/px/lib/python2.7/site-packages/baruwa/config/sql/integration.sql:230:
ERROR: syntax error at or near "ruleset"
LINE 3: ...CT ARRAY_TO_STRING(ARRAY['To:', name, 'no'], ' ') ruleset fr...
^
psql:/usr/home/baruwa/px/lib/python2.7/site-packages/baruwa/config/sql/integration.sql:233:
NOTICE: view "innerhighspamscore" does not exist, skipping
DROP VIEW
psql:/usr/home/baruwa/px/lib/python2.7/site-packages/baruwa/config/sql/integration.sql:241:
ERROR: syntax error at or near "num"
LINE 2: SELECT address, high_score, 1 num FROM addresses, users WHE...
^
psql:/usr/home/baruwa/px/lib/python2.7/site-packages/baruwa/config/sql/integration.sql:244:
NOTICE: view "highspamscore" does not exist, skipping
DROP VIEW
psql:/usr/home/baruwa/px/lib/python2.7/site-packages/baruwa/config/sql/integration.sql:257:
ERROR: syntax error at or near "ruleset"
LINE 3: ...RRAY['To:', address, ' ', TEXT(high_score)], ' ') ruleset fr...
^
psql:/usr/home/baruwa/px/lib/python2.7/site-packages/baruwa/config/sql/integration.sql:260:
NOTICE: view "innerspamscore" does not exist, skipping
DROP VIEW
psql:/usr/home/baruwa/px/lib/python2.7/site-packages/baruwa/config/sql/integration.sql:265:
ERROR: syntax error at or near "num"
LINE 2: SELECT address, low_score, 1 num FROM addresses, users WHER...
^
psql:/usr/home/baruwa/px/lib/python2.7/site-packages/baruwa/config/sql/integration.sql:268:
NOTICE: view "spamscore" does not exist, skipping
DROP VIEW
psql:/usr/home/baruwa/px/lib/python2.7/site-packages/baruwa/config/sql/integration.sql:281:
ERROR: syntax error at or near "ruleset"
LINE 3: ...ARRAY['To:', address, ' ', TEXT(low_score)], ' ') ruleset fr...
^
psql:/usr/home/baruwa/px/lib/python2.7/site-packages/baruwa/config/sql/integration.sql:284:
NOTICE: view "messagesize" does not exist, skipping
DROP VIEW
psql:/usr/home/baruwa/px/lib/python2.7/site-packages/baruwa/config/sql/integration.sql:298:
ERROR: syntax error at or near "ruleset"
LINE 3: ...'To:', '*@', name, ' ', TEXT(message_size)], ' ') ruleset fr...
^
psql:/usr/home/baruwa/px/lib/python2.7/site-packages/baruwa/config/sql/integration.sql:301:
NOTICE: view "innersignmsgs" does not exist, skipping
DROP VIEW
psql:/usr/home/baruwa/px/lib/python2.7/site-packages/baruwa/config/sql/integration.sql:319:
ERROR: syntax error at or near "ruleset"
LINE 3: ...AY_TO_STRING(ARRAY['From:', address, 'yes'], ' ') ruleset, 1...
^
psql:/usr/home/baruwa/px/lib/python2.7/site-packages/baruwa/config/sql/integration.sql:323:
NOTICE: view "signmsgs" does not exist, skipping
DROP VIEW
psql:/usr/home/baruwa/px/lib/python2.7/site-packages/baruwa/config/sql/integration.sql:331:
ERROR: relation "innersignmsgs" does not exist
psql:/usr/home/baruwa/px/lib/python2.7/site-packages/baruwa/config/sql/integration.sql:334:
NOTICE: view "innerhtmlsigs" does not exist, skipping
DROP VIEW
psql:/usr/home/baruwa/px/lib/python2.7/site-packages/baruwa/config/sql/integration.sql:352:
ERROR: syntax error at or near "ruleset"
LINE 3: ...gnature-dir%/users/', username, '/sig.html'], '') ruleset, 1...
^
psql:/usr/home/baruwa/px/lib/python2.7/site-packages/baruwa/config/sql/integration.sql:356:
NOTICE: view "htmlsigs" does not exist, skipping
DROP VIEW
psql:/usr/home/baruwa/px/lib/python2.7/site-packages/baruwa/config/sql/integration.sql:364:
ERROR: relation "innerhtmlsigs" does not exist
psql:/usr/home/baruwa/px/lib/python2.7/site-packages/baruwa/config/sql/integration.sql:367:
NOTICE: view "innertextsigs" does not exist, skipping
DROP VIEW
psql:/usr/home/baruwa/px/lib/python2.7/site-packages/baruwa/config/sql/integration.sql:385:
ERROR: syntax error at or near "ruleset"
LINE 3: ...ignature-dir%/users/', username, '/sig.txt'], '') ruleset, 1...
^
psql:/usr/home/baruwa/px/lib/python2.7/site-packages/baruwa/config/sql/integration.sql:389:
NOTICE: view "textsigs" does not exist, skipping
DROP VIEW
psql:/usr/home/baruwa/px/lib/python2.7/site-packages/baruwa/config/sql/integration.sql:397:
ERROR: relation "innertextsigs" does not exist
psql:/usr/home/baruwa/px/lib/python2.7/site-packages/baruwa/config/sql/integration.sql:400:
NOTICE: view "innersigimgfiles" does not exist, skipping
DROP VIEW
psql:/usr/home/baruwa/px/lib/python2.7/site-packages/baruwa/config/sql/integration.sql:416:
ERROR: syntax error at or near "ruleset"
LINE 3: ...signature-dir%/users/', username, '/', name], '') ruleset, 1...
^
psql:/usr/home/baruwa/px/lib/python2.7/site-packages/baruwa/config/sql/integration.sql:420:
NOTICE: view "sigimgfiles" does not exist, skipping
DROP VIEW
psql:/usr/home/baruwa/px/lib/python2.7/site-packages/baruwa/config/sql/integration.sql:428:
ERROR: relation "innersigimgfiles" does not exist
psql:/usr/home/baruwa/px/lib/python2.7/site-packages/baruwa/config/sql/integration.sql:431:
NOTICE: view "innersigimgs" does not exist, skipping
DROP VIEW
psql:/usr/home/baruwa/px/lib/python2.7/site-packages/baruwa/config/sql/integration.sql:447:
ERROR: syntax error at or near "ruleset"
LINE 3: ...Y['From: ', address, ' ', user_sigimgs.name], '') ruleset, 1...
^
psql:/usr/home/baruwa/px/lib/python2.7/site-packages/baruwa/config/sql/integration.sql:451:
NOTICE: view "sigimgs" does not exist, skipping
DROP VIEW
psql:/usr/home/baruwa/px/lib/python2.7/site-packages/baruwa/config/sql/integration.sql:459:
ERROR: relation "innersigimgs" does not exist
psql:/usr/home/baruwa/px/lib/python2.7/site-packages/baruwa/config/sql/integration.sql:462:
NOTICE: view "msrulesets" does not exist, skipping
DROP VIEW
psql:/usr/home/baruwa/px/lib/python2.7/site-packages/baruwa/config/sql/integration.sql:501:
ERROR: relation "spamactions" does not exist
baruwa=>
regards
Johan
_______________________________________________
Keep Baruwa FREE - http://pledgie.com/campaigns/12056
