<div dir="ltr"><br><div class="gmail_extra"><br><div class="gmail_quote">On Sun, Aug 5, 2018 at 10:48 AM, Daryl McDonald <span dir="ltr"><<a href="mailto:darylangela@gmail.com" target="_blank">darylangela@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr"><br><div class="gmail_extra"><br><div class="gmail_quote"><div><div class="h5">On Sun, Aug 5, 2018 at 10:19 AM, Jay Harbeston (ISeePeople) <span dir="ltr"><<a href="mailto:jharbestonus@gmail.com" target="_blank">jharbestonus@gmail.com</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 style="word-wrap:break-word"><br><div><div><div class="m_6425997530946802069gmail-h5"><br><blockquote type="cite"><div>On Aug 5, 2018, at 10:03 AM, Daryl McDonald <<a href="mailto:darylangela@gmail.com" target="_blank">darylangela@gmail.com</a>> wrote:</div><br class="m_6425997530946802069gmail-m_6830051584152922136Apple-interchange-newline"><div><div dir="ltr">Greetings Mythizens, I've rebuilt after a drive failure, and I'm having trouble restoring the database. I downloaded the back-up and restore files<div><br></div><div><div>daryl@trieli:~$ chmod a+x <a href="http://mythconverg_backup.pl/" target="_blank">mythconverg_backup.pl</a> <a href="http://mythconverg_restore.pl/" target="_blank">mythconverg_restore.pl</a></div><div>daryl@trieli:~$ <a href="http://mythconverg_restore.pl/" target="_blank">mythconverg_restore.pl</a> --drop_database --create_database --filename mythconverg-1344-2018080411271<wbr>7.sql.gz</div><div><a href="http://mythconverg_restore.pl/" target="_blank">mythconverg_restore.pl</a>: command not found</div><div>daryl@trieli:~$ <a href="http://mythconverg_restore.pl/" target="_blank">mythconverg_restore.pl</a> --directory/home/daryl --drop_database --create_database --filename mythconverg-1344-2018080411271<wbr>7.sql.gz</div><div><a href="http://mythconverg_restore.pl/" target="_blank">mythconverg_restore.pl</a>: command not found</div><div>daryl@trieli:~$ cd /home/dary/</div><div>bash: cd: /home/dary/: No such file or directory</div><div>daryl@trieli:~$ cd Home</div><div>bash: cd: Home: No such file or directory</div><div>daryl@trieli:~$ ls -al</div><div>total 52180</div><div>drwxr-xr-x 18 daryl daryl 4096 Aug 5 09:40 .</div><div>drwxr-xr-x 4 root root 4096 Aug 5 09:21 ..</div><div>-rw------- 1 daryl daryl 146 Aug 5 08:37 .bash_history</div><div>-rw-r--r-- 1 daryl daryl 220 Aug 5 07:36 .bash_logout</div><div>-rw-r--r-- 1 daryl daryl 3771 Aug 5 07:36 .bashrc</div><div>drwx------ 18 daryl daryl 4096 Aug 5 08:39 .cache</div><div>drwx------ 16 daryl daryl 4096 Aug 5 08:50 .config</div><div>drwxr-xr-x 2 daryl daryl 4096 Aug 5 07:59 Desktop</div><div>drwxr-xr-x 2 daryl daryl 4096 Aug 5 07:59 Documents</div><div>drwxr-xr-x 2 daryl daryl 4096 Aug 5 08:50 Downloads</div><div>-rw-r--r-- 1 daryl daryl 8980 Aug 5 07:36 examples.desktop</div><div>drwx------ 2 daryl daryl 4096 Aug 5 08:27 .gconf</div><div>drwx------ 3 daryl daryl 4096 Aug 5 08:32 .gnupg</div><div>-rw------- 1 daryl daryl 636 Aug 5 08:32 .ICEauthority</div><div>drwxr-xr-x 7 daryl daryl 4096 Aug 5 08:51 .kodi</div><div>drwx------ 3 daryl daryl 4096 Aug 5 07:59 .local</div><div>drwx------ 5 daryl daryl 4096 Aug 5 08:33 .mozilla</div><div>drwxr-xr-x 2 daryl daryl 4096 Aug 5 07:59 Music</div><div>-rw-r--r-- 1 daryl daryl 53170263 Aug 4 11:27 mythconverg-1344-2018080411271<wbr>7.sql.gz</div><div>-rwxrwxr-x 1 daryl daryl 59103 Aug 5 09:39 <a href="http://mythconverg_backup.pl/" target="_blank">mythconverg_backup.pl</a></div><div>-rwxrwxr-x 1 daryl daryl 68814 Aug 5 09:40 <a href="http://mythconverg_restore.pl/" target="_blank">mythconverg_restore.pl</a></div><div>drwxr-xr-x 2 daryl daryl 4096 Aug 5 07:59 Pictures</div><div>drwx------ 3 daryl daryl 4096 Aug 5 08:39 .pki</div><div>-rw-r--r-- 1 daryl daryl 675 Aug 5 07:36 .profile</div><div>drwxr-xr-x 2 daryl daryl 4096 Aug 5 07:59 Public</div><div>-rwxrwxr-x 1 daryl daryl 1107 Oct 23 2014 shortlog.sh</div><div>-rw-r--r-- 1 daryl daryl 0 Aug 5 08:01 .sudo_as_admin_successful</div><div>drwxr-xr-x 2 daryl daryl 4096 Aug 5 07:59 Templates</div><div>drwxr-xr-x 2 daryl daryl 4096 Aug 5 07:59 Videos</div><div>-rwxrwxr-x 1 daryl daryl 555 Sep 24 2016 wakeup_test.sh</div><div>-rw------- 1 daryl daryl 51 Aug 5 08:31 .Xauthority</div><div>-rw------- 1 daryl daryl 82 Aug 5 08:31 .xsession-errors</div><div>-rw------- 1 daryl daryl 1228 Aug 5 08:31 .xsession-errors.old</div></div></div></div></blockquote><div><br></div></div></div><div>You can run this by doing perl mythconverg……… </div><div><br></div><div> the ‘errors’ you are seeing is that your home directory is NOT in your path. The rest of the commands look fine.</div><div><br></div><div><br></div><div><br></div><br><blockquote type="cite"><div><span class="m_6425997530946802069gmail-"><div dir="ltr"><div><div>daryl@trieli:~$ <a href="http://mythconverg_restore.pl/" target="_blank">mythconverg_restore.pl</a> --drop_database --create_database --filename mythconverg-1344-2018080411271<wbr>7.sql.gz</div><div><a href="http://mythconverg_restore.pl/" target="_blank">mythconverg_restore.pl</a>: command not found</div><div>daryl@trieli:~$ ./<a href="http://mythconverg_restore.pl/" target="_blank">mythconverg_restore.pl</a> --drop_database --create_database --filename mythconverg-1344-2018080411271<wbr>7.sql.gz</div><div><br></div><div>ERROR: DBBackupDirectory not specified, stopped at ./<a href="http://mythconverg_restore.pl/" target="_blank">mythconverg_restore.pl</a> line 773.</div><div>daryl@trieli:~$ ./<a href="http://mythconverg_restore.pl/" target="_blank">mythconverg_restore.pl</a> --drop_database --create_database --directory ~ --filename mythconverg-1344-2018080411271<wbr>7.sql.gz</div><div>DBI connect('host=:database=mythco<wbr>nverg','',...) failed: Access denied for user 'daryl'@'localhost' (using password: NO) at ./<a href="http://mythconverg_restore.pl/" target="_blank">mythconverg_restore.pl</a> line 933.</div><div>DBI connect('host=','',...) failed: Access denied for user 'daryl'@'localhost' (using password: NO) at ./<a href="http://mythconverg_restore.pl/" target="_blank">mythconverg_restore.pl</a> line 933.</div><div><br></div><div>Unable to connect to database.</div><div> database: mythconverg</div><div> host: </div><div> username: </div><div>To see the password used, please re-run the script with the --verbose</div><div>argument.</div><div><br></div><div>Please check your configuration files to verify the database connection</div><div>information is correct. The files that are used to retrieve connection</div><div>information are prefixed with "parsing" in the "Parsing configuration files"</div><div>section of the --verbose output.</div><div><br></div><div>Also note that any [client] or [mysql] password specified in the MySQL options</div><div>file (/etc/my.cnf or /etc/mysql/my.cnf or ~/.my.cnf) will take precedence over</div><div>the password specified in the MythTV configuration files.</div><div><br></div><div>ERROR: Unable to connect to database.</div></div><div><br></div><div>I would appreciate any help getting this fixed. Daryl</div></div></span></div></blockquote></div></div></blockquote><div><br></div></div></div><div>I'm still getting nowhere:</div><div> daryl@trieli:~$ ./<a href="http://mythconverg_restore.pl" target="_blank">mythconverg_restore.pl</a> --create_database --directory ~ --filename mythconverg-1344-<wbr>20180804112717.sql.gz --verbose</div><div><br></div><div>Configuring environment:</div><div> - username: daryl</div><div> - HOME: /home/daryl</div><div> - MYTHCONFDIR: /home/daryl/.mythtv</div><div><br></div><div>Parsing configuration files:</div><div> - checking: /home/daryl/.mythtv/config.xml</div><div> - checking: /usr/local/share/mythtv/mysql.<wbr>txt</div><div> - checking: /usr/share/mythtv/mysql.txt</div><div> - checking: /usr/local/etc/mythtv/mysql.<wbr>txt</div><div> - checking: /etc/mythtv/mysql.txt</div><div> - checking: /home/daryl/.mythtv/mysql.txt</div><div> - checking: mysql.txt</div><div> - checking: /home/daryl/.mythtv/mysql.txt</div><div> - checking: /home/daryl/.mythtv/backuprc</div><div><br></div><div>Applying command-line arguments.</div><div><br></div><div>Checking configuration.</div><div><br></div><div>WARNING: DBName not specified. Using mythconverg</div><div><br></div><div>WARNING: DBHostName not specified.</div><div> Assuming it is specified in the MySQL options file.</div><div><br></div><div>WARNING: DBUserName not specified.</div><div> Assuming it is specified in the MySQL options file.</div><div><br></div><div>WARNING: DBPassword not specified.</div><div> Assuming it is specified in the MySQL options file.</div><div><br></div><div>Database Information:</div><div> DBHostName: </div><div> DBPort: -1</div><div> DBUserName: </div><div> DBPassword: </div><div> DBName: mythconverg</div><div> DBSchemaVer: </div><div> DBBackupDirectory: /home/daryl</div><div> DBBackupFilename: mythconverg-1344-<wbr>20180804112717.sql.gz</div><div> drop_database: no</div><div> create_database: yes</div><div><br></div><div>Executables:</div><div> mysql_client: mysql</div><div> uncompress: gzip -d</div><div><br></div><div>Miscellaneous:</div><div> partial_restore: no</div><div> restore_xmltvids: no</div><div> change_hostname: no</div><div><br></div><div>Checking database.</div><span class=""><div>DBI connect('host=:database=<wbr>mythconverg','',...) failed: Access denied for user 'daryl'@'localhost' (using password: NO) at ./<a href="http://mythconverg_restore.pl" target="_blank">mythconverg_restore.pl</a> line 933.</div><div><br></div></span><div>Preparing initial database.</div><span class=""><div>DBI connect('host=','',...) failed: Access denied for user 'daryl'@'localhost' (using password: NO) at ./<a href="http://mythconverg_restore.pl" target="_blank">mythconverg_restore.pl</a> line 933.</div><div><br></div><div>Unable to connect to database.</div><div> database: mythconverg</div><div> host: </div><div> username: </div></span><div> password: </div><span class=""><div><br></div><div>Please check your configuration files to verify the database connection</div><div>information is correct. The files that are used to retrieve connection</div><div>information are prefixed with "parsing" in the "Parsing configuration files"</div><div>section of the --verbose output.</div><div><br></div><div>Also note that any [client] or [mysql] password specified in the MySQL options</div><div>file (/etc/my.cnf or /etc/mysql/my.cnf or ~/.my.cnf) will take precedence over</div><div>the password specified in the MythTV configuration files.</div><div><br></div><div>ERROR: Unable to connect to database.</div></span></div></div></div></blockquote><div><br></div><div>None of the config files exist (listed under parsing) how do I create those? </div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr"><div class="gmail_extra"><div class="gmail_quote"><span class=""><div><br></div></span><span class=""><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div style="word-wrap:break-word"><div><blockquote type="cite"><div>
______________________________<wbr>_________________<br>mythtv-users mailing list<br><a href="mailto:mythtv-users@mythtv.org" target="_blank">mythtv-users@mythtv.org</a><br><a href="http://lists.mythtv.org/mailman/listinfo/mythtv-users" target="_blank">http://lists.mythtv.org/mailma<wbr>n/listinfo/mythtv-users</a><br><a href="http://wiki.mythtv.org/Mailing_List_etiquette" target="_blank">http://wiki.mythtv.org/Mailing<wbr>_List_etiquette</a><br>MythTV Forums: <a href="https://forum.mythtv.org" target="_blank">https://forum.mythtv.org</a><br></div></blockquote></div><br></div><br>______________________________<wbr>_________________<br>
mythtv-users mailing list<br>
<a href="mailto:mythtv-users@mythtv.org" target="_blank">mythtv-users@mythtv.org</a><br>
<a href="http://lists.mythtv.org/mailman/listinfo/mythtv-users" rel="noreferrer" target="_blank">http://lists.mythtv.org/mailma<wbr>n/listinfo/mythtv-users</a><br>
<a href="http://wiki.mythtv.org/Mailing_List_etiquette" rel="noreferrer" target="_blank">http://wiki.mythtv.org/Mailing<wbr>_List_etiquette</a><br>
MythTV Forums: <a href="https://forum.mythtv.org" rel="noreferrer" target="_blank">https://forum.mythtv.org</a><br>
<br></blockquote></span></div><br></div></div>
</blockquote></div><br></div></div>