Mailinglist Archive: opensuse (793 mails)

< Previous Next >
Re: [opensuse] How does one setup mythtv?
  • From: Per Jessen <per@xxxxxxxxxxxx>
  • Date: Thu, 30 Nov 2017 20:59:04 +0100
  • Message-id: <ovpnu8$i61$1@saturn.local.net>
Carlos E. R. wrote:

On Thursday, 2017-11-30 at 18:28 +0100, Per Jessen wrote:

«Once the software has been installed, MythTV must be configured
before you can use it. It needs to know what TV tuners you will use,
where to store recordings and other files, how you will be using it.

This guide assumes you have already installed MythTV, MySQL, created
the MySQL user id and set up your backend to automatically start. If
you used a Mythbuntu or a package from the Mythbuntu PPA these have
already been done.»

Note: "assumes you have already installed MySQL, created the
MySQL user id and set up your backend to automatically start.

How on earth would I do that if they don't explain how to do that?

Well, they don't explain to you how to login either nor how to install
the software. When you're not very familiar with mysql it's a bit of
steep learning curve. As for the mysql userid, I explained that
earlier today, and it is also done when you run that script, "mc.sql".

Create MySQL user id. How?

Quoting myself:

using the mysql command line interface, for instance.

"grant all privileges on <mythdb>.* to '<mythuser>'@'localhost'
identified by '<passwd>'"

As it happens, it is also done automatically by the 'mc.sql' script.

Set the backend to start automatically. Well, it refuses, it fails
with cryptic errors.

It just needs the timezone tables populated. There is a script for
that, it is a well-documented procedure.

Those instructions assume that I am an MySQL expert. I am not. I need
handholding. :-(

That's what we're doing. :-)

You run the script 'mysql_tzinfo_to_sql" which will generate the
necessary sql, then pipe that into the mysql client:

mysql_tzinfo_to_sql /usr/share/zoneinfo | mysql -u root -p mysql

How was I supposed to know that? I have never done such a thing.

You aren't supposed to know, but the page I mentioned does explain it.

Well, it asks for a password. Which one?
I have not defined any password.

If you have no root password, either:

a) omit the -p option to mysql.
b) logged in as root, set a password using 'mysqladmin password'.

The latter is a normal part of installing mysql - normally the mysql
start script will remind you, but maybe something was lost in the
conversion to systemd, I dunno.

Notice: I have not setup mariadb AT ALL. I do nothing with it.
Anything I should do with it, the mythtv people should explain in
detail :-(

As far as mythtv is concerned, you only need to run the script they have
provided, as well as populate the timezone tables.

I suggest the following:

set the root password using "mysqladmin password".
populate the timezone tables using the tzinfo script.
run the mc.sql script to set up the mythtv stuff.
start the mythbackend



--
Per Jessen, Zürich (0.9°C)
http://www.dns24.ch/ - your free DNS host, made in Switzerland.


--
To unsubscribe, e-mail: opensuse+unsubscribe@xxxxxxxxxxxx
To contact the owner, e-mail: opensuse+owner@xxxxxxxxxxxx

< Previous Next >
Follow Ups