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
MySQL 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.
Change 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
Mount 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/
Photoshop 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.
Say 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
Installing 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
Brisbane 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.
New 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.
Password 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.
Moving 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
Configuring 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
Throttling 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.