Re: SQLAuth question

"Gentian Bajraktari" <g.bajraktari@xxxxxxxxxx> · Fri, 13 May 2005 21:33:18 +0100

The way I know is not use the SQLauth, but use an external script, that 
connects to status port and after getting the aliases variable splits it 
into e164 numbers and checks them from the database....

Genti

----- Original Message ----- 
From: "igor selivanov" <igorselivanov@xxxxxxxxx>

To: <openh323gk-users@xxxxxxxxxxxxxxxxxxxxx>

Sent: Friday, May 13, 2005 8:17 PM

Subject: Re:  SQLAuth question

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/

-------------------------------------------------------
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/