Bug 28289

Summary:	mythtv: mc.sql ERROR 1819 (HY000) at line 2: /usr/share/mythtv/initialdb/mc.sql needs password correcting
Product:	Mageia	Reporter:	Bit Twister <bittwister2>
Component:	RPM Packages	Assignee:	David GEIGER <geiger.david68210>
Status:	NEW ---	QA Contact:
Severity:	normal
Priority:	Normal	CC:	anp
Version:	8
Target Milestone:	---
Hardware:	All
OS:	Linux
Whiteboard:
Source RPM:	mythtv-31.0-20210112.1.mga8.tainted.src.rpm	CVE:
Status comment:

Description Bit Twister 2021-02-03 19:50:23 CET

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.

Comment 1 Bit Twister 2021-02-03 20:21:16 CET

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

Comment 2 Lewis Smith 2021-02-04 11:37:54 CET

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.david68210
Summary: 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

Comment 3 David GEIGER 2021-02-04 18:44:46 CET

Is this issue reported upstream?

Comment 4 David GEIGER 2021-04-08 07:29:27 CEST

Is this bug fixed with current mythtv--31.0-20210323.1.1.mga8?

Comment 5 Bit Twister 2021-04-08 16:13:15 CEST

(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

Comment 6 Bit Twister 2021-04-10 06:03:14 CEST

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.

Comment 7 Anders Pedersen 2021-11-22 21:45:08 CET

Hi

Is there any plans on fixing this bug ?

I can't get a fresh install to work.

Best regards
Anders

CC: (none) => anp

Comment 8 David GEIGER 2023-02-04 13:53:42 CET

If this bug persist please file a new bug upstream at https://github.com/MythTV/mythtv/issues