<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>
Each table used by OpenSIPS has its own version. So, for each
table, you need to have the corresponding record in the
"version" table. The version table for dbtext comes
pre-populated with all the tables.<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 20:45, Alfred Rudrapati wrote:<br>
</div>
<blockquote
cite="mid:CADqT73q-DaQKS5egrJ60JmW9nV73d0gvtB1HzGTV52bjRehsWQ@mail.gmail.com"
type="cite">
<div dir="ltr">
<div>
<div>Thanks Bogdan.<br>
<br>
</div>
You said initially that I need a version table too. How do I
decide the contents and the values in it?<br>
<br>
</div>
Is there a document/link for me to catch up?<br>
</div>
<div class="gmail_extra"><br>
<div class="gmail_quote">On Wed, Feb 4, 2015 at 10:30 AM, Alfred
Rudrapati <span dir="ltr"><<a moz-do-not-send="true"
href="mailto:alfred5432@gmail.com" target="_blank">alfred5432@gmail.com</a>></span>
wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0
.8ex;border-left:1px #ccc solid;padding-left:1ex">
<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="HOEnZb">
<div class="h5">
<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> On 03.02.2015 19:28, Alfred Rudrapati
wrote:<br>
</div>
</div>
</div>
<blockquote type="cite">
<div>
<div>
<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>
</div>
</div>
</blockquote>
</div>
<br>
</div>
</blockquote>
<br>
</body>
</html>