[Serusers] SER + SERNAT + MySQL
Truong Chi Thanh
tchithanh2003 at yahoo.com
Fri Jul 29 03:17:07 CEST 2005
Hi all,
My name is chithanh. I'm working at Vietnam. Now I'm using with SER.
I have a case with SER.
| ser database |
|
|
============================
|| ||
| SER (5060) | | SERNAT + nathelper + rtpproxy (5082) |
|| ||
| user1 | | user2 |
Explain :
user1 registered SER ===> SER save("location") for user1 into table "location" of "ser" database.
user2 registered SERNAT ===> SER save("location") for user2 into table "location" of "ser" database.
My purpose :
user1 can call for user2.
user can call for user1.
Real when I run with this case. User1 can't call for User2. (although i had setted db_mode=1 for both) because :
+ User1 INVITE User2 ==> SER lookup("location") into SER's memory. Not lookup in ser database.
+ Use2 INVITE User1 ==> SERNAT lookup("location") into SERNAT's memory. Not lookup in ser database.
I want SER and SENAT when lookup("location"), they must lookup in table "location" of ser database.
How do u to solve for this problem ? Please help me.
===================================
My config of SERNAT :
#
# $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=yes # (cmd. line: -r)
rev_dns=no # (cmd. line: -R)
port=5082
listen=abc.com
alias=abc.com
children=4
fifo="/tmp/ser_fifo"
# ------------------ module loading ----------------------------------
# Uncomment this if you want to use SQL database
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/mysql.so"
loadmodule "/usr/local//lib/ser/modules/nathelper.so"
# Uncomment this if you want digest authentication
# mysql.so must be loaded !
loadmodule "/usr/local//lib/ser/modules/auth.so"
loadmodule "/usr/local//lib/ser/modules/auth_db.so"
#loadmodule "/usr/local//lib/ser/modules/auth_radius.so"
loadmodule "/usr/local//lib/ser/modules/acc.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", 1)
modparam("usrloc", "db_url", "sql://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)
# Accounting
modparam("acc", "log_level", 2)
#modparam("acc", "log_flag", 3)
#modparam("acc", "log_missed_flag", 3)
modparam("acc", "db_flag", 3)
modparam("acc", "db_missed_flag", 3)
# ------------------------- 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("chinhnam.com","subscriber")) {
www_challenge("chinhnam.com", "0");
break;
};
fix_nated_contact();
save("location");
break;
}; #End if(method=="REGISTER")
if (method=="INVITE") {
if (proxy_authorize("chinhnam.com","subscriber")) {
if (!lookup("location")) {
sl_send_reply("404", "Not Found");
break;
};
}else {
proxy_challenge("chinhnam.com", "0");
break;
}; #End if (proxy_authorize("chinhnam.com", "subcriber"))
}; #End if(method=="INVITE")
fix_nated_contact();
force_rtp_proxy();
t_on_reply("1");
#setflag(3);
}; #End if(uri=="myself")
# 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 main routing logic
onreply_route[1] {
fix_nated_contact();
if (status=~"[12][0-9][0-9]") {
force_rtp_proxy();
}
}
============================================================================
My config of SER :
#
# $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=yes # (cmd. line: -r)
rev_dns=no # (cmd. line: -R)
port=5060
listen=chinhnam.com
alias=chinhnam.com
children=4
fifo="/tmp/ser_fifo"
# ------------------ module loading ----------------------------------
# Uncomment this if you want to use SQL database
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/mysql.so"
# Uncomment this if you want digest authentication
# mysql.so must be loaded !
loadmodule "/usr/local//lib/ser/modules/auth.so"
loadmodule "/usr/local//lib/ser/modules/auth_db.so"
#loadmodule "/usr/local//lib/ser/modules/auth_radius.so"
loadmodule "/usr/local//lib/ser/modules/acc.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", 1)
modparam("usrloc", "db_url", "sql://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)
# Accounting
modparam("acc", "log_level", 2)
#modparam("acc", "log_flag", 3)
#modparam("acc", "log_missed_flag", 3)
modparam("acc", "db_flag", 3)
modparam("acc", "db_missed_flag", 3)
# ------------------------- 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("chinhnam.com","subscriber")) {
www_challenge("chinhnam.com", "0");
break;
};
save("location");
break;
}; #End if(method=="REGISTER")
if (method=="INVITE") {
if (proxy_authorize("chinhnam.com","subscriber")) {
if(uri=~"sip:63[0-9]*@") {
rewritehostport("192.168.200.248:5060");
}else if (!lookup("location")) {
sl_send_reply("404", "Not Found");
break;
};
}else {
proxy_challenge("chinhnam.com", "0");
break;
}; #End if (proxy_authorize("chinhnam.com", "subcriber"))
}; #End if(method=="INVITE")
#setflag(3);
}; #End if(uri=="myself")
# 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 main routing logic
=============================================================================
Note:
SER (5060) only signaling SIP for my user. Not use media proxy.
SER (5082) : signaling SIP + RTP path for my user. Use nathelper + rtpproxy
Thanks very much everything you had done for me.
Truong Chi Thanh
---------------------------------
Start your day with Yahoo! - make it your home page
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sip-router.org/pipermail/sr-users/attachments/20050728/2c39a9d4/attachment.htm>
More information about the sr-users
mailing list