[OpenSIPS-Users] problem getting db_text to work

[Bogdan-Andrei Iancu]

Hi Perazim,

Once again ,we will fix those examples - the correct table definition 
can be fund in scripts/dbtext/opensips folder (if using sources) or
/usr/share/opensips folder (is installed from packages).

Regards,

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

On 25.01.2015 14:32, P Perazim wrote:
> Followup.
>
> Referencing 
> http://www.opensips.org/html/docs/modules/devel/db_text.html  sp 
> examples 1.1, 1.2 1.3 => these appear to not be the only tables 
> required. I further reference 1.6, 1.7, 1.8. The definitions for 
> tables subscriber and location are not the same. Which ones should I use?
>
> When adding the version table as in example 1.8, I receive the 
> following error in syslog: Error:core:db_check_table_version: invalid 
> version  3 for table subscriber found, expected 7.
>
> Thanks,
>
> 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/f0f43f75/attachment-0001.htm>