[OpenSER-Users] registrations not saved in the mysql database

[Ovidiu Sas]

Hi all,

I was trying to keep persistent registrations in the mysql db, but it
seems that something is broken in the latest svn:
version: openser 1.3.0-pre1-notls (i386/linux)
flags: STATS: Off, EXTRA_DEBUG, USE_IPV6, USE_TCP, DISABLE_NAGLE,
USE_MCAST, SHM_MEM, SHM_MMAP, PKG_MALLOC, F_MALLOC,
FAST_LOCK-ADAPTIVE_WAIT
ADAPTIVE_WAIT_LOOPS=1024, MAX_RECV_BUFFER_SIZE 262144, MAX_LISTEN 16,
MAX_URI_SIZE 1024, BUF_SIZE 65535
poll method support: poll, epoll_lt, epoll_et, sigio_rt, select.
svnrevision: 2:3034M
@(#) $Id: main.c 3015 2007-11-05 13:08:50Z henningw $
main.c compiled on 11:41:03 Nov  6 2007 with gcc 4.1.2

The config that I used for testing is pretty simple:

# ----------- global configuration parameters ------------------------
debug=9            # debug level (cmd line: -dddddddddd)
fork=yes
log_stderror=no    # (cmd line: -E)
children=1
disable_tcp=yes

# ------------------ module loading ----------------------------------
mpath="/usr/local/lib/openser/modules/"
loadmodule "mysql.so"
loadmodule "sl.so"
loadmodule "tm.so"
loadmodule "rr.so"
loadmodule "maxfwd.so"
loadmodule "textops.so"
loadmodule "mi_fifo.so"
modparam("mi_fifo", "fifo_name", "/tmp/openser_fifo")

loadmodule "usrloc.so"
modparam("usrloc", "db_url", "mysql://openser:openserrw@127.0.0.1/openser")
modparam("usrloc", "db_mode", 1)

loadmodule "registrar.so"
#-------------------------  request routing logic -------------------
route{

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

        if (loose_route()) {
                # mark routing logic in request
                append_hf("P-hint: rr-enforced\r\n");
                route(1);
        };

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

        if (uri==myself) {
                if (method=="REGISTER") {
                        save("location");
                        exit;
                };
                if (!lookup("location")) {
                        sl_send_reply("404", "Not Found");
                        exit;
                };
                append_hf("P-hint: usrloc applied\r\n");
        };

        route(1);
}


route[1] {
        if (!t_relay()) {
                sl_reply_error();
        };
        exit;
}



Here are the relevant debug logs:

Nov  6 12:19:04 localhost /usr/local/sbin/openser[8963]:
core:db_double2str: Error in snprintf
Nov  6 12:19:04 localhost /usr/local/sbin/openser[8963]:
mysql:val2str: error while converting string to double
Nov  6 12:19:04 localhost /usr/local/sbin/openser[8963]:
core:db_print_values: Error while converting value to string
Nov  6 12:19:04 localhost /usr/local/sbin/openser[8963]:
usrloc:db_insert_ucontact: inserting contact in db failed
Nov  6 12:19:04 localhost /usr/local/sbin/openser[8963]:
usrloc:insert_ucontact: failed to insert in database


I can see the in memory registration via `openserctl ul show' command,
but the mysql database is not updated (verified via `openserctl db
show location')



Regards,
Ovidiu Sas