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

[Alfred Rudrapati]

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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opensips.org/pipermail/users/attachments/20150203/70d2bc3c/attachment.htm>