Introducing tellico2html

2018/10/18

First, let me give you that health news are as good as they can be (no more cancer cell found in latest scan I had). I’ll come back at work by end of this month, part time, but working again ! Now I can come back to what I was doing before ūüôā

Then as much as I love hearing and making music, I also love coding. And I had an issue to solve: I wanted to automate the generation of web pages from the database content I manage under tellico.

However, tellico is not providing what is needed to do that in a fully automatic mode, (while the interactive HTML export works fine) As shared on the tellico mailing list:

If I try from the CLI using the following command:

$ qdbus org.kde.tellico /Tellico org.kde.tellico.exportHTML Disques.html

I get the following error:

Error: org.freedesktop.DBus.Error.NoReply Did not receive a reply.

Probably the reply timeout expired due to a pretty big tc file (~ 3.8 MB)

Trying:

$ unzip -p Disques.tc | xsltproc /usr/share/tellico/tellico2html.xsl – > Disques2.html

works, but doesn’t generate the fields I want (I could trigger the xsl file for that) but more important doesn’t generate the individual html files per CD as with the graphical interface.

So no efficient to have what I need and put it in a cron.

Perl to the rescue ūüėČ and an opportunity to learn new perl modules. So I wrote the new tellico2html tool, I also announced on the tellico mailing-list, to solve that problem, and I now have an automatic generation of thousands of web pages for all the objects I manage with tellico, every night, allowing me to have a daily update of my internal web site with it.

You can test that yourself by following the recipe given in the README.md

Hope it will serve to others as well, so licensed under the AGPL v3.

And if you don’t understand anything to what I said, because you have no clue on what tellico can do, it’s really an ideal too lfor colelction management, and on my side, I use it *daily* and it has become a mandatory tool for me to manage CDs, Books, Comics, DVDs, even wine bottles !

Advertisements

Nouvelles de la semaine

2018/09/22

J’ai re√ßu pas mal de mails, autant de coll√®gues que d’amis ou de relations pour me demander des nouvelles alors voici les derni√®res !

En effet, cette semaine, c’√©tait la derni√®re s√©rie d’examens et de rendez-vous m√©dicaux pour statuer sur mon lymphome. Les r√©sultats de la mi-course √©taient encourageants, ceux de cette semaine confirment cela et me d√©clarent gu√©ri. Plus de cellules canc√©reuses visibles ni au scanner, ni √† la scintigraphie. Donc une bonne nouvelle pour moi ūüôā

Tout n’est pas compl√®tement fini pour autant, car je g√®re maintenant quelques effets secondaires (probl√®mes d’ongles tombant, de voix √©raill√©e que je contr√īle toujours pas compl√®tement, notamment dans le registre de t√©nor – l’alto allant plut√īt bien, et de fatigue r√©siduelle en diminution). Tout cela est normal apr√®s le traitement de chimio-th√©rapie que j’ai eu, et ces probl√®mes vont mettre quelques mois √† se r√©sorber, mais ce ne sont que des points mineurs par rapport au probl√®me principal qui lui a √©t√© soign√©.

Je suis encore arr√™t√© jusqu’au 26 octobre pour continuer √† r√©cup√©rer et √™tre en bonne forme pour reprendre le travail √† ce moment l√† en temps partiel th√©rapeutique (rythme adapt√© en fonction de mes capacit√©s √† absorber la charge). D’ici l√†, je continue √† faire de la musique comme je peux, et de coder autour de tellico en ce moment (plus dans un prochain article), avant de retourner √† mes projets libres principaux, puis mes activit√©s pour HPE qui m’a soutenu sans faillir durant cette p√©riode. Evidemment, cette issue favorable n’a √©t√© possible que par un travail remarquable du CHU de Grenoble dans l’√©quipe du Dr. Courby, l’abn√©gation et l’amour de ma femme, et le soutien de mes enfants qui ont rendu tout cela facile √† supporter, du moins autant que possible ūüėČ

 

La 29√®me acad√©mie de musique ancienne d’Etampes

2018/07/13

Puisqu’il faut que je me soigne, et comme il n’y avait pas de chimio cette semaine, j’ai pu participer √† ma 29√®me acad√©mie de musique ancienne d’Etampes, cr√©√©e par Jean Belliard, et maintenant dirig√©e par sa fille Laudine.

J’ai la chance d’y chanter un magnifique petit solo de t√©nor haut dans le Beatus Vir de Monteverdi, mais surtout 4 motets Renaissance (Josquin Desprez, Victoria, mes deux favoris, Morley et Palestrina) et j’ai de nouveau commis un diaporama qui semble avoir √©t√© bien re√ßu par les spectateurs de notre concert de ce soir. Je ne remercierai jamais assez B√©atrice ma femme et S√©gol√®ne ma fille pour l’aide apport√©e toute cette semaine, pour me permettre de participer dans les meilleures conditions et d’aller jusqu’au bout de mon envie d’augmenter le spectacle par cette projection.

Comment ? Vous ne saviez pas que nous faisions ce concert √† l’√©glise St Basile d’Etampes ce 13 juillet ? Venez vite vous rattraper en nous √©coutant soit le 14 juillet √† la Basilique de Longpont (91) ou encore ce dimanche 15 juillet en la magnifique abbaye de St Beno√ģt sur Loire (45) o√Ļ nous nous sommes produits de nombreuses fois d√©j√†, et qui attire, par la gr√Ęce de son lieu toujours un public de qualit√© … m√™me un jour de finale ūüėČ

Vous pourrez y assister √† un spectacle finalement rare en France, car la musique sacr√©e ancienne n’est pas tant chant√©e que cela, surtout par les amateurs, et dans ces conditions, avec un instrumentarium incroyable pour nous soutenir, ce serait dommage de manquer l’occasion annuelle de se replonger dans cette superbe musique des 15√®me aux 17√®me si√®cles.

On the right path

2018/06/25

Following the detection of my lymphoma, I’m right now in the middle of the treatment at the hospital and have passed recently a scintigraphy as a control, which doesn’t reveal any pack of cancer cells anymore, showing that the R-CHOP treatment I’m following is efficient.

So we go on, with a chemio every 14 days, up to begining of August where we’ll again make status. Goal being to eliminate remaining cancer cells that would not be seen by that type of exam.

Music is a good medicine for me and after our concert of Saturday, I now hope to participate to my 29th Academy of Early Music in Etampes, now directed by Laudine, the daughter of my master in sacred music Jean Belliard. And as music is also a family affair, I’ll be there with my wife and my first daughter (who will also take care of me !) and so it’ll be both a musical work and a familial pleasure, very beneficial for the cure of the lymphoma.

Evolution favorable

2018/06/24

Suite √† la d√©tection de mon lymphome, je suis actuellement au milieu de mon traitement au CHU de Grenoble et ai pass√© r√©cemment une Scintigraphie de contr√īle qui ne r√©v√®le plus d’amas canc√©reux visibles, montrant que le traitement R-Chop est efficace dans mon cas.

On continue donc ce traitement comme d’habitude, √† raison d’une chimio tous les 15 jours, jusqu’√† d√©but Ao√Ľt o√Ļ l’on refera un point. Il faut notamment √©radiquer ce qui pourrait encore rester et ne pas √™tre visible sur ce type d’examen.

La musique est un bon m√©dicament et aussi mon activit√© pr√©f√©r√©e de compensation, et apr√®s notre concert d’hier, j’esp√®re bien maintenant pouvoir participer √† ma 29√® acad√©mie de musique ancienne √† Etampes en Essonne dirig√©e maintenant par Laudine Belliard, la fille de mon ma√ģtre en musique sacr√©e, Jean Belliard. Car la musique est aussi une affaire de famille et j’y aurai le plaisir d’y √™tre avec ma femme et ma fille ain√©e (qui s’occuperont de moi comme un coq en p√Ęte, je le sais d’avance !) et ce sera donc un moment √† la fois de travail musical, et de plaisir familial, donc bien propice √† la r√©g√©n√©ration et √† la suite de la gu√©rison.

Un de mes m√©dicaments ;-)

2018/05/08

Il m’a souvent √©t√© dit que l’un des points les plus importants pour pouvoir gu√©rir est d’√™tre positif et de continuer √† avoir des activit√©s. Donc j’applique √† la lettre les conseils (rassurez-vous, je n’applique que ceux qui me plaisent ;-))

Donc pour ceux que cela int√©resse, l’ensemble vocal que j’anime donnera prochainement un concert. C’est un de mes m√©dicaments. Tous les d√©tails sur:
https://ensemblevariations.wordpress.com/2018/05/08/concert-le-2-juin-2018-a-leglise-de-biviers/

Some news

2018/05/03

For the second time, I’ll take some minutes to give you personal news.

Since early February 2018 I’ve had abdominal pain, reason for which I was unable to attend the big HPE event TES/TSS this year in Den Haag. After exams during these last months, I have a lymphoma (type B) which is in simpler words a cancer of some lymphatic glands.

The good news is that it can be cured and conditions seems to be met for that (at the step we’re of course). But for that I need to
“disappear” from the HPE scene and also weaken my participation to my other activities during the next 4 to 6 months to follow a cure based on chemotherapy, which started last week.

My main job during the next months to come is to cure. Of course, to succeed, I’ll need to rest, treatment, but also music (listening and practicing), computers (coding is so fun !) and more than ever the support of my family and friends, which is already there and will for sure help overcome this “annoyance”.

Chemotherapy started last week at the Grenoble University hospital, and I must confess I’m impressed by the quality of their work, as well as their capacity to take care of people (the extended team around Dr. Courby is just awesome). I won’t say I’m impatient to come back there (!), but I’m in the best hands possible so that everything works smoothly and for now, I don’t suffer from the potential negative symptoms (nausea, pain), just I’m tired , which is not abnormal.

So do not expect to see me that often around during that period, as especially my concentration capacity isn’t as good as before, which doesn’t
allow me to work a lot for now. I’m sorry to leave in particular the Open Source communities where I try to help, but believe me, I’ll try to stay
informed of news in that area as much as I can and I’ll be back ™ with renewed energy to continue wearing the FLOSS flag later this year with your help.

This article is the english version of the one posted in french earlier this week to allow nonfrench speakers to better understand my status.

Nouvelles récentes

2018/04/30

Pour une seconde fois, je souhaiterais prendre 2 minutes pour vous donner les dernières nouvelles me concernant.

Depuis F√©vrier 2018, je souffre de douleurs abdominales, raison pour laquelle je n’ai pu assister au grand √©v√©nement HPE TSS √† la Haye. Apr√®s des examens pass√©s ces derniers mois, je suis atteint d’un lymphome de type B (diffus √† grandes cellules variant centroblastique, de sous-type centro germinatif pour ceux que cela int√©resse !). En langage de tous les jours, c’est un cancer du ganglion abdominal et des glandes lymphatiques.

La bonne nouvelle est que cela se soigne, et que les conditions semblent r√©unies pour cela puisse bien se gu√©rir. Mais pour cela, il me faut “dispara√ģtre” d’HPE et aussi me mettre en retrait sur mes autres activit√©s pendant les prochains 4 √† 6 mois pour suivre une chimioth√©rapie qui a d√©marr√©e la semaine derni√®re. Mon travail principal de ces mois √† venir est de gu√©rir. Evidemment pour y arriver correctement, j’aurai besoin de repos, de soins mais aussi de musique (en √©couter, en faire), d’informatique (coder un peu!) et surtout du soutien des miens qui se manifeste en permanence et me permettra √† coup s√Ľr de passer ce moment p√©nible.

La chimioth√©rapie a commenc√© la semaine derni√®re au sein du CHU de Grenoble, et je dois dire que je suis impressionn√© par la qualit√© de leur travail, aussi bien que par leur qualit√© d’accompagnement (l’√©quipe √©tendue autour du Dr. Courby est remarquable). Je ne dirai pas que j’ai h√Ęte d’y retourner (!), mais je suis dans les meilleures mains possibles pour que cela se passe bien, et pour le moment, je n’ai pas les effets n√©gatifs potentiels d√©crits (naus√©es, douleurs), mais juste de la fatigue, ce est loin d’√™tre anormal.

Donc ne vous √©tonnez pas de ne pas me voir ou interagir autant qu’√† l’habitude durant cette p√©riode, j’ai en particulier moins de concentration que d’habitude, ce qui ne me permet pas de travailler correctement. D√©sol√© de vous laisser abruptement en cours de route, en particulier les communaut√©s Open Source o√Ļ j’essaie d’√™tre utile, mais je continuerai √† me tenir inform√©, y faire ce que je pourrai y faire avec mes moyens courants et j’esp√®re √™tre ensuite bien remis pour pouvoir continuer toutes nos activit√©s communes fin 2018 avec la m√™me envie et √©nergie qu’auparavant !

When your CentOS 7 install fails, anaconda in CLI to the rescue

2018/03/08

Ok, I know I’m always trying to do stuff a bit non-standard (No, running Mageia everywhere IS standard !!)

So this time, I wanted to update my CentOS 6 deployment server in Geneva to CentOS 7 and automate its setup with ansible (I already have some playbooks here to help).

The server is in a DMZ, with pretty strict security control, which normally isn’t an issue, but when eveything else fails…

Ok, so first yum update on that machine didn’t work. Lot’s of issues with that. Most of the messages you find on the net recommend to install another server in parallel. Fine, but this is not a VM, but a real machine (HPE ProLiant DL 180 Gen9) and I don’t have another one ! So I tried to update some packages manually. To make a long story short, glibc updated, but after that nothing worked as you enter in a nightmare with incorrect paths (they put everything under /usr in CentOS 7, so all /bin or /sbin binaries were not working anymore). Ok, so I had to reinstall the machine as no other method could rescue the situation, hopefully keeping my /prj FS safe.

So you use the marvelous Virtual Media feature of your server in order to mount a local ISO image on your system as a local CD of your remotely managed machine. So you download your CentOS 7 DVD latest version and try that. But it doesn’t work. Once again systemd fails to do something (logind launch in that case), and after that nothing works ūüė¶ Did I say already I hate systemd ? And even more the people behind it who think they are always right because it just works for them ūüė¶

After trying multiple things, I found out that CentOS 7.3 was going further on that system, so worked with that. Further meaning I was able to get a shell, but the graphical interface never wanted to launch. And using inst.vnc is not an option due to firewalling restrictions I can’t change on my end. Using inst.sshd was one way to have a working remote access. So I used that and tried to launch anaconda manually.

I used the text mode version, but it wasn’t able to reuse my existing partioning schema, as I found out. Yes, because I’m picky (I know !) on partitioning schema, and that machine had to use md RAID devices in parallel with normal partitions, and LVM on top + ext4 FS as that’s what I want (why do you want to use Linux, if the system dictates to you what to use !! then use Windows instead :-). And I wanted to keep some existing partitions safe. But launching anaconda manually didn’t take in account my existing partitioning schema (or I didn’t find how, in text mode you don’t get much help) so I lost everything on the server, without any warning concerning partitions ūüė¶ So back to backups then.

Ok so now I really have a new install to make, but still with the same partitioning schema. So I decided to create a kickstart for the machine, which would contain that partitioning schema so anaconda could use it (and get the rest of the conf at the same time).

The partitioning shema is as follow (nothing fancy, but nos completely standard either):

part /boot/efi --fstype=efi --ondisk=sda --size=200
part /boot --fstype=ext4 --ondisk=sda --size=500
part /tmp --fstype=ext4 --ondisk=sdb --size=700
part raid.01 --ondisk=sda --grow --size=200
part raid.02 --ondisk=sdb --grow --size=200

raid pv.01 --fstype ext4 --device pv.01 --level=RAID1 raid.01 raid.02
volgroup vg_dl180 --pesize=4096 pv.01
logvol / --fstype=ext4 --name=lv_root --vgname=vg_dl180 --size=40000
logvol /var --fstype=ext4 --name=lv_var --vgname=vg_dl180 --size=10000
logvol swap --name=lv_swap --vgname=vg_dl180 --size=4000
logvol /prj --fstype=ext4 --name=lv_prj --vgname=vg_dl180 --size=520 --grow

Now I don’t want to burn a new DVD to put the ks file on it, so I thought, let’s use the network.

But the instructions which tell you that you can use an instruction to set up the network statically (I have no DHCP server as this server will become the DHCP server of this LAN !) on your system forget one point. If you use ip=IPaddr::GW:NM:… and also inst.ks=http://somewhere/x.ks then the IP is put in DHCP mode automagically :-((

Ok, so now looking at the boot logs, I see that it tries to download the ks file, but can’t because it didn’t get the IP address through DHCP which is why I wanted to pass a static IP conf to it !!!

So you can’t use the inst.ks option, if you need static IP. In fact this is written but in the ip documentation. So let’s do that. You boot again (on my ADSL connection, it’s 30′ each time you try something so we’re 2 days after the start of course) and get to a shell with the IP setup correctly, but no ks file.

And I don’t have anything on that LAN of course, to share with http or NFS. So let’s find a way. Use https://file.io ! You can upload there a text file like the ks file, and get a URL so you can download it with wget in your shell ! (you need to setup the nameserver with the nameserver= option at boot time, or adapt your /etc/resolv.conf locally).

So now I have an IP conf, a local repo (seen as a CD) and the ks file !! I just now need to find a way to say to anaconda to use it. The useful doc can be found on the Fedora Wiki. Ok, not very detailed, but enough for me to try !

I needed to launch it with:
anaconda --text --kickstartfile=file.ks

I had to interactively change the source repo, as I had given a URL in the ks file, but for a reason it didn’t seem to work, so I pointed to the local CD instead (slower as the Virtual media was getting the content of CentOS through my ADSL link, and in that sense, it’s slow ! Luckily I only had 300 packages to install). I also had to setup a simple account (just in case)

And then it worked ! it took time, but worked ! It built my partition schema the way I wanted, and installed everything, including the boot loader correctly (was a UEFI conf).

So next time I’ll be stuck by anaconda not starting graphically, I know what to do, and hopefully you too ūüôā

Next step is to automate its configuration, and capture that so I can present it during the upcoming HPE TSS event in Den Haag !

Recrutement d’un ou d’une Chef de projet de migration √† Libre Office

2018/03/05

From: COMPARAT Laurence <laurence.comparat@grenoble.fr>
Date: 2018-03-04 14:30 GMT+01:00

Bonjour,

Je vous remercie de faire circuler cette information dans vos réseaux :

La Ville de Grenoble recrute, via son service commun avec la Métropole et le CCAS, un.e Chef.fe de projet migration à Libre Office :

https://www.lametro.fr/offre/161/23-cdd-3-ans-chef-de-projet-migration-a-libre-office.htm

Cordialement,

Laurence Comparat

*”Sauvons la libert√© par notre fraternit√©, la libert√© sauvera le reste.”
Victor Hugo.*

Adjointe au Maire – Ville de Grenoble
Acc√®s √† l’information et lib√©ration des donn√©es publiques
Utilisation et diffusion des logiciels libres ‚Äď Administration g√©n√©rale
Secrétariat : 04 76 76 38 53