Posts Categorized: Uncategorized

ProFTPd Port Restriction

Data ports are allocated to FTP clients on connection so it is difficult to know which port an FTP user might be using when they next connect. To narrow it down a little (for a low usage FTP service) I restricted the port range in /etc/proftpd/proftpd.conf with: PassivePorts                    49152 49252 Let's see how that goes…

Fonts in WebFX tab pane

The WebFX Tab Pane is a great javascript method of adding tabs to webpages. However I found that twhen using the Luna style the f;onts on Linux/Firefox defaulted to a Times type that was also a little too big.   To fix this amend the tab.css file in the Lunafolde and change all occurences of… Read more »

MySQL illegal field names in Mambo/Joomla Import

I had this problem when trying to import an SQL file which was a dump from a MySQL database for Mambo:  ERROR 1064 (42000) at line 142: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'option varchar(50) NOT… Read more »

MySQL Collation and Character Set Notes

When I was importing SQL data files into MySQL 5 (exported from MySQL 3.23) I ran into problems with collation types receiving the following error: ERROR 1071 (42000) at line 4659: Specified key was too long; max key length is 1000 bytes  "Collation" refers to letter sorting order – and you usually select it based… Read more »

2404 MySql Database Search Class

The MySQL Search Class available from 2404.co.uk 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 nwmrt.org

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 »