> Query Failed - events_list() - Can't find file: './jffnms/hosts.frm'
Bad MySQL table information, try repairing the hosts table with myisamchk.
And check the Archives.
Javier
Peter Day wrote:
> 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
> **
>
--
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
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.Net email is sponsored by: Discover Easy Linux Migration Strategies
from IBM. Find simple to follow Roadmaps, straightforward articles,
informative Webcasts and more! Get everything you need to get up to
speed, fast. http://ads.osdn.com/?ad_id=7477&alloc_id=16492&op=click
_______________________________________________
jffnms-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/jffnms-users
