Hi
I tried my level best to get this query going on but its still not get
into proper action.
I am writing down the debug info from Radius Server. Have a look over
it and let me know that how can i get this query going on.
Scenario:
a user 'masad2' is calling another endpoint 'user'. After looking at
first query request reply, u can see that Radius send Access-Accept.
But then the request comes up again from Calling Station (I didnt do
it by myself rather program gets its execution after single click). So
how can i continue with accepting the first request only and not to
process the rest of the requests?
Debug:
Supplying it as an Attachment Cz its big for writing over here.
Thanx
On 5/20/05, Marcin Jessa [EMAIL PROTECTED] wrote:
Hi.
Looks like this query will use quite a while to get executed.
What does the debug mode say? Any timeouts?
Regards,
Marcin Jessa
On Fri, 20 May 2005 13:16:20 +0500
Kamran Bukhari [EMAIL PROTECTED] wrote:
Hello
I want to do the authentication using MYsql on Radius. I was doing it
till now when i ended up with new query of my own. I developed a new
query for authentication which is not allowing me to enter. Help me
out with it.
authorize_check_query = SELECT DISTINCT
${authcheck_table}.id,${authcheck_table}.UserName,${authcheck_table}.Attribute,${authcheck_table}.Value,${authcheck_table}.op
FROM ${authcheck_table}, ${groupcheck_table} WHERE
(${authcheck_table}.Username = '%{Calling-Station-Id}') and
(${authcheck_table}.Permission = 'allow') and
(${groupcheck_table}.Permission='allow') and
(${groupcheck_table}.UserName='%{Calling-Station-Id}') and
(${groupcheck_table}.Blocked='Called-Station-Id') ORDER BY
${authcheck_table}.id
authcheck_table is like this
IdUserName Attribute op Value Permission
and my groupcheck_table table is like this
UserNameBlockedPermission
The basic problem I am facing is that i want to use alias from
calling-station-id. How can i do this ? I want to cut alias from both
the attributes (Calling-Station-Id and Called-Station-Id) and then
want to match them against the values in the table.
Help me out
--
Kamran Bukhari
-
List info/subscribe/unsubscribe? See
http://www.freeradius.org/list/users.html
--
Kamran Bukhari
rad_recv: Access-Request packet from host 150.150.15.112:3893, id=255,
length=227
User-Name = masad2
User-Password = common
NAS-IP-Address = 127.0.0.1
NAS-Identifier = GK2
NAS-Port-Type = Virtual
Service-Type = Login-User
Framed-IP-Address = 150.150.15.112
Calling-Station-Id = masad2
Called-Station-Id = user
h323-conf-id = h323-conf-id=4B53E709 5F31810 96D1000C F171813D
h323-call-origin = h323-call-origin=originate
h323-call-type = h323-call-type=VoIP
h323-gw-id = h323-gw-id=GK2
Processing the authorize section of radiusd.conf
modcall: entering group authorize for request 0
radius_xlat: '/usr/local/var/log/radius/radacct//auth-detail-20050524'
rlm_detail:
/usr/local/var/log/radius/radacct/%{Client-IP-Address}/auth-detail-%Y%m%d
expands to /usr/local/var/log/radius/radacct//auth-detail-20050524
modcall[authorize]: module auth_log returns ok for request 0
radius_xlat: 'masad2'
rlm_sql (sql): sql_set_user escaped user -- 'masad2'
radius_xlat: 'SELECT DISTINCT
radcheck.id,radcheck.UserName,radcheck.Attribute,radcheck.Value,radcheck.op
FROM radcheck, Block WHERE (radcheck.Username = 'masad2') and
(radcheck.Permission = 'allow') and (Block.Permission='allow') and
(Block.UserName='masad2') and (Block.Blocked='user') ORDER BY radcheck.id'
rlm_sql (sql): Reserving sql socket id: 4
rlm_sql_mysql: query: SELECT DISTINCT
radcheck.id,radcheck.UserName,radcheck.Attribute,radcheck.Value,radcheck.op
FROM radcheck, Block WHERE (radcheck.Username = 'masad2') and
(radcheck.Permission = 'allow') and (Block.Permission='allow') and
(Block.UserName='masad2') and (Block.Blocked='user') ORDER BY radcheck.id
radius_xlat: ''
radius_xlat: 'SELECT DISTINCT
radcheck.id,radcheck.UserName,radcheck.Attribute,radcheck.Value,radcheck.op
FROM radcheck, Block WHERE (radcheck.Username = 'masad2') and
(radcheck.Permission = 'allow') and (Block.Permission='allow') and
(Block.UserName='masad2') and (Block.Blocked='user') ORDER BY radcheck.id'
rlm_sql_mysql: query: SELECT DISTINCT
radcheck.id,radcheck.UserName,radcheck.Attribute,radcheck.Value,radcheck.op
FROM radcheck, Block WHERE (radcheck.Username = 'masad2') and
(radcheck.Permission = 'allow') and (Block.Permission='allow') and
(Block.UserName='masad2') and (Block.Blocked='user') ORDER BY radcheck.id
radius_xlat: ''
rlm_sql (sql): Released sql socket id: 4
modcall[authorize]: module sql returns ok for request 0
modcall: group authorize returns ok for request 0
auth: type Local
auth: user supplied User-Password matches local User-Password
Sending Access-Accept of id 255