Moving from MySQL 4 to MySQL 5 caused a few issues on Joomla websites. The problems stem from MySQL 4 using latin1 swedish as default but some applications like Joomla want utf8 so: 1. Re-export the database (it is Ok to do this from the existing MySQL 5 database): mysqldump -u username -p –default-character-set=latin1 –compatible=mysql40… Read more »
Posts By: jonny
Ubuntu Desktop Showing Home Folder Contents
I was playing with a shell script to rename a bunch of image files to lowercase then resize them but I had a typo in one of my variables resulting in accidentally renaming all the folders in my home directory with lowercase names. After next log in I now see the home folder contents displayed… Read more »
Joomla 1.5 – Customising
A few minor notes on changing some of the text in Joomla 1.5: Welcome to the FrontageIn the Admin Control Panel go to Menus > Main Menu > Home > Parameters – System > Page Title. Footer TextIn the Admin Control Panel go to Extensions > Template Manager > Template Name > Edit HTMLIn the… Read more »
Plesk SSL Certificates from Comodo
Trying a free SSL cert from Comodo and had some difficulties with an error message: The CA certificate does not sign the certificate So downloaded the following CA bundle:https://support.comodo.com/index.php?_m=downloads&_a=viewdownload&downloaditemid=77and used that instead of the one supplied in the email and the certificate was accepted.The install instructions here explain the process for Plesk. If using a… Read more »
Troubleshooting Munin
Having given up on installing and using Munin once already I thought I would jot a few notes to help in future troubleshooting. Test the connection by telnet from the munin-server to the munin-nodetelnet mynode 4949list [you should get a list of services available]fetch vmstat [you should get some vmstat numbers] Firewall is the munin-node… Read more »
Plesk ClamAV and SpamAssassin: ART
Configuring Plesk’s version of Qmail to use Clam and Spamassassin. I followed the instructions here:http://www.jaguarpc.com/forums/showthread.php?t=19328But I also received an error: Cannot find any reference to the Q-S administrator Email address in and needed to: vi /var/qmail/control/defaultdomain entering my domain name mybigdomain.tld Useful File Locations: /etc/qmail-scanner.ini/etc/mail/spamassassin/local.cf
Courier IMAP maximum connections
Just increased the maximum number of IMAP (courier) connections (for thunderbird and Mac users) in /etc/courier-imap/imapdMAXDAEMONS from 40 to 80MAXPERIP from 4 to 40as discussed here. I also set DEBUG_LOGIN=1 from DEBUG_LOGIN=0so I could use Munin to count the IMAP logins in the maillog.
MySQL 4 to MySQL 5 Character Sets and Collation
Moving from MySQL 4 to MySQL 5 caused a few issues on Joomla websites. The problems stem from MySQL 4 using latin1 swedish as default but some applications like Joomla want utf8 so: 1. Re-export the database (it is Ok to do this from the existing MySQL 5 database): mysqldump -u username -p –default-character-set=latin1 –compatible=mysql40… Read more »
Live TV Soccer Online
Found the following streaming live soccer: http://www.iraqgoals.net/ http://www.justin.tv
Debugging PHP Errors
To debug PHP without having to amend the php.ini for all websites add the following in a .htaccess file in the directory of the application. Easy to switch on and off: php_value display_errors 1php_value display_startup_errors 1 or php_flag display_errors onphp_value error_reporting 2039 More examples hereGood IBM article here about error reporting levels etc
