[OpenSIPS-Users] opensips-cli permissions problem on database creation

[Jeff Pyle]

No customizations to any opensips-cli.cfg anywhere.  It doesn't exist on
this system.

MariaDB [(none)]> create user `opensips`@`localhost` identified by
'opensipsrw';
Query OK, 0 rows affected (0.001 sec)

MariaDB [(none)]> grant all privileges on opensips.* to
`opensips`@`localhost`;
Query OK, 0 rows affected (0.001 sec)

MariaDB [(none)]> quit
Bye
root at opensips:~# opensips-cli -x database create
Password for admin MySQL user (root):
INFO: connected to DB, 'opensips' user is already created
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...

That's better.  Looks like it does just fine on Debian 10 with the
exception of the user creation.

I connected to my training VM, did a dump of the mysql table, and tried to
use the INSERT it created for the opensips at localhost user directly on my
local database.  It said the number of columns didn't match up.  So,
something has definitely changed between MariaDB 10.1.45 and 10.3.23.
Perhaps that's related to the opensips-cli failure.


- Jeff


On Thu, Sep 17, 2020 at 8:21 AM Liviu Chircu <liviu at opensips.org> wrote:

> On 17.09.2020 15:18, Liviu Chircu wrote:
> > By default, the CLI should create the DB without requiring any config
> > file customizations.
>
> For the sake of completeness, it should also create the
> "opensips:opensipsrw" user.
>
> --
> 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/20200917/d4f6c408/attachment-0001.html>