user "Sanet" - caller , in this moment all right, but service type different
from Gnugk side. I see in postgresql.conf have another request for service
type Call-Check. I have try change request as service type, but this too not
work. And too interesting, if call failed I see i DB not normal IP address
127.0.0.1 , If call have some duration - IP address right.
Why DB answer request ok, if she don't have requested destination prefix, or
destination not activ?, As I have write, check by IP address work ok, and
DB rejected authorization if don't find IP in voipuser table.
Serge.
----- Original Message -----
From: "Zygmuntowicz Michal" <m.zygmuntowicz@xxxxxxx>
To: <openh323gk-users@xxxxxxxxxxxxxxxxxxxxx>
Sent: Sunday, February 13, 2005 3:58 PM
Subject: Re: Gbugk Radius billing + other clients
> This is because the billing does not perform any tariff matching/credit
time
> calculation
> for the call terminating side (the answering endpoint). This is because
> credit time is related
> to the call originator, not the called party.
>
> The interesting part is why AquaGK is sending Access-Request with
> Service-Type = Call-Check
> and h323-call-origin=answer and not originate. Is the user 'Sanet' a
calling
> or called party?
>
> PS: What did not work in postgresql.conf, so you had to make changes?
>
> ----- Original Message -----
> From: "Serge" <520060793137-0001@xxxxxxxxxxx>
> Sent: Sunday, February 13, 2005 2:34 PM
>
>
> > Oh, I have forget , I have change postgresql.conf file, mit original (
> > gnugk
> > billing ) all calls rejected .
> > I have change all "Framed-Ip-Address" to "h323-remoute-address"
> > I need authorization only by IP.
> >
> > Please see Radius log:
> > This is for Gnugk - working Ok
> > =============================================================
> > rad_recv: Access-Request packet from host 127.0.0.1:65526, id=82,
> > length=89
> > User-Name = "*"
> > NAS-IP-Address = 1.2.3.4
> > NAS-Identifier = "Sanet4"
> > NAS-Port-Type = Virtual
> > Service-Type = Login-User
> > Framed-IP-Address = 2.3.4.5
> > Calling-Station-Id = "*"
> > Called-Station-Id = "709111111"
> > User-Password = "123"
> > Processing the authorize section of radiusd.conf
> > modcall: entering group authorize for request 12
> > modcall[authorize]: module "preprocess" returns ok for request 12
> > modcall[authorize]: module "chap" returns noop for request 12
> > rlm_realm: No '@' in User-Name = "*", looking up realm NULL
> > rlm_realm: No such realm "NULL"
> > modcall[authorize]: module "suffix" returns noop for request 12
> > radius_xlat: '*'
> > rlm_sql (sql): sql_set_user escaped user --> '*'
> > radius_xlat: 'SELECT id, '=2A', attrname, attrvalue, attrop FROM
> > ??radius_get_check_attrs('=2A', NULLIF('2.3.4.5', '')::INET, ???CASE
> > ????WHEN '709111111' = '' THEN TRUE ????ELSE FALSE ???END, ???CASE WHEN
> > 'Login-User' = 'Call-Check' THEN TRUE ELSE FALSE END, ???'=2A',
> > NULLIF('70911111',''), ???parse_avpair('', 'h323-ivr-out',
> > 'terminal-alias') ???)'
> > rlm_sql (sql): Reserving sql socket id: 7
> > rlm_sql_postgresql: query: SELECT id, '=2A', attrname, attrvalue, attrop
> > FROM ??radius_get_check_attrs('=2A', NULLIF('2.3.4.5', '')::INET,
> > ???CASE ????WHEN '709111111' = '' THEN TRUE ????ELSE FALSE ???END,
???CASE
> > WHEN 'Login-User' = 'Call-Check' THEN TRUE ELSE FALSE END, ???'=2A',
> > NULLIF('709111111',''), ???parse_avpair('', 'h323-ivr-out',
> > 'terminal-alias') ???)
> > rlm_sql_postgresql: Status: PGRES_TUPLES_OK
> > rlm_sql_postgresql: affected rows =
> > radius_xlat: ''
> > radius_xlat: 'SELECT id, '=2A', attrname, attrvalue, attrop FROM
> > ??radius_get_reply_attrs('=2A', NULLIF('2.3.4.5', '')::INET, ???CASE
> > ????WHEN '70957555988' = '' THEN TRUE ????ELSE FALSE ???END, ???CASE
WHEN
> > 'Login-User' = 'Call-Check' THEN TRUE ELSE FALSE END, ???'=2A',
> > NULLIF('7091111111',''), ???parse_avpair('', 'h323-ivr-out',
> > 'terminal-alias') ???)'
> > rlm_sql_postgresql: query: SELECT id, '=2A', attrname, attrvalue, attrop
> > FROM ??radius_get_reply_attrs('=2A', NULLIF('2.3.4.5', '')::INET,
> > ???CASE ????WHEN '709111111' = '' THEN TRUE ????ELSE FALSE ???END,
???CASE
> > WHEN 'Login-User' = 'Call-Check' THEN TRUE ELSE FALSE END, ???'=2A',
> > NULLIF('709111111',''), ???parse_avpair('', 'h323-ivr-out',
> > 'terminal-alias') ???)
> > rlm_sql_postgresql: Status: PGRES_TUPLES_OK
> > rlm_sql_postgresql: affected rows =
> > radius_xlat: ''
> > rlm_sql (sql): Released sql socket id: 7
> > modcall[authorize]: module "sql" returns ok for request 12
> > modcall: group authorize returns ok for request 12
> > auth: type Local
> > auth: user supplied User-Password matches local User-Password
> > Sending Access-Accept of id 82 to 127.0.0.1:65526
> > h323-credit-time = "h323-credit-time=895507"
> > h323-credit-amount = "h323-credit-amount=149.25"
> > h323-currency = "h323-currency=USD"
> > h323-billing-model = "h323-billing-model=2"
> > h323-return-code = "h323-return-code=0"
> > Finished request 12
> > ===============================================
> > This it other client Aqua GK - not normal working , not reseive from DB
> > h323-credit-....
> > ===============================================
> >
> > rad_recv: Access-Request packet from host 2.2.2.2:32948, id=245,
> > length=289
> > NAS-IP-Address = 2.2.2.2
> > NAS-Identifier = "Sanet4"
> > User-Name = "Sanet"
> > User-Password = "123"
> > Service-Type = Call-Check
> > Called-Station-Id = "12345678"
> > h323-call-origin = "h323-call-origin=answer"
> > h323-call-type = "h323-call-type=VoIP"
> > h323-conf-id = "h323-conf-id=022036C2 7130BDF3 3C2D5634 343434EF"
> > h323-remote-address = "h323-remote-address=3.3.3.3"
> > h323-setup-time = "h323-setup-time=13:09:58.287 UTC Sun Feb 13
> > 2005"
> > Processing the authorize section of radiusd.conf
> > modcall: entering group authorize for request 7
> > modcall[authorize]: module "preprocess" returns ok for request 7
> > modcall[authorize]: module "chap" returns noop for request 7
> > rlm_realm: No '@' in User-Name = "Sanet", looking up realm NULL
> > rlm_realm: No such realm "NULL"
> > modcall[authorize]: module "suffix" returns noop for request 7
> > radius_xlat: 'Sanet'
> > rlm_sql (sql): sql_set_user escaped user --> 'Sanet'
> > radius_xlat: 'SELECT id, 'Sanet', attrname, attrvalue, attrop FROM
> > ??radius_get_check_attrs('Sanet', NULLIF('3.3.3.3', '')::INET, ???CASE
> > ????WHEN '12345678' = '' THEN TRUE ????ELSE FALSE ???END, ???CASE WHEN
> > 'Call-Check' = 'Call-Check' THEN TRUE ELSE FALSE END, ???'',
> > NULLIF('12345678',''), ???parse_avpair('', 'h323-ivr-out',
> > 'terminal-alias')
> > ???)'
> > rlm_sql (sql): Reserving sql socket id: 2
> > rlm_sql_postgresql: query: SELECT id, 'Sanet', attrname, attrvalue,
attrop
> > FROM ??radius_get_check_attrs('Sanet', NULLIF('3.3.3.3', '')::INET,
> > ???CASE
> > ????WHEN '12345678' = '' THEN TRUE ????ELSE FALSE ???END, ???CASE WHEN
> > 'Call-Check' = 'Call-Check' THEN TRUE ELSE FALSE END, ???'',
> > NULLIF('12345678',''), ???parse_avpair('', 'h323-ivr-out',
> > 'terminal-alias')
> > ???)
> > rlm_sql_postgresql: Status: PGRES_TUPLES_OK
> > rlm_sql_postgresql: affected rows =
> > radius_xlat: ''
> > radius_xlat: 'SELECT id, 'Sanet', attrname, attrvalue, attrop FROM
> > ??radius_get_reply_attrs('Sanet', NULLIF('3.3.3.3', '')::INET, ???CASE
> > ????WHEN '12345678' = '' THEN TRUE ????ELSE FALSE ???END, ???CASE WHEN
> > 'Call-Check' = 'Call-Check' THEN TRUE ELSE FALSE END, ???'',
> > NULLIF('12345678',''), ???parse_avpair('', 'h323-ivr-out',
> > 'terminal-alias')
> > ???)'
> > rlm_sql_postgresql: query: SELECT id, 'Sanet', attrname, attrvalue,
attrop
> > FROM ??radius_get_reply_attrs('Sanet', NULLIF('3.3.3.3', '')::INET,
> > ???CASE
> > ????WHEN '12345678' = '' THEN TRUE ????ELSE FALSE ???END, ???CASE WHEN
> > 'Call-Check' = 'Call-Check' THEN TRUE ELSE FALSE END, ???'',
> > NULLIF('12345678',''), ???parse_avpair('', 'h323-ivr-out',
> > 'terminal-alias')
> > ???)
> > rlm_sql_postgresql: Status: PGRES_TUPLES_OK
> > rlm_sql_postgresql: affected rows =
> > radius_xlat: ''
> > rlm_sql (sql): Released sql socket id: 2
> > modcall[authorize]: module "sql" returns ok for request 7
> > modcall: group authorize returns ok for request 7
> > auth: type Local
> > auth: user supplied User-Password matches local User-Password
> > Sending Access-Accept of id 245 to 2.2.2.2:32948
> > h323-return-code = "h323-return-code=0"
> > Finished request 7
> >
> > ----- Original Message -----
> > From: "Zygmuntowicz Michal" <m.zygmuntowicz@xxxxxxx>
> > To: <openh323gk-users@xxxxxxxxxxxxxxxxxxxxx>
> > Sent: Sunday, February 13, 2005 1:02 PM
> > Subject: Re: Gbugk Radius billing + other clients
> >
> >
> >> You did not provide enough details. Some log fragments,
> >> system specifications, database entries would be helpful.
> >>
> >> ----- Original Message -----
> >> From: "Serge" <520060793137-0001@xxxxxxxxxxx>
> >> Sent: Saturday, February 12, 2005 1:17 PM
> >>
> >> Hello List,
> >> Gnugk + radius billing really cool.
> >> I have 2 GK GnuGK, 1 Aqua, and some gateway.
> >> I try use Gnugk radius billing for other gw and gk and have some
problem:
> >>
> >> Other client send to radius request and authorized from GnuGk billing
ok
> > by
> >> IP address, but allow / disallow prefix don't work and GnuGk Postgres
> >> database don't send to radius maximum connect time.
> >> Clients may work with any balance + or - , but money calculation work
Ok.
> >>
> >> All radius clients gw and gk have standard Radius interface.
> >>
> >> Can any help me?
> >> Many Thanks,
> >> Serge.
>
>
>
> -------------------------------------------------------
> SF email is sponsored by - The IT Product Guide
> Read honest & candid reviews on hundreds of IT Products from real users.
> Discover which products truly live up to the hype. Start reading now.
> http://ads.osdn.com/?ad_id=6595&alloc_id=14396&op=click
>
> _______________________________________________________
>
> List: Openh323gk-users@xxxxxxxxxxxxxxxxxxxxx
> Archive: http://sourceforge.net/mailarchive/forum.php?forum_id=8549
> Homepage: http://www.gnugk.org/
-------------------------------------------------------
SF email is sponsored by - The IT Product Guide
Read honest & candid reviews on hundreds of IT Products from real users.
Discover which products truly live up to the hype. Start reading now.
http://ads.osdn.com/?ad_id=6595&alloc_id=14396&op=click
_______________________________________________________
List: Openh323gk-users@xxxxxxxxxxxxxxxxxxxxx
Archive: http://sourceforge.net/mailarchive/forum.php?forum_id=8549
Homepage: http://www.gnugk.org/
