Re: GKAUTH SQLAuth RRQ Check failed

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

 



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


------------------------------------------------------------------------------
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