Freeradius - MySQL Update problem

[Claudiu Filip]

Hi musoket,
> rad_recv: Accounting-Request packet from host n.a.s.1:1646, id=239,
> length=531
>         Acct-Session-Id = "0024F8FF"
>         Calling-Station-Id = "442098765432"
>         Called-Station-Id = "0002561234567"
>         h323-setup-time = "h323-setup-time=16:53:14.471 GMT+3 Mon Aug 6 2007"
>         h323-gw-id = "h323-gw-id=Rotelkom_Gateway.www.nas.co.ug"
>         h323-conf-id = "h323-conf-id=B4550CDC FAA011D6 887DF94C E05F1EEE"
>         h323-call-origin = "h323-call-origin=answer"
>         h323-call-type = "h323-call-type=VoIP"
>         Cisco-AVPair = "h323-incoming-conf-id=B4550CDC FAA011D6 887DF94C
> E05F1EEE"
>         Cisco-AVPair = "subscriber=Unknown"
>         Cisco-AVPair = "session-protocol=cisco"
>         Cisco-AVPair = "gw-rxd-cdn=ton:0,npi:1,#:0002561234567"
>         User-Name = "rem.ote.add.ress"
>         Cisco-AVPair = "connect-progress=Call Up"
>         Acct-Authentic = 0
>         Acct-Status-Type = Start
>         Service-Type = Login-User
>         NAS-IP-Address = n.a.s.1
>         Acct-Delay-Time = 10


At the beginning of this thread you said that you saw in logs
h323-remote-address, but not in the sql database.
>From this snapshot, I dont see an entry with
     h323-remote-address = "h323-remote-address=x.y.z.t"

If you get the remote-address as User-Name, you can store that field
in db.


Regards,

Claudiu Filip
@: claudiu at globtel.ro
Http://www.globtel.ro
T:+40344880100
F:+40344880113