Ethereal won't display connections on the localhost interface. Your query should work fine (you should return at least one row with 1 in the first column).
----- Original Message ----- From: "igor selivanov" <igorselivanov@xxxxxxxxx>
Sent: Friday, May 13, 2005 5:58 PM
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 *
------------------------------------------------------- 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/
