2007/5/16, Ovidiu Sas <sip.nslu@gmail.com>:

Hi Charles,

In the lcr table you should have an empty string, not '%'.

Regards,
Ovidiu Sas

On 5/16/07, Charles Wang <lazy.charles@gmail.com> wrote:
> Hi all,
>
> I got this openser.cfg from http://www.sipwise.com/wizard .
> I tried to make a offnet call prefix with 00.
>
> I try to load_gws and next_gw for lcr.
> But I can't find out such as "select xxx from lcr" or "select xxx from gw"
> during these steps in my mysql.log ( I opened the log file myself ). And
> also it will not redirect to the voice gateway.
>
> Is it the error of my schemas ? Any idea for it please.
>
>
> #################### /var/log/message ####################
> May 16 22:52:05 XXX /usr/local/sbin/openser[29112]: New request - M=INVITE
> RURI=sip:00862123456789@XXX.XXX.XXX F=sip:101@XXX.XXX.XXX
> T=sip:00862123456789@XXX.XXX.XXX IP=61.217.XXX.XXX
> ID= C8F50846-1452-4EDC-9726-5A3AFECDF533@192.168.11.9
> May 16 22:52:05 XXX /usr/local/sbin/openser[29112]: Proxy authentication
> failed - M=INVITE RURI=sip:00862123456789@XXX.XXX.XXX F= sip:101@XXX.XXX.XXX
> T=sip:00862123456789@XXX.XXX.XXX IP=61.217.XXX.XXX
> ID= C8F50846-1452-4EDC-9726-5A3AFECDF533@192.168.11.9
> May 16 22:52:05 XXX /usr/local/sbin/openser[29117]: New request - M=INVITE
> RURI=sip:00862123456789@XXX.XXX.XXX F=sip:101@XXX.XXX.XXX
> T=sip:00862123456789@XXX.XXX.XXX IP=61.217.XXX.XXX
> ID= C8F50846-1452-4EDC-9726-5A3AFECDF533@192.168.11.9
> May 16 22:52:05 XXX /usr/local/sbin/openser[29117]: Clear caller preferences
> - M=INVITE RURI=sip:00862123456789@XXX.XXX.XXX F= sip:101@XXX.XXX.XXX
> T=sip:00862123456789@XXX.XXX.XXX IP=61.217.XXX.XXX
> ID= C8F50846-1452-4EDC-9726-5A3AFECDF533@192.168.11.9
> May 16 22:52:05 XXX /usr/local/sbin/openser[29117]: Load caller preferences
> for uuid '1' - M=INVITE RURI= sip:00862123456789@XXX.XXX.XXX F=
> sip:101@XXX.XXX.XXX T=sip:00862123456789@XXX.XXX.XXX IP=61.217.XXX.XXX
> ID= C8F50846-1452-4EDC-9726-5A3AFECDF533@192.168.11.9
> May 16 22:52:05 XXX /usr/local/sbin/openser[29117]: Clear callee preferences
> - M=INVITE RURI= sip:00862123456789@XXX.XXX.XXX F= sip:101@XXX.XXX.XXX
> T=sip:00862123456789@XXX.XXX.XXX IP=61.217.XXX.XXX
> ID=C8F50846-1452-4EDC-9726-5A3AFECDF533@192.168.11.9
> May 16 22:52:05 XXX /usr/local/sbin/openser[29117]: Callee is not local -
> M=INVITE RURI=sip:00862123456789@XXX.XXX.XXX F=sip:101@XXX.XXX.XXX
> T= sip:00862123456789@XXX.XXX.XXX IP=61.217.XXX.XXX
> ID=C8F50846-1452-4EDC-9726-5A3AFECDF533@192.168.11.9
> May 16 22:52:05 XXX /usr/local/sbin/openser[29117]: Ready to Invite To
> External - M=INVITE RURI=sip:00862123456789@XXX.XXX.XXX F=
> sip:101@XXX.XXX.XXX T= sip:00862123456789@XXX.XXX.XXX IP=61.217.XXX.XXX
> ID=C8F50846-1452-4EDC-9726-5A3AFECDF533@192.168.11.9
> May 16 22:52:05 XXX /usr/local/sbin/openser[29117]: Ready to 00 - M=INVITE
> RURI=sip:00862123456789@XXX.XXX.XXX F=sip:101@XXX.XXX.XXX
> T=sip:00862123456789@XXX.XXX.XXX IP=61.217.XXX.XXX
> ID=C8F50846-1452-4EDC-9726-5A3AFECDF533@192.168.11.9
> May 16 22:52:05 XXX /usr/local/sbin/openser[29117]: Ready to Load PSTN
> gateways - M=INVITE RURI=sip:00862123456789@XXX.XXX.XXX F=
> sip:101@XXX.XXX.XXX T= sip:00862123456789@XXX.XXX.XXX IP=61.217.XXX.XXX
> ID=C8F50846-1452-4EDC-9726-5A3AFECDF533@192.168.11.9
> May 16 22:52:05 XXX /usr/local/sbin/openser[29117]: Ready to NextGW -
> M=INVITE RURI=sip:00862123456789@XXX.XXX.XXX F=sip:101@XXX.XXX.XXX
> T= sip:00862123456789@XXX.XXX.XXX IP=61.217.XXX.XXX
> ID=C8F50846-1452-4EDC-9726-5A3AFECDF533@192.168.11.9
> May 16 22:52:05 XXX /usr/local/sbin/openser[29117]: No PSTN gateways
> available - M=INVITE RURI=sip:00862123456789@XXX.XXX.XXX F=
> sip:101@XXX.XXX.XXX T= sip:00862123456789@XXX.XXX.XXX IP=61.217.XXX.XXX
> ID=C8F50846-1452-4EDC-9726-5A3AFECDF533@192.168.11.9
>
>
>
> #################### /tmp/mysql.log ####################
> 070516 22:52:05     755 Query       select password,uuid from subscriber
> where username='101' AND domain='xxx.xxx.xxx'
>                     755 Query       select value,attribute,type from
> usr_preferences where uuid='1'
>                     755 Query       select uuid from subscriber where
> username = '00862123456789'
>
>
> ===> gw table
> | id | gw_name    | grp_id | ip_addr              | port   | uri_scheme |
> transport | strip | prefix |
> |  1 | my-test-gw |      1   | XXX.XXX.XXX.XXX | 5060 |          1       |
>       1    |     0 | NULL |
>
> ===> gw schema
> | Field          | Type                       | Null | Key   | Default  |
> Extra               |
> | id               | int(10)                     | NO   | PRI  | NULL    |
> auto_increment |
> | gw_name    | varchar(128)            | NO   | UNI  | NULL    |
>             |
> | grp_id         | int(10) unsigned      | NO   | MUL | NULL    |
>              |
> | ip_addr       | varchar(15)              | NO   |        | NULL    |
>                   |
> | port            | smallint(5) unsigned | YES  |       | NULL    |
>                |
> | uri_scheme | tinyint(3) unsigned   | YES  |       | NULL    |
>            |
> | transport     | tinyint(3) unsigned   | YES  |       | NULL    |
>               |
> | strip           | tinyint(3) unsigned   | YES  |       | NULL    |
>                 |      <=== it should be varchar ?
> | prefix          | varchar(16)             | YES  |       | NULL    |
>                   |       <=== default value should be Empty or NULL ?
>
> ===> gw_grp table
> | grp_id | grp_name     |
> |      1   | my-test-gw   |
>
> ===> gw_grp schema
> | Field        | Type                 | Null  | Key | Default | Extra
>        |
> | grp_id      | int(10) unsigned | NO   | PRI | NULL    | auto_increment |
> | grp_name | varchar(64)        | NO   |       | NULL    |
>      |
>
> ===> lcr table
> | id | prefix                    | from_uri  | grp_id  | priority   |
> |  1 | 00862123456789   | %           |      1    |       10   |
>
> ===> lcr schema
> | Field      | Type                     | Null   | Key | Default  | Extra
>             |
> | id          | int(10)                   | NO    | PRI  | NULL    |
> auto_increment |
> | prefix     | varchar(16)            | NO    | MUL | NULL    |
>           |
> | from_uri | varchar(128)           | YES  | MUL | NULL    |
>        |
> | grp_id    | int(10) unsigned     | NO    | MUL | NULL    |
>        |
> | priority   | tinyint(3) unsigned | NO    |         | NULL    |
>            |
>
>
>
> ################ parts of my openser.cfg
> #######################################
> loadmodule "lcr.so"
> modparam("lcr", "db_url",
> "mysql://openser:openserrw@localhost /openser")
> modparam("lcr", "gw_table", "gw")
> modparam("lcr", "gw_name_column", "gw_name")
> modparam("lcr", "ip_addr_column", "ip_addr")
> modparam("lcr", "port_column", "port")
> modparam("lcr", "uri_scheme_column", "uri_scheme")
> modparam("lcr", "transport_column", "transport")
> modparam("lcr", "grp_id_column", "grp_id")
> modparam("lcr", "lcr_table", "lcr")
> modparam("lcr", "strip_column", "strip")
>  modparam("lcr", "prefix_column", "prefix")
> modparam("lcr", "from_uri_column", "from_uri")
> modparam("lcr", "priority_column", "priority")
> modparam("lcr", "gw_uri_avp", "1400")
> modparam("lcr", "ruri_user_avp", "1402")
> modparam("lcr", "contact_avp", "1401")
>  modparam("lcr", "fr_inv_timer_avp", "s:fr_inv_timer_avp")
> modparam("lcr", "fr_inv_timer", 90)
> modparam("lcr", "fr_inv_timer_next", 30)
> modparam("lcr", "rpid_avp", "s:rpid")
>
> ########################################################################
> # Request route 'invite-to-external'
> ########################################################################
> route[15]
> {
>   xlog("L_INFO", "Ready to Invite To External - M=$rm RURI=$ru F=$fu T=$tu
> IP=$si ID=$ci\n");
>
>  if(isflagset(20))
>  {
>
>   xlog("L_INFO", "Call to foreign domain - M=$rm RURI=$ru F=$fu T=$tu IP=$si
> ID=$ci\n");
>   route(11);
>   exit;
>  }
>  if(!isflagset(23))
>  {
>   # don't allow calls relaying from PSTN to PSTN, if not explicitely
> forwarded
>   xlog("L_INFO", "Ready to 00 - M=$rm RURI=$ru F=$fu T=$tu IP=$si
> ID=$ci\n");
>   if(uri =~ "^sip:00[0-9]+@")
>   {
>    xlog("L_INFO", "Ready to Load PSTN gateways - M=$rm RURI=$ru F=$fu T=$tu
> IP=$si ID=$ci\n");
>    # only route numeric users to PSTN
>    if(!load_gws())
>    {
>     xlog("L_INFO", "Ready to LoadGW - M=$rm RURI=$ru F=$fu T=$tu IP=$si
> ID=$ci\n");
>     xlog("L_ERR", "Error loading PSTN gateways - M=$rm RURI=$ru F=$fu T=$tu
> IP=$si ID=$ci\n");
>     sl_send_reply("503", "PSTN Termination Currently Unavailable");
>     exit;
>    }
>    if(!next_gw())
>    {
>
>     xlog("L_INFO", "Ready to NextGW - M=$rm RURI=$ru F=$fu T=$tu IP=$si
> ID=$ci\n");
>     xlog("L_ERR", "No PSTN gateways available - M=$rm RURI=$ru F=$fu T=$tu
> IP=$si ID=$ci\n");
>     sl_send_reply("503", "PSTN Termination Currently Unavailable");
>     exit;
>    }
>    setflag(21);
>
>    t_on_failure("1");
>    route(11);
>   }
>  }
>
>  xlog("L_INFO", "Call to unknown user - M=$rm RURI=$ru F=$fu T=$tu IP=$si
> ID=$ci\n");
>  route(7);
>  sl_send_reply("404", "User Not Found");
>  exit;
>
> }
>
>
> --
>
> Best Regards
> Charles
> _______________________________________________
> Users mailing list
> Users@openser.org
> http://openser.org/cgi-bin/mailman/listinfo/users
>
>