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 &#39;MYSQL&#39; loaded<br>Control engine &#39;FIFO&#39; 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 href="http://localhost.com">localhost.com</a> | 101      | <a href="http://test.com">test.com</a> |<br>| 111            | <a href="http://test.com">test.com</a>      | 101      | <a 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 &lt;<a href="mailto:anca@voice-system.ro">anca@voice-system.ro</a>&gt;<br>#<br># Please refer to the Core CookBook at:<br>#      <a 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 = &quot;/usr/local/etc/opensips/tls/user/user-cert.pem&quot;<br>#tls_private_key = &quot;/usr/local/etc/opensips/tls/user/user-privkey.pem&quot;<br>
#tls_ca_list = &quot;/usr/local/etc/opensips/tls/user/user-calist.pem&quot;<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 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=&quot;/usr/local/lib/opensips/modules/&quot;<br><br>/* uncomment next line for MySQL DB support */<br>
loadmodule &quot;db_mysql.so&quot;<br>loadmodule &quot;signaling.so&quot;<br>loadmodule &quot;sl.so&quot;<br>loadmodule &quot;tm.so&quot;<br>loadmodule &quot;rr.so&quot;<br>loadmodule &quot;maxfwd.so&quot;<br>loadmodule &quot;usrloc.so&quot;<br>
loadmodule &quot;registrar.so&quot;<br>loadmodule &quot;textops.so&quot;<br>loadmodule &quot;mi_fifo.so&quot;<br>loadmodule &quot;uri.so&quot;<br>loadmodule &quot;acc.so&quot;<br>loadmodule &quot;dialog.so&quot;<br>loadmodule &quot;mi_xmlrpc.so&quot;<br>
loadmodule &quot;domain.so&quot;<br>loadmodule &quot;auth_db.so&quot;<br>loadmodule &quot;auth.so&quot;<br>loadmodule &quot;alias_db.so&quot;<br>#loadmodule &quot;auth_aaa.so&quot;<br>/* uncomment next lines for MySQL based authentication support <br>
   NOTE: a DB (like db_mysql) module must be also loaded */<br>#loadmodule &quot;auth.so&quot;<br>#loadmodule &quot;auth_db.so&quot;<br>/* uncomment next line for aliases support<br>   NOTE: a DB (like db_mysql) module must be also loaded */<br>
#loadmodule &quot;alias_db.so&quot;<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 &quot;multi-module params&quot; section ) */<br>#loadmodule &quot;domain.so&quot;<br>/* uncomment the next two lines for presence server support<br>   NOTE: a DB (like db_mysql) module must be also loaded */<br>
#loadmodule &quot;presence.so&quot;<br>#loadmodule &quot;presence_xml.so&quot;<br><br><br># ----------------- setting module-specific parameters ---------------<br><br>#=======================Dialog===================<br>
modparam(&quot;dialog&quot;, &quot;enable_stats&quot;, 1)<br>modparam(&quot;dialog&quot;, &quot;timeout_avp&quot;, &quot;$avp(10)&quot;)<br>modparam(&quot;dialog&quot;, &quot;default_timeout&quot;, 10111111)<br>modparam(&quot;dialog&quot;, &quot;db_url&quot;, &quot;mysql://opensips:opensipsrw@localhost/opensips&quot;)<br>
modparam(&quot;dialog&quot;, &quot;db_mode&quot;, 1)<br>modparam(&quot;dialog&quot;, &quot;table_name&quot;, &quot;dialog&quot;)<br><br># ----- mi_fifo params -----<br>modparam(&quot;mi_fifo&quot;, &quot;fifo_name&quot;, &quot;/tmp/opensips_fifo&quot;)<br>
<br><br># ----- rr params -----<br># add value to ;lr param to cope with most of the UAs<br>modparam(&quot;rr&quot;, &quot;enable_full_lr&quot;, 1)<br># do not append from tag to the RR (no need for this script)<br>modparam(&quot;rr&quot;, &quot;append_fromtag&quot;, 0)<br>
<br><br># ----- registrar params -----<br>/* uncomment the next line not to allow more than 10 contacts per AOR */<br>#modparam(&quot;registrar&quot;, &quot;max_contacts&quot;, 10)<br><br><br># ----- usrloc params -----<br>
modparam(&quot;usrloc&quot;, &quot;db_mode&quot;,   0)<br>/* uncomment the following lines if you want to enable DB persistency<br>   for location entries */<br>#modparam(&quot;usrloc&quot;, &quot;db_mode&quot;,   2)<br>#modparam(&quot;usrloc&quot;, &quot;db_url&quot;,<br>
#    &quot;mysql://opensips:opensipsrw@localhost/opensips&quot;)<br><br><br># ----- uri params -----<br>modparam(&quot;uri&quot;, &quot;use_uri_table&quot;, 0)<br><br><br># ----- acc params -----<br>/* what sepcial events should be accounted ? */<br>
modparam(&quot;acc&quot;, &quot;early_media&quot;, 1)<br>modparam(&quot;acc&quot;, &quot;report_ack&quot;, 1)<br>modparam(&quot;acc&quot;, &quot;report_cancels&quot;, 1)<br>/* by default ww do not adjust the direct of the sequential requests.<br>
   if you enable this parameter, be sure the enable &quot;append_fromtag&quot;<br>   in &quot;rr&quot; module */<br>modparam(&quot;acc&quot;, &quot;detect_direction&quot;, 0)<br>/* account triggers (flags) */<br>modparam(&quot;acc&quot;, &quot;failed_transaction_flag&quot;, 3)<br>
modparam(&quot;acc&quot;, &quot;log_flag&quot;, 1)<br>modparam(&quot;acc&quot;, &quot;log_missed_flag&quot;, 2)<br>/* uncomment the following lines to enable DB accounting also */<br>modparam(&quot;acc&quot;, &quot;db_flag&quot;, 1)<br>
modparam(&quot;acc&quot;, &quot;db_missed_flag&quot;, 2)<br><br><br># ----- auth_db params -----<br>/* uncomment the following lines if you want to enable the DB based<br>   authentication */<br>modparam(&quot;auth_db&quot;, &quot;calculate_ha1&quot;, yes)<br>
modparam(&quot;auth_db&quot;, &quot;password_column&quot;, &quot;password&quot;)<br>modparam(&quot;auth_db&quot;, &quot;db_url&quot;,&quot;mysql://opensips:opensipsrw@localhost/opensips&quot;)<br>modparam(&quot;auth_db&quot;, &quot;load_credentials&quot;, &quot;&quot;)<br>
<br><br># ----- alias_db params -----<br>/* uncomment the following lines if you want to enable the DB based<br>   aliases */<br>modparam(&quot;alias_db&quot;, &quot;db_url&quot;,&quot;mysql://opensips:opensipsrw@localhost/opensips&quot;)<br>
<br><br># ----- domain params -----<br>/* uncomment the following lines to enable multi-domain detection<br>   support */<br>modparam(&quot;domain&quot;, &quot;db_url&quot;,&quot;mysql://opensips:opensipsrw@localhost/opensips&quot;)<br>
modparam(&quot;domain&quot;, &quot;db_mode&quot;, 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(&quot;auth_db|usrloc|uri&quot;, &quot;use_domain&quot;, 1)<br><br><br># ----- presence params -----<br>/* uncomment the following lines if you want to enable presence */<br>#modparam(&quot;presence|presence_xml&quot;, &quot;db_url&quot;,<br>
#    &quot;mysql://opensips:opensipsrw@localhost/opensips&quot;)<br>#modparam(&quot;presence_xml&quot;, &quot;force_active&quot;, 1)<br>#modparam(&quot;presence&quot;, &quot;server_address&quot;, &quot;sip:<a href="http://192.168.1.2:5060">192.168.1.2:5060</a>&quot;)<br>
<br># ================ Xmlrpc params========================<br>modparam(&quot;mi_xmlrpc&quot;, &quot;port&quot;, 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(&quot;10&quot;)) {<br>        sl_send_reply(&quot;483&quot;,&quot;Too Many Hops&quot;);<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(&quot;BYE&quot;)) {<br>                setflag(1); # do accounting ...<br>                setflag(3); # ... even if the transaction fails<br>
            } else if (is_method(&quot;INVITE&quot;)) {<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(&quot;SUBSCRIBE&quot;) &amp;&amp; $rd == &quot;your.server.ip.address&quot;) {<br>            ##    # in-dialog subscribe requests<br>            ##    route(2);<br>            ##    exit;<br>            ##}<br>
            if ( is_method(&quot;ACK&quot;) ) {<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 -&gt;<br>                    # ignore and discard<br>                    exit;<br>
                }<br>            }<br>            sl_send_reply(&quot;404&quot;,&quot;Not here&quot;);<br>        }<br>        exit;<br>    }<br><br>    #initial requests<br><br>    # CANCEL processing<br>    if (is_method(&quot;CANCEL&quot;))<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==&quot;REGISTER&quot;) &amp;&amp; from_uri==myself) /*no multidomain version*/<br>    if (!(method==&quot;REGISTER&quot;) &amp;&amp; is_from_local())  /*multidomain version*/<br>
    {<br>        if (!proxy_authorize(&quot;&quot;, &quot;subscriber&quot;)) {<br>            proxy_challenge(&quot;&quot;, &quot;0&quot;);<br>            exit;<br>        }<br>        if (!db_check_from()) {<br>            sl_send_reply(&quot;403&quot;,&quot;Forbidden auth ID&quot;);<br>
            exit;<br>        }<br>    <br>        consume_credentials();<br>        # caller authenticated<br>    }<br><br>    # preloaded route checking<br>    if (loose_route()) {<br>        xlog(&quot;L_ERR&quot;,<br>        &quot;Attempt to route with preloaded Route&#39;s [$fu/$tu/$ru/$ci]&quot;);<br>
        if (!is_method(&quot;ACK&quot;))<br>            sl_send_reply(&quot;403&quot;,&quot;Preload Route denied&quot;);<br>        exit;<br>    }<br><br>    # record routing<br>    if (!is_method(&quot;REGISTER|MESSAGE&quot;))<br>
        record_route();<br><br>    # account only INVITEs<br>    if (is_method(&quot;INVITE&quot;)) {<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(&quot;P-hint: outbound\r\n&quot;); <br>        # if you have some interdomain connections via TLS<br>        ##if($rd==&quot;<a href="http://tls_domain1.net">tls_domain1.net</a>&quot;) {<br>
        ##    t_relay(&quot;tls:<a href="http://domain1.net">domain1.net</a>&quot;);<br>        ##    exit;<br>        ##} else if($rd==&quot;<a href="http://tls_domain2.net">tls_domain2.net</a>&quot;) {<br>        ##    t_relay(&quot;tls:<a href="http://domain2.net">domain2.net</a>&quot;);<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 &#39;if&#39; block<br>
    ##   NOTE: uncomment also the definition of route[2] from  below<br>    ##if( is_method(&quot;PUBLISH|SUBSCRIBE&quot;))<br>    ##        route(2);<br><br>    if (is_method(&quot;PUBLISH&quot;))<br>    {<br>        sl_send_reply(&quot;503&quot;, &quot;Service Unavailable&quot;);<br>
        exit;<br>    }<br>    <br><br>    if (is_method(&quot;REGISTER&quot;))<br>    {<br>        # authenticate the REGISTER requests (uncomment to enable auth)<br>        if (!www_authorize(&quot;&quot;, &quot;subscriber&quot;))<br>
        {<br>            www_challenge(&quot;&quot;, &quot;0&quot;);<br>            exit;<br>        }<br>        <br>        if (!db_check_to()) <br>        {<br>            sl_send_reply(&quot;403&quot;,&quot;Forbidden auth ID&quot;);<br>
            exit;<br>        }<br><br>        if (!save(&quot;location&quot;))<br>            sl_reply_error();<br><br>        exit;<br>    }<br><br>    if ($rU==NULL) {<br>        # request with no Username in RURI<br>        sl_send_reply(&quot;484&quot;,&quot;Address Incomplete&quot;);<br>
        exit;<br>    }<br><br>    # apply DB based aliases (uncomment to enable)<br>    ##alias_db_lookup(&quot;dbaliases&quot;);<br><br>    # do lookup with method filtering<br>    if (!lookup(&quot;location&quot;,&quot;m&quot;)) {<br>
        switch ($retcode) {<br>            case -1:<br>            case -3:<br>                t_newtran();<br>                t_reply(&quot;404&quot;, &quot;Not Found&quot;);<br>                exit;<br>            case -2:<br>
                sl_send_reply(&quot;405&quot;, &quot;Method Not Allowed&quot;);<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(&quot;INVITE&quot;)) {<br>        t_on_branch(&quot;2&quot;);<br>        t_on_reply(&quot;2&quot;);<br>        t_on_failure(&quot;1&quot;);<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(&quot;PUBLISH&quot;))<br>##    {<br>##        handle_publish();<br>
##    }<br>##    else<br>##    if( is_method(&quot;SUBSCRIBE&quot;))<br>##    {<br>##        handle_subscribe();<br>##    }<br>##<br>##    exit;<br>##}<br><br><br>branch_route[2] {<br>    xlog(&quot;new branch at $ru\n&quot;);<br>
}<br><br><br>onreply_route[2] {<br>    xlog(&quot;incoming reply\n&quot;);<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(&quot;3[0-9][0-9]&quot;)) {<br>    ##t_reply(&quot;404&quot;,&quot;Not found&quot;);<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(&quot;486|408&quot;)) {<br>    ##    sethostport(&quot;<a href="http://192.168.2.100:5060">192.168.2.100:5060</a>&quot;);<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 href="mailto:akibsayyed@gmail.com" target="_blank">akibsayyed@gmail.com</a><br><a href="mailto:akibsayyed@matrixshell.com" target="_blank">akibsayyed@matrixshell.com</a><br>
Mob:- +91-966-514-2243<br><br><br>