<html><body><div style="color:#000; background-color:#fff; font-family:times new roman, new york, times, serif;font-size:10pt"><div><span>HI <br></span></div><div><br><span></span></div><div><span>I think you should enable a dbaliase lookup as below</span></div><div><br><span></span></div><div> # apply DB based aliases (uncomment to enable)<br> alias_db_lookup("dbaliases"); <-- uncomment this line<br></div><div><br></div><div style="font-family: times new roman,new york,times,serif; font-size: 10pt;"><div style="font-family: times new roman,new york,times,serif; font-size: 12pt;"><font face="Arial" size="2"><hr size="1"><b><span style="font-weight: bold;">From:</span></b> Akib Sayyed <akibsayyed@gmail.com><br><b><span style="font-weight: bold;">To:</span></b> OpenSIPS users mailling list
<users@lists.opensips.org><br><b><span style="font-weight: bold;">Sent:</span></b> Friday, July 15, 2011 8:42 PM<br><b><span style="font-weight: bold;">Subject:</span></b> [OpenSIPS-Users] aliasing in opensips not working<br></font><br><div id="yiv543760560">i am completely new to opensip<br>i am trying to add alias <br clear="all">it shows me when i execute following<br>[root@localhost akib]# opensipsctl alias_db list<br>database engine 'MYSQL' loaded<br>Control engine 'FIFO' loaded<br>
Dumping all aliases may take long: do you want to proceed? [Y<br>y<br>Dumping all aliases...<br><br>+----------------+---------------+----------+----------+<br>| alias_username | alias_domain | username | domain |<br>+----------------+---------------+----------+----------+<br>
| 100000 | | 101 | |<br>| 10000 | <a rel="nofollow" target="_blank" href="http://localhost.com">localhost.com</a> | 101 | <a rel="nofollow" target="_blank" href="http://test.com">test.com</a> |<br>| 111 | <a rel="nofollow" target="_blank" href="http://test.com">test.com</a> | 101 | <a rel="nofollow" target="_blank" href="http://test.com">test.com</a> |<br>
+----------------+---------------+----------+----------+<br><br><br><br>but when i dial 111 it just dosent work it says call not found<br>here is my opensips.cfg<br><br>#<br># $Id: opensips.cfg 7027 2010-07-15 13:48:29Z razvancrainea $<br>
#<br># OpenSIPS basic configuration script<br># by Anca Vamanu <<a rel="nofollow" ymailto="mailto:anca@voice-system.ro" target="_blank" href="mailto:anca@voice-system.ro">anca@voice-system.ro</a>><br>#<br># Please refer to the Core CookBook at:<br># <a rel="nofollow" target="_blank" href="http://www.opensips.org/index.php?n=Resources.DocsCookbooks">http://www.opensips.org/index.php?n=Resources.DocsCookbooks</a><br>
# for a explanation of possible statements, functions and parameters.<br>#<br><br><br>####### Global Parameters #########<br><br>debug=3<br>log_stderror=no<br>log_facility=LOG_LOCAL0<br><br>fork=yes<br>children=4<br><br>/* uncomment the following lines to enable debugging */<br>
#debug=6<br>#fork=no<br>#log_stderror=yes<br><br>/* uncomment the next line to disable TCP (default on) */<br>#disable_tcp=yes<br><br>/* uncomment the next line to enable the auto temporary blacklisting of <br> not available destinations (default disabled) */<br>
#disable_dns_blacklist=no<br><br>/* uncomment the next line to enable IPv6 lookup after IPv4 dns <br> lookup failures (default disabled) */<br>#dns_try_ipv6=yes<br><br>/* uncomment the next line to disable the auto discovery of local aliases<br>
based on revers DNS on IPs (default on) */<br>#auto_aliases=no<br><br>/* uncomment the following lines to enable TLS support (default off) */<br>#disable_tls = no<br>#listen = tls:your_IP:5061<br>#tls_verify_server = 1<br>
#tls_verify_client = 1<br>#tls_require_client_certificate = 0<br>#tls_method = TLSv1<br>#tls_certificate = "/usr/local/etc/opensips/tls/user/user-cert.pem"<br>#tls_private_key = "/usr/local/etc/opensips/tls/user/user-privkey.pem"<br>
#tls_ca_list = "/usr/local/etc/opensips/tls/user/user-calist.pem"<br><br><br>port=5060<br><br>/* uncomment and configure the following line if you want opensips to <br> bind on a specific interface/port/proto (default bind on all available) */<br>
#listen=udp:<a rel="nofollow" target="_blank" href="http://192.168.1.2:5060">192.168.1.2:5060</a><br><br><br>####### Modules Section ########<br><br>#set module path<br>mpath="/usr/local/lib/opensips/modules/"<br><br>/* uncomment next line for MySQL DB support */<br>
loadmodule "db_mysql.so"<br>loadmodule "signaling.so"<br>loadmodule "sl.so"<br>loadmodule "tm.so"<br>loadmodule "rr.so"<br>loadmodule "maxfwd.so"<br>loadmodule "usrloc.so"<br>
loadmodule "registrar.so"<br>loadmodule "textops.so"<br>loadmodule "mi_fifo.so"<br>loadmodule "uri.so"<br>loadmodule "acc.so"<br>loadmodule "dialog.so"<br>loadmodule "mi_xmlrpc.so"<br>
loadmodule "domain.so"<br>loadmodule "auth_db.so"<br>loadmodule "auth.so"<br>loadmodule "alias_db.so"<br>#loadmodule "auth_aaa.so"<br>/* uncomment next lines for MySQL based authentication support <br>
NOTE: a DB (like db_mysql) module must be also loaded */<br>#loadmodule "auth.so"<br>#loadmodule "auth_db.so"<br>/* uncomment next line for aliases support<br> NOTE: a DB (like db_mysql) module must be also loaded */<br>
#loadmodule "alias_db.so"<br>/* uncomment next line for multi-domain support<br> NOTE: a DB (like db_mysql) module must be also loaded<br> NOTE: be sure and enable multi-domain support in all used modules<br>
(see "multi-module params" section ) */<br>#loadmodule "domain.so"<br>/* uncomment the next two lines for presence server support<br> NOTE: a DB (like db_mysql) module must be also loaded */<br>
#loadmodule "presence.so"<br>#loadmodule "presence_xml.so"<br><br><br># ----------------- setting module-specific parameters ---------------<br><br>#=======================Dialog===================<br>
modparam("dialog", "enable_stats", 1)<br>modparam("dialog", "timeout_avp", "$avp(10)")<br>modparam("dialog", "default_timeout", 10111111)<br>modparam("dialog", "db_url", "mysql://opensips:opensipsrw@localhost/opensips")<br>
modparam("dialog", "db_mode", 1)<br>modparam("dialog", "table_name", "dialog")<br><br># ----- mi_fifo params -----<br>modparam("mi_fifo", "fifo_name", "/tmp/opensips_fifo")<br>
<br><br># ----- rr params -----<br># add value to ;lr param to cope with most of the UAs<br>modparam("rr", "enable_full_lr", 1)<br># do not append from tag to the RR (no need for this script)<br>modparam("rr", "append_fromtag", 0)<br>
<br><br># ----- registrar params -----<br>/* uncomment the next line not to allow more than 10 contacts per AOR */<br>#modparam("registrar", "max_contacts", 10)<br><br><br># ----- usrloc params -----<br>
modparam("usrloc", "db_mode", 0)<br>/* uncomment the following lines if you want to enable DB persistency<br> for location entries */<br>#modparam("usrloc", "db_mode", 2)<br>#modparam("usrloc", "db_url",<br>
# "mysql://opensips:opensipsrw@localhost/opensips")<br><br><br># ----- uri params -----<br>modparam("uri", "use_uri_table", 0)<br><br><br># ----- acc params -----<br>/* what sepcial events should be accounted ? */<br>
modparam("acc", "early_media", 1)<br>modparam("acc", "report_ack", 1)<br>modparam("acc", "report_cancels", 1)<br>/* by default ww do not adjust the direct of the sequential requests.<br>
if you enable this parameter, be sure the enable "append_fromtag"<br> in "rr" module */<br>modparam("acc", "detect_direction", 0)<br>/* account triggers (flags) */<br>modparam("acc", "failed_transaction_flag", 3)<br>
modparam("acc", "log_flag", 1)<br>modparam("acc", "log_missed_flag", 2)<br>/* uncomment the following lines to enable DB accounting also */<br>modparam("acc", "db_flag", 1)<br>
modparam("acc", "db_missed_flag", 2)<br><br><br># ----- auth_db params -----<br>/* uncomment the following lines if you want to enable the DB based<br> authentication */<br>modparam("auth_db", "calculate_ha1", yes)<br>
modparam("auth_db", "password_column", "password")<br>modparam("auth_db", "db_url","mysql://opensips:opensipsrw@localhost/opensips")<br>modparam("auth_db", "load_credentials", "")<br>
<br><br># ----- alias_db params -----<br>/* uncomment the following lines if you want to enable the DB based<br> aliases */<br>modparam("alias_db", "db_url","mysql://opensips:opensipsrw@localhost/opensips")<br>
<br><br># ----- domain params -----<br>/* uncomment the following lines to enable multi-domain detection<br> support */<br>modparam("domain", "db_url","mysql://opensips:opensipsrw@localhost/opensips")<br>
modparam("domain", "db_mode", 1) # Use caching<br><br><br># ----- multi-module params -----<br>/* uncomment the following line if you want to enable multi-domain support<br> in the modules (dafault off) */<br>
#modparam("auth_db|usrloc|uri", "use_domain", 1)<br><br><br># ----- presence params -----<br>/* uncomment the following lines if you want to enable presence */<br>#modparam("presence|presence_xml", "db_url",<br>
# "mysql://opensips:opensipsrw@localhost/opensips")<br>#modparam("presence_xml", "force_active", 1)<br>#modparam("presence", "server_address", "sip:<a rel="nofollow" target="_blank" href="http://192.168.1.2:5060">192.168.1.2:5060</a>")<br>
<br># ================ Xmlrpc params========================<br>modparam("mi_xmlrpc", "port", 8000)<br>####### Routing Logic ########<br><br><br># main request routing logic<br><br>route{<br> setflag(4);<br>
create_dialog();<br> if (!mf_process_maxfwd_header("10")) {<br> sl_send_reply("483","Too Many Hops");<br> exit;<br> }<br><br> if (has_totag()) {<br> # sequential request withing a dialog should<br>
# take the path determined by record-routing<br> if (loose_route()) {<br> if (is_method("BYE")) {<br> setflag(1); # do accounting ...<br> setflag(3); # ... even if the transaction fails<br>
} else if (is_method("INVITE")) {<br> # even if in most of the cases is useless, do RR for<br> # re-INVITEs alos, as some buggy clients do change route set<br> # during the dialog.<br>
record_route();<br> }<br> # route it out to whatever destination was set by loose_route()<br> # in $du (destination URI).<br> route(1);<br> } else {<br> /* uncomment the following lines if you want to enable presence */<br>
##if (is_method("SUBSCRIBE") && $rd == "your.server.ip.address") {<br> ## # in-dialog subscribe requests<br> ## route(2);<br> ## exit;<br> ##}<br>
if ( is_method("ACK") ) {<br> if ( t_check_trans() ) {<br> # non loose-route, but stateful ACK; must be an ACK after <br> # a 487 or e.g. 404 from upstream server<br>
t_relay();<br> exit;<br> } else {<br> # ACK without matching transaction -><br> # ignore and discard<br> exit;<br>
}<br> }<br> sl_send_reply("404","Not here");<br> }<br> exit;<br> }<br><br> #initial requests<br><br> # CANCEL processing<br> if (is_method("CANCEL"))<br>
{<br> if (t_check_trans())<br> t_relay();<br> exit;<br> }<br><br> t_check_trans();<br><br> # authenticate if from local subscriber (uncomment to enable auth)<br> # authenticate all initial non-REGISTER request that pretend to be<br>
# generated by local subscriber (domain from FROM URI is local)<br> ##if (!(method=="REGISTER") && from_uri==myself) /*no multidomain version*/<br> if (!(method=="REGISTER") && is_from_local()) /*multidomain version*/<br>
{<br> if (!proxy_authorize("", "subscriber")) {<br> proxy_challenge("", "0");<br> exit;<br> }<br> if (!db_check_from()) {<br> sl_send_reply("403","Forbidden auth ID");<br>
exit;<br> }<br> <br> consume_credentials();<br> # caller authenticated<br> }<br><br> # preloaded route checking<br> if (loose_route()) {<br> xlog("L_ERR",<br> "Attempt to route with preloaded Route's [$fu/$tu/$ru/$ci]");<br>
if (!is_method("ACK"))<br> sl_send_reply("403","Preload Route denied");<br> exit;<br> }<br><br> # record routing<br> if (!is_method("REGISTER|MESSAGE"))<br>
record_route();<br><br> # account only INVITEs<br> if (is_method("INVITE")) {<br> setflag(1); # do accounting<br> }<br> if (!uri==myself)<br> ## replace with following line if multi-domain support is used<br>
##if (!is_uri_host_local())<br> {<br> append_hf("P-hint: outbound\r\n"); <br> # if you have some interdomain connections via TLS<br> ##if($rd=="<a rel="nofollow" target="_blank" href="http://tls_domain1.net">tls_domain1.net</a>") {<br>
## t_relay("tls:<a rel="nofollow" target="_blank" href="http://domain1.net">domain1.net</a>");<br> ## exit;<br> ##} else if($rd=="<a rel="nofollow" target="_blank" href="http://tls_domain2.net">tls_domain2.net</a>") {<br> ## t_relay("tls:<a rel="nofollow" target="_blank" href="http://domain2.net">domain2.net</a>");<br>
## exit;<br> ##}<br> route(1);<br> }<br><br> # requests for my domain<br><br> ## uncomment this if you want to enable presence server <br> ## and comment the next 'if' block<br>
## NOTE: uncomment also the definition of route[2] from below<br> ##if( is_method("PUBLISH|SUBSCRIBE"))<br> ## route(2);<br><br> if (is_method("PUBLISH"))<br> {<br> sl_send_reply("503", "Service Unavailable");<br>
exit;<br> }<br> <br><br> if (is_method("REGISTER"))<br> {<br> # authenticate the REGISTER requests (uncomment to enable auth)<br> if (!www_authorize("", "subscriber"))<br>
{<br> www_challenge("", "0");<br> exit;<br> }<br> <br> if (!db_check_to()) <br> {<br> sl_send_reply("403","Forbidden auth ID");<br>
exit;<br> }<br><br> if (!save("location"))<br> sl_reply_error();<br><br> exit;<br> }<br><br> if ($rU==NULL) {<br> # request with no Username in RURI<br> sl_send_reply("484","Address Incomplete");<br>
exit;<br> }<br><br> # apply DB based aliases (uncomment to enable)<br> ##alias_db_lookup("dbaliases");<br><br> # do lookup with method filtering<br> if (!lookup("location","m")) {<br>
switch ($retcode) {<br> case -1:<br> case -3:<br> t_newtran();<br> t_reply("404", "Not Found");<br> exit;<br> case -2:<br>
sl_send_reply("405", "Method Not Allowed");<br> exit;<br> }<br> }<br><br> # when routing via usrloc, log the missed calls also<br> setflag(2);<br><br> route(1);<br>
}<br><br><br>route[1] {<br> # for INVITEs enable some additional helper routes<br> if (is_method("INVITE")) {<br> t_on_branch("2");<br> t_on_reply("2");<br> t_on_failure("1");<br>
}<br><br> if (!t_relay()) {<br> sl_reply_error();<br> };<br> exit;<br>}<br><br><br># Presence route<br>/* uncomment the whole following route for enabling presence<br> NOTE: do not forget to enable the call of this route from the main<br>
route */<br>##route[2]<br>##{<br>## if (!t_newtran())<br>## {<br>## sl_reply_error();<br>## exit;<br>## };<br>##<br>## if(is_method("PUBLISH"))<br>## {<br>## handle_publish();<br>
## }<br>## else<br>## if( is_method("SUBSCRIBE"))<br>## {<br>## handle_subscribe();<br>## }<br>##<br>## exit;<br>##}<br><br><br>branch_route[2] {<br> xlog("new branch at $ru\n");<br>
}<br><br><br>onreply_route[2] {<br> xlog("incoming reply\n");<br>}<br><br><br>failure_route[1] {<br> if (t_was_cancelled()) {<br> exit;<br> }<br><br> # uncomment the following lines if you want to block client <br>
# redirect based on 3xx replies.<br> ##if (t_check_status("3[0-9][0-9]")) {<br> ##t_reply("404","Not found");<br> ## exit;<br> ##}<br><br> # uncomment the following lines if you want to redirect the failed <br>
# calls to a different new destination<br> ##if (t_check_status("486|408")) {<br> ## sethostport("<a rel="nofollow" target="_blank" href="http://192.168.2.100:5060">192.168.2.100:5060</a>");<br> ## # do not set the missed call flag again<br>
## t_relay();<br> ##}<br>}<br><br><br>-- <br>Akib Sayyed<br>Matrix-Shell<br><a rel="nofollow" ymailto="mailto:akibsayyed@gmail.com" target="_blank" href="mailto:akibsayyed@gmail.com">akibsayyed@gmail.com</a><br><a rel="nofollow" ymailto="mailto:akibsayyed@matrixshell.com" target="_blank" href="mailto:akibsayyed@matrixshell.com">akibsayyed@matrixshell.com</a><br>
Mob:- +91-966-514-2243<br><br><br>
</div><br>_______________________________________________<br>Users mailing list<br><a ymailto="mailto:Users@lists.opensips.org" href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a><br><a href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users" target="_blank">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a><br><br><br></div></div></div></body></html>