No, well, I'm not sure about how Active Directory works, but the best thing to do is auth from an SQL database. We use mysql (easy, free, and damned functional) coupled with Open Systems Radiator (not free, extremely functional tho). PPPoE auths to a radius server, which in turn can look up the SQL database, to query a login & password (e.g. if the SELECT sql statements returns <1 records, the radius server will issue a REJECT to the access point). I can't speak for other radius servers, but Radiator shipped with a predone SQL file, which creates all the necessary tables in the mysql database (also comes in a bunch of other formats for Oracle, MSSQL etc). You can then just add your own columns to the existing tables, carrying specific information. So you could hold the MAC address, the login, the password, and all the customer details (better to hold a customer unique identifer and store the customer record in a different table), and wallah :) ER Databases really are sooo good :)
Kind Regards Colin ----- Original Message ----- From: "The Wirefree Network" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, November 05, 2003 6:39 AM Subject: [smartBridges] sB with IAS / IIS / MT / PPPoE > Now that is a descriptive subject line if I do say so myself. > > By weeks end, I will have a Win2k server box and a Microtik box. I also > have routers ready to deploy for EVERY client with built-in PPPoE. > > My plan is this: > Step 1: Setup IAS (microsoft radius) to authenticate my sB devices (instead > of internal MAC). > Step 2: Setup Mikrotik for PPPoE/Bandwidth throttling which requires a > Radius server (use Number 2 for the IAS). > Step 3: Setup IIS webpage to allow my clients to log in and see their > current bandwidth webpage (use Number 3 for IAS). > > > MORE INFO: > Step 1, is the easy part. > Step 2, is authenicating the client's router (w/built-in PPPoE) with the > radius server/MT box and setting up the bandwidth throttling at the same > time. I actually dont have a clue on how to do this yet. > Step 3, I have the webpages individually created each night at midnight > (MRTG totalizer), but need to limit the client to only viewing their page. > Still need to learn how to do this as well. > > > Anyway...after reading up on IAS (and active directory), I see a big > problem. It appears that I will need to create a user for the Wirless > Device (sB) authentication, another user for the PPPoE login, and yet > another user for allowing access to the IIS webpages. Is this true!??!? > sob...sob... Do I really have to create 3 users in Active Directory for > every one of my clients?!?!? Tell me it aint so!??! I only have 60...but > that is 180 users to create!!! > > I have an MS access database that contains EVERYTHING I need (username, MAC > addresses, IPs, passwords, etc). Is there a way to export the MS Access > data, and then import it into AIS for automatic creation of all these > users?!?!? > > I am open to any and all suggestions that do not refer to a LINUX box. For > many reasons, I just cant go down that path. > > Thanks y'all!! > > Sully > > > The PART-15.ORG smartBridges Discussion List > To Join: mailto:[EMAIL PROTECTED] (in the body type subscribe smartBridges <yournickname> > To Remove: mailto:[EMAIL PROTECTED] (in the body type unsubscribe smartBridges) > Archives: http://archives.part-15.org > > The PART-15.ORG smartBridges Discussion List To Join: mailto:[EMAIL PROTECTED] (in the body type subscribe smartBridges <yournickname> To Remove: mailto:[EMAIL PROTECTED] (in the body type unsubscribe smartBridges) Archives: http://archives.part-15.org
