Member
FutureboyEnso OS | Review from an openSUSE User
Kmail und PostgreSQL zusammenbringen
Kmail, das Mailprogramm des KDE Projekts, kommt ja nicht alleine daher. Mit dabei ist auch ein Adressbuch, eine Terminverwaltung, ein Benachrichtigungsdienst und noch einiges mehr. Das ganze wird von Akonadi, dem dahinterliegenden Backend der gesamten KDE PIM Suite, sozusagen am Laufen gehalten.
Standardmäßig läuft Akonadi mit MySQL als Datenbanksystem, was bei mir aber immer wieder Zicken gemacht hat. Daher habe ich mich mal nach Alternativen umgesehen und bin neben SQLite bei PostgreSQL gelandet. Über SQLite und die Implementierung in Akonadi gab es leider einige negative Berichte, darum habe ich es direkt aussortiert.
Mit PostgreSQL hatte ich keine Erfahrungen, konnte es aber recht schnell einrichten. Die Anbindung von Akonadi und somit Kmail an PostgreSQL war ebenfalls einfach.
Alle Schritte unter openSUSE
Zuerst installieren wir alle nötigen Pakete für PostgreSQL und die Akonadi-Anbindung:
# zypper in postgresql-server libQt5Sql5-postgresql
PostgreSQL Server aktivieren und starten:
# systemctl enable --now postgresql
Postgres-Nutzer und -Datenbank anlegen:
# su - postgres $ createuser <dein-nutzername> $ psql postgres postgres=# alter user <dein-nutzername> createdb; postgres=# \q; # exit
Dann richten wir – mit deinem regulären Nutzerkonto – den Datenbankzugriff einrichten:
$ createdb akonadi-<dein-nutzername>
Nun stoppen wir Akonadi und löschen bzw. verschieben die Einstellungen. Das ist besonders wichtig, falls du Akonadi schon einmal gestartet hast!
$ akonadictl stop $ rm -rf ~/.local/share/akonadi
Die Verbindung zum Datenbankserver passen wir in der Datei ~/.config/akonadi/akonadiserverrc wie folgt an:
[%General] Driver=QPSQL [QPSQL] Host=/tmp/akonadi-<dein-nutzername>.hash InitDbPath=/usr/bin/initdb Name=akonadi Options= ServerPath=/usr/bin/pg_ctl StartServer=true
Abschließend Akonadi neu starten und du bist startklar:
$ akonadictl start
Bringing Kmail and PostgreSQL together
Kmail, the mail program of the KDE project, does not come alone. Also included is an address book, an appointment manager, a notification service and much more. The whole thing is kept running by Akonadi, the backend of the whole KDE PIM Suite.
By default Akonadi runs with MySQL as database system, but this has caused quite some fuss again and again. So I looked around for alternatives and ended up at PostgreSQL next to SQLite. Unfortunately there were some negative reports about SQLite and the implementation in Akonadi, so I sorted it out directly.
I had no experience with PostgreSQL, but was able to set it up quite quickly. Connecting Akonadi and Kmail to PostgreSQL was also easy.
All steps under openSUSE
First we install all necessary packages for PostgreSQL and the Akonadi connection:
# zypper in postgresql-server libQt5Sql5-postgresql
Activate and start PostgreSQL Server:
# systemctl enable --now postgresql
Create Postgres user and database:
# su - postgres $ createuser <your-username> $ psql postgres postgres=# alter user <your-username> createdb; postgres=# \q; # exit
Then we set up the database access with your regular user account:
$ createdb akonadi-<your-username>
Now we stop Akonadi and delete or move the settings. This is especially important if you have already had started Akonadi!
$ akonadictl stop $ rm -rf ~/.local/share/akonadi
We adjust the connection to the database server in the file ~/.config/akonadi/akonadiserverrc as follows:
[%General]
Driver=QPSQL
[QPSQL]
Host=/tmp/akonadi-<your-username>.hash
InitDbPath=/usr/bin/initdb
Name=akonadi
Options=
ServerPath=/usr/bin/pg_ctl
StartServer=true
Finally restart Akonadi and you are ready to go:
$ akonadictl start
KDE Connect: Controla tu PC desde tu smartphone
¿Qué es KDE Connect?
- Recibir las notificaciones del teléfono en la computadora de escritorio y responder a los mensajes
- Controlar la reproducción de música en nuestro escritorio desde el teléfono
- Usa el teléfono como control remoto para nuestro escritorio
- Ejecutar comandos predefinidos en la PC desde dispositivos conectados. Veáse la lista de comandos de ejemplo para más detalles.
- Comprueba el nivel de batería del teléfono desde el escritorio.
- Llamar al teléfono para ayudar a encontrarlo.
- Compartir archivos y enlaces entre dispositivos.
- Navega tu teléfono desde el escritorio
- Controla el volumen del escritorio desde el teléfono.
-
Implementa un protocolo de comunicación seguro a través de la red, y permite a cualquier desarrollador crear complementos sobre él.
-
Tiene un componente que instalas en tu escritorio.
- Tiene una aplicación cliente de KDE Connect que ejecutas en tu teléfono.
Instalación en openSUSE LEAP 15
In support of Coraline Ada Ehmke
Last night, the linux.org DNS was hijacked and redirected to a page that doxed her. Coraline is doing extremely valuable work with the Contributor Covenant code of conduct, which many free software projects have adopted already.
Coraline has been working for years in making free software, and computer technology circles in general, a welcome place for underrepresented groups.
I hope Coraline stays safe and strong. You can support her directly on Patreon.
Konqueror is Still Awesome
My GUADEC 2018 presentation
I just realized that I forgot to publish my presentation from this year's GUADEC. Sorry, here it is!
You can also get the ODP file for the presentation. This is released under a CC-BY-SA license.
This is the video of the presentation.
Update Dec/06: Keen readers spotted an incorrect use of opaque pointers; I've updated the example code in the presentation to match Jordan's fix with the recommended usage. That merge request has an interesting conversation on FFI esoterica, too.
USB or Removable Media Formatting in Linux
GNUHealth conference 2018 aftermath
GNU Health Con is an annual conference that brings together enthusiasts and developers of the Free/Libre Health & Hospital Information System. It hosted in Las Palmas de Gran Canaria, Spain on November 23rd until 25th.
I met the people behind the project during the openSUSE conference 2018. Since I'm health professional, this projects fits me. So I introduced myself to the community and started to write some articles and translate in Greek. I didn't have in mind to join GNU Health Conference by that time. I just liked the project and wanted to contribute. The idea to attend came after summer, during another conference. GNU Health is sponsored by openSUSE. So openSUSE planed to be there both with a presentation and a booth. I would like to thank openSUSE sponsoring me to attend to such an awesome conference.
My Odyssey for me started going from Thessaloniki to Hamburg (about 3 hours flight) and then Hamburg to Las Palmas (about 5 hours flight). I arrived just before midnight and the weather was rainy. Heavy rain. I didn't feel it much because I was exited to attend the conference.
The first day of the conference there were couple of interesting presentations such as Digital Health: Health for all by Tomas Karopka, Patient information governance standards by Dr Richard Fitton where he talked about the GDPR, Orthanc: Free ecosystem for medical imaging by Sebastien Jodogne, a project that is very useful even to veterinarians. I liked Isabela's presentation about Privacy and security of your health information. She introduced us to Tor project and mission. A cool thing I learnt there was the facebookcorewwwi.onion (it allows access to Facebook through the Tor protocol) and onionshare (an open source tool that lets you securely and anonymously share a file of any size). Ghazal Hassan explained what it's happening in Morocco. The title of his presentation was Challenges in health data management in low-income countries. The day closed with Ludwig Nussel presenting openSUSE Leap and Tumbleweed an overview. The feedback was very positive on openSUSE. Many implementations are on openSUSE and the guys that use it, they say that it's very stable system even they have some obstacles to overcome on infrastructure. The day closed with a round table about open source on health. A conclusion that came out from this talk is that we have to document everything we do, so more people can use our product.
During the coffee break, we had our group photo.
The second day started with Axel Braun talking about the community followed by Vincenzo Virgilio that analyzed what is happening with migrants in Italy. It's something that it's happening in my country also and it's important to have a managing health platform for immigrants. Armand Mpassy-Nzouma analyzed how you can manage a project with GNU Health. He made a quite funny and inspiring talk. My friends from Argentina, Ingrid Spessotti and Francisco Moyano Casco talked about Diamante health information system. Francisco mentioned that they use Pentium 4 as servers. It's an example that if there is no money for technology, use what ever you have at the time. Emillen Fouda talked about the impact that GNU Health has at the Bafia District Hospital. Closing the day, Luis Falcon introduced the book of life and the GNU Health Federation. The day ended with GNU Health Social Medicine Awards 2018 and a dinner at a fancy restaurante.
Sunday was the last day of the conference. Actually it was workshop day. There was a demo of the federation and also the command line.
Personally, I helped at the booth, although there were not countless attendees. We had a pretty cozy booth. People got swag and asked questions about Leap and how it's connected to SUSE.
My experience was unbelievable. I'm very happy that openSUSE community supports a fantastic "health and healthy community". Usually doctors aren't that enthusiasts when it comes to conferences. But if you mix with open source, you get a hybrid. I can't wait to meet you again guys. Maybe FOSDEM, maybe next conference.
Here is a vlog (in Greek) about my trip to Las Palmas and the conference.
to see more from my trips, subscribe to my channel...