[OpenSIPS-Users] I am facing some issue while creating DB through opensips-cli .

[Sasmita Panda]

Hi ,

>> cat default.cfg
[default]
log_level: WARNING
prompt_name: opensips-cli
prompt_intro: Welcome to OpenSIPS Command Line Interface!
prompt_emptyline_repeat_cmd: False
history_file: ~/.opensips-cli.history
history_file_size: 1000
output_type: pretty-print
communication_type: fifo
fifo_file: /tmp/opensips_fifo
database_modules: All
database_admin_url: mysql://root:cccl0g1c@localhost/opensips
database_url:  mysql://opensips:opensipsrw@localhost
database_schema_path: ./opt/opensips-3.1/scripts

I have configured this under default.cfg file .
When I am creating a database it creates only 27 tables .

database_modules: ALL . What does this mean? I think it must create
table for all the modules loaded .
Isn't it so ?


*Thanks & Regards*
*Sasmita Panda*
*Senior Network Testing and Software Engineer*
*3CLogic , ph:07827611765*


On Fri, Nov 20, 2020 at 3:07 PM Liviu Chircu <liviu at opensips.org> wrote:

> On 20.11.2020 09:29, Sasmita Panda wrote:
> >
> > [default]
> > database_modules: All
> > [mysql]
> > database_admin_url: mysql://root:cccl0g1c@localhost/opensips
> > database_url:  mysql://opensips:opensipsrw@localhost
> > database_schema_path: ./opt/opensips-3.1/scripts
>
> Hi, Sasmita?
>
> What blog post did you get this example from?  This "smart" example was
> fixed at some point because it was misleading developers, but I'm afraid
> it got copy-pasted on a few blogs and is now still spreading... Please
> read the revised examples in the Database module documentation [1].
> Maybe re-read it from the beginning :)
>
> TL;DR: in your .cfg file, the [mysql] tag defines a separate
> opensips-cli instance, not a DB module property!  So please avoid this
> technique and set all of your options under the [default] tag.
>
> Best regards,
>
> [1]:
>
> https://github.com/OpenSIPS/opensips-cli/blob/master/docs/modules/database.md#database-management
>
> --
> Liviu Chircu
> www.twitter.com/liviuchircu | www.opensips-solutions.com
>
>
> _______________________________________________
> 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/20201120/856c1bfd/attachment.html>