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

[Alex Lutay]

Hi,

It is hard to say something from this side.
Maybe 'mysql.user' table was not backuped/restored and
there is no proper user 'sipwise' inside?
Maybe you missed "flush hosts; flush privileges"?

You can share your exact commands to backup/restore procedures,
I will try this on my side. BTW did you use our manuals?
Which release do you use?

Did it happen once or you still see this error on 'ngcpcfg apply'?
If so, consider to execute:
> ngcp-sync-grants --verbose --recreate-user
> ngcp-sync-constants -verbose -root

It should recreate all the necessary sipwise users and sync their
passwords with constants.yml

I hope it will help you.
Cannot trace it further from here.

Have fun!

On 6/12/19 5:52 PM, Andy Clark wrote:
> 2019-06-12 08:42:25 spce: /var has no support of .services
> 2019-06-12 08:42:25 spce: Executing sync-db:
>                      DBI
> connect('database=provisioning;host=localhost;port=3306','sipwise',...)
> failed: Access denied for user 'sipwise'@'localhost' (using password:
> YES) at /usr/share/ngcp-ngcpcfg/helper//sync-db line 79.
>                      Error: Could not connect to database 'provisioning'
> at 'localhost:3306' as 'sipwise': Access denied for user
> 'sipwise'@'localhost' (using password: YES)
> 2019-06-12 08:42:25 spce: OK:   nothing to commit.
> 2019-06-12 08:42:25 spce: Synchronizing MySQL grants/credentials
> 
> 
> restored database (full restore except for accounting.cdr)
> restored /etc/ngcp-config
> restored /etc/mysql/sipwise.conf


-- 
Alex Lutay