Sunday, June 26, 2005

Quick and Dirty; Apache HTTP Compression

Following are few steps for HTTP compression on Apache.

  • Open httpd.conf
  • Uncomment line #LoadModule headers_module modules/mod_headers.so, if it is commented
  • At the very end of the file, add following lines

LoadModule deflate_module modules/mod_deflate.so



# Insert filter
SetOutputFilter DEFLATE

# Netscape 4.x has some problems...
BrowserMatch ^Mozilla/4 gzip-only-text/html

# Netscape 4.06-4.08 have some more problems
BrowserMatch ^Mozilla/4\.0[678] no-gzip

# MSIE masquerades as Netscape, but it is fine
BrowserMatch \bMSIE !no-gzip !gzip-only-text/html

# Don't compress images
SetEnvIfNoCase Request_URI \.(?:gifjpe?gpng)$ no-gzip dont-vary


# Make sure proxies don't deliver the wrong content
Header append Vary User-Agent env=!dont-vary

  • Restart your Apache HTTP server and you are all up and running with compression server output compression.

For more details refer Apache's mod_deflate Documentation

Tuesday, June 14, 2005

Connect Oracle behind Firewall

Problem: TNS:operation timed out
Reason : Oracle database server behind any type of firewall.
Solution: Add "USE_SHARED_SOCKET"="TRUE", on the windows registry.

[HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\HOME0]
"USE_SHARED_SOCKET"="TRUE

More information can be found here