Skip to main content


Showing posts from 2014

Archlinux MySQL Workbench result grid

Introduction I run ArchLinux for a while and one of my key software is MySQL Workbench.
Unfortunately, I did not get it working for a while.
Dont worry, it's working now, and this is my attempt to collect the informations in order to try to know what happenned.

What did not work Several week after having a base Archlinux installation working, I managed to install MySQL Workbench from AUR.

The software behaved correctly except the result grid never displayed: I just got a blank grid, but when switching to the edit form the data were there. Data have been correctly retrieved and can be edited, but the problem was on the result grid display.

It was version 6.1.6 at that time, arround the end of June 2014.
I recompiled "mysql-connector-c++", "ctemplates" before building mysql-workbench: no way, no result grid.

I even tried to compile Mysql Workbench development version (6.2 at that time) against AUR  "mysql-connector-c++", "ctemplates" but no w…

Madagascar OpenData en phase de consultation

Le gouvernement malgache est en train de s'interesser à l'ouverture des données publiques:  Voici le calendrier des évènements:
Je pense que ça peut interesser plusieurs personnes (physiques et morales) alors je diffuse.
Noter que j'ai reçu l'invitation le 30 juillet, via le GOTICOM, c'est un peu tard pour participer aux premières séances, mais celles qui m'interessent le plus sont les dernières.

Archlinux installation notes

Introduction I switched to Arch Linux, a totally new distribution for me, and these are some tips I had to perform in order the make things work.
InstallationThe installation guide page is quite clear. It's a step by step set of instruction an intermediate Linux user may blindly follow.
The only thing I missed is the syntax of "/etc/vconsole.conf", in order to get my french keyboard considered. Instead of having it on another page, I'd rather it would be in this page.
Pidgin At work we need Pidgin with the support of Sametime. I had to recompile it from ABS, and compile the "meanwhile" utilities from AUR.
The Pidgin wiki page misses the indication that libpurple-meanwhile has to be installed with meanwhile.
Modem I choosed to have my network managed with NetworkManager.
As described on the guide, the installation instructions miss the step to enable the NetworkManager service at boot.
I had my EVDO ZTE Modem unrecognized until the service was started.

Debian automated installation equivalent to kickstart on CentOS

In the RedHat world and its derivative, after installing a system you usually get a file named “/root/install.ks”. This is not the case in the Debian world, but I think I found a way to get a “dump” of the answaers I provided in the installation process:
### Preseeding other packages# Depending on what software you choose to install, or if things go wrong# during the installation process, it's possible that other questions may# be asked. You can preseed those too, of course. To get a list of every# possible question that could be asked during an install, do an# installation, and then run these commands:# debconf-get-selections --installer > file# debconf-get-selections >> file
 I took that from

Batch editing LDAP passwords

I need to implement a groupware for my organisation. In order to achieve this, I need to test each user login, and make some interaction tests, espacially for free/busy features of the calendar. The authencation is against an LDAP server. I need to copy the LDAP server and batch modify the passwords to be all the same in my test environment. In order to achieve this, I need to list all “dn” and modify the “userPassword” value.
This is done in two steps:
ldapsearch -w 'admin-password' \ -x -D 'cn=admin,dc=rktmb,dc=org' \ -b 'ou=Users,dc=rktmb,dc=org' \ -s one \ -H ldap://localhost dn
To list the users ldapsearch -w 'admin-password' \ -x -D 'cn=admin,dc=rktmb,dc=org' \ -b 'ou=Users,dc=rktmb,dc=org' \ -s one \ -H ldap://localhost dn \ | awk '/^dn: /{print $0"\nchangetype: modify \nreplace: userPassword …

Installation Tomcat 7 Solr 4 par JNDI sur CentOS 6

Contexte Pour des sites à nombre élevé de contenu, il peut être une solution de s'aider de Solr pour l'indexation du contenu et rapidifier les recherches. Pour cela il faut installer Tomcat et ajouter certains modules à l'installation de Drupal. Ceci agrémenté d'une configuration. Il existe une documentation d'installation de Solr mais basée sur Tomcat 6. C'est un Wiki, donc en théorie je devrais pouvoir contribuer, mais avant, je publie la version française sur mon blog.
Installer Tomcat 7 On choisi le répertoire “/opt/tomcat/” comme racine La version choisie est la dernière sortie à l'écriture de ce document. La distribution binaire proposée par le site de Tomcat convient très bien pour cet exercice. Les répertoires dont on va se servir sont /opt/tomcat/conf/Catalina/localhost/ /opt/tomcat/lib/
Installer Solr Solr est téléchargeable depuis son site Web. On a à disposition une archive “.tar.gz”. On n'aura pas besoin de tout son contenu, mais maulheur…

Exim 4 Client Authentication on CentOS 6

I want my Exim 4 MTA to use another host as SmartHost. The remote SmartHost requires authentication, but on port 25.
The procedure is to Disable direct delivery by looking up MX DNS record (dnslookup section) Enable SmartHosting (by telling it to use remote_msa transport) Ajusting remote SMTP settings (remote_msa section) Setup client authentication
To achieve this, the configuration should be (yes, you comment the whole section):
#dnslookup: # driver = dnslookup # domains = ! +local_domains # transport = remote_smtp # ignore_target_hosts = : # no_more
smarthost: driver = manualroute domains = ! +local_domains transport = remote_msa route_data = no_more

Then remote_msa: driver = smtp port = 25 hosts_require_auth = *
client_auth: driver = plaintext public_name = LOGIN client_send = : test : P@ssw0rd
Note that the default Exim configuration suggests CRAM-MD5 authentication method, but my example g…