we are currently trying to get the authentification mechanism between our Gatekeeper and various clients working with our mySQL database (installed on a different machine). Everything seems to work fine: We can see in the logfiles that the GK manages to access the database and seems to perform the query correctly. Although the clients are registered in the database with their IP number and ID the gatekeeper refuses to accept their authentification request.
The AuthSections in the gatekeeper.ini file look as follows and are taken from the gnugk website:
(IP numbers altered for security considerations)
... [Gatekeeper::Auth] MySQLPasswordAuth=optional;RRQ MySQLAliasAuth=required;RRQ default=allow
[MySQLAuth] Host=xxx.xxx.xxx.xxx Database=database User=User Password=Password Table=Table IDField=ID PasswordField=Password ExtraCriterion=Locked < 1
[MySQLAliasAuth] Host=xxx.xxx.xxx.xxx Database=database User=User Password=Password Table=Table IDField=ID IPField=IP ExtraCriterion=Locked < 1 CacheTimeout=300 ...
When we try to connect from a client we get the following log:
....
2004/02/27 15:27:10.563 1 RasSrv.cxx(947) GK RRQ Received
in mysql_query_define0 RETURN FUNC with one arg: 3284
2004/02/27 15:27:10.570 4 gkauth.cxx(1140) Unknown RRQAuth condition: xxx.xxx.xxx.xxx
2004/02/27 15:27:10.573 4 gkauth.cxx(1040) Gk RRQAuth condition 'xxx.xxx.xxx.xxx' rejected endpoint 3284
2004/02/27 15:27:10.573 2 gkauth.cxx(295) GkAuth MySQLAliasAuth check failed
2004/02/27 15:27:10.573 2 RasSrv.cxx(1202) RRJ|xxx.xxx.xxx.xxx9|3284:dialedDigits|terminal|securityDenial;
2004/02/27 15:27:10.573 3 RasSrv.cxx(2164) GK Send to xxx.xxx.xxx.xxx:32821
registrationReject {
....
When we perform a query by means of any SQL editor we can see that the correct IP number is returned as expected.
But we cannot see why the client cannot register.
We would appreciate any help on this topic.
Best wishes Michael
------------------------------------------------------- SF.Net is sponsored by: Speed Start Your Linux Apps Now. Build and deploy apps & Web services for Linux with a free DVD software kit from IBM. Click Now! http://ads.osdn.com/?ad_id=1356&alloc_id=3438&op=click _______________________________________________ List: Openh323gk-users@xxxxxxxxxxxxxxxxxxxxx Archive: http://sourceforge.net/mailarchive/forum.php?forum_id=8549 Homepage: http://www.gnugk.org/