Archive for August, 2007

Correcting Horde problems after upgrading to PHP 5 on Plesk 7.5.x

With Plesk 7.5.x, a PHP upgrade to version 5 will cause some issues with Horde. These issues stem from problems with the pear scripts that Horde depends on.
To fix it, run these commands:
# pear upgrade DB
# cp -a /usr/share/pear/DB.php /usr/share/pear/DB/ /usr/share/psa-horde/pear/
Credit for this fix goes to Mike J.

Urchin: Unable to open database for writing since it has been archived

Urchin sometimes takes it upon itself to do some weird things, and this is one of those times. If Urchin has archived a month of data, and then you ask Urchin to parse a log that contains accesses from that archived month, you’ll receive this ugly error:
Unable to open database for writing since it [...]

MySQL Error Codes

Sometimes you need a good reference, and this is one of those times. MySQL’s perror command returns many error codes, and I’ve provided a listing here. To find errors individually, just run:
# perror 28
OS error code 28: No space left on device

Here’s the list:
OS error code 1: Operation [...]

MySQL’s query cache explained

An often misused and misunderstood aspect of MySQL is the query cache. I’ve seen blog post after blog post online talking about query caching as the most integral and important feature in MySQL. Many of these same posts advocate cranking the variables to the max to give you “ultimate performance.” One of [...]

Reset the Urchin admin password

Should you find yourself in the situation where you’ve forgotten the Urchin admin password, don’t worry. It’s easily reset with the following command:
cd util ./uconf-driver action=set_parameter table=user name=”(admin)” ct_password=urchin
This will set the password to ‘urchin’, and then you can log into Urchin’s web interface and change it to a secure password. [...]