<html>
<head>
<meta content="text/html; charset=utf-8" http-equiv="Content-Type">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<div class="moz-cite-prefix"><tt>Hi Alfred,<br>
<br>
1) escape the colon when used in data (with \)<br>
<br>
2) latest 1.11 is the stable one<br>
<br>
3) yes, all stable releases are production ready.<br>
<br>
4) no, there are no official numbers, but you should look also
at new features or improvements. For each version you have a
page listing the news:<br>
<a class="moz-txt-link-freetext" href="http://www.opensips.org/About/Version-1-11-0">http://www.opensips.org/About/Version-1-11-0</a><br>
<a class="moz-txt-link-freetext" href="http://www.opensips.org/About/Version-1-10-0">http://www.opensips.org/About/Version-1-10-0</a><br>
....<br>
<br>
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 04.02.2015 17:30, Alfred Rudrapati wrote:<br>
</div>
<blockquote
cite="mid:CADqT73oFRvA27bo2On8cJH4ciZW11e-_RAKi2oS119+07U+Q+Q@mail.gmail.com"
type="cite">
<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
moz-do-not-send="true" 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 moz-do-not-send="true" 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 moz-do-not-send="true">INFO:core:shm_mem_init</a>:
allocating SHM block</p>
<p class="MsoNormal">Feb 3 09:08:19 test_server
opensips: <a moz-do-not-send="true">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
moz-do-not-send="true">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
moz-do-not-send="true">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
moz-do-not-send="true">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
moz-do-not-send="true">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
moz-do-not-send="true">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
moz-do-not-send="true">INFO:sl:mod_init</a>:
Initializing StateLess engine</p>
<p class="MsoNormal">Feb 3 09:08:19 test_server
/usr/sbin/opensips[14637]: <a
moz-do-not-send="true">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
moz-do-not-send="true">INFO:maxfwd:mod_init</a>:
initializing...</p>
<p class="MsoNormal">Feb 3 09:08:19 test_server
/usr/sbin/opensips[14637]: <a
moz-do-not-send="true">INFO:textops:mod_init</a>:
initializing...</p>
<p class="MsoNormal">Feb 3 09:08:19 test_server
/usr/sbin/opensips[14637]: <a
moz-do-not-send="true">INFO:sipmsgops:mod_init</a>:
initializing...</p>
<p class="MsoNormal">Feb 3 09:08:19 test_server
/usr/sbin/opensips[14637]: <a
moz-do-not-send="true">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
moz-do-not-send="true">INFO:core:cleanup</a>:
cleanup</p>
<p class="MsoNormal">Feb 3 09:08:19 test_server
opensips: <a moz-do-not-send="true">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 moz-do-not-send="true" href="mailto:Users@lists.opensips.org" target="_blank">Users@lists.opensips.org</a>
<a moz-do-not-send="true" 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>
</blockquote>
<br>
</body>
</html>