<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 Perazim,<br>
<br>
1) I will check the cfg file included in the docs, to be sure
that is up to date. Note you are using the devel version and
things may change here on daily bases.<br>
If you had only errors on "modules not found", it is mainly an
installation issue - you need to adapt the cfg to your
installation path (the correct path to the modules).<br>
<br>
2) ok<br>
<br>
3) you need the "version" table too.<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 25.01.2015 12:55, P Perazim wrote:<br>
</div>
<blockquote cite="mid:1422183350.54c4cbb69df6b@mail.inbox.lt"
type="cite">
<style type="text/css">
/*<![CDATA[*/
blockquote.c1 {border-left: 1px solid #cccccc; margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex}
/*]]>*/
</style> <br>
<br>
<div>Quoting <strong>Bogdan-Andrei Iancu <a
moz-do-not-send="true" href="mailto:bogdan@opensips.org"><bogdan@opensips.org></a></strong>
:</div>
<blockquote class="c1">Hi Perazim,<br>
<br>
The db_text is supported and actively maintained.<br>
<br>
1) Could you point to the docs you found as outdated, so we can
review</blockquote>
<br>
This is the doc I used:<br>
<br>
<a class="moz-txt-link-freetext" href="http://www.opensips.org/html/docs/modules/devel/db_text.html">http://www.opensips.org/html/docs/modules/devel/db_text.html</a><br>
<br>
When I used the sample as a config file I received a lot of errors
and had to edit all the lines referencing modules. It seems that
something new may have been added to opensips in this regards.
Also, I had to add the line to load the signaling module. These
exceptions lead me to ask if perhaps the db_text configuration
examples/instruction may be outdated. As I have never seen a
working config for db_text, I was not sure what could be the
reason this is not working. I have a VERY simple PABX
configuration.
<blockquote class="c1"> <br>
<br>
2) the message is correct. The last "folder" in the path you
provide is<br>
actually the DB name :</blockquote>
<br>
This sheds some light. This explains why the syslog shows
/etc/opensips as the path when I specified /etc/opensips/dbtext.
<blockquote class="c1"> <br>
text:///path/to/dbtext/database<br>
so path is "/etc/opensips" and the name of DB is "dbtext"<br>
<br>
3) what seems to be the part not working ?</blockquote>
<br>
Adjusting the location of the dbtext files, I receive these errors
in the syslog:<br>
<br>
...<br>
Jan 25 12:37:52 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)<br>
Jan 25 12:37:52 server /usr/sbin/opensips[27369]:
NOTICE:core:main: version: opensips 1.7.2-tls (i386/linux)<br>
Jan 25 12:37:52 server /usr/sbin/opensips[27369]: <a class="moz-txt-link-freetext" href="INFO:core:main">INFO:core:main</a>:
using 32 Mb shared memory<br>
Jan 25 12:37:52 server /usr/sbin/opensips[27369]: <a class="moz-txt-link-freetext" href="INFO:core:main">INFO:core:main</a>:
using 2 Mb private memory per process<br>
Jan 25 12:37:52 server /usr/sbin/opensips[27369]:
NOTICE:signaling:mod_init: initializing module ...<br>
Jan 25 12:37:52 server /usr/sbin/opensips[27369]:
<a class="moz-txt-link-freetext" href="INFO:sl:mod_init">INFO:sl:mod_init</a>: Initializing StateLess engine<br>
Jan 25 12:37:52 server /usr/sbin/opensips[27369]:
<a class="moz-txt-link-freetext" href="INFO:tm:mod_init">INFO:tm:mod_init</a>: TM - initializing...<br>
Jan 25 12:37:52 server /usr/sbin/opensips[27369]:
<a class="moz-txt-link-freetext" href="INFO:rr:mod_init">INFO:rr:mod_init</a>: rr - initializing<br>
Jan 25 12:37:52 server /usr/sbin/opensips[27369]:
<a class="moz-txt-link-freetext" href="INFO:maxfwd:mod_init">INFO:maxfwd:mod_init</a>: initializing...<br>
Jan 25 12:37:52 server /usr/sbin/opensips[27369]:
<a class="moz-txt-link-freetext" href="INFO:usrloc:ul_init_locks">INFO:usrloc:ul_init_locks</a>: locks array size 512<br>
Jan 25 12:37:52 server /usr/sbin/opensips[27369]:
<a class="moz-txt-link-freetext" href="INFO:registrar:mod_init">INFO:registrar:mod_init</a>: initializing...<br>
Jan 25 12:37:52 server /usr/sbin/opensips[27369]:
<a class="moz-txt-link-freetext" href="INFO:textops:mod_init">INFO:textops:mod_init</a>: initializing...<br>
Jan 25 12:37:52 server /usr/sbin/opensips[27369]:
<a class="moz-txt-link-freetext" href="INFO:db_text:dbt_init">INFO:db_text:dbt_init</a>: using database at: /etc/opensips/dbtext<br>
Jan 25 12:37:52 server /usr/sbin/opensips[27369]:
ERROR:db_text:dbt_query: table does not exist!<br>
Jan 25 12:37:52 server /usr/sbin/opensips[27369]:
ERROR:core:db_table_version: error in db_query<br>
Jan 25 12:37:52 server /usr/sbin/opensips[27369]:
ERROR:core:db_check_table_version: querying version for table
subscriber<br>
Jan 25 12:37:52 server /usr/sbin/opensips[27369]:
ERROR:uri:mod_init: Invalid table version.<br>
Jan 25 12:37:52 server /usr/sbin/opensips[27369]:
ERROR:core:init_mod: failed to initialize module uri<br>
Jan 25 12:37:52 server /usr/sbin/opensips[27369]: ERROR:core:main:
error while initializing modules<br>
Jan 25 12:37:52 server opensips: <a class="moz-txt-link-freetext" href="INFO:core:daemonize">INFO:core:daemonize</a>: pre-daemon
process exiting with -1<br>
Jan 25 12:40:08 server clamd[2191]: SelfCheck: Database status OK.<br>
...<br>
<br>
Seems that there is a table not found but it doesn't indicated
which one.<br>
<br>
The opensips.cfg and the tables location and subscriber are
attached.<br>
<br>
Thanks for the help.<br>
<br>
Perazim<br>
<br>
<blockquote class="c1"> <br>
Regards,<br>
<br>
Bogdan-Andrei Iancu<br>
OpenSIPS Founder and Developer<br>
<a moz-do-not-send="true" target="_blank"
href="http://www.opensips-solutions.com">http://www.opensips-solutions.com</a><br>
<br>
On 23.01.2015 12:41, P Perazim wrote:<br>
> Been running opensips for several years using<br>
> mysql. Very simple config. No problems.<br>
><br>
> Now I need to make it even simpler and use db_text<br>
> so I can deinstall mysql.<br>
><br>
> Problem is that after looking at the docs and<br>
> examples for db_text I am having no joy getting<br>
> this to work. Seems as though the docs may be out<br>
> of date now. I tried using an opensips.cfg sample<br>
> from the dbtext docs but it produced many errors.<br>
><br>
> So, to start: Is the db_text mode still supported?<br>
> Where are the most current docs and examples?<br>
><br>
> The first thing that errors is that I cannot seem<br>
> to set the location of the db_text files. Using<br>
> db_default_url="text:///etc/opensips/dbtext", the<br>
> syslog shows: <a class="moz-txt-link-freetext" href="INFO:db_text:dbt_init">INFO:db_text:dbt_init</a> using database<br>
> at: /etc/opensips - NOT the location that is set<br>
> with db_default_url="text:///etc/opensips/dbtext"<br>
> Thi8s location exists and two files called<br>
> location and subscriber are there setup as docs<br>
> indicate.<br>
><br>
> Any ideas?<br>
><br>
> Thanks in advance,<br>
><br>
> Perazim<br>
><br>
><br>
> _______________________________________________<br>
> Users mailing list<br>
> <a class="moz-txt-link-abbreviated" href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a><br>
> <a moz-do-not-send="true" target="_blank"
href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a><br>
><br>
<br>
</blockquote>
</blockquote>
<br>
</body>
</html>