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

Thu Jun 13 14:38:05 EDT 2019

Still the same issue

2019-06-13 11:20:13 spce: /var has no support of .services
2019-06-13 11:20:13 spce: Executing sync-db:
                     DBI
connect('database=provisioning;host=localhost;port=3306','sipwise',...)
failed: Access denied for user 'sipwise'@'localhost' (using password: YES)
atgcp-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-13 11:20:13 spce: OK:   nothing to commit.
2019-06-13 11:20:13 spce: Synchronizing MySQL grants/credentials

version 6.5.4.1+0~mr6.5.4.1-

also a quick note: when i rest the dababase using "ngcp-reset-db"  then i
run "ngcpcfg apply" - I get the same error as above

-----------------
root at spce:~# source /etc/mysql/sipwise.cnf && mysql -usipwise
-p"${SIPWISE_DB_PASSWORD}" -hlocalhost -P3306 provisioning
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 4356
Server version: 10.1.38-MariaDB-0+deb9u1 Debian 9.8

Type 'help;' or '\h' for help. Type '\c' to clear the current input
statement.

---------------------

root at spce:~# source /etc/mysql/sipwise.cnf && mysql -usipwise
-p"${SIPWISE_DB_PASSWORD}" provisioning
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 4387
Server version: 10.1.38-MariaDB-0+deb9u1 Debian 9.8

Type 'help;' or '\h' for help. Type '\c' to clear the current input
statement.

after running ngcpcfg apply
 more /var/log/mysql/mysqld.err
2019-06-13  4:56:13 140274934056704 [Note] /usr/sbin/mysqld: Normal shutdown
2019-06-13  4:56:13 140274934056704 [Note] Event Scheduler: Purging the
queue. 0 events
2019-06-13  4:56:13 140269622109952 [Note] InnoDB: FTS optimize thread
exiting.
2019-06-13  4:56:13 140274934056704 [Note] InnoDB: Starting shutdown...
2019-06-13  4:56:14 140274934056704 [Note] InnoDB: Waiting for page_cleaner
to finish flushing of buffer pool
2019-06-13  4:56:16 140274934056704 [Note] InnoDB: Shutdown completed; log
sequence number 8665897760
2019-06-13  4:56:16 140274934056704 [Note] /usr/sbin/mysqld: Shutdown
complete

2019-06-13  4:56:35 140471483144192 [Note] InnoDB: Using mutexes to ref
count buffer pool pages
2019-06-13  4:56:35 140471483144192 [Note] InnoDB: The InnoDB memory heap
is disabled
2019-06-13  4:56:35 140471483144192 [Note] InnoDB: Mutexes and rw_locks use
GCC atomic builtins
2019-06-13  4:56:35 140471483144192 [Note] InnoDB: GCC builtin
__atomic_thread_fence() is used for memory barrier
2019-06-13  4:56:35 140471483144192 [Note] InnoDB: Compressed tables use
zlib 1.2.8
2019-06-13  4:56:35 140471483144192 [Note] InnoDB: Using Linux native AIO
2019-06-13  4:56:35 140471483144192 [Note] InnoDB: Using SSE crc32
instructions
2019-06-13  4:56:35 140471483144192 [Note] InnoDB: Initializing buffer
pool, size = 4.0G
2019-06-13  4:56:36 140471483144192 [Note] InnoDB: Completed initialization
of buffer pool
2019-06-13  4:56:39 140471483144192 [Note] InnoDB: Highest supported file
format is Barracuda.
2019-06-13  4:56:56 140471483144192 [Note] InnoDB: 128 rollback segment(s)
are active.
2019-06-13  4:56:56 140471483144192 [Note] InnoDB: Waiting for purge to
start
2019-06-13  4:56:56 140471483144192 [Note] InnoDB:  Percona XtraDB (
http://www.percona.com) 5.6.42-84.2 started; log sequence number 8665897760
2019-06-13  4:56:56 140466041349888 [Note] InnoDB: Dumping buffer pool(s)
not yet started
2019-06-13  4:56:56 140471483144192 [Note] Plugin 'FEEDBACK' is disabled.
2019-06-13  4:56:56 140471483144192 [Note] Server socket created on IP:
'127.0.0.1'.
2019-06-13  4:56:57 140471483144192 [Note] /usr/sbin/mysqld: ready for
connections.
Version: '10.1.38-MariaDB-0+deb9u1'  socket: '/var/run/mysqld/mysqld.sock'
 port: 3306  Debian 9.8

On Thu, Jun 13, 2019 at 6:00 AM Alex Lutay <alutay at sipwise.com> wrote:

> 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
> _______________________________________________
> Spce-user mailing list
> Spce-user at lists.sipwise.com
> https://lists.sipwise.com/listinfo/spce-user
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sipwise.com/pipermail/spce-user_lists.sipwise.com/attachments/20190613/564d90cd/attachment-0001.html>