Re: GKAUTH SQLAuth RRQ Check failed

"Santosh" <santosh_tripathi@xxxxxxxxxxxxxx> · Wed, 6 May 2009 16:21:45 +0530

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:  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@xxxxxxxxxxxxxxxxxxxxx 

    Sent: Wednesday, May 06, 2009 11:47 
    AM
    Subject:  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@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/