Homepage of Timotheus Pokorra

Recently I was in the situation where I needed to manage users in Kolab from PHP.

There is an API for the Kolab Webadmin, and it is documented here: https://docs.kolab.org/architecture-and-design/kolab-wap-api.html

There is also a PHP class, that I could have used: https://cgit.kolab.org/webadmin/tree/lib/kolab_client_api.php. But for some reason, I am using CURL.

It took me some time to figure out how to do the GET or POST calls for connecting to the API and call user.info, user.delete, user.add and users.list.

Therefore, I have created a small PHP class, that shows how to do that.

You can find it here: https://github.com/TBits/KolabScripts/tree/KolabWinterfell/kolab-webadmin-api-client

There is also a test.config.php and a test.php to show the usage of that class.

During development, I sometimes got the message: “Internal error”. This is from the class kolab_api_controller, eg. https://cgit.kolab.org/webadmin/tree/lib/kolab_api_controller.php#n181

Actually, it would help if that error was logged to /var/log/kolab-webadmin/errors with some detail:

else {
    Log::error("API controller: Internal Error, ".$service . "_" . $method. " Post: " .print_r($postdata,true). " Get: ".print_r($_GET,true));
    $this->output->error("Internal error", 500);
}

Here comes a quick overview on recent updates to Kolab 16 packages.

Please note: I am only using public information. I have no background knowledge about the releases.

In the past days, the roundcubemail-plugin-contextmenu package has been updated from version 2.1.1 to 2.3. This affects Debian/Ubuntu and RHEL/CentOS.

For details see:

• roundcubemail-plugin-contextmenu in OBS and the upstream commit log of Release 2.3

Here comes a quick overview on recent updates to Kolab 16 packages.

Please note: I am only using public information. I have no background knowledge about the releases.

In the past days, the erlang package has been built for Debian Jessie for Plesk, so that version 18.3.4 will be available there. It only affects Debian Jessie packages for Plesk. Guam has been rebuilt due to this.

For details see:

• erlang
• guam

Here comes a quick overview on recent updates to Kolab 16 packages.

Please note: I am only using public information. I have no background knowledge about the releases.

In the past days, the package roundcubemail has been updated from 1.2 to version 1.3. It affects both RHEL/CentOS and Debian/Ubuntu. Other packages have been rebuilt due to this upgrade:

• roundcubemail: Upgrade to version 1.3
• iRony
• kolab-freebusy
• kolab-syncroton: Update to version 2.3.7

Here is a link to the Roundcube Mail 1.3 Release notes: Roundcube Webmail 1.3.0 released.

Here comes a quick overview on recent updates to Kolab 16 packages.

Please note: I am only using public information. I have no background knowledge about the releases.

I did not report on Updates for Kolab 16 for quite a while. But now that we are finally on a production server with Kolab 16 for TBits.net, I have the intention to report again if anything relevant to the RPM packages changed.

In the past days, the package kolab-syncroton has been updated and rebuilt. It affects both RHEL/CentOS and Debian/Ubuntu.

• kolab-syncroton: Patch setAttendeeStatus for increased Outlook compatibility

KontoCheck ist eine Bibliothek zum Test deutscher Bankkonten, kann aber auch zum Umrechnen der Kontonummern und BLZ in IBAN und BIC benutzt werden.

Es gab ein neues Update der Bankdatei, deren Inhalt jetzt für den Zeitraum 06. März 2017 bis 03. September 2017 gilt. In unserer Bankdatei sind immer die zwei neuesten Bankdaten von der Bundesbank enthalten. Quelle: Deutsche Bundesbank, BLZ Download.

Entsprechend habe ich die Debian und CentOS Pakete aktualisiert:

http://software.opensuse.org/download/package?project=home:tpokorra:kontocheck&package=kontocheck

Auch der Online Dienst https://kontocheck.solidcharity.com/ wurde auf die neue Version aktualisiert. Hier können sowohl manuell Umwandlungen von Kontonummer/BLZ auf IBAN/BIC durchgeführt werden, als auch über einen WebService Abfragen gestellt werden, die mit XML beantwortet werden.

German title: “Lastschriften in Überweisungen konvertieren”

We have had the situation that a SEPA direct debit was sent twice to the bank.

Now we need to credit our customers the amount again.

I did not find an open source script that reverses a direct debit, but I found https://github.com/AbcAeffchen/Sephpa which can write SEPA direct credit files.

Preparation on CentOS7:

yum install epel-release
yum install php-cli composer
composer require AbcAeffchen/Sephpa

Then get the index.php from below, modify the filename of the direct debit file, and the execution and creation date, and pipe the result:

php reverseSEPA.php > directcredit.xml

Here is the script:

I had problems installing nuget packages on CentOS 7 with the mono packages from my copr at https://copr.fedorainfracloud.org/coprs/tpokorra/mono/

I got this error when running nuget restore:

WARNUNG: Error: TrustFailure (Ssl error:1000007d:SSL routines:OPENSSL_internal:CERTIFICATE_VERIFY_FAILED)

The solution is to run once this command (see also http://www.mono-project.com/docs/about-mono/releases/3.12.0/#cert-sync):

sudo cert-sync /etc/pki/tls/certs/ca-bundle.crt

This command is run by default when you install the mono package provided by Xamarin, see https://github.com/mono/linux-packaging-mono/blob/centos/mono-core.spec#L393

Here comes a quick overview on recent updates to Kolab 16 packages.

Please note: I am only using public information. I have no background knowledge about the releases.

I did not report on Updates for Kolab 16 while some courageous people (dhoffend, airhardt/sicherha, hede, kanarip, and probably more) were making Kolab 16 ready for Debian. This seems to have been accomplished.

Also in the past weeks, Kolab 16.1 has been released on December 15th 2016. See the announcement here: https://kolabsystems.com/news/kolab-161-out-now-0

Yesterday, a couple of packages have been updated and rebuilt. Looking at the changes, it only affects Kolab on Debian.

• roundcubemail-plugins-kolab: Add dependencies for kolab_2fa plugin on Debian
• php-christianriesen-base32: now builds for Debian as well
• php-endroid-qrcode: now builds for Debian as well
• php-spomky-labs-otphp: now builds for Debian as well
• kolab-freebusy: Debian package: add dependency on php-monolog
• iRony and kolab-syncroton seem to have been rebuilt because they depend on the other packages.

There is documentation about how to import Contacts into the Roundcube address books from CSV files: https://docs.roundcube.net/doc/help/1.1/en_US/addressbook/importexport.html

Unfortunately, that documentation does not come with a description of the columns supported.

Read the rest of this entry »