Category: Linux

Setting up OpenVPN – debian

Here’s the steps involved in getting OpenVPN client up and running.. http://openvpn.net/howto.html (looking for a simpler vpn solution? try vtun – it’s pretty kick arse and works well with port forwarding or routers that dont support vpn passthru) # apt-get install openvpn openssl ca-certificates# cp /usr/share/doc/openvpn/examples/sample-config-files/client.conf /etc/openvpn/# mkdir /etc/openvpn/keys/# — move your client keys into […]

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

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

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

Website Screenshot Thumbnail Creator Script

One day I needed to create thumbnails of about 300 websites, this
would usually take a very long time, so I wacked together a simple
shell script which makes use of Firefox, Xvfb, and ImagemagickThe
script creates a virtual X desktop, starts a Firefox instance, and
then, using the openUrl command, proceeds to load each website and
capture a screenshot one at a time.If you cannot get Xvfb
working, you should be able to run this with little modification on a
spare linux desktop. I suggest you play with image magicks cropping
tools to remove the firefox decal. here is the original bash script