Re[4]: [Openh323gk-users] voipcall_match_tariff
H.323 Gatekeeper for VoIP and videconferencing
Brought to you by:
willamowius
From: Roman V. L. <ro...@du...> - 2004-12-29 13:18:25
|
Hello Zygmuntowicz, Wednesday, December 29, 2004, 3:50:32 PM, you wrote: ZM> And what would you like to have in voipcalltermtariff? ZM> Did you setup termination tariffs/accounts too? Yes,i have account 23874;"2";"2004-12-24 16:23:02+03";"";"FALSE";"-0.0257";"0.0000";"USD" and user associated whith this account 23875;"8";"70951111111";"2";"FALSE";"TRUE";"1";"^$";"''";"";"qqq";"qqq";"TRUE" in voiptariffdst i have following 23400;"332";"TRUE";"7812";"test";"FALSE" and associated termination tariff in voiptariff table 29326;"569";"332";"";"0.0180";"USD";"1";"1";"0";"''";"TRUE";"TRUE" And also originating tariff associated whith this destination 23401;"332";"332";"";"0.0700";"USD";"1";"1";"0";"''";"TRUE";"FALSE" Can i have the following in voipcalltermtariff? 29355;"6";"376";"2";"70951111111";"127.0.0.1";"0.0036";"0.0180";"USD";"1";"1";"0";"''" and another thing, with this record in voipcalltermtariff i also have record in voipcall table with originating tariff "376";"2";"70951111111";"0000018B";"32D7D241 DB6D58A3 9BBA0002 A400D6B3";"10.10.10.10";"''";"127.0.0.1";"140476109";"127.0.0.1";"78125555555";"2004-12-29 19:11:34+03";"2004-12-29 19:11:37+03";"2004-12-29 19:11:49+03";"10";"12";"0.0140";"0.0700";"USD";"test";"1";"1";"0";"2004-12-29 16:13:18+03";"0";"2004-12-29 16:13:18+03";"2004-12-29 16:13:33.330431+03";"0";"7812" ZM> Another thing is that you should not get NULL in place ZM> of calledstationip (assuming the call is not rejected). ZM> ----- Original Message ----- ZM> From: "Roman V. Luschik" <ro...@du...> ZM> Sent: Wednesday, December 29, 2004 1:39 PM >> ZM> No, that's exactly how it is supposed to work. Terminating >> ZM> account/tariff is matched based on dialed number and/or terminating >> IP, >> ZM> not on the originating party h323id. >> >> For example : >> i have incoming call to my gateway whith CallingPartyNum=70951111111 >> and CalledPartyNum=78125555555. >> in voipuser tables i have following record >> 23875;"8";"70951111111";"2";"FALSE";"TRUE";"1";"^$";"''";"";"qqq";"qqq";"TRUE" >> >> i have the following record in voipcall table: >> >> "315";"2";"70951111111";"0000014E";"9C45EA35 588E11D9 937C99AA >> 9D030214";"10.10.10.10";"''";"127.0.0.1";"70951111111";"127.0.0.1";"78125555555";"2004-12-29 >> 11:07:59+03";"2004-12-29 11:08:02+03";"2004-12-29 >> 11:08:36+03";"10";"34";"0.0397";"0.0700";"USD";"test";"1";"1";"0";"2004-12-29 >> 08:09:50+03";"0";"2004-12-29 08:09:50+03";"2004-12-29 >> 08:10:26.494159+03";"0";"7812" >> >> and nothing in voipcalltermtarif >> >> How the call will get in the table voipcalltermtarif? >> SELECT INTO termuser * FROM >> match_terminating_user('78125555555', false, >> NULL); -- Best regards, Roman mailto:ro...@du... |