[mythtv-users] Getting GUI Error message, when opening the MythTV Browser page.

[Miroslav Pavlovic]

Hello,
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)
I imported my Backup with Mythbuntu Control Center and copied all files
back under /var/lib/mythtv.

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.)

[err] => Access denied for user 'mythtv'@'localhost' (using password: YES)

It works via command line and the pasword set in config.xml is correct.
(See below; password changed for this mail)

The Server is listening on the correct IP:Port.

miro at mythbox:~$ netstat -ntlp|grep -i 3306
(Not all processes could be identified, non-owned process info
 will not be shown, you would have to be root to see it all.)
tcp        0      0 127.0.0.1:3306          0.0.0.0:*
LISTEN      -
miro at mythbox:~$


And remember, this is a mythbuntu install. Used this ISO:
http://cdimage.ubuntu.com/mythbuntu/releases/16.04/release/mythbuntu-16.04.6-desktop-amd64.iso

Somehow I get a page under http://192.168.178.32:6544/

Any idea what is wrong here ?

Thanks!
Cheers,
Miro

----

Fatal Error

!!NoTrans: Access denied for user 'mythtv'@'localhost' (using password:
YES) [#1045]

Backtrace
Array
(
[0] => Array
(
[file] => /usr/share/mythtv/mythweb/classes/Database/Query/mysqlicompat.php
[line] => 65
[function] => error
[class] => Database
[object] => Database_mysqlicompat Object
(
[dbh] =>
[error] => Access denied for user 'mythtv'@'localhost' (using password:
YES) [#1045]
[err] => Access denied for user 'mythtv'@'localhost' (using password: YES)
[errno] => 1045
[last_sh] => Database_Query_mysqlicompat Object
(
[dbh] =>
[query] => Array
(
[0] => SET NAMES utf8;
)

[last_query] => SET NAMES utf8;



----
miro at mythbox:~$ mysql -u mythtv -pP900XGam
mysql: [Warning] Using a password on the command line interface can be
insecure.
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 96
Server version: 5.7.26-0ubuntu0.16.04.1 (Ubuntu)

Copyright (c) 2000, 2019, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input
statement.

mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mythconverg        |
+--------------------+
2 rows in set (0,00 sec)

mysql> quit
Bye
miro at mythbox:~$ cat /etc/mythtv/config.xml
<Configuration>
  <Database>
    <PingHost>1</PingHost>
    <Host>localhost</Host>
    <UserName>mythtv</UserName>
    <Password>P900XGam</Password>
    <DatabaseName>mythconverg</DatabaseName>
    <Port>3306</Port>
  </Database>
  <WakeOnLAN>
    <Enabled>0</Enabled>
    <SQLReconnectWaitTime>0</SQLReconnectWaitTime>
    <SQLConnectRetry>5</SQLConnectRetry>
    <Command>echo 'WOLsqlServerCommand not set'</Command>
  </WakeOnLAN>
</Configuration>

miro at mythbox:~$


<https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail>
Virenfrei.
www.avast.com
<https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail>
<#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.mythtv.org/pipermail/mythtv-users/attachments/20190509/db7fbaee/attachment.html>