[isf-wifidog] JiWire formatted CSV node list export

[Gabe Sawhney]

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
> >>
>
>