[mythtv-users] New installation errors

[Stephen Worthington]

On Sat, 16 Sep 2017 18:16:21 -0700, you wrote:

>On 09/16/2017 05:14 PM, Peter Bennett wrote:
>>
>>
>> On 09/16/2017 06:39 PM, Dick Steffens wrote:
>>> I'm still not able to configure the backend. Is it possibly because I 
>>> installed MySQL myself before installing MythTV? If so, do I need to 
>>> create the database and user in MySQL? If so, where can I find 
>>> instructions on what to do?
>>>
>>> Thanks.
>>> <--->
>> If you installed from a package such as the ubuntu repository it 
>> should have set up the database user id for you. 
>
>Yes, I did, but no, it did not.
>
>> In case it did not, or you installed manually, the instructions are here
>> https://www.mythtv.org/wiki/Build_from_Source#MythTV_Database_Setup
>> mysql -u root -p
>> create database mythconverg;
>
>There already was a mythconverg database. See below.
>
>> create user 'mythtv'@'%' identified by 'mythtv';
>
>I got an error message (now lost) when I tried this. I ran
>
>select user, host from mysql.user;
>
>and found that was a mythtv user at host %. I was not able to set a password for it
>(as per a couple of lines down in the instructions), nor was I able to create user mythtv @ localhost, or set a password for it.
>Probably being too clever, I dropped and recreated database mythconverg, and then
>dropped user mythtv and recreated it. Then I was able to finish the rest of this set of instructions.
>
>> create user 'mythtv'@'localhost' identified by 'mythtv';
>> set password for 'mythtv'@'%' = password('mythtv');
>> set password for 'mythtv'@'localhost' = password('mythtv');
>> connect mythconverg;
>> grant all privileges on *.* to 'mythtv'@'%' with grant option;
>> grant all privileges on *.* to 'mythtv'@'localhost' with grant option;
>> flush privileges;
>> exit;
>
>I ran
>
>mysql_tzinfo_to_sql /usr/share/zoneinfo | mysql -u root -p mysql
>
>It appeared to run normally, with the noted warnings seen on the 
>instructions.
>
>Next I ran mythbackend from the terminal. Lots of errors related to 
>mythconverg being empty. I'm guessing that I shouldn't have dropped it 
>and recreated it. An example error message is
>
>Database error was:
>
>Table 'mythconverg.settings' doesn't exist
>
>
>Where can I find the instructions for creating the innards of mythconverg?
>
>Or, is there something else I need to do?
>
>Thanks for your help.

I believe that all you need to do is to run mythtv-setup instead of
mythbackend - it should create all the tables if they are not there.
Or you can restore an old backup database, and then let mythtv-setup
upgrade it to the latest schema.