Aug 02 13:26

Perl Ecommerce Applications Roundup

Our main focus is to create and maintain eCommerce sites with Interchange.

On one hand it runs smoothly on existing sites and supports customization needed by our user base.

On the other hand it predates developments like PSGI, plugins and abstract engines for sessions, logging and templates.

For the future we decided to do a complete rewrite of the Interchange software. I will talk at YAPC::Europe 2011 in Riga about our plans.

Oct 05 2010

mongoDB conference Berlin 2010

I decided to go to the mongoDB conference Berlin 2010 to learn about this pretty new schema free and documented oriented database. The 100$ for the conference with three tracks of talks at the same time where really well spent. Most of the talks I listened to were very good and inspiring to try out MongoDB for real life projects.

Aug 31 2010

Move old files to another directory with find

This example shows how to move a large number of files to another directory:


find /var/www/userpics -name '*.jpg' -mtime +31 -print0 | xargs --null mv --target-directory=/backup/oldpics/

Jul 01 2010

Update with records from another table


update subject_cloud set count = count + 1 from (select subject from subjects where sku = '9780520241329') as subs where subs.subject = subject_cloud.subject;

May 23 2010

Testing Gzip compression on your website with wget

wget --save-headers --header\="Accept-Encoding: gzip,deflate" http://www.linuxia.de

Dec 03 2009

Samba/OpenLDAP Cheatsheet

List domain groups:

net groupmap list

Adding domain group:

smbldap-groupadd -a interchange

Adding user to domain group:

smbldap-groupmod -m racke interchange

Please restart Samba after adding domain groups or adding user to domain groups.

Dec 03 2009

OpenLDAP: TLS init def ctx failed: -207

Today I upgraded OpenLDAP in order to fix the insufficient input validation security problem (DSA-1943-1).
Unfortunately OpenLDAP refused to start after the upgrade.

After adding

loglevel config stats

to the configuration file it gave me at least the meaningful error message:

TLS init def ctx failed: -207.

Nov 06 2009

Open LDAP with SSL on Debian

First of all create a self-signed certificate by following the instructions at http://www.eclectica.ca/howto/ssl-cert-howto.php. I copied the private key and the certificates to /etc/ldap. Please make sure that the
private key is only readable by root.

Next add the following lines to /etc/ldap/slapd.conf:

TLSCaCertificateFile /etc/ldap/cacert.pem
TLSCertificateFile /etc/ldap/cert.pem
TLSCertificateKeyFile /etc/ldap/cert.key

Finally make sure that the LDAP server is listening at the ldaps port (636) by editing /etc/default/slapd
and restarting the LDAP server.

Oct 23 2009

Pure-FTPd 1.0.23 has been released

Version 1.0.23 has just been released.

Grab it from http://download.pureftpd.org/pub/pure-ftpd/releases/

This version should fix a lot of old-standing issues. Transfers are more
reliable and should flawlessly handle any kind of cancelation and
disconnection. Virtual quotas should also be way better than they used to be.
FTP over TLS is also more reliable, way faster than it used to be and
overall compatibility with clients has been greatly enhanced. Logging also
received some improvement.

Some limitations of the initial TLS support were also lifted, like the

Jul 14 2009

OpenERP for starters

First of all I installed OpenERP on a local machine:

  1. Install OpenERP server
  2. PostgreSQL user
  3. Install OpenERP client

The installation is documented at doc.openerp.com.

The server is installed as follows:

  1. install required packages
  2. download and unpack sources
  3. sudo python setup.py install

The installation neither adds an init script nor a configuration file.