Wednesday, March 23, 2016

More report optimization

The JobsOverview report was failing after yesterday’s internal optimizations. It took me yet another hour to repair it. But the result is cool: we no longer need the JobsOverview/Default.odt template, and the functional spec (The Jobs plugin) now also tests the content of this report.

Yet another example of why a developer should be paid per month (or per hour), but not per ticket.

Importing legacy data into Lino Welfare

During a phone metting with Wilfried I understood a few more things. We must import only disbursement orders, nothing else. And Wilfried now gave me a complete list of the accounts (budgetary articles) to import.

I adapted cpas2lino. Here is some doctest snippet which I used for basic temporary tests before committing.

>>> from lino import startup
>>> startup('lino_welfare.projects.eupen.settings.doctests')
>>> from \
...     import wanted_accounts
>>> for obj in wanted_accounts():
...     obj.full_clean()
...     #
...     print(obj)
(832/330/03B) Heizölzulage (durch Staat bezuschusst)
(832/330/05) Sozio-kulturelle Beteiligung (Allgemein)
(832-4653/03) Erstatt. an Staat von Einn. 832/-3343/21

Just as a reminder to myself, here are the commands to run on the server:

$ go testlino
$ a
$ time python run ../cpas_eupen/snapshot/
$ python run
$ cat delete_ledger.sql | python dbshell
$ time python cpas2lino /mnt/oeshz_home_server/ANWPROG/TIM/CPAS

Letsencrypt sends erroneous expiration notices

I received yet another email from

Let's Encrypt certificate expiration notice


Your certificate (or certificates) for the names listed below will
expire in 9 days (on 01 Apr 16 19:39 +0000). Please make sure to
renew your certificate before then, or visitors to your website
will encounter errors.


For any questions or support, please visit Unfortunately, we can't
provide support by email.

If you are receiving this email in error, unsubscribe at

The Let's Encrypt Team

I started to receive these reminders about three months after my first installation on that server. After the first mail I ran letsencrypt-auto renew successfully. When I run it now, I get:

$ letsencrypt-auto renew
Updating letsencrypt and virtual environment dependencies...
The following certs are not due for renewal yet:
  ... (a list of all certificates on that server)
No renewals were attempted.

Maximum recursion depth exceeded while calling a Python object

While investigating for #844 I tried to do a dump and a restore in CPAS de Châtelet in the hope of reproducing the problem.

I got another problem instead. When trying to reload the data, I had an AttributeError: module object has no attribute OverlapGroups on this line of the file

if overlap_group: overlap_group = settings.SITE.modules.isip.OverlapGroups.get_by_value(overlap_group)

This was because the following line was missing in lino_welfare.modlib.isip.models:

from .choicelists import *

So I had to do an upgrade in CPAS de Châtelet before even investigating more about #844.

TODO: Automatically run double dump test (fab ddt) for all demo projects.