Thanks Hugh - after some stuffing around with new date formats, this works very well! > -----Original Message----- > From: Hugh Irvine [mailto:[EMAIL PROTECTED]] > Sent: Friday, 31 August 2001 9:27 AM > To: [EMAIL PROTECTED]; [EMAIL PROTECTED] > Subject: Re: Second copy of Accounting Data (was RE: (RADIATOR) Connecting to MS > SQL 2000) > Importance: Low > > > Hello Jamz - > > This is very easy to do simply by adding a second AuthBy clause. > > # define AuthBy RADIUS > > <AuthBy RADIUS> > Identifier ForwardAccountingOnly > Host ..... > Secret ..... > NoForwardAuthentication > ..... > </AuthBy> > > <AuthBy SQL> > Identifier YourNormalAuthBy > ...... > </AuthBy> > > ....... > > # define Realm(s) or Handler(s) > > <Realm .....> > AuthByPolicy ContinueAlways > AuthBy ForwardAccountingOnly > AuthBy YourNormalAuthBy > </Realm> > > hth > > Hugh > > > On Friday 31 August 2001 09:11, [EMAIL PROTECTED] wrote: > > Hugh and List, > > I have resorted to running Radiator locally on the SQL 2000 Server > > with ActiveState Perl and DBI::ODBC. > > > > Works very well! - and not surprisingly the database access is fast :) > > > > Our existing Radiator server is running on a linux box and talking to a > > PostgreSQL database on another machine, but we eventually want to move over > > to the new server. > > > > We have our new database structure in place but to begin the software > > development cycle it would be really great to have a second copy of all the > > accounting records flowing into the SQL 2000 database as well as our > > exisiting PostgreSQL database. > > > > Is there anything I can do to the Radiator config on the production machine > > to get it to forward a copy of all the accounting radius packets to the > > second server? > > > > Cheers, > > Jamz. > > > > > -----Original Message----- > > > From: Hugh Irvine [mailto:[EMAIL PROTECTED]] > > > Sent: Wednesday, 29 August 2001 11:55 AM > > > To: [EMAIL PROTECTED]; [EMAIL PROTECTED] > > > Subject: Re: (RADIATOR) Connecting to MS SQL 2000 > > > Importance: Low > > > > > > > > > Hello Jamz - > > > > > > I personally have had the most success with the free version of Sybase > > > for Linux (www.sybase.com) with DBI:Sybase, and configure the Sybase > > > client to connect to the MSSQL host. Alternatively, you can install a > > > copy of > > > > Radiator > > > > > on W2000k using DBI:ODBC and then proxy from Radiator on the Linux host > > > to Radiator on the W2000k host. > > > > > > hth > > > > > > Hugh > > > > > > On Wednesday 29 August 2001 12:05, [EMAIL PROTECTED] wrote: > > > > > Hi, > > > > > > > > We have been using Radiator on Linux for a while now, > > > > connecting to a PostgreSQL server and everything has been great. > > > > However > > > > > > we are now moving to MS SQL 2000 in line with upsizing of our > > > > operations and I was wondering if anyone out there had any > > > > recommendation as to how > > > > to > > > > > > get Perl DBI connectivity to MS SQL 2000. > > > > > > > > I have already tried: > > > > DBI:MSSQL > > > > DBI:Sybase + FreeTDS > > > > DBI:ODBC + Merant's Sequallink > > > > DBI:ODBC + Openlink > > > > > > > > And can get none of them to work - however Merant's Sequalink seems the > > > > most promising as it says that it can verify the DSN okay, However > > > > DBI:ODBC > > > > > > won't use it - says driver manager cant connect and no default driver > > > > specified. > > > > > > > > If we can't get it connected we may have to consider other RADIUS > > > > servers, > > > > > > like bundled MS one, but hopefully we can get Radiator talking to the > > > > MS SQL before then. > > > > > > > > Any comments would be appreciated. > > > > > > > > Regards, > > > > Jamz. > > > > > > > > _____ > > > > > > > > > > > > Jamz Boman > > > > Internal Systems Developer > > > > <http://www.airnet.com.au/> > > > > Ph: (08) 8168 8068 > > > > Ph: (08) 8211 9200 > > > > 149 Currie Street, Adelaide > > > > South Australia 5000 > > > > Australia > > > > "I have as yet to establish a telepathic link to your computer, please > > > > wait..." > > > > -- Andrew Hill on Customer Support > > > > > > ---------------------------------------- > > > Content-Type: text/html; name="Attachment: 1" > > > Content-Transfer-Encoding: quoted-printable > > > Content-Description: > > > ---------------------------------------- > > > > > > -- > > > Radiator: the most portable, flexible and configurable RADIUS server > > > anywhere. Available on *NIX, *BSD, Windows 95/98/2000, NT, MacOS X. > > > - > > > Nets: internetwork inventory and management - graphical, extensible, > > > flexible with hardware, software, platform and database independence. > > > === > > > Archive at http://www.open.com.au/archives/radiator/ > > > Announcements on [EMAIL PROTECTED] > > > To unsubscribe, email '[EMAIL PROTECTED]' with > > > 'unsubscribe radiator' in the body of the message. > > -- > Radiator: the most portable, flexible and configurable RADIUS server > anywhere. Available on *NIX, *BSD, Windows 95/98/2000, NT, MacOS X. > - > Nets: internetwork inventory and management - graphical, extensible, > flexible with hardware, software, platform and database independence. > === > Archive at http://www.open.com.au/archives/radiator/ > Announcements on [EMAIL PROTECTED] > To unsubscribe, email '[EMAIL PROTECTED]' with > 'unsubscribe radiator' in the body of the message. === Archive at http://www.open.com.au/archives/radiator/ Announcements on [EMAIL PROTECTED] To unsubscribe, email '[EMAIL PROTECTED]' with 'unsubscribe radiator' in the body of the message.
