Posts Categorized: Uncategorized

2404 MySql Database Search Class

The MySQL Search Class available from is a useful quick way to implement a database search in PHP. However there is an error when doing table joins on approx line 110 of the code the following line:                 $sql .= "{$join_type} JOIN {$join_table} ". should read:                 $sql… Read more »

Joomla Latest Events Component Error

Using the Joomla Latest Events module I received the following error message:  Warning: array_key_exists(): The second argument should be either an array or an object in /path/to/website/modules/mod_events_latest.lib.php on line 241 Solved by adding the following line: var $eventsByDay  = array();  after:  class JEventsLatest { in the file: /path/to/website/modules/mod_events_latest.lib.php

Beginner Rsync

Rsync comes pre-installed on many systems including Red Hat, Ubuntu and Solaris. Rsync is a useful tool for performing remote backups. It is very efficient as it only backs up the changes or differences in tany changed files rather than the whole file. BASIC EXAMPLE – LOCAL BACKUPS: In this example you can use rsync… Read more »

Solaris 8 NFS shares

Directories can be shared across the network using NFS on Solaris 8. I used the following to mount a directory from a remote system (named servermachine in the listings below) on a local system (clientmachine). On the Server (Host) The /etc/exports file is not used. On Solaris 8 it is the /etc/dfs/dfstab which should be… Read more »

Defaulting SSH to a non-standard host port

If the SSH server on a host has been configured to listen on a non-standard port for example port 92 then normally we would connect with: ssh -p 92 theserver.tld Remembering and typing that -p 92 switch can be a pain in the |Configuring ssh on the client can ease the pain: vi /etc/ssh/ssh_config Add… Read more »

Squid access.log file over 2Gb

I had a problem with Squid which required removing the access.log file as it had grown over 2Gb in size which has caused Squid to terminate and also stopped Squid from starting.The cache.log file seemed to hang at: 2008/04/20 19:09:23| Ready to serve requests.2008/04/20 19:09:24| Configuring Sibling cache2.domain.tld/8080/3130 2008/04/20 19:09:24| Store rebuilding is  1.4% complete… Read more »

Exchange 2007 Identifier Limits

Exchange 2007 Event Viewer reports errors such as: Failed to create a new named property for database "First Storage Group\Mailbox Database 1" because the number of named properties reached the quota limit (11000).  User attempting to create the named property: "CLIENTACCESSHOST$"  Named property GUID: 00020386-0000-0000-c000-000000000046  Named property name/id: "x-rc-host" It seems that Exchange 2007 is… Read more »

CPAN Perl Modules – LWP failed with code

I had a little difficulty today installing some Perl modules from CPAN. I was getting messages like: Fetching with Net::FTP:'t fetch 01mailrc.txt.gz from Fetching with LWP: failed with code[400] message[FTP return code 150]Fetching with Net::FTP: First I tried removing the exisint file from /usr/lib/perl5/5.8.5/CPAN/ Then I tried the install… Read more »

Adding the RPMforge Repositories on CentOS5

Adding the RPMforge repositories is one of the first things I like to do on a new install. Instructions are on the RPMforge website but it is as straightforward as: wget rpm -Uhv rpmforge*  You will then notice the repo details in /etc/yum.repos.d This allowed me to update Spam Assassin from the 3.1.9 version… Read more »

Keep MySQL Alive

I wanted to have a cron job that would check if MySQL was still running and if not to start it again. The following got me started with an hourly check: 0 * * * * ps -ef | grep mysqld | grep -v grep >> /dev/null || /etc/init.d/mysql start