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

[Sasmita Panda]

DEBUG: DB 'opensips' exists
DEBUG: Creating standard tables
DEBUG: checking tables: acc alias_db auth_db avpops clusterer dialog
dialplan dispatcher domain drouting group load_balancer msilo permissions
rtpproxy rtpengine speeddial tls_mgm usrloc
INFO: Running standard-create.sql...
INFO: Running acc-create.sql...
INFO: Running alias_db-create.sql...
INFO: Running auth_db-create.sql...
INFO: Running avpops-create.sql...
INFO: Running clusterer-create.sql...
INFO: Running dialog-create.sql...
INFO: Running dialplan-create.sql...
INFO: Running dispatcher-create.sql...
INFO: Running domain-create.sql...
INFO: Running drouting-create.sql...
INFO: Running group-create.sql...
INFO: Running load_balancer-create.sql...
INFO: Running msilo-create.sql...
INFO: Running permissions-create.sql...
INFO: Running rtpproxy-create.sql...
INFO: Running rtpengine-create.sql...
INFO: Running speeddial-create.sql...
INFO: Running tls_mgm-create.sql...
INFO: Running usrloc-create.sql...


Yes , I have checked mysql . There is also only 27 tables created .

mysql> show tables;
+--------------------+
| Tables_in_opensips |
+--------------------+
| acc                |
| address            |
| clusterer          |
| dbaliases          |
| dialog             |
| dialplan           |
| dispatcher         |
| domain             |
| dr_carriers        |
| dr_gateways        |
| dr_groups          |
| dr_partitions      |
| dr_rules           |
| grp                |
| load_balancer      |
| location           |
| missed_calls       |
| re_grp             |
| rtpengine          |
| rtpproxy_sockets   |
| silo               |
| speed_dial         |
| subscriber         |
| tls_mgm            |
| uri                |
| usr_preferences    |
| version            |
+--------------------+
27 rows in set (0.00 sec)

:( :( :(

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


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

> On 20.11.2020 12:16, Sasmita Panda wrote:
>
> 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 ?
>
> I've no idea why it behaves like this.  With "ALL", it should create 67
> tables, not 27.  Can you post the output?
>
> Also, could you manually check your database afterwards and confirm it
> contains 27 tables?
>
> Thanks,
>
> --
> Liviu Chircuwww.twitter.com/liviuchircu | www.opensips-solutions.com
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opensips.org/pipermail/users/attachments/20201120/b196eb37/attachment.html>