Hi I've deleted all the interfaces from the host except for the first one and I lost all my graphing data also. So, I wont do that again.
Here is the output from that command; debian:/opt/jffnms/engine# php4 -q autodiscovery_interfaces.php 142.46.x.xx Content-type: text/html PHP Warning: Function registration failed - duplicate name - snmpget in Unknown on line 0 PHP Warning: Function registration failed - duplicate name - snmpwalk in Unknown on line 0 PHP Warning: Function registration failed - duplicate name - snmprealwalk in Unknown on line 0 PHP Warning: Function registration failed - duplicate name - snmpwalkoid in Unknown on line 0 PHP Warning: Function registration failed - duplicate name - snmp_get_quick_print in Unknown on line 0 PHP Warning: Function registration failed - duplicate name - snmp_set_quick_print in Unknown on line 0 PHP Warning: Function registration failed - duplicate name - snmpset in Unknown on line 0 PHP Warning: snmp: Unable to register functions, unable to load in Unknown on line 0 db_ping(mysql) Connection to DB Restored... db_ping(mysql) Connection to DB Restored... db_ping(mysql) Connection to DB Restored... db_ping(mysql) Connection to DB Restored... db_ping(mysql) Connection to DB Restored... Query failed - autodiscovery hosts data - You have an error in your SQL syntax near '.4.58 and hosts.autodiscovery = autodiscovery.id' at line 6debian:/opt/jffnms/engine# Thanks again....looks like I'm going to have to start over to get this fixed...oh well...first time blues...:) -----Original Message----- From: Javier Szyszlican [mailto:[EMAIL PROTECTED] Sent: Friday, May 14, 2004 10:41 AM To: [EMAIL PROTECTED] Subject: [jffnms-users] Re: Event view errors? Jason, You can leave the First Interface of each. That way you will not loose anything, but since the AD may have added a lot, it will be harder. This is not a normal procedure you will have to do. I'm thinking theres a problem with your DB. Try to do a "REPAIR Table interfaces;" from MySQL. And after that run: cd /opt/jffnms/engine php -q autodiscovery_interfaces.php <host_id> And send me the output, that way I can see why its adding (or not) all the interfaces again. There's no way to remove an event via the web GUI, also, there's no need for you to delete all the events, I was just telling you that it was to make it clean. The MySQL command I gave you only will delete all events, not host or interfaces records. Javier Jason Humes wrote: > Wont I loose all of my current performance data if I delete the > interfaces from the host? So, I delete all the interfaces from the > host, and then what...do a manual discovery? I use the cron that > comes with Debian. And that mysql command, will that totally wipe out > the database of hosts/interfaces? Also, is there any way to delete > events through the web interface, or just with some script. Thanks > again. > > -----Original Message----- > From: Javier Szyszlican [mailto:[EMAIL PROTECTED] > Sent: Friday, May 14, 2004 10:23 AM > To: Jason Humes > Subject: RE: [jffnms-users] Re: Event view errors? > > > Jason, > > First, try to delete all the interfaces of the host you are having > problems with. Because the Auto discovery seems to be adding the same > interfaces all the time. Maybe there's a consistency problem on your > DB. > > Yes, Cronjobs work ok. > > To start as new, you can also execute the following MySQL command: > "DELETE FROM Events;" > > What cron do you use? the way I describe in the INSTALL file works > correctly. > > The PHP memory problem is related to the number of interfaces that the > Auto discovery added. > > Javier > > > On Fri, 14 May 2004 08:58:24 -0400, "Jason Humes" <[EMAIL PROTECTED]> > said: > >>HI >>The event screen is not showing all events for the last hour, only one >>event...if I click on the + button it shows one more event and if I >>click the + again it shows one more event, but they are all in the >>same hour/minute/day. I've included a screen shot of the events I'm >>seeing (basically the same events over and over again even though >>autodiscovery is off and I've deleted these interfaces). My cron jobs >>seem to be working as >>they constantly flood the display of my console with messages (even >>though I >>thought the output was directed to /dev/null as per the install >>instructions)...how can I tell if they are really working... How can I >>fix >>this PHP memory problem. Thanks very much for your help as this is a >>great >>product and we will be using it for a very large deployment. Thanks >>again. >> >>-----Original Message----- >>From: Javier Szyszlican [mailto:[EMAIL PROTECTED] >>Sent: Thursday, May 13, 2004 3:05 PM >>To: [EMAIL PROTECTED] >>Subject: [jffnms-users] Re: Event view errors? >> >> >>Jason, >> >> >>The events screen shows the last hours events, not all at the time, >>you can try to use the " > " icon to go back, or use the filter. >> >>The error is because you have a lot of events, and trying to show them >>all, causes PHP to run out of memory. >> >>Check if you have your cron jobs working ok... >> >>Also, send me the complete Administrative event you are seeing. >> >>Javier >> >>Jason Humes wrote: >> >>>Hi >>>I've recently installed JFFNMS (for the first time, and I must say, >>>I >>>love this product) 0.7.7 on a Debian 3.0 system and have a few >>>problems. One, when I try to view the Events by clicking on >>>Views-Events, it only displays a single event at a time, and if I >>>click on the ALL button it dumps this error to me: >>> >>>Fatal error: Allowed memory size of 8388608 bytes exhausted (tried >>>to >>>allocate 32 bytes) in /opt/jffnms/lib/api.db.inc.php on line 275 >>> >>>Fatal error: Allowed memory size of 8388608 bytes exhausted (tried >>>to >>>allocate 145 bytes) in Unknown on line 0 >>> >>>Number two, when I created my hosts I had them set for automagic >>>discovery and it kept on discovering interfaces which I had manually >>>deleted from the host and generating events for each interface it >>>found, every half hour...so I disabled autodiscovery on the hosts in >>>question, yet I'm still getting the "Found interface x (## of times)" >>>messages for these hosts. Is there any way to stop this, or am I >>>missing something here. Thanks very much. >>> >>>Jason >>> >>> >>>------------------------------------------------------- >>>This SF.Net email is sponsored by: SourceForge.net Broadband Sign-up >>>now for SourceForge Broadband and get the fastest 6.0/768 connection >>>for only $19.95/mo for the first 3 months! >>>http://ads.osdn.com/?ad_id=2562&alloc_id=6184&op=click >> >> >> >>------------------------------------------------------- >>This SF.Net email is sponsored by: SourceForge.net Broadband Sign-up >>now for SourceForge Broadband and get the fastest 6.0/768 connection >>for only $19.95/mo for the first 3 months! >>http://ads.osdn.com/?ad_id=2562&alloc_id=6184&op=click >>_______________________________________________ >>jffnms-users mailing list >>[EMAIL PROTECTED] >>https://lists.sourceforge.net/lists/listinfo/jffnms-users >> > > =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= > Javier Szyszlican, Project Leader, JFFNMS > [EMAIL PROTECTED] > > I hope JFFNMS or I were helpful to you, > if you can, please donate at http://jffnms.org/donate > > > ------------------------------------------------------- > This SF.Net email is sponsored by: SourceForge.net Broadband Sign-up > now for SourceForge Broadband and get the fastest 6.0/768 connection > for only $19.95/mo for the first 3 months! > http://ads.osdn.com/?ad_id=2562&alloc_id=6184&op=click ------------------------------------------------------- This SF.Net email is sponsored by: SourceForge.net Broadband Sign-up now for SourceForge Broadband and get the fastest 6.0/768 connection for only $19.95/mo for the first 3 months! http://ads.osdn.com/?ad_id=2562&alloc_id=6184&op=click _______________________________________________ jffnms-users mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jffnms-users ------------------------------------------------------- This SF.Net email is sponsored by: SourceForge.net Broadband Sign-up now for SourceForge Broadband and get the fastest 6.0/768 connection for only $19.95/mo for the first 3 months! http://ads.osdn.com/?ad_id=2562&alloc_id=6184&op=click _______________________________________________ jffnms-users mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jffnms-users
