Posts Categorized: Uncategorized

MySQL: mysql is not running but lock exists

A MySQL crash on Red Hat system resulted with: /etc/init.d/mysql status coming back with: mysql is not running but lock exists Solved by removing the lock file: rm /var/lock/subsys/mysql If this happens again it may also be necessary to remove the pid file from /var/lib/mysql

Password-less SSH for Rsync from Solaris

This short article will demonstrate by example password-less ssh from a Solaris 8 box which will backup the contents of a linux box using rsync.In the example there are 2 users involved and 2 machines involved:User: bak2solaris Machine: mylinuxbox (RHEL/Centos) User: root Machine: mysolarisbox (Solaris 8)A cron job will run on machine 'mysolarisbox' as root…. Read more »

SpamAssassin: Overriding default scores

If desired the default scores for rules in spamassassin (located in /usr/share/spamassassin/ can be changed by setting the scores either in /etc/mail/spamassassin/ or another .cf file in the directory. For example, could define: # added an extra half point to the surbl checksscore URIBL_AB_SURBL 2.113score URIBL_JP_SURBL 3.357 score URIBL_OB_SURBL 2.632score URIBL_PH_SURBL 2.535score URIBL_SBL  … Read more »

First Aide for Intrusion Detection

I was considering installing tripwire on a CentOS 5.1 install but I happened upon an article about 'aide' which also notifies the system admin about changes to core files (and thus possible intrusions) Of course any genuine newly installed software may also trigger differences in the aide database. yum install aide If not using SELinux… Read more »

Spamassassin and sa-update

Sa-update replaces Rules-Du-Jour providing fresh spam rules to spamassassin in a similar way that freshclam provides viri updates to ClamAV.Presumably Spamassassin is installed but if it isn't: yum install spamassassin* This will install the main package plus the seperate tools package. Some of the plug-ins require specific perl modules so the following might help depending… Read more »

Aptana for Linux Web Development

Aptana is an Eclipse plug-in/perspective aimed at web development including support for Ajax and PHP. With Eclipsed installed, Aptana can be added by: Open Eclipse Choose Help > Software Updates > Find and Install… In the dialog enter 'Aptana' as the name URL is Install After installation restart Eclipse and choose Window > Open… Read more »

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 »