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 <[email protected]> :
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
> [email protected]
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>
_______________________________________________ Users mailing list [email protected] http://lists.opensips.org/cgi-bin/mailman/listinfo/users
