I'm evaluating JFFNMS as a possible alternative to Nagios, but I am running into an issue with compatibility with mySQL 5.0 on a Debian 3.1 station. I am following the documentation provided for both Debain and general *unix. My issue comes up with executing the script for mySQL I get this error:
./mysql -u jffnms -p jffnms < /usr/local/jffnms-0.8.2/docs/jffnms-0.8.2.mysql
Enter password:
ERROR 1064 (42000) at line 932: 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 'condition char(250) NOT NULL default '',
description char(60) NOT NULL default' at line 3
After talking to a college we modified the jffnms-0.8.2.mysql file to have line 932 read:
conditi char(250) NOT NULL default ' ',
Taking out the keyword 'condition' and replacing it with 'conditi'. The mySQL file now reads into my database without a problem. Now I haven't tested it, but I imagine this destorys many calls placed on this table.
I'm by no strech a mySQL expert, but I am hoping for advice or ideas. Is JFFNMS compatible with mySQL 5.0? Is there another mySQL dump that can create the database structure? Or is there something I am doing wrong?
Taylor
[EMAIL PROTECTED]
Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
_______________________________________________ jffnms-users mailing list jffnms-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jffnms-users
