|
Hi Everyone,
Can you please help meI one more time.I want to add some checks before a user calls to any number.so that he/she does not call any ISD or STD number. So just to check I copy pasted the same registration query as you can seee below and after registration I delete the user.But my problem is even though user does not exist in the after registration he can Call??? So once after the registration RegQuery=SELECT 1 FROM authorisation where
H323ID like '%u'
I delete the user so that CallQuery(using the same query) doesn't get it. Regards, Santosh [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 1 FROM authorisation where H323ID like '%u' CallQuery=SELECT 1 FROM authorisation where H323ID like '%u' MinPoolSize=5 ----- Original Message ----- From: "Santosh" <santosh_tripathi@xxxxxxxxxxxxxx> To: "Zygmuntowicz Michal" <m.zygmuntowicz@xxxxxxx>; "GNU Gatekeeper Users" <openh323gk-users@xxxxxxxxxxxxxxxxxxxxx> Sent: Wednesday, May 06, 2009 6:19 PM Subject: Re: GKAUTH SQLAuth RRQ Check failed > 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/
