I am trying to set up a scheme to authenticate registering units. To do that I figured I need SQLAuth set up. I have a MYSQL database set up on the same server, and the iptables allow connections to port 3306 (default MySQL port). I am not clear, however, what the query needs to get from the database to be considered as successful. A row returned? a 1 returned? I made my RegQuery SELECT 1 FROM epauth (an existing table), so that it would always be true, however my units are failing to register, and the gatekeeper says SQL check failed: 2005/05/13 11:26:32.699 1 RasSrv.cxx(330) RAS RRQ Received 2005/05/13 11:26:32.703 3 gkauth.cxx(969) GKAUTH SQLAuth RRQ check failed Furthermore, according to ethereal, there is never any connection attempted or made to the MySQL server during the registration attempt. Please tell me what I am doing wrong here. Here is the relevant part of the config [Gatekeeper::Auth] SQLAuth=sufficient;RRQ [SQLAuth] ;Driver=PostgreSQL Driver=MySQL Host=localhost Database=billing Username=gnugk Password=mypass MinPoolSize=3 RegQuery=SELECT 1 FROM epauth and here, just in case, is the start-up data from the gatekeeper. 2005/05/13 11:23:42.998 2 singleton.cxx(32) Create instance: CallTable(2) 2005/05/13 11:23:43.000 2 gk.cxx(545) GK TimeToLive for Registrations: 300 2005/05/13 11:23:43.000 2 singleton.cxx(32) Create instance: RasServer(3) 2005/05/13 11:23:43.001 2 RasSrv.cxx(703) GK Using Direct Signalling 2005/05/13 11:23:43.001 2 RasSrv.cxx(704) GK H.245 Routed Disabled 2005/05/13 11:23:43.002 2 singleton.cxx(32) Create instance: GkStatus(4) 2005/05/13 11:23:43.002 2 singleton.cxx(32) Create instance: Agent(5) 2005/05/13 11:23:43.003 2 singleton.cxx(32) Create instance: RegistrationTable(6) 2005/05/13 11:23:43.006 2 RasSrv.cxx(740) GK Home = 192.168.0.190 2005/05/13 11:23:43.008 1 RasSrv.cxx(491) Listening to 192.168.0.190:1719(U) 2005/05/13 11:23:43.010 1 RasSrv.cxx(491) Listening to 192.168.0.190:1718(Mcast) 2005/05/13 11:23:43.011 1 RasSrv.cxx(491) Listening to 192.168.0.190:7000 2005/05/13 11:23:43.012 1 RasSrv.cxx(799) RAS Add broadcast listener 2005/05/13 11:23:43.017 3 yasocket.cxx(768) GkStatus waiting... 2005/05/13 11:23:43.058 1 gkauth.cxx(329) GKAUTH SQLAuth rule added to check RAS: RRQ, OTHER: NONE 2005/05/13 11:23:43.203 3 gksql.cxx(166) SQLAuth Database connection pool created: gnugk@localhost[billing] 2005/05/13 11:23:43.204 2 Routing.cxx(532) VQueue (CTI) Virtual queues enabled (aliases:CC), request timeout: 10 s 2005/05/13 11:23:43.205 2 singleton.cxx(32) Create instance: Routing::Analyzer(7) 2005/05/13 11:23:43.206 1 Routing.cxx(207) RoutingPolicy::OnARQ add policy internal,neighbor for prefix dialedDigits 2005/05/13 11:23:43.208 1 Routing.cxx(207) RoutingPolicy::OnLRQ add policy internal,parent,neighbor for prefix * 2005/05/13 11:23:43.209 1 Routing.cxx(207) RoutingPolicy::OnSetup add policy internal,parent,neighbor for prefix * 2005/05/13 11:23:43.210 1 Routing.cxx(207) RoutingPolicy::OnFacility add policy internal,parent,neighbor for prefix * Yahoo! Mail Stay connected, organized, and protected. Take the tour: http://tour.mail.yahoo.com/mailtour.html ------------------------------------------------------- This SF.Net email is sponsored by Oracle Space Sweepstakes Want to be the first software developer in space? Enter now for the Oracle Space Sweepstakes! http://ads.osdn.com/?ad_id=7393&alloc_id=16281&op=click _______________________________________________________ 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/
