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" <[email protected]>
To: "Zygmuntowicz Michal" <[email protected]>; "GNU Gatekeeper Users"
<[email protected]>
Sent: Wednesday, May 06, 2009 6:19 PM
Subject: Re: [Openh323gk-users] 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" <[email protected]>
> To: "Santosh" <[email protected]>; "GNU Gatekeeper Users"
> <[email protected]>
> Sent: Wednesday, May 06, 2009 4:38 PM
> Subject: Re: [Openh323gk-users] 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" <[email protected]>
>> 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:[email protected]
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/
