[Serusers] BD accountingok, but no connection

[Joao Pereira]

Hello to all

I already have SER going to the DB to check if the endpoints are registered,
but when I enabled the DB accountig I couldnt do calls between the
endpoints.

Can someone check my routing policy and tell me why does SER always returns
"Not Found"?

Thanks
Joao

theres my ser.conf:


debug=5
#fork=no
log_stderror=yes


check_via=no    # (cmd. line: -v)
dns=no           # (cmd. line: -r)
rev_dns=no      # (cmd. line: -R)
fifo="/tmp/ser_fifo"

# ------------------ module loading ----------------------------------
loadmodule "/usr/local/lib/ser/modules/postgres.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"

# ----------------- setting module-specific parameters ---------------
modparam("usrloc", "db_mode",   1)
modparam("usrloc", "user_column", "username")
modparam("usrloc", "contact_column", "contacto")
modparam("usrloc", "expires_column", "expires")
modparam("usrloc", "db_url", "DB_STUFF")
modparam("usrloc", "timer_interval", 120)

modparam("auth_db", "calculate_ha1", yes)

modparam("auth_db", "user_column", "username")
modparam("auth_db", "domain_column", "dominio")

modparam("auth_db", "calculate_ha1", 1)
modparam("auth_db", "password_column", "password")
modparam("auth_db", "use_rpid", 0)

modparam("auth_db","db_url","DB_STUFF")

modparam("rr", "enable_full_lr", 1)

# -------------------------  request routing logic -------------------
route{

        if (!mf_process_maxfwd_header("10")) {
                sl_send_reply("483","Too Many Hops");
                break;
        };
        if ( msg:len > max_len ) {
                sl_send_reply("513", "Message too big");
                break;
        };

        if (loose_route()) {
                t_relay();
                break;
        };

if (uri==myself) {
        if (method=="REGISTER") {
                if (!www_authorize("DB_IP", "utilizador")) {
                www_challenge("DB_IP", "0");
                break;
                };
        save("registo_sip");
        break;
        };

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

};

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

        };



}