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

Fri May 10 09:30:39 UTC 2019

ok, I got a bit further, the root mysql problem, I fixed like this:
(Found the steps from a page, but dont have the URL handy)
(Also set a Linux User root password before)

   1. Stop MySQL

 sudo service mysql stop

   1. Make MySQL service directory.

 sudo mkdir /var/run/mysqld

   1. Give MySQL user permission to write to the service directory.

 sudo chown mysql: /var/run/mysqld

   1. Start MySQL manually, without permission checks or networking.

 sudo mysqld_safe --skip-grant-tables --skip-networking &

   1. Log in without a password.

 mysql -uroot mysql

*Now reset authentication and set password resolving to default mechanism:*

use mysql; # use mysql tableupdate user set
authentication_string=PASSWORD("") where User='root'; # update
password to nothingupdate user set plugin="mysql_native_password"
where User='root'; # set password resolving to default mechanism for
root user

flush privileges;
quit;
----

So now I am able to access the mysql ddatabase as root user:

miro at mythbox:~$ *sudo mysql -u root mythconverg*
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 4
Server version: 5.7.26-0ubuntu0.16.04.1 (Ubuntu)

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 tables;
+--------------------------------+
| Tables_in_mythconverg          |
+--------------------------------+
| archiveitems                   |
| bdbookmark                     |
| callsignnetworkmap             |
| capturecard                    |
| cardinput                      |
| channel                        |
| channelgroup                   |
| channelgroupnames              |

ooo

*And now my mythtv browser GUI works again !!! hooray*

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

Am Fr., 10. Mai 2019 um 11:16 Uhr schrieb Miroslav Pavlovic <
mail.pavlovic at gmail.com>:

> Thanks for your Support, but still not fixed and same Error comes up.
> I've set the root password, see below some command line output.
>
> BR./Miro
>
> miro at mythbox:~$ sudo su -
> [sudo] password for miro:
> root at mythbox:~#
> root at mythbox:~# passwd
> Enter new UNIX password:
> Retype new UNIX password:
> passwd: password updated successfully
> root at mythbox:~#
> root at mythbox:~# exit
> logout
> miro at mythbox:~$ su -
> Password:
> root at mythbox:~#
> root at mythbox:~#
> root at mythbox:~# exit
> logout
> miro at mythbox:~$
> miro at mythbox:~$ sudo mysql -u root -p mythconverg
> Enter password:
> ERROR 1524 (HY000): Plugin 'mysqlnativepassword' is not loaded
> 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>
> <#m_-658443965015245527_DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>
>
> Am Fr., 10. Mai 2019 um 04:40 Uhr schrieb Stephen Worthington <
> stephen_agent at jsw.gen.nz>:
>
>> On Thu, 9 May 2019 21:33:14 +0100, you wrote:
>>
>> >On 09/05/2019 17:18, Stephen Worthington wrote:
>> >> On Thu, 9 May 2019 17:05:59 +0200, you wrote:
>> >>
>> >>> I can log in to the DB using the mythtv User, but not able as root. I
>> dont
>> >>> have the password and also getting the below Error.
>> >>>
>> >>> miro at mythbox:/etc/mythtv$ sudo mysql -u root mythconverg
>> >>> ERROR 1524 (HY000): Plugin 'mysqlnativepassword' is not loaded
>> >>> miro at mythbox:/etc/mythtv$ sudo mysql -u root
>> >>> ERROR 1524 (HY000): Plugin 'mysqlnativepassword' is not loaded
>> >>> miro at mythbox:/etc/mythtv$
>> >>
>> >> I have never met that problem before, but try it looks like it is
>> >> trying to get the root password from the operating system and does not
>> >> have the plugin to do that.  So try with -p and it should ask for the
>> >> root password:
>> >>
>> >> sudo mysql -u root -p mythconverg
>> >>
>> >> And if that does not work try just:
>> >>
>> >> sudo mysql
>> >>
>> >> If that fails, there used to be an obscure bug with caching of
>> >> passwords, the easiest fix for which is to restart MySQL (or reboot):
>> >>
>> >> sudo systemctl restart mysql
>> >>
>> >> If you do not have a root password set, use this command to set it:
>> >>
>> >> sudo passwd
>> >>
>> >Actually, it is complaining about the *mysql* password. To access mysql,
>> any user should be able to
>> >do that. sudo is not required here.
>> >
>> >I would assume that the root password for mysql/mariadb was requested
>> during the installation
>> >procedure. Whenever I have built a clean Debian system with mysql, that
>> is one of the steps that
>> >happens along the way.
>>
>> Yes, setting the MySQL user and password for the mythconverg database
>> should happen on MythTV install in a clean setup.  That does not work
>> though, if you then restore from an old system and copy across the old
>> config.xml which will have a different password.  Since you can not
>> normally set MySQL passwords using the MythTV credentials, and MySQL
>> on a clean system has no other login credentials, you then need to use
>> the root password (the system root password, not the MySQL one) to
>> access MySQL to do the GRANT commands needed.
>>
>> And if you have not set the (system) root password, you probably need
>> to do that before you can use root to run the mysql command.  Since I
>> always set the root password as soon as I boot into a clean system, I
>> have never tried to run mysql from root without a root password set.
>> _______________________________________________
>> mythtv-users mailing list
>> mythtv-users at mythtv.org
>> http://lists.mythtv.org/mailman/listinfo/mythtv-users
>> http://wiki.mythtv.org/Mailing_List_etiquette
>> MythTV Forums: https://forum.mythtv.org
>>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.mythtv.org/pipermail/mythtv-users/attachments/20190510/7c3c19c4/attachment.html>