Unfortunatelly, this is a limitation of terminating tariffs. They can be matched only by a terminator's IP or by dialed number (exact number, no prefix match). The limitation was due to slow tariff prefix-based matching, so I didn't want to make everything even slower. Of course, it would be possible to match by a prefix - you would just have to modify a bit match_terminating_user to perform a prefix based match too. ----- Original Message ----- From: "manjula hettiarachchi" <manjula_55@xxxxxxxxx> Sent: Thursday, November 02, 2006 9:51 AM > I have been using SQLbill(gnugk2.2.3-2) for over 1 > year. Its working fine. Recently I came across a > situation where I terminated to TWO carriers who share > the same IP. (hosted softswitch). > > I have created seperate voipaccount records, seperate > terminating tariffs, seperate prefixes (in > PermanentEP) for the 2 terminating accounts and > seperate voipuser records and left the framed IP field > BLANK. > > My aim was to make gnugk identify the corresponding > TERMINATING account using the different prefixes used > in PermanentEP. However sqlbill does not write records > to the voipcalltermtariff. > > If I insert the IP to one of the voipuser accounts it > will write records in the voipcalltermtariff table > for that particular account only. > > I can see in function:match_terminating_user, that > terminating account is selected based on h323id WHEN > FramedIP is not present. > > +++++ > BEGIN > user.id := NULL; > IF h323idmatch THEN > SELECT INTO user * FROM voipuser > WHERE terminating AND h323id = userh323id AND NOT > disabled; > END IF; > IF NOT FOUND OR user.id IS NULL THEN > SELECT INTO user * FROM voipuser > WHERE terminating AND framedip >>= userip AND NOT > disabled; > END IF; > RETURN user; > END; > =========== > > However it does not seem to work. Is there any other > way to achieve what I am trying to do? > > please let me know if anyone has faced this situation. > Your advise is very much appreciated > > Thanks > > Manjula ------------------------------------------------------------------------- Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642 _______________________________________________________ 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/
