Thanks buddy.It worked for me and I guess I had not read the manual properly and was trying something different. ----- Original Message ----- From: "Zygmuntowicz Michal" <m.zygmuntowicz@xxxxxxx> To: "Santosh" <santosh_tripathi@xxxxxxxxxxxxxx>; "GNU Gatekeeper Users" <openh323gk-users@xxxxxxxxxxxxxxxxxxxxx> Sent: Wednesday, May 06, 2009 4:38 PM Subject: Re: GKAUTH SQLAuth RRQ Check failed > Have you read the manual section about ReqQuery and SQLAuth? > It's stated there that the first column of a result row is converted > to a boolean value determining authentication result. So in your case > it should be SELECT 1 FROM ..., I guess. > > ----- Original Message ----- > From: "Santosh" <santosh_tripathi@xxxxxxxxxxxxxx> > Sent: Wednesday, May 06, 2009 12:51 PM > > > Hi, > I have already checked it ,it is passing the correct value of '%u'.Infact > I can write the correct value into my table too.Its only when I try to > compare it with my table entries,its giving me problem.Please find my > content of gatekeeper.ini below: > > [Gatekeeper::Main] > Fourtytwo=42 > > [GkStatus::Auth] > rule=allow > > [RasSrv::GWPrefixes] > TESTSV=0 > > [Gatekeeper::Auth] > SQLAuth=sufficient,RRQ > > [SQLAuth] > Driver=MySQL > Host=localhost > Database=authorisation > Username=root > CacheTimeout=300 > RegQuery=SELECT * FROM authorisation where H323ID like '%u' > MinPoolSize=1 > > And please let me know if i need to make any changes. > > Best regards, > Santosh > > Disclaimer: The information contained in this e-mail and attachments if any are privileged and confidential and are intended for the individual(s) or entity(ies) named in this e-mail. If the reader or recipient is not the intended recipient, or employee or agent responsible for delivering to the intended recipient, you are hereby notified that dissemination, distribution or copying of this communication or attachments thereof is strictly prohibited. IF YOU RECEIVE this communication in error, please immediately notify the sender and return the original message. ------------------------------------------------------------------------------ The NEW KODAK i700 Series Scanners deliver under ANY circumstances! Your production scanning environment may not be a perfect world - but thanks to Kodak, there's a perfect scanner to get the job done! With the NEW KODAK i700 Series Scanner you'll get full speed at 300 dpi even with all image processing features enabled. http://p.sf.net/sfu/kodak-com _______________________________________________________ Posting: mailto:Openh323gk-users@xxxxxxxxxxxxxxxxxxxxx Archive: http://sourceforge.net/mailarchive/forum.php?forum_name=openh323gk-users Unsubscribe: http://lists.sourceforge.net/lists/listinfo/openh323gk-users Homepage: http://www.gnugk.org/
