Re: (RADIATOR) FreeTDS

2000-09-28 Thread Delanet Administration
Dean, Your DBSource line is incorrect. Form as follows: DBSource dbi:FreeTDS:database=radius;host=your.host.com;port=1433 Also, I'm not sure if using a version of 4.2 will work or not on MS SQL 7.0, however I am using a version of 7.0 on my FreeTDS with no problems as ye

(RADIATOR) Update table with check/reply attributes from perl script

2000-10-16 Thread Delanet Administration
I'm trying to write a script that pulls in reply attributes from a MSSQL (Platypus) database and inserts them into an existing SUBSCRIBERS table on a MySQL database. I've got everything working fine down to one part.. The UPDATE statement fails to put the correct data in, and instead cuts short at

(RADIATOR) Rewriting usernames - adding text to a username

2000-10-23 Thread Delanet Administration
I'm trying to rewrite a username such that a predefined portion of text is added before authentication takes place. The text will most likely be one word preceded by a hyphen "-delanet" for instance. Main reason is that due to a large number of acquisitions of other ISP and hosting companies, we

(RADIATOR) Problems with SessionDatabase SQL

2000-10-27 Thread Delanet Administration
I've made a few changes to my sessiondatabase section and radiator does not seem to honor all of them. In paticular, the username seems to be returned as the plain value returned by the NAS (%u) despite my having changed it to %n. I have it declared as follows: DBSource dbi:mysql:radius DBUse

(RADIATOR) AuthByPolicy questions

2000-11-28 Thread Delanet Administration
I currently have radiator set up with 4 fall throughs in an AuthBy group with a AuthBypolicy of ContinueUntilAccept. My only issue with this is that if a customer exceeds their simultaneous use limit it continues to fall through the checks till the last one fails before rejecting the customer as

(RADIATOR) Errors on DB connect failure

2000-12-07 Thread Delanet Administration
Noticed the following errors in my logs when one of my servers started radiusd before mysql was running. I understand the connect failure and backing off. What I am questioning is the 'Undefined subroutine' errors. I'm not suffering any problems that I can see from it (when I startup properly) how

Re: (RADIATOR) Freetds and radius

2000-12-15 Thread Delanet Administration
Just a warning, the FreeTDS 5.0 and 5.1 both have given us alot of trouble with memory leaks. We had about 2000 incoming lines and authenticated on mysql, but sent out accounting to a MS SQL 6.5 server using DBD:Sybase 0.23 and FreeTDS (both versions above). Memory leaked such that 4 days run time

(RADIATOR) Re: (Fwd) BOUNCE radiator@open.com.au: Admin request of type /^\s*config\b/i at line 8

2001-01-09 Thread Delanet Administration
Ok I understand how it works now. Why is there an option for special characters at all in the addquery if it uses the value passed to accounting reardless? And is there a way to remove the realm or rewrite the username *after* the insert into accounting? Reason I need this is that my billing sys