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



On Thursday, 2017-11-30 at 08:48 -0500, Patrick Shanahan wrote:
* Carlos E. R. <> [11-30-17 08:45]:

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.

from the cl: mysql
or install something like phpMyAdmin for graphical access

Ok, thanks, I run "mysql" as root and pasted each line one by one.



Isengard:~ # mysql
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 12
Server version: 10.0.31-MariaDB SLE 12 SP1 package

Copyright (c) 2000, 2017, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [(none)]> CREATE DATABASE IF NOT EXISTS mythconverg;
Query OK, 1 row affected (0.00 sec)

MariaDB [(none)]> GRANT ALL ON mythconverg.* TO mythtv@localhost IDENTIFIED BY
"mythtv";
Query OK, 0 rows affected (0.00 sec)

MariaDB [(none)]> FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.01 sec)

MariaDB [(none)]> GRANT CREATE TEMPORARY TABLES ON mythconverg.* TO mythtv@localhost
IDENTIFIED BY "mythtv";
Query OK, 0 rows affected (0.01 sec)

MariaDB [(none)]> FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.00 sec)

MariaDB [(none)]> ALTER DATABASE mythconverg DEFAULT CHARACTER SET utf8 COLLATE
utf8_general_ci;
Query OK, 1 row affected (0.00 sec)

MariaDB [(none)]> quit
Bye
Isengard:~ #



But still "mythtvsetup" fails. It asks country and language, I hit save, the display flashes, and again asks country and language.


CLI output is:

cer@Isengard:~> mythtvsetup 2017-11-30 16:03:36.895945 I Setup Interrupt handler
2017-11-30 16:03:36.895986 I Setup Terminated handler
2017-11-30 16:03:36.895997 I Setup Segmentation fault handler
2017-11-30 16:03:36.896012 I Setup Aborted handler
2017-11-30 16:03:36.896022 I Setup Bus error handler
2017-11-30 16:03:36.896036 I Setup Floating point exception handler
2017-11-30 16:03:36.896050 I Setup Illegal instruction handler
2017-11-30 16:03:36.896065 I Setup Real-time signal 0 handler
2017-11-30 16:03:36.896082 I Setup Hangup handler
2017-11-30 16:03:36.896228 C mythtv-setup version: [v0.28.1] www.mythtv.org
2017-11-30 16:03:36.896241 C Qt version: compile: 5.6.1, runtime: 5.6.1
2017-11-30 16:03:36.896246 N Enabled verbose msgs: general
2017-11-30 16:03:36.896262 N Setting Log Level to LOG_INFO
2017-11-30 16:03:36.907624 I Added logging to the console
2017-11-30 16:03:37.106917 N Using runtime prefix = /usr
2017-11-30 16:03:37.106930 N Using configuration directory = /home/cer/.mythtv
2017-11-30 16:03:37.107061 I Assumed character encoding: en_US.UTF-8
2017-11-30 16:03:37.107693 N Empty LocalHostName.
2017-11-30 16:03:37.107703 I Using localhost value of Isengard
2017-11-30 16:03:37.240731 N Desktop video mode: 1920x1080 59.934 Hz
2017-11-30 16:03:37.358467 E LIRC: Failed to connect to Unix socket
'/var/run/lirc/lircd'
eno: No such file or directory (2)
2017-11-30 16:03:37.358513 I No joystick configuration found, not enabling
joystick control
2017-11-30 16:03:37.532133 E CECAdapter: Failed to find any CEC devices.
2017-11-30 16:03:37.532307 I CECAdapter: Closing down CEC.
2017-11-30 16:03:37.532364 I UDPListener: Enabling
2017-11-30 16:03:37.533033 I Binding to UDP 127.0.0.1:0
2017-11-30 16:03:37.533095 I Binding to UDP 192.168.1.16:0
2017-11-30 16:03:37.533158 I Binding to UDP [::1]:0
2017-11-30 16:03:37.533337 I Binding to UDP [fe80::4ecc:6aff:fe61:50a1%eth0]:0
2017-11-30 16:03:37.533403 I Binding to UDP 192.168.1.255:0
2017-11-30 16:03:37.545102 I Using Frameless Window
2017-11-30 16:03:37.545110 I Using Full Screen Window
libGL error: failed to load driver: swrast
2017-11-30 16:03:37.861717 I UI Screen Resolution: 1920 x 1080
2017-11-30 16:03:37.925751 I Using the Qt painter
2017-11-30 16:03:38.864369 N Setting QT default locale to en_US
2017-11-30 16:03:39.117455 I MythUIWebBrowser: Loading css from -
file:///usr/share/mythtv/themes/default/htmls/mythbrowser.css
2017-11-30 16:03:39.123839 I MythUIWebBrowser: enabling plugins
2017-11-30 16:03:39.832664 I System Locale (en_US), Country (US), Language (en)
2017-11-30 16:04:22.361140 I Loading en_us translation for module mythfrontend
2017-11-30 16:04:22.377427 N Setting QT default locale to en_US
2017-11-30 16:04:22.377456 I Current locale en_US
2017-11-30 16:04:22.382417 N Reading locale defaults from
/usr/share/mythtv//locales/en_us.xml
2017-11-30 16:04:22.383212 E SaveSettingOnHost('Country') - No database yet
2017-11-30 16:04:22.383223 E SaveSettingOnHost('FreqTable') - No database yet
2017-11-30 16:04:22.383232 E SaveSettingOnHost('ISO639Language0') - No
database yet
2017-11-30 16:04:22.383240 E SaveSettingOnHost('ISO639Language1') - No
database yet
2017-11-30 16:04:22.383249 E SaveSettingOnHost('Language') - No database yet
2017-11-30 16:04:22.383256 E SaveSettingOnHost('TVFormat') - No database yet
2017-11-30 16:04:22.383263 E SaveSettingOnHost('VbiFormat') - No database yet
2017-11-30 16:04:22.383275 E SaveSettingOnHost('DateFormat') - No database yet
2017-11-30 16:04:22.383285 E SaveSettingOnHost('MythArchiveDateFormat') - No
database yet
2017-11-30 16:04:22.383295 E SaveSettingOnHost('MythArchiveTimeFormat') - No
database yet
2017-11-30 16:04:22.383305 E SaveSettingOnHost('MythArchiveVideoFormat') - No
database yet
2017-11-30 16:04:22.383315 E SaveSettingOnHost('ShortDateFormat') - No
database yet
2017-11-30 16:04:22.383325 E SaveSettingOnHost('TimeFormat') - No database yet
2017-11-30 16:04:22.389376 I Starting process manager
2017-11-30 16:04:22.398404 I Starting process signal handler
2017-11-30 16:04:22.398471 I Starting IO manager (read)
2017-11-30 16:04:22.398472 I Starting IO manager (write)
2017-11-30 16:04:22.949403 I ScreenSaverX11Private: XScreenSaver support
enabled
2017-11-30 16:04:22.957042 I ScreenSaverX11Private: DPMS is active.
2017-11-30 16:04:23.073277 E Error preparing query: SELECT DISTINCT dirname
FROM storagegroup WHERE groupname = :GROUP AND hostname = :HOSTNAME
2017-11-30 16:04:23.073308 E Driver error was [2/1146]:
QMYSQL3: Unable to prepare statement
Database error was:
Table 'mythconverg.storagegroup' doesn't exist

2017-11-30 16:04:23.073676 E DB Error (StorageGroup::StorageGroup()):
Query was:
SELECT DISTINCT dirname FROM storagegroup WHERE groupname = 'Themes' AND
hostname = 'Isengard'
Bindings were:
:GROUP="Themes", :HOSTNAME="Isengard"
Driver error was [2/1146]:
QMYSQL: Unable to execute query
Database error was:
Table 'mythconverg.storagegroup' doesn't exist <=================

2017-11-30 16:04:23.074809 N Inserting MythTV initial database information.
2017-11-30 16:04:23.074855 C Upgrading to MythTV schema version 1307
2017-11-30 16:04:23.219637 I Loading en_us translation for module mythfrontend
2017-11-30 16:04:23.221061 E LIRC: Failed to connect to Unix socket
'/var/run/lirc/lircd'
eno: No such file or directory (2)
2017-11-30 16:04:23.221120 I No joystick configuration found, not enabling
joystick control
2017-11-30 16:04:23.390300 E CECAdapter: Failed to find any CEC devices.
2017-11-30 16:04:23.890587 I CECAdapter: Closing down CEC.
2017-11-30 16:04:23.890617 I UDPListener: Enabling
2017-11-30 16:04:23.892230 I Binding to UDP 127.0.0.1:0
2017-11-30 16:04:23.892302 I Binding to UDP 192.168.1.16:0
2017-11-30 16:04:23.892373 I Binding to UDP [::1]:0
2017-11-30 16:04:23.892480 I Binding to UDP [fe80::4ecc:6aff:fe61:50a1%eth0]:0
2017-11-30 16:04:23.892550 I Binding to UDP 192.168.1.255:0
2017-11-30 16:04:23.960240 I Using Frameless Window
2017-11-30 16:04:23.960251 I Using Full Screen Window
2017-11-30 16:04:23.965391 I UI Screen Resolution: 1920 x 1080
2017-11-30 16:04:23.970726 I Using the Qt painter
2017-11-30 16:04:25.021211 I MythUIWebBrowser: Loading css from -
file:///usr/share/mythtv/themes/default/htmls/mythbrowser.css
2017-11-30 16:04:25.029132 I MythUIWebBrowser: enabling plugins
2017-11-30 16:04:25.727667 I System Locale (en_US), Country (US), Language (en)




So again I tell the country and language, and this time it appears to hold:


2017-11-30 16:10:22.797917 I Loading es_es translation for module mythfrontend
2017-11-30 16:10:22.855960 I Using Frameless Window
2017-11-30 16:10:22.855974 I Using Full Screen Window
2017-11-30 16:10:22.856018 I UI Screen Resolution: 1920 x 1080
2017-11-30 16:10:22.871228 I Using the Qt painter
2017-11-30 16:10:22.965520 I MythUIWebBrowser: Loading css from -
file:///usr/share/mythtv/themes/default/htmls/mythbrowser.css
2017-11-30 16:10:22.971706 I MythUIWebBrowser: enabling plugins
2017-11-30 16:10:23.017697 W MythPainter: 17 images not yet de-allocated.
cer@Isengard:~>


Maybe it will work after all...

Trying the frontend. It says, in Spanish, that the database is outdated by 37
versions!
That I should run mythtv-setup to update my database, and exits.


Maybe the problem is that I'm running it via ssh to another machine. :-?


Ah, the server is not running. Start it:

Isengard:~ # systemctl status mythbackend.service ● mythbackend.service - MythTV backend service
Loaded: loaded (/usr/lib/systemd/system/mythbackend.service; disabled;
vendor preset: disabled)
Active: inactive (dead)
Isengard:~ # systemctl start mythbackend.service Isengard:~ # systemctl status mythbackend.service ● mythbackend.service - MythTV backend service
Loaded: loaded (/usr/lib/systemd/system/mythbackend.service; disabled;
vendor preset: disabled)
Active: failed (Result: exit-code) since Thu 2017-11-30 16:19:04 CET; 1s ago
Process: 22991 ExecStart=/usr/bin/mythbackend --logpath /var/log/mythtv
$MYTHBACKEND_OPTIONS (code=exited, status=153)
Main PID: 22991 (code=exited, status=153)

Nov 30 16:19:04 Isengard mythbackend[22991]: 2017-11-30 16:19:04.410120 N
Empty LocalHostName.
Nov 30 16:19:04 Isengard mythbackend[22991]: 2017-11-30 16:19:04.410128 I
Using localhost value of Isengard
Nov 30 16:19:04 Isengard mythbackend[22991]: 2017-11-30 16:19:04.429163 N
Setting QT default locale to es_ES
Nov 30 16:19:04 Isengard mythbackend[22991]: 2017-11-30 16:19:04.429186 I
Current locale es_ES
Nov 30 16:19:04 Isengard mythbackend[22991]: 2017-11-30 16:19:04.429279 N
Reading locale defaults from /usr/share/mythtv//locales/es_es.xml
Nov 30 16:19:04 Isengard mythbackend[22991]: 2017-11-30 16:19:04.439958 I
Loading es_es translation for module mythfrontend
Nov 30 16:19:04 Isengard mythbackend[22991]: 2017-11-30 16:19:04.442379 E
MySQL time zone support is missing. Please install it and try again. See
'mysql_tzinfo_to_sql' for assistance.
Nov 30 16:19:04 Isengard systemd[1]: mythbackend.service: Main process exited,
code=exited, status=153/n/a
Nov 30 16:19:04 Isengard systemd[1]: mythbackend.service: Unit entered failed
state.
Nov 30 16:19:04 Isengard systemd[1]: mythbackend.service: Failed with result
'exit-code'.
Isengard:~ #


WTF?

MySQL time zone support is missing. Please install it and try again.

How on earth do I do that?

- -- Cheers,
Carlos E. R.
(from openSUSE 42.2 x86_64 "Malachite" at Telcontar)
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v2

iEYEARECAAYFAlogIpkACgkQtTMYHG2NR9XFRQCfZMXJ/Ri2xvtPInFN8K5mTBmQ
opgAnRpZ2w7zifSxB4m8EmEI19VrVSJo
=PxUF
-----END PGP SIGNATURE-----
< Previous Next >
Follow Ups