Re: MySQL and JFFNMS script for DataBase Load
Javier Szyszlican <
javier@...>
2004-01-29 15:28:22 GMT
That's a very bledding-edge version.
I'll recomend to use the 4.0.x branch. I've never tested JFFNMS with a version
newer than 4.0.x.
You can't remove the types table and expect everything to work correctly.
Javier
On Thursday 29 January 2004 12:23, Coleman, Scott wrote:
> Hi Javier
> here is the info
> mysql Ver 14.3 Distrib 4.1.1-alpha, for portbld-freebsd5.1 (i386)
> I got the script to run by removing the types database from the script and
> creating it through comparison and rename (with webmin)
> it worked fine and the database is up and running however when I attempt to
> pull up jffnms I get this error message at the top
> " Query Failed - interface_status - 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 'types on (types.id = alarms.type) LEFT OUTER JOIN
> severity on (types.severity = ' at line 4 "
> any guesses??
>
>
> Thank you, and if there is anything else we can do to assist please don't
> hesitate to ask
> K. Scott Coleman
> MIS
>
>
>
> -----Original Message-----
> From: Javier Szyszlican [mailto:javier@...]
> Sent: Wednesday, January 28, 2004 8:24 PM
> To: Coleman, Scott; 'jffnms-users@...'
> Subject: Re: [jffnms-users] MySQL and JFFNMS script for DataBase Load
>
>
> Hi Scott,
>
> I've never seen this..
>
> Maybe "types" is now a reserved keyword on some new verion of MySQL.
>
> Which version of MySQL are you using exactly?
>
> I've never seen a 4.0.x MySQL do this.
>
> Javier
>
> On Wednesday 28 January 2004 20:34, Coleman, Scott wrote:
> > Hello -
> > I do not know if this is an issue with MySQL or with the setup script or
> > just something rather strange on my part
> >
> > I am running FreeBSD 5.1
> > Apache 2.1 (mod_ssl)
> > Snort
> > ACID
> > MySQL41-Server
> > and JFFNMS 0.7.4
> > when I install it works fine I can set everything up on the PHP side and
> > all lights are go
> > however when I run the setup script for the database it will not go past
> > the "CREATE TABLE types (
> > on line 1084
> > the error is - " 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 'types ("
> > I have copied it over and tried it two more times without success it
> > makes every table up to this one and I can get it to make every table
> > after this one
> > but it will not make this one
> > I searched MySQL site and all the forums I could find in and on this
> > does anyone have any input for this one???
> > thanks in advance
> >
> >
> > Thank you, and if there is anything else we can do to assist please don't
> > hesitate to ask
> > K. Scott Coleman
> > MIS
> >
> >
> >
> >
> > **********************************************************************
> > This email and any files transmitted with it are confidential and
> > intended solely for the use of the individual or entity to whom they
> > are addressed. If you have received this email in error please notify
> > the sender by email, delete and destroy this message and its
> > attachments.
> >
> > **********************************************************************
-------------------------------------------------------
The SF.Net email is sponsored by EclipseCon 2004
Premiere Conference on Open Tools Development and Integration
See the breadth of Eclipse activity. February 3-5 in Anaheim, CA.
http://www.eclipsecon.org/osdn
_______________________________________________
jffnms-users mailing list
jffnms-users@...
https://lists.sourceforge.net/lists/listinfo/jffnms-users
From Scott.Coleman@... Thu Jan 29 12:23:34 2004
RSS Feed