[RADIATOR] Loading configuration dynamically from SQL database

2011-04-07 Thread Remco van Noorloos
Good morning, Today I installed an evaluation version of Radiator and I'm trying to configure it in a way that matches the procedure of our current RADIUS server. What happens in the current environment with an incoming RADIUS Request is the following: 1) A so-called 'Realm' is se

Re: [RADIATOR] Loading configuration dynamically from SQL database

2011-04-08 Thread Heikki Vatiainen
On 04/07/2011 12:58 PM, Remco van Noorloos wrote: Hello Remco, > Today I installed an evaluation version of Radiator and I'm trying to > configure it in a way that matches the procedure of our current > RADIUS server. Please see below for my comments and an example of one way of recreating your

Re: [RADIATOR] Loading configuration dynamically from SQL database

2011-04-11 Thread Remco van Noorloos
Hi Heikki, Thanks for your answer! I've tried your suggestion and I managed to get some variables dynamically from an SQL database. When I try AuthColumnDef twice in two different AuthBy SQL's it doesn't seem to work though. The 'AUTH_BACKEND' and 'CONNECTION_ID' are working properly. When R

Re: [RADIATOR] Loading configuration dynamically from SQL database

2011-04-11 Thread Heikki Vatiainen
On 04/11/2011 11:42 AM, Remco van Noorloos wrote: Hello Remco, > I've tried your suggestion and I managed to get some variables dynamically > from an SQL database. > > When I try AuthColumnDef twice in two different AuthBy SQL's it doesn't seem > to work though. The 'AUTH_BACKEND' and 'CONNEC

Re: [RADIATOR] Loading configuration dynamically from SQL database

2011-04-11 Thread Remco van Noorloos
1, CONNECTION_ID, request Remco -Oorspronkelijk bericht- Van: Heikki Vatiainen [mailto:h...@open.com.au] Verzonden: maandag 11 april 2011 14:44 Aan: Remco van Noorloos CC: radiator@open.com.au Onderwerp: Re: [RADIATOR] Loading configuration dynamically from SQL database On 04/1

Re: [RADIATOR] Loading configuration dynamically from SQL database

2011-04-12 Thread Heikki Vatiainen
On 04/11/2011 05:13 PM, Remco van Noorloos wrote: > Currently we have 100+ LDAP servers we're authenticating with. So if > we have to edit the config file in order to make a change that > wouldn't be manageable for us and is a situation we really like to > avoid. That is very understandable. One

Re: [RADIATOR] Loading configuration dynamically from SQL database

2011-04-12 Thread Remco van Noorloos
EJECT, No such user Tue Apr 12 14:53:36 2011: INFO: Access rejected for prox1-a...@dsl.proxsys.net: No such user Tue Apr 12 14:53:36 2011: DEBUG: Packet dump: *** Sending to 127.0.0.1 port 1739 Code: Access-Reject Identifier: 141 Authentic: e<252><160><164><169>

Re: [RADIATOR] Loading configuration dynamically from SQL database

2011-04-12 Thread Heikki Vatiainen
gt; prepared. (SQL-42000) > Tue Apr 12 14:53:36 2011: DEBUG: AuthBy SQL result: REJECT, No such user > Tue Apr 12 14:53:36 2011: DEBUG: AuthBy HANDLER result: REJECT, No such user > Tue Apr 12 14:53:36 2011: INFO: Access rejected for > prox1-a...@dsl.proxsys.net: No such user > Tue Apr

Re: [RADIATOR] Loading configuration dynamically from SQL database

2011-04-14 Thread Remco van Noorloos
rver Driver][SQL Server]Statement(s) could not be > prepared. (SQL-42000) > Tue Apr 12 14:53:36 2011: DEBUG: AuthBy SQL result: REJECT, No such user > Tue Apr 12 14:53:36 2011: DEBUG: AuthBy HANDLER result: REJECT, No such user > Tue Apr 12 14:53:36 2011: INFO: Access rejected for > prox1-

Re: [RADIATOR] Loading configuration dynamically from SQL database

2011-04-14 Thread Heikki Vatiainen
On 04/14/2011 11:02 AM, Remco van Noorloos wrote: > Is it possible to override CONNECTION_ID with a second query / AuthColumnDef? Both AcctColumnDef in AuthBy SQL and AuthAttrDef in AuthBy LDAP2 add attributes. Both AuthBy SQL and AuthBy LDAP2 offer a hook that can be used to modify for example,