Re: [OpenSIPS-Users] Last Modified AOR for User
Hi Jalung, If you list the records in mongoDB collection, do you see the last_modified field properly set ? (I'm trying to understand if you have a problem with the data in DB or with the query itself) Regards, Bogdan-Andrei Iancu OpenSIPS Founder and Developer http://www.opensips-solutions.com On 07.02.2015 01:47, sevpal wrote: If I’m storing the location table in a mongodb collection, how to query the most current AOR for a user? I can query all the fields except the date/time fields eg; “last_modified”, they return empty. I’m doing this using the mongo raw query in Opensips. Jalung ___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users ___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users
Re: [OpenSIPS-Users] Group and Prefix Based Dynamic Routing
Hi Nick, If you want to do prefix based routing, you should not use the L flag - this flag says that the whole number you have in RURI must match the prefix in DB. Regards, Bogdan-Andrei Iancu OpenSIPS Founder and Developer http://www.opensips-solutions.com On 08.02.2015 03:58, symack wrote: Hello Everyone, Currently we are using do_routing to route our calls based on group id's. Now we would like to offer some different routes to every group based on prefixes. Essentially it would be something like do_routing(2,L) INSERT INTO dr_rules (groupid, prefix, timerec, priority, routeid, gwlist, attrs, description) VALUES ('2','00111','',1,'0','1','yes','Standard Wholesale Route'); INSERT INTO dr_rules (groupid, prefix, timerec, priority, routeid, gwlist, attrs, description) VALUES ('2','00112','',1,'0','2','yes','Premium Wholesale Route'); In essence, a group can be routed to many gateways based on prefix sent in initial invite. Reading the documentation: /L/- Do strict length matching over the prefix - actually DR engine will do full number matching and not prefix matching anymore. Will I not be able to route the call based on the prefix alone? I do not know the full number, unless we use regex which is the job of dialplan and not dr_rules. Nick. ___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users ___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users
Re: [OpenSIPS-Users] The user's address stay in memory
Hi, We were looking to a way to integrate this in a more natural way - there is a feature request (https://github.com/OpenSIPS/opensips/issues/337) for being able to track the replies to pinging OPTIONS . By doing that, you can see when the end point dies (it will simply stop answering to ping) and you can forcedly unregister it . But this is just a plan yet. Regards, Bogdan-Andrei Iancu OpenSIPS Founder and Developer http://www.opensips-solutions.com On 07.02.2015 16:46, microx wrote: Hi Tin, As long as the registration of the user has timed out, the user's registration info will be invalid. With OpenSIPS, you can set an upper bound on the maximum expiry value of user registration (modparam(registrar, max_expires, your_preferred_value)) and set the interval in which the expired user registration data are removed (modparam(usrloc, timer_interval, your_preferred_value)). If you would like to delete such users on your own, you may use the MI function ul_rm provided in the usrloc moduel. Kind wishes, Chen-Che -- View this message in context: http://opensips-open-sip-server.1449251.n2.nabble.com/The-user-s-address-stay-in-memory-tp7595234p7595242.html Sent from the OpenSIPS - Users mailing list archive at Nabble.com. ___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users ___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users
Re: [OpenSIPS-Users] Errors on opensips 1.11.3 (Logging and db_text)
Hi Alfred, Each table used by OpenSIPS has its own version. So, for each table, you need to have the corresponding record in the version table. The version table for dbtext comes pre-populated with all the tables. Regards, Bogdan-Andrei Iancu OpenSIPS Founder and Developer http://www.opensips-solutions.com On 04.02.2015 20:45, Alfred Rudrapati wrote: Thanks Bogdan. You said initially that I need a version table too. How do I decide the contents and the values in it? Is there a document/link for me to catch up? On Wed, Feb 4, 2015 at 10:30 AM, Alfred Rudrapati alfred5...@gmail.com mailto:alfred5...@gmail.com wrote: Hi Bogdan, Thanks. That took care of it. I have a few more questions: 1. Is there a way to change the delimiter from : (colon) to something else? I am using the dispatcher dbtext and it would help if the delimiter was not colon. Sip URIs have colons in them. 2. We are migrating from 1.7 opensips to 1.11.3. Is that the most stable one to migrate too? 3. I have been able to get the servers up and running on 1.11.3. Is this a production-grade opensips release? 4. Do you have any benchmarks/metrics that I can show to management to justify the upgrade and the fact that it wont have detrimental effects on our production environment.? 5. Is there a notls verion of the opensips rpm? I only see the tls rpm for 1.11.3 On Tue, Feb 3, 2015 at 12:54 PM, Bogdan-Andrei Iancu bog...@opensips.org mailto:bog...@opensips.org wrote: Hi Alfred, 1) I suspect a configuration issue with your syslog daemon - maybe the debug level is skipped for default log file. 2) in /tmp/opensipsdb you need to have the version table too. Best regards, Bogdan-Andrei Iancu OpenSIPS Founder and Developer http://www.opensips-solutions.com On 03.02.2015 19:28, Alfred Rudrapati wrote: I have 2 issues: 1.I have set my log to DEBUG but I don’t see then displayed. Notice that the below snipped shows INFOR and ERROR logs only. debug=6 log_stderror=no log_facility=LOG_LOCAL0 2.I am trying to use the dbtext module and Here is the error I get: Stopping opensips: not running [WARNING] Starting opensips: [FAILED] Feb 3 09:08:19 test_server opensips: INFO:core:shm_mem_init: allocating SHM block Feb 3 09:08:19 test_server opensips: INFO:core:init_tcp: using epoll_lt as the TCP io watch method (auto detected) Feb 3 09:08:19 test_server /usr/sbin/opensips[14637]: NOTICE:core:main: version: opensips 1.11.3-tls (x86_64/linux) Feb 3 09:08:19 test_server /usr/sbin/opensips[14637]: INFO:core:main: using 32 Mb shared memory Feb 3 09:08:19 test_server /usr/sbin/opensips[14637]: INFO:core:main: using 2 Mb private memory per process Feb 3 09:08:19 test_server /usr/sbin/opensips[14637]: INFO:core:evi_publish_event: Registered event E_CORE_THRESHOLD(0) Feb 3 09:08:19 test_server /usr/sbin/opensips[14637]: INFO:core:evi_publish_event: Registered event E_CORE_SHM_THRESHOLD(1) Feb 3 09:08:19 test_server /usr/sbin/opensips[14637]: INFO:core:evi_publish_event: Registered event E_CORE_PKG_THRESHOLD(2) Feb 3 09:08:19 test_server /usr/sbin/opensips[14637]: INFO:sl:mod_init: Initializing StateLess engine Feb 3 09:08:19 test_server /usr/sbin/opensips[14637]: INFO:tm:mod_init: TM - initializing... Feb 3 09:08:19 test_server /usr/sbin/opensips[14637]: NOTICE:signaling:mod_init: initializing module ... Feb 3 09:08:19 test_server /usr/sbin/opensips[14637]: INFO:maxfwd:mod_init: initializing... Feb 3 09:08:19 test_server /usr/sbin/opensips[14637]: INFO:textops:mod_init: initializing... Feb 3 09:08:19 test_server /usr/sbin/opensips[14637]: INFO:sipmsgops:mod_init: initializing... Feb 3 09:08:19 test_server /usr/sbin/opensips[14637]: INFO:db_text:dbt_init: using database at: /tmp/opensipsdb Feb 3 09:08:19 test_server /usr/sbin/opensips[14637]: ERROR:db_text:dbt_query: table does not exist! Feb 3 09:08:19 test_server /usr/sbin/opensips[14637]: ERROR:core:db_table_version: error in db_query Feb 3 09:08:19 test_server /usr/sbin/opensips[14637]: ERROR:dispatcher:init_ds_db: failed to query table version Feb 3 09:08:19 test_server /usr/sbin/opensips[14637]: ERROR:dispatcher:mod_init: failed to init database support Feb 3 09:08:19 test_server /usr/sbin/opensips[14637]: ERROR:core:init_mod: failed to initialize module dispatcher Feb 3 09:08:19 test_server /usr/sbin/opensips[14637]: ERROR:core:main: error while initializing modules
Re: [OpenSIPS-Users] Last Modified AOR for User
The data in the DB are stored correctly, there aren’t any problems there, I can view all the fields properly set with “db.location.find()” . On a raw Query though, all the other fields return with Json data except the date/time fields. It seems mongo needs a different kind of directive than what is currently in the module to retrieve the data. From: Bogdan-Andrei Iancu Sent: Monday, February 09, 2015 4:24 AM To: sevpal ; OpenSIPS users mailling list Subject: Re: [OpenSIPS-Users] Last Modified AOR for User Hi Jalung, If you list the records in mongoDB collection, do you see the last_modified field properly set ? (I'm trying to understand if you have a problem with the data in DB or with the query itself) Regards, Bogdan-Andrei Iancu OpenSIPS Founder and Developer http://www.opensips-solutions.comOn 07.02.2015 01:47, sevpal wrote: If I’m storing the location table in a mongodb collection, how to query the most current AOR for a user? I can query all the fields except the date/time fields eg; “last_modified”, they return empty. I’m doing this using the mongo raw query in Opensips. Jalung ___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users ___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users
[OpenSIPS-Users] Testing Event_Route with USRLOC
I'm trying out event_route with USRLOC but I am not seeing any xlogs. I'm not 100% clear how to set up event_route's but it seems like it is basically just creating the following modparam(usrloc, db_mode, 2) event_route[E_UL_AOR_INSERT] { xlog(The E_UL_AOR_INSERT event was raised\n); } event_route[E_UL_AOR_DELETE] { xlog(The E_UL_AOR_DELETE event was raised\n); } Is there anything else that needs to be done in the script? If I register or register a client I am not seeing any xlog messages. And if I delete a client using opensipsctl fifo ul_rm I don't see anything. Running OpenSIPS 1.11.2-notls ___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users