Hi all,
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 ####################
#################### /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