Technology

Manually change WordPress’ home and siteurl in MySQL

       296 words, 2 minutes

In my tidy process, I had to copy WordPress from one host to another, then access it from various URLs so that the production and the development versions were both accessible from the same public IP. To duplicate the data in a fast manner, I dumped the SQL data and tarred the WWW directory. The problem is that WordPress’ home and siteurl are kept the same between those instances. And since you try to access the administration zone, you’re redirected to the original location… To modify the duplicated instance, you can configure WordPress straight from MySQL. Here are the directions:

Continue reading...


Enable gzip compression on OpenBSD’s Apache

       436 words, 3 minutes

OpenBSD ships with Apache 1.3.x. It is better, faster, stronger, etc… but it isn’t compression-capable by default (AFAIK). Here are the directions to enable compression for all your Web resources:

Continue reading...


Configure SOGo to use MySQL socket

       109 words, 1 minutes

When connecting SOGo with MySQL, you may either use a remote or a local server. To use a remote server, you’ll configure SOGo with such directives: SOGoProfileURL = "mysql://sogouser:sogopass@mysqlhost:3306/sogodbname/sogo_user_profile"; To use a local MySQL server, you will need to access the mysql.socket file. And when it is secured with chroot&friends, the mysql.sock may not be where SOGo expects it. I have mine located at /var/chroot/mysql/mysql.sock. Normally, you would modify my.cnf to refer to the MySQL socket file. But, with SOGo, you must configure the directives as follow:

Continue reading...


Automatic WordPress installation

       385 words, 2 minutes

Here’s a quick trick that allows automatic installation of WordPress on an HTTP server. The normal process is: browse to wordpress.com, grab the archive locally, upload to your server, unzip and run the installer. Sometimes, you even have to unzip locally and then upload the whole sets of files to the server. The automatic process can be done using Instant Install.

Continue reading...


Monitor Apache SSL with Munin

       73 words, 1 minutes

On my munin-node-1.4.5p5, I can only graph HTTP activity ; no HTTPS. There is a plugin though that enables graphing both HTTP and HTTPS. Grab the plugin here ; Copy it in /etc/munin/plugins/ in replacement for the original Munin plugin ; Configure /etc/munin/plugin-conf.d/openbsd-packages to know about the Apache ports to monitor: (...) [apache_*] env.ssl yes env.port 80 env.ports 443 (...) Restart munin_node Wait about 5 minutes and check your new shiny HTTP/SSL graphs!

Continue reading...


59 / 88