<DIV>
<DIV><FONT face=Arial size=2>Hi all,</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>My name is chithanh. I'm working at Vietnam. Now I'm using with SER.</FONT></DIV>
<DIV><FONT face=Arial size=2>I have a case with SER.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2> | ser database |</FONT></DIV>
<DIV><FONT face=Arial size=2> |</FONT></DIV>
<DIV><FONT face=Arial size=2> |</FONT></DIV>
<DIV><FONT face=Arial size=2> ============================</FONT></DIV>
<DIV><FONT face=Arial size=2> || ||</FONT></DIV>
<DIV><FONT face=Arial size=2>| SER (5060) | | SERNAT + nathelper + rtpproxy (5082) |</FONT></DIV>
<DIV><FONT face=Arial size=2> || ||</FONT></DIV>
<DIV><FONT face=Arial size=2>| user1 | | user2 |</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Explain :</FONT></DIV>
<DIV><FONT face=Arial size=2> user1 registered SER ===> SER save("location") for user1 into table "location" of "ser" database.</FONT></DIV>
<DIV><FONT face=Arial size=2> user2 registered SERNAT ===> SER save("location") for user2 into table "location" of "ser" database.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>My purpose : </FONT></DIV>
<DIV><FONT face=Arial size=2> user1 can call for user2. </FONT></DIV>
<DIV><FONT face=Arial size=2> user can call for user1.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Real when I run with this case. User1 can't call for User2. (although i had setted db_mode=1 for both) because :</FONT></DIV>
<DIV><FONT face=Arial size=2> + User1 INVITE User2 ==> SER lookup("location") into SER's memory. Not lookup in ser database. </FONT></DIV>
<DIV><FONT face=Arial size=2> + Use2 INVITE User1 ==> SERNAT lookup("location") into SERNAT's memory. Not lookup in ser database.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>I want SER and SENAT when lookup("location"), they must lookup in table "location" of ser database. </FONT></DIV>
<DIV><FONT face=Arial size=2>How do u to solve for this problem ? </FONT><FONT face=Arial size=2> </FONT><FONT face=Arial size=2>Please help me.</FONT></DIV>
<DIV><FONT face=Arial size=2>===================================</FONT></DIV>
<DIV><FONT face=Arial size=2>My config of SERNAT :</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT><FONT face=Arial size=2>#<BR># $Id: ser.cfg,v 1.21.4.1 2003/11/10 15:35:15 andrei Exp $<BR>#<BR># simple quick-start config script<BR>#</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2># ----------- global configuration parameters ------------------------</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>debug=3 # debug level (cmd line: -dddddddddd)<BR>fork=yes<BR>log_stderror=no # (cmd line: -E)</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>/* Uncomment these lines to enter debugging mode<BR>debug=7<BR>fork=no<BR>log_stderror=yes<BR>*/</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>check_via=no # (cmd. line: -v)<BR>dns=yes # (cmd. line: -r)<BR>rev_dns=no # (cmd. line: -R)<BR>port=5082<BR>listen=abc.com<BR>alias=abc.com<BR>children=4<BR>fifo="/tmp/ser_fifo"<BR># ------------------ module loading ----------------------------------</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2># Uncomment this if you want to use SQL database<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/mysql.so"<BR>loadmodule "/usr/local//lib/ser/modules/nathelper.so"</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV><FONT face=Arial size=2>
<DIV><BR># Uncomment this if you want digest authentication<BR># mysql.so must be loaded !<BR>loadmodule "/usr/local//lib/ser/modules/auth.so"<BR>loadmodule "/usr/local//lib/ser/modules/auth_db.so"<BR>#loadmodule "/usr/local//lib/ser/modules/auth_radius.so"<BR>loadmodule "/usr/local//lib/ser/modules/acc.so"</DIV>
<DIV> </DIV>
<DIV><BR># ----------------- setting module-specific parameters ---------------</DIV>
<DIV> </DIV>
<DIV># -- usrloc params --</DIV>
<DIV> </DIV>
<DIV>#modparam("usrloc", "db_mode", 0)</DIV>
<DIV> </DIV>
<DIV># Uncomment this if you want to use SQL database<BR># for persistent storage and comment the previous line<BR>modparam("usrloc", "db_mode", 1)<BR>modparam("usrloc", "db_url", "sql://ser:heslo@localhost/ser")</DIV>
<DIV> </DIV>
<DIV># -- auth params --<BR># Uncomment if you are using auth module<BR>#<BR>modparam("auth_db", "calculate_ha1", yes)<BR>#<BR># If you set "calculate_ha1" parameter to yes (which true in this config),<BR># uncomment also the following parameter)<BR>#<BR>modparam("auth_db", "password_column", "password")</DIV>
<DIV> </DIV>
<DIV># -- rr params --<BR># add value to ;lr param to make some broken UAs happy<BR>modparam("rr", "enable_full_lr", 1)</DIV>
<DIV> </DIV>
<DIV># Accounting<BR>modparam("acc", "log_level", 2)<BR>#modparam("acc", "log_flag", 3)<BR>#modparam("acc", "log_missed_flag", 3)<BR>modparam("acc", "db_flag", 3)<BR>modparam("acc", "db_missed_flag", 3)</DIV>
<DIV> </DIV>
<DIV># ------------------------- request routing logic -------------------</DIV>
<DIV> </DIV>
<DIV># main routing logic</DIV>
<DIV> </DIV>
<DIV>route{</DIV>
<DIV> </DIV>
<DIV> # 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> </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> </DIV>
<DIV> # if the request is for other domain use UsrLoc<BR> # (in case, it does not work, use the following command<BR> # with proper names and addresses in it)<BR> if (uri==myself) {<BR> if (method=="REGISTER") {<BR> # Uncomment this if you want to use digest authentication<BR> if (!www_authorize("chinhnam.com","subscriber"))
{<BR> www_challenge("chinhnam.com", "0");<BR> break;<BR> };<BR> fix_nated_contact();<BR>
save("location");<BR> break;<BR> }; #End if(method=="REGISTER")</DIV>
<DIV> </DIV>
<DIV> if (method=="INVITE") {<BR> if (proxy_authorize("chinhnam.com","subscriber")) {<BR> if (!lookup("location")) {<BR> sl_send_reply("404", "Not Found");<BR>
break;<BR> };<BR> }else {<BR> proxy_challenge("chinhnam.com", "0");<BR> break;<BR> }; #End if
(proxy_authorize("chinhnam.com", "subcriber"))<BR> }; #End if(method=="INVITE")</DIV>
<DIV> </DIV>
<DIV> fix_nated_contact();<BR> force_rtp_proxy();<BR> t_on_reply("1");<BR> #setflag(3);<BR> }; #End if(uri=="myself")<BR> # forward to current uri now; use stateful forwarding; that<BR> # works reliably even if we forward from TCP to UDP<BR> if (!t_relay()) {<BR> sl_reply_error();<BR> };<BR>} #End main routing logic</DIV>
<DIV> </DIV>
<DIV>onreply_route[1] {<BR> fix_nated_contact();<BR> if (status=~"[12][0-9][0-9]") {<BR> force_rtp_proxy();<BR> }<BR>}<BR>============================================================================</DIV>
<DIV>My config of SER :</DIV>
<DIV>#<BR># $Id: ser.cfg,v 1.21.4.1 2003/11/10 15:35:15 andrei Exp $<BR>#<BR># simple quick-start config script<BR>#</DIV>
<DIV> </DIV>
<DIV># ----------- global configuration parameters ------------------------</DIV>
<DIV> </DIV>
<DIV>debug=3 # debug level (cmd line: -dddddddddd)<BR>fork=yes<BR>log_stderror=no # (cmd line: -E)</DIV>
<DIV> </DIV>
<DIV>/* Uncomment these lines to enter debugging mode<BR>debug=7<BR>fork=no<BR>log_stderror=yes<BR>*/</DIV>
<DIV> </DIV>
<DIV>check_via=no # (cmd. line: -v)<BR>dns=yes # (cmd. line: -r)<BR>rev_dns=no # (cmd. line: -R)<BR>port=5060<BR>listen=chinhnam.com<BR>alias=chinhnam.com<BR>children=4<BR>fifo="/tmp/ser_fifo"<BR># ------------------ module loading ----------------------------------</DIV>
<DIV> </DIV>
<DIV># Uncomment this if you want to use SQL database<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/mysql.so"</DIV>
<DIV> </DIV>
<DIV># Uncomment this if you want digest authentication<BR># mysql.so must be loaded !<BR>loadmodule "/usr/local//lib/ser/modules/auth.so"<BR>loadmodule "/usr/local//lib/ser/modules/auth_db.so"<BR>#loadmodule "/usr/local//lib/ser/modules/auth_radius.so"<BR>loadmodule "/usr/local//lib/ser/modules/acc.so"</DIV>
<DIV> </DIV>
<DIV><BR># ----------------- setting module-specific parameters ---------------</DIV>
<DIV> </DIV>
<DIV># -- usrloc params --</DIV>
<DIV> </DIV>
<DIV>#modparam("usrloc", "db_mode", 0)</DIV>
<DIV> </DIV>
<DIV># Uncomment this if you want to use SQL database<BR># for persistent storage and comment the previous line<BR>modparam("usrloc", "db_mode", 1)<BR>modparam("usrloc", "db_url", "sql://ser:heslo@localhost/ser")<BR># -- auth params --<BR># Uncomment if you are using auth module<BR>#<BR>modparam("auth_db", "calculate_ha1", yes)<BR>#<BR># If you set "calculate_ha1" parameter to yes (which true in this config),<BR># uncomment also the following parameter)<BR>#<BR>modparam("auth_db", "password_column", "password")</DIV>
<DIV> </DIV>
<DIV># -- rr params --<BR># add value to ;lr param to make some broken UAs happy<BR>modparam("rr", "enable_full_lr", 1)</DIV>
<DIV> </DIV>
<DIV># Accounting<BR>modparam("acc", "log_level", 2)<BR>#modparam("acc", "log_flag", 3)<BR>#modparam("acc", "log_missed_flag", 3)<BR>modparam("acc", "db_flag", 3)<BR>modparam("acc", "db_missed_flag", 3)</DIV>
<DIV> </DIV>
<DIV># ------------------------- request routing logic -------------------</DIV>
<DIV> </DIV>
<DIV># main routing logic</DIV>
<DIV> </DIV>
<DIV>route{</DIV>
<DIV> </DIV>
<DIV> # 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> </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> </DIV>
<DIV> # if the request is for other domain use UsrLoc<BR> # (in case, it does not work, use the following command<BR> # with proper names and addresses in it)<BR> if (uri==myself) {<BR> if (method=="REGISTER") {<BR> # Uncomment this if you want to use digest authentication<BR> if (!www_authorize("chinhnam.com","subscriber"))
{<BR> www_challenge("chinhnam.com", "0");<BR> break;<BR> };<BR> save("location");<BR> break;<BR> }; #End
if(method=="REGISTER")</DIV>
<DIV> </DIV>
<DIV> if (method=="INVITE") {<BR> if (proxy_authorize("chinhnam.com","subscriber")) {<BR> if(uri=~"sip:63[0-9]*@") {<BR> rewritehostport("192.168.200.248:5060");<BR> }else if (!lookup("location"))
{<BR> sl_send_reply("404", "Not Found");<BR> break;<BR> };<BR> }else
{<BR> proxy_challenge("chinhnam.com", "0");<BR> break;<BR> }; #End if (proxy_authorize("chinhnam.com", "subcriber"))<BR> }; #End if(method=="INVITE")</DIV>
<DIV> </DIV>
<DIV> #setflag(3);</DIV>
<DIV> </DIV>
<DIV> }; #End if(uri=="myself")<BR> # forward to current uri now; use stateful forwarding; that<BR> # works reliably even if we forward from TCP to UDP<BR> if (!t_relay()) {<BR> sl_reply_error();<BR> };<BR>} #End main routing logic</DIV>
<DIV>=============================================================================</DIV>
<DIV></FONT> </DIV>
<DIV><FONT face=Arial size=2>Note:</FONT></DIV>
<DIV><FONT face=Arial size=2> SER (5060) only signaling SIP for my user. Not use media proxy.</FONT></DIV>
<DIV><FONT face=Arial size=2> SER (5082) : signaling SIP + RTP path for my user. Use nathelper + rtpproxy</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV>Thanks very much <FONT face=Arial size=2>everything you had done for me.</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2>Truong Chi Thanh</FONT></DIV></DIV><p>
                <hr size=1> <a href="http://us.rd.yahoo.com/evt=34442/*http://www.yahoo.com/r/hs">Start your day with Yahoo! - make it your home page </a>