Re: sql billing not work please help

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

 



Thanks one more time, Sorry, may I ask you too..
----------------------
I use RadAliasAuth, but endpoints don't may registred , I set FixedPassword
and set this in DB, one more time logs for this setting:
----gnugk.ini------------
[RadAliasAuth]
Servers=1.2.3.4
SharedSecret=secret
RequestTimeout=2000
IdCacheTimeout=9000
SocketDeleteTimeout=60000
RequestRetransmissions=2
AppendCiscoAttributes=0
IncludeTerminalAliases=0
IncludeEndpointIP=1
FixedPassword='123'
-------------------DB>voipuser---------------------
22476;"19";"2011";"1";"FALSE";"FALSE";"123";"''";"2011";"1.1.1.1";"bbbbb";"'
'";"f"

----------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
 -------------------------------------

---------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/

[Index of Archives]     [SIP]     [Open H.323]     [Gnu Gatekeeper]     [Asterisk PBX]     [ISDN Cause Codes]     [Yosemite News]

  Powered by Linux