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

[Alfred Rudrapati]

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>
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 Developerhttp://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 listUsers at lists.opensips.orghttp://lists.opensips.org/cgi-bin/mailman/listinfo/users
>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opensips.org/pipermail/users/attachments/20150204/fa2f1db5/attachment-0001.htm>