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'
