<div dir="ltr"><br><div class="gmail_extra"><br><div class="gmail_quote">On Sun, Aug 5, 2018 at 1:44 PM, Stephen Worthington <span dir="ltr"><<a href="mailto:stephen_agent@jsw.gen.nz" target="_blank">stephen_agent@jsw.gen.nz</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div class="gmail-HOEnZb"><div class="gmail-h5">On Sun, 5 Aug 2018 11:30:14 -0400, you wrote:<br>
<br>
>On Sun, Aug 5, 2018 at 11:06 AM, Stephen Worthington <<br>
><a href="mailto:stephen_agent@jsw.gen.nz">stephen_agent@jsw.gen.nz</a>> wrote:<br>
><br>
>> On Sun, 5 Aug 2018 10:48:01 -0400, you wrote:<br>
>><br>
>><br>
>> >I'm still getting nowhere:<br>
>> > daryl@trieli:~$ ./<a href="http://mythconverg_restore.pl" rel="noreferrer" target="_blank">mythconverg_restore.pl</a> --create_database --directory ~<br>
>> >--filename mythconverg-1344-<wbr>20180804112717.sql.gz --verbose<br>
>> ><br>
>> >Configuring environment:<br>
>> > - username: daryl<br>
>> > - HOME: /home/daryl<br>
>> > - MYTHCONFDIR: /home/daryl/.mythtv<br>
>> ><br>
>> >Parsing configuration files:<br>
>> > - checking: /home/daryl/.mythtv/config.xml<br>
>> > - checking: /usr/local/share/mythtv/mysql.<wbr>txt<br>
>> > - checking: /usr/share/mythtv/mysql.txt<br>
>> > - checking: /usr/local/etc/mythtv/mysql.<wbr>txt<br>
>> > - checking: /etc/mythtv/mysql.txt<br>
>> > - checking: /home/daryl/.mythtv/mysql.txt<br>
>> > - checking: mysql.txt<br>
>> > - checking: /home/daryl/.mythtv/mysql.txt<br>
>> > - checking: /home/daryl/.mythtv/backuprc<br>
>> ><br>
>> >Applying command-line arguments.<br>
>> ><br>
>> >Checking configuration.<br>
>> ><br>
>> >WARNING: DBName not specified. Using mythconverg<br>
>> ><br>
>> >WARNING: DBHostName not specified.<br>
>> > Assuming it is specified in the MySQL options file.<br>
>> ><br>
>> >WARNING: DBUserName not specified.<br>
>> > Assuming it is specified in the MySQL options file.<br>
>> ><br>
>> >WARNING: DBPassword not specified.<br>
>> > Assuming it is specified in the MySQL options file.<br>
>> ><br>
>> >Database Information:<br>
>> > DBHostName:<br>
>> > DBPort: -1<br>
>> > DBUserName:<br>
>> > DBPassword:<br>
>> > DBName: mythconverg<br>
>> > DBSchemaVer:<br>
>> > DBBackupDirectory: /home/daryl<br>
>> > DBBackupFilename: mythconverg-1344-<wbr>20180804112717.sql.gz<br>
>> > drop_database: no<br>
>> > create_database: yes<br>
>> ><br>
>> >Executables:<br>
>> > mysql_client: mysql<br>
>> > uncompress: gzip -d<br>
>> ><br>
>> >Miscellaneous:<br>
>> > partial_restore: no<br>
>> > restore_xmltvids: no<br>
>> > change_hostname: no<br>
>> ><br>
>> >Checking database.<br>
>> >DBI connect('host=:database=<wbr>mythconverg','',...) failed: Access denied<br>
>> for<br>
>> >user 'daryl'@'localhost' (using password: NO) at ./<a href="http://mythconverg_restore.pl" rel="noreferrer" target="_blank">mythconverg_restore.pl</a><br>
>> >line 933.<br>
>> ><br>
>> >Preparing initial database.<br>
>> >DBI connect('host=','',...) failed: Access denied for user 'daryl'@<br>
>> 'localhost'<br>
>> >(using password: NO) at ./<a href="http://mythconverg_restore.pl" rel="noreferrer" target="_blank">mythconverg_restore.pl</a> line 933.<br>
>> ><br>
>> >Unable to connect to database.<br>
>> > database: mythconverg<br>
>> > host:<br>
>> > username:<br>
>> > password:<br>
>> ><br>
>> >Please check your configuration files to verify the database connection<br>
>> >information is correct. The files that are used to retrieve connection<br>
>> >information are prefixed with "parsing" in the "Parsing configuration<br>
>> files"<br>
>> >section of the --verbose output.<br>
>> ><br>
>> >Also note that any [client] or [mysql] password specified in the MySQL<br>
>> >options<br>
>> >file (/etc/my.cnf or /etc/mysql/my.cnf or ~/.my.cnf) will take precedence<br>
>> >over<br>
>> >the password specified in the MythTV configuration files.<br>
>> ><br>
>> >ERROR: Unable to connect to database.<br>
>><br>
>> It looks like you have restored the /etc/mythtv/config.xml file, which<br>
>> contains the password to access the mythconverg database. But the<br>
>> MariaDB or MySQL database system you are restoring to is clean - it<br>
>> does not have the user/password that was in your old database to allow<br>
>> access to the mythconverg database. The user/password data is not<br>
>> stored in the mythconverg database - it is stored in a separate system<br>
>> maintained database, and can not be restored by<br>
>> <a href="http://mythconverg_restore.pl" rel="noreferrer" target="_blank">mythconverg_restore.pl</a>.<br>
>><br>
>> So what you need to do is to do the SQL commands needed to add the<br>
>> user/password from /etc/mythtv/config.xml into the MySQL<br>
>> authentication system. See this page for how:<br>
>><br>
>> <a href="https://www.mythtv.org/wiki/Category:MySQL" rel="noreferrer" target="_blank">https://www.mythtv.org/wiki/<wbr>Category:MySQL</a><br>
>><br>
>> Search for "Access denied for user".<br>
>><br>
><br>
>I don't think this went as it should have:<br>
><br>
>Enter password:<br>
>Reading table information for completion of table and column names<br>
>You can turn off this feature to get a quicker startup with -A<br>
><br>
>Welcome to the MySQL monitor. Commands end with ; or \g.<br>
>Your MySQL connection id is 42<br>
>Server version: 5.7.23-0ubuntu0.16.04.1 (Ubuntu)<br>
><br>
>Copyright (c) 2000, 2018, Oracle and/or its affiliates. All rights reserved.<br>
><br>
>Oracle is a registered trademark of Oracle Corporation and/or its<br>
>affiliates. Other names may be trademarks of their respective<br>
>owners.<br>
><br>
>Type 'help;' or '\h' for help. Type '\c' to clear the current input<br>
>statement.<br>
><br>
>mysql> GRANT ALL PRIVILEGES ON *.* TO 'mythtv'@'localhost' IDENTIFIED BY<br>
>'mythtv' WITH GRANT OPTION;<br>
>Query OK, 0 rows affected, 1 warning (0.02 sec)<br>
><br>
>mysql> UPDATE user SET Password=h2TGgzwD('mythtv') WHERE user='mythtv';<br>
>ERROR 1054 (42S22): Unknown column 'Password' in 'field list'<br>
>mysql> FLUSH PRIVELIGES<br>
<br>
</div></div>You have misinterpreted the syntax of the GRANT command. PASSWORD()<br>
is a function that encrypts a plain-text password for storage into the<br>
database. So the command should be:<br>
<br>
UPDATE user SET Password=PASSWORD('h2TGgzwD') where user='mythtv';<br>
<br>
But as you have posted the actual password publicly here, it would be<br>
a good idea to run the apg command (install with "apt install apg" if<br>
necessary) and generate a new password to use, and put that in<br>
/etc/mythtv/config.xml and in the above command.<br></blockquote><div><br></div><div>With proper syntax (copy&paste) it still looks unproductive:</div><div><div>daryl@trieli:~$ mysql -u root -p mysql</div><div>Enter password: </div><div>Reading table information for completion of table and column names</div><div>You can turn off this feature to get a quicker startup with -A</div><div><br></div><div>Welcome to the MySQL monitor. Commands end with ; or \g.</div><div>Your MySQL connection id is 12</div><div>Server version: 5.7.23-0ubuntu0.16.04.1 (Ubuntu)</div><div><br></div><div>Copyright (c) 2000, 2018, Oracle and/or its affiliates. All rights reserved.</div><div><br></div><div>Oracle is a registered trademark of Oracle Corporation and/or its</div><div>affiliates. Other names may be trademarks of their respective</div><div>owners.</div><div><br></div><div>Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.</div><div><br></div><div>mysql> GRANT ALL PRIVILEGES ON *.* TO 'mythtv'@'localhost' IDENTIFIED BY 'mythtv' WITH GRANT OPTION;</div><div>Query OK, 0 rows affected, 1 warning (0.01 sec)</div><div><br></div><div>mysql> UPDATE user SET Password=PASSWORD('mythtv') WHERE user='mythtv';</div><div>ERROR 1054 (42S22): Unknown column 'Password' in 'field list'</div><div>mysql> FLUSH PRIVILEGES;</div><div>Query OK, 0 rows affected (0.00 sec)</div><div><br></div><div>mysql> quit</div><div>Bye</div></div><div><br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
<div class="gmail-HOEnZb"><div class="gmail-h5">______________________________<wbr>_________________<br>
mythtv-users mailing list<br>
<a href="mailto:mythtv-users@mythtv.org">mythtv-users@mythtv.org</a><br>
<a href="http://lists.mythtv.org/mailman/listinfo/mythtv-users" rel="noreferrer" target="_blank">http://lists.mythtv.org/<wbr>mailman/listinfo/mythtv-users</a><br>
<a href="http://wiki.mythtv.org/Mailing_List_etiquette" rel="noreferrer" target="_blank">http://wiki.mythtv.org/<wbr>Mailing_List_etiquette</a><br>
MythTV Forums: <a href="https://forum.mythtv.org" rel="noreferrer" target="_blank">https://forum.mythtv.org</a><br>
</div></div></blockquote></div><br></div></div>