[OpenSIPS-Users] Query regarding db_text.

[Bogdan-Andrei Iancu]

Woow...1.6.....that's the grandpa OpenSIPS...even 1.11 is no longer 
maintain. I strongly suggest to try to move to the 2.2 versions.

Still, to shortly answer to your question - I assume you add the lcr and 
gw via the opensipsctl tool, right ? if so, maybe the path to the DBTEXT 
database (as configured in opensipsctl) is different from the path to 
the DB you created .. The CTL use default 
/usr/share/local/opensips/dbtext/opensips, while you want 
/usr/local/etc/opensips/opensips

Regards,

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

OpenSIPS Bootcamp 2017, Houston, US
   http://opensips.org/training/OpenSIPS_Bootcamp_2017.html

On 06/29/2017 12:44 PM, Sasmita Panda wrote:
> Hi ,
>
>    I was in hurry . So I moved to opensips-1.6 . I am successfully 
> installed and configured .
>
>    But still I am facing some other issue here . I have created 
> database in " /usr/local/etc/opensips/opensips " directory .
>    When I am adding lcr and gw table entry . its getting added in 
> different path  " /usr/share/local/opensips/dbtext/opensips"
>
>    Then I changed the path to the latter one . for lcr and gw the 
> entry get added in the file . But its not working as expected .
>
>    What should I do  ?
>
>
> */Thanks & Regards/*
> /Sasmita Panda/
> /Network Testing and Software Engineer/
> /3CLogic , ph:07827611765/
>
> On Thu, Jun 29, 2017 at 2:48 PM, Bogdan-Andrei Iancu 
> <bogdan at opensips.org <mailto:bogdan at opensips.org>> wrote:
>
>     Hi Sasmita,
>
>     Could you check in the file
>     /usr/local/lib[64]/opensips/opensipsctl/opensipsdbctl.base and
>     post here the EXTRA_TABLES definition (should be line 30) ?
>
>     Regards,
>
>     Bogdan-Andrei Iancu
>        OpenSIPS Founder and Developer
>        http://www.opensips-solutions.com <http://www.opensips-solutions.com>
>
>     OpenSIPS Bootcamp 2017, Houston, US
>        http://opensips.org/training/OpenSIPS_Bootcamp_2017.html
>     <http://opensips.org/training/OpenSIPS_Bootcamp_2017.html>
>
>     On 06/28/2017 03:58 PM, Sasmita Panda wrote:
>>     Hi All,
>>            I am trying to use db_text module of opensips-1.11 . While
>>     creating DB , its giving error .
>>     [root at 2e922d8237f4 opensips]# /usr/local/sbin/opensipsdbctl
>>     create opensips
>>     INFO: creating DBTEXT tables at: opensips ...
>>     Install presence related tables? (y/n): y
>>     INFO: creating DBTEXT presence tables at: opensips ...
>>     Install tables for imc cpl siptrace domainpolicy carrierroute
>>     userblacklist b2b registrant call_center? (y/n): y
>>     INFO: creating DBTEXT extra tables at: opensips ...
>>     cp: cannot stat
>>     '/usr/local//share/opensips//dbtext/opensips/call_center': No
>>     such file or directory
>>     ERROR: Creating extra tables failed!
>>     What should I do to solve the problem ? Its not creating all the
>>     tables . Please help me .
>>     */Thanks & Regards/*
>>     /Sasmita Panda/
>>     /Network Testing and Software Engineer/
>>     /3CLogic , ph:07827611765/
>>
>>     _______________________________________________
>>     Users mailing list
>>     Users at lists.opensips.org <mailto:Users at lists.opensips.org>
>>     http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>>     <http://lists.opensips.org/cgi-bin/mailman/listinfo/users>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opensips.org/pipermail/users/attachments/20170629/a6ceee6d/attachment-0001.html>