Hello Javier and Robert: Please disregard my previous e-mail about the database not working. The database is now WORKING.
Thanks for your help. How the problem was solved: I was making the changes in c:\php\php.ini instead of c:\windows\php.ini. After I made the changes (e.g., register_globals = On, etc) in c:\windows\php.ini, the database not working error went away. Again, thanks for your help. --- Khyati Tripathi <[EMAIL PROTECTED]> wrote: > 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 > === message truncated === ------------------------------------------------------- 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