<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2800.1106" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>We have downloaded the latest ser software from cvs
in order to support appending of remote party id while using mysql as the ser
database.</FONT></DIV>
<DIV><FONT face=Arial size=2>After compiling and installing the ser software we
included the auth and auth_db parameters and also the append_rpid_hf()
function in our ser.cfg file as shown below.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>SER server starts and registration is
successfull however when forwarding to the pstn gateway, ser will not append the
remote party id header, even if the rpid and uri columns in mysql
database are populated accordingly using the serctl add rpid command. Calls
are also successfull however the gateway will not include the calling party
number in the setup message because the rpid header is missing.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Any ideas please?</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Thanks</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Charles and Andrew</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># ----------- 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=no #
(cmd. line: -r)<BR>rev_dns=no # (cmd. line:
-R)<BR>#port=5060<BR>#children=4<BR>fifo="/tmp/ser_fifo"</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2># ------------------ module loading
----------------------------------</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>loadmodule
"/our_downloads/sip_router/modules/mysql/mysql.so"<BR>#loadmodule
"//lib/ser/modules/mysql.so"</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>loadmodule "//lib/ser/modules/sl.so"<BR>loadmodule
"//lib/ser/modules/tm.so"<BR>loadmodule "//lib/ser/modules/rr.so"<BR>loadmodule
"//lib/ser/modules/maxfwd.so"<BR>loadmodule
"//lib/ser/modules/usrloc.so"<BR>loadmodule
"//lib/ser/modules/registrar.so"<BR>loadmodule
"//lib/ser/modules/textops.so"</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2># Uncomment this if you want digest
authentication<BR># mysql.so must be loaded !<BR>loadmodule
"//lib/ser/modules/auth.so"<BR>loadmodule
"//lib/ser/modules/auth_db.so"</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV><FONT face=Arial size=2>
<DIV><BR>#loadmodule "//lib/ser/modules/acc.so"</DIV>
<DIV> </DIV>
<DIV># ----------------- 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)</DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV># -- auth params --</DIV>
<DIV> </DIV>
<DIV><BR>modparam("auth_db", "use_rpid", 1)<BR>modparam("auth_db",
"rpid_column", "rpid")<BR>modparam("auth", "rpid_prefix",
"<sip:")<BR>modparam("auth", "rpid_suffix",
"@testphone.com>:party=calling;screen=no;privacy=off")</DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV><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> </DIV>
<DIV> </DIV>
<DIV># ------------------------- request routing logic
-------------------</DIV>
<DIV> </DIV>
<DIV># main routing logic</DIV>
<DIV> </DIV>
<DIV>route{<BR> <BR></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> <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> <BR> # 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=~"testphone.com")
{<BR> lookup("aliases");<BR> if (method=="REGISTER")
{</DIV>
<DIV> </DIV>
<DIV>#Uncomment this if you want to use digest
authentication<BR> if (!www_authorize("testphone.com",
"subscriber")) {<BR> www_challenge("testphone.com",
"0");<BR> append_rpid_hf();<BR> break;<BR> };</DIV>
<DIV> </DIV>
<DIV><BR> <BR> save("location");<BR> break;<BR> };</DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV>
if (uri=~"^sip:21") {<BR>
append_rpid_hf();<BR> forward(a
valid ip address for the gateway was inserted
here);<BR>
break;<BR>
}</DIV>
<DIV> </DIV>
<DIV>
if (uri=~"^sip:123")
{<BR>
forward(a valid ip address for the gareway was inserted
here);<BR> break;<BR>
}</DIV>
<DIV> </DIV>
<DIV><BR> # native SIP destinations are handled using our USRLOC
DB<BR> if (!lookup("location"))
{<BR> sl_send_reply("404",
"Not Found");<BR> break;<BR> };<BR> };</DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV><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> <BR> <BR>}</DIV>
<DIV> </DIV>
<DIV></FONT> </DIV></BODY></HTML>