Category: Linux

Ever need to send a log file or something to an email address: for text attachments: mail -s subject email@address.com < /path/to/my/text.file for binary attachments (images etc..) mutt -s subject -a /path/to/image.jpg email@address.com < /dev/null

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 […]

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 […]

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 […]

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 […]