A very strange error occured during reboot of my server (just after apt-get upgrade):

error: ‘Access denied for user ‘debian-sys-maint’@’localhost’
(using password: YES)’

After some search on the web, I found the solution.

The debian_sys_maint user is the one used by mysql user system under debian sytems. In order to fix this (seeming to be a grant error) do like this:
Save the password of debian_sys_maint user which is localized in /etc/mysql/debian.cnf file (readable only by root):

sudo more /etc/mysql/debian.cnf

The file is in following format:

# Automatically generated for Debian scripts. DO NOT TOUCH!
[client]
host = localhost
user = debian-sys-maint
password = ftL7po8KaZD4Vh0a <= The debian user system password
socket = /var/run/mysqld/mysqld.sock
[mysql_upgrade]
user = debian-sys-maint
password = ftL7po8KaZD4Vh0a
socket = /var/run/mysqld/mysqld.sock
basedir = /usr

Save somewhere this password, then connect on mysql under root:

mysql -u root -p

and execute following command:

mysql > GRANT ALL PRIVILEGES ON *.* TO ‘debian-sys-maint’@'localhost’
IDENTIFIED BY ‘your_password’ WITH GRANT OPTION;

And should be OK now.

Article translated from “Chérie, je l’appelle comment mon blog ? ”

Today, I put an internal multicard reader on my principal workstation.

It’s look like that:

and it allows to read several storage card like SD, MMC, Compact Flash.

Its setup is no really difficult… if you know 2 or 3 things

First: this hardware must be pluged on the USB ports of the motherboard which looks like that:

Please note the color sequence: red - white - green - black

Once plugged, the kernel must be configured like that:

Device Drivers —>
SCSI device support —>
<*> SCSI device support
<*> SCSI disk support
<*> SCSI generic support
[*] Probe all LUNs on each SCSI device
USB support —>
<*> Support for Host-side USB
<*> EHCI HCD (USB 2.0) support
<*> OHCI HCD support
<*> UHCI HCD (most Intel and Via) support
<*> USB Mass Storage support

I insist on the 4th option (Probe all LUNs etc.) which is fundamental to be able to manage several cards on the same USB port.

The device files created will be something like that: /dev/hdb1, hdc1, hdd1 etc.

What look like two Parisians on Sunday?

There was “La chanson du dimanche”, the weekly video you can watch on there website: http://www.lachansondudimanche.com/

.

These days, I listen, once again, the full version of Starmania (Tycoon project for English spokers), the Rock Opera written by Michel Berger and Luc Plamondon in 1978. Yes… nearly 30 years ago. We can easily think this production becomes old-fashioned. Maybe… However it will be a pleasure to tell you the story.

It takes place in the future. People left country to populate the large city like Monopolis: the great capital of Occident with its miles of undergrounds. This concentration of people brings, of course, a lot of criminality.

Quand tout l’monde dort tranquille
Dans les banlieues dortoir
C’est l’heure où les zonards
Descendent sur la ville
Qui est-ce qui viole les filles
Le soir dans les parkings ?
Qui met l’feu aux buildings ?
C’est toujours les zonards
“Quand on arrive en ville” Daniel Balavoine

Soon, it is the election day of the President of Occident! Through applicants: Zéro Janvier! A business man whose the press give a lot of media coverage to. He recently became the leader of the PPP party: “Parti Pris Pour le Progrès”. He advocates an atomic world: a modern and secured life.

Pour enrayer la nouvelle vague terroriste
Nous prendrons des mesures extrémistes
Nous imposerons le retour à l’ordre
Si on ne peut pas vivre dans la concorde
Nous mettrons la capitale
Sous la loi martiale
“Le meeting de Zéro Janvier” Etienne Chicot

Fortunately, everything is not so sad. A simple broadcast of Capital TV gives a ray of light in everyone’s heart: Starmania! Animated by “Cristal”, it is a real TV where everyone can appear in TV and know its 15 minutes of fame. This broadcast make people miss there life.

Voici maintenant
L’émission préférée
Des jeunes de tout âge
L’émission numéro un
Dans tous les sondages
Starmania - Starmania
Présentée par Cristal
Le sourire de Télé Capitale
“Starmania Starmania” La speakerine

During the electoral campaign, Zéro Janvier put is private life on the public level. Actually, he announce its future marriage with Stella Spotlight, a very famous ex-movie star. Everything is not pink for them but this couple help each other: the first one has a human image of himself for electors, the second will not be missed by public.

Stella Spotlight (Diane Dufresne)
Moi j’suis avec toi parce que tu m’fais du bien
Toi tu t’sers de moi pour arriver à tes fins
Zéro Janvier (Etienne Chicot)
Faut pas mélanger l’amour et le métier
On fait tout c’qu’on peut pour pouvoir se rendre heureux

I will not reveal you the end of the story, but I can say during all the spectacle, we can see the conflict between the “Etoiles Noires”, terrorist and/or anarchist group, against Zéro Janvier, a conservative politician, until the election results.

Voici maintenant
Le moment de la victoire
Zéro Janvier
L’homme qui est à mes côtés
Mesdames Messieurs
Vous ne voudrez pas y croire
Mes après c’est vous
Qui avaient votés
“La victoire de Zéro Janvier” Nanette Workman

I remind this fiction has been written in 1978, nearly 30 years ago. So characters, places, and incidents are either the product of the author’s imagination or are used fictitiously, and any resemblance to actual persons, living or dead, events or locales is entirely coincidental.

Links:
http://starm.free.fr/sitestarm/ a very whole website about Starmania (story, songs texts, characters etc.)

.

XiaoXiao

You certainly remenber the first appearance  of the stickman in Xiaoxiao. Alan Becker make him relive with…

Animator vs animation - the victim

Animation vs Animator II - The revenge of the Chosen One!

This article will be written in English, eventually to be readable by the maintainers of the development I’ll talk about. Sorry for the French speakers and, especially, for the English speakers for my terrible poor language practice.
So, like my frequently users know, this homepage is made with Wordpress and Gallery for the photos. Both of them are linked by a plugin called WPG2. I found last week a great module for gallery2 => GMAP module.

It is a module which allow to retrieve EXIF GPS data from picture and to embed a Google Map in Gallery in order to show the place the photo has been taken.

Unfortunately, after install, the plugin didn’t work… very well. Pictures were located under Africa (in spite of I do not remember Italy was so far), lot of pages failed (with indigestible error messages) etc.

After few nights remembering my far PHP knowledge and discovering the evolution of coding during my inactive development period (the object oriented concept is now strongly embed in PHP), I debugged the functionalities I wanted.

I do not support the idea my improvement are perfect or universal (eg. I circumvented a switch to detect the GPS coordinates format to put my own reading coordinates algorithm) but maybe it can help some users to make GMAP module working or maintainers to unblock the subversion files.

In all case, I provide my modifications first to save and eventually reapply them after a apti-get update of my server.

In modules/map/MapGroupAdmin.inc AND modules/map/MapRouteAdmin.inc (exactly the same modification)

Put these two lines in comment

GalleryCoreApi::requireOnce(’modules/core/classes/helpers/GalleryPermissionHelper_medium.class’);
list($ret,$perms)=GalleryPermissionHelper_medium::fetchPermissionsForItems($ids,$gallery->getActiveUserId());
And add these ones instead

GalleryCoreApi::requireOnce(’modules/core/classes/helpers/GalleryPermissionHelper_advanced.class’);
list($ret,$perms)=GalleryPermissionHelper_advanced::fetchAllPermissionsForItem($ids);

The GalleryPermissionHelper_medium class does not (no longer ?) exists, I had to adapt function with GalleryPermission_Helper_advanced one. Note this modification must be done in the two files with the same way.

In modules/map/MapSiteAdmin.inc

Find these two lines:

$lat = explode(" ",str_replace(",",".",$exifData[$id]['GPS/Latitude']['value']));

$lon = explode(" ",str_replace(",",".",$exifData[$id]['GPS/Longitude']['value']));

And replace the $id index by $i like that:

$lat = explode(" ",str_replace(",",".",$exifData[$i]['GPS/Latitude']['value']));

$lon = explode(" ",str_replace(",",".",$exifData[$i]['GPS/Longitude']['value']));

It certainly was a typing mistake by a developer.

In modules/exif/lib/exifer/makers/gps.inc

Put into comment the following lines:

$hour = GPSRational(substr($data,0,16),$intel);
$minutes = GPSRational(substr($data,16,16),$intel);
$seconds = GPSRational(substr($data,32,16),$intel);
And add these ones:

$hour = hexdec(substr($data,40,8));
$minutes = hexdec(substr($data,24,8))/((float)hexdec(substr($data,16,8)));
$seconds = 0;
For this… I do not have any idea about why my EXIF data do not correspond with the reading algorithm of the original module… But with my modification, they do.
So, use this patch if and only if you have some problem of reading of GPS coordinates.

In modules/map/ShowMap.inc

AFTER these lines:

SELECT [GallerymapMap::itemId],
[GallerymapMap::value]
FROM [GallerymapMap]
WHERE [GallerymapMap::field] = \’GPS\’
ADD (and NOT REPLACE) this one:

AND [GallerymapMap::value] <> \’0,0\’
This modification is to avoid timeout problem if the majority of your pictures have none or unreadable GPS data.

That’s all

Thanks to make me know if you have some difficulty with my explanation (or with my English ) and do not hesitate to:

• Execute
• Study
• Redistribute
• Improve

my code… like GPL licence oblige me and you