Mailinglist Archive: opensuse (793 mails)

< Previous Next >
Re: [opensuse] How does one setup mythtv?
  • From: "Carlos E. R." <robin.listas@xxxxxxxxxxxxxx>
  • Date: Thu, 30 Nov 2017 14:39:37 +0100 (CET)
  • Message-id: <alpine.LSU.2.21.1711301431270.31979@Telcontar.valinor>
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1



On Thursday, 2017-11-30 at 08:27 +0100, Per Jessen wrote:

Carlos E. R. wrote:

I'm unsure how to setup mythtv.

I installed:

mythtv-docs-0.28.1+git.20170712.eef6a480b0-1.2.noarch
mythtv-common-0.28.1+git.20170712.eef6a480b0-1.2.x86_64
mythtv-frontend-0.28.1+git.20170712.eef6a480b0-1.2.x86_64
mythtv-base-themes-0.28.1+git.20170712.eef6a480b0-1.2.noarch
mythtv-setup-0.28.1+git.20170712.eef6a480b0-1.2.x86_64
mythtv-backend-0.28.1+git.20170712.eef6a480b0-1.2.x86_64

MythTV has a backend and a frontend. They can easily run on the same
system or on different ones, and you can have multiple backends.

Set up the backend by running "mythsetup", the frontend ("mythfrontend")
will notice it hasn't been configured and will open the config dialogue
automatically when you run it for the first time.

But it doesn't work, it goes in a loop perhaps because it fails to access the database. I thought that program would configure mysql and create the database first.


Nest is "Configuring_MythTV". It says:

«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.»

MySQL was installed automatically at some point (María*) and I started
it - - I did not configure anything on it, everything is at defaults.

You would normally want to set the root password, but it's not
mandatory.

Run "/usr/share/mysql-test/suse-test-run" to verify mysql does work.

How do I create the "MySQL user id"? There are no instructions on
that.

using the mysql command line interface, for instance.

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

mythdb = name you chose for the database.
mythuser = user you chose for accessing the database.
passwd = password of your choice.

All will go into the backend and frontend config.


Well, then what I need is a HOWTO doc on how to setup mysql. That is missing.


Is not the setup program supposed to create and configure the
database?

It will need a userid and a password to do that.

How do I do that?


Isengard:~ # mythtv-setup
2017-11-30 03:54:03.315318 I Setup Interrupt handler
2017-11-30 03:54:03.315355 I Setup Terminated handler
[snip]
2017-11-30 03:54:03.535945 E [DBManager0] Unable to connect to
database!
2017-11-30 03:54:03.535987 E Driver error was [1/1045]:
QMYSQL: Unable to connect
Database error was:
Access denied for user 'mythtv'@'localhost' (using password: YES)

Ok, so the default user is 'mythtv'. You just need to grant it access
to the database - I think the default database might be 'mythconverg'.

And how do I create the database and give the user access to it?

Instructions for all that are missing in the HOWTO.


I see file "/usr/share/doc/packages/mythtv-docs/database/mc.sql"


CREATE DATABASE IF NOT EXISTS mythconverg;
GRANT ALL ON mythconverg.* TO mythtv@localhost IDENTIFIED BY "mythtv";
FLUSH PRIVILEGES;
GRANT CREATE TEMPORARY TABLES ON mythconverg.* TO mythtv@localhost
IDENTIFIED BY "mythtv";
FLUSH PRIVILEGES;
ALTER DATABASE mythconverg DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;


But how do I run that? It is not a bash script.



- -- Cheers,
Carlos E. R.
(from openSUSE 42.2 x86_64 "Malachite" at Telcontar)

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v2

iEYEARECAAYFAlogCiEACgkQtTMYHG2NR9VoXgCeK0+IkHWM6LSx1E2R6cl+5l/m
PPgAoJDDfhQn1b1ftWfAs+o7uDNyx2kE
=QTcj
-----END PGP SIGNATURE-----
< Previous Next >