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