[Spce-user] after db restore - DB provisioning access denied
andyclark05251978 at gmail.com
Fri Jun 14 07:52:52 EDT 2019
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:
> 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
> Alex Lutay
> Spce-user mailing list
> Spce-user at lists.sipwise.com
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the Spce-user