Thats pretty much what I roughly had in mind.
But now for extra credit: ;-)
Right now you only return the preferred gateway IP. You should modify
your SQL to return the other gateway IPs in the next rows so the call
will failover to those when the preferred gateway isn't available.
Regards,
Jan
Robert Kulagowski wrote:
> > So would the following work as the SQL SELECT statement?
> >
> > SELECT gatewayip from routes where calling=left('%r',2)
> >
> > Also, it seems like I can add a priority field to the table so that the
> > gatewayip can vary as well?
> >
> > If the e.164 of the unit is 212345 and the h.323 name is
> > "chicago-polycom@xxxxxxxxxxx", what's going to be in the %r field and
> > what's going to be in the %{Calling-Station-Id} ?
>
> I ended up doing this:
> QUERY=SELECT gatewayip from routes where
> calling=left(substring_index('%r','=',-1),2)
>
> because the %r being passed from the Polycom endpoint comes through as
> "chicago-polycom@xxxxxxxxxxx=213538" to the SQL query, I ended up using the
> above query. The substring_index gives me everything to the right of the
> first = sign, and then I'm taking the left two characters (site code) as
> the lookup.
>
> But then I tried
> QUERY=SELECT gatewayip from routes where
> calling=left('%{Calling-Station-Id}',2)
>
> and that's working even better, because I'm just getting the 6-digit e.164
> number and don't need as much fancy parsing.
>
> So, yay!
--
Jan Willamowius, jan@xxxxxxxxxxxxxx, http://www.gnugk.org/
------------------------------------------------------------------------------
Come build with us! The BlackBerry(R) Developer Conference in SF, CA
is the only developer event you need to attend this year. Jumpstart your
developing skills, take BlackBerry mobile applications to market and stay
ahead of the curve. Join us from November 9 - 12, 2009. Register now!
http://p.sf.net/sfu/devconference
_______________________________________________________
Posting: mailto:Openh323gk-users@xxxxxxxxxxxxxxxxxxxxx
Archive: http://sourceforge.net/mailarchive/forum.php?forum_name=openh323gk-users
Unsubscribe: http://lists.sourceforge.net/lists/listinfo/openh323gk-users
Homepage: http://www.gnugk.org/
