[Spce-user] [EXTERNAL] database error

[Dario Busso]

Deat Pa.
>From the Handbook:
https://www.sipwise.com/doc/mr12.3.1/spce/ce/mr12.3.1/appendices-main/appendices-main.html#_constants_yml_overview
The usage of external DB is not supported for the NGCP CE version.
KR
Dario

On Thu, Jun 13, 2024 at 8:50 AM Pa Ka <pa.ka12 at outlook.com> wrote:

> Hello team,
>
>
>
> Could you please assist me with this ? using mr12.3.1
>
>
>
> In constant.yml file I edit the database as follows:
>
> database:
>
>     local:
>
>         dbhost: IP.address.of.my.db
>
>
>
>
>
> ngcp-update-db-schema save the db scheme to my db server. But doesn’t
> create users. I suppose not even all tables are created.
>
>
>
> ngcp-reset-db returns [ mysqldump: Got error: 2002: "Can't connect to
> server on 'localhost' (111)" when trying to connect ] not sure where
> localhost is coming from. Yet I changed the db host in constant.yml file .
>
>
>
> also, mariadb.cnf, my.cnf, grants.yml both from /etc/mysql have been
> updated. I set mydbip address in those file. But still when I tried to
> create db to my db server by using ngcp-reset-db it returns localhost
> access error, above
>
>
>
> where can I get this db host, what am I doing wrong? thanks
> --
> Spce-user mailing list
> Spce-user at lists.sipwise.com
> http://lists.sipwise.com/mailman/listinfo/spce-user_lists.sipwise.com
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sipwise.com/pipermail/spce-user_lists.sipwise.com/attachments/20240613/d332530c/attachment-0001.htm>