|
I'm setting up a new
v2 box and decided to use mysql 5.5 but once the convert script
is run to generate policyd.mysql ( in ~/database ), I get an
error when creating the db tables: mysql -p policydv2 < ./policyd.mysql Enter password: ERROR 1064 (42000) at line 30: 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 'TYPE=InnoDB CHARACTER SET latin1 COLLATE latin1_bin' at line 12 I assumed it was something to do with the table creation so had a check in the mysql 5.5 docs and it appears that TYPE= has been replaced with ENGINE= I'm not great at generating diffs but it should be straightforward to patch this fix into convert-tsql ... I've done convert-tsql manually and policyd.mysql is now generated correctly for mysql 5.5. Regards --
Robby Pedrica |
_______________________________________________ Users mailing list [email protected] http://lists.policyd.org/mailman/listinfo/users
