Powered by Jitbit Forum free trial version.
home recent topics recent posts search faq  

TekRADIUS Forum



register | lost password   open id
Messages in this topic - RSS

Home » Interoperability » Alternative Authorization Query

Interoperability with RADIUS clients & servers
23.11.2011 15:01:46

svc
svc
Posts: 3
Hello,

I have tried to use an alternative query to select the authorization parameters from the "users" table (Select * from Users where (UserName='%Key%' and AttrType = 1), tekradius sent Accesss-Accept packet without "success-reply" atributes.
What's the problem?

Segrey
0 permalink
23.11.2011 15:28:38

Admin
Admin
Administrator
Posts: 1833
Dear Segrey,

What is your exact alternative query? What attributes are returned form that query?

Best regards,

Yasin KAPLAN
0 permalink
23.11.2011 16:11:21

svc
svc
Posts: 3
Dear Yasin,

The field "Use Default Authentification Key" is unchecked.
Key is "calling-station-id".
Use default Authorezation Query is uncheked.
Auth. Query is "Select * from Users where UserName='%Key%' and AttrType=1"

log:

RadAuth req. from : 91.197.180.12:1527 - 23.11.2011 18:08:38
Size : 42 / 42
Identifier : 0
Attributes :
Calling-Station-Id = 87045678762222
User-Name = void
23.11.2011 18:08:38 - Check items control - Start (Group : Default).
23.11.2011 18:08:38 - Check items control - Stop (Group : Default).
23.11.2011 18:08:38 - Authentication successfull for user '87045678762222'
23.11.2011 18:08:38 - Fetching Success-Reply items - Start.
23.11.2011 18:08:38 - Fetching Success-Reply items - Stop.

**********************************************************************************************************************

The field "Use Default Authentification Key" is unchecked.
Key is "calling-station-id".
Use default Authorezation Query is cheked.
Auth. Query is "Select * from Users where UserName='%Key%' and AttrType=1"

log:

RadAuth req. from : 91.197.180.12:1509 - 23.11.2011 17:45:23
Size : 42 / 42
Identifier : 0
Attributes :
Calling-Station-Id = 87045678762222
User-Name = void
23.11.2011 17:45:23 - Check items control - Start (Group : Default).
23.11.2011 17:45:23 - Check items control - Stop (Group : Default).
23.11.2011 17:45:23 - Authentication successfull for user '87045678762222'
23.11.2011 17:45:23 - Fetching Success-Reply items - Start.
23.11.2011 17:45:23 - Fetching Success-Reply items - Stop.
23.11.2011 17:45:23 - Generating Reply Packet - Start.
23.11.2011 17:45:23 - Generating Reply Packet - Stop.
RadAuth reply to : 91.197.180.12:1509 - 23.11.2011 17:45:23
Size : 26
Identifier : 0
Attributes :
Framed-IP-Address = 10.10.10.10
0 permalink
24.11.2011 06:14:05

svc
svc
Posts: 3
Dear Yasin,
I have read the user manual more carefully, it works fine.
Please cancel my request. It was my fault.

Sergey
0 permalink
24.11.2011 15:15:55

Admin
Admin
Administrator
Posts: 1833
You welcome
0 permalink

Home » Interoperability » Alternative Authorization Query





Powered by Jitbit Forum 7.2.13.0 © 2006-2011 Jitbit Software