I am currently running an sql database (mySql) on my Windows system. I use it for my MRTG Viewer front-end (not fun making that work on Windows).
Anyway...I am not stuck on any one particular way of setting up the radius/database. However....I must have one Windows box and one Microtik box. I then have a pretty extensive MS Access database for my clients that does all sorts of stuff for me (i.e. creating HTML code, creating MRTG file, creating customer invoice, etc, etc). So...I would LOVE to use my MS Access database for the backend of Radius. I know there are Radius programs out there for Windows, that can query MS access...however, every one of them are upwards of $500-1000. I own Windows XP, Windows 2000 server, and Microtik. I really would like this to work....there should be an automated way of using my Access Database. Sully -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of shoffman Sent: Wednesday, November 05, 2003 6:43 AM To: [EMAIL PROTECTED] Subject: Re: [smartBridges] sB with IAS / IIS / MT / PPPoE Sully, I do believe you can link all this together in Active Directory. I personally would not go this approach for I think Active Directory is the slowest directory servcie available, throws way too many errors and does not follow applicable RFC's (all MS says is we wrote it for our systems and thats it, we don't need to follow RFC's...). But, there is definitely ways of giving the same user multiple pieces of information so that the directory will answer questions about separate separate services for that user. The only thing I can think of is ID'ing the user. You may have to standardize this across all three services. I know that Cisco was working on an appliance that did all this over a year ago, and so was Nortel.. Don't know what happened, will have to dig out my notes on our meeting with them (They talked to us about using UltraDNS's directory service software for the directory part... can't say much more.) Realize that if you know enough about DNS and how to manipulate all the different types of classes and fields in that directory service, its probably the fastest directory service for this type of basic information look-up (i.e. simple question, simple answer) out there. I also bet you could build a SQL database that would work better than Active Directory by a mile. Scott Scott -----Original Message----- From: "The Wirefree Network" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Date: Tue, 4 Nov 2003 22:39:49 -0800 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 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
