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 16:39:13 +0100 (CET)
  • Message-id: <alpine.LSU.2.21.1711301635410.31979@Telcontar.valinor>
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1



On Thursday, 2017-11-30 at 16:27 +0100, Per Jessen wrote:
Carlos E. R. wrote:

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.

You just have to grant the "mythtv" user access first.

How exactly?

(see later)

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.

See above :-)

How exactly?

(see later)


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?

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

How exactly?

(see later)

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.

It is plain SQL:

mysql -u root -p </usr/share/doc/packages/mythtv-docs/database/mc.sql

Well, to you it is plain. I do not know SQL at all. It is Greek or Chinese to me.

I figured out that I had to open the program "mysql" as root and paste all those lines one by one. But the backend does not start - see my other post. Missing feature in mysql.


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

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

iEYEARECAAYFAlogJiEACgkQtTMYHG2NR9U7MgCeKnkIiSBx9Ev6bVMbW87u2bx/
LCcAoJJgUI+MT+W3F+vjJLOVhf7NzFkz
=MpVi
-----END PGP SIGNATURE-----

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

< Previous Next >