Sunday, June 08, 2008

Howto install Wikicalc on a Debian server

As I indicated in my last post: WikiCalc is a collaborative spreadsheet operating on the principle of wiki. It is completely written in Perl. To install Wikicalc, nothing more simple, just start by installing the necessary tools for your good old Debian:
apt-get install apache2 libapache2-mod-perl2
Then download sources: wikicalc-1-0.tar.gz. Then can begin the installation process itself:
cd /var/www
tar xvzf wikicalc-1-0.tar.gz
ln -s wikicalc-1-0 wikicalc

Now you have to let the Wikicalc engine to be accessible from your Web server: compared to the configuration by default, you just need to add these few lines :

NameVirtualHost *

ServerAdmin webmaster@localhost

DocumentRoot /var/www/wikicalc/

Options FollowSymLinks
AllowOverride None

Options Indexes FollowSymLinks MultiViews ExecCGI
AddHandler cgi-script .cgi .pl
AllowOverride None
Order allow,deny
allow from all

Load Perl module:
a2enmod perl
restart /etc/init.d/apache2

To finish the installation, go to and follow the instructions ....

Now you can play with this imressive spreedsheat

Thursday, February 15, 2007

Sony Ericsson w810i and Linux

Despite all problems I had to stop my phone subscription at Orange twisted, my new subscription will be an Orange one biggrin, after all, they are not so bad lol, my choice was a little quickly and I chose a Sony Ericsson w810i wink, I would have to check the compatibility of this telephone with Linux… Indeed I would like to be able to synchronize it with Kontact razz, in particular the calendar, To-do and the list of contacts… If like me you have large fingers: the keyboard of the portable telephone can be for you a nightmare rolleyes

The good point of Sony Ericsson w810i is that it is provided with a USB cable to connect it with your PC, when it is connected, two modes are available:

  1. File transfer
  2. phone mode
The “File transfer” mode allows you to transfer the data from your mobile phone to Linux. But I have not yet succeed to make the contrary… sad The phone mode can be used with Kmobiltools to see contacts, the SMS sent and receives, to telephone and send SMS. But I still did not find the ultimate tool allowing me to synchronize my mobile phone with my KDE rolleyes with the USB link, for that I am testing some software:
  1. Kandy: hmmm… that does not work!
  2. Kmobiletools: works very well but it is not what I am looking for
  3. Wammu/Gammu: the X interface is very ugly but this software seems to works well when it does not freeze
  4. Gnokii: command line tool and requires to create yourself a configuration file. Kontact uses this tool by default, but that does not work very well
  5. GCALSYNC: that deviates a little my wired vision of a local synchronisation, but that will at least enable me to manage correctly my schedule.
For the moment I am reduce to synchronize my telephone under Windows… and synchronise Windows with Linux… this is not the universal panacea evil but I seek and hope well to find a perfect solution

Saturday, December 02, 2006

Flash Player 9 and Linux

YES, now I will be able to play to the games written in Flash and to enjoy the new web sites based on Flex2.0. This time, it is as easy as pie to install : just download the plugin from this adress:
uncompress it and copy in your user's directory of plugins of Mozilla: it must be something as: ~/.mozilla/plugins/ ... Restart it, and now you are ready for web site based on flash (you can test the MacDo's game). And now enjoy the beauty of flash...

Wednesday, November 29, 2006

Close and manage file with vim

Let's continue with the best practice of the vim software:

to close vim
to close vim without recording the modifications
to write the modification
to write the file you are editing in NEW_FILE
:w! [FILE]
it is the same action as before but you force the action
:n,mw [FILE]
save the lines from n to m in the file FILE
:n,mw >>[FILE]
add the lines from n to m at the end of the file FILE
:wq ou :x ou ZZ
Save the file and close vim
edit the file again but with the version on the disk
:e [FILE]
edit the file FILE rather than the current file (:e! to force the action)
:r [FILE]
insert the file FILE after the current line
:rn [FILE] ou :nr [FILE]
insert the file FILE after the line n
n is either a number, or . for the current line, or $ for the last line.
display information about vim

it should be enough today to play a little and increase your productivity lol ;-)

Saturday, November 11, 2006

Kapersky and the 20 viruses

Kaspersky has just published its list of the top 20 malwaress (Virus/Trojan/Worm/...) spreaded by mail. As a consequence, in the case you see those little creature: don't click on them, don't try to play with them...
  1. Email-Worm.Win32.NetSky.q
  2. Email-Worm.Win32.Warezov.dn
  3. Email-Worm.Win32.Bagle.gen
  4. Email-Worm.Win32.Scano.gen
  5. Email-Worm.Win32.Warezov.ev
  6. Email-Worm.Win32.Bagle.mail
  7. Email-Worm.Win32.Warezov.dc
  8. Email-Worm.Win32.Mydoom.l
  9. Email-Worm.Win32.Mydoom.m
  10. Email-Worm.Win32.Scano.e
  12. Email-Worm.Win32.NetSky.aa
  13. Email-Worm.Win32.NetSky.b
  14. Net-Worm.Win32.Mytob.c
  15. Trojan-Spy.HTML.Bankfraud.od
  17. Email-Worm.Win32.Warezov.gen
  18. Email-Worm.Win32.Bagle.dx
  19. Email-Worm.Win32.Warezov.dh
Some new players in the team: Warezov.dn, Warezov.ev, Warezov.dc,,, Warezov.gen, Warezov.dh.
Some malwares which begin to extinguish: NetSky.b, Mytob.c, Bankfraud.od, Unfortunately we can notice the return of: NetSky.q, Bagle.gen, Bagle.mail, Mydoom.l, Mydoom.m, Scano.e, NetSky.aa, Bagle.dx, this means that some people don't have an uptodate antivirus, as a consequence they are infected and spread the threat! So install an antivirus if you haven't one already and ensure that it is uptodate (not only Kapersky, but Norton too, or ClamWin...)

Friday, November 03, 2006

LastFMproxy, Streamripper and Amarok

I have recently discovered Lastfm, the community radio. It is a great thing just give it the name of some artists you like and it will gather musics of this artists or similar artists... After that you can be a little more specific and say if you like the music or if you want to ban it! Most of the time the choices are excellent and they are becoming more and more relevant with the time and your selection. If you want to read the lastfm flux in one of your old player on linux, you should try lastfmproxy (you can find it here ), just uncompress the archive with this command:
tar -xvzf lastfmproxy-1.1.tar.gz
then go inside the directory you have just created, modify the file with your username and password for That's it, now you can run the main script:
you should see something like:
Starting LastFMProxy 1.1...
Connecting to server...
To tune in, point your browser to:
The last line stand to give you the url you can listen in your old player... So start it and open this url. That's working ;-) Great.
In all the previous part I said "old player", it is because with the great player of linux: Amarok, you can directly play you need to go in Settings and that's it! You can now choose open a flux! Enjoy.
You probably wonder why I told you about LastFmproxy if you don't need it to play LastFM if you use Amarok... It is because there is a little trick: if you listen LastFM, you only listen it, when you shut down your computer, or when the music is finished, there is no way to listen it again! So let install streamripper to record all this music on your computer. First of all you should only record music with a copy left, otherwise you are out of law! Now start lastfmproxy as explained before. And type this little command:
streamripper http://localhost:1881/lastfm.mp3 -d /home/mynqme/mydirectory -r
you can notice 3 arguments:
the radio you want to listen and record
the directory in which you will save music
the last argument will let you listen the music you are recording.
Launch the command, go to Amarok and open the url http://localhost:8000
That's it you can listen and record music on LastFM

Tuesday, October 17, 2006

How to verify the root user id on SUN?

If you program sometimes on Sun Solaris, you have probably noticed that the syntax is not always the same as the one of Linux, or HP-Unix... This time, before running my script I had to verify that it is root, who runs the script: after 30 minutes of headhache, I finally find a way: enjoy the aspirin

WHO=`id | cut -f1 -d" "`
if [ ! "$WHO" = "uid=0(root)" ]


echo "You must be super-user to run this script."

exit 1


How to get rid of output of your scripts?

Just add at the end of your command line: >/dev/null 2>&1 so you redirect fd1 to /dev/null, then dump it onto fd2:

Normally: fd1 -> stdout fd2 -> stderr

>/dev/null: fd1 -> /dev/null fd2 -> stdout

2>&1: fd1 -> /dev/null fd2 -> /dev/null

Now no more output, it is very interessant espscially for cronjob.