[Serusers] Broken Calls not written to Database
Iqbal
iqbal at gigo.co.uk
Tue Jul 12 19:46:00 CEST 2005
what I would do is to write all calls, but bill them as zero, that way
if at a later date you need to bill you can. As for DB getting billing
not sure what the best practice here is, but i am thinking of dumping
the acc to archive every 3 mnths
Iqbal
Ozan Blotter wrote:
> Dear Iqbal,
>
> Thanks for your help and btw i've found the way how to prevent
> database not to write 833 to 833 calls which are free and has nothing
> to do with, so my database not grows with them. I think the broken
> calls can be set in MERA VoIP which is used as PSTN Gateway by our
> Carrier.
>
> Thanks Again,
> Ozan
>
> # -----------------------------------------------------------------
> # Record Route Section and Acc section
> #
> -----------------------------------------------------------------
> if (method=="INVITE" && client_nat_test("3")) {
> record_route_preset("212.XXX.104.XXX:5060;nat=yes");
> } else if (method!="REGISTER") {
> if!(uri=~"^sip:833[0-9]*@") {
> record_route();
> setflag(1);
> }
> };
>
> # -----------------------------------------------------------------
>
>
>
> ----- Original Message ----- From: "Iqbal" <iqbal at gigo.co.uk>
> To: "Ozan Blotter" <cosmocid at ispro.net.tr>
> Cc: <serusers at lists.iptel.org>
> Sent: Tuesday, July 12, 2005 8:06 PM
> Subject: Re: [Serusers] Broken Calls not written to Database
>
>
>> oh completely forgot to answer the question, if the user unplugs,
>> then who will send the BYE, only the pstn gateway can, and most can
>> (someone confirm) send a BYE if they receive nothing for a
>> transaction for 30secs or so, hence ur billing might be out for 30secs.
>> However what i do for a "broken" call, is to complete it when I do my
>> billing, by how much, well thats upto what mood I am in :-), but
>> usually round it up to the next minute. This is not accurate, because
>> the user may bypass this and not send a BYE but might have carried on
>> his call...soooooo get the CDR from the gateway, and for open calls,
>> I am trying to match the cdr data with that in ser, which aint easy
>> sinc ethe cdr have no username of them.
>>
>> Again these are just methods to reduce/remove the inaccuracies, it
>> wont be 100% but over time it will get close
>>
>> Iqbal
>>
>> Ozan Blotter wrote:
>>
>>> Dear List,
>>> I'm making a call to PSTN, it's okay i can talk with the other
>>> party via ATA, but suddenly i unplug power from it, and in
>>> accounting module it does not write line with BYE message so i
>>> cannot understand whether the call is finished or not. only INVITE
>>> and ACK are written, no BYE :(
>>> This may be a security hole for customers, because they talk for a
>>> long time and they may unplug their units or cut power so it does
>>> not tell SER it's over. How i can prevent this, also what i need to
>>> add as a line for telling ACC module not to write calls from 833 to
>>> 833 into database, which are free SIP2SIP calls ?
>>> Btw, a Postpaid Billing System is on the way for OpenSER built in
>>> PHP, later i will need OpenSER group's help to place it onto hosting
>>> site. Shortly it will have features:
>>> * Nothing extra from package, default MySql Database which comes
>>> with OpenSER Release is being used,
>>> * All routing is done via OpenSER's ser.cfg ,
>>> * Initial Rate, Initial Time, Increment Rate, Increment Time will be
>>> user variable ,
>>> * Account Creation/Deletion done in PHP ,
>>> * Invoice Generation and CDR will include many variables ,
>>> * Rating will be in PHP,
>>> * And everything is totaly free :)
>>> If you have ideas and/or suggestion please write back to me so i
>>> can work for it too.
>>> Reqs: OpenSER & PHP & MySql & Apache
>>> Thanks,
>>> Ozan
>>>
>>> debug=3
>>> fork=yes
>>> log_stderror=no
>>> listen=212.XXX.104.XXX
>>> port=5060
>>> children=4
>>> alias=212.XXX.104.XXX
>>> dns=no
>>> rev_dns=no
>>> fifo="/tmp/openser_fifo"
>>> fifo_db_url="mysql://openser:openserrw@localhost/openser"
>>> loadmodule "/usr/local/lib/openser/modules/mysql.so"
>>> loadmodule "/usr/local/lib/openser/modules/sl.so"
>>> loadmodule "/usr/local/lib/openser/modules/tm.so"
>>> loadmodule "/usr/local/lib/openser/modules/rr.so"
>>> loadmodule "/usr/local/lib/openser/modules/maxfwd.so"
>>> loadmodule "/usr/local/lib/openser/modules/usrloc.so"
>>> loadmodule "/usr/local/lib/openser/modules/registrar.so"
>>> loadmodule "/usr/local/lib/openser/modules/auth.so"
>>> loadmodule "/usr/local/lib/openser/modules/auth_db.so"
>>> loadmodule "/usr/local/lib/openser/modules/uri.so"
>>> loadmodule "/usr/local/lib/openser/modules/uri_db.so"
>>> loadmodule "/usr/local/lib/openser/modules/mediaproxy.so"
>>> loadmodule "/usr/local/lib/openser/modules/nathelper.so"
>>> loadmodule "/usr/local/lib/openser/modules/textops.so"
>>> loadmodule "/usr/local/lib/openser/modules/domain.so"
>>> loadmodule "/usr/local/lib/openser/modules/acc.so"
>>> #modparam("auth_db|uri_db|usrloc", "db_url",
>>> "mysql://ser:heslo@localhost/ser")
>>> modparam("auth_db", "calculate_ha1", 1)
>>> modparam("auth_db", "password_column", "password")
>>> modparam("auth_db", "use_domain", 1)
>>> modparam("domain", "db_mode", 1)
>>> modparam("nathelper", "rtpproxy_disable", 1)
>>> modparam("nathelper", "natping_interval", 0)
>>> modparam("mediaproxy","natping_interval", 30)
>>> modparam("mediaproxy","mediaproxy_socket", "/var/run/mediaproxy.sock")
>>> modparam("mediaproxy","sip_asymmetrics","/usr/local/etc/openser/sip-asymmetric-clients")
>>>
>>> modparam("mediaproxy","rtp_asymmetrics","/usr/local/etc/openser/rtp-asymmetric-clients")
>>>
>>> modparam("usrloc", "db_mode", 2)
>>> modparam("usrloc", "use_domain", 1)
>>> modparam("registrar", "default_expires", 60)
>>> modparam("registrar", "min_expires", 30)
>>> modparam("registrar", "nat_flag", 6)
>>> modparam("registrar", "use_domain", 1)
>>> modparam("rr", "enable_full_lr", 1)
>>> modparam("acc", "db_url",
>>> "mysql://openser:openserrw@localhost/openser")
>>> modparam("acc", "log_level", 1)
>>> modparam("acc", "log_flag", 1)
>>> modparam("acc", "db_flag", 1)
>>> route {
>>> # -----------------------------------------------------------------
>>> # Sanity Check Section
>>> #
>>> -----------------------------------------------------------------
>>> if (!mf_process_maxfwd_header("10")) {
>>> sl_send_reply("483", "Too Many Hops");
>>> break;
>>> };
>>> if (msg:len > max_len) {
>>> sl_send_reply("513", "Message Overflow");
>>> break;
>>> };
>>> # -----------------------------------------------------------------
>>> # Record Route Section and Acc section
>>> #
>>> -----------------------------------------------------------------
>>> if (method=="INVITE" && client_nat_test("3")) {
>>> # INSERT YOUR IP ADDRESS HERE
>>> record_route_preset("212.XXX.104.XXX:5060;nat=yes");
>>> } else if (method!="REGISTER") {
>>> record_route();
>>> setflag(1);
>>> };
>>> # -----------------------------------------------------------------
>>> # Call Tear Down Section
>>> #
>>> -----------------------------------------------------------------
>>> if (method=="BYE" || method=="CANCEL") {
>>> end_media_session();
>>> };
>>> # -----------------------------------------------------------------
>>> # Loose Route Section
>>> #
>>> -----------------------------------------------------------------
>>> if (loose_route()) {
>>> if (has_totag() && (method=="INVITE" || method=="ACK")) {
>>> if (client_nat_test("3") || search("^Route:.*;nat=yes")) {
>>> setflag(6);
>>> use_media_proxy();
>>> };
>>> };
>>> route(1);
>>> break;
>>> };
>>> # -----------------------------------------------------------------
>>> # Call Type Processing Section
>>> #
>>> -----------------------------------------------------------------
>>> if (uri!=myself) {
>>> route(1);
>>> break;
>>> };
>>> if (uri==myself) {
>>> if (method=="CANCEL") {
>>> route(3);
>>> break;
>>> } else if (method=="INVITE") {
>>> route(3);
>>> break;
>>> } else if (method=="REGISTER") {
>>> route(2);
>>> break;
>>> };
>>> lookup("aliases");
>>> if (uri!=myself) {
>>> route(1);
>>> break;
>>> };
>>> if (!lookup("location")) {
>>> sl_send_reply("404", "User Not Found");
>>> break;
>>> };
>>> };
>>> route(1);
>>> }
>>> route[1] {
>>> # -----------------------------------------------------------------
>>> # Default Message Handler
>>> #
>>> -----------------------------------------------------------------
>>> t_on_reply("1");
>>> if (!t_relay()) {
>>> if (method=="INVITE" || method=="ACK") {
>>> end_media_session();
>>> };
>>> sl_reply_error();
>>> };
>>> }
>>> route[2] {
>>> # -----------------------------------------------------------------
>>> # REGISTER Message Handler
>>> #
>>> ----------------------------------------------------------------
>>> if (!search("^Contact:\ +\*") && client_nat_test("7")) {
>>> setflag(6);
>>> fix_nated_register();
>>> force_rport();
>>> };
>>> sl_send_reply("100", "Trying");
>>> if (!www_authorize("","subscriber")) {
>>> www_challenge("","0");
>>> break;
>>> };
>>> if (!check_to()) {
>>> sl_send_reply("401", "Unauthorized");
>>> break;
>>> };
>>> consume_credentials();
>>> if (!save("location")) {
>>> sl_reply_error();
>>> };
>>> }
>>> route[3] {
>>> # -----------------------------------------------------------------
>>> # CANCEL and INVITE Message Handler
>>> #
>>> -----------------------------------------------------------------
>>> if (client_nat_test("3")) {
>>> setflag(7);
>>> force_rport();
>>> fix_nated_contact();
>>> };
>>> lookup("aliases");
>>> if (uri!=myself) {
>>> route(1);
>>> break;
>>> };
>>> if (uri=~"^sip:0[0-9]*@*") {
>>> rewritehost("212.XXX.59.XXX");
>>> route(1);
>>> break;
>>> };
>>> if (!lookup("location")) {
>>> sl_send_reply("404", "User Not Found");
>>> break;
>>> };
>>> if (method=="CANCEL") {
>>> route(1);
>>> break;
>>> };
>>> if (!proxy_authorize("","subscriber")) {
>>> proxy_challenge("","0");
>>> break;
>>> } else if (!check_from()) {
>>> sl_send_reply("403", "Use From=ID");
>>> break;
>>> };
>>> consume_credentials();
>>> if (isflagset(6) || isflagset(7)) {
>>> use_media_proxy();
>>> };
>>> route(1);
>>> }
>>> onreply_route[1] {
>>> if ((isflagset(6) || isflagset(7)) &&
>>> (status=~"(180)|(183)|2[0-9][0-9]")) {
>>> if (!search("^Content-Length:\ +0")) {
>>> use_media_proxy();
>>> };
>>> };
>>> if (client_nat_test("1")) {
>>> fix_nated_contact();
>>> };
>>> }
>>>
>>> ------------------------------------------------------------------------
>>>
>>>
>>> _______________________________________________
>>> Serusers mailing list
>>> serusers at lists.iptel.org
>>> http://lists.iptel.org/mailman/listinfo/serusers
>>>
>
>
> .
>
More information about the sr-users
mailing list