<div dir="ltr"><div><div><div><div>Hi Bogdan,<br><br>Thanks. That took care of it.<br> <br>I have a few more questions:<br><br></div>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.<br></div>2. We are migrating from 1.7 opensips to 1.11.3. Is that the most stable one to migrate too?<br></div>3. I have been able to get the servers up and running on 1.11.3. Is this a production-grade opensips release? <br>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.?<br></div>5. Is there a notls verion of the opensips rpm? I only see the tls rpm for 1.11.3<br><br></div><div class="gmail_extra"><br><div class="gmail_quote">On Tue, Feb 3, 2015 at 12:54 PM, Bogdan-Andrei Iancu <span dir="ltr"><<a href="mailto:bogdan@opensips.org" target="_blank">bogdan@opensips.org</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div text="#000000" bgcolor="#FFFFFF">
<div><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 cols="72">Bogdan-Andrei Iancu
OpenSIPS Founder and Developer
<a href="http://www.opensips-solutions.com" target="_blank">http://www.opensips-solutions.com</a></pre><div><div class="h5">
On 03.02.2015 19:28, Alfred Rudrapati wrote:<br>
</div></div></div>
<blockquote type="cite"><div><div class="h5">
<div dir="ltr">
<p class="MsoNormal">I have 2 issues: </p>
<p class="MsoNormal"> </p>
<p><span><span>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> </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><span><span>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>INFO:core:shm_mem_init</a>: allocating SHM block</p>
<p class="MsoNormal">Feb 3 09:08:19 test_server opensips:
<a>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>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>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>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>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>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>INFO:sl:mod_init</a>: Initializing StateLess engine</p>
<p class="MsoNormal">Feb 3 09:08:19 test_server
/usr/sbin/opensips[14637]:
<a>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>INFO:maxfwd:mod_init</a>: initializing...</p>
<p class="MsoNormal">Feb 3 09:08:19 test_server
/usr/sbin/opensips[14637]:
<a>INFO:textops:mod_init</a>: initializing...</p>
<p class="MsoNormal">Feb 3 09:08:19 test_server
/usr/sbin/opensips[14637]:
<a>INFO:sipmsgops:mod_init</a>: initializing...</p>
<p class="MsoNormal">Feb 3 09:08:19 test_server
/usr/sbin/opensips[14637]:
<a>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>INFO:core:cleanup</a>: cleanup</p>
<p class="MsoNormal">Feb 3 09:08:19 test_server opensips:
<a>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></fieldset>
<br>
</div></div><pre>_______________________________________________
Users mailing list
<a href="mailto:Users@lists.opensips.org" target="_blank">Users@lists.opensips.org</a>
<a href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users" target="_blank">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a>
</pre>
</blockquote>
<br>
</div>
</blockquote></div><br></div>