i-Wa

Configuring Apache 2.2 with Ingres 10.0.0.107 on Windows 32 bit XP Home SP3
Thursday, October 29, 2009

Configuring Apache 2.2 with Ingres 10.0.0.107 on Windows 32 bit XP Home SP3, aka, UCOSP: status report #10

• Bring up your command line window by going to start->Run and type cmd. Type "cbf" to bring up the menu for settings of the DBMS Ingres.
  
  1. Go to DBMS Server->cache Menu, turn the variable 64k caches from "off"(default) to "on".
     
  2. Go to DBMS Server->cursor_limit, increase from 128(default) to 200.
     
  3. Go to DBMS Server->system_maxlocks, increase from 50(default) to 1500.
     
  4. Go to Locking System->per_tx_limit, increase to 1500(default) if it is not.
  
  
• Follow this to check if your Apache is running as a service or locally.
  
• If your web server, Apache, is running as a service, then do the following:
  
  1. Right click My Computer
     
  2. Select "Properties", then go to "Advanced" Tab, click onto "Environment Variables", go to the section of "System variables".
     
  3. Use Add/Edit to add:
     

     II_SYSTEM=C:\Program Files\Ingres\IngresIJ
     PATH=C:\Program Files\Ingres\IngresIJ\bin;C:\Program
     Files\Ingres\IngresIJ\utility;%PATH%

     
     
  4. Reboot your PC for the Service Control Manager to see the new variables
  
  
• If your web server, Apache, is running via your local Windows account, then do the following:
  
  1. Go to Start->Run, and type "cmd /k C:\Program Files\Ingres\IngresIJ\bin\setingenvs.bat"
     
  2. Restart the Apache instance, httpd.exe, by typing "C:\your_path_to_apache\bin\httpd.exe -k restart"
  
  
• Follow this here to see if Apache is talking to Ingres

• The wiki above is specific to Fedora Linux as of date 2009-10-29, ways to configure vary for different types and version of Linux as well as Windows.
  
• After following the above on the part of changing locking variables of Ingres, and restarted the Ingres instance, the "shocking green light" of "Primary Transaction Log", and "Dual Transaction Log" maybe become a darker green colour. If you check your own errlog.log in "C:\Program Files\\whatever\\Ingres??\ingres\files\", and there is no problem about changing of the variables, then it should be the Ingres Visual Manager(IVM) that got confused :p, so don't worry about that.
  

Posted byA nerdy girl at 1:09 PM    

0 comments:

Post a Comment