The mailing list for users of the eduroam Configuration Assistant Tool (CAT)

[Stefan Winter <address@concealed>]

Hi again,

> The number you see is either Windows XP (Spain is at 19088 there) or
> 13720 for what is recorded in the database as "android_Pie". It doesn't
> get displayed properly because the device configuration lists it as
> "android_pie" (no capitals).
> 
> And that's bug #2: why is the device that is called android_pie in
> config recorded in the DB as android_Pie? None of the other Android
> entries exhibit the same behaviour.
> 
> I'll find out and will get this fixed in 2.0.1.

You live, you learn.

So we had a UNIQUE KEY on the device ID (varchar), and a ON DUPLICATE
KEY UPDATE to increment the stats.

It turns out that MySQL/MariaDB compares varchars case-INsensitive *and*
that for some reason our very first download of Pie was labelled
android_Pie.

So, all future downloads were attributes to that "same" device, even
when we changed the config towards android_pie.

This didn't require any code change; I merely changed all strings
towards lower-case and now all future ones will be added to the
lowercase one. Which is displayed correctly in the NRO stats. So this is
fixed effective immediately.

Bug #1 still needs a code fix, and that's for 2.0.1 still.

Greetings,

Stefan

-- 
Stefan WINTER
Ingenieur de Recherche
Fondation RESTENA - Réseau Téléinformatique de l'Education Nationale et
de la Recherche
2, avenue de l'Université
L-4365 Esch-sur-Alzette

Tel: +352 424409 1
Fax: +352 422473

PGP key updated to 4096 Bit RSA - I will encrypt all mails if the
recipient's key is known to me

http://pgp.mit.edu:11371/pks/lookup?op=get&search=0xC0DE6A358A39DC66

Attachment: 0xC0DE6A358A39DC66.asc
Description: application/pgp-keys

Attachment: signature.asc
Description: OpenPGP digital signature