Jan and Group;
I've been playing heavily with the SQL routing policy pieces of recent
and stumbled upon an issue with a database structure that returns 2
columns, when the second one is NULL. If this case, the call fails.
If the query only returns one column, the function works properly, and
if you ensure that a gateway IP in a case where two columns are being
returned, those calls work (unless you try to use your own IP for the
gateway).
Anyway, looking at the code, I copied, and edited this patch, it works
in all cases (translate just alias, or add gateway IP, or lastly,
translate alias and add gateway IP). I'd like to submit this patch for
consideration to be included in the CVS code. Please excuse the
comments, they were put into the code so I could track my changes.
Thank you
Andrew
--- Routing.cxx 2010-08-27 08:24:08.000000000 -0400
+++ /root/openh323gk/Routing.cxx 2010-08-26 14:24:49.000000000 -0400
@@ -1794,7 +1794,21 @@ void SqlPolicy::DatabaseLookup(
H323SetAliasAddress(newDestination, newAliases[0]);
destination.SetNewAliases(newAliases);
}
- } else if (result->GetNumFields() == 2) {
+// Added by Andrew Herdman to get around the NULL 2nd column (2010-08-26)
+ } else if ((result->GetNumFields() == 2) && (resultRow[1].first
== NULL)) {
+ PString newDestinationAlias = resultRow[0].first;
+ PString newDestinationIP = resultRow[1].first;
+ PTRACE(5, m_name << "\tQuery result : " <<
newDestinationAlias << ", " << newDestinationIP);
+ if (newDestinationAlias.ToUpper() == "REJECT") {
+ destination.SetRejectCall(true);
+ } else {
+ H225_ArrayOf_AliasAddress newAliases;
+ newAliases.SetSize(1);
+ H323SetAliasAddress(newDestinationAlias,
newAliases[0]);
+ destination.SetNewAliases(newAliases);
+ }
+ } else if ((result->GetNumFields() == 2) && (resultRow[1].first
!= NULL)) {
+// End Code Added by Andrew Herdman (2010-08-26)
PString newDestinationAlias = resultRow[0].first;
PString newDestinationIP = resultRow[1].first;
PTRACE(5, m_name << "\tQuery result : " <<
newDestinationAlias << ", " << newDestinationIP);
------------------------------------------------------------------------------
Sell apps to millions through the Intel(R) Atom(Tm) Developer Program
Be part of this innovative community and reach millions of netbook users
worldwide. Take advantage of special opportunities to increase revenue and
speed time-to-market. Join now, and jumpstart your future.
http://p.sf.net/sfu/intel-atom-d2d
_______________________________________________________
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/
