You should use:
RegQuery=SELECT 1 from table1 where username = '%u'
instead of CallQuery if you want to achieve endpoint registration.
Read the manual carefully.
All the best,
Gabriel
At 04:53 AM 1/21/2006, you wrote:
Hi, All,
I'm trying to do some simple experiments with sqlauth module. When
a h323 call comes in,
I'll check database to see if this caller has a record in the database we
have. if yes, then let it go
through, if no then reject it. however, I got stuck here. I got no rows
returned from query. :-(
I'm not sure what I should put after SQLAuth. I put ARQ first, then
always 'no rows are returned
from column', then I changed to RRQ, it admits every call! Now, I put all
these things on and 'no rows
returned' again. :-((( Could anyone please give me some advice on how
these parameters should be
set up and what they mean?
running topology is like
machine A is running gk, machine B is running database, machine C
is running openmcu, machine
D is running h323 client.
A: gnugk -r -c config
B: mysqld --user=mysql
C: openmcu -u mcu1 -g A
D: ohphone -u jim -g A mcu1
jim is in database already, but query always returns with no rows.
is there any 'step by step' instructions
on how to get this working?
thanks,
-Jim
my configuration file is like:
[Gatekeeper::Main]
Fourtytwo=42
Name=Covet
StatusPort=7000
[GkStatus::Auth]
rule=explicit
127.0.0.1=allow
default = forbid
[Gatekeeper::Auth]
SQLAuth=required;RRQ,ARQ,SetupUnreg
default=allow
[SQLAuth]
Driver=MySQL
Host= a.b.c.d
Database= usrdb
Username=usr1
Password=usr1
CallQuery=SELECT 1 from table1 where username = '%u'
-------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc. Do you grep through log files
for problems? Stop! Download the new AJAX search engine that makes
searching your log files as easy as surfing the web. DOWNLOAD SPLUNK!
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=103432&bid=230486&dat=121642
_______________________________________________________
Posting: mailto:Openh323gk-users@xxxxxxxxxxxxxxxxxxxxx
Archive: http://sourceforge.net/mailarchive/forum.php?forum_id=8549
Unsubscribe: http://lists.sourceforge.net/lists/listinfo/openh323gk-users
Homepage: http://www.gnugk.org/
