[isf-wifidog] JiWire formatted CSV node list export

[François Proulx]

We are simply using the Openvpn DHCP-like attribution scheme and we  
wrote a script that matches the MAC address with the current VPN IP  
address.

Also, in order to create non-conflicting IP ranges for each hotspot,  
we came up with an interesting an idea that uses a MD5 hash of the  
MAC address. Basically we hash the MAC address and extract a 16-bit  
binary string from it and use it as part of the IP network identifier  
( such as 10.(insert 16-bit here).0/8 ). Since the MAC address is  
unique and is far smaller than the MD5 hash we get a pretty good  
entropy out of the extracted 16-bit string.


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

> My follow-up questions aren't wifidog-specific, but are related to
> running/managing networks using wifidog.
>
> I love the zero-config router idea.  But what about the openvpn  
> client config?
>
> Also, doesn't this method confuse the stats, a bit?  I mean, if you
> consider the stats to be per-router, that's fine -- but it's much more
> useful to consider them per-node.  For example, if I want to see how
> many connections were made at Laika over the past year, but the router
> was swapped out once, I need to run two reports and add the result by
> hand, no?  And further, if the "old" router was then put back into
> service elsewhere then things get even more confused.
>
> I like the zero-config router idea, but not if it's going to  
> confuse our stats.
>
> Gabe
>
>
> On 7/10/06, François Proulx <fproulx at edito.qc.ca> wrote:
>> ** 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
>> >>
>>
>>