[OpenSIPS-Users] Errors on opensips 1.11.3 (Logging and db_text)

Bogdan-Andrei Iancu bogdan at opensips.org
Wed Feb 4 18:27:47 CET 2015


Hi Alfred,

1) escape the colon when used in data (with \)

2) latest 1.11 is the stable one

3) yes, all stable releases are production ready.

4) no, there are no official numbers, but you should look also at new 
features or improvements. For each version you have a page listing the news:
     http://www.opensips.org/About/Version-1-11-0
     http://www.opensips.org/About/Version-1-10-0
     ....

Regards,

Bogdan-Andrei Iancu
OpenSIPS Founder and Developer
http://www.opensips-solutions.com

On 04.02.2015 17:30, Alfred Rudrapati 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 
> <bogdan at opensips.org <mailto:bogdan at 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
>>
>>     Feb  3 09:08:19 test_server /usr/sbin/opensips[14637]:
>>     INFO:core:cleanup: cleanup
>>
>>     Feb  3 09:08:19 test_server opensips: INFO:core:daemonize:
>>     pre-daemon process exiting with -1
>>
>>     Snipped from my opensips.cfg:
>>
>>     loadmodule "db_text.so"
>>
>>     modparam("db_text", "db_mode", 1)
>>
>>     modparam("dispatcher", "db_url", "text:///tmp/opensipsdb")
>>
>>     /tmp/opensipsdb has a chmod of 777:
>>
>>     drwxrwxrwx 2 root root           4096 Feb  3 09:07 opensipsdb
>>
>>     my test dispatcher file:
>>
>>     [root@ test_server tmp]# ls -ltr opensipsdb/dispatcher
>>
>>     -rw-r--r-- 1 root root 218 Feb  3 09:13 opensipsdb/dispatcher
>>
>>     [root@ test_server tmp]# cat opensipsdb/dispatcher
>>
>>     id(int,auto) setid(int) destination(string) socket(string,null)
>>     state(int) weight(int) attrs(string) description(string)
>>
>>     1:1:sip\:1.2.3.4\:5060:null:0:51:line1:server11
>>
>>     2:1:sip\:1.2.3.4\:5070:null:0:49:line2:server12
>>
>>     Any help/direction is appreciated.
>>
>>
>>
>>     _______________________________________________
>>     Users mailing list
>>     Users at lists.opensips.org  <mailto:Users at lists.opensips.org>
>>     http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>
>

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opensips.org/pipermail/users/attachments/20150204/6c2be91a/attachment.htm>


More information about the Users mailing list