sguildb sql script

Error while starting sguil server:

$ sudo /etc/init.d/sguil-server start
 * Starting sguil-server                                                                   pid(11948)  Loading access list: /etc/sguild/sguild.access
pid(11948)  Sensor access list set to ALLOW ANY.
pid(11948)  Client access list set to ALLOW ANY.
pid(11948)  Email Configuration:
pid(11948)    Config file: /etc/sguild/sguild.email
pid(11948)    Enabled: No
pid(11948)  Connecting to localhost on 3306 as sguil
pid(11948)  MySQL Version: version 5.1.58-1ubuntu1
pid(11948)  SguilDB Version: 0.12 0.12
ERROR: Incompatable DB schema. Required Version: 0.12  Installed Version: 0.12 0.12 Check the server/sql_scripts directory of  the src that came with sguild for scripts to help you upgrade
SGUILD: Exiting...

----------------------------------------------------------------------------------

Error while importing sql from /usr/share/doc/sguil-server/sql_scripts/create_sguildb.sql


mysql> SOURCE /usr/share/doc/sguil-server/sql_scripts/create_sguildb.sql
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 '--)' at line 1
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 '--CREATE TABLE tcphdr
--(












--CREATE TABLE udphdr
--(






--CREATE T' at line 1

#Incomplete table from the original source:


mysql> show tables;
+-------------------+
| Tables_in_sguildb |
+-------------------+
| history           |
| nessus            |
| nessus_data       |
| pads              |
| portscan          |
| status            |
| user_info         |
| version           |
+-------------------+
8 rows in set (0.00 sec)
---------------------------------------------------------------------------------------

Changed to use different one at http://www.bufferoverflow.it/media/create_sguildb.sql
and this settles the problem.

mysql> SOURCE /usr/share/doc/sguil-server/sql_scripts/create_sguildb.sql.1
Query OK, 0 rows affected, 1 warning (0.14 sec)

Query OK, 0 rows affected (0.12 sec)

Query OK, 0 rows affected (0.11 sec)

Query OK, 0 rows affected (0.13 sec)

Query OK, 0 rows affected (0.15 sec)

Query OK, 0 rows affected (0.13 sec)

Query OK, 0 rows affected (0.12 sec)

Query OK, 0 rows affected (0.11 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, 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, 1 row affected (0.00 sec)

Query OK, 1 row affected (0.00 sec)

Query OK, 0 rows affected (0.11 sec)

Query OK, 1 row affected (0.00 sec)

mysql> show tables;
+-------------------+
| Tables_in_sguildb |
+-------------------+
| history           |
| nessus            |
| nessus_data       |
| pads              |
| portscan          |
| sensor            |
| status            |
| user_info         |
| version           |
+-------------------+
9 rows in set (0.00 sec)