Author Archive
The chemical wave !
The Chemical Brothers - Italia Wave
Well, the festival still have to "grow" … In Arezzo was something else, but I'm sure next year will already better. We were there mainly for the Chemical Brothers but we also got some other cool artists like Bugo and Sud Sound System.
We also went at the Elettrowave, the electronic side of the festival. The location couldn't be better: an old fortress by the sea !
Fortezza Vecchia - Livorno - Via Flickr thanks to livornoalone
See you next year Livorno !
PS : Someone told me that the tower of the "Fortezza Vecchia" in Livorno is taller than the tower of Pisa. Is it true ?
Marcus Miller – EstivalJazz 2008
Marcus Miller - Estivaljazz '08 - Lugano - Picture by Andrea Perotti via Flickr
Yesterday I went up to Chiasso directly after work, there I met Sma and we went together to Lugano to see Marcus Miller playing at Estivaljazz 2008.
Great show, we also managed to sit in front of the stage. The clarinet/saxophone player on the left was my hero, he was moving like a spring while blowing like hell and was the only one who could compete with Miller. Alex Han his name, and 20 his age !
So, if you pass by Lugano the first weekend of July don't forget about the EstivalJazz !
PS: As usual I didn't have any camera with me. I took the picture from Flickr, here the complete gallery » –
Automatic vHost with Apache
In my development machine i wanted to have a specific vHost for each project. Something that would allow me to type URL like:
- http://wordpress-test1.lan/
- http://phpmyadmin.lan/
- http://project1.lan/
I started to set for each one a vHost in Apache but after a while I've found myself with too many vHost files.
So I started to search for a more easy and fast way, and here it is:
Note: you need to install Apache mod_rewrite to make things work.
Preamble:
- You have Apache installed, and your DocumentRoot is /var/www/
- You have mod_rewrite installed and enabled
- You can modify the /etc/hosts file
Let's say we want to install a test/demo version of Wordpress and access it from the URL http://wp-test.lan/
- We download and untar Wordpress in /var/www/wp-test/
- We tell our machine to resolve the domain wp-test.lan with the IP 127.0.0.1. To make this we add a line to our hosts file.
hpatoio@namazu:~$ sudo su -
[sudo] password for hpatoio:
root@namazu:~#echo "127.0.0.1 wp-test.lan" >> /etc/hosts
root@namazu:~#exit
hpatoio@namazu:~$ - Now we have to change Apache config. Open /etc/apache2/sites-anabled/000-default with your favorite editor and add these lines inside the <VirtualHost *> directive:
RewriteEngine onBasically :
RewriteCond %{HTTP_HOST} ^([^.]+)\.lan$
RewriteRule ^(.+)$ /%1$1- The first line turns the mod_rewrite on
- The second one tells Apache to keep in the host part of the URL (HTTP_HOST) everything that stands before ".lan"
- Finally the third line insert the string matched before (%1) between the host and the resource part (directory + file + query string) of the requested URL
- Restart Apache
hpatoio@namazu:~$sudo /etc/init.d/apache2 restart
Now if open your browser and you point it to the URL http://wp-test.lan/ you should see the WP installation page. Right ?
Critical Mass Lecco
It has to start somewhere,
it has to start sometime !
Which better place than here ?
Which better time than now ?
Critical Mass Lecco 2008
Clusone '07
Giusy, Kathrin and me. Thanks to Adeline (on the other side of the camera
Like the last 4 years, few days ago, I was in Clusone for the Estate di S.Martino, I love this village and the feeling you get during the happening. Lovely wine, traditional food and true friends … need more to be happy ?
If the next year you wanna come mark this site: www.bandabidu.org.
CSV export from MySQL
If you have access on the machine with MySQL and you need to export all tables in a database you can use:
hpatoio@namazu:~$ mysqldump -uroot -p DATABASE_NAME -T '/home/simone/export_csv' --fields-terminated-by "," --fields-enclosed-by '"' --lines-terminated-by "\n"
the script will create a files for each table of the DB and will place it in export_csv.
If you need to export a custom resultset or you need to export data from a remote MySQL server on your machine you can use this command :
hpatoio@namazu:~$ mysql -uroot -h HOSTNAME -p DATABASE_NAME -B -e "select field1,field2 ... fieldX from \`TABLE_NAME\`;" | sed 's/\t/","/g;s/^/"/;s/$/"/;s/\n//g' > my_export.csv
Microsoft Access to MySQL | Online converter
Amazing online tool to convert MDB Microsoft Access file to MySQL SQL scripts !
Check it out -> http://www.mdb2mysql.com/
Good times
Joelle and I
And also for this year my vacations are finished. Many people I've met on the way … some were already friends, some were new 
.
I could write for hours trying to tell you who I meet and where I was, but, as you probably know I'm not good in telling stories.
So just wanna say thanks to : Jan, Rebekka, Bugo, Vale, Gio, Anca (even if it didn't work), Joelle and all the people at the NEVA meeting, Linnea, Kenneth and all the Tjärnkvist family, Karsten, Liga, the lovely people in Ultervattnet, the backpackers at the Sunflower Hostel, Adam and of course to Swedish Police
Due I didn't have a camera with me there are no pictures of the vacations, except for this one …