Archive for December, 2008
Friday, December 12th, 2008
Found this by chance after looooong dig on the 'Net, therefore reporting here since it's as simple as efficient! 1. Make a smart playlist called “All Files” with this rule: “Artist” is not “123456789″ (or any nonsense name that won’t be in your library). 2. Make a static playlist called ...
Posted in iTunes | No Comments »
Wednesday, December 10th, 2008
It happens sometimes that due to database migration, you see spurious characters in MySQL tables and you would like to intervene massively (thick for instance to forums) and replace them with proper characters. Luckily this is easily doable if you manage to have connection to DB with command line ...
Posted in SQL | 1 Comment »
Wednesday, December 10th, 2008
This is happening, for instance, when moving a Virtual Machine from one Server to another or when changing the physical network adapter of a server. The reason is that NIC's MAC Address changes, therefore Linux perform a new HW detection and creates new adapter definition, ending in situation where ...
Posted in linux | No Comments »
Tuesday, December 9th, 2008
I've finally managed to get this working, so now I need to write some note in case I have to redo it in the future :) This is short howto about enabling https and multiple virtual hosts on Apache 2.0. Much of the instructions are copypasted from Debian ...
Posted in apache, linux, openssl | No Comments »
Friday, December 5th, 2008
Once you have access to DB, the SQL string is: DELETE FROM phpbb_users WHERE user_active=0 AND user_id>0 This will cleanup all the users marked as non active, thus most likely spam.
Posted in SQL | No Comments »
