From: Javier S. <ja...@jf...> - 2006-09-21 11:30:57
|
I'd that happen to another user. Its because the MySQL you are using has that limitation. You can upgrade MySQL or modify the file there that "255" is in and change it to "254" it will not affect the application. Javier Gibbs, Darren wrote: > Javier. > > Thanks for that. I've started the upgrade, but run into a snag. > > The patching of the app works fine, but when I try to upgrade the > database scheme, I get the following error > > /usr/local/jffnms # cat > docs/upgrade/mysql/jffnms-0.8.2-to-0.8.3.mysql.diff* | mysql -u jffnms > -pjffnms jffnms > ERROR 1074 at line 39: Too big column length for column 'value' (max = > 255). Use BLOB instead > /usr/local/jffnms # > > Any clues as to what I'm doing wrong here? More importantly, what I can > do to fix it? > > Thanks. > > Darren > > -----Original Message----- > From: jff...@li... > [mailto:jff...@li...] On Behalf Of Javier > Szyszlican > Sent: Thursday, 21 September 2006 10:50 AM > To: Gibbs, Darren > Cc: JFFNMS Mail List > Subject: Re: [jffnms-users] JFFNMS 0.8.3 Released > > If you already have 0.8.2 running, then you can keep your own PHP, 0.8.3 > will work. > > It should also work with the latest one. > > I use 5.1.4 > > Javier > > Gibbs, Darren wrote: >> Javier. >> >> A quick query - the upgrade notes say we are advised to upgrade PHP >> and postgres if being used - what version of PHP is required for 0.8.3 > >> to run? >> >> Thanks. >> >> Darren Gibbs >> Senior Network Engineer >> >> -----Original Message----- >> From: jff...@li... >> [mailto:jff...@li...] On Behalf Of >> Javier Szyszlican >> Sent: Monday, 18 September 2006 4:36 AM >> To: JFFNMS Mail List >> Subject: [jffnms-users] JFFNMS 0.8.3 Released >> >> Hello Everyone, >> >> Yes, JFFNMS 0.8.3 has, finally, been released. >> >> Thank you very much for all the support, and I apologize for the > delay. >> This version fixes all the commonly reported issues in the mailing >> list like issues with RRDTool 1.2.x, NAD (Network Auto Discovery) with > >> PosgresSQL, and a few more. >> >> I've also included support for the Dell OpenManage Chassis alarm, and >> OS/400 integration. >> >> You can download the files from: >> >> http://sourceforge.net/project/showfiles.php?group_id=46041&release_id >> =3 >> 26271 >> >> >> >> And here is the full Change Log: >> >> * New Features: >> >> - Support for RRDTool 1.2.x >> - Escapes : in COMMENT statements (Reported by: Aaron Daubman >> <daubman >> |a|t| gmail |d|o|t| com>) >> - Uses LucidaTypewriter font so the graphs are about the same >> as with RRDTool 1.0.x >> >> - Storage device interface type now tracks index changes (like >> when adding a USB drive) or restarting the Agent >> >> - OS/400 Interface type with CPU Utilization graph >> By: David LIMA <DLIMA |a|t| fr |d|o|t| scc |d|o|t| com> >> >> - Per-Host CPU Threshold for Cisco and Linux/Unix hosts >> By: David LIMA <DLIMA |a|t| fr |d|o|t| scc |d|o|t| com> >> >> - Initial Dell OpenManager Interface type (only general alarm for >> now) >> By: Ben Lentz <blentz |a|t| channing-bete |d|o|t| com> and >> David LIMA <DLIMA@fr |d|o|t| scc |d|o|t| com> >> >> * Bug Fixes: >> >> - Apache Discovery now has a 10 seconds timeout. >> by: Craig Small <csmall |a|t| enc |d|o|t| com |d|o|t| au> >> >> - Install guide includes cron.allow and new tmpwatch and pcntl >> dependencies >> Reported by: Joel Harrison <joel_harrison |a|t| bankone >> |d|o|t| >> com> >> >> - New Installation guide for Windows >> By: Fabricio Castro <Fabricio |d|o|t| Castro |a|t| valueadd >> |d|o|t| com >> |d|o|t| br> >> >> - Host name field now is bigger >> Reported by: Emmanuel Doguet <stage2 |a|t| tbs-internet >> |d|o|t| >> com> >> >> - crontab example now has only one Autodiscovery enabled (old one) >> Reported by: Cody Holland <cody |d|o|t| holland |a|t| gmail >> |d|o|t| com> >> >> - Changed some tables to avoid MySQL 5.x keywords ('condition') >> Fixed by: Craig Small <csmall |a|t| enc |d|o|t| com |d|o|t| >> au> >> >> - NAD now works in PostgreSQL >> >> - Cisco CC TFTP copy now works even with the MIBs loaded >> Fixed by: Nick Korosi <nkorosi |a|t| sbcglobal |d|o|t| net> >> >> - NTP Client GPS support >> >> - TCP Port Status now supports hosts with a different SNMP port >> Reported by: Tim Nelson <tnelson |a|t| utaria |d|o|t| net> >> >> - tmpwatch.sh script should work in most Unices now >> Fixed by: Aaron Daubman <daubman |a|t| gmail |d|o|t| com> >> >> - RRDTool will not use the Pipe system when the command line is >> bigger than 1000 characters >> Fixed by: Aaron Daubman <daubman |a|t| gmail |d|o|t| com> >> >> - Added PortChannel link type to NAD >> >> - SNMP Traps Backend GUI now works >> Fixed by: Craig Small <csmall |a|t| enc |d|o|t| com |d|o|t| >> au> >> >> - Timezone removed from PostgreSQL Date results >> Reported by: MOYA Yves <MOYA |a|t| ifb-france |d|o|t| com> >> >> - Changed state field in alarm_states to int (10) >> Reported by: frederic Vay <frederic |d|o|t| vay |a|t| e-qual >> |d|o|t| fr> >> >> - HostMIB interfaces on Windows paths with Non-Printable >> characters were not correctly handled >> >> - Fixed RRDTool grapher to skip empty array items causing problems > >> with some RRDTool versions >> By: Sebastien Namche <sebastien |d|o|t| nameche |a|t| netensia >> |d|o|t| fr> >> >> - Added blocked_devices to storage discovery to avoid problems on >> MacOSX with /dev and /.vol >> >> >> >> Javier >> >> >> -- >> =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= >> Javier Szyszlican, Project Leader, JFFNMS ja...@jf... >> >> I hope JFFNMS or I were helpful to you, if you can, please donate at >> http://jffnms.org/donate >> >> >> ---------------------------------------------------------------------- >> -- >> - >> 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=1216 >> 42 _______________________________________________ >> jffnms-users mailing list >> jff...@li... >> https://lists.sourceforge.net/lists/listinfo/jffnms-users >> >> ******************************************************* >> PLEASE NOTE: This internet email message has been checked for viruses >> and appropriate content to ensure it complies with TABCORP's >> electronic communication policy. >> ******************************************************* >> >> ********************************************************************** >> ************* The information in this e-mail message and any files >> transmitted with it are intended to be confidential and for the use of > >> only the individual or entity to whom they are addressed. The message >> and files may be protected by legal professional privilege, or other >> legal rules. The confidentiality of and privilege applying to this >> message and files is not waived if this message or files has been sent > >> to you by mistake. >> If the reader of this message or files is not the intended recipient, >> you are notified that retention, distribution or copying of this >> message and files are strictly prohibited. If you receive this >> message or files in error, please notify us immediately by telephone >> or return e-mail and delete all copies from your computer system. It >> is the recipient's responsibility to check this message and files for > viruses. >> Thank you. >> ********************************************************************** >> ************* >> > > -- > =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= > Javier Szyszlican, Project Leader, JFFNMS ja...@jf... > > I hope JFFNMS or I were helpful to you, if you can, please donate at > http://jffnms.org/donate > > > ------------------------------------------------------------------------ > - > Take Surveys. Earn Cash. Influence the Future of IT Join > SourceForge.net's Techsay panel and you'll get the chance to share your > opinions on IT & business topics through brief surveys -- and earn cash > http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDE > V > _______________________________________________ > jffnms-users mailing list > jff...@li... > https://lists.sourceforge.net/lists/listinfo/jffnms-users > > ------------------------------------------------------------------------- > Take Surveys. Earn Cash. Influence the Future of IT > Join SourceForge.net's Techsay panel and you'll get the chance to share your > opinions on IT & business topics through brief surveys -- and earn cash > http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV > _______________________________________________ > jffnms-users mailing list > jff...@li... > https://lists.sourceforge.net/lists/listinfo/jffnms-users -- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Javier Szyszlican, Project Leader, JFFNMS ja...@jf... I hope JFFNMS or I were helpful to you, if you can, please donate at http://jffnms.org/donate |