[MeshBox-radius] RE: Need help with creating a database / RADIUS Server

[Mark M. <mar...@ne...>]

Eden/Matt/Chris/Michael/Bob,
 
 
If you haven't done so already, please subscribe to this mailing list:
 
http://lists.sourceforge.net/lists/listinfo/meshbox-radius
 
Also please E-mail me your current sourceforge screen name/login, so I
can add you to the source forge developer's site.
 
 
We're trying to create a Global authentication server database.  
 
This is a BIG task.
 
These are the goals:
 
We're trying to create a global authentication server.  So users have
one login, and one password, and they can roam freely between wireless
MeshBox communities.  We'd like the User database to be manageable using
our current web-based control panel (php-based).  That way we can assign
permissions to certain users, and they can add/edit/manage user accounts
in their local area.
 
1) We currently have a user database
2) We'd like to use FreeRADIUS (for user authentication), and somehow
tie this to our current user database.
3) We'd like to use NoCat (for wireless authentication)
4) We need to add a Lat/Long field to the current database (need some
type of lat/long conversion program to convert an address to lat/long).
The mapping server will use this lat/long field for the Mapping of
MeshBox nodes.
5) We need to add address (and country code) information to the current
user database (and somehow convert the street address to a lat/long).
6) We need to update the web-based control panel pages with the
additional fields (address, country code, phone number, etc.) for easy
web-based administration.
 
Any ideas on how we can do all this?  Where shall we begin?  Do you want
to see what we currently have in place first?  <Looking around the room
for ideas>
 
         Mark
 
 

-----Original Message-----
From: Eden Akhavi [mailto:ede...@lt...] 
Sent: Friday, February 28, 2003 5:02 PM
To: 'Mark Malewski'
Subject: RE:  Need help with creating a database


Hi Mark,
 
What do you need?
 
Regards
 

Eden

-----Original Message-----
From: Mark Malewski [mailto:mar...@ne...] 
Sent: 28 February 2003 21:26
Subject: Need help with creating a database


Is anyone on this list a DBA person?  Someone that knows quite a bit
about databases, and how to create them, etc.
 
Looking for a little help, please contact me off-list.
 
             Thanks,
 
               Mark