Hi SerUsers,

I'm using SER 0.9.2 on Fedora Core 3, it works good, i can do MySql Auth. but i couldn't make it work with Accounting Module. I get INVITE and ACK messages only in Database as:

? ? <sip:12345@192.168.1.9;user=phone>;tag=xIzNxkDMxID <sip:54321@192.168.1.9>;tag=xIzM5MDMxID 200 INVITE sip:54321@192.168.1.9 sip:54321@192.168.1.201:5060 sip:12345@192.168.1.9;user=phone sip:54321@192.168.1.9 950D1B912D91212@192.168.1.200 12345 192.168.1.9 xIzNxkDMxID xIzM5MDMxID 2005-05-25 21:20:05 20050526002005

? ? <sip:12345@192.168.1.9;user=phone>;tag=xIzNxkDMxID <sip:54321@192.168.1.9>;tag=xIzM5MDMxID 200 ACK sip:192.168.1.9 sip:54321@192.168.1.201:5060 sip:12345@192.168.1.9;user=phone sip:54321@192.168.1.9 950D1B912D91212@192.168.1.200 12345 192.168.1.9 xIzNxkDMxID xIzM5MDMxID 2005-05-25 21:20:05 20050526002005

It never gave me BYE messages :(

Below is my ser.cfg >>>>>>>>>>>>>>>>>>>

debug=3
fork=yes
log_stderror=no

listen=192.168.1.9 # put your server IP address here
port=5060
children=4

dns=no
rev_dns=no

fifo="/tmp/ser_fifo"
fifo_db_url="mysql://ser:heslo@localhost/ser"

loadmodule "/usr/local/lib/ser/modules/mysql.so"
loadmodule "/usr/local/lib/ser/modules/sl.so"
loadmodule "/usr/local/lib/ser/modules/tm.so"
loadmodule "/usr/local/lib/ser/modules/rr.so"
loadmodule "/usr/local/lib/ser/modules/maxfwd.so"
loadmodule "/usr/local/lib/ser/modules/usrloc.so"
loadmodule "/usr/local/lib/ser/modules/registrar.so"
loadmodule "/usr/local/lib/ser/modules/auth.so"
loadmodule "/usr/local/lib/ser/modules/auth_db.so"
loadmodule "/usr/local/lib/ser/modules/acc.so"
loadmodule "/usr/local/lib/ser/modules/uri_db.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("usrloc", "db_mode", 2)
modparam("rr", "enable_full_lr", 1)

modparam("acc", "log_level", 1)
modparam("acc", "db_flag", 1)
modparam("acc", "log_missed_flag", 3)
modparam("acc", "log_fmt", "fimos")
modparam("acc", "db_url", "mysql://ser:heslo@localhost/ser")
modparam("acc", "db_missed_flag", 2)
modparam("acc", "early_media", 1)
modparam("acc", "failed_transactions", 1)
modparam("acc", "log_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
        # -----------------------------------------------------------------
        if (method!="REGISTER") {
                record_route();
        };

        # -----------------------------------------------------------------
        # Loose Route Section
        # -----------------------------------------------------------------
        if (loose_route()) {
                route(1);
                break;
        };

setflag(1);

        # -----------------------------------------------------------------
        # Call Type Processing Section
        # -----------------------------------------------------------------
        if (uri!=myself) {
                route(1);
                break;
        };

        if (uri==myself) {
                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
        # -----------------------------------------------------------------
        if (!t_relay()) {
                sl_reply_error();
        };
}

route[2] {

        # -----------------------------------------------------------------
        # REGISTER Message Handler
        # ----------------------------------------------------------------
        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] {
        # -----------------------------------------------------------------
        # INVITE Message Handler
        # -----------------------------------------------------------------
        if (!proxy_authorize("localhost","subscriber")) {
                proxy_challenge("localhost","0");
                break;
        } else if (!check_from()) {
                sl_send_reply("403", "Use From=ID");
                break;
        };

consume_credentials();

        lookup("aliases");
        if (uri!=myself) {
                route(1);
                break;
        };

        if (!lookup("location")) {
                sl_send_reply("404", "User Not Found");
                break;
        };

route(1);
}
<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<

Thanks,

PS : is there anyone for basic billing for SER. CDRtool from agProject seems okay but i have no idea, i need a billing directly from SER's database, not Radius. A PHP Coder can do that within a couple of hours i believe.