No, my endpoints don't support CAT, I need authentication only by IP, and have IP adress in database. Gnugk log: ---------------------------------- 2004/12/13 15:09:21.815 1 RasSrv.cxx(312) RAS RRQ Received 2004/12/13 15:09:21.815 3 radproto.cxx(2094) RADIUS Sending PDU to RADIUS server 1.2.3.4 (1.2.3.4:1812) 2004/12/13 15:09:21.819 3 radproto.cxx(2133) RADIUS Received PDU from RADIUS server 1.2.3.4 (1.2.3.4:181 2004/12/13 15:09:21.819 3 gkauth.cxx(1142) GKAUTH RadAliasAuth RRQ check failed 2004/12/13 15:09:21.820 2 RasSrv.cxx(357) RRJ|1.2.3.5|2011:dialedDigits=2011:h323_ID|terminal|securityDen 2004/12/13 15:09:21.820 3 RasSrv.cxx(203) RAS Send to 1.2.3.5:1025 registrationReject { requestSeqNum = 35407 protocolIdentifier = 0.0.8.2250.0.2 rejectReason = securityDenial <<null>> gatekeeperIdentifier = 5 characters { 0053 0061 003e 0064 0074 aaa ------------------------------------- Thanks, Regards, Serge. ----- Original Message ----- From: "Zygmuntowicz Michal" <m.zygmuntowicz@xxxxxxx> To: <openh323gk-users@xxxxxxxxxxxxxxxxxxxxx> Sent: Monday, December 13, 2004 12:25 PM Subject: Re: sql billing not work please help > You should probably take a look at the gatekeeper logs. > The RadAuth module requires that endpoints send their > username/password in a special way (CAT token). Make > sure all your endpoints support this. > > Besides, if you have checkh323id = FALSE and no framedip specified, > who is the billing supposed to authenticate your endpoint? If neither id > nor ip is to be checked. > > ----- Original Message ----- > From: "Serge" <520060793137-0001@xxxxxxxxxxx> > Sent: Monday, December 13, 2004 5:02 AM > > > Hello List, > Please Help, > I use: system rh9 ; gnugk 2.2.0 (Linux Executable ) ; freradius; postrgesql > 7.4 > I need: what registered and unregistered endpoints only by IP, may or may > not call and prepaid billing > > I have upgrade sql billing and now not work at all :(. Early I use sample > your sql billing and use only for billing ( not for Auth ), and sql count ok > user balance. > This new version for only accounting not working at all ( ? ) cdr ok, but > not user /destination select . I don't know why , but if I set in gnugk.ini > RadAuth=required - gnugk don't send request to radius at all. request go if > I use RadAliasAuth=required. But endpoints don't may registred - > 'securityDenial'. > > This some configuration and logs. And so, early I try set billing and see, > what RadAcct work only if I se Servers=ip , and not Servers=localhost > > > [RadAuth] > Servers=1.2.3.4 > SharedSecret=secret > RequestTimeout=2000 > IdCacheTimeout=9000 > SocketDeleteTimeout=60000 > RequestRetransmissions=2 > AppendCiscoAttributes=0 > IncludeTerminalAliases=0 > IncludeEndpointIP=1 > > [RadAliasAuth] > Servers=1.2.3.4 > SharedSecret=secret > RequestTimeout=2000 > IdCacheTimeout=9000 > SocketDeleteTimeout=60000 > RequestRetransmissions=2 > AppendCiscoAttributes=0 > IncludeTerminalAliases=0 > IncludeEndpointIP=1 > FixedPassword='123' > > -------------------voipuser--------------------- > 22476;"19";"2011";"1";"FALSE";"FALSE";"123";"''";"2011";"1.1.1.1";"bbbbb";"' '";"f" > 22477;"20";"2010";"1";"FALSE";"FALSE";"$^";"$^";"''";"";"aaa";"''";"f" > 22478;"21";"2012";"2";"FALSE";"FALSE";"$^";"$^";"''";"";"bbb";"Home";"f" > 30648;"22";"2025";"2";"FALSE";"FALSE";"123";"''";"2025";"2.2.2.2";"eeeeee";" ''";"f" > 30650;"23";"2026";"5";"FALSE";"FALSE";"123";"''";"''";"3.3.3.3";"ccccc";"''" ;"f" > ------------------------------------------------------ > > ---------radius log------------------------- > rad_recv: Access-Request packet from host 1.2.3.4:56619, id=213, length=75 > User-Name = "2011" > NAS-IP-Address = 1.2.3.4 > NAS-Identifier = "Sanet" > NAS-Port-Type = Virtual > Service-Type = Login-User > Framed-IP-Address = 1.2.3.4 > User-Password = "'123'" > Processing the authorize section of radiusd.conf > modcall: entering group authorize for request 100 > modcall[authorize]: module "preprocess" returns ok for request 100 > radius_xlat: > '/usr/local/var/log/radius/radacct/1.2.3.4/auth-detail-20041213' > rlm_detail: > /usr/local/var/log/radius/radacct/%{Client-IP-Address}/auth-detail-%Y%m%d > expands to /usr/local/var/log/radius/radacct/1.2.3.4/auth-detail-20041213 > modcall[authorize]: module "auth_log" returns ok for request 100 > modcall[authorize]: module "chap" returns noop for request 100 > rlm_realm: No '@' in User-Name = "2011", looking up realm NULL > rlm_realm: No such realm "NULL" > modcall[authorize]: module "suffix" returns noop for request 100 > radius_xlat: '2011' > rlm_sql (sql): sql_set_user escaped user --> '2011' > radius_xlat: 'SELECT id, '2011', attrname, attrvalue, attrop FROM > ??radius_get_check_attrs('2011', NULLIF(1.2.3.4, '')::INET, ???CASE ????WHEN > '' = '' THEN TRUE ????ELSE FALSE ???END, ???CASE WHEN 'Login-User' = > 'Call-Check' THEN TRUE ELSE FALSE END, ???NULLIF('',''), NULLIF('',''), > ???'' ???)' > rlm_sql (sql): Reserving sql socket id: 9 > rlm_sql_postgresql: query: SELECT id, '2011', attrname, attrvalue, attrop > FROM ??radius_get_check_attrs('2011', NULLIF(1.2.3.4, '')::INET, ???CASE > ????WHEN '' = '' THEN TRUE ????ELSE FALSE ???END, ???CASE WHEN 'Login-User' > = 'Call-Check' THEN TRUE ELSE FALSE END, ???NULLIF('',''), NULLIF('',''), > ???'' ???) > rlm_sql_postgresql: Status: PGRES_TUPLES_OK > rlm_sql_postgresql: affected rows = > radius_xlat: '' > radius_xlat: 'SELECT id, '2011', attrname, attrvalue, attrop FROM > ??radius_get_reply_attrs('2011', NULLIF(1.2.3.4, '')::INET, ???CASE ????WHEN > '' = '' THEN TRUE ????ELSE FALSE ???END, ???CASE WHEN 'Login-User' = > 'Call-Check' THEN TRUE ELSE FALSE END, ???NULLIF('',''), NULLIF('',''), > ???'' ???)' > rlm_sql_postgresql: query: SELECT id, '2011', attrname, attrvalue, attrop > FROM ??radius_get_reply_attrs('2011', NULLIF(1.2.3.4, '')::INET, ???CASE > ????WHEN '' = '' THEN TRUE ????ELSE FALSE ???END, ???CASE WHEN 'Login-User' > = 'Call-Check' THEN TRUE ELSE FALSE END, ???NULLIF('',''), NULLIF('',''), > ???'' ???) > rlm_sql_postgresql: Status: PGRES_TUPLES_OK > rlm_sql_postgresql: affected rows = > radius_xlat: '' > rlm_sql (sql): No matching entry in the database for request from user > [2011] > rlm_sql (sql): Released sql socket id: 9 > modcall[authorize]: module "sql" returns notfound for request 100 > modcall: group authorize returns ok for request 100 > auth: No authenticate method (Auth-Type) configuration found for the > request: Rejecting the user > auth: Failed to validate the user. > Login incorrect: [2011/'123'] (from client Sanet port 0) > Sending Access-Reject of id 213 to 1.2.3.4:56619 > > ---------------------Postgresql log:----------------------------------- > LOG: statement: SELECT id, '2011', attrname, attrvalue, attrop FROM > radius_get_check_attrs('2011', NULLIF(1.2.3.4, '')::INET, CASE > WHEN '' = '' THEN TRUE ELSE FALSE > END, CASE WHEN 'Login-User' = 'Call-Check' THEN TRUE ELSE > FALSE END, NULLIF('',''), NULLIF('',''), > '' ) > LOG: statement: SELECT id, '2011', attrname, attrvalue, attrop FROM > radius_get_reply_attrs('2011', NULLIF(1.2.3.4, '')::INET, CASE > WHEN '' = '' THEN TRUE ELSE FALSE > END, CASE WHEN 'Login-User' = 'Call-Check' THEN TRUE ELSE > FALSE END, NULLIF('',''), NULLIF('',''), > '' ) > ------------------------------------ > > Many Thanks, > Regards, > 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://productguide.itmanagersjournal.com/ > > _______________________________________________________ > > 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://productguide.itmanagersjournal.com/ _______________________________________________________ List: Openh323gk-users@xxxxxxxxxxxxxxxxxxxxx Archive: http://sourceforge.net/mailarchive/forum.php?forum_id=8549 Homepage: http://www.gnugk.org/