Set gnugk log level to 7 and you will get more debug messages.It is useful.And the sql query is strange.You can trySELECT h235password FROM billing WHERE users='%1' What do you mean "IS Active"? I think it is wrong. regards,Daniel
wubo write:
openh323gk-users :> > > [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 ?> > 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> }> }> > > > > wubo> wubo@xxxxxxxxxxx> 2004-09-21> N琀Y薜闅奨?矈辵紙Lv?铦z壢L僻j?畍菆N氳v??颌贳喝?#19;zYn?#8;Z?.?#24;図呴唺鳟眾.b?'癵?#22;窞Ng瀽h煷''鈗玘?brKh~)茛雈⒎《?鑦?傝漽+fjv z?㈥鏹W(涾.壸┊墾秊e.+-:棫噠穫K瑉?娝l矉玵玷?#7;?r痾m?膦贶y?侀薹鶜奦玶瘂麒﹩楄?9阊铏闦佽m稛?#12; 炶$⒏???????????????????????甸殜X?矈辵?!3搿蹨磌?!3潹 h汗跁K !:k≯湺颧蕥玭?濍,??叓r㈦a妝(~豝涶⒔氍b嫬:槯妷禳g?窞Ng瀽h煷''鈗玘仇?▲嫮殜迒踚?楫噉r?壸?贇潹 韬冠楓(涾.壸┊墾?????????????????????+-^?鲛 ?谦躇b槽?嫬q玷??隌b斤岫??(悍 ~娻{幅殜V玶瘂麒??婎涾濘z&z枲{鴐稛? 0?顐O?
