<div dir="ltr">
<p class="MsoNormal">I have 2 issues: </p>
<p class="MsoNormal"> </p>
<p class="" style><span style><span style>1.<span style="font:7pt "Times New Roman"">
</span></span></span>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.</p>
<p class=""> </p>
<p class="MsoNormal">debug=6</p>
<p class="MsoNormal">log_stderror=no</p>
<p class="MsoNormal">log_facility=LOG_LOCAL0</p>
<p class="MsoNormal"> </p>
<p class="MsoNormal"> </p>
<p class="" style><span style><span style>2.<span style="font:7pt "Times New Roman"">
</span></span></span>I am trying to use the dbtext module and
Here is the error I get:</p>
<p class="MsoNormal"> </p>
<p class="MsoNormal">Stopping opensips: not
running
[WARNING]</p>
<p class="MsoNormal">Starting
opensips:
[FAILED]</p>
<p class="MsoNormal"> </p>
<p class="MsoNormal">Feb 3 09:08:19 test_server opensips:
INFO:core:shm_mem_init: allocating SHM block</p>
<p class="MsoNormal">Feb 3 09:08:19 test_server opensips:
INFO:core:init_tcp: using epoll_lt as the TCP io watch method (auto detected)</p>
<p class="MsoNormal">Feb 3 09:08:19 test_server /usr/sbin/opensips[14637]:
NOTICE:core:main: version: opensips 1.11.3-tls (x86_64/linux)</p>
<p class="MsoNormal">Feb 3 09:08:19 test_server /usr/sbin/opensips[14637]:
INFO:core:main: using 32 Mb shared memory</p>
<p class="MsoNormal">Feb 3 09:08:19 test_server /usr/sbin/opensips[14637]:
INFO:core:main: using 2 Mb private memory per process</p>
<p class="MsoNormal">Feb 3 09:08:19 test_server /usr/sbin/opensips[14637]:
INFO:core:evi_publish_event: Registered event <E_CORE_THRESHOLD(0)></p>
<p class="MsoNormal">Feb 3 09:08:19 test_server /usr/sbin/opensips[14637]:
INFO:core:evi_publish_event: Registered event <E_CORE_SHM_THRESHOLD(1)></p>
<p class="MsoNormal">Feb 3 09:08:19 test_server /usr/sbin/opensips[14637]:
INFO:core:evi_publish_event: Registered event <E_CORE_PKG_THRESHOLD(2)></p>
<p class="MsoNormal">Feb 3 09:08:19 test_server /usr/sbin/opensips[14637]:
INFO:sl:mod_init: Initializing StateLess engine</p>
<p class="MsoNormal">Feb 3 09:08:19 test_server /usr/sbin/opensips[14637]:
INFO:tm:mod_init: TM - initializing...</p>
<p class="MsoNormal">Feb 3 09:08:19 test_server /usr/sbin/opensips[14637]:
NOTICE:signaling:mod_init: initializing module ...</p>
<p class="MsoNormal">Feb 3 09:08:19 test_server /usr/sbin/opensips[14637]:
INFO:maxfwd:mod_init: initializing...</p>
<p class="MsoNormal">Feb 3 09:08:19 test_server /usr/sbin/opensips[14637]:
INFO:textops:mod_init: initializing...</p>
<p class="MsoNormal">Feb 3 09:08:19 test_server /usr/sbin/opensips[14637]:
INFO:sipmsgops:mod_init: initializing...</p>
<p class="MsoNormal">Feb 3 09:08:19 test_server /usr/sbin/opensips[14637]:
INFO:db_text:dbt_init: using database at: /tmp/opensipsdb</p>
<p class="MsoNormal">Feb 3 09:08:19 test_server /usr/sbin/opensips[14637]:
ERROR:db_text:dbt_query: table does not exist!</p>
<p class="MsoNormal">Feb 3 09:08:19 test_server /usr/sbin/opensips[14637]:
ERROR:core:db_table_version: error in db_query</p>
<p class="MsoNormal">Feb 3 09:08:19 test_server /usr/sbin/opensips[14637]:
ERROR:dispatcher:init_ds_db: failed to query table version</p>
<p class="MsoNormal">Feb 3 09:08:19 test_server /usr/sbin/opensips[14637]:
ERROR:dispatcher:mod_init: failed to init database support</p>
<p class="MsoNormal">Feb 3 09:08:19 test_server /usr/sbin/opensips[14637]:
ERROR:core:init_mod: failed to initialize module dispatcher</p>
<p class="MsoNormal">Feb 3 09:08:19 test_server /usr/sbin/opensips[14637]:
ERROR:core:main: error while initializing modules</p>
<p class="MsoNormal">Feb 3 09:08:19 test_server /usr/sbin/opensips[14637]:
INFO:core:cleanup: cleanup</p>
<p class="MsoNormal">Feb 3 09:08:19 test_server opensips: INFO:core:daemonize:
pre-daemon process exiting with -1</p>
<p class="MsoNormal"> </p>
<p class="MsoNormal">Snipped from my opensips.cfg:</p>
<p class="MsoNormal">loadmodule "db_text.so"</p>
<p class="MsoNormal">modparam("db_text", "db_mode", 1)</p>
<p class="MsoNormal">modparam("dispatcher", "db_url",
"text:///tmp/opensipsdb")</p>
<p class="MsoNormal"> </p>
<p class="MsoNormal">/tmp/opensipsdb has a chmod of 777:</p>
<p class="MsoNormal">drwxrwxrwx 2 root
root 4096 Feb
3 09:07 opensipsdb</p>
<p class="MsoNormal"> </p>
<p class="MsoNormal">my test dispatcher file:</p>
<p class="MsoNormal">[root@ test_server tmp]# ls -ltr opensipsdb/dispatcher</p>
<p class="MsoNormal">-rw-r--r-- 1 root root 218 Feb 3 09:13
opensipsdb/dispatcher</p>
<p class="MsoNormal">[root@ test_server tmp]# cat opensipsdb/dispatcher</p>
<p class="MsoNormal">id(int,auto) setid(int) destination(string)
socket(string,null) state(int) weight(int) attrs(string) description(string)</p>
<p class="MsoNormal">1:1:sip\:1.2.3.4\:5060:null:0:51:line1:server11</p>
<p class="MsoNormal">2:1:sip\:1.2.3.4\:5070:null:0:49:line2:server12</p>
<p class="MsoNormal"> </p>
<p class="MsoNormal">Any help/direction is appreciated.</p>
<p class="MsoNormal"> </p>
<p class="MsoNormal"> </p>
<p class="MsoNormal"> </p>
</div>