Bug #2258
mariadb update breaks initial hda-install run
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 almost 4 years ago
- Description updated (diff)
#2 Updated by vikasy almost 4 years ago
The command to downgrade which worked on my system was:
dnf --allowerasing downgrade mariadb mariadb-common
#3 Updated by cpg almost 4 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)
Also available in: Atom