[isf-wifidog] JiWire formatted CSV node list export

[François Proulx]

** I CCed the list since I think your question might be asked by  
other list members **

We are in the process of upgrading all our routers to Whiterussian  
RC5, at the same time we decided to switch to using the MAC address  
for uniquely identifying a node. Last year we added the code  
(contribution from Schuyler Erle) to the Wifidog gateway. This way,  
once we flash a router (we created a new firmware image including  
wifidog, vpn etc... ) the only thing that differs from one router to  
another is its MAC address, so we never have to touch any config file  
since the MAC address is burned in the router NVRAM by default.

This means that if we need to swap a broken router, we also need to  
change the node id for a database record. As you might imagine, since  
currently all connections are using this as as foreign key, changing  
the node id is a real burden on the database (when you have many  
thousands connections for one node). We plan to add another field  
that will (in my example) be the MAC address, leaving a permanent ID  
(which will probably be auto-generated).


On 10-Jul-06, at 12:17 , Gabe Sawhney wrote:

> Hi François -- Interesting; why did you decide to make the gw_id the
> mac address?
>
> Gabe
>
>
> On 7/10/06, François Proulx <fproulx at edito.qc.ca> wrote:
>> JiWire output is in the SVN right now. Although at Ile Sans Fil, we
>> are waiting to add a permanent node id to the database before we
>> actually use it, because we are currently in the process of upgrading
>> our routers and using the MAC address as a unique ID instead. But if
>> you think you wont' change you node ID soon, it should be alright.
>>
>>
>> On 10-Jul-06, at 11:44 , michel memeteau wrote:
>>
>> > Sorry to insist but that is not clear if Jiwire output is in SVN ?
>> >
>> > http://dev.wifidog.org/ticket/43
>> >
>> > 'Cause , we are about to upgrade our wifidog server  
>> ( auth.wireless-
>> > fr.org )
>> > because of RSS feed bugs , but have to be sure it's the right time
>> > ( features
>> > etc..)
>> >
>> > http://dev.wifidog.org/browser/trunk/wifidog-auth/wifidog/
>> > hotspot_status.php
>> >
>> > seems to show that other format are not commited in ?
>> >
>> > Not to hurry people but maybe we could give an hand on it ?
>> >
>> > Quoting Max Horváth <max.horvath at maxspot.de>:
>> >
>> >> -----BEGIN PGP SIGNED MESSAGE-----
>> >> Hash: SHA1
>> >>
>> >> During this week I'll be committing the code to SVN ...
>> >>
>> >> François Proulx wrote:
>> >>
>> >>> Max told me he would push his code soon. I'm eagerly waiting for
>> >>> all of it
>> >>>
>> >>>
>> >>> On 18-Jun-06, at 2:31 PM, michel memeteau wrote:
>> >>>
>> >>>> Great ! this could be really handfull !
>> >>>>
>> >>>> I ve seen that Maxspot.de have a PDF and KML export on Wifidog ,
>> >>>> is this on
>> >>>> SVN ? or any patch to integrate ?
>> >>>>
>> >>>> There is A need for a way to browse a kind of offline Map ,  
>> maybe
>> >>>> adding a map
>> >>>> in the pdf export with links
>> >>>>
>> >>>> Le Dimanche 18 Juin 2006 06:04, François Proulx a écrit :
>> >>>>> hi !
>> >>>>>
>> >>>>> Just to let you know I added a JiWire formatted CSV node list
>> >>>>> export.
>> >>>>>
>> >>>>> Works fine, but Excel doesn't handle well UTF-8 characters  
>> (hey,
>> >>>>> that's a M$ product so no surprise here).
>> >>>>
>> >>>> --
>> >>>> %----------------------------------------------%
>> >>>> Michel Memeteau
>> >>>> http://memeteau.free.fr
>> >>>> sip:17476005010 at proxy01.sipphone.com
>> >>>> jabber:freechelmi at jabber.fr
>> >>>> 0491886375 0624808051
>> >>>>
>> >>>>
>> >>>> _______________________________________________
>> >>>> WiFiDog mailing list
>> >>>> WiFiDog at listes.ilesansfil.org
>> >>>> http://listes.ilesansfil.org/cgi-bin/mailman/listinfo/wifidog
>> >>>
>> >>> _______________________________________________
>> >>> WiFiDog mailing list
>> >>> WiFiDog at listes.ilesansfil.org
>> >>> http://listes.ilesansfil.org/cgi-bin/mailman/listinfo/wifidog
>> >>>
>> >>
>> >> -----BEGIN PGP SIGNATURE-----
>> >> Version: GnuPG v1.4.1 (Darwin)
>> >>
>> >> iD8DBQFEleCm+BKgC+eQ3ooRArgkAJ4mx4T0O1uujwKV/jNxNbkn6Tt8tgCfYOrV
>> >> w7f7TI8OY/Y5jvn07Do0nFI=
>> >> =m5hA
>> >> -----END PGP SIGNATURE-----
>> >> _______________________________________________
>> >> WiFiDog mailing list
>> >> WiFiDog at listes.ilesansfil.org
>> >> http://listes.ilesansfil.org/cgi-bin/mailman/listinfo/wifidog
>> >>
>> >
>> >
>> > --
>> > Michel memeteau
>> > sip:17476005010 at proxy01.sipphone.com
>> > 0491886375
>> > jabber : freechelmi at jabber.fr
>> > www.marseille-wireless.org
>> >
>> > ----------------------------------------------------------------
>> > This message was sent using IMP, the Internet Messaging Program.
>> >
>> > _______________________________________________
>> > WiFiDog mailing list
>> > WiFiDog at listes.ilesansfil.org
>> > http://listes.ilesansfil.org/cgi-bin/mailman/listinfo/wifidog
>>
>> _______________________________________________
>> WiFiDog mailing list
>> WiFiDog at listes.ilesansfil.org
>> http://listes.ilesansfil.org/cgi-bin/mailman/listinfo/wifidog
>>