<html>
<head>
<meta content="text/html; charset=windows-1252"
http-equiv="Content-Type">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<div class="moz-cite-prefix"><tt>Hi Alfred,<br>
<br>
1) I suspect a configuration issue with your syslog daemon -
maybe the debug level is skipped for default log file.<br>
<br>
2) in </tt><tt>/tmp/opensipsdb you need to have the "version"
table too.<br>
<br>
Best regards,<br>
</tt>
<pre class="moz-signature" cols="72">Bogdan-Andrei Iancu
OpenSIPS Founder and Developer
<a class="moz-txt-link-freetext" href="http://www.opensips-solutions.com">http://www.opensips-solutions.com</a></pre>
On 03.02.2015 19:28, Alfred Rudrapati wrote:<br>
</div>
<blockquote
cite="mid:CADqT73pA8dzS8YJD=5qqRBPv28jD_u12_gfFjN6hLKNb8p5N7A@mail.gmail.com"
type="cite">
<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:
<a class="moz-txt-link-freetext" href="INFO:core:shm_mem_init">INFO:core:shm_mem_init</a>: allocating SHM block</p>
<p class="MsoNormal">Feb 3 09:08:19 test_server opensips:
<a class="moz-txt-link-freetext" href="INFO:core:init_tcp">INFO:core:init_tcp</a>: 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]:
<a class="moz-txt-link-freetext" href="INFO:core:main">INFO:core:main</a>: using 32 Mb shared memory</p>
<p class="MsoNormal">Feb 3 09:08:19 test_server
/usr/sbin/opensips[14637]:
<a class="moz-txt-link-freetext" href="INFO:core:main">INFO:core:main</a>: using 2 Mb private memory per process</p>
<p class="MsoNormal">Feb 3 09:08:19 test_server
/usr/sbin/opensips[14637]:
<a class="moz-txt-link-freetext" href="INFO:core:evi_publish_event">INFO:core:evi_publish_event</a>: Registered event
<E_CORE_THRESHOLD(0)></p>
<p class="MsoNormal">Feb 3 09:08:19 test_server
/usr/sbin/opensips[14637]:
<a class="moz-txt-link-freetext" href="INFO:core:evi_publish_event">INFO:core:evi_publish_event</a>: Registered event
<E_CORE_SHM_THRESHOLD(1)></p>
<p class="MsoNormal">Feb 3 09:08:19 test_server
/usr/sbin/opensips[14637]:
<a class="moz-txt-link-freetext" href="INFO:core:evi_publish_event">INFO:core:evi_publish_event</a>: Registered event
<E_CORE_PKG_THRESHOLD(2)></p>
<p class="MsoNormal">Feb 3 09:08:19 test_server
/usr/sbin/opensips[14637]:
<a class="moz-txt-link-freetext" href="INFO:sl:mod_init">INFO:sl:mod_init</a>: Initializing StateLess engine</p>
<p class="MsoNormal">Feb 3 09:08:19 test_server
/usr/sbin/opensips[14637]:
<a class="moz-txt-link-freetext" href="INFO:tm:mod_init">INFO:tm:mod_init</a>: 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]:
<a class="moz-txt-link-freetext" href="INFO:maxfwd:mod_init">INFO:maxfwd:mod_init</a>: initializing...</p>
<p class="MsoNormal">Feb 3 09:08:19 test_server
/usr/sbin/opensips[14637]:
<a class="moz-txt-link-freetext" href="INFO:textops:mod_init">INFO:textops:mod_init</a>: initializing...</p>
<p class="MsoNormal">Feb 3 09:08:19 test_server
/usr/sbin/opensips[14637]:
<a class="moz-txt-link-freetext" href="INFO:sipmsgops:mod_init">INFO:sipmsgops:mod_init</a>: initializing...</p>
<p class="MsoNormal">Feb 3 09:08:19 test_server
/usr/sbin/opensips[14637]:
<a class="moz-txt-link-freetext" href="INFO:db_text:dbt_init">INFO:db_text:dbt_init</a>: 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]:
<a class="moz-txt-link-freetext" href="INFO:core:cleanup">INFO:core:cleanup</a>: cleanup</p>
<p class="MsoNormal">Feb 3 09:08:19 test_server opensips:
<a class="moz-txt-link-freetext" href="INFO:core:daemonize">INFO:core:daemonize</a>:
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>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
Users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a>
<a class="moz-txt-link-freetext" href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a>
</pre>
</blockquote>
<br>
</body>
</html>