Sully, Have you ever considered porting your Access database to SQL , and then use Access front end to manipulate data in the SQL database?
Scott -----Original Message----- From: "The Wirefree Network" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Date: Wed, 5 Nov 2003 09:25:48 -0800 Subject: RE: [smartBridges] sB with IAS / IIS / MT / PPPoE > 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 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
