RE: SQLAuth question

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



test
-----Original Message-----
From: openh323gk-users-admin@xxxxxxxxxxxxxxxxxxxxx
[mailto:openh323gk-users-admin@xxxxxxxxxxxxxxxxxxxxx]On Behalf Of igor
selivanov
Sent: Monday, May 16, 2005 8:55 PM
To: openh323gk-users@xxxxxxxxxxxxxxxxxxxxx
Subject: Re:  SQLAuth question


Greetings,

   I've been trying to get something working to check
the e164# at startup, but can't find a way to access
it.  It seems e164 can only be accessed through the
%{aliases} blob, and MySQL string manipulation
necessary to do this is very ugly as it seems to me. 
There was a suggestion of using an external stript to
parse it - I can do that, but I cannot find a way to
integrate it into the gatekeeper.  I can connect to a
status port and parse, but I am not just trying to
keep a database updated somewhere, I am trying to have
the gatekeeper fail to register a rogue unit, so my
script has to interact with the gatekeeper process. 
It seems like this would be a very straightforward
thing to do, 
but as of right now it is a bitter stumbling block :(

   Igor

--- igor selivanov <igorselivanov@xxxxxxxxx> wrote:
> OK! That's a great idea, but how do I incorporate
> external scripts into the gnugk authentication
> scheme?
>  I don't remember anything in the manual referencing
> outsourcing to external scripts.
>  
> --- Gentian Bajraktari <g.bajraktari@xxxxxxxxxx>
> wrote:
> 
> > 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).
> > >>
> 
> 
> 
> 
> 
> 		
> Discover Yahoo! 
> Use Yahoo! to plan a weekend, have fun online and
> more. Check it out! 
> http://discover.yahoo.com/
> 
> 
>
-------------------------------------------------------
> 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=7412&alloc_id=16344&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=7412&alloc_id=16344&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/

[Index of Archives]     [SIP]     [Open H.323]     [Gnu Gatekeeper]     [Asterisk PBX]     [ISDN Cause Codes]     [Yosemite News]

  Powered by Linux