Hi,
thank you for the help , just i would like u to give me one more hint.
u mentioned : -
3. Modify the SQL query in GnuGK
Replace 'u' with seth323id('%u','%{caller-ip}')
where exactly the SQL query , in which file?
Regards
> ----- Original Message -----
> From: "Rushan Sobar" <Rushan@xxxxxxxxxx>
> To: <openh323gk-users@xxxxxxxxxxxxxxxxxxxxx>
> Sent: Wednesday, July 26, 2006 9:43 PM
> Subject: avaya / voice master
>
>
>> Hi,
>>
>> I'm trying to setup avaya exchange to my GNU , also im trying to connect
>> voice master gatekeeper to my gnu , my gnu work with radius and sqlbill ,
>> the problem that avaya and voice master don't send H323ID to register
>> into my gatekeeper , is there any way in sqlbill to add account based on
>> ip address not H323ID?
>>
>> Regards
>> Rushan
>>
>> Message: 2
>> Date: Thu, 27 Jul 2006 04:31:34 +0800
>> From: Simon Horne <s.horne@xxxxxxxxxxxxxx>
>> Subject: Re: avaya / voice master
>> To: GNU Gatekeeper Users <openh323gk-users@xxxxxxxxxxxxxxxxxxxxx>
>> Message-ID: <6.0.0.22.2.20060727042034.0436d128@xxxxxxxxxxxxx>
>> Content-Type: text/plain; charset="us-ascii"; format=flowed
>>
>>
>> The solution is to
>>
>> 1. create a H323ID entry in sqlbill of the IP address you wish to allow
>> 2. Create a sql function like this
>>
>> CREATE OR REPLACE FUNCTION seth323id(text, text) RETURNS text AS
>> $body$
>> DECLARE
>> userh323id ALIAS FOR $1;
>> userip ALIAS FOR $2;
>> userid INT := NULL;
>> BEGIN
>> SELECT INTO userid u.id FROM voipuser u WHERE u.h323id =
>> userh323id;
>>
>> IF NOT FOUND THEN
>> RETURN userip;
>> ELSE
>> RETURN userh323id;
>> END IF;
>> END;
>> $body$
>> LANGUAGE 'plpgsql' STABLE;
>>
>> This will check if the H323ID is missing and if so then it returns the
>> callers IP.
>>
>> 3. Modify the SQL query in GnuGK
>> Replace 'u' with seth323id('%u','%{caller-ip}')
>>
>> This should work
>>
>> Simon
>
-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys-and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________________
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/
