Re: Gbugk Radius billing + other clients

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 

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/
[Index of Archives]     [SIP]     [Open H.323]     [Gnu Gatekeeper]     [Asterisk PBX]     [ISDN Cause Codes]     [Yosemite News]

  Powered by Linux