HOWTO avoid sql injection


a) windows server eigene ip von aussen nicht erreichbar
b) unix - apache vor windows server
c) interner host name im iis dazu ( zB irgendwas.loc )
d) unix /etc/hosts + zeile:  IP(windowsServer)   irgendwas.loc

e) apache conf:

	<VirtualHost 192.168.3.5:80>
		ServerName www.irgendwas.at
		ServerAlias irgendwas.at

		ServerAdmin administrator@irgendwas.at

		RedirectMatch permanent ^.*\.(exe|dll|ida).* http://127.0.0.1
		RedirectMatch permanent /_vti_.* http://127.0.0.1

		
			Options -Indexes

			ProxyPass http://irgendwas.loc/
			ProxyPassReverse http://irgendwas.loc/

			Order Deny,Allow
			Deny from all
			Allow from all

		

		RewriteEngine On

		RewriteCond %{QUERY_STRING}     \
			(;|%3B)((\s|%20)+)?(ALTER|DECLARE|DROP|CREATE|SET|SELECT|INSERT|UPDTE|DELETE|CAST|CONVERT|EXEC|EXECUTE)   [NC,OR]
		RewriteCond %{QUERY_STRING}     \
			(CAST|CONVERT|EXEC)((\s|%20)+)?(\(|%28)   [NC]

		RewriteRule (.*) http://127.0.0.1$1  [L,F,R=403]

		RewriteLogLevel 0
		RewriteLog /var/log/httpd/irgendwas-rewrite.log

		CustomLog /var/log/httpd/irgendwas-access.log combined
		ErrorLog /var/log/httpd/irgendwas-error.log
	</VirtualHost>