Changed line 104 in the create_sguildb.sql file to:
updated TIMESTAMP NOT NULL,
And away we go. Hope it helps someone somewhere.
From: Lay, James [mailto:james.lay@...]
Sent: Monday, October 14, 2013 3:44 PM
Subject: [Sguil-users] New install help
So...I've got sguil running great on a different machine...trouble I'm
having is porting it over to an upgraded machine. I'm having an issue
importing the database:
[15:30:24 ids:~/src/sguil-0.8.0/server/sql_scripts$ mysql -u root -p -D
sguildb < create_sguildb.sql
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
Any hints on this? Thank you.
Get latest updates about Open Source Projects, Conferences and News.