Blog
MySQL 5 differences
Just a note, while MySQL provide a list of Version 5 Features (Official Data Sheet ), I’ve so far found a few small things. mysql> DESC [table], the Null column now shows NO when it was blank
Read moreMySQL 5 Production Release
MySQL has offically released Version 5 (5.0.15). Just installed over the RC (5.0.13) and restarted had my development machine working fine, however now I need to more closely investigate 2 complicated queries with Outer Joins that no longer work between 4 and 5, and 2 update queries that have crashed my 5.
Read moreChange MP3 bitrate encoding for a MP3 audio file
Get Lame from http://lame.sourceforge.net/ $ su – $ cd /src $ wget http://optusnet.dl.sourceforge.net/sourceforge/lame/lame-3.96.1.tar.gz $ tar xvfz lame-3.96.1.tar.gz $ cd lame-3.96.1 $ ./configure $ make $ make install $ lame –help
Read moreMount Window Share under Linux with Samba
First check what shares are available for your Windoze Box (in this case it is at 192:168.100.36 with a login of and a password of ) $ smbclient -L 192.168.100.36 -U $ mkdir /mnt/
Read morePhotoshop CS .PSD Thumbnails in Windows Explorer
Adobe Photoshop CS (v8.x) no longer supports displaying PSD files as thumbnails in Windows Explorer’s thumbnail view, all you get is a standard Photoshop icon. If you have upgraded from a previous version of Photoshop to Photoshop CS you will be OK but a fresh install of CS will NOT included thumbnail previews of PSDs.
Read moreA tip for not using Click Here as a link on a web page
http://www.w3.org/QA/Tips/noClickHere
Read moreSay no to Word Document Attachments
Interesting read at http://www.gnu.org/philosophy/no-word-attachments.html I found this in a signuature footer. Worthy of consideration. Please avoid sending me Word or PowerPoint attachments. See http://www.gnu.org/philosophy/no-word-attachments.html
Read moreInstalling Samba
Running on CentOS 4.1 the following steps were use to install Samba. Install RPM’s $ rpm -ivh samba-3.0.10-1.4E.i386.rpm $ rpm -ivh samba-swat-3.0.10-1.4E.i386.rpm Start Processes $ /etc/rc.d/init.d/smb start Check Processes $ ps -ef | grep smb
Read moreBrisbane MySQL Users Group
By accident I came across a MySQL Users Group in Brisbane .http://mysql.meetup.com/84/ . I guess I should have thought about it sooner, I go to the QLD Java Users Group, I spent a long time going to the Oracle Users Group, and have been involved in an XP Users group.
Read moreNew Techstuff Blog
Well, it was about time to move to a more standard Blog for my TechStuff, rather then mixing with my personal blog at http://blog.ronaldandanna.com . As I wrote this blog software in a few hours one day, and never got around to finishing things like a calendar and RSS feeds, it was also another good excuse to try out Drupal.
Read morePassword protecting Apache Site for external users only
In order to make an intranet an extranet, you need to place the intranet on a server in the DMZ. From here, configure a virtual server accordingly (e.g. intranet.site.com.au) You will need to configure on an internal DNS (or smoothwall /etc/hosts when using a webproxy) a reference to intranet.
Read moreMoving from standard Apache httpd install to virtual hosts
First you need to create an appropiate directory for virtual host. (Using the example of creating an intranet) $ su – $ useradd intranet $ chmod 755 /home/intranet # needed for apache nobody process
Read moreConfiguring SSH for automated rsync
In order to rsync files between two servers in an automated sense, you need to setup an appropiate SSH key between both the source and destination servers. Destination Server $ cd
Read moreThrottling the CPU on my laptop
Using CentOS 4.1 as the Operating System on my laptop for all my work, I’ve been able to throttle down my CPU when running on battery power to extend my battery life, much like the modes that Windoze provides.
Read more