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

[Andy Clark]

All working - Thank you

Really appreciate your help Alex!!!

I honestly did not think it mattered if I manually edited or restored that
file. I when changing the original, I like to comment then make changes. I
know that the help that you and your team provide takes up a lot of your
time and recreating the issue from our emails takes even more time. I just
wanted to say "Thank you!!!" and I really appreciate it all your help

On Fri, Jun 14, 2019 at 1:01 AM Alex Lutay <alutay at sipwise.com> wrote:

> Hi,
>
> Hm, I suspect you were laying saying "I have restored
> /etc/mysql/sipwise.conf from backup".
> The file /etc/mysql/sipwise.cnf was NOT from backup,\
> but manually edited ;-)
>
> OK, here is the answer. Copy from one of your comments:
> > 3. vim /etc/mysql/sipwise.cnf
> >           # SIPWISE_DB_PASSWORD='XXXXXXXXXXXXXXXXX' existing
> >           SIPWISE_DB_PASSWORD='YYYYYYYYYYYYYYYYYYY' # from backup server
>
> Here is the code in /usr/share/ngcp-ngcpcfg/helper//sync-db
> > open my $SWFH, '<', '/etc/mysql/sipwise.cnf';
> > my $dbpass = join ' ', <$SWFH>;
> > close $SWFH;
> > $dbpass =~ s/^.*SIPWISE_DB_PASSWORD=\'([^\']+)\'.*$/$1/;
>
> At least it should be
> > - ... /^.*SIPWISE_DB_PASSWORD=\'([^\']+)\'.*$/$1/;
> > + ... /^\s*SIPWISE_DB_PASSWORD=\'([^\']+)\'.*$/$1/;
>
> I have reported it internally to improve sync-db code here, TT#60670
>
> As a quick "fix" for you, please remove the first commented line in
> /etc/mysql/sipwise.cnf keep only one line in file:
> > SIPWISE_DB_PASSWORD='YYYYYYYYYYYYYYYYYYY'
> (you anyway have the old password in etckeeper).
>
> Have fun!
>
> On 6/13/19 8:38 PM, Andy Clark wrote:
> > Still the same issue
> [...skipped...]
>
> --
> 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/20190614/7af2592c/attachment-0001.html>