[OpenSIPS-Users] problem getting db_text to work

[Bogdan-Andrei Iancu]

Hi Perazim,

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

2) ok

3) you need the "version" table too.

Regards,

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

On 25.01.2015 12:55, P Perazim wrote:
>
>
> 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
>
>
> This is the doc I used:
>
> http://www.opensips.org/html/docs/modules/devel/db_text.html
>
> 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.
>
>
>
>     2) the message is correct. The last "folder" in the path you
>     provide is
>     actually the DB name :
>
>
> This sheds some light. This explains why the syslog shows 
> /etc/opensips as the path when I specified /etc/opensips/dbtext.
>
>
>     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 ?
>
>
> Adjusting the location of the dbtext files, I receive these errors in 
> the syslog:
>
> ...
> Jan 25 12:37:52 server opensips: INFO:core:init_tcp: using epoll_lt as 
> the TCP io watch method (auto detected)
> Jan 25 12:37:52 server /usr/sbin/opensips[27369]: NOTICE:core:main: 
> version: opensips 1.7.2-tls (i386/linux)
> Jan 25 12:37:52 server /usr/sbin/opensips[27369]: INFO:core:main: 
> using 32 Mb shared memory
> Jan 25 12:37:52 server /usr/sbin/opensips[27369]: INFO:core:main: 
> using 2 Mb private memory per process
> Jan 25 12:37:52 server /usr/sbin/opensips[27369]: 
> NOTICE:signaling:mod_init: initializing module ...
> Jan 25 12:37:52 server /usr/sbin/opensips[27369]: INFO:sl:mod_init: 
> Initializing StateLess engine
> Jan 25 12:37:52 server /usr/sbin/opensips[27369]: INFO:tm:mod_init: TM 
> - initializing...
> Jan 25 12:37:52 server /usr/sbin/opensips[27369]: INFO:rr:mod_init: rr 
> - initializing
> Jan 25 12:37:52 server /usr/sbin/opensips[27369]: 
> INFO:maxfwd:mod_init: initializing...
> Jan 25 12:37:52 server /usr/sbin/opensips[27369]: 
> INFO:usrloc:ul_init_locks: locks array size 512
> Jan 25 12:37:52 server /usr/sbin/opensips[27369]: 
> INFO:registrar:mod_init: initializing...
> Jan 25 12:37:52 server /usr/sbin/opensips[27369]: 
> INFO:textops:mod_init: initializing...
> Jan 25 12:37:52 server /usr/sbin/opensips[27369]: 
> INFO:db_text:dbt_init: using database at: /etc/opensips/dbtext
> Jan 25 12:37:52 server /usr/sbin/opensips[27369]: 
> ERROR:db_text:dbt_query: table does not exist!
> Jan 25 12:37:52 server /usr/sbin/opensips[27369]: 
> ERROR:core:db_table_version: error in db_query
> Jan 25 12:37:52 server /usr/sbin/opensips[27369]: 
> ERROR:core:db_check_table_version: querying version for table subscriber
> Jan 25 12:37:52 server /usr/sbin/opensips[27369]: ERROR:uri:mod_init: 
> Invalid table version.
> Jan 25 12:37:52 server /usr/sbin/opensips[27369]: ERROR:core:init_mod: 
> failed to initialize module uri
> Jan 25 12:37:52 server /usr/sbin/opensips[27369]: ERROR:core:main: 
> error while initializing modules
> Jan 25 12:37:52 server opensips: INFO:core:daemonize: pre-daemon 
> process exiting with -1
> Jan 25 12:40:08 server clamd[2191]: SelfCheck: Database status OK.
> ...
>
> Seems that there is a table not found but it doesn't indicated which one.
>
> The opensips.cfg and the tables location and subscriber are attached.
>
> Thanks for the help.
>
> Perazim
>
>
>     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/fef7ef0d/attachment.htm>