Your tables does not exists in the jffnms database.
This is the most important step.
c:\> c:\Program Files\MySQL\MySQL Server 4.1\bin\mysql.exe -ujffnms -pjffnms jffnms < c:\jffnms\docs\jffnms-0.8.x.mysql
Please check its ok.
Javier
Sven Gabriel wrote:
Javier,
I don't forgot it. Although I have repeat it, but the error message is the same ! Hope, that you can help me.
Sven,
You forgot to do the "mysql import data" step.
Configure MySQL:
To create the JFFNMS DB run the following:
Check the path to mysql.exe
c:\> c:\Program Files\MySQL\MySQL Server 4.1\bin\mysql.exe -u
root -p<Root MySQL Password>
mysql>CREATE DATABASE jffnms;
mysql>GRANT ALL PRIVILEGES ON jffnms.* TO [EMAIL PROTECTED]
IDENTIFIED BY 'jffnms';
mysql>FLUSH PRIVILEGES;
mysql>quit;
And:
c:\> c:\Program Files\MySQL\MySQL Server 4.1\bin\mysql.exe
-ujffnms -pjffnms jffnms < c:\jffnms\docs\jffnms-0.8.x.mysql
Replace x with the version you are installing.
Sven Gabriel wrote:
Hi all JFFNMS-User !
After finishing the installation of JFFNMS and setting up the /admin/setup.php page (no errors), I get the following error message,
when I
continue to http://myserver
-----------------------------------------------------------------------
16:11:25 db_ping(mysql) Connection to DB Restored... 16:11:26 db_ping(mysql) Connection to DB Restored... 16:11:27 db_ping(mysql) Connection to DB Restored... 16:11:28 db_ping(mysql) Connection to DB Restored... 16:11:29 db_ping(mysql) Connection to DB Restored...
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in C:\jffnms-0.8.1\lib\api.db.inc.php on line 306
16:11:30 db_ping(mysql) Connection to DB Restored... 16:11:31 db_ping(mysql) Connection to DB Restored... 16:11:32 db_ping(mysql) Connection to DB Restored... 16:11:33 db_ping(mysql) Connection to DB Restored... 16:11:34 db_ping(mysql) Connection to DB Restored...
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in C:\jffnms-0.8.1\lib\api.db.inc.php on line 306
16:11:35 db_ping(mysql) Connection to DB Restored... 16:11:36 db_ping(mysql) Connection to DB Restored... 16:11:37 db_ping(mysql) Connection to DB Restored... 16:11:38 db_ping(mysql) Connection to DB Restored... 16:11:39 db_ping(mysql) Connection to DB Restored...
16:11:39 Query Failed - table_insert(events) - insert into events (date,type,host,interface,state,username,info) VALUES ('2005-04-13 16:11:34','43','1','Login','failed','admin','from 127.0.0.1') - Table 'jffnms.events' doesn't exist
16:11:40 db_ping(mysql) Connection to DB Restored... 16:11:41 db_ping(mysql) Connection to DB Restored... 16:11:42 db_ping(mysql) Connection to DB Restored... 16:11:43 db_ping(mysql) Connection to DB Restored... 16:11:44 db_ping(mysql) Connection to DB Restored...
Warning: join() [<function.join>]: Bad arguments. in C:\jffnms-0.8.1\lib\api.events.inc.php on line 246 Query Failed - events_list() - Table 'jffnms.hosts' doesn't exist
-----------------------------------------------------------------------
I hope someone can help me.
Greetz Sven
-- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= 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://ads.osdn.com/?ad_id=6595&alloc_id=14396&op=click _______________________________________________ jffnms-users mailing list jffnms-users@lists.sourceforge.net 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
------------------------------------------------------- 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://ads.osdn.com/?ad_id=6595&alloc_id=14396&op=click _______________________________________________ jffnms-users mailing list jffnms-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jffnms-users
