Programming

Apache 2.4 upgrade on Arch Linux

Update: Here is the follow-up, using Apache 2.4.9 This article has been written from memory afterwards, so it may be imprecise and/or incomplete but contains the main steps to a successful migration. I plan to complete it when I'll upgrade another machine. You should be able to find the missing…

Turn PHP_SESSID off on an OVH shared server

In a .htaccess file, add: SetEnv SESSION_USE_TRANS_SID 0 In your PHP code:

MySQL: dump the encoding hell

I have encountered this issue in MySQL version 5.1.x, but not in 5.5 (I have not tested other versions): generating a dump of a UTF-8 encoded database (Collation: utf8_general_ci) resulted on non-ASCII characters (like "éà ç") being garbled. I am used to backup databases with this mysqldump…

MariaDB (MySQL): retrieve database collation

In the MySQL prompt:

Git: push a tag when the remote is up-to-date

I started using tags a few weeks ago, after reading "A successful Git branching model". Update: tags are not pushed along without the --tags option. Tags are simply pushed along with the usual git push command. However, if a tag is created after pushing the latest commit, another git push just…