I am working on installing the stable version on policyd (2.0.12) and
have used
the following script to convert the tsql files to mysql.
for i in core.tsql access_control.tsql quotas.tsql amavis.tsql
checkhelo.tsql checkspf.tsql greylisting.tsql accounting.tsql
do
./convert-tsql mysql55 $i
done > policyd.sql
When I load the file most of it loads but in several sections I get the
following error.
ERROR 1064 (42000): You have an error in your SQL syntax; check the
manual that corresponds to your MySQL server version for the right
syntax to use near '@BIG_INTEGER@,
RecipientData TEXT,
UNIQUE (Instance)
) ENGINE=InnoDB CHA' at line 25
ERROR 1146 (42S02): Table 'policyd.session_tracking' doesn't exist
ERROR 1146 (42S02): Table 'policyd.session_tracking' doesn't exist
Query OK, 0 rows affected (0.01 sec)
ERROR 1064 (42000): You have an error in your SQL syntax; check the
manual that corresponds to your MySQL server version for the right
syntax to use near '@BIG_INTEGER@,
Verdict VARCHAR(255),
Data TEXT,
Comment VARCHAR(102' at line 12
ERROR 1146 (42S02): Table 'policyd.quotas' doesn't exist
ERROR 1146 (42S02): Table 'policyd.quotas' doesn't exist
ERROR 1064 (42000): You have an error in your SQL syntax; check the
manual that corresponds to your MySQL server version for the right
syntax to use near '@BIG_INTEGER@,
Comment VARCHAR(1024),
Disabled SMALLINT NOT NULL DEFAULT ' at line 7
ERROR 1146 (42S02): Table 'policyd.quotas_limits' doesn't exist
ERROR 1146 (42S02): Table 'policyd.quotas_limits' doesn't exist
ERROR 1146 (42S02): Table 'policyd.quotas_limits' doesn't exist
ERROR 1064 (42000): You have an error in your SQL syntax; check the
manual that corresponds to your MySQL server version for the right
syntax to use near '@BIG_INTEGER@,
Counter NUMERIC(10,4),
UNIQUE (QuotasLimitsID,TrackKey)' at line 7
ERROR 1146 (42S02): Table 'policyd.quotas_tracking' doesn't exist
Query OK, 0 rows affected (0.01 sec)
Query OK, 1 row affected (0.00 sec)
ERROR 1064 (42000): You have an error in your SQL syntax; check the
manual that corresponds to your MySQL server version for the right
syntax to use near '@BIG_INTEGER@,
UseHRP SMALLINT,
HRPPeriod @BIG_INTEGER@,
HRPLi' at line 11
Query OK, 0 rows affected (0.00 sec)
Query OK, 1 row affected (0.00 sec)
Query OK, 1 row affected (0.00 sec)
Query OK, 1 row affected (0.00 sec)
Query OK, 1 row affected (0.00 sec)
Query OK, 0 rows affected (0.01 sec)
ERROR 1064 (42000): You have an error in your SQL syntax; check the
manual that corresponds to your MySQL server version for the right
syntax to use near '@BIG_INTEGER@ NOT NULL,
UNIQUE (Address,Helo)
) ENGINE=InnoDB CHARACTER SET la' at line 4
ERROR 1146 (42S02): Table 'policyd.checkhelo_tracking' doesn't exist
Query OK, 0 rows affected (0.00 sec)
ERROR 1064 (42000): You have an error in your SQL syntax; check the
manual that corresponds to your MySQL server version for the right
syntax to use near '@BIG_INTEGER@,
Track VARCHAR(255) NOT NULL,
GreylistAuthValidity ' at line 11
Query OK, 0 rows affected (0.00 sec)
ERROR 1064 (42000): You have an error in your SQL syntax; check the
manual that corresponds to your MySQL server version for the right
syntax to use near '@BIG_INTEGER@ NOT NULL,
LastSeen @BIG_INTEGER@ NOT NULL,
Comment VARCHAR(1' at line 6
ERROR 1064 (42000): You have an error in your SQL syntax; check the
manual that corresponds to your MySQL server version for the right
syntax to use near '@BIG_INTEGER@ NOT NULL,
Comment VARCHAR(1024),
UNIQUE (TrackKey)
) ENGINE=' at line 6
ERROR 1064 (42000): You have an error in your SQL syntax; check the
manual that corresponds to your MySQL server version for the right
syntax to use near '@BIG_INTEGER@ NOT NULL,
LastUpdate @BIG_INTEGER@ NOT NULL,
Tries @BIG_INTE' at line 7
ERROR 1146 (42S02): Table 'policyd.greylisting_tracking' doesn't exist
--
-----------------------------------------------------------------------
Willie Bollinger | 2975B Manchester Rd.| E-Mail: [email protected]
Quantum Internet Services| Manchester, MD 21102| Voice: 410-239-6920
-----------------------------------------------------------------------
_______________________________________________
Users mailing list
[email protected]
http://lists.policyd.org/mailman/listinfo/users_lists.policyd.org
