<style type="text/css">
/*<![CDATA[*/
blockquote.c1 {border-left: 1px solid #cccccc; margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex}
/*]]>*/
</style> <br /> <br /> <div>Quoting <strong>Bogdan-Andrei Iancu <a href="mailto:bogdan@opensips.org"><bogdan@opensips.org></a></strong> :</div> <blockquote class="c1">Hi Perazim,<br /> <br /> The db_text is supported and actively maintained.<br /> <br /> 1) Could you point to the docs you found as outdated, so we can review</blockquote><br />This is the doc I used:<br /><br />http://www.opensips.org/html/docs/modules/devel/db_text.html<br /><br />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.<blockquote class="c1"> <br /> <br /> 2) the message is correct. The last "folder" in the path you provide is<br /> actually the DB name :</blockquote><br />This sheds some light. This explains why the syslog shows /etc/opensips as the path when I specified /etc/opensips/dbtext. <blockquote class="c1"> <br /> text:///path/to/dbtext/database<br /> so path is "/etc/opensips" and the name of DB is "dbtext"<br /> <br /> 3) what seems to be the part not working ?</blockquote><br />Adjusting the location of the dbtext files, I receive these errors in the syslog:<br /><br />...<br />Jan 25 12:37:52 server opensips: INFO:core:init_tcp: using epoll_lt as the TCP io watch method (auto detected)<br />Jan 25 12:37:52 server /usr/sbin/opensips[27369]: NOTICE:core:main: version: opensips 1.7.2-tls (i386/linux)<br />Jan 25 12:37:52 server /usr/sbin/opensips[27369]: INFO:core:main: using 32 Mb shared memory<br />Jan 25 12:37:52 server /usr/sbin/opensips[27369]: INFO:core:main: using 2 Mb private memory per process<br />Jan 25 12:37:52 server /usr/sbin/opensips[27369]: NOTICE:signaling:mod_init: initializing module ...<br />Jan 25 12:37:52 server /usr/sbin/opensips[27369]: INFO:sl:mod_init: Initializing StateLess engine<br />Jan 25 12:37:52 server /usr/sbin/opensips[27369]: INFO:tm:mod_init: TM - initializing...<br />Jan 25 12:37:52 server /usr/sbin/opensips[27369]: INFO:rr:mod_init: rr - initializing<br />Jan 25 12:37:52 server /usr/sbin/opensips[27369]: INFO:maxfwd:mod_init: initializing...<br />Jan 25 12:37:52 server /usr/sbin/opensips[27369]: INFO:usrloc:ul_init_locks: locks array size 512<br />Jan 25 12:37:52 server /usr/sbin/opensips[27369]: INFO:registrar:mod_init: initializing...<br />Jan 25 12:37:52 server /usr/sbin/opensips[27369]: INFO:textops:mod_init: initializing...<br />Jan 25 12:37:52 server /usr/sbin/opensips[27369]: INFO:db_text:dbt_init: using database at: /etc/opensips/dbtext<br />Jan 25 12:37:52 server /usr/sbin/opensips[27369]: ERROR:db_text:dbt_query: table does not exist!<br />Jan 25 12:37:52 server /usr/sbin/opensips[27369]: ERROR:core:db_table_version: error in db_query<br />Jan 25 12:37:52 server /usr/sbin/opensips[27369]: ERROR:core:db_check_table_version: querying version for table subscriber<br />Jan 25 12:37:52 server /usr/sbin/opensips[27369]: ERROR:uri:mod_init: Invalid table version.<br />Jan 25 12:37:52 server /usr/sbin/opensips[27369]: ERROR:core:init_mod: failed to initialize module uri<br />Jan 25 12:37:52 server /usr/sbin/opensips[27369]: ERROR:core:main: error while initializing modules<br />Jan 25 12:37:52 server opensips: INFO:core:daemonize: pre-daemon process exiting with -1<br />Jan 25 12:40:08 server clamd[2191]: SelfCheck: Database status OK.<br />...<br /><br />Seems that there is a table not found but it doesn't indicated which one.<br /><br />The opensips.cfg and the tables location and subscriber are attached.<br /><br />Thanks for the help.<br /><br />Perazim<br /><br /><blockquote class="c1"> <br /> Regards,<br /> <br /> Bogdan-Andrei Iancu<br /> OpenSIPS Founder and Developer<br /> <a target="_blank" href="http://www.opensips-solutions.com">http://www.opensips-solutions.com</a><br /> <br /> On 23.01.2015 12:41, P Perazim wrote:<br /> > Been running opensips for several years using<br /> > mysql. Very simple config. No problems.<br /> ><br /> > Now I need to make it even simpler and use db_text<br /> > so I can deinstall mysql.<br /> ><br /> > Problem is that after looking at the docs and<br /> > examples for db_text I am having no joy getting<br /> > this to work. Seems as though the docs may be out<br /> > of date now. I tried using an opensips.cfg sample<br /> > from the dbtext docs but it produced many errors.<br /> ><br /> > So, to start: Is the db_text mode still supported?<br /> > Where are the most current docs and examples?<br /> ><br /> > The first thing that errors is that I cannot seem<br /> > to set the location of the db_text files. Using<br /> > db_default_url="text:///etc/opensips/dbtext", the<br /> > syslog shows: INFO:db_text:dbt_init using database<br /> > at: /etc/opensips - NOT the location that is set<br /> > with db_default_url="text:///etc/opensips/dbtext"<br /> > Thi8s location exists and two files called<br /> > location and subscriber are there setup as docs<br /> > indicate.<br /> ><br /> > Any ideas?<br /> ><br /> > Thanks in advance,<br /> ><br /> > Perazim<br /> ><br /> ><br /> > _______________________________________________<br /> > Users mailing list<br /> > Users@lists.opensips.org<br /> > <a target="_blank" href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a><br /> ><br /> <br /></blockquote>