23.11.2011 15:01:46
 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 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 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 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 Administrator Posts: 1833
|
You welcome
|
|
|
0
• permalink
|