Michal,
Thank you! You are right, it does work, but now I
need to incorporate my logic, and have a little bit of
trouble. I want to check the e164 of the registering
unit for existence in the database, but there is not
much I can do with the %{aliases} variable, as it is a
comma-separated list. I would have to quote every
single entry in it to stick it in a query. And check
if any of the entries there exist in my database. As
it is, all I have is a string blob. How do I check
for the e164 (dialeddigits)?
--- Zygmuntowicz Michal <m.zygmuntowicz@xxxxxxx>
wrote:
> 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/
>
__________________________________
Yahoo! Mail Mobile
Take Yahoo! Mail with you! Check email on your mobile phone.
http://mobile.yahoo.com/learn/mail
-------------------------------------------------------
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/
