[jffnms-users] Problem When Logging in to JFFNMS

[Peter Day]

Help.....   I have just installed JFFNMS onto a SuSE 9.1 server... I believe that I have followed all the installation instructions... although, in truth, anything is possible... I am now seeing 2 problems...   1) On entry into the /admin/setup.php screen I receive the following error at the top of the screen     Warning: is_file(): Stat failed for /root/bin/smsclient (errno=13 - Permission denied) in /opt/jffnms-0.8.2/htdocs/admin/setup.php on line 19     If I have read other posts correctly this error can be ignored.   2) A rather more serious error occurs, unfortunately, when I try to log into the main screen... On logging in using admin/admin the next screen takes a long time to arrive and then displays this error... 08:48:12 db_ping(mysql) Connection to DB Restored... 08:48:13 db_ping(mysql) Connection to DB Restored... 08:48:14 db_ping(mysql) Connection to DB Restored... 08:48:15 db_ping(mysql) Connection to DB Restored... 08:48:16 db_ping(mysql) Connection to DB Restored... Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /opt/jffnms-0.8.2/lib/api.db.inc.php on line 306 08:48:17 db_ping(mysql) Connection to DB Restored... 08:48:18 db_ping(mysql) Connection to DB Restored... 08:48:19 db_ping(mysql) Connection to DB Restored... 08:48:20 db_ping(mysql) Connection to DB Restored... 08:48:21 db_ping(mysql) Connection to DB Restored... Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /opt/jffnms-0.8.2/lib/api.db.inc.php on line 306 08:48:22 db_ping(mysql) Connection to DB Restored... 08:48:23 db_ping(mysql) Connection to DB Restored... 08:48:24 db_ping(mysql) Connection to DB Restored... 08:48:25 db_ping(mysql) Connection to DB Restored... 08:48:26 db_ping(mysql) Connection to DB Restored... 08:48:26 Query Failed - table_insert(events) - insert into events (date,type,host,interface,state,username,info) VALUES ('2005-07-22 08:48:21','43','1','Login','failed','admin','from 128.9.202.50') - Can't find file: './jffnms/events.frm' (errno: 13)08:48:27 db_ping(mysql) Connection to DB Restored... 08:48:28 db_ping(mysql) Connection to DB Restored... 08:48:29 db_ping(mysql) Connection to DB Restored... 08:48:30 db_ping(mysql) Connection to DB Restored... 08:48:31 db_ping(mysql) Connection to DB Restored... Warning: join(): Bad arguments. in /opt/jffnms-0.8.2/lib/api.events.inc.php on line 246 Query Failed - events_list() - Can't find file: './jffnms/hosts.frm' (errno: 13)     Any ideas ? Because I am rapidly running out of ways around this ... I have installed jffnms into /opt/jffnms-0.8.2 not /opt/jffnms which is contrary to the instructions ... however, it should be noted that I tried that installing into jffnms directory first and this still gave me an error....   Yours hopefully   Pete Day