[RADIATOR] SQL Insert

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