Re: [Optigold-ISP] Re: (RADIATOR) Recommendations for ISP Billing System
Mike McCauley wrote: >Its supplied as full source code. It works with a wide range of user >databases, >including flat file, DBM, password file, SQL, LDAP, Proxy etc etc, and >runs on >Unix, NT, Win95/98, Rhapsody etc. When it comes to SQL, it can work with >almost any free or commercial SQL server. > >What we would really like to be able to do is to authenticate users directly >out of the OptiGold database, and insert dialup usage records dorectly >into the >database. That makes for a very tightly integrated auth/billing/cust >management package. Cool... definately sounds pretty nice... I could probably put some custom stuff into Optigold ISP to allow for Radiator to authenticate directly from it, but to be honest, it would probably be easier to just wait until FileMaker Pro 5.0 in May. Which adds a two-way SQL/ODBC plug-in. In your "ideal" world, how would *you* want to autenticate from the Optigold ISp database? - Shawn --- Shawn D. Hogan President, Data Point Solutions http://www.data-point.com (619) 452-3696 ICQ: 8319647 === To unsubscribe, email '[EMAIL PROTECTED]' with 'unsubscribe radiator' in the body of the message.
Re: [Optigold-ISP] Re: (RADIATOR) Recommendations for ISP Billing System
Hi Shawn, On Feb 18, 7:27pm, Shawn Hogan wrote: > Subject: Re: [Optigold-ISP] Re: (RADIATOR) Recommendations for ISP Billin > Greg Gibson wrote: > > >I, for one, would sure love to see some integration between Radiator and > >Optigold. > > Hm... Radiator is a RADIUS server I take it? Indeed. > > Are there any hooks into Radiator, or how does Radiator allow other apps > to talk to it? Its supplied as full source code. It works with a wide range of user databases, including flat file, DBM, password file, SQL, LDAP, Proxy etc etc, and runs on Unix, NT, Win95/98, Rhapsody etc. When it comes to SQL, it can work with almost any free or commercial SQL server. What we would really like to be able to do is to authenticate users directly out of the OptiGold database, and insert dialup usage records dorectly into the database. That makes for a very tightly integrated auth/billing/cust management package. -- Mike McCauley[EMAIL PROTECTED] Open System Consultants Pty. Ltd Unix, Motif, C++, WWW 24 Bateman St Hampton, VIC 3188 AustraliaConsulting and development Phone, Fax: +61 3 9598-0985 http://www.open.com.au Radiator: the most portable, flexible and configurable RADIUS server anywhere. SQL, proxy, DBM, files, LDAP, NIS+, password, NT, Emerald, Platypus, Freeside, external, etc etc etc on Unix, Win95, NT, Rhapsody === To unsubscribe, email '[EMAIL PROTECTED]' with 'unsubscribe radiator' in the body of the message.
Re: [Optigold-ISP] Re: (RADIATOR) Recommendations for ISP Billing System
Greg Gibson wrote: >I, for one, would sure love to see some integration between Radiator and >Optigold. Hm... Radiator is a RADIUS server I take it? Are there any hooks into Radiator, or how does Radiator allow other apps to talk to it? - Shawn --- Shawn D. Hogan President, Data Point Solutions http://www.data-point.com (619) 452-3696 ICQ: 8319647 === To unsubscribe, email '[EMAIL PROTECTED]' with 'unsubscribe radiator' in the body of the message.
Re: (RADIATOR) Recommendations for ISP Billing System
On Fri, 19 Feb 1999, Mike McCauley wrote: > Hi Leigh, > > Rodopi: lots of nice features, web interface, with server programs running > under IIS. Very easy to install, but requires MS-SQL and IIS to be installed > first. There has been quite a bit of discussion about a backdoor Trojan in Rodopi that connects to Rodopi HQ and sends them information about your customers. Make sure it's adequately firewalled if you don't like this behavior. -- --Jay Hennigan [EMAIL PROTECTED]805-884-6323 -- WestNet: Internet service to Santa Barbara, Ventura and the world. === To unsubscribe, email '[EMAIL PROTECTED]' with 'unsubscribe radiator' in the body of the message.
Re: (RADIATOR) Recommendations for ISP Billing System
On Feb 18, 9:48pm, Leigh Sandy wrote: > Subject: Re: (RADIATOR) Recommendations for ISP Billing System > Mike, > > Thanks for the feedback... and for the warning against purchasing in haste. > Do any (or all) support transferring an existing Unix password file into the > SQL database? Not sure, but the buildsql script provided with Radiator can populate almost any SQL database from a password file. -- Mike McCauley[EMAIL PROTECTED] Open System Consultants Pty. Ltd Unix, Motif, C++, WWW 24 Bateman St Hampton, VIC 3188 AustraliaConsulting and development Phone, Fax: +61 3 9598-0985 http://www.open.com.au Radiator: the most portable, flexible and configurable RADIUS server anywhere. SQL, proxy, DBM, files, LDAP, NIS+, password, NT, Emerald, Platypus, Freeside, external, etc etc etc on Unix, Win95, NT, Rhapsody === To unsubscribe, email '[EMAIL PROTECTED]' with 'unsubscribe radiator' in the body of the message.
Re: [Optigold-ISP] Re: (RADIATOR) Recommendations for ISP Billing System
I, for one, would sure love to see some integration between Radiator and Optigold. Greg At 09:17 PM 2/18/99 -0500, Novagate Systems Admin wrote: >Yes, it uses Filemaker Pro. FMP has hooks to query a SQL database but not >act as an SQL database. As it is now Optigold has a RADIUS import feature >that imports parsed RADIUS detail files. Optigold already works with a >number of user management packages and even exports RADIUS users files. >I'm not exactly sure how the integration would work but i've copied this >to the Optigold ISP list for further comment :-) Of course you also have >all the features of FMP like built in web integration, cross platform >operation, etc. > >For all you Optigold ISP users out there, Radiator is definately one of >the best (if not the best) RADIUS servers around. Check it out at >http://www.open.com.au/radiator/ > >-Dave > >On Fri, 19 Feb 1999, Mike McCauley wrote: > >> On Feb 18, 8:26pm, Novagate Systems Admin wrote: >> > Subject: Re: (RADIATOR) Recommendations for ISP Billing System >> > Check out http://www.data-point.com/products/isp/ >> > >> > IMHO, it is by far the best package out there. From an interface point of >> > view it is easily the best. And moving from Quickbooks is a snap, just >> > click on the fields you want to convert. Also, the revisions are constant >> > so if there's a feature you need it will probably end up in the next >> > version (although it does just about everything, including manage a >> > WuakeII server!). I've seen some packages that haven't been upgraded in >> > months and as we know, our businesses are not that static :-) >> >> Looks very nice. >> Any idea what sort of database is behind it? >> Could Radiator get to it? >> >> >> -- >> Mike McCauley[EMAIL PROTECTED] >> Open System Consultants Pty. Ltd Unix, Motif, C++, WWW >> 24 Bateman St Hampton, VIC 3188 AustraliaConsulting and development >> Phone, Fax: +61 3 9598-0985 http://www.open.com.au >> >> Radiator: the most portable, flexible and configurable RADIUS server >> anywhere. SQL, proxy, DBM, files, LDAP, NIS+, password, NT, Emerald, >> Platypus, Freeside, external, etc etc etc on Unix, Win95, NT, Rhapsody >> > > > >--- >To subscribe, unsubscribe and list archive >please visit http://www.data-point.com/lists >--- > > == Greg Gibson703-631-5755 President[EMAIL PROTECTED] The PressRoom Online Services www.pressroom.com == === To unsubscribe, email '[EMAIL PROTECTED]' with 'unsubscribe radiator' in the body of the message.
Re: (RADIATOR) Recommendations for ISP Billing System
Mike, Thanks for the feedback... and for the warning against purchasing in haste. Do any (or all) support transferring an existing Unix password file into the SQL database? >Emerald, PLatypus and Rodopi are all very functional, with lots of good >features. Here is a potted summary of the pros and cons as I see them: > >Emerald: PC GUI, MS-SQL, very easy to install, good features, but you must >install MS-SQL first. > >Platypus: PC GUI, MS-SQL, probably a bit more mature than Emerald. Installation >is a bit mnore involved than the others (you have to create the database and >databse device yourself from instructions), and instll MS-SQL first > >Rodopi: lots of nice features, web interface, with server programs running >under IIS. Very easy to install, but requires MS-SQL and IIS to be installed >first. > >In all case, installation is not too bad, but you will have to spend some time >configuring it to suit your needs (adding the packages, services and prices >etc) > >I would be inclined not to chooose on the basis of how easy it is to install >and configure, but on the features offered. On that basis,its hard to choose >between Platypus and Rodopi. Emerald is prob behind those two. > >This might be a case of "purchase in haste, repent at leisure", though I dont >think you will have serious problems with any of them. > >Radiator works fine with all of them, and will auth direct from their database, >and insert accounting direct to their database. > > >On Feb 18, 4:54pm, Leigh Sandy wrote: >> Subject: (RADIATOR) Recommendations for ISP Billing System >> >> We are in the process of evaluating a billing system for our office. We >currently have about 2000 dial-up customers and are transitioning from >Livingston Radius to Radiator. Our current billing system is QuickBooks Pro >and it is really a pain. Any comments on Rodopi? Platypus? Emerald? Do any >of them build the server with all the software preinstalled and configured? We >need something that won't take much of our time to configure. >> >> Leigh >> - Original Message - >> From: Kevin Wormington >> To: [EMAIL PROTECTED] >> Sent: Thursday, February 18, 1999 11:30 AM >> Subject: (RADIATOR) SQL with failover to flat file >> >> >> Hi all, >> >> I am using v2.13 with a modified AuthPLATYPUS going against MSSQL 6.5. I >would like to set radiator up to try authenticating from AuthPLATYPUS and if >the SQL server is down then attempt authenticating from a flat users file, this >would allow my remote radius servers to authenticate if there was an sql server >failure or a leased-line was down. Is this possible and would there be a delay >on each auth if the sql server were down or would it get marked as down until >it came back up? >> >> Thanks, >> >> Kevin >> Sofnet, Inc. >> >> [ Attachment (text/x-html): 2544 bytes >> Character set: iso-8859-1 >> Encoded with "quoted-printable" ] >>-- End of excerpt from Leigh Sandy > > > >-- >Mike McCauley[EMAIL PROTECTED] >Open System Consultants Pty. Ltd Unix, Motif, C++, WWW >24 Bateman St Hampton, VIC 3188 AustraliaConsulting and development >Phone, Fax: +61 3 9598-0985 http://www.open.com.au > >Radiator: the most portable, flexible and configurable RADIUS server >anywhere. SQL, proxy, DBM, files, LDAP, NIS+, password, NT, Emerald, >Platypus, Freeside, external, etc etc etc on Unix, Win95, NT, Rhapsody >=== >To unsubscribe, email '[EMAIL PROTECTED]' with >'unsubscribe radiator' in the body of the message. > === To unsubscribe, email '[EMAIL PROTECTED]' with 'unsubscribe radiator' in the body of the message.
Re: (RADIATOR) Recommendations for ISP Billing System
Yes, it uses Filemaker Pro. FMP has hooks to query a SQL database but not act as an SQL database. As it is now Optigold has a RADIUS import feature that imports parsed RADIUS detail files. Optigold already works with a number of user management packages and even exports RADIUS users files. I'm not exactly sure how the integration would work but i've copied this to the Optigold ISP list for further comment :-) Of course you also have all the features of FMP like built in web integration, cross platform operation, etc. For all you Optigold ISP users out there, Radiator is definately one of the best (if not the best) RADIUS servers around. Check it out at http://www.open.com.au/radiator/ -Dave On Fri, 19 Feb 1999, Mike McCauley wrote: > On Feb 18, 8:26pm, Novagate Systems Admin wrote: > > Subject: Re: (RADIATOR) Recommendations for ISP Billing System > > Check out http://www.data-point.com/products/isp/ > > > > IMHO, it is by far the best package out there. From an interface point of > > view it is easily the best. And moving from Quickbooks is a snap, just > > click on the fields you want to convert. Also, the revisions are constant > > so if there's a feature you need it will probably end up in the next > > version (although it does just about everything, including manage a > > WuakeII server!). I've seen some packages that haven't been upgraded in > > months and as we know, our businesses are not that static :-) > > Looks very nice. > Any idea what sort of database is behind it? > Could Radiator get to it? > > > -- > Mike McCauley[EMAIL PROTECTED] > Open System Consultants Pty. Ltd Unix, Motif, C++, WWW > 24 Bateman St Hampton, VIC 3188 AustraliaConsulting and development > Phone, Fax: +61 3 9598-0985 http://www.open.com.au > > Radiator: the most portable, flexible and configurable RADIUS server > anywhere. SQL, proxy, DBM, files, LDAP, NIS+, password, NT, Emerald, > Platypus, Freeside, external, etc etc etc on Unix, Win95, NT, Rhapsody > === To unsubscribe, email '[EMAIL PROTECTED]' with 'unsubscribe radiator' in the body of the message.
Re: (RADIATOR) Recommendations for ISP Billing System
On Feb 18, 8:26pm, Novagate Systems Admin wrote: > Subject: Re: (RADIATOR) Recommendations for ISP Billing System > Check out http://www.data-point.com/products/isp/ > > IMHO, it is by far the best package out there. From an interface point of > view it is easily the best. And moving from Quickbooks is a snap, just > click on the fields you want to convert. Also, the revisions are constant > so if there's a feature you need it will probably end up in the next > version (although it does just about everything, including manage a > WuakeII server!). I've seen some packages that haven't been upgraded in > months and as we know, our businesses are not that static :-) Looks very nice. Any idea what sort of database is behind it? Could Radiator get to it? -- Mike McCauley[EMAIL PROTECTED] Open System Consultants Pty. Ltd Unix, Motif, C++, WWW 24 Bateman St Hampton, VIC 3188 AustraliaConsulting and development Phone, Fax: +61 3 9598-0985 http://www.open.com.au Radiator: the most portable, flexible and configurable RADIUS server anywhere. SQL, proxy, DBM, files, LDAP, NIS+, password, NT, Emerald, Platypus, Freeside, external, etc etc etc on Unix, Win95, NT, Rhapsody === To unsubscribe, email '[EMAIL PROTECTED]' with 'unsubscribe radiator' in the body of the message.
Re: (RADIATOR) Radiator on MACperl?
On Feb 18, 4:42pm, Internet 2xtreme wrote: > Subject: (RADIATOR) Radiator on MACperl? > I was talking to another ISP that is based on Macintosh servers. I told > them about radiator and that it perl. He said that he had MACperl > version 5.???. I'm not sure what this is nor have I seen it. Does > anybody know if radiator will run on a macintosh server? I did some experiments with it recently, but hit a brick wall trying to run it on 680x0 hardware (which is all I have here). The problem was that you need the MacPerl with CFM (code fragment manager) in order to use loadable modules like MD5. But the CFM version of MacPerl also expects to find AppleScriptLib, which is not present on 680x0 platforms. I expect it works a treat on PPC platforms. Its probably just a temporary prob with the way they built MacPerl. Im hopeful that Radiator will work without much effort, and I would sure like to see it running on Mac, just for fun. I never thought anybody would actually want to use it there ;-) If your friend want to get in touch to try to work something out, we would be willing to talk. Cheers. -- Mike McCauley[EMAIL PROTECTED] Open System Consultants Pty. Ltd Unix, Motif, C++, WWW 24 Bateman St Hampton, VIC 3188 AustraliaConsulting and development Phone, Fax: +61 3 9598-0985 http://www.open.com.au Radiator: the most portable, flexible and configurable RADIUS server anywhere. SQL, proxy, DBM, files, LDAP, NIS+, password, NT, Emerald, Platypus, Freeside, external, etc etc etc on Unix, Win95, NT, Rhapsody === To unsubscribe, email '[EMAIL PROTECTED]' with 'unsubscribe radiator' in the body of the message.
Re: (RADIATOR) Recommendations for ISP Billing System
Check out http://www.data-point.com/products/isp/ IMHO, it is by far the best package out there. From an interface point of view it is easily the best. And moving from Quickbooks is a snap, just click on the fields you want to convert. Also, the revisions are constant so if there's a feature you need it will probably end up in the next version (although it does just about everything, including manage a WuakeII server!). I've seen some packages that haven't been upgraded in months and as we know, our businesses are not that static :-) -Dave On Thu, 18 Feb 1999, Internet 2xtreme wrote: > We too came up the same path that you did. We started out with just > plain quickbooks. Once we cleared 1200 customers, that was not > usable any more. Then we went with a billing program offered by our > Credit Card processing company called webbiller. That was not good at > all. After a year of that, we finally got going on platypus. We love it. > We looked at emerald, but felt that was a work in progress. We also > looked at the literature on rodopi and ISPgold. Platypus looked better, > so we got it. It wasn't until a year after having platypus that we got > radiator. That was a nice complement to platypus. We know of one > other ISP in our area using platypus as well. > > John Kicklighter > Internet 2xtreme > > From: "Leigh Sandy" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Subject: (RADIATOR) Recommendations for ISP Billing System > Date sent:Thu, 18 Feb 1999 16:54:18 -0500 > > > We are in the process of evaluating a billing system for our office. We currently >have about 2000 dial-up customers and are transitioning from Livingston Radius to >Radiator. Our current billing system is QuickBooks Pro and it is really a pain. Any >comments on Rodopi? Platypus? Emerald? Do > any of them build the server with all the software preinstalled and configured? We >need something that won't take much of our time to configure. > > > > Leigh > > - Original Message - > > From: Kevin Wormington > > To: [EMAIL PROTECTED] > > Sent: Thursday, February 18, 1999 11:30 AM > > Subject: (RADIATOR) SQL with failover to flat file > > > > > > Hi all, > > > > I am using v2.13 with a modified AuthPLATYPUS going against MSSQL 6.5. I would >like to set radiator up to try authenticating from AuthPLATYPUS and if the SQL server >is down then attempt authenticating from a flat users file, this would allow my >remote radius servers to authenticate if there > was an sql server failure or a leased-line was down. Is this possible and would >there be a delay on each auth if the sql server were down or would it get marked as >down until it came back up? > > > > Thanks, > > > > Kevin > > Sofnet, Inc. > > > > > > === > To unsubscribe, email '[EMAIL PROTECTED]' with > 'unsubscribe radiator' in the body of the message. > === To unsubscribe, email '[EMAIL PROTECTED]' with 'unsubscribe radiator' in the body of the message.
Re: (RADIATOR) Recommendations for ISP Billing System
We too came up the same path that you did. We started out with just plain quickbooks. Once we cleared 1200 customers, that was not usable any more. Then we went with a billing program offered by our Credit Card processing company called webbiller. That was not good at all. After a year of that, we finally got going on platypus. We love it. We looked at emerald, but felt that was a work in progress. We also looked at the literature on rodopi and ISPgold. Platypus looked better, so we got it. It wasn't until a year after having platypus that we got radiator. That was a nice complement to platypus. We know of one other ISP in our area using platypus as well. John Kicklighter Internet 2xtreme From: "Leigh Sandy" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Subject:(RADIATOR) Recommendations for ISP Billing System Date sent: Thu, 18 Feb 1999 16:54:18 -0500 > We are in the process of evaluating a billing system for our office. We currently >have about 2000 dial-up customers and are transitioning from Livingston Radius to >Radiator. Our current billing system is QuickBooks Pro and it is really a pain. Any >comments on Rodopi? Platypus? Emerald? Do any of them build the server with all the software preinstalled and configured? We need something that won't take much of our time to configure. > > Leigh > - Original Message - > From: Kevin Wormington > To: [EMAIL PROTECTED] > Sent: Thursday, February 18, 1999 11:30 AM > Subject: (RADIATOR) SQL with failover to flat file > > > Hi all, > > I am using v2.13 with a modified AuthPLATYPUS going against MSSQL 6.5. I would >like to set radiator up to try authenticating from AuthPLATYPUS and if the SQL server >is down then attempt authenticating from a flat users file, this would allow my >remote radius servers to authenticate if there was an sql server failure or a leased-line was down. Is this possible and would there be a delay on each auth if the sql server were down or would it get marked as down until it came back up? > > Thanks, > > Kevin > Sofnet, Inc. > === To unsubscribe, email '[EMAIL PROTECTED]' with 'unsubscribe radiator' in the body of the message.
(RADIATOR) Radiator on MACperl?
I was talking to another ISP that is based on Macintosh servers. I told them about radiator and that it perl. He said that he had MACperl version 5.???. I'm not sure what this is nor have I seen it. Does anybody know if radiator will run on a macintosh server? He has his billing being handled with filemaker. He says that there are some ODBC drivers for filemaker that should work. He currently has another macintosh based radius server. Thanks, John Kicklighter Internet 2xtreme === To unsubscribe, email '[EMAIL PROTECTED]' with 'unsubscribe radiator' in the body of the message.
Re: (RADIATOR) Recommendations for ISP Billing System
Hi Leigh, Emerald, PLatypus and Rodopi are all very functional, with lots of good features. Here is a potted summary of the pros and cons as I see them: Emerald: PC GUI, MS-SQL, very easy to install, good features, but you must install MS-SQL first. Platypus: PC GUI, MS-SQL, probably a bit more mature than Emerald. Installation is a bit mnore involved than the others (you have to create the database and databse device yourself from instructions), and instll MS-SQL first Rodopi: lots of nice features, web interface, with server programs running under IIS. Very easy to install, but requires MS-SQL and IIS to be installed first. In all case, installation is not too bad, but you will have to spend some time configuring it to suit your needs (adding the packages, services and prices etc) I would be inclined not to chooose on the basis of how easy it is to install and configure, but on the features offered. On that basis,its hard to choose between Platypus and Rodopi. Emerald is prob behind those two. This might be a case of "purchase in haste, repent at leisure", though I dont think you will have serious problems with any of them. Radiator works fine with all of them, and will auth direct from their database, and insert accounting direct to their database. On Feb 18, 4:54pm, Leigh Sandy wrote: > Subject: (RADIATOR) Recommendations for ISP Billing System > > We are in the process of evaluating a billing system for our office. We currently have about 2000 dial-up customers and are transitioning from Livingston Radius to Radiator. Our current billing system is QuickBooks Pro and it is really a pain. Any comments on Rodopi? Platypus? Emerald? Do any of them build the server with all the software preinstalled and configured? We need something that won't take much of our time to configure. > > Leigh > - Original Message - > From: Kevin Wormington > To: [EMAIL PROTECTED] > Sent: Thursday, February 18, 1999 11:30 AM > Subject: (RADIATOR) SQL with failover to flat file > > > Hi all, > > I am using v2.13 with a modified AuthPLATYPUS going against MSSQL 6.5. I would like to set radiator up to try authenticating from AuthPLATYPUS and if the SQL server is down then attempt authenticating from a flat users file, this would allow my remote radius servers to authenticate if there was an sql server failure or a leased-line was down. Is this possible and would there be a delay on each auth if the sql server were down or would it get marked as down until it came back up? > > Thanks, > > Kevin > Sofnet, Inc. > > [ Attachment (text/x-html): 2544 bytes > Character set: iso-8859-1 > Encoded with "quoted-printable" ] >-- End of excerpt from Leigh Sandy -- Mike McCauley[EMAIL PROTECTED] Open System Consultants Pty. Ltd Unix, Motif, C++, WWW 24 Bateman St Hampton, VIC 3188 AustraliaConsulting and development Phone, Fax: +61 3 9598-0985 http://www.open.com.au Radiator: the most portable, flexible and configurable RADIUS server anywhere. SQL, proxy, DBM, files, LDAP, NIS+, password, NT, Emerald, Platypus, Freeside, external, etc etc etc on Unix, Win95, NT, Rhapsody === To unsubscribe, email '[EMAIL PROTECTED]' with 'unsubscribe radiator' in the body of the message.
Re: (RADIATOR) Questions about Radiator (fwd)
On 1999-02-18T22:16:10, Tomasz Pi³at <[EMAIL PROTECTED]> said: > > And this mailing list is > > active, so you can always have your questions answered. > Very good. Fast support is very important for us... The support we get from Mike is excellent. Think of this as "Open Source", but with a guy paid to be motivated to do the maintenance and support ;-) Sincerely, Lars Marowsky-Brée -- Lars Marowsky-Brée Network Management teuto.net Netzdienste GmbH - DPN Verbund-Partner === To unsubscribe, email '[EMAIL PROTECTED]' with 'unsubscribe radiator' in the body of the message.
(RADIATOR) Recommendations for ISP Billing System
We are in the process of evaluating a billing system for our office. We currently have about 2000 dial-up customers and are transitioning from Livingston Radius to Radiator. Our current billing system is QuickBooks Pro and it is really a pain. Any comments on Rodopi? Platypus? Emerald? Do any of them build the server with all the software preinstalled and configured? We need something that won't take much of our time to configure. Leigh - Original Message - From: Kevin Wormington To: [EMAIL PROTECTED] Sent: Thursday, February 18, 1999 11:30 AM Subject: (RADIATOR) SQL with failover to flat file Hi all, I am using v2.13 with a modified AuthPLATYPUS going against MSSQL 6.5. I would like to set radiator up to try authenticating from AuthPLATYPUS and if the SQL server is down then attempt authenticating from a flat users file, this would allow my remote radius servers to authenticate if there was an sql server failure or a leased-line was down. Is this possible and would there be a delay on each auth if the sql server were down or would it get marked as down until it came back up? Thanks, Kevin Sofnet, Inc.
Re: (RADIATOR) SQL with failover to flat file
Hi Kevin, On Feb 18, 10:30am, Kevin Wormington wrote: > Subject: (RADIATOR) SQL with failover to flat file > > Hi all, > > I am using v2.13 with a modified AuthPLATYPUS going against MSSQL 6.5. I would like to set radiator up to try authenticating from AuthPLATYPUS and if the SQL server is down then attempt authenticating from a flat users file, this would allow my remote radius servers to authenticate if there was an sql server failure or a leased-line was down. Is this possible and would there be a delay on each auth if the sql server were down or would it get marked as down until it came back up? Using this config, it will try to contact the SQL server for each authentication, but if it fails, it will fall through to a password file. Then, next time it will try again to contact. If the SQL server is dowm Radiator will find out very quickly (<1 second) so I would not expect a significant performance loss. AuthByPolicy ContinueWhileIgnore # If the server is down, AuthBy PLATYPUS will IGNORE the request # and we will continue on to the FILE authentication. . ... -- Mike McCauley[EMAIL PROTECTED] Open System Consultants Pty. Ltd Unix, Motif, C++, WWW 24 Bateman St Hampton, VIC 3188 AustraliaConsulting and development Phone, Fax: +61 3 9598-0985 http://www.open.com.au Radiator: the most portable, flexible and configurable RADIUS server anywhere. SQL, proxy, DBM, files, LDAP, NIS+, password, NT, Emerald, Platypus, Freeside, external, etc etc etc on Unix, Win95, NT, Rhapsody === To unsubscribe, email '[EMAIL PROTECTED]' with 'unsubscribe radiator' in the body of the message.
Re: (RADIATOR) Questions about Radiator (fwd)
> -- Forwarded message -- > Date: Wed, 17 Feb 1999 10:36:52 +0900 (JST) > From: Peter Chow <[EMAIL PROTECTED]> > > On Wed, 17 Feb 1999, Andrzej Blaszczyk wrote: > > > I am new on this list and still hesitate to buy a Radiator radius. I work > > for big ISP. I would like to know something from users' point of view. > > You can always ask for an evaluation version and test it for yourself. We > did and are very satisfied with Radiator. We did it to, and we are very pleased with it what we have seen. > > efficient to build a distributed network of radiuses in above 50 access > > points of presence with above 2000 users in each POP. What infrastructure > > That would be 100,000 users in your network? Do they all have individual > accounts? We don't have nearly that many, perhaps 40,000 unique entries in > users file. Well, maybe not at the moment, but we will reach this point quite soon. > Other users have had success with direct database authentication, but we > haven't done this yet. We are using some dispersed sql databases, with one "main" database for syncing... > I would suggest you test out Radiator for yourself. You'll find that it > is by far the best Radius product out there. I have little experience with Radiator, but i must agree. And i love Perl :> > And this mailing list is > active, so you can always have your questions answered. Very good. Fast support is very important for us... TP -- Tomasz 'Poncki' Piłat System and Network Administrator tomekp(a)supermedia.pl at http://PoncLAND.xyz.lublin.pl/SuperMedia C.U.I., Warsaw, Poland http://lublin.irc.pl/~ircd/ http://www.supermedia.pl/ === To unsubscribe, email '[EMAIL PROTECTED]' with 'unsubscribe radiator' in the body of the message.
(RADIATOR) SQL with failover to flat file
Hi all, I am using v2.13 with a modified AuthPLATYPUS going against MSSQL 6.5. I would like to set radiator up to try authenticating from AuthPLATYPUS and if the SQL server is down then attempt authenticating from a flat users file, this would allow my remote radius servers to authenticate if there was an sql server failure or a leased-line was down. Is this possible and would there be a delay on each auth if the sql server were down or would it get marked as down until it came back up? Thanks, Kevin Sofnet, Inc.
Re: (RADIATOR) Two questions...
On Wed, 17 Feb 1999, Andrew wrote:
> Wed Feb 17 16:09:23 1999: ERR: do failed for 'UPDATE CallsOnline SET
> acctinputoctets = , acctoutputoctets = , acctsessiontime = ,
> acctterminatecause = 0 WHERE acctsessionid = '284842146' AND nasidentifier
> = '209.16.18.34'': ORA-00936: missing expression (DBD: error possibly near
> <*> indicator at char 42 in 'UPDATE CallsOnline SET acctinputoctets = <*>,
> acctoutputoctets = , acctsessiontime = , acctterminatecause = 0 WHERE
> acctsessionid = '284842146' AND nasidentifier = '209.16.18.34'')
[snip]
> AcctSQLStatement UPDATE CallsOnline SET acctinputoctets = \
> %{Acct-Input-Octets}, acctoutputoctets = %{Acct-Output-Octets}, \
> acctsessiontime = %{Acct-Session-Time}, acctterminatecause = \
> 0 WHERE acctsessionid = '%{Acct-Session-Id}' \
> AND nasidentifier = '%{NAS-Identifier}'
>
> First of all, does anyone know why some accounting packets are lacking
> these variables? My rather uneducated guess is that it's someone who
No, I don't know, but...
> Failing an explanation for the missing variables, does anyone have any
> suggestions on how to deal with these errors appropriately? The result of
> the error is that we end up with a start record in our CallsOnline table,
> but no stop record, so for all intents and purposes, this user is
> indefinitely logged on.
>
> Any explanations and/or ideas are greatly appreciated!
Try this:
AcctSQLStatement UPDATE CallsOnline SET acctinputoctets = \
'%{Acct-Input-Octets}', acctoutputoctets = '%{Acct-Output-Octets}',\
acctsessiontime = '%{Acct-Session-Time}', acctterminatecause = \
0 WHERE acctsessionid = '%{Acct-Session-Id}' \
AND nasidentifier = '%{NAS-Identifier}'
All I did was quote everything. SQL doesn't care if you quote numbers.
Then you just need to deal with how your SQL server will deal with = ''.
Steve
---
Steve Roderick ProAxis Communications, Inc.
[EMAIL PROTECTED] Internet Access Provider
(541) 757-0248
===
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.
(RADIATOR) Kudos
On Thu, 18 Feb 1999, Mike McCauley wrote: > Apologies. > > It requires SNMP_Session-0.62.tar.gz from > ftp://ftp.switch.ch/software/sources/network/snmp/perl/ Of course after a new release, Mike gets to deal with all of the fallout. But I for one want to extend a hearty thanks and congratulations on a job well done. 2.13 is a major step forward! Thank you, Steve --- Steve Roderick ProAxis Communications, Inc. [EMAIL PROTECTED] Internet Access Provider (541) 757-0248 === To unsubscribe, email '[EMAIL PROTECTED]' with 'unsubscribe radiator' in the body of the message.
Re: (RADIATOR) Detail logging by Realm name
On Thu, 18 Feb 1999, Stephen Ollis wrote: > I've got multiple realms configured that authenticate via a single > flatfile. The reason for the multiple realms is due to multiple > customer types to allow them to dial in for different functions - > i.e. DVS tunnelling on BAY 5399's, IPASS, etc. I have a single > flatfile with basic authentication details, and use > RewriteUsername s/^([^@]+).*/$1/ > in each pair to strip out the realm. > > I want to have separate detail files for each realm for accounting > purpose so I setup:- > # Where do we write the accounting file > AcctLogFileName %L/detail.%R-%Y%m%d > in each realm file.. but it is creating the detail file as > %L/detail.-19990218 instead of %L/detail.realmname-19990218 > > Putting the AcctLogFileName entry before or after the Rewrite > has no effect. This is the point of my recent patch recommendation (Thanks to Mike for incorporating it into the next release!). You HAVE to stop stripping off the realm (you actually need to guarantee it is there) and then use the change that I mentioned in my previous post. This will solve your problem. Steve --- Steve Roderick ProAxis Communications, Inc. [EMAIL PROTECTED] Internet Access Provider (541) 757-0248 === To unsubscribe, email '[EMAIL PROTECTED]' with 'unsubscribe radiator' in the body of the message.
