[Serusers] mysql problem when runnnig cvs head version - SOLVED!!
Rafael J. Risco G.V
rafael_rgv at yahoo.com
Tue Aug 24 19:57:26 CEST 2004
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 at 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 at 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 at 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 at 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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sip-router.org/pipermail/sr-users/attachments/20040824/3122e2b2/attachment.htm>
More information about the sr-users
mailing list