The solution to that problem is the one you found.
Try:
c:\> cd "c:\Program Files\MySQL\MySQL Server 4.1\bin\"
Then:
mysql.exe -ujffnms -pjffnms jffnms < c:\jffnms\docs\jffnms-0.8.2.mysql
It has to work, if it doesn't read the mysql.exe manual that came with your
install or in the web.
Javier
Jacques of Vicnet wrote:
Hi Folks
I appear to be experiencing a typical newbie problem. From my reading of
the archives it seems to be a recurring issue. I am trying to setup
JFFNMS on a windows 2000 machine using MSQL version 4.1. It all appears
to work ok and when i look at the /admin/setup.php page on my pc it
looks ok but when i try to access JFFNMS i am getting the following error:
10:44:00 db_ping(mysql) Connection to DB Restored... 10:44:01
db_ping(mysql) Connection to DB Restored... 10:44:02 db_ping(mysql)
Connection to DB Restored... 10:44:03 db_ping(mysql) Connection to DB
Restored... 10:44:04 db_ping(mysql) Connection to DB Restored...
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result
resource in C:\jffnms\lib\api.db.inc.php on line 306
10:44:05 db_ping(mysql) Connection to DB Restored... 10:44:06
db_ping(mysql) Connection to DB Restored... 10:44:07 db_ping(mysql)
Connection to DB Restored... 10:44:08 db_ping(mysql) Connection to DB
Restored... 10:44:09 db_ping(mysql) Connection to DB Restored...
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result
resource in C:\jffnms\lib\api.db.inc.php on line 306
10:44:10 db_ping(mysql) Connection to DB Restored... 10:44:11
db_ping(mysql) Connection to DB Restored... 10:44:12 db_ping(mysql)
Connection to DB Restored... 10:44:13 db_ping(mysql) Connection to DB
Restored... 10:44:14 db_ping(mysql) Connection to DB Restored...
10:44:14 Query Failed - table_insert(events) - insert into events
(date,type,host,interface,state,username,info) VALUES ('2006-01-10
10:44:09','43','1','Login','failed','jssnms','from 192.190.180.249') -
Table 'jffnms.events' doesn't exist10:44:15 db_ping(mysql) Connection to
DB Restored... 10:44:16 db_ping(mysql) Connection to DB Restored...
10:44:17 db_ping(mysql) Connection to DB Restored... 10:44:18
db_ping(mysql) Connection to DB Restored... 10:44:19 db_ping(mysql)
Connection to DB Restored...
Warning: join() [<http://192.190.180.249/function.join>function.join]:
Bad arguments. in C:\jffnms\lib\api.events.inc.php on line 246
Query Failed - events_list() - Table 'jffnms.hosts' doesn't exist
I went through the mail archives and found emails from javier suggesting
that this error occurs because a file hasn't been imported into mysql. I
went back through the win32 install manual and tried the recommended
command (c:\> c:\Program Files\MySQL\MySQL Server 4.1\bin\mysql.exe
-ujffnms -pjffnms jffnms < c:\jffnms\docs\jffnms-0.8.2.mysql) but it
either rejects it or spits out the following. Neither result makes any
difference.
Variables (--variable-name=value)
and boolean options {FALSE|TRUE} Value (after reading options)
--------------------------------- -----------------------------
auto-rehash TRUE
character-sets-dir (No default value)
default-character-set latin1
compress FALSE
database (No default value)
delimiter ;
vertical FALSE
force FALSE
named-commands FALSE
local-infile FALSE
no-beep FALSE
host (No default value)
html FALSE
xml FALSE
line-numbers TRUE
unbuffered FALSE
column-names TRUE
sigint-ignore FALSE
port 3306
prompt mysql>
quick FALSE
raw FALSE
reconnect FALSE
shared-memory-base-name (No default value)
socket (No default value)
table FALSE
debug-info FALSE
user jffnms
safe-updates FALSE
i-am-a-dummy FALSE
connect_timeout 0
max_allowed_packet 16777216
net_buffer_length 16384
select_limit 1000
max_join_size 1000000
secure-auth FALSE
Is there another way to go about solving this problem?
_______________________________________
Jacques Kosky
Senior Network Administrator
Vicnet
Phone: (613) 8664 7438
Mobile 0407 614 742
Fax: 9639 2175
ICQ: 10421595
-------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc. Do you grep through log
files
for problems? Stop! Download the new AJAX search engine that makes
searching your log files as easy as surfing the web. DOWNLOAD SPLUNK!
http://ads.osdn.com/?ad_id=7637&alloc_id=16865&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
-------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc. Do you grep through log files
for problems? Stop! Download the new AJAX search engine that makes
searching your log files as easy as surfing the web. DOWNLOAD SPLUNK!
http://ads.osdn.com/?ad_id=7637&alloc_id=16865&op=click
_______________________________________________
jffnms-users mailing list
jffnms-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/jffnms-users
