Password-less unattended CVS+SSH sessions

You may have the need some day to issue CVS commands (same stands for SVN I think) using the SSH connection (such as CVS_RSH=ssh and so on) in a crontab. The problem may be that you need to type a password to get granted the SSH connection. With SSH public keys and ssh-agent it’s easy, but in a crontab, that will no longer work 🙁

It’s pretty easy… well… doable at least 😉

The trick is to launch the CVS commands with a “ssh” script in the PATH, which will be something like this :

#! /bin/sh

export SSH_ASKPASS=/whereveryouwant/my-ssh-askpass
export DISPLAY=:0
unset TERM
exec setsid /usr/bin/ssh $*

and where the my-ssh-askpass script will simply do :
#! /bin/sh
echo yourpreferredpassword

Hope this helps 🙂

Article “Le logiciel libre en voie de reconnaissance mondiale” dans la banque des savoirs de l’Essonne

Le logiciel libre en voie de reconnaissance mondiale, est le titre de l’article de La banque des savoirs de l’Essonne, à la Une en ce moment, pour lequel j’ai contribué en tant qu’expert du sujet.

La banque des savoirs de l’Essonne est un site de vulgarisation scientifique, qui s’appuie notamment sur l’expertise des enseignants et chercheurs qui travaillent en Éssonne.

Plus de détails sur la première page de l’article.

P.S.: une mention de PicoForge, sur laquelle nous travaillons au mileu de quelques références prestigieuses de l’actualité du Libre, c’est bien, mais je n’y suis pour rien ;)… enfin, si ça nous fait un peu connaître, je ne me plaindrai pas 😉

Web2.0 workshop ahead in Rennes in early July

I’ll be visiting Rennes (France) in early July for the « Les étés TIC de Bretagne » conference/workshop, which promise 3 days of gathering around Internet and Web2.0 usages in Britanny.

This will be an oportunity for our Contrib 2.0 project to have a workshop, and advance a bit more our research agenda.

In between, I’ll have xen setup to demonstrate some novelties of PicoForge, I hope.

Scripting mysql database backups on phpMyadmin with CURL

Sometimes, you can only access your MySQL database with phpMyadmin (the previous tool I blogged about won’t be helpful, then). But you may wish to backup the database on a regular way.

PhpMyadmin allows you to backup the database, but you may like to do it in an unattended way.

I’ve written a shell-script which will use CURL to do so.

I couldn’t find any such script… so I hope I didn’t reinvent the wheel 😉

Update 2008/04/15 : I have made some modifications to the script, and it is now in SVN. You may grab a copy from the picoforge project’s websvn.