Re: [OpenSIPS-Users] Last Modified AOR for User

2015-02-09 Thread Bogdan-Andrei Iancu

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

2015-02-09 Thread Bogdan-Andrei Iancu

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

2015-02-09 Thread Bogdan-Andrei Iancu

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)

2015-02-09 Thread Bogdan-Andrei Iancu

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

2015-02-09 Thread sevpal
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

2015-02-09 Thread Duane Larson
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