[OpenSIPS-Users] problem getting db_text to work

[Bogdan-Andrei Iancu]

Hi Perazim,

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.

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 ;)

Regards,

Bogdan-Andrei Iancu
OpenSIPS Founder and Developer
http://www.opensips-solutions.com

On 26.01.2015 15:20, P Perazim wrote:
> Further progress: Found Tables at /usr/share/opensips/dbtext/opensips 
> and copied them to /etc/opensips/dbtext/
>
> Opensips now starts without errors.
>
> 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.
>
> Is there anything else I should alter in the migration from mysql to 
> dbtext?
>
>
>
> 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:
>
> https://github.com/OpenSIPS/opensips/blob/master/scripts/opensipsdbctl.dbtext
>
> 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.
>
> Hope this helps.
>
> Perazim
>
>
> Quoting *Bogdan-Andrei Iancu <bogdan at opensips.org> 
> <mailto:bogdan at opensips.org>* :
>
>     Hi Perazim,
>
>     The db_text is supported and actively maintained.
>
>     1) Could you point to the docs you found as outdated, so we can review
>     and update ?
>
>     2) the message is correct. The last "folder" in the path you
>     provide is
>     actually the DB name :
>
>     text:///path/to/dbtext/database
>     so path is "/etc/opensips" and the name of DB is "dbtext"
>
>     3) what seems to be the part not working ?
>
>     Regards,
>
>     Bogdan-Andrei Iancu
>     OpenSIPS Founder and Developer
>     http://www.opensips-solutions.com
>
>     On 23.01.2015 12:41, P Perazim wrote:
>     > Been running opensips for several years using
>     > mysql. Very simple config. No problems.
>     >
>     > Now I need to make it even simpler and use db_text
>     > so I can deinstall mysql.
>     >
>     > Problem is that after looking at the docs and
>     > examples for db_text I am having no joy getting
>     > this to work. Seems as though the docs may be out
>     > of date now. I tried using an opensips.cfg sample
>     > from the dbtext docs but it produced many errors.
>     >
>     > So, to start: Is the db_text mode still supported?
>     > Where are the most current docs and examples?
>     >
>     > The first thing that errors is that I cannot seem
>     > to set the location of the db_text files. Using
>     > db_default_url="text:///etc/opensips/dbtext", the
>     > syslog shows: INFO:db_text:dbt_init using database
>     > at: /etc/opensips - NOT the location that is set
>     > with db_default_url="text:///etc/opensips/dbtext"
>     > Thi8s location exists and two files called
>     > location and subscriber are there setup as docs
>     > indicate.
>     >
>     > Any ideas?
>     >
>     > Thanks in advance,
>     >
>     > Perazim
>     >
>     >
>     > _______________________________________________
>     > Users mailing list
>     > Users at lists.opensips.org
>     > http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>     >
>

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opensips.org/pipermail/users/attachments/20150126/d56c52d3/attachment.htm>