Hello
I Still Don't understand what is happens when I use realm for Callback
feature.
My Postgresql.conf:
sql_user_name = "%{Stripped-User-Name:-%{User-Name}}"
authorize_check_query = "SELECT * FROM select_check_attrs('%{SQL-User-Name}',
'%{NAS-IP-Address}', '%{Service-Type}', '%{Called-Station-Id}', '%{Realm}')"
authorize_reply_query = "SELECT * FROM select_reply_attrs('%{SQL-User-Name}',
'%{NAS-IP-Address}', '%{Service-Type}', '%{Called-Station-Id}', '%{Realm}')"
When i logs like 'user' and radiusd runs in debug mode i see:
rlm_realm: No '@' in User-Name = "test", looking up realm NULL
rlm_realm: Found realm "NULL"
rlm_realm: Adding Stripped-User-Name = "test"
rlm_realm: Proxying request from user test to realm NULL
rlm_realm: Adding Realm = "NULL"
rlm_realm: Authentication realm is LOCAL.
modcall[authorize]: module "suffix" returns noop for request 1
radius_xlat: 'test'
rlm_sql (sql): sql_set_user escaped user --> 'test'
radius_xlat: 'SELECT * FROM select_check_attrs('test',
'80.82.166.50', 'Framed-User', '790303', 'NULL')'
rlm_sql (sql): Reserving sql socket id: 13
rlm_sql_postgresql: query: SELECT * FROM select_check_attrs('test',
'80.82.166.50', 'Framed-User', '790303', 'NULL')
rlm_sql_postgresql: Status: PGRES_TUPLES_OK
rlm_sql_postgresql: affected rows =
radius_xlat: ''
radius_xlat: 'SELECT * FROM select_reply_attrs('test',
'80.82.166.50', 'Framed-User', '790303', 'NULL')'
rlm_sql_postgresql: query: SELECT * FROM select_reply_attrs('test',
'80.82.166.50', 'Framed-User', '790303', 'NULL')
rlm_sql_postgresql: Status: PGRES_TUPLES_OK
rlm_sql_postgresql: affected rows =
radius_xlat: ''
rlm_sql (sql): Released sql socket id: 13
modcall[authorize]: module "sql" returns ok for request 1
And user logs in.
When i logs like '[EMAIL PROTECTED]' and radiusd runs in debug mode i see:
modcall: entering group authorize for request 0
modcall[authorize]: module "chap" returns noop for request 0
rlm_realm: Looking up realm "cb" for User-Name = "[EMAIL PROTECTED]"
rlm_realm: Found realm "cb"
rlm_realm: Adding Stripped-User-Name = "test"
rlm_realm: Proxying request from user test to realm cb
rlm_realm: Adding Realm = "cb"
rlm_realm: Authentication realm is LOCAL.
modcall[authorize]: module "suffix" returns noop for request 0
radius_xlat: 'test'
rlm_sql (sql): sql_set_user escaped user --> 'test'
radius_xlat: 'SELECT * FROM select_check_attrs('test', '80.82.166.50',
'Framed-User', '790303', 'cb')'
rlm_sql (sql): Reserving sql socket id: 14
rlm_sql_postgresql: query: SELECT * FROM select_check_attrs('test',
'80.82.166.50', 'Framed-User', '790303', 'cb')
rlm_sql_postgresql: Status: PGRES_TUPLES_OK
rlm_sql_postgresql: affected rows =
radius_xlat: ''
radius_xlat: 'SELECT * FROM select_reply_attrs('test', '80.82.166.50',
'Framed-User', '790303', 'cb')'
rlm_sql_postgresql: query: SELECT * FROM select_reply_attrs('test',
'80.82.166.50', 'Framed-User', '790303', 'cb')
rlm_sql_postgresql: Status: PGRES_TUPLES_OK
rlm_sql_postgresql: affected rows =
radius_xlat: ''
rlm_sql (sql): No matching entry in the database for request from user [test]
rlm_sql (sql): Released sql socket id: 14
modcall[authorize]: module "sql" returns notfound for request 0
All procedures returns the same result independently of realm. Where
is My error? I simply wants to authorize user...
--
Best regards,
Motovilov mailto:[EMAIL PROTECTED]
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
