hello
...answering myself:
1. Update database tables: ser_mysql.sh backup and then reinstall...
2. I had problems with adding users using the serctl with this new database:
 error: " error: overlap with an existing alias " ... I solved adding lookup("aliases");  in the configuration file.
 
maybe  will be useful for someone...
 
# ----------- global configuration parameters ------------------------
#debug=3         # debug level (cmd line: -dddddddddd)
#fork=yes
#log_stderror=no        # (cmd line: -E)
#/* Uncomment these lines to enter debugging mode
debug=9
fork=yes
log_stderror=yes
#*/
listen=200.110.2.xxx
listen=127.0.0.1
port=5060
# hostname matching an alias will satisfy the condition uri==myself".
alias=200.110.2.xxx
check_via=no    # (cmd. line: -v)
dns=no           # (cmd. line: -r)
rev_dns=no      # (cmd. line: -R)
children=4
fifo="/tmp/ser_fifo"
# ------------------ module loading ----------------------------------
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/group.so"
loadmodule "/usr/local/lib/ser/modules/uri.so"
loadmodule "/usr/local/lib/ser/modules/uri_db.so" ##needed in cvs head version
loadmodule "/usr/local/lib/ser/modules/acc.so"
# loadmodule "/usr/local/lib/ser/modules/vm.so"
# digest authentication
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",   2)
# storing passwords in our database in plain text:
# modparam("auth_db", "calculate_ha1", yes)
# modparam("auth_db", "password_column", "password")
# For Rad Accounting
modparam("acc","radius_config","/usr/local/etc/radiusclient/radiusclient.conf")
modparam("acc", "service_type", 15)
modparam("acc", "radius_flag", 1)
modparam("acc", "radius_missed_flag", 3)
modparam("acc", "report_ack", 0)
modparam("tm", "fr_timer", 20 )
modparam("tm", "fr_inv_timer", 30 )
modparam("tm", "wt_timer", 20 )
modparam("tm", "uac_from", "sip:avisos@millicom.net.pe" )
modparam("rr", "enable_full_lr", 1)
modparam("group", "db_url", "mysql://ser:heslo@localhost/ser")  # mysql in cvs head vs
#modparam("uri", "db_url", "sql://ser:heslo@localhost/ser") ## in ser0814
modparam("uri_db", "db_url", "mysql://ser:heslo@localhost/ser") # in cvs head version

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

        # initial sanity checks -- messages with
        # max_forwards==0, or excessively long requests
        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;
        };
        # we record-route all messages -- to make sure that
        # subsequent messages will go through our proxy; that's
        # particularly good if upstream and downstream entities
        # use different transport protocol
        record_route();
        # loose-route processing
        if (loose_route()) {
                t_relay();
                break;
        };
          # set for accounting:
    
                if (method=="INVITE") {
                log(1, "INVITE\n");
                setflag(1); /* set for accounting (the same value as in log_flag!) */
                };
                if (method=="BYE" || method=="CANCEL") {
                log (1, "BYE or CANCEL\n");
                setflag(1);
                };

        if (!uri==myself) {
                t_relay();
                break;
        };
        if (method == "REGISTER") {
                # to use digest authentication
                if (!www_authorize("call.millicom.com.pe", "subscriber")) {
                        www_challenge("call.millicom.com.pe", "0");
                        break;
                };
                if (!save("location")) {
                        sl_reply_error();
                };
                break;
        };
        lookup("aliases");
        # does the user wish redirection on no availability? (i.e., is he
        # in the voicemail group?) -- determine it now and store it in
        # flag 4, before we rewrite the flag using UsrLoc
        if (is_user_in("Request-URI", "voicemail")) {
                setflag(4);
        };
        setflag(3);
        # native SIP destinations are handled using our USRLOC DB
        if (!lookup("location")) {
                # handle user which was not found
                        route(4);
                        break;
        };
        # if user is on-line and is in voicemail group, enable redirection
        if (method == "INVITE" && isflagset(4)) {
                t_on_failure("1");
        };
        t_relay();
}
# ------------- handling of unavailable user ------------------
route[4] {
       # non-Voip -- just send "off-line"
        if (!(method=="INVITE" || method=="ACK" || method=="CANCEL" || method == "REFER" || method == "BYE")) {
                sl_send_reply("404", "Not Found");
                acc_rad_request("404 Not Found");
                break;
        };
        # not voicemail subscriber
        if (!isflagset(4)) {
                sl_send_reply("404", "Not Found and no voicemail turned on");
                acc_rad_request("404 Not Found");
                break;
        };
        # forward to voicemail now
        rewritehostport("call.millicom.com.pe:5090");
        t_relay_to_udp("call.millicom.com.pe", "5090");
}
# if forwarding downstream did not succeed, try voicemail running
# at bat.iptel.org:5090
failure_route[1] {
        revert_uri();
        rewritehostport("call.millicom.com.pe:5090");
        append_branch();
        t_relay_to_udp("call.millicom.com.pe", "5090");
}
 
 
rafael


"Rafael J. Risco G.V" <rafael_rgv@yahoo.com> wrote:
Hello
 
I need to run ser dev version (from cvs head) in order to run dev version of sems with mp3 recording support and other features... I re-compiled ser and change some parameters like this:
 
loadmodule "/usr/local/lib/ser/modules/uri_db.so" ##needed in cvs head version
modparam("group", "db_url", "mysql://ser:heslo@localhost/ser")  # "mysql" instead of "sql" in cvs head vs.
modparam("uri_db", "db_url", "mysql://ser:heslo@localhost/ser") # instead of "uri"
 
please see errors below...  any idea?
 
 0(0) group module - initializing
 0(0) find_mod_export: found <db_use_table> in module mysql [/usr/local/lib/ser/modules/mysql.so]
 0(0) find_mod_export: found <db_init> in module mysql [/usr/local/lib/ser/modules/mysql.so]
 0(0) find_mod_export: found <db_close> in module mysql [/usr/local/lib/ser/modules/mysql.so]
 0(0) find_mod_export: found <db_query> in module mysql [/usr/local/lib/ser/modules/mysql.so]
 0(0) find_mod_export: found <db_raw_query> in module mysql [/usr/local/lib/ser/modules/mysql.so]
 0(0) find_mod_export: found <db_free_result> in module mysql [/usr/local/lib/ser/modules/mysql.so]
 0(0) find_mod_export: found <db_insert> in module mysql [/usr/local/lib/ser/modules/mysql.so]
 0(0) find_mod_export: found <db_delete> in module mysql [/usr/local/lib/ser/modules/mysql.so]
 0(0) find_mod_export: found <db_update> in module my sql [/usr/local/lib/ser/modules/mysql.so]
 0(0) get_connection(): Connection not found in the pool
[root@gkproxy01 sip_router]#  0(0) submit_query(): Unknown column 'table_version' in 'field list'
 0(0) submit_query(): Error while submitting query
 0(0) table_version(): Error in db_query
 0(0) release_connection(): Removing connection from the pool
 0(0) group:mod_init(): Error while querying table version
 0(0) init_mod(): Error while initializing module group
ERROR: error while initializing modules
 0(0) DEBUG: tm_shutdown : start
 0(0) DEBUG: unlink_timer_lists : empting DELETE list
 0(0) DEBUG: tm_shutdown : empting hash table
 0(0) DEBUG: tm_shutdown : releasing timers
 0(0) DEBUG: tm_shutdown : removing semaphores
 0(0) DEBUG: tm_shutdown : destroing tmcb lists
 0(0) DEBUG: tm_shutdown : done
 0(4380) shm_mem_destroy
 0(4380) destroying the sha red memory lock



Do You Yahoo!?
Todo lo que quieres saber de Estados Unidos, América Latina y el resto del Mundo.
Visíta Yahoo! Noticias.
_______________________________________________
Serusers mailing list
serusers@lists.iptel.org
http://lists.iptel.org/mailman/listinfo/serusers



Do You Yahoo!?
Todo lo que quieres saber de Estados Unidos, América Latina y el resto del Mundo.
Visíta Yahoo! Noticias.