<div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div>Hello,</div><div>I was running mythbuntu fine for few years, till last week, when I tried to upgrade it to 16.04LTS. After fiddling around for few days, I decided to copy all recordings, etc. (/var/lib/mythtv/* ) and the last days backup and fresh and clean install Mythbuntu 16.04LTS. The install was successfull and I was able to get my video cards also working.(WinTV HVR-4000-HD)</div><div>I imported my Backup with Mythbuntu Control Center and copied all files back under /var/lib/mythtv.<br></div><div><br></div><div>When I try to open the mythtv Gui via Browser, I am getting a mysql error messages i the browser.(See more at the end of mail.)</div><div><br></div><div>
[err] => Access denied for user 'mythtv'@'localhost' (using password: YES)
</div><div><br></div><div>It works via command line and the pasword set in config.xml is correct. (See below; password changed for this mail)<br></div><div><br></div><div>The Server is listening on the correct IP:Port.</div><div><br></div><div>miro@mythbox:~$ netstat -ntlp|grep -i 3306<br>(Not all processes could be identified, non-owned process info<br> will not be shown, you would have to be root to see it all.)<br>tcp 0 0 <a href="http://127.0.0.1:3306">127.0.0.1:3306</a> 0.0.0.0:* LISTEN -<br>miro@mythbox:~$<br></div><div><br></div><div><br></div><div>And remember, this is a mythbuntu install. Used this ISO:</div><div><a href="http://cdimage.ubuntu.com/mythbuntu/releases/16.04/release/mythbuntu-16.04.6-desktop-amd64.iso">http://cdimage.ubuntu.com/mythbuntu/releases/16.04/release/mythbuntu-16.04.6-desktop-amd64.iso</a></div><div><br></div><div>Somehow I get a page under <a href="http://192.168.178.32:6544/">http://192.168.178.32:6544/</a></div><div></div><div><br></div><div>Any idea what is wrong here ?</div><div><br></div><div>Thanks!</div><div>Cheers,</div><div>Miro<br></div><div><br></div><div>----</div><div><br></div><div>
<h2>Fatal Error</h2>
<p class="err">
!!NoTrans: Access denied for user 'mythtv'@'localhost' (using password: YES) [#1045]<br>
<br>
Backtrace<br>
Array<br>
(<br>
[0] => Array<br>
(<br>
[file] => /usr/share/mythtv/mythweb/classes/Database/Query/mysqlicompat.php<br>
[line] => 65<br>
[function] => error<br>
[class] => Database<br>
[object] => Database_mysqlicompat Object<br>
(<br>
[dbh] => <br>
[error] => Access denied for user 'mythtv'@'localhost' (using password: YES) [#1045]<br>
[err] => Access denied for user 'mythtv'@'localhost' (using password: YES)<br>
[errno] => 1045<br>
[last_sh] => Database_Query_mysqlicompat Object<br>
(<br>
[dbh] => <br>
[query] => Array<br>
(<br>
[0] => SET NAMES utf8;<br>
)<br>
<br>
[last_query] => SET NAMES utf8;</p>
</div><div><br></div><div><br></div><div><br></div><div>----<br></div><div>miro@mythbox:~$ mysql -u mythtv -pP900XGam<br>mysql: [Warning] Using a password on the command line interface can be insecure.<br>Welcome to the MySQL monitor. Commands end with ; or \g.<br>Your MySQL connection id is 96<br>Server version: 5.7.26-0ubuntu0.16.04.1 (Ubuntu)<br><br>Copyright (c) 2000, 2019, 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 statement.<br><br>mysql> show databases;<br>+--------------------+<br>| Database |<br>+--------------------+<br>| information_schema |<br>| mythconverg |<br>+--------------------+<br>2 rows in set (0,00 sec)<br><br>mysql> quit<br>Bye<br>miro@mythbox:~$ cat /etc/mythtv/config.xml<br><Configuration><br> <Database><br> <PingHost>1</PingHost><br> <Host>localhost</Host><br> <UserName>mythtv</UserName><br> <Password>P900XGam</Password><br> <DatabaseName>mythconverg</DatabaseName><br> <Port>3306</Port><br> </Database><br> <WakeOnLAN><br> <Enabled>0</Enabled><br> <SQLReconnectWaitTime>0</SQLReconnectWaitTime><br> <SQLConnectRetry>5</SQLConnectRetry><br> <Command>echo 'WOLsqlServerCommand not set'</Command><br> </WakeOnLAN><br></Configuration><br><br>miro@mythbox:~$<br><br></div></div></div></div></div></div></div><div id="DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2"><br> <table style="border-top:1px solid #d3d4de">
<tr>
<td style="width:55px;padding-top:18px"><a href="https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail" target="_blank"><img src="https://ipmcdn.avast.com/images/icons/icon-envelope-tick-round-orange-animated-no-repeat-v1.gif" alt="" width="46" height="29" style="width: 46px; height: 29px;"></a></td>
<td style="width:470px;padding-top:17px;color:#41424e;font-size:13px;font-family:Arial,Helvetica,sans-serif;line-height:18px">Virenfrei. <a href="https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail" target="_blank" style="color:#4453ea">www.avast.com</a> </td>
</tr>
</table>
<a href="#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2" width="1" height="1"></a></div>