Hi everyone i am having some issue trying to use postgres as backend
databse so far i did this as says in the installer file version 2.1
for i in core.tsql access_control.tsql quotas.tsql amavis.tsql
checkhelo.tsql checkspf.tsql greylisting.tsql accounting.tsql; do
./convert-tsql pgsql $i; done > policyd.pgsql
so far so god but when i load this in my PGsql server i get this
sudo -u postgres psql policyd < policyd.pgs
ERROR: syntax error at or near "#"
LINE 1: # Core schema
^
ERROR: syntax error at or near "you"
LINE 1: you can redistribute it and/or modify
^
ERROR: syntax error at or near "either"
LINE 1: either version 2 of the License, or
^
ERROR: syntax error at or near "without"
LINE 1: without even the implied warranty of
^
ERROR: syntax error at or near "if"
LINE 1: if not, write to the Free Software Foundation, Inc.,
^
NOTICE: CREATE TABLE will create implicit sequence "policies_id_seq"
for serial column "policies.id"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"policies_pkey" for table "policies"
CREATE TABLE
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
NOTICE: CREATE TABLE will create implicit sequence
"policy_members_id_seq" for serial column "policy_members.id"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"policy_members_pkey" for table "policy_members"
CREATE TABLE
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
NOTICE: CREATE TABLE will create implicit sequence
"policy_groups_id_seq" for serial column "policy_groups.id"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"policy_groups_pkey" for table "policy_groups"
NOTICE: CREATE TABLE / UNIQUE will create implicit index
"policy_groups_name_key" for table "policy_groups"
CREATE TABLE
INSERT 0 1
INSERT 0 1
NOTICE: CREATE TABLE will create implicit sequence
"policy_group_members_id_seq" for serial column "policy_group_members.id"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"policy_group_members_pkey" for table "policy_group_members"
CREATE TABLE
INSERT 0 1
INSERT 0 1
INSERT 0 1
NOTICE: CREATE TABLE / UNIQUE will create implicit index
"session_tracking_instance_key" for table "session_tracking"
CREATE TABLE
CREATE INDEX
CREATE INDEX
ERROR: syntax error at or near "#"
LINE 1: # AccessControl module schema
^
ERROR: syntax error at or near "you"
LINE 1: you can redistribute it and/or modify
^
ERROR: syntax error at or near "either"
LINE 1: either version 2 of the License, or
^
ERROR: syntax error at or near "without"
LINE 1: without even the implied warranty of
^
ERROR: syntax error at or near "if"
LINE 1: if not, write to the Free Software Foundation, Inc.,
^
ERROR: syntax error at or near "#"
LINE 2: # Quotas module schema
^
ERROR: syntax error at or near "you"
LINE 1: you can redistribute it and/or modify
^
ERROR: syntax error at or near "either"
LINE 1: either version 2 of the License, or
^
ERROR: syntax error at or near "without"
LINE 1: without even the implied warranty of
^
ERROR: syntax error at or near "if"
LINE 1: if not, write to the Free Software Foundation, Inc.,
^
ERROR: relation "quotas" does not exist
LINE 1: INSERT INTO quotas (PolicyID,Name,Track,Period,Verdict) VALU...
^
ERROR: relation "quotas" does not exist
LINE 1: INSERT INTO quotas (PolicyID,Name,Track,Period,Verdict) VALU...
^
NOTICE: CREATE TABLE will create implicit sequence
"quotas_limits_id_seq" for serial column "quotas_limits.id"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"quotas_limits_pkey" for table "quotas_limits"
ERROR: relation "quotas" does not exist
ERROR: relation "quotas_limits" does not exist
LINE 1: INSERT INTO quotas_limits (QuotasID,Type,CounterLimit) VALUE...
^
ERROR: relation "quotas_limits" does not exist
LINE 1: INSERT INTO quotas_limits (QuotasID,Type,CounterLimit) VALUE...
^
ERROR: relation "quotas_limits" does not exist
LINE 1: INSERT INTO quotas_limits (QuotasID,Type,CounterLimit) VALUE...
^
NOTICE: CREATE TABLE / UNIQUE will create implicit index
"quotas_tracking_quotaslimitsid_key" for table "quotas_tracking"
ERROR: relation "quotas_limits" does not exist
ERROR: relation "quotas_tracking" does not exist
ERROR: syntax error at or near "#"
LINE 1: # Amavis module schema
^
ERROR: syntax error at or near "you"
LINE 1: you can redistribute it and/or modify
^
ERROR: syntax error at or near "either"
LINE 1: either version 2 of the License, or
^
ERROR: syntax error at or near "without"
LINE 1: without even the implied warranty of
^
ERROR: syntax error at or near "if"
LINE 1: if not, write to the Free Software Foundation, Inc.,
^
ERROR: relation "amavis_rules" does not exist
LINE 1: INSERT INTO amavis_rules
^
ERROR: syntax error at or near "#"
LINE 1: # CheckHelo module schema
^
ERROR: syntax error at or near "you"
LINE 1: you can redistribute it and/or modify
^
ERROR: syntax error at or near "either"
LINE 1: either version 2 of the License, or
^
ERROR: syntax error at or near "without"
LINE 1: without even the implied warranty of
^
ERROR: syntax error at or near "if"
LINE 1: if not, write to the Free Software Foundation, Inc.,
^
NOTICE: CREATE TABLE will create implicit sequence
"checkhelo_blacklist_id_seq" for serial column "checkhelo_blacklist.id"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"checkhelo_blacklist_pkey" for table "checkhelo_blacklist"
NOTICE: CREATE TABLE / UNIQUE will create implicit index
"checkhelo_blacklist_helo_key" for table "checkhelo_blacklist"
CREATE TABLE
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
NOTICE: CREATE TABLE will create implicit sequence
"checkhelo_whitelist_id_seq" for serial column "checkhelo_whitelist.id"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"checkhelo_whitelist_pkey" for table "checkhelo_whitelist"
NOTICE: CREATE TABLE / UNIQUE will create implicit index
"checkhelo_whitelist_source_key" for table "checkhelo_whitelist"
CREATE TABLE
NOTICE: CREATE TABLE / UNIQUE will create implicit index
"checkhelo_tracking_address_key" for table "checkhelo_tracking"
CREATE TABLE
CREATE INDEX
ERROR: syntax error at or near "#"
LINE 1: # CheckSPF module schema
^
ERROR: syntax error at or near "you"
LINE 1: you can redistribute it and/or modify
^
ERROR: syntax error at or near "either"
LINE 1: either version 2 of the License, or
^
ERROR: syntax error at or near "without"
LINE 1: without even the implied warranty of
^
ERROR: syntax error at or near "if"
LINE 1: if not, write to the Free Software Foundation, Inc.,
^
ERROR: syntax error at or near "#"
LINE 1: # Greylisting module schema
^
ERROR: syntax error at or near "you"
LINE 1: you can redistribute it and/or modify
^
ERROR: syntax error at or near "either"
LINE 1: either version 2 of the License, or
^
ERROR: syntax error at or near "without"
LINE 1: without even the implied warranty of
^
ERROR: syntax error at or near "if"
LINE 1: if not, write to the Free Software Foundation, Inc.,
^
NOTICE: CREATE TABLE will create implicit sequence
"greylisting_whitelist_id_seq" for serial column "greylisting_whitelist.id"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"greylisting_whitelist_pkey" for table "greylisting_whitelist"
NOTICE: CREATE TABLE / UNIQUE will create implicit index
"greylisting_whitelist_source_key" for table "greylisting_whitelist"
CREATE TABLE
NOTICE: CREATE TABLE will create implicit sequence
"greylisting_autowhitelist_id_seq" for serial column
"greylisting_autowhitelist.id"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"greylisting_autowhitelist_pkey" for table "greylisting_autowhitelist"
NOTICE: CREATE TABLE / UNIQUE will create implicit index
"greylisting_autowhitelist_trackkey_key" for table
"greylisting_autowhitelist"
CREATE TABLE
NOTICE: CREATE TABLE will create implicit sequence
"greylisting_autoblacklist_id_seq" for serial column
"greylisting_autoblacklist.id"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"greylisting_autoblacklist_pkey" for table "greylisting_autoblacklist"
NOTICE: CREATE TABLE / UNIQUE will create implicit index
"greylisting_autoblacklist_trackkey_key" for table
"greylisting_autoblacklist"
CREATE TABLE
NOTICE: CREATE TABLE / UNIQUE will create implicit index
"greylisting_tracking_trackkey_key" for table "greylisting_tracking"
CREATE TABLE
CREATE INDEX
ERROR: syntax error at or near "#"
LINE 1: # Accounting module schema
^
ERROR: syntax error at or near "you"
LINE 1: you can redistribute it and/or modify
^
ERROR: syntax error at or near "either"
LINE 1: either version 2 of the License, or
^
ERROR: syntax error at or near "without"
LINE 1: without even the implied warranty of
^
ERROR: syntax error at or near "if"
LINE 1: if not, write to the Free Software Foundation, Inc.,
^
NOTICE: CREATE TABLE / UNIQUE will create implicit index
"accounting_tracking_accountingid_key" for table "accounting_tracking"
ERROR: relation "accounting" does not exist
wish i think is wear since is parsing stuff like this one
ERROR: syntax error at or near "if"
LINE 1: if not, write to the Free Software Foundation, Inc.,
can anyone help me whit this.Thanks and regards.
_______________________________________________
Users mailing list
[email protected]
http://lists.policyd.org/mailman/listinfo/users
