Re: [Serusers] mysql problem when runnnig cvs head version - SOLVED!!

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" &lt;rafael_rgv(a)yahoo.com&gt; 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(a)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.