I finally resolved this issue and everything seemed to be fine until this morning. Now I'm receiving strange error's in my browser window. I'll add a host and it doesn't appear in the list...alarms report errors as follows too:
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 - interface_status - Can't open file: 'interfaces.MYI'. (errno: 145) 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... Warning: Bad arguments to join() in /opt/jffnms/lib/api.events.inc.php on line 239 Query Failed - events_list() - Can't open file: 'interfaces.MYI'. (errno: 145) I don't know why this was running perfectly yesterday and is broken now. Any ideas? Thanks, Sean -----Original Message----- From: Javier Szyszlican [mailto:[EMAIL PROTECTED] Sent: December 7, 2004 2:40 PM To: Sean Marshall Subject: Re: [jffnms-users] Seperate Database machine issues Sean, I've never tried to use different OS's for this. You will have to consult the MySQL Manual about that. But if you can connect via the Linux CLI to the Windows Server, then it should be ok. Try: echo select * from interfaces | mysql -h server -ujffnms -pjffnms jffnms Javier Sean Marshall wrote: > Hi, > > Yes I've verified it, and I'm using the IP address not hostname. Would > there be an issue due to me using two different OS's for front end and back > end? Any other idea's would be very helpful. > > -----Original Message----- > From: Javier Szyszlican [mailto:[EMAIL PROTECTED] > Sent: December 7, 2004 2:22 PM > Cc: '[EMAIL PROTECTED]' > Subject: Re: [jffnms-users] Seperate Database machine issues > > Hi Sean, > > Are you sure the hostname is specified in the conf/config.ini file? > > Javier > > Sean Marshall wrote: > >>I've used JFFNMS for sometime now successfully, however I want to move the >>database (will be starting over with a new one) onto a separate machine. >>The poller box is running Red Hat Linux with jffnms 0.7.9 and the database >>server is running Win2003 MySQL 4.0.22 (I think). I've setup everything > > and > >>well I get DB(mysql): Could not connect to the Database. Errors. I can't >>login at all anymore, even to setup.php. >> >>I've tried using the command line to test database connectivity mysql -h >>hostname -u jffnms -p jffnms and this works just fine. Any ideas what > > could > >>be wrong? >> >>Thanks, >> >>Sean >> > > -- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= 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 ------------------------------------------------------- SF email is sponsored by - The IT Product Guide Read honest & candid reviews on hundreds of IT Products from real users. Discover which products truly live up to the hype. Start reading now. http://productguide.itmanagersjournal.com/ _______________________________________________ jffnms-users mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jffnms-users
