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 dtbaker.com.au from the same /var/www/dtbaker directory <VirtualHost *> ServerName dtbaker.com.au ServerAdmin dtbaker@email.com ServerAlias *.dtbaker.com.au 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 http://www.toadsoft.com/toad_oracle.htm Download and Install the Oracle XE Client from http://www.oracle.com/technology/software/products/database/xe/htdocs/102xewinsoft.html 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 […]