If you have clients that needs to register with user/pass use RegQuery. If you have clients gw to gw (like wholesales) use CallQuery. Of course you can have both types in same time and in this case of course you will use both queryes.
If you will have both register and unregistered calls you can use something like:
SQLAuth=required;RRQ,ARQ,SetupUnreg
Regards,
Gabriel
At 07:52 PM 1/22/2006, you wrote:
Hi, Gabriel,
thanks for the info. this is very helpful. my question is that,
how may we know in advance whether a user is sending a call in registration mode or direct mode? or we should put both ARQ and RRQ and define query like this:
SQLAuth=required;ARQ,RRQ
...
RegQuery=select....
CallQuery=select...
in this way, SQLAuth will process both ARQ and RRQ message, right? and the corresponding query will be used respectively depending on what mode user is calling
in, right? if we want to process more message, we just put their names into list and define
the right query for it, right?
thanks,
-Rui
On 1/22/06, Gabriel Georgescu <gabigeo@xxxxxxxxxxx> wrote:
- It all comes from the form of authentication. If the call comes with an RRQ then the RegQuery is used. If it comes with an ARQ the CallQuery is used.
- In other words if the user is sending the call in registration mode then the RegQuery will be used.
- If the call is sent directly (gateway to gateway) then the CallQuery will be used.
- Only one query is used when the call comes as I described above.
- And please ask the questions on list so others can benefit from the answers.
- All the best,
- Gabriel
- At 10:32 AM 1/22/2006, you wrote:
- Hi, Gabriel,
- here is what I am confused: why do you use regquery not callquery?
- you see, whenever a call comes in, gnugk needs to find out if the caller
- is in database and accept/reject the call based on result. so i think probably
- i should use callquery. what you are saying...can I understand in this way:
- whenever a call comes in with -g gnugk specified, it means registration to
- gnugk first...but after registration, what does it do?
- sorry to bother you, thanks a lot!
- -Jim
- On 1/20/06, Gabriel Georgescu <gabigeo@xxxxxxxxxxx> wrote:
- 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/
