Project

General

Profile

Bug #2258

mariadb update breaks initial hda-install run

Added by cpg over 3 years ago. Updated over 3 years ago.

Status:
Closed
Priority:
Normal
Assignee:
Category:
-
Target version:
-
Start date:
06/17/2017
Due date:
% Done:

0%


Description

we found out the hard way that new versions of mariadb in fedora 25 upstream (not the one in the DVD), and in the latest fedora 26 DVD, have an issue where the initial password setting in hda-install using mysqladmin breaks.

the work-around is to downgrade mariadb before hda-install (or after it was run but failed) with this command (though I'm not 100% sure of it, it may require adding mariadb-common to the downgrade command):

dnf downgrade --allowerase mariadb

the error as it appears to the user in the terminal looks like this and installation does not finish due to it:

Initializing MySQL
...
Activating your HDA's settings
ERROR 1045 (28000): Access denied for user 'amahihda'@'localhost' (using password: YES)

in the hda-install-X.log file, it looks like this:

...
Starting MySQL
Initializing MySQL
mysqladmin:
You cannot use 'password' command as mysqld runs
with grant tables disabled (was started with --skip-grant-tables).
Use: "mysqladmin flush-privileges password '*'" instead
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
***************        TBD: Initialize storage pooling ... *******************
Initializing Ruby on Rails and DB
** Invoke db:migrate (first_time)
** Invoke environment (first_time)
** Execute environment
** Invoke db:load_config (first_time)
** Execute db:load_config
** Execute db:migrate
rake aborted!
Mysql2::Error: Access denied for user 'amahihda'@'localhost' (using password: YES)
/var/hda/platform/html/vendor/bundle/ruby/2.3.0/gems/mysql2-0.3.21/lib/mysql2/client.rb:70:in `connect'
...

History

#1 Updated by cpg over 3 years ago

  • Description updated (diff)

#2 Updated by vikasy over 3 years ago

The command to downgrade which worked on my system was:

dnf --allowerasing downgrade mariadb mariadb-common

#3 Updated by cpg over 3 years ago

  • Status changed from New to Assigned
  • Assignee set to cpg

Thanks. @vikasy could you report the mysql version that works?

(and the version that fails, if you still have the text on the screen)

#4 Updated by cpg over 3 years ago

  • Status changed from Assigned to Closed

fixed via #2259

Also available in: Atom