[RADIATOR] SQL Insert
Ricardo Martinez
rmartinez at redvoiss.net
Tue Nov 24 15:22:30 CST 2009
Don't worry I've found the solution.
I've made the password match.
Thanks
Ricardo.-
-----Mensaje original-----
De: radiator-bounces at open.com.au [mailto:radiator-bounces at open.com.au]
En nombre de Ricardo Martinez
Enviado el: martes, 24 de noviembre de 2009 16:33
Para: Hugh Irvine
CC: radiator at open.com.au
Asunto: Re: [RADIATOR] SQL Insert
Hello Hugh.
I did what you told me. It works !... the parameter is inserted in the
database, but I have a doubt about the whole process
Look at this debug :
Attributes:
Callback-Number = "5233717"
User-Name = "1613390"
User-Password = "|u9<211>U>>99>qt<139>c<1198><182>"
Service-Type = Login-User
Called-Station-Id = "dummy"
Calling-Station-Id = "01234567890"
NAS-IP-Address = 127.0.0.1
NAS-Port = 0
cisco-h323-prompt-id = "30136"
cisco-h323-billing-model = " ani"
cisco-h323-conf-id = "h323-conf-id=69EA98F0 1A3711CC 8096FD43
D222166E"
Tue Nov 24 15:30:38 2009: DEBUG: Handling request with Handler
'Request-Type = Access-Request, cisco-h323-billing-model =ani'
Tue Nov 24 15:30:38 2009: DEBUG: Deleting session for 1613390,
127.0.0.1, 0
Tue Nov 24 15:30:38 2009: DEBUG: Handling with Radius::AuthSQL
Tue Nov 24 15:30:38 2009: DEBUG: do query is: 'insert into ani
(ani,usua) values ('5233717',30136)':
Tue Nov 24 15:30:38 2009: DEBUG: Handling with Radius::AuthSQL:
Tue Nov 24 15:30:38 2009: DEBUG: Query is: 'select 1 from dual':
Tue Nov 24 15:30:38 2009: DEBUG: Radius::AuthSQL looks for match with
1613390
Tue Nov 24 15:30:38 2009: DEBUG: Radius::AuthSQL REJECT: Bad Password
Tue Nov 24 15:30:38 2009: DEBUG: AuthBy SQL result: REJECT, Bad Password
Tue Nov 24 15:30:38 2009: INFO: Access rejected for 1613390: Bad
Password
Tue Nov 24 15:30:38 2009: DEBUG: Packet dump:
*** Sending to 64.76.154.108 port 35912 ....
Code: Access-Reject
Identifier: 96
Authentic: <135>F<192>##J<252>+<206>~<18><255><232><252><152>h
Attributes:
Reply-Message = "Request Denied"
After the AuthSQLStatement I put a AuthSelect with "select 1 from dual"
but it seems to fail.
I even tried a AuthSelect empty but it tries to match password with
users... and it fails too.
Can I just make the insert?
Hope you can help me.
Regards,
Ricardo.-
-----Mensaje original-----
De: Hugh Irvine [mailto:hugh at open.com.au]
Enviado el: viernes, 20 de noviembre de 2009 18:56
Para: Ricardo Martinez
CC: radiator at open.com.au
Asunto: Re: [RADIATOR] SQL Insert
Hello Ricardo -
You can add an AuthSQLStatement to your AuthBy SQL clause:
.....
<AuthBy SQL>
.....
AuthSQLStatement .......
.....
</AuthBy>
.....
BTW - the current release is Radiator 4.5.1.
regards
Hugh
On 21 Nov 2009, at 07:56, Ricardo Martinez wrote:
> Hello List.
> I'm using Radiator 3.13. I'm trying to insert a value in my Oracle
DB, through radiator.
> For example if I have the next Access-Request :
>
> Code: Access-Request
> Identifier: 243
> Authentic:
<240><221><183><244><187><202><143><171><15><229><220>d<226><211>E<198>
> Attributes:
> User-Name = "173"
> Service-Type = Login-User
> Called-Station-Id = "003490878"
> Calling-Station-Id = "01234890"
> NAS-IP-Address = 127.0.0.1
> NAS-Port = 0
>
> I would like to insert the value in the "Called-Station-Id" field in
some table in my Oracle DB.
>
> Is possible to do this using Radiator?. How ?
>
> Thanks in advance,
> Ricardo Martinez
>
> _______________________________________________
> radiator mailing list
> radiator at open.com.au
> http://www.open.com.au/mailman/listinfo/radiator
NB:
Have you read the reference manual ("doc/ref.html")?
Have you searched the mailing list archive
(www.open.com.au/archives/radiator)?
Have you had a quick look on Google (www.google.com)?
Have you included a copy of your configuration file (no secrets),
together with a trace 4 debug showing what is happening?
--
Radiator: the most portable, flexible and configurable RADIUS server
anywhere. Available on *NIX, *BSD, Windows, MacOS X.
Includes support for reliable RADIUS transport (RadSec),
and DIAMETER translation agent.
-
Nets: internetwork inventory and management - graphical, extensible,
flexible with hardware, software, platform and database independence.
-
CATool: Private Certificate Authority for Unix and Unix-like systems.
_______________________________________________
radiator mailing list
radiator at open.com.au
http://www.open.com.au/mailman/listinfo/radiator
More information about the radiator
mailing list