[prev in list] [next in list] [prev in thread] [next in thread]
List: sems
Subject: [Sems] need help
From: gaillacharry () yahoo ! fr (gaillac harry)
Date: 2004-04-02 15:12:54
Message-ID: 1080911937.1439.11.camel () serveur1 ! example ! com
[Download RAW message or body]
Hello,
I would prefer to use mysql DB instead of DBtext for sems isdngw plugin.
Telephones numbers have to register to dbtext. How may I use mysql table
location with usrloc module (if possible ??).
which modparams ?
Anybody could look at my ser.cfg
Regards
Harry
-------------- next part --------------
#
# $Id: ser.cfg,v 1.21.4.1 2003/11/10 15:35:15 andrei Exp $
#
# simple quick-start config script
#
# ----------- 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=7
fork=no
log_stderror=yes
*/
check_via=no # (cmd. line: -v)
dns=no # (cmd. line: -r)
rev_dns=no # (cmd. line: -R)
port=5060
children=2
fifo="/tmp/ser_fifo"
fifo_mode=0666
listen=192.168.0.1
# ------------------ module loading ----------------------------------
# Uncomment this if you want to use SQL database
loadmodule "/usr/lib/ser/modules/mysql.so"
loadmodule "/usr/lib/ser/modules/sl.so"
loadmodule "/usr/lib/ser/modules/tm.so"
loadmodule "/usr/lib/ser/modules/rr.so"
loadmodule "/usr/lib/ser/modules/maxfwd.so"
loadmodule "/usr/lib/ser/modules/usrloc.so"
loadmodule "/usr/lib/ser/modules/registrar.so"
loadmodule "/usr/lib/ser/modules/vm.so"
# Uncomment this if you want digest authentication
# mysql.so must be loaded !
loadmodule "/usr/lib/ser/modules/auth.so"
loadmodule "/usr/lib/ser/modules/auth_db.so"
# ----------------- setting module-specific parameters ---------------
# -- usrloc params --
#modparam("usrloc", "db_mode", 0)
# Uncomment this if you want to use SQL database
# for persistent storage and comment the previous line
modparam("usrloc", "db_mode", 2)
modparam("usrloc", "db_url", "mysql://ser:heslo@localhost/ser")
# -- auth params --
# Uncomment if you are using auth module
#
modparam("auth_db", "calculate_ha1", yes)
#
# If you set "calculate_ha1" parameter to yes (which true in this config),
# uncomment also the following parameter)
#
modparam("auth_db", "password_column", "password")
# -- rr params --
# add value to ;lr param to make some broken UAs happy
modparam("rr", "enable_full_lr", 1)
# --vm params--
modparam("voicemail","db_url", "mysql://ser:heslo@localhost/ser")
modparam("voicemail", "email_column", "email")
modparam("voicemail", "subscriber_table", "subscriber")
modparam("voicemail", "user_column", "username")
# ------------------------- request routing logic -------------------
# main 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;
};
# if the request is for other domain use UsrLoc
# (in case, it does not work, use the following command
# with proper names and addresses in it)
if (uri==myself) {
if (method=="REGISTER") {
# Uncomment this if you want to use digest authentication
if (!www_authorize("example.com", "subscriber")) {
www_challenge("example.com", "0");
break;
};
save("location");
break;
};
lookup("aliases");
# native SIP destinations are handled using our USRLOC DB
if (!lookup("location")) {
sl_send_reply("404", "Not Found");
break;
};
};
#forward to route [1]
if(uri=~"sip:[0-9]+@.*") {
route(1);
break;
};
#forward to current uri now; use stateful forwarding; that
#works reliably even if we forward from TCP to UDP
if (!t_relay()) {
sl_reply_error();
};
}
# end of main route
route [1] {
if(t_newtran()){
if(method=="INVITE" || method=="BYE" || method=="CANCEL" || method=="REFER"){
# send a response right at the start to avoid retransmissions
t_reply("100","Trying -- just wait a minute !");
# confrence only gets activated on invite requests
if(method=="INVITE"){
if(uri=~"sip:1000@.*"){
if(!vm("/tmp/am_fifo","conference")){
log("could not contact conference\n");
t_reply("500","could not contact conference");
};
} else {
t_reply("404","Not Found");
# stop routing here, the message is now processed by the media server
break;
};
if(method=="INVITE"){
if(uri=~"sip:2000@.*"){
if(!vm("/tmp/am_fifo","ivr")){
log("could not contact ivr\n");
t_reply("500","could not contact ivr");
};
# we dont feel responsible for sip addresses not starting with
# a number, so send the right error code.
} else {
t_reply("404","Not Found");
};
# stop routing here, the message is now processed by the media server
break;
};
if(method=="INVITE"){
if(uri=~"sip:18@.*"){
if(!vm("/tmp/am_fifo","isdngw")){
log("could not contact \
isdngw\n");
t_reply("500","could not \
contact isdngw"); };
# we dont feel responsible for sip addresses \
not starting with
# a number, so send the right error code.
} else {
t_reply("404","Not Found");
};
# stop routing here, the message is now \
processed by the media server break;
};
# The following handles the call termination, we must pass these requests
# to the media server as follows. Again make shure the fifo name and permissions
# are set correctly (like im sems.conf).
if((method=="BYE")||(method=="CANCEL")){
if(!vm("/tmp/am_fifo","bye")){
log("could not contact the media server\n");
t_reply("500","could not contact the media server");
};
break;
};
# other methods than INVITE, BYE and CANCEL are not handled by this SIP Server
# so we sent an error message
} else {
log("ERROR: method not supported\n");
t_reply("500", "sorry, method not supported");
};
} else {
# for any reason the transaction could not be created, send error code
log("could not create new transaction\n");
sl_send_reply("500","could not create new transaction");
};
}
}
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic