Re: GKAUTH SQLAuth RRQ Check failed

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

 



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/

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

  Powered by Linux