Hello everybody.
I am trying to configure RAS so to register only specific endpoints
which are already present in a Mysql Database. So i inserted the
following lines in the GnuGK configuration file:
;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
[Gatekeeper::Auth]
SQLAuth=sufficient;RRQ
[SQLAuth]
Driver=MySQL
Host=xx.xxx.xxx.xx:3306
Database=test
Username=user
Password=password
RegQuery=SELECT accept, aliases from sqlauth WHERE orig_aliases='%{aliases}';
;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
But not all of the endpoints in the zone behave in the same way, so
that the queries which are sent to the Mysql database are different
from each other when the %{aliases} is expanded. I.e.
SELECT accept, aliases from sqlauth WHERE orig_aliases='DAgustin,4011'
SELECT accept, aliases from sqlauth WHERE orig_aliases='4006'
SELECT accept, aliases from sqlauth WHERE orig_aliases='2220,TorinoPMN'
The preceding queries refers to registration attempts by Mirial
Softphone, PacPhone and an Aethra Codec respectively.
I would like to avoid inserting different informations in the database
for each different endpoint and i would also like to avoid the use of
LIKE in SQL statements.
I thoughts that the AliasFilterType directive would have helped in
this case so i added to the configuration file the following lines,
just before the [Gatekeeper::Auth] lines
;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
[RasSrv::RRQFeatures]
AliasTypeFilter=terminal;dialeddigits
;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
I hoped that by using the preceding line, the %aliases would be
expanded to dialeddigits only, but it's not so.
Do you have any suggestions to try to even out this situation? I tried
also using SQLAuth on GRQ, but it seems it's of no use.
Thanks for any help. Pierlu
p.s. GnuGk is version 2.3.0
------------------------------------------------------------------------------
Come build with us! The BlackBerry® Developer Conference in SF, CA
is the only developer event you need to attend this year. Jumpstart your
developing skills, take BlackBerry mobile applications to market and stay
ahead of the curve. Join us from November 9-12, 2009. Register now!
http://p.sf.net/sfu/devconf
_______________________________________________________
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/
