Hello Javier: Thanks for your suggestion about the GRANT statements. I followed your suggestion, and I am now able to execute following SQL related commands without any errors. However, I still get the JFFNMS setup errors pasted below. I appreciate your help in setting up the JFFNMS. -------------------------- ****** Sucsessful SQL Commands ******
mysql> grant all privileges on jffnms.* to [EMAIL PROTECTED] identified by 'jffnms'; Query OK, 0 rows affected (0.41 sec) mysql> flush privileges; Query OK, 0 rows affected (0.04 sec) mysql> quit; Bye C:\Program Files\MySQL\MySQL Server 4.1\bin>mysql.exe -u jffnms -pjffnms jffnms < c:\jffnms\jffnms-0.8.2\docs\jffnms-0.8.2.mysql (No errors displayed after executing above command) -------------------------------------- ***** Latest JFFNMS Setup Errors **** Version 0.8.2 Site Name Database Configuration Database Type MySQL PostgreSQL Database Server Database Name Database Username Database Password Is The Database Working? no System Configuration Operating System Unix-like Windows GUI Access Method Local Via Satellite Satellite Server - optional ok Satellite URI or 'none' ok Paths Configuration Absolute Path ok WebServer Relative Path ok TFTP Server Files Path ok RRD Files Path ok Engine Temp Files Path ok Log Files Path ok Temp Images Absolute Path ok WebServer Temp Images Relative Path ok PHP Executable Path ok GraphViz Neato Executable Path error RRDTool Executable Path ok GNU Diff Executable Path error NMAP PortScanner Executable Path error FPing Executable Path error SMSClient for SMS via Modem error NTPQ Executable error PHP Status Register Globals set to On no Allow URL fopen set to On yes SNMP Module Loaded? error Sockets Module Loaded? error GD Module Loaded? error MySQL Module Loaded? error PostgreSQL Module Loaded? error PCRE Module Loaded? ok WDDX Module Loaded? ok GUI Options GUI Auth/Login Method HTTP Login Screen Login Screen Image URL ok Login Screen Image Link URL ok Custom CSS Stylesheet URL ok Internal Options Debugging/Logging Enabled Number of days to store Events/Alarms Number of days to store Raw Syslog/Tacacs/Trap records Number of days to store Host Configs Events Latest (in Minutes) Default Map Refresh in secs Default Events Refresh in secs Events Sound Alert Replay Active Alarms Every in minutes Request Authentication to acess Setup --- Javier Szyszlican <[EMAIL PROTECTED]> wrote: > You are skipping the GRANT statements in the > INSTALL.win32 file. > > You are not importing the schema correctly. > > Javier > > Khyati Tripathi wrote: > > Hello: > > > > I am trying to use JFFNMS on a Windows XP laptop. > The > > basic problem is that the database is not working. > > > Thanks for your help. > > > > These are the Errors on JFFNMS Setup Page... > > > > Is The Database Working? no > > > > GraphViz Neato Executable Path error > > RRDTool Executable Path ok > > GNU Diff Executable Path error > > NMAP PortScanner Executable Path error > > FPing Executable Path error > > SMSClient for SMS via Modem error > > NTPQ Executable error > > PHP Status > > Register Globals set to On no > > Allow URL fopen set to On yes > > SNMP Module Loaded? error > > Sockets Module Loaded? error > > GD Module Loaded? error > > MySQL Module Loaded? error > > PostgreSQL Module Loaded? error > > PCRE Module Loaded? ok > > WDDX Module Loaded? ok > > > > When I try to use some commands suggested in > > previously posted e-mails, I get follolwing > results... > > > > C:\Program Files\MySQL\MySQL Server > 4.1\bin>mysql.exe > > -ujffnms -pjffnms jffnms < > > c:\jffnms\jffnms-0.8.2\docs\jffnms-0.8.2.mysql > > ERROR 1045 (28000): Access denied for user > > 'jffnms'@'localhost' (using password: > > YES) > > > > Following statement works... > > C:\Program Files\MySQL\MySQL Server > 4.1\bin>mysql.exe > > -uroot -ptripathi jffnms < > > c:\jffnms\jffnms-0.8.2\docs\jffnms-0.8.2.mysql > > > > mysql> select * from hosts; > > ERROR 1046 (3D000): No database selected > > > > > > Thanks, again. > > > > Sincerely, > > KT. > > > > > > > > > ------------------------------------------------------- > > This SF.Net email is sponsored by the JBoss Inc. > Get Certified Today > > Register for a JBoss Training Course. Free > Certification Exam > > for All Training Attendees Through End of 2005. > For more info visit: > > > http://ads.osdn.com/?ad_id=7628&alloc_id=16845&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 the JBoss Inc. > Get Certified Today > Register for a JBoss Training Course. Free > Certification Exam > for All Training Attendees Through End of 2005. For > more info visit: > http://ads.osdn.com/?ad_id=7628&alloc_id=16845&op=click > _______________________________________________ > jffnms-users mailing list > jffnms-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/jffnms-users > ------------------------------------------------------- This SF.Net email is sponsored by the JBoss Inc. Get Certified Today Register for a JBoss Training Course. Free Certification Exam for All Training Attendees Through End of 2005. For more info visit: http://ads.osdn.com/?ad_id=7628&alloc_id=16845&op=click _______________________________________________ jffnms-users mailing list jffnms-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jffnms-users
