Articles

GPG & OpenSSL commands

Generate a random password: $ openssl rand -base64 18 Examine ASN.1 structure of a CSR: $ openssl asn1parse -i -in ./0000_csr-certbot.pem Generate a key (interactive mode): $ gpg --gen-key You can use the key generator in an unattended mode. Values in the example below are the same as the defaults proposed …
➟ Read more

Bazaar commands

Check-out in the local openerp-server folder the 6.0 branch of the OpenERP server project from Launchpad: $ bzr branch lp:openobject-server/6.0 openerp-server Same command as above, but fetch a particular revision: $ bzr branch lp:openobject-server/6.0 -r 3425 openerp-server Check-out the current head of a branch, without …
➟ Read more

PostgreSQL commands

Update the default configuration to allow direct authentication from the local machine: $ sed -i 's/^local\s\+all\s\+all\s\+ident/local all all trust/g' /etc/postgresql/8.4/main/pg_hba.conf Same as above but for local IPv4 and IPv6 connexions: $ sed -i 's/^host\s\+all …
➟ Read more

Installation Guide for a full-featured Debian server

Here is a collection of articles I wrote during the past year. Together they form a guide that will let you setup a full-featured Debian server. All of these tutorials are based on the recent work I did to setup my personal server on Debian Squeeze. These articles are independent …
➟ Read more

How-to merge Mailman mailing-lists

Let’s say I have an old inactive mailing list (which ID is old-ml) for which I want to merge its archives to another one (called active-ml). To do so, I have to merge the two mbox files holding all mails since the creation of these mailing-lists. I first tried …
➟ Read more