Category: Linux

Wildcard Apache2 Sub Domains

Sub domains in Apache… Here’s the apache config used for this site. This tells apache to serve up all sub domains of from the same /var/www/dtbaker directory <VirtualHost *> ServerName ServerAdmin ServerAlias * DocumentRoot /var/www/dtbaker/ <Directory /> </Directory> <Directory /var/www/dtbaker> Options Indexes FollowSymLinks MultiViews Order allow,deny allow from all </Directory> ErrorLog /var/log/apache2/error.log […]

Oracle and Toad – tnsnames.ora example

Getting Toad to work with Oracle doesn’t seem to be explained very well anywhere. Here’s a quick list: Download and Install TOAD from Download and Install the Oracle XE Client from If you launch toad now, you should see XE as an option for connecting to Oracle Create a tnsnames.ora file in C:/Program […]

svn: PROPFIND request failed on /svn – Moved Permanently

Setup a new svn repo, and got the following error: # svn checkout http://xx.xx.xx.xx/svn /var/www/myproject –non-interactive# svn: PROPFIND request failed on ‘/svn’# svn: PROPFIND of ‘/svn’: 301 Moved Permanently (http://xx.xx.xx.xx/) Make sure apache has read/write access to the repo, if that doesn’t fix it, then move your svn repo out of the DocumentRoot and you […]

Oracle Joins Across Multiple Servers

You can create a link as: CREATE PUBLIC DATABASE LINK “OtherDB” CONNECT TO “UserName” IDENTIFIED by “Password” USING ‘SID’SELECT * FROM “OtherSchema”.”TableName”@”OtherDB”; or CREATE SYNONYM “otherTableName” FOR “OtherSchema”.”TableName”@”OtherDB” SELECT * FROM “otherTableName” ( it’s easier to do this via the oracle enterprise manager http://192.168.X.X:1158/em Administration > Schema ) You need to establish the link as […]