![](https://seccdn.libravatar.org/avatar/77cb4da5f72bc176182dcc33f03a18f3.jpg?s=120&d=mm&r=g)
-----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-----