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
At 03:43 AM 27/07/2006, you wrote:
>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
>
>
>
>-------------------------------------------------------------------------
>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/
-------------------------------------------------------------------------
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/
