Skip to content

Instantly share code, notes, and snippets.


Stephan Bösch-Plepelits plepe

View GitHub Profile
plepe /
Last active Nov 21, 2020
Installing Mailman3 on Ubuntu 18.04 with MariaDB

Installing Mailman3 on Ubuntu 18.04 with MariaDB

Installing Mailman3 on Ubuntu 18.04 was surprisingly difficult, that's why I want to share my experiences with the world. Here you are:

First install MariaDB

apt install mariadb-server

Add to [mysqld] in /etc/mysql/mariadb.conf.d/50-server.cnf:

plepe / copy.php
Last active Mar 15, 2019
Drupal 8: A script to copy settings from manage display for "search result" of bibcite to all other bibcite types.
View copy.php
$db = new PDO('mysql:dbname=drupal8', '', '');
$res = $db->query("select * from config where name='core.entity_view_display.bibcite_reference.conference_paper.search_result'");
$elem = $res->fetch();
$orig_data = unserialize($elem['data']);
$res = $db->query("select * from config where name like 'bibcite_entity.bibcite_reference_type.%'");
$types = array();
while ($elem = $res->fetch()) {
$type = substr($elem['name'], 38);
plepe /
Created Oct 12, 2018
How I migrated Drupal 6 (with Biblio module) to Drupal 8 (with Bibcite module)

How I migrated Drupal 6 (with Biblio module) to Drupal 8 (with Bibcite module)

I got the task of upgrading an old Drupal 6 webpage to a newer version. We decided to skip Drupal 7 and go directly for Drupal 8 with the new bibcite module (although it is still at 1.0-alpha7 at the time of this writing).

Upgrading most of the content of Drupal 6 to Drupal 8 worked rather fine, with the exception of the Views which have to be migrated separately. Migrating the content of the biblio to bibcite was quite a task though. In this text, I will report how I did the transition.

One of the biggest hurdles was, that the migration would split the publications into two separate entitys. In Drupal 6, there was a "Biblio" content type, which had a "biblio" field with all the bibliographic sub-fields. And there were a fewer custom fields (via CCK), e.g. a teaser image and some node references to projects (which were a separate content type).

After the migration, the publications are a separate entity type (Content -> Biblio

plepe / testfind.js
Created Mar 2, 2017
pouchdb-find error with elemMatch and array of objects
View testfind.js
#!/usr/bin/env node
var async = require('async')
var PouchDB = require('pouchdb')
var db = PouchDB('foobar')
// drop database and re-create (always start with new database)
View tilegrid.html
<script src="lib/ol3/ol.js"></script>
<link rel="stylesheet" href="lib/ol3/ol.css" type="text/css">
window.onload = function() {
var map = new ol.Map({
target: "map",
view: new ol.View({
View json_readable_encode.php
json readable encode
basically, encode an array (or object) as a json string, but with indentation
so that i can be easily edited and read by a human
Copyleft (C) 2008-2011 BohwaZ <>
plepe / gist:52ecc9f18efb32c68d18
Last active Jan 18, 2021
MDADM and LVM cheat sheet
View gist:52ecc9f18efb32c68d18



  • md: multiple devices
command description
cat /proc/mdstat show status of all raids
mdadm --detail /dev/md0 detailed status of raid md0
plepe / gist:7632178
Last active Dec 29, 2015
Error log when compiling mod_tile with Mapnik 2.3.x (see:
View gist:7632178
Making all in iniparser3.0b
make[1]: Entering directory `/home/skunk/mod_tile/iniparser3.0b'
make[1]: Nothing to be done for `all'.
make[1]: Leaving directory `/home/skunk/mod_tile/iniparser3.0b'
make[1]: Entering directory `/home/skunk/mod_tile'
g++ -DHAVE_CONFIG_H -I. -I./includes -I/usr/include/freetype2 -pthread -I/usr/local/include -I/usr/local/include/mapnik/agg -I/usr/include -I/usr/include/cairo -I/usr/include/glib-2.0 -I/usr/lib/x86_64-linux-gnu/glib-2.0/include -I/usr/include/pixman-1 -I/usr/include/freetype2 -I/usr/include/libpng12 -g -O2 -MT gen_tile.o -MD -MP -MF .deps/gen_tile.Tpo -c -o gen_tile.o `test -f 'src/gen_tile.cpp' || echo './'`src/gen_tile.cpp
In file included from /usr/include/c++/4.8/mutex:35:0,
from /usr/local/include/mapnik/config.hpp:56,
from /usr/local/include/mapnik/color.hpp:27,
from /usr/local/include/mapnik/map.hpp:27,
plepe / webadmin.php
Last active Jul 16, 2020
webadmin.php is a simple Web-based file manager.
View webadmin.php
// source:
* webadmin.php - a simple Web-based file manager
* Copyright (C) 2004-2011 Daniel Wacker [daniel dot wacker at web dot de]
* This program is free software; you can redistribute it and/or modify
* it under the terms of the GNU General Public License as published by
* the Free Software Foundation; either version 2 of the License, or
* (at your option) any later version.
plepe / gist:4148833
Created Nov 26, 2012
Commons - von der Informatik in die Raumplanung
View gist:4148833

Commons in der Informatik: Die „Free and Open Source Software“ Bewegung

Um Anwendungsmöglichkeiten für das Commons-Prinzip in der Raumplanung zu finden, ist es hilfreich sich Anwendungen in anderen gesellschaftlichen Bereichen anzusehen; zum Beispiel in der noch relativ jungen Branche Informatik. Dort spielt das Commons-Prinzip besonders in der Softwareentwicklung und in der Wissensgeneration eine große Rolle.

Digitale Information - zu dieser zählt Software - hat das Herausstellungsmerkmal, dass sie unendlich vervielfältigbar ist, ohne einen technischen Qualitätsverlust zu erleiden - im Gegensatz zu Raum, der eine beschränkte Ressource ist.

Das bedeutet aber auch, dass das Vervielfältigen von Information nur künstlich beschränkt werden kann. Das möchte man z.B. zur Kommerzialisierung von Inhalten (wie Computerprogrammen oder digitalen Inhalte wie Filme und Bücher), aber auch aus Datenschutzgründen (Stichwort: Gläserner Mensch). Diese k