[OpenSER-Users] Accounting issues

[David Villasmil Govea]

Hello all,

     I finally got accounting on db to work. I added a few extra fields and
its all fine. But i have some questions:

I added:

     modparam("acc", "db_extra", "from_uri=$fu ; to_uri=$tu ; from_user=$fU;
source_ip=$si")

     to me config, and all the info gets loaded. BUT, source_ip is not
always the ip from which the request was received, either that, or INVITES
are not getting logged!
 well, that's really 2 questions in one... ;)

here's my config:

#
# sample config file to be used with nathelper/rtpproxy
#
# start RTPProxy with: rtpproxy -l your_public_ip -s udp:localhost:8899
#

# ----------- global configuration parameters ------------------------

debug=2            # debug level (cmd line: -dddddddddd)
fork=yes
log_stderror=yes # (cmd line: -E)

# Uncomment these lines to enter debugging mode
#fork=no
#log_stderror=yes


check_via=no    # (cmd. line: -v)
dns=no          # (cmd. line: -r)
rev_dns=no      # (cmd. line: -R)
port=5060
children=20
disable_dns_blacklist=true


#

# --- module loading

mpath="/usr/lib/openser/modules/"

loadmodule "mysql.so"
loadmodule "sl.so"
loadmodule "tm.so"
loadmodule "rr.so"
loadmodule "maxfwd.so"
loadmodule "usrloc.so"
loadmodule "registrar.so"
loadmodule "textops.so"
loadmodule "nathelper.so"
loadmodule "auth.so"
loadmodule "auth_db.so"
loadmodule "mi_fifo.so"
loadmodule "dispatcher.so"
#loadmodule "domain.so"
loadmodule "xlog.so"
loadmodule "/usr/lib/openser/modules/acc.so"

modparam("acc", "early_media", 1)
modparam("acc", "report_cancels", 1)

modparam("acc", "db_flag", 2)
modparam("acc", "db_url", "mysql://openser:password@localhost/openser")
modparam("acc", "report_ack", 0)
modparam("acc", "db_missed_flag", 3)
modparam("acc", "failed_transaction_flag", 4)
modparam("acc", "db_extra", "from_uri=$fu ; to_uri=$tu ; from_user=$fU;
source_ip=$si")


#
#       CONSTANTS
#

# --- setting module parameters
#modparam("domain","db_url","mysql://openser:password@localhost/openser")
#modparam("domain", "db_mode", 1)
#modparam("domain", "domain_table", "domain")
#modparam("domain", "domain_col", "domain")

modparam("xlog", "buf_size", 8192)

# --- setting module parameters
modparam("dispatcher", "list_file", "/etc/openser/dispatcher.list")

# -- mi_fifo params --
modparam("mi_fifo", "fifo_name", "/tmp/openser_fifo")

modparam("usrloc|auth_db","db_url","mysql://openser:password@localhost
/openser")

# -- usrloc params --
modparam("usrloc", "db_mode", 1)
modparam("usrloc", "nat_bflag", 6)
#modparam("usrloc", "use_domain", 0)

# -- registrar params --
modparam("registrar|nathelper", "received_avp", "$avp(i:42)")

# -- auth params --
modparam("auth_db", "calculate_ha1", yes)
modparam("auth_db", "password_column", "password")
#modparam("auth_db", "use_domain", 0)

# -- rr params --
#modparam("rr", "enable_full_lr", 1)



# -- nathelper
modparam("nathelper", "rtpproxy_sock", "udp:1.2.3.4:8899")
modparam("nathelper", "natping_interval", 30)
modparam("nathelper", "ping_nated_only", 1)
modparam("nathelper", "sipping_bflag", 7)
modparam("nathelper", "sipping_from", "sip:pinger at sip.whatever.com")

#modparam("registrar", "max_contacts", 1)

# --- main routing logic
route{
        if (method=="INVITE") {
                xlog("L_NOTICE", "INVITE MESSAGE RECEIVED - START ACC\n");
                setflag(2);
                setflag(3);
                setflag(4);
        };

        if (method=="BYE") {
                xlog ("L_NOTICE", "BYE  - STOP ACCOUNTING\n");
                setflag(2);
                setflag(3);
                setflag(4);
        };

        if (method=="CANCEL") {
                xlog ("L_NOTICE", "CANCEL - STOP ACCOUNTING\n");
                setflag(2);
                setflag(3);
                setflag(4);
        };

        if (method=="REGISTER") {
                setflag(2);
                setflag(3);
                setflag(4);
        };


        if (!mf_process_maxfwd_header("100")) {
                sl_send_reply("483","Too Many Hops");
                exit;
        };

        #if (msg:len >=  2048 ) {
        #       sl_send_reply("513", "Message too big");
        #       exit;
        #};

        # NAT detection
        route(2);

        if (!method=="REGISTER")
                record_route();

        if (loose_route()) {
                append_hf("P-hint: rr-enforced\r\n");
                route(1);
        };

        if (!uri==myself) {
#       if (!is_uri_host_local() ) {
                append_hf("P-hint: outbound\r\n");
                route(1);
        };

        if (uri==myself) {
                if (method=="REGISTER") {
                        xlog("L_NOTICE", "\nNew Registration\n");

                        if (!www_authorize("sip.whatever.com",
"subscriber")) {
                                xlog("L_NOTICE", "\nRegistration FAILED!
CLIENT: $au\n");
                                www_challenge("sip.whatever.com", "0");
                                exit;
                        };

                        if (isflagset(5)) {
                                xlog("L_NOTICE", "\nRegistration OK\n");
                                setbflag(6);
                                # if you want OPTIONS natpings uncomment
next
                                # setbflag(7);
                        };
                        save("location");
                        exit;
                };

        };

        route(1);
}


route[1] {
        xlog("L_NOTICE", "\n**************IN ROUTE 1************\n");
        if (subst_uri('/(sip:.*);nat=yes/\1/')){
                setbflag(6);
        };

        if (isflagset(5)||isbflagset(6)) {
                route(3);
        }

        if (!t_relay()) {
                sl_reply_error();
        };
        exit;
}

route[2]{
        force_rport();
        if (nat_uac_test("19")) {
                if (method=="REGISTER") {
                        fix_nated_register();
                } else {
                        fix_nated_contact();
                };
                setflag(5);
        };
}

route[3] {
        if (is_method("BYE|CANCEL")) {
                unforce_rtp_proxy();
        } else if (is_method("INVITE")){
                force_rtp_proxy();
                t_on_failure("1");
        };
        if (isflagset(5))
                search_append('Contact:.*sip:[^>[:cntrl:]]*', ';nat=yes');
        t_on_reply("1");
}

failure_route[1] {
        if (isbflagset(6) || isflagset(5)) {
                unforce_rtp_proxy();
        }
}

onreply_route[1] {
        if ((isflagset(5) || isbflagset(6)) &&
status=~"(183)|(2[0-9][0-9])") {
                force_rtp_proxy();
        }
        search_append('Contact:.*sip:[^>[:cntrl:]]*', ';nat=yes');

        if (isbflagset(6)) {
                fix_nated_contact();
        }
        exit;
}


#=======================================

Thanks in advance!

Any other comment to make this cfg better, i'm all ears!!

David
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.kamailio.org/pipermail/users/attachments/20071207/c66eff7d/attachment.htm