[Sguil-users] Error creating sguil db in FreeBSD

[C. L. M. <car...@gm...>]

Hi all,

 When I try to create sguil db in a FreeBSD 8.4 host returns me this error:

Enter password:
ERROR 1064 (42000) at line 95: 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 '(14) NOT NULL,
  active ENUM('Y','N') DEFAULT 'Y',
  ip VARCHAR(15) DEFAULT NUL' at line 10

 I've tried this solution also:

http://marc.info/?l=sguil-users&m=130377278505912

but it doesn't works. Returns the following error:

root@fbsd:/etc/sguild # mysqlsel/db server: Table 'sguildb.version'
doesn't exist
    while executing
"mysqlsel $MAIN_DB_SOCKETID $query -flatlist"
    (procedure "FlatDBQuery" line 5)
    invoked from within
"FlatDBQuery "SELECT version FROM version""
    invoked from within
"set currentDBVer [FlatDBQuery "SELECT version FROM version"]"
    (file "/usr/local/bin/sguild" line 570)

Any idea how to fix this??

Thanks.