[Spce-user] after db restore - DB provisioning access denied

[Alex Lutay]

Hi,

Please always reply to spce-user@ mailing list.
Sipwise doesn't provide direct support for CE user.

JFYI, ngcp-backup component is available for PRO/Carrier platforms only.
There you can perform everything out of the box in several "clicks".

The message means user 'sipwise at localhost' should exist in mysql now:

> [defaults.sipwise.localhost]
> flush privileges
>   revoke all from: sipwise at localhost
>   grant all privileges on *.* to sipwise at localhost with grant option
>   drop: soap at localhost
>   flush privileges

Can you re-check this locally?

Also try to connect manually:

> source /etc/mysql/sipwise.cnf && \
> mysql -usipwise -p"${SIPWISE_DB_PASSWORD}" -hlocalhost -P3306 provisioning

Also try to use mysql socket directly (mysql client connect the server
using socket /var/run/mysqld/mysqld.sock instead of TCP connection if
host is 'localhost'):

> source /etc/mysql/sipwise.cnf && \
> mysql -usipwise -p"${SIPWISE_DB_PASSWORD}" provisioning

Check mysql error log file /var/log/mysql/mysqld.err for the reason of
rejects here.

BTW, what is the release number?

Tnx!

On 6/13/19 2:36 PM, Andy Clark wrote:
> Hi Alex,
> Still getting the same error after	> ngcp-sync-constants -root
> ngcp-sync-constants -verbose -root
> ngcpcfg apply
>
[...removed...]

-- 
Alex Lutay