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/
