<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>
If your scubscriber list survived an OpenSIPS restart, it
definitly means they were written down in the DB text file.
Otherwise there is no way to be restart persistent.<br>
<br>
Thank you for the hints, we will include them in future docs /
tutorials. Also, the OpenSIPS community will appreciate if you
could write down such a document "how to use dbtext" and make it
public ;)<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 26.01.2015 15:20, P Perazim wrote:<br>
</div>
<blockquote cite="mid:1422278453.54c63f355126e@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>Further progress: Found Tables at
/usr/share/opensips/dbtext/opensips and copied them to
/etc/opensips/dbtext/<br>
<br>
Opensips now starts without errors.<br>
<br>
I see from the docs that any updated dbtext table records are
written only upon exit of opensips. So I subscribed several users
with opensipsctl add username password and exited but found no
changes to table subscribers. Upon starting opwnsips the
subscribers were preserved. But how? I ask as I plan to use this
on openwrt router and need to know where to place the files that
are updated so that flash is not damaged by too many writes.<br>
<br>
Is there anything else I should alter in the migration from mysql
to dbtext?<br>
<br>
<br>
<br>
For those that come after me, it would be helpful to document
these things that I have had to dig out like specific instruction
of how to populate the dbtext tables. Searching I found this:<br>
<br>
<a class="moz-txt-link-freetext" href="https://github.com/OpenSIPS/opensips/blob/master/scripts/opensipsdbctl.dbtext">https://github.com/OpenSIPS/opensips/blob/master/scripts/opensipsdbctl.dbtext</a><br>
<br>
which gave me a clue what was missing however this script was
nowhere to be found on my system nor could I find any reference to
it in the docs.<br>
<br>
Hope this helps.<br>
<br>
Perazim<br>
<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<br>
and update ?<br>
<br>
2) the message is correct. The last "folder" in the path you
provide is<br>
actually the DB name :<br>
<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 ?<br>
<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>