Description of problem: mg8 rc5 ERROR 1819 (HY000) at line 2: Your password does not satisfy the current policy requirements Version-Release number of selected component (if applicable): How reproducible: Always Steps to Reproduce: 1. mysql --user=root --password=secret < /usr/share/mythtv/initialdb/mc.sql 2. 3.
After fixing line 2 I get ERROR 1396 (HY000) at line 3: Operation ALTER USER failed for 'mythtv'@'localhost' Workaround: # dif /hotbu/usr/share/mythtv/initialdb/mc.sql /usr/share/mythtv/initialdb/mc.sql 2,3c2,3 < CREATE USER IF NOT EXISTS 'mythtv'@'localhost' IDENTIFIED WITH mysql_native_password; < ALTER USER 'mythtv'@'localhost' IDENTIFIED BY 'mythtv'; --- > CREATE USER IF NOT EXISTS 'mythtv'@'localhost' IDENTIFIED by 'ZZZZZZZZ'; > ALTER USER 'mythtv'@'localhost' IDENTIFIED BY 'ZZZZZZZZ'; Where ZZZZZZZZ meets sqa datsbase restrictions. see https://bugs.mageia.org/show_bug.cgi?id=19127#c16
Thank you for the report & diagnosis. I found this (plus a lot saying there were no restrictions!): --- For MySQL databases, to meet the minimum conditions required for a strong password, the password must contain at least: Nine characters Two uppercase letters Two lowercase letters Two numbers Two of the following allowed special characters: ‘ ~ ! @ # $ % ^ & * ( ) _ - + = { } [ ] / < > , . ; ? ' : | (space) --- Can this be assigned to you, DavidG, as having done most recent commits for this?
Assignee: bugsquad => geiger.david68210Summary: mythtv: mc.sql ERROR 1819 (HY000) at line 2: => mythtv: mc.sql ERROR 1819 (HY000) at line 2: /usr/share/mythtv/initialdb/mc.sql needs password correcting
Is this issue reported upstream?
Is this bug fixed with current mythtv--31.0-20210323.1.1.mga8?
(In reply to David GEIGER from comment #4) > Is this bug fixed with current mythtv--31.0-20210323.1.1.mga8? No. Tested just for you today via Mageia-8-netinstall-nonfree-x86_64.iso
Beside the password problem; mariadb-10.5.8-2.mga8 has a create user syntax change. :( $ diff mc.sql_install /usr/share/mythtv/initialdb/mc.sql < CREATE USER IF NOT EXISTS 'mythtv'@'localhost' IDENTIFIED WITH mysql_native_password; < ALTER USER 'mythtv'@'localhost' IDENTIFIED BY 'mythtv'; --- > CREATE OR REPLACE USER "mythtv"@"localhost" IDENTIFIED by "ZZZZZZZZ"; > ALTER USER "mythtv"@"localhost" IDENTIFIED BY "ZZZZZZZZ"; Guessing apostrophes can be used instead of double quotes. After two days of trying to get my clean Production mythtv install going, I had no further desire to do another clean install just to check if single quote would work in place of double quotes.
Hi Is there any plans on fixing this bug ? I can't get a fresh install to work. Best regards Anders
CC: (none) => anp
If this bug persist please file a new bug upstream at https://github.com/MythTV/mythtv/issues