Freeradius wont retry to connect SQL

2005-12-06 Thread Fernando Brito
Hello. I’m using freeradius 1.0.5. I have 3 radiusd running on the same machine (a radiusd connects to mysql, the other two, connects to SQL using unixODBC 2.2.4-11 and freetds 0.61-6.2).   Everything works fine until I stop the SQL server. The radiusd won’t try to re-connect to SQL and I

SQL and MSSQL databases diference

2005-11-15 Thread Fernando Brito
Hi, here is another question. In the first case I'm using an mssql module to connect to my database and the "radiusd -X" command tell me something like this: radiusd -X --- rlm_sql (mssql): Driver rlm_sql_unixodbc (module rlm_sql_unixodbc) loaded and linked rlm_sql (mssql): Attemp

MSSQL Querys -> No matching entry

2005-11-15 Thread Fernando Brito
Hi, I'm trying to make a simple authorization using the mssql module but when Radius execute all the querys "No matching entry..." is the answer. I'm completely sure that all the data store in my database is correct, but I always had the same responce: radiusd -X - radius

Re: FreeRadius using two SQL servers

2005-11-15 Thread Fernando Brito
El mar, 15-11-2005 a las 13:23 -0500, Dusty Doris escribió: > > what do you think if we try to use a Perl module inside of the autorize > > section?!?!. I want the Perl module to decide between my two sql servers > > depending of the incoming realm, I think this can be a possible way to > > take. I

RE: Problem using exec module

2005-11-15 Thread Fernando Brito
Sorry, but I had tryed that out and it didn't work. In the second run of the "authorize" section radiusd never touch the subsections, but my guess is that the Autz-Type variable is always empty, even after running the files module: users file DEFAULT Auth-Type := System, Real

Re: Problem using exec module

2005-11-15 Thread Fernando Brito
El mar, 15-11-2005 a las 12:00 +0100, Nicolas Baradakis escribió: > %{check:Autz-Type} Thanks for the advice, I just tryed it and the error is gone but the variable appears to be empty. I'll keep trying but if you have another idea I'll be too glad to hear about it. Thanks and bye!! NanO - Lis

Problem using exec module

2005-11-14 Thread Fernando Brito
Hi, I'm trying to use the next exec module: radius.conf --- modules { exec { wait = yes input_pairs = request } exec echo { wait = yes program = "/bin/echo %{Autz-Type}" input_p

RE: FreeRadius using two SQL servers

2005-11-14 Thread Fernando Brito
and in radiusd.conf: > > > authorize { > > files > > Autz-Type AUTZ_SQL1 { > SQL1 > } > > Autz-Type AUTZ_SQL2 { > SQL2 > } > > } > > > Hope that helps, > Mike > > > > -Original Message- > &g

FreeRadius using two SQL servers

2005-11-14 Thread Fernando Brito
Hi, my version of FreeRadius is 1.0.5 and what I'm trying to do is that when a radius client ask my freeradius, if the Realm is "" I want to autorize him with the first SQL server and if the Realm is "" with the second one. I already have two diferent sql configuration files, sql1.conf and