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