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
----- Original Message -----
From: Zygmuntowicz Michal
To: Santosh ; GNU Gatekeeper Users
Sent: Wednesday, May 06, 2009 3:35 PM
Subject: Re: [Openh323gk-users] GKAUTH SQLAuth RRQ Check failed
You need to check a trace level 5 log to see what is actually substituted
for %u when the query is being sent to the server. Maybe the problem
is a value substituted for %u.
----- Original Message -----
From: Santosh
To: openh323gk-users@lists.sourceforge.net
Sent: Wednesday, May 06, 2009 11:47 AM
Subject: [Openh323gk-users] GKAUTH SQLAuth RRQ Check failed
Hi,
I am using GNUGK Version 2.2.3 and for granting the access to a user I am
using SQLAUTH.
I have a RegQuery(SELECT * FROM authorisation where H323ID like '%u') where
authorisation is my Mysql table name and I have all the entries properly
inserted into the table for each user.But this fails everytime.
Am I doing something wrong? Because if I just write in RegQuery SELECT *
FROM authorisation, it works.
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@lists.sourceforge.net
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/
