Re: [OpenSIPS-Users] opensips-cp dispatcher issue

2015-04-21 Thread Podrigal, Aron
status can be either Enabled, Disabled, Probing so what you see in the web
interface is I guess that it is not disabled.  Correct me if I'm wrong.

On Tue, Apr 21, 2015 at 6:44 PM, Satish Patel  wrote:

> In command line it is showing
>
> root@dispatcher1:/var/www# opensipsctl dispatcher dump
> SET:: 1
> URI:: sip:173.XXX.XXX.181 state=Probing
>
>
> But on Opensips-cp web interface it is showing
>
> DB state: Active
>
> Look like it is not syncing with opensips properly.
>
> what would be the issue?
>
>
>
>
> ___
> Users mailing list
> Users@lists.opensips.org
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>
>


-- 
Aron Podrigal
-
//Be happy :-)
___
Users mailing list
Users@lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/users


[OpenSIPS-Users] opensips-cp dispatcher issue

2015-04-21 Thread Satish Patel
In command line it is showing

root@dispatcher1:/var/www# opensipsctl dispatcher dump
SET:: 1
URI:: sip:173.XXX.XXX.181 state=Probing


But on Opensips-cp web interface it is showing

DB state: Active

Look like it is not syncing with opensips properly.

what would be the issue?
___
Users mailing list
Users@lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/users


Re: [OpenSIPS-Users] does dispatcher use cache?

2015-04-21 Thread Podrigal, Aron
Yes, it does have cache. and there is a opensipsctl dispatcher reload to
reload from db.

On Tue, Apr 21, 2015 at 4:28 PM, Satish Patel  wrote:

> Does dispatcher module use internal cache? Because we have many group and
> i don't want opensips hit everytime SQL table to read IP address.
>
> Does opensips load dispatcher table in memory to not hit SQL for each call?
>
> ___
> Users mailing list
> Users@lists.opensips.org
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>
>


-- 
Aron Podrigal
-
//Be happy :-)
___
Users mailing list
Users@lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/users


Re: [OpenSIPS-Users] opensips 1.11 postgress DB BUG

2015-04-21 Thread Podrigal, Aron
MySQL has a option --password to provide the password on command line.
postgres however does not. but here is some refs how you can accomplish
what you would like.
http://www.postgresql.org/docs/9.4/static/libpq-pgpass.html

On Tue, Apr 21, 2015 at 4:26 PM, Satish Patel  wrote:

> can't we make password less? just like MySQL?
>
> On Tue, Apr 21, 2015 at 1:56 PM, Podrigal, Aron 
> wrote:
>
>> It executes a series of sql files ( I don't remember the dir location
>> where its stored I think somewhere in the share dir) for each file it asks
>> for the password.
>>
>> On Tue, Apr 21, 2015 at 1:44 PM, Satish Patel 
>> wrote:
>>
>>> I am installing opensips 1.11.3 with postgress DB but i don't know what
>>> is going on here
>>>
>>>
>>> root@dopensips:/etc/opensips# opensipsdbctl create
>>> INFO: creating database opensips ...
>>> Password for user postgres:
>>> Password for user postgres:
>>> Password for user postgres:
>>> NOTICE:  CREATE TABLE / UNIQUE will create implicit index
>>> "version_t_name_idx" for table "version"
>>> Password for user postgres:
>>> NOTICE:  CREATE TABLE will create implicit sequence "acc_id_seq" for
>>> serial column "acc.id"
>>> NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index
>>> "acc_pkey" for table "acc"
>>> NOTICE:  CREATE TABLE will create implicit sequence
>>> "missed_calls_id_seq" for serial column "missed_calls.id"
>>> NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index
>>> "missed_calls_pkey" for table "missed_calls"
>>> Password for user postgres:
>>> NOTICE:  CREATE TABLE will create implicit sequence "domain_id_seq" for
>>> serial column "domain.id"
>>> NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index
>>> "domain_pkey" for table "domain"
>>> NOTICE:  CREATE TABLE / UNIQUE will create implicit index
>>> "domain_domain_idx" for table "domain"
>>> Password for user postgres:
>>> NOTICE:  CREATE TABLE will create implicit sequence "grp_id_seq" for
>>> serial column "grp.id"
>>> NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index
>>> "grp_pkey" for table "grp"
>>> NOTICE:  CREATE TABLE / UNIQUE will create implicit index
>>> "grp_account_group_idx" for table "grp"
>>> NOTICE:  CREATE TABLE will create implicit sequence "re_grp_id_seq" for
>>> serial column "re_grp.id"
>>> NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index
>>> "re_grp_pkey" for table "re_grp"
>>> Password for user postgres:
>>> NOTICE:  CREATE TABLE will create implicit sequence "address_id_seq" for
>>> serial column "address.id"
>>> NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index
>>> "address_pkey" for table "address"
>>> Password for user postgres:
>>> NOTICE:  CREATE TABLE will create implicit sequence "aliases_id_seq" for
>>> serial column "aliases.id"
>>> NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index
>>> "aliases_pkey" for table "aliases"
>>> NOTICE:  CREATE TABLE / UNIQUE will create implicit index
>>> "aliases_alias_idx" for table "aliases"
>>> Password for user postgres:
>>> NOTICE:  CREATE TABLE will create implicit sequence "location_id_seq"
>>> for serial column "location.id"
>>> NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index
>>> "location_pkey" for table "location"
>>> NOTICE:  CREATE TABLE / UNIQUE will create implicit index
>>> "location_account_contact_idx" for table "location"
>>> Password for user postgres:
>>> NOTICE:  CREATE TABLE will create implicit sequence "silo_id_seq" for
>>> serial column "silo.id"
>>> NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index
>>> "silo_pkey" for table "silo"
>>> Password for user postgres:
>>> NOTICE:  CREATE TABLE will create implicit sequence "dbaliases_id_seq"
>>> for serial column "dbaliases.id"
>>> NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index
>>> "dbaliases_pkey" for table "dbaliases"
>>> NOTICE:  CREATE TABLE / UNIQUE will create implicit index
>>> "dbaliases_alias_idx" for table "dbaliases"
>>> Password for user postgres:
>>> NOTICE:  CREATE TABLE will create implicit sequence "uri_id_seq" for
>>> serial column "uri.id"
>>> NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index
>>> "uri_pkey" for table "uri"
>>> NOTICE:  CREATE TABLE / UNIQUE will create implicit index
>>> "uri_account_idx" for table "uri"
>>> Password for user postgres:
>>> NOTICE:  CREATE TABLE will create implicit sequence
>>> "rtpproxy_sockets_id_seq" for serial column "rtpproxy_sockets.id"
>>> NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index
>>> "rtpproxy_sockets_pkey" for table "rtpproxy_sockets"
>>> Password for user postgres:
>>> NOTICE:  CREATE TABLE will create implicit sequence "speed_dial_id_seq"
>>> for serial column "speed_dial.id"
>>> NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index
>>> "speed_dial_pkey" for table "speed_dial"
>>> NOTICE:  CREATE TABLE / UNIQUE will create implicit index
>>> "speed_dial_speed_dial_idx" for table "speed_dial"
>>> Password for user postgres:
>>> NOTICE:  CREATE TABLE

[OpenSIPS-Users] does dispatcher use cache?

2015-04-21 Thread Satish Patel
Does dispatcher module use internal cache? Because we have many group and i
don't want opensips hit everytime SQL table to read IP address.

Does opensips load dispatcher table in memory to not hit SQL for each call?
___
Users mailing list
Users@lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/users


Re: [OpenSIPS-Users] opensips 1.11 postgress DB BUG

2015-04-21 Thread Satish Patel
can't we make password less? just like MySQL?

On Tue, Apr 21, 2015 at 1:56 PM, Podrigal, Aron 
wrote:

> It executes a series of sql files ( I don't remember the dir location
> where its stored I think somewhere in the share dir) for each file it asks
> for the password.
>
> On Tue, Apr 21, 2015 at 1:44 PM, Satish Patel 
> wrote:
>
>> I am installing opensips 1.11.3 with postgress DB but i don't know what
>> is going on here
>>
>>
>> root@dopensips:/etc/opensips# opensipsdbctl create
>> INFO: creating database opensips ...
>> Password for user postgres:
>> Password for user postgres:
>> Password for user postgres:
>> NOTICE:  CREATE TABLE / UNIQUE will create implicit index
>> "version_t_name_idx" for table "version"
>> Password for user postgres:
>> NOTICE:  CREATE TABLE will create implicit sequence "acc_id_seq" for
>> serial column "acc.id"
>> NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "acc_pkey"
>> for table "acc"
>> NOTICE:  CREATE TABLE will create implicit sequence "missed_calls_id_seq"
>> for serial column "missed_calls.id"
>> NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index
>> "missed_calls_pkey" for table "missed_calls"
>> Password for user postgres:
>> NOTICE:  CREATE TABLE will create implicit sequence "domain_id_seq" for
>> serial column "domain.id"
>> NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index
>> "domain_pkey" for table "domain"
>> NOTICE:  CREATE TABLE / UNIQUE will create implicit index
>> "domain_domain_idx" for table "domain"
>> Password for user postgres:
>> NOTICE:  CREATE TABLE will create implicit sequence "grp_id_seq" for
>> serial column "grp.id"
>> NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "grp_pkey"
>> for table "grp"
>> NOTICE:  CREATE TABLE / UNIQUE will create implicit index
>> "grp_account_group_idx" for table "grp"
>> NOTICE:  CREATE TABLE will create implicit sequence "re_grp_id_seq" for
>> serial column "re_grp.id"
>> NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index
>> "re_grp_pkey" for table "re_grp"
>> Password for user postgres:
>> NOTICE:  CREATE TABLE will create implicit sequence "address_id_seq" for
>> serial column "address.id"
>> NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index
>> "address_pkey" for table "address"
>> Password for user postgres:
>> NOTICE:  CREATE TABLE will create implicit sequence "aliases_id_seq" for
>> serial column "aliases.id"
>> NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index
>> "aliases_pkey" for table "aliases"
>> NOTICE:  CREATE TABLE / UNIQUE will create implicit index
>> "aliases_alias_idx" for table "aliases"
>> Password for user postgres:
>> NOTICE:  CREATE TABLE will create implicit sequence "location_id_seq" for
>> serial column "location.id"
>> NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index
>> "location_pkey" for table "location"
>> NOTICE:  CREATE TABLE / UNIQUE will create implicit index
>> "location_account_contact_idx" for table "location"
>> Password for user postgres:
>> NOTICE:  CREATE TABLE will create implicit sequence "silo_id_seq" for
>> serial column "silo.id"
>> NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index
>> "silo_pkey" for table "silo"
>> Password for user postgres:
>> NOTICE:  CREATE TABLE will create implicit sequence "dbaliases_id_seq"
>> for serial column "dbaliases.id"
>> NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index
>> "dbaliases_pkey" for table "dbaliases"
>> NOTICE:  CREATE TABLE / UNIQUE will create implicit index
>> "dbaliases_alias_idx" for table "dbaliases"
>> Password for user postgres:
>> NOTICE:  CREATE TABLE will create implicit sequence "uri_id_seq" for
>> serial column "uri.id"
>> NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "uri_pkey"
>> for table "uri"
>> NOTICE:  CREATE TABLE / UNIQUE will create implicit index
>> "uri_account_idx" for table "uri"
>> Password for user postgres:
>> NOTICE:  CREATE TABLE will create implicit sequence
>> "rtpproxy_sockets_id_seq" for serial column "rtpproxy_sockets.id"
>> NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index
>> "rtpproxy_sockets_pkey" for table "rtpproxy_sockets"
>> Password for user postgres:
>> NOTICE:  CREATE TABLE will create implicit sequence "speed_dial_id_seq"
>> for serial column "speed_dial.id"
>> NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index
>> "speed_dial_pkey" for table "speed_dial"
>> NOTICE:  CREATE TABLE / UNIQUE will create implicit index
>> "speed_dial_speed_dial_idx" for table "speed_dial"
>> Password for user postgres:
>> NOTICE:  CREATE TABLE will create implicit sequence
>> "usr_preferences_id_seq" for serial column "usr_preferences.id"
>> NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index
>> "usr_preferences_pkey" for table "usr_preferences"
>> Password for user postgres:
>> NOTICE:  CREATE TABLE will create implicit sequence "subscriber_id_seq"
>> for serial column "subscriber.id"
>> NOTICE:  CREATE TABLE

Re: [OpenSIPS-Users] opensips 1.11 postgress DB BUG

2015-04-21 Thread Podrigal, Aron
It executes a series of sql files ( I don't remember the dir location where
its stored I think somewhere in the share dir) for each file it asks for
the password.

On Tue, Apr 21, 2015 at 1:44 PM, Satish Patel  wrote:

> I am installing opensips 1.11.3 with postgress DB but i don't know what is
> going on here
>
>
> root@dopensips:/etc/opensips# opensipsdbctl create
> INFO: creating database opensips ...
> Password for user postgres:
> Password for user postgres:
> Password for user postgres:
> NOTICE:  CREATE TABLE / UNIQUE will create implicit index
> "version_t_name_idx" for table "version"
> Password for user postgres:
> NOTICE:  CREATE TABLE will create implicit sequence "acc_id_seq" for
> serial column "acc.id"
> NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "acc_pkey"
> for table "acc"
> NOTICE:  CREATE TABLE will create implicit sequence "missed_calls_id_seq"
> for serial column "missed_calls.id"
> NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index
> "missed_calls_pkey" for table "missed_calls"
> Password for user postgres:
> NOTICE:  CREATE TABLE will create implicit sequence "domain_id_seq" for
> serial column "domain.id"
> NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index
> "domain_pkey" for table "domain"
> NOTICE:  CREATE TABLE / UNIQUE will create implicit index
> "domain_domain_idx" for table "domain"
> Password for user postgres:
> NOTICE:  CREATE TABLE will create implicit sequence "grp_id_seq" for
> serial column "grp.id"
> NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "grp_pkey"
> for table "grp"
> NOTICE:  CREATE TABLE / UNIQUE will create implicit index
> "grp_account_group_idx" for table "grp"
> NOTICE:  CREATE TABLE will create implicit sequence "re_grp_id_seq" for
> serial column "re_grp.id"
> NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index
> "re_grp_pkey" for table "re_grp"
> Password for user postgres:
> NOTICE:  CREATE TABLE will create implicit sequence "address_id_seq" for
> serial column "address.id"
> NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index
> "address_pkey" for table "address"
> Password for user postgres:
> NOTICE:  CREATE TABLE will create implicit sequence "aliases_id_seq" for
> serial column "aliases.id"
> NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index
> "aliases_pkey" for table "aliases"
> NOTICE:  CREATE TABLE / UNIQUE will create implicit index
> "aliases_alias_idx" for table "aliases"
> Password for user postgres:
> NOTICE:  CREATE TABLE will create implicit sequence "location_id_seq" for
> serial column "location.id"
> NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index
> "location_pkey" for table "location"
> NOTICE:  CREATE TABLE / UNIQUE will create implicit index
> "location_account_contact_idx" for table "location"
> Password for user postgres:
> NOTICE:  CREATE TABLE will create implicit sequence "silo_id_seq" for
> serial column "silo.id"
> NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "silo_pkey"
> for table "silo"
> Password for user postgres:
> NOTICE:  CREATE TABLE will create implicit sequence "dbaliases_id_seq" for
> serial column "dbaliases.id"
> NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index
> "dbaliases_pkey" for table "dbaliases"
> NOTICE:  CREATE TABLE / UNIQUE will create implicit index
> "dbaliases_alias_idx" for table "dbaliases"
> Password for user postgres:
> NOTICE:  CREATE TABLE will create implicit sequence "uri_id_seq" for
> serial column "uri.id"
> NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "uri_pkey"
> for table "uri"
> NOTICE:  CREATE TABLE / UNIQUE will create implicit index
> "uri_account_idx" for table "uri"
> Password for user postgres:
> NOTICE:  CREATE TABLE will create implicit sequence
> "rtpproxy_sockets_id_seq" for serial column "rtpproxy_sockets.id"
> NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index
> "rtpproxy_sockets_pkey" for table "rtpproxy_sockets"
> Password for user postgres:
> NOTICE:  CREATE TABLE will create implicit sequence "speed_dial_id_seq"
> for serial column "speed_dial.id"
> NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index
> "speed_dial_pkey" for table "speed_dial"
> NOTICE:  CREATE TABLE / UNIQUE will create implicit index
> "speed_dial_speed_dial_idx" for table "speed_dial"
> Password for user postgres:
> NOTICE:  CREATE TABLE will create implicit sequence
> "usr_preferences_id_seq" for serial column "usr_preferences.id"
> NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index
> "usr_preferences_pkey" for table "usr_preferences"
> Password for user postgres:
> NOTICE:  CREATE TABLE will create implicit sequence "subscriber_id_seq"
> for serial column "subscriber.id"
> NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index
> "subscriber_pkey" for table "subscriber"
> NOTICE:  CREATE TABLE / UNIQUE will create implicit index
> "subscriber_account_idx" for table "subscriber"
> Password for use

[OpenSIPS-Users] opensips 1.11 postgress DB BUG

2015-04-21 Thread Satish Patel
I am installing opensips 1.11.3 with postgress DB but i don't know what is
going on here


root@dopensips:/etc/opensips# opensipsdbctl create
INFO: creating database opensips ...
Password for user postgres:
Password for user postgres:
Password for user postgres:
NOTICE:  CREATE TABLE / UNIQUE will create implicit index
"version_t_name_idx" for table "version"
Password for user postgres:
NOTICE:  CREATE TABLE will create implicit sequence "acc_id_seq" for serial
column "acc.id"
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "acc_pkey"
for table "acc"
NOTICE:  CREATE TABLE will create implicit sequence "missed_calls_id_seq"
for serial column "missed_calls.id"
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index
"missed_calls_pkey" for table "missed_calls"
Password for user postgres:
NOTICE:  CREATE TABLE will create implicit sequence "domain_id_seq" for
serial column "domain.id"
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index
"domain_pkey" for table "domain"
NOTICE:  CREATE TABLE / UNIQUE will create implicit index
"domain_domain_idx" for table "domain"
Password for user postgres:
NOTICE:  CREATE TABLE will create implicit sequence "grp_id_seq" for serial
column "grp.id"
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "grp_pkey"
for table "grp"
NOTICE:  CREATE TABLE / UNIQUE will create implicit index
"grp_account_group_idx" for table "grp"
NOTICE:  CREATE TABLE will create implicit sequence "re_grp_id_seq" for
serial column "re_grp.id"
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index
"re_grp_pkey" for table "re_grp"
Password for user postgres:
NOTICE:  CREATE TABLE will create implicit sequence "address_id_seq" for
serial column "address.id"
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index
"address_pkey" for table "address"
Password for user postgres:
NOTICE:  CREATE TABLE will create implicit sequence "aliases_id_seq" for
serial column "aliases.id"
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index
"aliases_pkey" for table "aliases"
NOTICE:  CREATE TABLE / UNIQUE will create implicit index
"aliases_alias_idx" for table "aliases"
Password for user postgres:
NOTICE:  CREATE TABLE will create implicit sequence "location_id_seq" for
serial column "location.id"
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index
"location_pkey" for table "location"
NOTICE:  CREATE TABLE / UNIQUE will create implicit index
"location_account_contact_idx" for table "location"
Password for user postgres:
NOTICE:  CREATE TABLE will create implicit sequence "silo_id_seq" for
serial column "silo.id"
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "silo_pkey"
for table "silo"
Password for user postgres:
NOTICE:  CREATE TABLE will create implicit sequence "dbaliases_id_seq" for
serial column "dbaliases.id"
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index
"dbaliases_pkey" for table "dbaliases"
NOTICE:  CREATE TABLE / UNIQUE will create implicit index
"dbaliases_alias_idx" for table "dbaliases"
Password for user postgres:
NOTICE:  CREATE TABLE will create implicit sequence "uri_id_seq" for serial
column "uri.id"
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "uri_pkey"
for table "uri"
NOTICE:  CREATE TABLE / UNIQUE will create implicit index "uri_account_idx"
for table "uri"
Password for user postgres:
NOTICE:  CREATE TABLE will create implicit sequence
"rtpproxy_sockets_id_seq" for serial column "rtpproxy_sockets.id"
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index
"rtpproxy_sockets_pkey" for table "rtpproxy_sockets"
Password for user postgres:
NOTICE:  CREATE TABLE will create implicit sequence "speed_dial_id_seq" for
serial column "speed_dial.id"
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index
"speed_dial_pkey" for table "speed_dial"
NOTICE:  CREATE TABLE / UNIQUE will create implicit index
"speed_dial_speed_dial_idx" for table "speed_dial"
Password for user postgres:
NOTICE:  CREATE TABLE will create implicit sequence
"usr_preferences_id_seq" for serial column "usr_preferences.id"
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index
"usr_preferences_pkey" for table "usr_preferences"
Password for user postgres:
NOTICE:  CREATE TABLE will create implicit sequence "subscriber_id_seq" for
serial column "subscriber.id"
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index
"subscriber_pkey" for table "subscriber"
NOTICE:  CREATE TABLE / UNIQUE will create implicit index
"subscriber_account_idx" for table "subscriber"
Password for user postgres:
NOTICE:  CREATE TABLE will create implicit sequence "pdt_id_seq" for serial
column "pdt.id"
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "pdt_pkey"
for table "pdt"
NOTICE:  CREATE TABLE / UNIQUE will create implicit index
"pdt_sdomain_prefix_idx" for table "pdt"
Password for user postgres:
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index
"dialog_pkey" for table "dialog"
Pa

[OpenSIPS-Users] [IMPORTANT] Read if you are using TCP/TLS with OpenSIPS 1.11, 1.10 or 1.8

2015-04-21 Thread Liviu Chircu

Hello all,

>>> The following notice concerns _all_ OpenSIPS 1.11, 1.10 and 1.8 
users making use of TCP/TLS listeners <<<


While keeping in mind the goal of offering uniformity amongst all 
supported versions, we decided to push a backwards-incompatible change 
on all supported versions a few weeks ago. Although this might cause 
headaches to the above-mentioned OpenSIPS users (if not already!), we 
feel that these changes will smoothen the transition to the upcoming 
OpenSIPS 2.1, while also acting as a scripting improvement.


The change was committed on April 1, 2015. Really. It will _only_ be 
contained in the upcoming 1.11.5, 1.10.5 and 1.8.8 releases. It is 
basically just a measuring unit change. As such:


- milliseconds instead of seconds for "tcp_connect_timeout" / 
"tcp_send_timeout" [1] (more precision, also acts as a feature)
- milliseconds instead of microseconds for 
"tcp_async_local_connect_timeout" / "tcp_async_local_write_timeout" [2] 
(less precision, but without any costs)
- the official documentation now reflects the new changes! If you're not 
running on latest code (older than april 1), be careful with the 
documentation for the above 4 parameters when setting up your proxies.


We do our best to keep OpenSIPS as backwards-compatible as possible. 
However, sometimes the benefits of doing the opposite outweigh the costs!


[1] http://www.opensips.org/Documentation/Script-CoreParameters-1-11#toc93
[2] http://www.opensips.org/Documentation/Script-CoreParameters-1-11#toc86

Thank you for your understanding,
OpenSIPS team
___
Users mailing list
Users@lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/users