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 http://wikicalc.monsite.com/wikicalccgi.pl and follow the instructions ....

Now you can play with this imressive spreedsheat

Sony Ericsson w810i and Linux

Despite all problems I had to stop my phone subscription at Orange , my new subscription will be an Orange one , after all, they are not so bad , my choice was a little quickly and I chose a Sony Ericsson w810i , I would have to check the compatibility of this telephone with Linux… Indeed I would like to be able to synchronize it with Kontact , 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

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… 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 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 but I seek and hope well to find a perfect solution

Tags: kandy, telephone, Sony, ericsson, w810i, kmobiletools, wammu, gammu, gnokii, gcalsync, kontact, kde, to synchronize

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:
http://www.adobe.com/go/fp9_update_b2_installer_linuxplugin
uncompress it and copy libflashplayer.so 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...

Tags: flash player, flash 9, linux, Firefox, Flex2.0

Close and manage file with vim

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

:q
to close vim
:q!
to close vim without recording the modifications
:w
to write the modification
:w [NEW_FILE]
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
:e!
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.
:version
display information about vim

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

Tags: vim, productivity, linux

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
11. Email-Worm.Win32.Warezov.do
12. Email-Worm.Win32.NetSky.aa
13. Email-Worm.Win32.NetSky.b
14. Net-Worm.Win32.Mytob.c
15. Trojan-Spy.HTML.Bankfraud.od
16. Email-Worm.Win32.Warezov.eu
17. Email-Worm.Win32.Warezov.gen
18. Email-Worm.Win32.Bagle.dx
19. Email-Worm.Win32.Warezov.dh
20. Email-Worm.Win32.Scano.aq
    

Some new players in the team: Warezov.dn, Warezov.ev, Warezov.dc, Warezov.do, Warezov.eu, Warezov.gen, Warezov.dh.
Some malwares which begin to extinguish: NetSky.b, Mytob.c, Bankfraud.od, Scano.aq. 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...)

Tags: antivirus, kapersky, clamwin, Norton, virus, worm, trojan, mail

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 config.py file with your username and password for Last.fm. That's it, now you can run the main script:
python main.py
you should see something like:
Starting LastFMProxy 1.1...
Connecting to last.fm server...
To tune in, point your browser to:
http://localhost:1881/
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 Last.fm: you need to go in Settings and that's it! You can now choose open a Last.fm 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

Tags: amarok, streamripper, lastfm, lastfmproxy, streaming, music

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)" ]
then
echo "You must be super-user to run this script."
exit 1
fi

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.