<DIV>hello</DIV>
<DIV>...answering myself:</DIV>
<DIV>1. Update database tables: ser_mysql.sh backup and then reinstall...</DIV>
<DIV>2. I had problems with adding users using the serctl with this new database:</DIV>
<DIV> error: " error: overlap with an existing alias " ... I solved adding lookup("aliases"); in the configuration file.</DIV>
<DIV> </DIV>
<DIV>maybe will be useful for someone...</DIV>
<DIV> </DIV>
<DIV># ----------- global configuration parameters ------------------------</DIV>
<DIV>#debug=3 # debug level (cmd line: -dddddddddd)<BR>#fork=yes<BR>#log_stderror=no # (cmd line: -E)</DIV>
<DIV>#/* Uncomment these lines to enter debugging mode<BR>debug=9<BR>fork=yes<BR>log_stderror=yes<BR>#*/</DIV>
<DIV>listen=200.110.2.xxx<BR>listen=127.0.0.1<BR>port=5060</DIV>
<DIV># hostname matching an alias will satisfy the condition uri==myself".<BR>alias=200.110.2.xxx</DIV>
<DIV>check_via=no # (cmd. line: -v)<BR>dns=no # (cmd. line: -r)<BR>rev_dns=no # (cmd. line: -R)<BR>children=4<BR>fifo="/tmp/ser_fifo"</DIV>
<DIV># ------------------ module loading ----------------------------------<BR>loadmodule "/usr/local/lib/ser/modules/mysql.so"<BR>loadmodule "/usr/local/lib/ser/modules/sl.so"<BR>loadmodule "/usr/local/lib/ser/modules/tm.so"<BR>loadmodule "/usr/local/lib/ser/modules/rr.so"<BR>loadmodule "/usr/local/lib/ser/modules/maxfwd.so"<BR>loadmodule "/usr/local/lib/ser/modules/usrloc.so"<BR>loadmodule "/usr/local/lib/ser/modules/registrar.so"<BR>loadmodule "/usr/local/lib/ser/modules/group.so"<BR>loadmodule "/usr/local/lib/ser/modules/uri.so"<BR>loadmodule "/usr/local/lib/ser/modules/uri_db.so" ##needed in cvs head version<BR>loadmodule "/usr/local/lib/ser/modules/acc.so"<BR># loadmodule "/usr/local/lib/ser/modules/vm.so"</DIV>
<DIV># digest authentication<BR>loadmodule "/usr/local/lib/ser/modules/auth.so"<BR>loadmodule "/usr/local/lib/ser/modules/auth_db.so"</DIV>
<DIV># ----------------- setting module-specific parameters ---------------</DIV>
<DIV>modparam("usrloc", "db_mode", 2)</DIV>
<DIV># storing passwords in our database in plain text:<BR># modparam("auth_db", "calculate_ha1", yes)<BR># modparam("auth_db", "password_column", "password")</DIV>
<DIV># For Rad Accounting<BR>modparam("acc","radius_config","/usr/local/etc/radiusclient/radiusclient.conf")<BR>modparam("acc", "service_type", 15)<BR>modparam("acc", "radius_flag", 1)<BR>modparam("acc", "radius_missed_flag", 3)<BR>modparam("acc", "report_ack", 0)</DIV>
<DIV>modparam("tm", "fr_timer", 20 )<BR>modparam("tm", "fr_inv_timer", 30 )<BR>modparam("tm", "wt_timer", 20 )<BR>modparam("tm", "uac_from", "sip:avisos@millicom.net.pe" )</DIV>
<DIV>modparam("rr", "enable_full_lr", 1)</DIV>
<DIV>modparam("group", "db_url", "mysql://ser:heslo@localhost/ser") # mysql in cvs head vs<BR>#modparam("uri", "db_url", "sql://ser:heslo@localhost/ser") ## in ser0814<BR>modparam("uri_db", "db_url", "mysql://ser:heslo@localhost/ser") # in cvs head version</DIV>
<DIV><BR># --------------------- request routing logic -------------------<BR>route {</DIV>
<DIV><BR> # initial sanity checks -- messages with<BR> # max_forwards==0, or excessively long requests<BR> if (!mf_process_maxfwd_header("10")) {<BR> sl_send_reply("483","Too Many Hops");<BR> break;<BR> };<BR> if ( msg:len > max_len ) {<BR> sl_send_reply("513", "Message too big");<BR> break;<BR> };</DIV>
<DIV> # we record-route all messages -- to make sure that<BR> # subsequent messages will go through our proxy; that's<BR> # particularly good if upstream and downstream entities<BR> # use different transport protocol<BR> record_route();<BR> # loose-route processing<BR> if (loose_route()) {<BR> t_relay();<BR> break;<BR> };</DIV>
<DIV> # set for accounting:<BR> <BR> if (method=="INVITE") {<BR> log(1, "INVITE\n");<BR> setflag(1); /* set for accounting (the same value as in log_flag!) */<BR> };</DIV>
<DIV> if (method=="BYE" || method=="CANCEL") {<BR> log (1, "BYE or CANCEL\n");<BR> setflag(1);<BR> };</DIV>
<DIV><BR> if (!uri==myself) {<BR> t_relay();<BR> break;<BR> };</DIV>
<DIV> if (method == "REGISTER") {<BR> # to use digest authentication<BR> if (!www_authorize("call.millicom.com.pe", "subscriber")) {<BR> www_challenge("call.millicom.com.pe", "0");<BR> break;<BR> };<BR> if (!save("location"))
{<BR> sl_reply_error();<BR> };<BR> break;<BR> };<BR> lookup("aliases"); <BR> # does the user wish redirection on no availability? (i.e., is he<BR> # in the voicemail group?) -- determine it now and store it in<BR> # flag 4, before we rewrite the flag using UsrLoc<BR> if (is_user_in("Request-URI", "voicemail")) {<BR>
setflag(4);<BR> };<BR> setflag(3);<BR> # native SIP destinations are handled using our USRLOC DB<BR> if (!lookup("location")) {<BR> # handle user which was not found<BR> route(4);<BR> break;<BR> };</DIV>
<DIV> # if user is on-line and is in voicemail group, enable redirection<BR> if (method == "INVITE" && isflagset(4)) {<BR> t_on_failure("1");<BR> };<BR> t_relay();<BR>}</DIV>
<DIV># ------------- handling of unavailable user ------------------<BR>route[4] {<BR> # non-Voip -- just send "off-line"<BR> if (!(method=="INVITE" || method=="ACK" || method=="CANCEL" || method == "REFER" || method == "BYE")) {<BR> sl_send_reply("404", "Not Found");<BR> acc_rad_request("404 Not Found");<BR> break;<BR> };</DIV>
<DIV> # not voicemail subscriber<BR> if (!isflagset(4)) { <BR> sl_send_reply("404", "Not Found and no voicemail turned on");<BR> acc_rad_request("404 Not Found");<BR> break;<BR> };</DIV>
<DIV> # forward to voicemail now<BR> rewritehostport("call.millicom.com.pe:5090");<BR> t_relay_to_udp("call.millicom.com.pe", "5090");<BR>}</DIV>
<DIV># if forwarding downstream did not succeed, try voicemail running<BR># at bat.iptel.org:5090</DIV>
<DIV>failure_route[1] {<BR> revert_uri();<BR> rewritehostport("call.millicom.com.pe:5090");<BR> append_branch();<BR> t_relay_to_udp("call.millicom.com.pe", "5090");<BR>}<BR></DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV>rafael</DIV>
<DIV><BR><BR><B><I>"Rafael J. Risco G.V" <rafael_rgv@yahoo.com></I></B> wrote:</DIV>
<BLOCKQUOTE class=replbq style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #1010ff 2px solid">
<DIV>Hello</DIV>
<DIV> </DIV>
<DIV>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:</DIV>
<DIV> </DIV>
<DIV>loadmodule "/usr/local/lib/ser/modules/uri_db.so" ##needed in cvs head version<BR>modparam("group", "db_url", "mysql://ser:heslo@localhost/ser") # "mysql" instead of "sql" in cvs head vs.<BR>modparam("uri_db", "db_url", "mysql://ser:heslo@localhost/ser") # instead of "uri" </DIV>
<DIV> </DIV>
<DIV>please see errors below... any idea?</DIV>
<DIV> </DIV>
<DIV> 0(0) group module - initializing<BR> 0(0) find_mod_export: found <db_use_table> in module mysql [/usr/local/lib/ser/modules/mysql.so]<BR> 0(0) find_mod_export: found <db_init> in module mysql [/usr/local/lib/ser/modules/mysql.so]<BR> 0(0) find_mod_export: found <db_close> in module mysql [/usr/local/lib/ser/modules/mysql.so]<BR> 0(0) find_mod_export: found <db_query> in module mysql [/usr/local/lib/ser/modules/mysql.so]<BR> 0(0) find_mod_export: found <db_raw_query> in module mysql [/usr/local/lib/ser/modules/mysql.so]<BR> 0(0) find_mod_export: found <db_free_result> in module mysql [/usr/local/lib/ser/modules/mysql.so]<BR> 0(0) find_mod_export: found <db_insert> in module mysql [/usr/local/lib/ser/modules/mysql.so]<BR> 0(0) find_mod_export: found <db_delete> in module mysql [/usr/local/lib/ser/modules/mysql.so]<BR> 0(0) find_mod_export: found <db_update> in module my sql
[/usr/local/lib/ser/modules/mysql.so]<BR> 0(0) get_connection(): Connection not found in the pool<BR>[root@gkproxy01 sip_router]# 0(0) submit_query(): Unknown column 'table_version' in 'field list'<BR> 0(0) submit_query(): Error while submitting query<BR> 0(0) table_version(): Error in db_query<BR> 0(0) release_connection(): Removing connection from the pool<BR> 0(0) group:mod_init(): Error while querying table version<BR> 0(0) init_mod(): Error while initializing module group<BR>ERROR: error while initializing modules<BR> 0(0) DEBUG: tm_shutdown : start<BR> 0(0) DEBUG: unlink_timer_lists : empting DELETE list<BR> 0(0) DEBUG: tm_shutdown : empting hash table<BR> 0(0) DEBUG: tm_shutdown : releasing timers<BR> 0(0) DEBUG: tm_shutdown : removing semaphores<BR> 0(0) DEBUG: tm_shutdown : destroing tmcb lists<BR> 0(0) DEBUG: tm_shutdown : done<BR> 0(4380) shm_mem_destroy<BR> 0(4380) destroying the sha red
memory lock<BR></DIV>
<P><BR>
<HR noShade SIZE=1>
<B>Do You Yahoo!?</B><BR><A href="http://espanol.yahoo.com/mail_tagline/*http://espanol.news.yahoo.com"><IMG height=26 src="http://us.i1.yimg.com/us.yimg.com/i/not/dailynews.gif" width=30 align=left border=0></A> Todo lo que quieres saber de Estados Unidos, América Latina y el resto del Mundo.<BR>Visíta <A href="http://espanol.yahoo.com/mail_tagline/*http://espanol.news.yahoo.com">Yahoo! Noticias</A>.<BR>_______________________________________________<BR>Serusers mailing list<BR>serusers@lists.iptel.org<BR>http://lists.iptel.org/mailman/listinfo/serusers<BR></BLOCKQUOTE><p><br><hr size=1 noshade><b>Do You Yahoo!?</b><br>
<a href=http://espanol.yahoo.com/mail_tagline/*http://espanol.news.yahoo.com><img src="http://us.i1.yimg.com/us.yimg.com/i/not/dailynews.gif" width=30 height=26 border=0 align=left></a>
Todo lo que quieres saber de Estados Unidos, América Latina y el resto del Mundo.<br>
Visíta <a href=http://espanol.yahoo.com/mail_tagline/*http://espanol.news.yahoo.com>Yahoo! Noticias</a>.<br>