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