Why MySQL failed ???

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

 



openh323gk-users   :
   
when I use MySQL as a backend database to authenticate the endpoints. ,  I  failed ,  why ?    help me!
The log as follows:
2004/10/22 09:58:16.260 5                job.cxx(360)   JOB     Worker threads: 6 total - 6 busy, 0 idle
2004/10/22 09:58:16.261 5                job.cxx(188)   JOB     Starting Job RRQ at Worker thread 7176
2004/10/22 09:58:16.261 1             RasSrv.cxx(312)   RAS     RRQ Received
2004/10/22 09:58:16.261 3             gkauth.cxx(1142)  GKAUTH  SQLPasswordAuth RRQ check failed
2004/10/22 09:58:16.262 2             RasSrv.cxx(357)   RRJ|192.168.0.28|11:dialedDigits|terminal|securityDenial;
2004/10/22 09:58:16.262 3             RasSrv.cxx(203)   RAS     Send to 192.168.0.28:1135
registrationReject {
    requestSeqNum = 12713
    protocolIdentifier = 0.0.8.2250.0.4
    rejectReason = securityDenial <<null>>
    gatekeeperIdentifier =  3 characters {
      0047 004b 0031                            GK1
    }
  }

                           
                                  And    my   ini    as  follow:
	
[Gatekeeper::Main]
Fourtytwo=42
Name=GK1
TimeToLive=300

[RoutedMode]
GKRouted=1
H245Routed=0

[Gatekeeper::Auth]
SQLPasswordAuth=required;RRQ
default=allow

[SQLPasswordAuth]
Driver=MySQL
Host=192.168.0.28
Database=test
Username=wubo
Password=195161
CacheTimeout=300
Query=SELECT h235password FROM billing WHERE users='%1' IS Active
MinPoolSize=5

[GkStatus::Auth]
rule=allow



And , MySQL have a database called "test",contained a table called "billing",
The "billing" have two field:  users , h235password ,

users   h235password
11         22

I use a ohphone ,  when I use : ohphone -a -l -u 11 -G GK1 ,  I failed .
why ???
		

        wubo
        wubo@xxxxxxxxxxx
          2004-09-21
???????????????????????甸?X?????!3搿????!3??h汗?K!:k≯?颧????,????r㈦a?(~??⒔氍b?:??禳g??N?g?h?'?'??仇??▲??????楫?r??????韬冠?(?.?┊????????????????????????+-?^?鲛	?谦躇b槽??q玷????b斤岫??(悍~?{?幅?V??麒??????z&z?{???0??O?

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

  Powered by Linux