Thank you so much for your time Alan.
> Configure both modules:
Yup - I did that..
> And then list them both in the "instantiate" section
Yup - I eventually did that too.. My concern is that if I list 2 sql instances
and both have readclients=yes and either one is down, then FR won't start.
I read another thread about this and it didn't seem like there was a way around
this currently. I would be willing to create an enhancement if you think it's
a reasonable thing to do and if you would entertain the possibility of
accepting the patch. If so, and you'd like to provide some guidance on how
you'd like to see it implemented, let me know. Or, I can propose something and
ask for your feedback if you'd prefer.
> Then in the virtual server for the dynamic client,
> list them in a redundant section:
Ugh - I had redundant in the instantiate.
One more thing.. I'm having trouble getting redundancy to work in the dynamic
client virtual server:
authorize {
redundant sqlha {
sqlaugs
sqlroch
}
if ("%{sqlha: SELECT nasname FROM nas
WHERE nasname = '%{Packet-Src-IP-Address}'}") {
update control {
FreeRADIUS-Client-IP-Address = "%{Packet-Src-IP-Address}"
FreeRADIUS-Client-Shortname = "%{sqlha: SELECT shortname FROM nas
WHERE nasname = '%{Packet-Src-IP-Address}'}"
FreeRADIUS-Client-Secret = "%{sqlha: SELECT secret FROM nas
WHERE nasname = '%{Packet-Src-IP-Address}'}"
FreeRADIUS-Client-NAS-Type = "%{sqlha: SELECT type FROM nas
WHERE nasname = '%{Packet-Src-IP-Address}'}"
}
}
}
Note: query lines are split above for readability - they are not split in the
config.
I've tried sqlha as a prefix, as shown above, which I now know is wrong because
it has no xlate capability (if I'm reading the code correctly). I also tried
sqlroch and sqlaugs as a prefix. If I use a prefix of a database that is down,
then it never tries the 2nd choice for the assignment stmts (it does try the
2nd choice for the if stmt). If I use the prefix of a database that is up, it
works fine for assignment and if stmts. I attached the debug output for all 3
tests. For all 3 tests, sqlroch was up and sqlaugs was down.
Am I doing something wrong or is this a bug? I thought about using an else
block that uses the other sql module as a prefix; but, if that's needed, then
what is the purpose of redundant?
Thanks again for your help.
rad_recv: Access-Request packet from host 10.117.80.168 port 60947, id=81,
length=93
Thu Sep 17 14:58:40 2009 : Debug: server dynamic_client_server {
Thu Sep 17 14:58:40 2009 : Info: radius_xlat: Calling decode_attribute with
{User-Name}
Thu Sep 17 14:58:40 2009 : Info: decode_attribute: {User-Name}
Thu Sep 17 14:58:40 2009 : Info: radius_xlat: Back from decode_attribute with
Thu Sep 17 14:58:40 2009 : Debug: rlm_sql (sqlaugs): Ignoring unconnected
handle 4..
Thu Sep 17 14:58:40 2009 : Debug: rlm_sql (sqlaugs): Ignoring unconnected
handle 3..
Thu Sep 17 14:58:40 2009 : Debug: rlm_sql (sqlaugs): Ignoring unconnected
handle 2..
Thu Sep 17 14:58:40 2009 : Debug: rlm_sql (sqlaugs): Ignoring unconnected
handle 1..
Thu Sep 17 14:58:40 2009 : Debug: rlm_sql (sqlaugs): Ignoring unconnected
handle 0..
Thu Sep 17 14:58:40 2009 : Info: rlm_sql (sqlaugs): There are no DB handles to
use! skipped 5, tried to connect 0
Thu Sep 17 14:58:40 2009 : Error: rlm_sql: Error getting sql socket - returning
FAIL
Thu Sep 17 14:58:40 2009 : Info: radius_xlat: Calling decode_attribute with
{User-Name}
Thu Sep 17 14:58:40 2009 : Info: decode_attribute: {User-Name}
Thu Sep 17 14:58:40 2009 : Info: radius_xlat: Back from decode_attribute with
Thu Sep 17 14:58:40 2009 : Debug: rlm_sql (sqlroch): Reserving sql socket id: 4
Thu Sep 17 14:58:40 2009 : Info: rlm_sql: Xlating authorize_check_query...
Thu Sep 17 14:58:40 2009 : Info: radius_xlat: Calling decode_attribute with
{SQL-User-Name}',NULL,NULL,NULL
Thu Sep 17 14:58:40 2009 : Info: decode_attribute:
{SQL-User-Name}',NULL,NULL,NULL
Thu Sep 17 14:58:40 2009 : Info: radius_xlat: Back from decode_attribute with
Thu Sep 17 14:58:40 2009 : Debug: query: SELECT 1,'',NULL,NULL,NULL
Thu Sep 17 14:58:40 2009 : Info: rlm_sql: Calling rlm_sql_process_groups...
Thu Sep 17 14:58:40 2009 : Info: rlm_sql: Found 0 groups
Thu Sep 17 14:58:40 2009 : Debug: rlm_sql (sqlroch): Released sql socket id: 4
Thu Sep 17 14:58:40 2009 : Info: rlm_sql: Finished rlm_sql_authorize
Thu Sep 17 14:58:40 2009 : Info: radius_evaluate_condition: ("%{sqlaugs: SELECT
nasname FROM nas WHERE nasname = '%{Packet-Src-IP-Address}'}")
Thu Sep 17 14:58:40 2009 : Info: >>> RECURSING WITH ... "%{sqlaugs: SELECT
nasname FROM nas WHERE nasname = '%{Packet-Src-IP-Address}'}")
Thu Sep 17 14:58:40 2009 : Info: radius_evaluate_condition: "%{sqlaugs: SELECT
nasname FROM nas WHERE nasname = '%{Packet-Src-IP-Address}'}")
Thu Sep 17 14:58:40 2009 : Info: >>> LOOKING AT "%{sqlaugs: SELECT nasname FROM
nas WHERE nasname = '%{Packet-Src-IP-Address}'}")
Thu Sep 17 14:58:40 2009 : Info: expand_string: Calling radius_xlat with
%{sqlaugs: SELECT nasname FROM nas WHERE nasname = '%{Packet-Src-IP-Address}'}
Thu Sep 17 14:58:40 2009 : Info: radius_xlat: Calling decode_attribute with
{sqlaugs: SELECT nasname FROM nas WHERE nasname = '%{Packet-Src-IP-Address}'}
Thu Sep 17 14:58:40 2009 : Info: decode_attribute: {sqlaugs: SELECT nasname
FROM nas WHERE nasname = '%{Packet-Src-IP-Address}'}
Thu Sep 17 14:58:40 2009 : Info: rlm_sql_xlat: Called with ' SELECT nasname
FROM nas WHERE nasname = '%{Packet-Src-IP-Address}''
Thu Sep 17 14:58:40 2009 : Info: radius_xlat: Calling decode_attribute with
{User-Name}
Thu Sep 17 14:58:40 2009 : Info: decode_attribute: {User-Name}
Thu Sep 17 14:58:40 2009 : Info: radius_xlat: Back from decode_attribute with
Thu Sep 17 14:58:40 2009 : Info: radius_xlat: Calling decode_attribute with
{Packet-Src-IP-Address}'
Thu Sep 17 14:58:40 2009 : Info: decode_attribute: {Packet-Src-IP-Address}'
Thu Sep 17 14:58:40 2009 : Info: radius_xlat: Back from decode_attribute with
Thu Sep 17 14:58:40 2009 : Info: rlm_sql_xlat: radius_xlat returned ' SELECT
nasname FROM nas WHERE nasname = '10.117.80.168''
Thu Sep 17 14:58:40 2009 : Debug: rlm_sql (sqlaugs): Ignoring unconnected
handle 4..
Thu Sep 17 14:58:40 2009 : Debug: rlm_sql (sqlaugs): Ignoring unconnected
handle 3..
Thu Sep 17 14:58:40 2009 : Debug: rlm_sql (sqlaugs): Ignoring unconnected
handle 2..
Thu Sep 17 14:58:40 2009 : Debug: rlm_sql (sqlaugs): Ignoring unconnected
handle 1..
Thu Sep 17 14:58:40 2009 : Debug: rlm_sql (sqlaugs): Ignoring unconnected
handle 0..
Thu Sep 17 14:58:40 2009 : Info: radius_xlat: Back from decode_attribute with
Thu Sep 17 14:58:40 2009 : Info: >>> Comparison returned 0
Thu Sep 17 14:58:40 2009 : Info: >>> GOT result 0
Thu Sep 17 14:58:40 2009 : Info: >>> AT EOL -> 0
Thu Sep 17 14:58:40 2009 : Info: >>> AFTER RECURSION ... )
Thu Sep 17 14:58:40 2009 : Info: >>> AT EOL -> 0
Thu Sep 17 14:58:40 2009 : Debug: } # server dynamic_client_server
Thu Sep 17 14:58:40 2009 : Debug: - Cannot add client 10.117.80.168: Required
attribute "FreeRADIUS-Client-Secret" is missing.
Thu Sep 17 14:58:40 2009 : Error: Ignoring request to authentication address *
port 1812 from unknown client 10.117.80.168 port 60947
Thu Sep 17 14:58:40 2009 : Debug: Ready to process requests.
rad_recv: Access-Request packet from host 10.117.80.168 port 61874, id=21,
length=93
Thu Sep 17 15:08:21 2009 : Debug: server dynamic_client_server {
Thu Sep 17 15:08:21 2009 : Info: radius_xlat: Calling decode_attribute with
{User-Name}
Thu Sep 17 15:08:21 2009 : Info: decode_attribute: {User-Name}
Thu Sep 17 15:08:21 2009 : Info: radius_xlat: Back from decode_attribute with
Thu Sep 17 15:08:21 2009 : Debug: rlm_sql (sqlaugs): Ignoring unconnected
handle 4..
Thu Sep 17 15:08:21 2009 : Debug: rlm_sql (sqlaugs): Ignoring unconnected
handle 3..
Thu Sep 17 15:08:21 2009 : Debug: rlm_sql (sqlaugs): Ignoring unconnected
handle 2..
Thu Sep 17 15:08:21 2009 : Debug: rlm_sql (sqlaugs): Ignoring unconnected
handle 1..
Thu Sep 17 15:08:21 2009 : Debug: rlm_sql (sqlaugs): Ignoring unconnected
handle 0..
Thu Sep 17 15:08:21 2009 : Info: rlm_sql (sqlaugs): There are no DB handles to
use! skipped 5, tried to connect 0
Thu Sep 17 15:08:21 2009 : Error: rlm_sql: Error getting sql socket - returning
FAIL
Thu Sep 17 15:08:21 2009 : Info: radius_xlat: Calling decode_attribute with
{User-Name}
Thu Sep 17 15:08:21 2009 : Info: decode_attribute: {User-Name}
Thu Sep 17 15:08:21 2009 : Info: radius_xlat: Back from decode_attribute with
Thu Sep 17 15:08:21 2009 : Debug: rlm_sql (sqlroch): Reserving sql socket id: 4
Thu Sep 17 15:08:21 2009 : Info: rlm_sql: Xlating authorize_check_query...
Thu Sep 17 15:08:21 2009 : Info: radius_xlat: Calling decode_attribute with
{SQL-User-Name}',NULL,NULL,NULL
Thu Sep 17 15:08:21 2009 : Info: decode_attribute:
{SQL-User-Name}',NULL,NULL,NULL
Thu Sep 17 15:08:21 2009 : Info: radius_xlat: Back from decode_attribute with
Thu Sep 17 15:08:21 2009 : Debug: query: SELECT 1,'',NULL,NULL,NULL
Thu Sep 17 15:08:21 2009 : Info: rlm_sql: Calling rlm_sql_process_groups...
Thu Sep 17 15:08:21 2009 : Info: rlm_sql: Found 0 groups
Thu Sep 17 15:08:21 2009 : Debug: rlm_sql (sqlroch): Released sql socket id: 4
Thu Sep 17 15:08:21 2009 : Info: rlm_sql: Finished rlm_sql_authorize
Thu Sep 17 15:08:21 2009 : Info: radius_evaluate_condition: ("%{sqlha: SELECT
nasname FROM nas WHERE nasname = '%{Packet-Src-IP-Address}'}")
Thu Sep 17 15:08:21 2009 : Info: >>> RECURSING WITH ... "%{sqlha: SELECT
nasname FROM nas WHERE nasname = '%{Packet-Src-IP-Address}'}")
Thu Sep 17 15:08:21 2009 : Info: radius_evaluate_condition: "%{sqlha: SELECT
nasname FROM nas WHERE nasname = '%{Packet-Src-IP-Address}'}")
Thu Sep 17 15:08:21 2009 : Info: >>> LOOKING AT "%{sqlha: SELECT nasname FROM
nas WHERE nasname = '%{Packet-Src-IP-Address}'}")
Thu Sep 17 15:08:21 2009 : Info: expand_string: Calling radius_xlat with
%{sqlha: SELECT nasname FROM nas WHERE nasname = '%{Packet-Src-IP-Address}'}
Thu Sep 17 15:08:21 2009 : Info: radius_xlat: Calling decode_attribute with
{sqlha: SELECT nasname FROM nas WHERE nasname = '%{Packet-Src-IP-Address}'}
Thu Sep 17 15:08:21 2009 : Info: decode_attribute: {sqlha: SELECT nasname FROM
nas WHERE nasname = '%{Packet-Src-IP-Address}'}
Thu Sep 17 15:08:21 2009 : Info: radius_xlat: Back from decode_attribute with
Thu Sep 17 15:08:21 2009 : Info: >>> Comparison returned 0
Thu Sep 17 15:08:21 2009 : Info: >>> GOT result 0
Thu Sep 17 15:08:21 2009 : Info: >>> AT EOL -> 0
Thu Sep 17 15:08:21 2009 : Info: >>> AFTER RECURSION ... )
Thu Sep 17 15:08:21 2009 : Info: >>> AT EOL -> 0
Thu Sep 17 15:08:21 2009 : Debug: } # server dynamic_client_server
Thu Sep 17 15:08:21 2009 : Debug: - Cannot add client 10.117.80.168: Required
attribute "FreeRADIUS-Client-Secret" is missing.
Thu Sep 17 15:08:21 2009 : Error: Ignoring request to authentication address *
port 1812 from unknown client 10.117.80.168 port 61874
Thu Sep 17 15:08:21 2009 : Debug: Ready to process requests.
rad_recv: Access-Request packet from host 10.117.80.168 port 62503, id=162,
length=93
Thu Sep 17 15:00:42 2009 : Debug: server dynamic_client_server {
Thu Sep 17 15:00:42 2009 : Info: radius_xlat: Calling decode_attribute with
{User-Name}
Thu Sep 17 15:00:42 2009 : Info: decode_attribute: {User-Name}
Thu Sep 17 15:00:42 2009 : Info: radius_xlat: Back from decode_attribute with
Thu Sep 17 15:00:42 2009 : Debug: rlm_sql (sqlaugs): Ignoring unconnected
handle 4..
Thu Sep 17 15:00:42 2009 : Debug: rlm_sql (sqlaugs): Ignoring unconnected
handle 3..
Thu Sep 17 15:00:42 2009 : Debug: rlm_sql (sqlaugs): Ignoring unconnected
handle 2..
Thu Sep 17 15:00:42 2009 : Debug: rlm_sql (sqlaugs): Ignoring unconnected
handle 1..
Thu Sep 17 15:00:42 2009 : Debug: rlm_sql (sqlaugs): Ignoring unconnected
handle 0..
Thu Sep 17 15:00:42 2009 : Info: rlm_sql (sqlaugs): There are no DB handles to
use! skipped 5, tried to connect 0
Thu Sep 17 15:00:42 2009 : Error: rlm_sql: Error getting sql socket - returning
FAIL
Thu Sep 17 15:00:42 2009 : Info: radius_xlat: Calling decode_attribute with
{User-Name}
Thu Sep 17 15:00:42 2009 : Info: decode_attribute: {User-Name}
Thu Sep 17 15:00:42 2009 : Info: radius_xlat: Back from decode_attribute with
Thu Sep 17 15:00:42 2009 : Debug: rlm_sql (sqlroch): Reserving sql socket id: 4
Thu Sep 17 15:00:42 2009 : Info: rlm_sql: Xlating authorize_check_query...
Thu Sep 17 15:00:42 2009 : Info: radius_xlat: Calling decode_attribute with
{SQL-User-Name}',NULL,NULL,NULL
Thu Sep 17 15:00:42 2009 : Info: decode_attribute:
{SQL-User-Name}',NULL,NULL,NULL
Thu Sep 17 15:00:42 2009 : Info: radius_xlat: Back from decode_attribute with
Thu Sep 17 15:00:42 2009 : Debug: query: SELECT 1,'',NULL,NULL,NULL
Thu Sep 17 15:00:42 2009 : Info: rlm_sql: Calling rlm_sql_process_groups...
Thu Sep 17 15:00:42 2009 : Info: rlm_sql: Found 0 groups
Thu Sep 17 15:00:42 2009 : Debug: rlm_sql (sqlroch): Released sql socket id: 4
Thu Sep 17 15:00:42 2009 : Info: rlm_sql: Finished rlm_sql_authorize
Thu Sep 17 15:00:42 2009 : Info: radius_evaluate_condition: ("%{sqlroch: SELECT
nasname FROM nas WHERE nasname = '%{Packet-Src-IP-Address}'}")
Thu Sep 17 15:00:42 2009 : Info: >>> RECURSING WITH ... "%{sqlroch: SELECT
nasname FROM nas WHERE nasname = '%{Packet-Src-IP-Address}'}")
Thu Sep 17 15:00:42 2009 : Info: radius_evaluate_condition: "%{sqlroch: SELECT
nasname FROM nas WHERE nasname = '%{Packet-Src-IP-Address}'}")
Thu Sep 17 15:00:42 2009 : Info: >>> LOOKING AT "%{sqlroch: SELECT nasname FROM
nas WHERE nasname = '%{Packet-Src-IP-Address}'}")
Thu Sep 17 15:00:42 2009 : Info: expand_string: Calling radius_xlat with
%{sqlroch: SELECT nasname FROM nas WHERE nasname = '%{Packet-Src-IP-Address}'}
Thu Sep 17 15:00:42 2009 : Info: radius_xlat: Calling decode_attribute with
{sqlroch: SELECT nasname FROM nas WHERE nasname = '%{Packet-Src-IP-Address}'}
Thu Sep 17 15:00:42 2009 : Info: decode_attribute: {sqlroch: SELECT nasname
FROM nas WHERE nasname = '%{Packet-Src-IP-Address}'}
Thu Sep 17 15:00:42 2009 : Info: rlm_sql_xlat: Called with ' SELECT nasname
FROM nas WHERE nasname = '%{Packet-Src-IP-Address}''
Thu Sep 17 15:00:42 2009 : Info: radius_xlat: Calling decode_attribute with
{User-Name}
Thu Sep 17 15:00:42 2009 : Info: decode_attribute: {User-Name}
Thu Sep 17 15:00:42 2009 : Info: radius_xlat: Back from decode_attribute with
Thu Sep 17 15:00:42 2009 : Info: radius_xlat: Calling decode_attribute with
{Packet-Src-IP-Address}'
Thu Sep 17 15:00:42 2009 : Info: decode_attribute: {Packet-Src-IP-Address}'
Thu Sep 17 15:00:42 2009 : Info: radius_xlat: Back from decode_attribute with
Thu Sep 17 15:00:42 2009 : Info: rlm_sql_xlat: radius_xlat returned ' SELECT
nasname FROM nas WHERE nasname = '10.117.80.168''
Thu Sep 17 15:00:42 2009 : Debug: rlm_sql (sqlroch): Reserving sql socket id: 3
Thu Sep 17 15:00:42 2009 : Debug: query: SELECT nasname FROM nas WHERE
nasname = '10.117.80.168'
Thu Sep 17 15:00:42 2009 : Debug: rlm_sql (sqlroch): Released sql socket id: 3
Thu Sep 17 15:00:42 2009 : Info: radius_xlat: Back from decode_attribute with
Thu Sep 17 15:00:42 2009 : Info: >>> Comparison returned 1
Thu Sep 17 15:00:42 2009 : Info: >>> GOT result 1
Thu Sep 17 15:00:42 2009 : Info: >>> AT EOL -> 1
Thu Sep 17 15:00:42 2009 : Info: >>> AFTER RECURSION ... )
Thu Sep 17 15:00:42 2009 : Info: >>> AT EOL -> 1
Thu Sep 17 15:00:42 2009 : Info: expand_string: Calling radius_xlat with
%{Packet-Src-IP-Address}
Thu Sep 17 15:00:42 2009 : Info: radius_xlat: Calling decode_attribute with
{Packet-Src-IP-Address}
Thu Sep 17 15:00:42 2009 : Info: decode_attribute: {Packet-Src-IP-Address}
Thu Sep 17 15:00:42 2009 : Info: radius_xlat: Back from decode_attribute with
Thu Sep 17 15:00:42 2009 : Info: expand_string: Calling radius_xlat with
%{sqlroch: SELECT shortname FROM nas WHERE nasname = '%{Packet-Src-IP-Address}'}
Thu Sep 17 15:00:42 2009 : Info: radius_xlat: Calling decode_attribute with
{sqlroch: SELECT shortname FROM nas WHERE nasname = '%{Packet-Src-IP-Address}'}
Thu Sep 17 15:00:42 2009 : Info: decode_attribute: {sqlroch: SELECT shortname
FROM nas WHERE nasname = '%{Packet-Src-IP-Address}'}
Thu Sep 17 15:00:42 2009 : Info: rlm_sql_xlat: Called with ' SELECT shortname
FROM nas WHERE nasname = '%{Packet-Src-IP-Address}''
Thu Sep 17 15:00:42 2009 : Info: radius_xlat: Calling decode_attribute with
{User-Name}
Thu Sep 17 15:00:42 2009 : Info: decode_attribute: {User-Name}
Thu Sep 17 15:00:42 2009 : Info: radius_xlat: Back from decode_attribute with
Thu Sep 17 15:00:42 2009 : Info: radius_xlat: Calling decode_attribute with
{Packet-Src-IP-Address}'
Thu Sep 17 15:00:42 2009 : Info: decode_attribute: {Packet-Src-IP-Address}'
Thu Sep 17 15:00:42 2009 : Info: radius_xlat: Back from decode_attribute with
Thu Sep 17 15:00:42 2009 : Info: rlm_sql_xlat: radius_xlat returned ' SELECT
shortname FROM nas WHERE nasname = '10.117.80.168''
Thu Sep 17 15:00:42 2009 : Debug: rlm_sql (sqlroch): Reserving sql socket id: 2
Thu Sep 17 15:00:42 2009 : Debug: query: SELECT shortname FROM nas WHERE
nasname = '10.117.80.168'
Thu Sep 17 15:00:42 2009 : Debug: rlm_sql (sqlroch): Released sql socket id: 2
Thu Sep 17 15:00:42 2009 : Info: radius_xlat: Back from decode_attribute with
Thu Sep 17 15:00:42 2009 : Info: expand_string: Calling radius_xlat with
%{sqlroch: SELECT secret FROM nas WHERE nasname = '%{Packet-Src-IP-Address}'}
Thu Sep 17 15:00:42 2009 : Info: radius_xlat: Calling decode_attribute with
{sqlroch: SELECT secret FROM nas WHERE nasname = '%{Packet-Src-IP-Address}'}
Thu Sep 17 15:00:42 2009 : Info: decode_attribute: {sqlroch: SELECT secret FROM
nas WHERE nasname = '%{Packet-Src-IP-Address}'}
Thu Sep 17 15:00:42 2009 : Info: rlm_sql_xlat: Called with ' SELECT secret FROM
nas WHERE nasname = '%{Packet-Src-IP-Address}''
Thu Sep 17 15:00:42 2009 : Info: radius_xlat: Calling decode_attribute with
{User-Name}
Thu Sep 17 15:00:42 2009 : Info: decode_attribute: {User-Name}
Thu Sep 17 15:00:42 2009 : Info: radius_xlat: Back from decode_attribute with
Thu Sep 17 15:00:42 2009 : Info: radius_xlat: Calling decode_attribute with
{Packet-Src-IP-Address}'
Thu Sep 17 15:00:42 2009 : Info: decode_attribute: {Packet-Src-IP-Address}'
Thu Sep 17 15:00:42 2009 : Info: radius_xlat: Back from decode_attribute with
Thu Sep 17 15:00:42 2009 : Info: rlm_sql_xlat: radius_xlat returned ' SELECT
secret FROM nas WHERE nasname = '10.117.80.168''
Thu Sep 17 15:00:42 2009 : Debug: rlm_sql (sqlroch): Reserving sql socket id: 1
Thu Sep 17 15:00:42 2009 : Debug: query: SELECT secret FROM nas WHERE nasname
= '10.117.80.168'
Thu Sep 17 15:00:42 2009 : Debug: rlm_sql (sqlroch): Released sql socket id: 1
Thu Sep 17 15:00:42 2009 : Info: radius_xlat: Back from decode_attribute with
Thu Sep 17 15:00:42 2009 : Info: expand_string: Calling radius_xlat with
%{sqlroch: SELECT type FROM nas WHERE nasname = '%{Packet-Src-IP-Address}'}
Thu Sep 17 15:00:42 2009 : Info: radius_xlat: Calling decode_attribute with
{sqlroch: SELECT type FROM nas WHERE nasname = '%{Packet-Src-IP-Address}'}
Thu Sep 17 15:00:42 2009 : Info: decode_attribute: {sqlroch: SELECT type FROM
nas WHERE nasname = '%{Packet-Src-IP-Address}'}
Thu Sep 17 15:00:42 2009 : Info: rlm_sql_xlat: Called with ' SELECT type FROM
nas WHERE nasname = '%{Packet-Src-IP-Address}''
Thu Sep 17 15:00:42 2009 : Info: radius_xlat: Calling decode_attribute with
{User-Name}
Thu Sep 17 15:00:42 2009 : Info: decode_attribute: {User-Name}
Thu Sep 17 15:00:42 2009 : Info: radius_xlat: Back from decode_attribute with
Thu Sep 17 15:00:42 2009 : Info: radius_xlat: Calling decode_attribute with
{Packet-Src-IP-Address}'
Thu Sep 17 15:00:42 2009 : Info: decode_attribute: {Packet-Src-IP-Address}'
Thu Sep 17 15:00:42 2009 : Info: radius_xlat: Back from decode_attribute with
Thu Sep 17 15:00:42 2009 : Info: rlm_sql_xlat: radius_xlat returned ' SELECT
type FROM nas WHERE nasname = '10.117.80.168''
Thu Sep 17 15:00:42 2009 : Debug: rlm_sql (sqlroch): Reserving sql socket id: 0
Thu Sep 17 15:00:42 2009 : Debug: query: SELECT type FROM nas WHERE nasname =
'10.117.80.168'
Thu Sep 17 15:00:42 2009 : Debug: rlm_sql (sqlroch): Released sql socket id: 0
Thu Sep 17 15:00:42 2009 : Info: radius_xlat: Back from decode_attribute with
Thu Sep 17 15:00:42 2009 : Info: ::: FROM 4 TO 0 MAX 4
Thu Sep 17 15:00:42 2009 : Info: ::: Examining FreeRADIUS-Client-IP-Address
Thu Sep 17 15:00:42 2009 : Info: ::: APPENDING FreeRADIUS-Client-IP-Address
FROM 0 TO 0
Thu Sep 17 15:00:42 2009 : Info: ::: Examining FreeRADIUS-Client-Shortname
Thu Sep 17 15:00:42 2009 : Info: ::: APPENDING FreeRADIUS-Client-Shortname FROM
1 TO 1
Thu Sep 17 15:00:42 2009 : Info: ::: Examining FreeRADIUS-Client-Secret
Thu Sep 17 15:00:42 2009 : Info: ::: APPENDING FreeRADIUS-Client-Secret FROM 2
TO 2
Thu Sep 17 15:00:42 2009 : Info: ::: Examining FreeRADIUS-Client-NAS-Type
Thu Sep 17 15:00:42 2009 : Info: ::: APPENDING FreeRADIUS-Client-NAS-Type FROM
3 TO 3
Thu Sep 17 15:00:42 2009 : Info: ::: TO in 0 out 4
Thu Sep 17 15:00:42 2009 : Info: ::: to[0] = FreeRADIUS-Client-IP-Address
Thu Sep 17 15:00:42 2009 : Info: ::: to[1] = FreeRADIUS-Client-Shortname
Thu Sep 17 15:00:42 2009 : Info: ::: to[2] = FreeRADIUS-Client-Secret
Thu Sep 17 15:00:42 2009 : Info: ::: to[3] = FreeRADIUS-Client-NAS-Type
Thu Sep 17 15:00:42 2009 : Debug: } # server dynamic_client_server
Thu Sep 17 15:00:42 2009 : Debug: - Added client 10.117.80.168 with shared
secret xxxxxxxx
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
