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/
