Hi guys, Charles i think that you can use `openserctl fifo lcr_reload' that will refresh your cache with DB content.
-Angel El mié, 16-05-2007 a las 15:23 -0400, Ovidiu Sas escribió: > Hi Charles, > > In 1.2 the DB was removed, so only cached mode is available. > It should speed up things :-) > > > Regards, > Ovidiu Sas > > On 5/16/07, Charles Wang <[EMAIL PROTECTED]> wrote: > > Dear Ovidiu, > > > > Thank you for your kind, and I solved it. You are right, it is cached mode. > > Is it possible to always be loaded it from DB not in cache? > > > > Thank you again. > > > > Best regards, > > Charles > > > > > > 2007/5/17, Ovidiu Sas <[EMAIL PROTECTED]>: > > > Hi Charles, > > > > > > Starting with 1.2 lcr is operating in cached mode and therefore there > > > will be no SQL queries during a call. > > > You can use `openserctl fifo lcr_dump' to check the content of your > > tables. > > > > > > > > > Regards, > > > Ovidiu Sas > > > > > > On 5/16/07, Charles Wang <[EMAIL PROTECTED]> wrote: > > > > Hi, Ovidiu, > > > > > > > > I update the from_uri field from '%' to Empty string. > > > > But the result is the same as before. > > > > > > > > No any SQL command related to lcr or gw or gw_grp in my mysql.log during > > I > > > > make an offnet call. > > > > > > > > Best regards, > > > > Charles > > > > > > > > > > > > 2007/5/16, Ovidiu Sas <[EMAIL PROTECTED]>: > > > > > Hi Charles, > > > > > > > > > > > > > > > In the lcr table you should have an empty string, not '%'. > > > > > > > > > > > > > > > Regards, > > > > > Ovidiu Sas > > > > > > > > > > On 5/16/07, Charles Wang < [EMAIL PROTECTED]> 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:[EMAIL PROTECTED] F=sip:[EMAIL PROTECTED] > > > > > > T=sip:[EMAIL PROTECTED] IP=61.217.XXX.XXX > > > > > > ID= > > [EMAIL PROTECTED] > > > > > > May 16 22:52:05 XXX /usr/local/sbin/openser[29112]: Proxy > > authentication > > > > > > failed - M=INVITE RURI=sip:[EMAIL PROTECTED] F= > > > > sip:[EMAIL PROTECTED] > > > > > > T= sip:[EMAIL PROTECTED] IP=61.217.XXX.XXX > > > > > > ID= > > [EMAIL PROTECTED] > > > > > > May 16 22:52:05 XXX /usr/local/sbin/openser[29117]: New request - > > > > M=INVITE > > > > > > RURI=sip:[EMAIL PROTECTED] F=sip:[EMAIL PROTECTED] > > > > > > T= sip:[EMAIL PROTECTED] IP=61.217.XXX.XXX > > > > > > ID= > > [EMAIL PROTECTED] > > > > > > May 16 22:52:05 XXX /usr/local/sbin/openser[29117]: Clear caller > > > > preferences > > > > > > - M=INVITE RURI=sip:[EMAIL PROTECTED] F= > > sip:[EMAIL PROTECTED] > > > > > > T= sip:[EMAIL PROTECTED] IP=61.217.XXX.XXX > > > > > > ID= > > [EMAIL PROTECTED] > > > > > > May 16 22:52:05 XXX /usr/local/sbin/openser[29117]: Load caller > > > > preferences > > > > > > for uuid '1' - M=INVITE RURI= sip:[EMAIL PROTECTED] F= > > > > > > sip:[EMAIL PROTECTED] T=sip:[EMAIL PROTECTED] > > IP=61.217.XXX.XXX > > > > > > ID= > > [EMAIL PROTECTED] > > > > > > May 16 22:52:05 XXX /usr/local/sbin/openser[29117]: Clear callee > > > > preferences > > > > > > - M=INVITE RURI= sip:[EMAIL PROTECTED] F= > > sip:[EMAIL PROTECTED] > > > > > > T=sip:[EMAIL PROTECTED] IP=61.217.XXX.XXX > > > > > > > > [EMAIL PROTECTED] > > > > > > May 16 22:52:05 XXX /usr/local/sbin/openser[29117]: Callee is not > > local > > > > - > > > > > > M=INVITE RURI=sip:[EMAIL PROTECTED] F=sip:[EMAIL PROTECTED] > > > > > > T= sip:[EMAIL PROTECTED] IP=61.217.XXX.XXX > > > > > > > > [EMAIL PROTECTED] > > > > > > May 16 22:52:05 XXX /usr/local/sbin/openser[29117]: Ready to Invite > > To > > > > > > External - M=INVITE RURI=sip:[EMAIL PROTECTED] F= > > > > > > sip:[EMAIL PROTECTED] T= sip:[EMAIL PROTECTED] > > IP=61.217.XXX.XXX > > > > > > > > [EMAIL PROTECTED] > > > > > > May 16 22:52:05 XXX /usr/local/sbin/openser[29117]: Ready to 00 - > > > > M=INVITE > > > > > > RURI=sip:[EMAIL PROTECTED] F=sip:[EMAIL PROTECTED] > > > > > > T= sip:[EMAIL PROTECTED] IP=61.217.XXX.XXX > > > > > > > > [EMAIL PROTECTED] > > > > > > May 16 22:52:05 XXX /usr/local/sbin/openser[29117]: Ready to Load > > PSTN > > > > > > gateways - M=INVITE RURI=sip:[EMAIL PROTECTED] F= > > > > > > sip:[EMAIL PROTECTED] T= sip:[EMAIL PROTECTED] > > IP=61.217.XXX.XXX > > > > > > > > [EMAIL PROTECTED] > > > > > > May 16 22:52:05 XXX /usr/local/sbin/openser[29117]: Ready to NextGW > > - > > > > > > M=INVITE RURI=sip:[EMAIL PROTECTED] F=sip:[EMAIL PROTECTED] > > > > > > T= sip:[EMAIL PROTECTED] IP=61.217.XXX.XXX > > > > > > > > [EMAIL PROTECTED] > > > > > > May 16 22:52:05 XXX /usr/local/sbin/openser[29117]: No PSTN gateways > > > > > > available - M=INVITE RURI=sip:[EMAIL PROTECTED] F= > > > > > > sip:[EMAIL PROTECTED] T= sip:[EMAIL PROTECTED] > > IP=61.217.XXX.XXX > > > > > > > > [EMAIL PROTECTED] > > > > > > > > > > > > > > > > > > > > > > > > #################### /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:[EMAIL PROTECTED] /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 > > > > > > [email protected] > > > > > > http://openser.org/cgi-bin/mailman/listinfo/users > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > -- > > > > > > > > Best Regards > > > > Charles > > > > > > > > > > > -- > > > > Best Regards > > Charles >
signature.asc
Description: Esta parte del mensaje está firmada digitalmente
_______________________________________________ Users mailing list [email protected] http://openser.org/cgi-bin/mailman/listinfo/users
