[opensuse] How does one setup mythtv?
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hi, 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 In file /usr/share/doc/packages/mythtv-docs/docs/README.HOWTO says one has to read http://www.mythtv.org/wiki/MythTV-HOWTO, so I do. .../Category:Software_Installation says nothing for *SUSE, so I assume I just need to install the openSUSE packages. Next step is "Post_Installation_Tasks", and again, nothing to do. 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. 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. Start the backend automatically? It is not configured yet. Sure? Next step is <https://www.mythtv.org/wiki/Setup_General> I try run "mythtv-setup" as root. It asks country and language, then tries to access mysql, apparently fails, asks where it is, click finish, and it loops again to the first step, nothing saved despite having clicked "save". What can I do? Those instructions are not clear at all, and I see no docus for openSUSE. None in our wiki, either. Is not the setup program supposed to create and configure the database? 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 2017-11-30 03:54:03.315365 I Setup Segmentation fault handler 2017-11-30 03:54:03.315373 I Setup Aborted handler 2017-11-30 03:54:03.315381 I Setup Bus error handler 2017-11-30 03:54:03.315389 I Setup Floating point exception handler 2017-11-30 03:54:03.315401 I Setup Illegal instruction handler 2017-11-30 03:54:03.315415 I Setup Real-time signal 0 handler 2017-11-30 03:54:03.315430 I Setup Hangup handler 2017-11-30 03:54:03.315570 C mythtv-setup version: [v0.28.1] www.mythtv.org 2017-11-30 03:54:03.315584 C Qt version: compile: 5.6.1, runtime: 5.6.1 2017-11-30 03:54:03.315588 N Enabled verbose msgs: general 2017-11-30 03:54:03.315610 N Setting Log Level to LOG_INFO 2017-11-30 03:54:03.326593 I Added logging to the console 2017-11-30 03:54:03.525984 N Using runtime prefix = /usr 2017-11-30 03:54:03.525996 N Using configuration directory = /root/.mythtv 2017-11-30 03:54:03.526138 I Assumed character encoding: POSIX 2017-11-30 03:54:03.526144 W This application expects to be running a locale that specifies a UTF-8 codeset, and many features may behave improperly with your current language settings. Please set the LANG variable(s) in the environment in which this program is executed to include a UTF-8 codeset (such as 'en_US.UTF-8'). 2017-11-30 03:54:03.526733 N Empty LocalHostName. 2017-11-30 03:54:03.526741 I Using localhost value of Isengard 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) 2017-11-30 03:54:03.653334 N Desktop video mode: 1920x1080 59.934 Hz 2017-11-30 03:54:03.769752 E LIRC: Failed to connect to Unix socket '/var/run/lirc/lircd' eno: No such file or directory (2) 2017-11-30 03:54:03.769798 I No joystick configuration found, not enabling joystick control 2017-11-30 03:54:03.938387 E CECAdapter: Failed to find any CEC devices. 2017-11-30 03:54:03.938599 I CECAdapter: Closing down CEC. 2017-11-30 03:54:03.938656 I UDPListener: Enabling 2017-11-30 03:54:03.939349 I Binding to UDP 127.0.0.1:0 2017-11-30 03:54:03.939414 I Binding to UDP 192.168.1.16:0 2017-11-30 03:54:03.939474 I Binding to UDP [::1]:0 2017-11-30 03:54:03.939639 I Binding to UDP [fe80::4ecc:6aff:fe61:50a1%eth0]:0 2017-11-30 03:54:03.939703 I Binding to UDP 192.168.1.255:0 2017-11-30 03:54:03.951401 I Using Frameless Window 2017-11-30 03:54:03.951409 I Using Full Screen Window libGL error: failed to load driver: swrast 2017-11-30 03:54:04.227727 I UI Screen Resolution: 1920 x 1080 2017-11-30 03:54:04.276658 I Using the Qt painter 2017-11-30 03:54:05.215532 N Setting QT default locale to en_US 2017-11-30 03:54:05.470302 I MythUIWebBrowser: Loading css from - file:///usr/share/mythtv/themes/default/htmls/mythbrowser.css 2017-11-30 03:54:05.476714 I MythUIWebBrowser: enabling plugins 2017-11-30 03:54:06.141178 I System Locale (en_US), Country (US), Language (en) 2017-11-30 03:54:21.718663 I Loading en_us translation for module mythfrontend 2017-11-30 03:54:28.797334 E [DBManager1] Unable to connect to database! 2017-11-30 03:54:28.797354 E Driver error was [1/1045]: QMYSQL: Unable to connect Database error was: Access denied for user 'mythtv'@'localhost' (using password: YES) 2017-11-30 03:54:28.797378 A Cannot login to database 2017-11-30 03:54:28.913039 E LIRC: Failed to connect to Unix socket '/var/run/lirc/lircd' eno: No such file or directory (2) 2017-11-30 03:54:28.913072 I No joystick configuration found, not enabling joystick control 2017-11-30 03:54:29.067939 E CECAdapter: Failed to find any CEC devices. 2017-11-30 03:54:29.568221 I CECAdapter: Closing down CEC. 2017-11-30 03:54:29.568261 I UDPListener: Enabling 2017-11-30 03:54:29.568480 I Binding to UDP 127.0.0.1:0 2017-11-30 03:54:29.568540 I Binding to UDP 192.168.1.16:0 2017-11-30 03:54:29.568603 I Binding to UDP [::1]:0 2017-11-30 03:54:29.568706 I Binding to UDP [fe80::4ecc:6aff:fe61:50a1%eth0]:0 2017-11-30 03:54:29.568778 I Binding to UDP 192.168.1.255:0 2017-11-30 03:54:29.580310 I Using Frameless Window 2017-11-30 03:54:29.580317 I Using Full Screen Window 2017-11-30 03:54:29.584335 I UI Screen Resolution: 1920 x 1080 2017-11-30 03:54:29.588736 I Using the Qt painter 2017-11-30 03:54:30.633849 I MythUIWebBrowser: Loading css from - file:///usr/share/mythtv/themes/default/htmls/mythbrowser.css 2017-11-30 03:54:30.639512 I MythUIWebBrowser: enabling plugins 2017-11-30 03:54:31.299038 I System Locale (en_US), Country (US), Language (en) 2017-11-30 03:54:33.398074 I Loading en_us translation for module mythfrontend 2017-11-30 03:54:35.573727 A User cancelled database configuration 2017-11-30 03:54:35.602216 E Failed to init MythContext, exiting. Isengard:~ # - -- Cheers Carlos E. R. (from 42.2 x86_64 "Malachite" at Telcontar) -----BEGIN PGP SIGNATURE----- Version: GnuPG v2 iEYEARECAAYFAlofdxMACgkQtTMYHG2NR9WSFwCePFDyxl/9yQ8Ex4xAYmH+GWqz xscAnjmhSmW7ViXVKunHTDzJ0fnqhJO5 =O5Xd -----END PGP SIGNATURE-----
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.
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.
Start the backend automatically? It is not configured yet. Sure?
Yes, that doesn't sound right, but it won't hurt.
Next step is <https://www.mythtv.org/wiki/Setup_General>
I try run "mythtv-setup" as root. It asks country and language, then tries to access mysql, apparently fails, asks where it is, click finish, and it loops again to the first step, nothing saved despite having clicked "save".
What can I do? Those instructions are not clear at all, and I see no docus for openSUSE. None in our wiki, either.
There is nothing openSUSE specific in mythtv.
Is not the setup program supposed to create and configure the database?
It will need a userid and a password to 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'. -- Per Jessen, Zürich (2.0°C) http://www.cloudsuisse.com/ - your owncloud, hosted in Switzerland. -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse+owner@opensuse.org
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.
Oops - and of course multiple frontends too. -- Per Jessen, Zürich (1.5°C) http://www.dns24.ch/ - free dynamic DNS, made in Switzerland. -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse+owner@opensuse.org
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On Thursday, 2017-11-30 at 08:29 +0100, Per Jessen wrote:
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.
Oops - and of course multiple frontends too.
Yes, I saw that on the howto. A decade ago I set up mythtv, but now I have forgotten. I suppose I set up mysql, but I have forgotten how to do that, too, and the howto doesn't say anything. - -- Cheers, Carlos E. R. (from openSUSE 42.2 x86_64 "Malachite" at Telcontar) -----BEGIN PGP SIGNATURE----- Version: GnuPG v2 iEYEARECAAYFAlogCo0ACgkQtTMYHG2NR9U2WwCgiARnHT29DQp20iq2BiOnVfkX 7dsAn0moyHX65nDYJrpVXQ8Xgix5tsQi =q79p -----END PGP SIGNATURE----- -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse+owner@opensuse.org
-----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-----
* Carlos E. R. <robin.listas@telefonica.net> [11-30-17 08:45]:
-----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.
from the cl: mysql or install something like phpMyAdmin for graphical access -- (paka)Patrick Shanahan Plainfield, Indiana, USA @ptilopteri http://en.opensuse.org openSUSE Community Member facebook/ptilopteri Registered Linux User #207535 @ http://linuxcounter.net Photos: http://wahoo.no-ip.org/piwigo paka @ IRCnet freenode -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse+owner@opensuse.org
-----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-----
Carlos E. R. wrote:
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
Ah, that looks better.
So again I tell the country and language, and this time it appears to hold:
Right, the database got populated.
MySQL time zone support is missing. Please install it and try again. How on earth do I do that?
https://mariadb.com/kb/en/library/mysql_tzinfo_to_sql/ The script is in the mariadb-tools package. -- Per Jessen, Zürich (2.4°C) http://www.hostsuisse.com/ - dedicated server rental in Switzerland. -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse+owner@opensuse.org
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On Thursday, 2017-11-30 at 16:41 +0100, Per Jessen wrote:
Carlos E. R. wrote:
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
Ah, that looks better.
So again I tell the country and language, and this time it appears to hold:
Right, the database got populated.
MySQL time zone support is missing. Please install it and try again. How on earth do I do that?
https://mariadb.com/kb/en/library/mysql_tzinfo_to_sql/
The script is in the mariadb-tools package.
That package was already installed. Now what? The backend refuses to start with that error. Where is the hammer? :-? - -- Cheers, Carlos E. R. (from openSUSE 42.2 x86_64 "Malachite" at Telcontar) -----BEGIN PGP SIGNATURE----- Version: GnuPG v2 iEYEARECAAYFAlogKx8ACgkQtTMYHG2NR9Xn9gCeMrvWrv8MiTG6AD/aqWrdlgO2 TwsAoJPX6/IRcxzDmwKQUzGiiLkERTDl =rc63 -----END PGP SIGNATURE----- -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse+owner@opensuse.org
Carlos E. R. wrote:
On Thursday, 2017-11-30 at 16:41 +0100, Per Jessen wrote:
Carlos E. R. wrote:
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
Ah, that looks better.
So again I tell the country and language, and this time it appears to hold:
Right, the database got populated.
MySQL time zone support is missing. Please install it and try again. How on earth do I do that?
https://mariadb.com/kb/en/library/mysql_tzinfo_to_sql/
The script is in the mariadb-tools package.
That package was already installed.
Now what? The backend refuses to start with that error. Where is the hammer?
Well, follow the instructions from the link above to populate the necessary zoneinfo table(s). 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 -- Per Jessen, Zürich (2.5°C) http://www.hostsuisse.com/ - dedicated server rental in Switzerland. -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse+owner@opensuse.org
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On Thursday, 2017-11-30 at 18:28 +0100, Per Jessen wrote:
Carlos E. R. wrote:
On Thursday, 2017-11-30 at 16:41 +0100, Per Jessen wrote:
Right, the database got populated.
MySQL time zone support is missing. Please install it and try again. How on earth do I do that?
https://mariadb.com/kb/en/library/mysql_tzinfo_to_sql/
The script is in the mariadb-tools package.
That package was already installed.
Now what? The backend refuses to start with that error. Where is the hammer?
Well, follow the instructions from the link above to populate the necessary zoneinfo table(s).
There are no instructions on how to setup the database. The instructions are: <https://www.mythtv.org/wiki/Configuring_MythTV> «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? Create MySQL user id. How? Set the backend to start automatically. Well, it refuses, it fails with cryptic errors. Those instructions assume that I am an MySQL expert. I am not. I need handholding. :-( Ah, you mean the instructions on the mariadb site? Wow. :-(
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. Well, it asks for a password. Which one? I have not defined any password. Isengard:~ # mysql_tzinfo_to_sql /usr/share/zoneinfo | mysql -u root -p mysql Enter password: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES) Isengard:~ # 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 :-( I did setup mysql once, a decade or two ago. I don't remember what I did. - -- Cheers, Carlos E. R. (from openSUSE 42.2 x86_64 "Malachite" at Telcontar) -----BEGIN PGP SIGNATURE----- Version: GnuPG v2 iEYEARECAAYFAlogWdYACgkQtTMYHG2NR9XHIQCfQPbJTdASXVk0oga3hCc7d8yT ATAAn2f6PX+qmIlQ4cowHRan5TLNLTTi =SS6a -----END PGP SIGNATURE-----
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@opensuse.org To contact the owner, e-mail: opensuse+owner@opensuse.org
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Content-ID: <alpine.LSU.2.21.1711302217210.14421@Telcontar.valinor> On Thursday, 2017-11-30 at 20:59 +0100, Per Jessen wrote:
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>'"
Password?
As it happens, it is also done automatically by the 'mc.sql' script.
But I think that the script is wrong, because the frontend complains the database is 37 versions old, to run setup to correct it. I think it is the backendsetuptool which has to create the database instead, for which the user id must be set before.
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.
Yes, but it fails. It is a documented procedure but I'm not an mysql expert to know about it.
Those instructions assume that I am an MySQL expert. I am not. I need handholding. :-(
That's what we're doing. :-)
Thanks :-)
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.
Yes, but it is a page outside of the mythtv howto pages.
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.
It certainly didn't ask me anything. See later.
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
Ok. I will do something else: /var/lib/mysql and restart the service. Done. Success. Does not ask to setup a password. The data directory is created again. Isengard:~ # mysqladmin password New password: Confirm new password: Isengard:~ # mysql_tzinfo_to_sql /usr/share/zoneinfo | mysql -u root -p mysql .... Done. Isengard:~ # cat /usr/share/doc/packages/mythtv-docs/database/mc.sql | mysql -u root -p mysql Enter password: Isengard:~ # Good! Finally: 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 22:01:16 CET; 1s ago Process: 32392 ExecStart=/usr/bin/mythbackend --logpath /var/log/mythtv $MYTHBACKEND_OPTIONS (code=exited, status=138) Main PID: 32392 (code=exited, status=138) Nov 30 22:01:16 Isengard mythbackend[32392]: 2017-11-30 22:01:16.468585 C Upgrading to MythTV schema version 1344 Nov 30 22:01:16 Isengard mythbackend[32392]: 2017-11-30 22:01:16.470940 I Database schema upgrade complete. <========== Nov 30 22:01:16 Isengard mythbackend[32392]: 2017-11-30 22:01:16.471440 I Loading en_us translation for module mythfrontend <====== Nov 30 22:01:16 Isengard mythbackend[32392]: 2017-11-30 22:01:16.476693 E MythCoreContext::GetBackendServerIP(): No address defined for host: localhost Nov 30 22:01:16 Isengard mythbackend[32392]: 2017-11-30 22:01:16.477788 E MythSocket(27f5040:-1): Failed to connect to (::1:6543) Connection refused Nov 30 22:01:16 Isengard mythbackend[32392]: 2017-11-30 22:01:16.479517 E MythCoreContext::GetBackendServerIP(): No address defined for host: Isengard Nov 30 22:01:16 Isengard mythbackend[32392]: 2017-11-30 22:01:16.572938 I Removed logging to /var/log/mythtv/mythbackend.20171130210116.32392.log Nov 30 22:01:16 Isengard systemd[1]: mythbackend.service: Main process exited, code=exited, status=138/n/a Nov 30 22:01:16 Isengard systemd[1]: mythbackend.service: Unit entered failed state. Nov 30 22:01:16 Isengard systemd[1]: mythbackend.service: Failed with result 'exit-code'. Isengard:~ # My guess is that it is trying to connect to the database via network and that is disabled by default. That would be in /etc/my.cnf. I suppose it is this: # These are commonly set, remove the # and set as required. port = 3306 socket = /var/run/mysql/mysql.sock Now try to start the backend - fails again, same error. Why is it trying (::1:6543)? mythbackend also fails: Isengard:~ # mythbackend No setting found for this machine's BackendServerIP. Please run setup on this machine and modify the first page of the general settings. 2017-11-30 22:08:03.906309 C mythbackend version: [v0.28.1] www.mythtv.org 2017-11-30 22:08:03.906344 C Qt version: compile: 5.6.1, runtime: 5.6.1 2017-11-30 22:08:03.906349 N Enabled verbose msgs: general 2017-11-30 22:08:03.906379 N Setting Log Level to LOG_INFO 2017-11-30 22:08:03.917578 I Added logging to the console 2017-11-30 22:08:03.917969 I Setup Interrupt handler 2017-11-30 22:08:03.917985 I Setup Terminated handler 2017-11-30 22:08:03.917995 I Setup Segmentation fault handler 2017-11-30 22:08:03.918007 I Setup Aborted handler 2017-11-30 22:08:03.918015 I Setup Bus error handler 2017-11-30 22:08:03.918028 I Setup Floating point exception handler 2017-11-30 22:08:03.918040 I Setup Illegal instruction handler 2017-11-30 22:08:03.918062 I Setup Real-time signal 0 handler 2017-11-30 22:08:03.918078 I Setup Hangup handler 2017-11-30 22:08:03.918166 N Using runtime prefix = /usr 2017-11-30 22:08:03.918171 N Using configuration directory = /root/.mythtv 2017-11-30 22:08:03.918299 I Assumed character encoding: POSIX 2017-11-30 22:08:03.918310 W This application expects to be running a locale that specifies a UTF-8 codeset, and many features may behave improperly with your current language settings. Please set the LANG variable(s) in the environment in which this program is executed to include a UTF-8 codeset (such as 'en_US.UTF-8'). 2017-11-30 22:08:03.918744 N Empty LocalHostName. 2017-11-30 22:08:03.918756 I Using localhost value of Isengard 2017-11-30 22:08:03.935381 N Setting QT default locale to en_US 2017-11-30 22:08:03.935405 I Current locale en_US 2017-11-30 22:08:03.935494 N Reading locale defaults from /usr/share/mythtv//locales/en_us.xml 2017-11-30 22:08:03.948038 I Loading en_us translation for module mythfrontend 2017-11-30 22:08:03.954712 I Current MythTV Schema Version (DBSchemaVer): 1344 2017-11-30 22:08:03.955180 I Loading en_us translation for module mythfrontend 2017-11-30 22:08:03.960970 E MythCoreContext::GetBackendServerIP(): No address defined for host: localhost 2017-11-30 22:08:03.962259 E MythSocket(25390d0:-1): Failed to connect to (::1:6543) Connection refused 2017-11-30 22:08:03.965046 E MythCoreContext::GetBackendServerIP(): No address defined for host: Isengard Isengard:~ # mythtvsetup does run, however. In general config it asks about "Port" and "status port". 6543 and 6544. Suppose I should leave alone. It asks a lot of questions I have no idea about. And I can not exit without answering "no storage group directories are defined... you must add at least one." But I have no idea where to set it up (system or home?), I have no TV card. And this time it has not asked at all about my country and language, it is using English and USA settings without asking, which is wrong. The backend still fails to start: 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 22:18:07 CET; 2s ago Process: 9367 ExecStart=/usr/bin/mythbackend --logpath /var/log/mythtv $MYTHBACKEND_OPTIONS (code=exited, status=1/FAILURE) Main PID: 9367 (code=exited, status=1/FAILURE) Nov 30 22:18:07 Isengard mythbackend[9367]: 2017-11-30 22:18:07.506713 I Loading en_us translation for module mythfrontend Nov 30 22:18:07 Isengard mythbackend[9367]: 2017-11-30 22:18:07.510435 N MythBackend: Starting up as the master server. Nov 30 22:18:07 Isengard mythbackend[9367]: 2017-11-30 22:18:07.513010 W MythBackend: No valid capture cards are defined in the database. Nov 30 22:18:07 Isengard mythbackend[9367]: 2017-11-30 22:18:07.517338 E Scheduler: No capture cards are defined in the database. Nov 30 22:18:07 Isengard mythbackend[9367]: Perhaps you should re-read the installation instructions? Nov 30 22:18:07 Isengard mythbackend[9367]: 2017-11-30 22:18:07.567965 I Added logging to /var/log/mythtv/mythbackend.20171130211807.9367.log Nov 30 22:18:07 Isengard mythbackend[9367]: 2017-11-30 22:18:07.660817 I Removed logging to /var/log/mythtv/mythbackend.20171130211807.9367.log Nov 30 22:18:07 Isengard systemd[1]: mythbackend.service: Main process exited, code=exited, status=1/FAILURE Nov 30 22:18:07 Isengard systemd[1]: mythbackend.service: Unit entered failed state. Nov 30 22:18:07 Isengard systemd[1]: mythbackend.service: Failed with result 'exit-code'. Isengard:~ # I think it wants a card, and I do not have one nor intention to add one, you know that. For others: the intention is to use mythtv to view media files created by other programs. If it is impossible to run without a card, it is a dead end. And the backend service doesn't run. - -- Cheers, Carlos E. R. (from openSUSE 42.2 x86_64 "Malachite" at Telcontar) -----BEGIN PGP SIGNATURE----- Version: GnuPG v2 iEYEARECAAYFAlogeFoACgkQtTMYHG2NR9V6FgCfUZHuLOiGF+knJhRo+GjnBTFS vVIAoJcjyFljkxu9eAS4jviHEbqMl47y =cwd7 -----END PGP SIGNATURE-----
Carlos E. R. wrote:
On Thursday, 2017-11-30 at 20:59 +0100, Per Jessen wrote:
Quoting myself:
using the mysql command line interface, for instance.
"grant all privileges on <mythdb>.* to '<mythuser>'@'localhost' identified by '<passwd>'"
Password?
Any password you want, in cleartext.
As it happens, it is also done automatically by the 'mc.sql' script.
But I think that the script is wrong, because the frontend complains the database is 37 versions old, to run setup to correct it.
That script only creates the database and the userid, it does not create any tables.
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.
Yes, but it fails. It is a documented procedure but I'm not an mysql expert to know about it.
No expert knowledge required, you only need to run the script. How does it fail? If it is about the password, I have already explained that.
22:01:16.476693 E MythCoreContext::GetBackendServerIP(): No address defined for host: localhost Nov 30 22:01:16 Isengard mythbackend[32392]: 2017-11-30 22:01:16.477788 E MythSocket(27f5040:-1): Failed to connect to (::1:6543) Connection refused
This is the backend trying to connect to iself (the backend listens on 6543 and 6544). Weird.
mythtvsetup does run, however. In general config it asks about "Port" and "status port". 6543 and 6544. Suppose I should leave alone.
Yup.
It asks a lot of questions I have no idea about. And I can not exit without answering "no storage group directories are defined... you must add at least one." But I have no idea where to set it up (system or home?),
It just needs a directory with some space. /var/spool/mythtv is what I use.
I have no TV card.
It should be irrelevant, but I haven't tried setting up a backend without a tv card.
And this time it has not asked at all about my country and language, it is using English and USA settings without asking, which is wrong.
So change it. It is probably what you set earlier.
Nov 30 22:18:07 Isengard mythbackend[9367]: 2017-11-30 22:18:07.513010 W MythBackend: No valid capture cards are defined in the database. Nov 30 22:18:07 Isengard mythbackend[9367]: 2017-11-30 22:18:07.517338 E Scheduler: No capture cards are defined in the database. Nov 30 22:18:07 Isengard mythbackend[9367]: Perhaps you should re-read the installation instructions?
I wonder if there might be a "null" capture card. Or maybe you just any card, at random. -- Per Jessen, Zürich (1.4°C) http://www.hostsuisse.com/ - dedicated server rental in Switzerland. -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse+owner@opensuse.org
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On Thursday, 2017-11-30 at 23:09 +0100, Per Jessen wrote:
Carlos E. R. wrote:
On Thursday, 2017-11-30 at 20:59 +0100, Per Jessen wrote:
Quoting myself:
using the mysql command line interface, for instance.
"grant all privileges on <mythdb>.* to '<mythuser>'@'localhost' identified by '<passwd>'"
Password?
Any password you want, in cleartext.
Yes, that part is solved :-)
As it happens, it is also done automatically by the 'mc.sql' script.
But I think that the script is wrong, because the frontend complains the database is 37 versions old, to run setup to correct it.
That script only creates the database and the userid, it does not create any tables.
Ah, ok.
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.
Yes, but it fails. It is a documented procedure but I'm not an mysql expert to know about it.
No expert knowledge required, you only need to run the script. How does it fail? If it is about the password, I have already explained that.
22:01:16.476693 E MythCoreContext::GetBackendServerIP(): No address defined for host: localhost Nov 30 22:01:16 Isengard mythbackend[32392]: 2017-11-30 22:01:16.477788 E MythSocket(27f5040:-1): Failed to connect to (::1:6543) Connection refused
This is the backend trying to connect to iself (the backend listens on 6543 and 6544). Weird.
I thought it was trying to connect to mysql, but no, it is different.
mythtvsetup does run, however. In general config it asks about "Port" and "status port". 6543 and 6544. Suppose I should leave alone.
Yup.
It asks a lot of questions I have no idea about. And I can not exit without answering "no storage group directories are defined... you must add at least one." But I have no idea where to set it up (system or home?),
It just needs a directory with some space. /var/spool/mythtv is what I use.
owned by whom? Should it already exist? I'll point it to somewhere on the external rotating rust. The internal is small and SSD. /data/waterhoard/mythtv It complains that the directory does not exist, and please fix it. Absurd, can't it create a directory? I do not know what permissions to use. I can not login as "mythtv", it is "nologin" user, to create the path. Ok, created.
I have no TV card.
It should be irrelevant, but I haven't tried setting up a backend without a tv card.
And this time it has not asked at all about my country and language, it is using English and USA settings without asking, which is wrong.
So change it. It is probably what you set earlier.
I don't see where. No, it is using USA settings. Earlier I set up Spanish settings. I see settings one to eight, and none asks about country/language. I also tried to delete the mythtv on /root, no good - that's for the client.
Nov 30 22:18:07 Isengard mythbackend[9367]: 2017-11-30 22:18:07.513010 W MythBackend: No valid capture cards are defined in the database. Nov 30 22:18:07 Isengard mythbackend[9367]: 2017-11-30 22:18:07.517338 E Scheduler: No capture cards are defined in the database. Nov 30 22:18:07 Isengard mythbackend[9367]: Perhaps you should re-read the installation instructions?
I wonder if there might be a "null" capture card. Or maybe you just any card, at random.
It will try to probe it. I will do some reading... - -- Cheers, Carlos E. R. (from openSUSE 42.2 x86_64 "Malachite" at Telcontar) -----BEGIN PGP SIGNATURE----- Version: GnuPG v2 iEYEARECAAYFAlogibMACgkQtTMYHG2NR9WqfACbBl1JT6L0n6PUrBbaOOJW8h2x xTIAoJJaSqrXv0K53BRS5cMwE+b0luB4 =tQtj -----END PGP SIGNATURE----- -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse+owner@opensuse.org
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On Thursday, 2017-11-30 at 23:44 +0100, Carlos E. R. wrote:
On Thursday, 2017-11-30 at 23:09 +0100, Per Jessen wrote:
Carlos E. R. wrote:
And this time it has not asked at all about my country and language, it is using English and USA settings without asking, which is wrong.
So change it. It is probably what you set earlier.
I don't see where. No, it is using USA settings. Earlier I set up Spanish settings.
I see settings one to eight, and none asks about country/language. I also tried to delete the mythtv on /root, no good - that's for the client.
I was running the setup via ssh to my multimedia server machine. Now I tried directly on the server: it coredumps. Could not connect to display. This is another issue, yast also fails. Also "xeyes" (Error: can't open display"). I think "su -" doesn't set the correct vars or permissions. I'll open another thread about that one, happens on some of my computers and not others. - -- Cheers, Carlos E. R. (from openSUSE 42.2 x86_64 "Malachite" at Telcontar) -----BEGIN PGP SIGNATURE----- Version: GnuPG v2 iEYEARECAAYFAlogjrAACgkQtTMYHG2NR9Wv9QCeLU8QL2/gFSFErRFIZ3yLO2bq cHkAniaY4PVeh3luedUxxcIx6DTbXpMv =Qtlk -----END PGP SIGNATURE----- -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse+owner@opensuse.org
Carlos E. R. wrote:
It asks a lot of questions I have no idea about. And I can not exit without answering "no storage group directories are defined... you must add at least one." But I have no idea where to set it up (system or home?),
It just needs a directory with some space. /var/spool/mythtv is what I use.
owned by whom? Should it already exist?
On my system, the backend runs as mythbackend:video, but check what the service unit says. systemctl cat mythbackend.service
It complains that the directory does not exist, and please fix it. Absurd, can't it create a directory? I do not know what permissions to use. I can not login as "mythtv", it is "nologin" user, to create the path.
To login as a "nologin" user: su -s /bin/sh mythtv. But it's hardly needed to create a directory owned by somebody else.
I have no TV card.
It should be irrelevant, but I haven't tried setting up a backend without a tv card.
And this time it has not asked at all about my country and language, it is using English and USA settings without asking, which is wrong.
So change it. It is probably what you set earlier.
I don't see where. No, it is using USA settings. Earlier I set up Spanish settings.
Language/locale settings are in the frontend, under "Setup->Appearance". They are tied to the user. The database country/language are set when you first create it. I actually don't know where to change that, but as you haven't used the database yet, you could just repeat the exercise - drop database, run script, run frontend.
I also tried to delete the mythtv on /root, no good - that's for the client.
The frontend client runs as the local user, not as root. On my setup, /root/.mythtv is a link to "/var/lib/mythtv/.mythtv/"
Nov 30 22:18:07 Isengard mythbackend[9367]: 2017-11-30 22:18:07.513010 W MythBackend: No valid capture cards are defined in the database. Nov 30 22:18:07 Isengard mythbackend[9367]: 2017-11-30 22:18:07.517338 E Scheduler: No capture cards are defined in the database. Nov 30 22:18:07 Isengard mythbackend[9367]: Perhaps you should re-read the installation instructions?
I wonder if there might be a "null" capture card. Or maybe you just any card, at random.
It will try to probe it.
Possibly. I've been wondering about setting up a storage backend only, I might try it out today. -- Per Jessen, Zürich (-1.0°C) http://www.dns24.ch/ - your free DNS host, made in Switzerland. -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse+owner@opensuse.org
Per Jessen wrote:
I wonder if there might be a "null" capture card. Or maybe you just any card, at random.
There is in fact a DEMO card, but getting it to work is not easy - you still need input sources and channel sources. Faking it might be possible, but would require a lot of trial&error. I'm sorry, I didn't realise mythtv would insist on having a capture card. -- Per Jessen, Zürich (-0.6°C) http://www.hostsuisse.com/ - virtual servers, made in Switzerland. -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse+owner@opensuse.org
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.
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 :-)
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>'"
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 -- Per Jessen, Zürich (2.4°C) http://www.hostsuisse.com/ - virtual servers, made in Switzerland. -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse+owner@opensuse.org
-----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@opensuse.org To contact the owner, e-mail: opensuse+owner@opensuse.org
On Thu, 30 Nov 2017 16:39:13 +0100 (CET) "Carlos E. R." <robin.listas@telefonica.net> wrote:
I figured out that I had to open the program "mysql" as root
Note that mysql root is not the same as linux root. mysql users are completely separate from linux users. So put the username on the command line as Per suggests. -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse+owner@opensuse.org
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On Thursday, 2017-11-30 at 16:16 -0000, Dave Howorth wrote: El 2017-11-30 a las 16:16 -0000, Dave Howorth escribió:
Date: Thu, 30 Nov 2017 16:16:07 +0000 From: Dave Howorth <dave@howorth.org.uk> To: opensuse@opensuse.org Subject: Re: [opensuse] How does one setup mythtv?
On Thu, 30 Nov 2017 16:39:13 +0100 (CET) "Carlos E. R." <robin.listas@telefonica.net> wrote:
I figured out that I had to open the program "mysql" as root
Note that mysql root is not the same as linux root. mysql users are completely separate from linux users. So put the username on the command line as Per suggests.
The database is already created. I would have to remove it somehow and start again. This is very complex, mythtv should have a chapter on the mysql configuration. The howto says nothing on it. - -- Cheers, Carlos E. R. (from openSUSE 42.2 x86_64 "Malachite" at Telcontar) -----BEGIN PGP SIGNATURE----- Version: GnuPG v2 iEYEARECAAYFAlogL3IACgkQtTMYHG2NR9XTUgCfR6LGy0k7vi5ZqGyMreNQ1/dj gCgAnRBo+oLTEpnWmxV/VhXml3q4mrS8 =eCZZ -----END PGP SIGNATURE-----
Carlos E. R. wrote:
On Thursday, 2017-11-30 at 16:16 -0000, Dave Howorth wrote:
El 2017-11-30 a las 16:16 -0000, Dave Howorth escribió:
Date: Thu, 30 Nov 2017 16:16:07 +0000 From: Dave Howorth <dave@howorth.org.uk> To: opensuse@opensuse.org Subject: Re: [opensuse] How does one setup mythtv?
On Thu, 30 Nov 2017 16:39:13 +0100 (CET) "Carlos E. R." <robin.listas@telefonica.net> wrote:
I figured out that I had to open the program "mysql" as root
Note that mysql root is not the same as linux root. mysql users are completely separate from linux users. So put the username on the command line as Per suggests.
The database is already created. I would have to remove it somehow and start again.
DROP DATABASE mythconverg.
This is very complex, mythtv should have a chapter on the mysql configuration. The howto says nothing on it.
I agree it belongs on the howto, I am surprised it isn't there. As for "complex" - it's no more complex than e.g. wordpress or owncloud or roundcube, but I guess it might appear complex when you're not used to to dealing with mysql. -- Per Jessen, Zürich (2.6°C) http://www.dns24.ch/ - your free DNS host, made in Switzerland. -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse+owner@opensuse.org
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Content-ID: <alpine.LSU.2.21.1711302023490.9933@Telcontar.valinor> On Thursday, 2017-11-30 at 17:37 +0100, Per Jessen wrote: El 2017-11-30 a las 17:37 +0100, Per Jessen escribió:
Date: Thu, 30 Nov 2017 17:37:25 +0100 From: Per Jessen <per@computer.org> To: opensuse@opensuse.org Subject: Re: [opensuse] How does one setup mythtv?
Carlos E. R. wrote:
On Thursday, 2017-11-30 at 16:16 -0000, Dave Howorth wrote:
El 2017-11-30 a las 16:16 -0000, Dave Howorth escribió:
Date: Thu, 30 Nov 2017 16:16:07 +0000 From: Dave Howorth <dave@howorth.org.uk> To: opensuse@opensuse.org Subject: Re: [opensuse] How does one setup mythtv?
On Thu, 30 Nov 2017 16:39:13 +0100 (CET) "Carlos E. R." <robin.listas@telefonica.net> wrote:
I figured out that I had to open the program "mysql" as root
Note that mysql root is not the same as linux root. mysql users are completely separate from linux users. So put the username on the command line as Per suggests.
The database is already created. I would have to remove it somehow and start again.
DROP DATABASE mythconverg.
And then, what do I do exactly? mariadb is not configured at all. To run the above sql commands, which I think are wrong, I need a password, which I do not know. Then I also need: «This guide assumes you have already installed MythTV, MySQL, created the MySQL user id and set up your backend to automatically start.» I need to create that "mysql user id", whichever it is. And I also need the tzinfo thing, it also asks for a password.
This is very complex, mythtv should have a chapter on the mysql configuration. The howto says nothing on it.
I agree it belongs on the howto, I am surprised it isn't there. As for "complex" - it's no more complex than e.g. wordpress or owncloud or roundcube, but I guess it might appear complex when you're not used to to dealing with mysql.
It is indeed. I have to guess and ask what to do, and then it doesn't work. This is very frustrating :-( - -- Cheers, Carlos E. R. (from openSUSE 42.2 x86_64 "Malachite" at Telcontar) -----BEGIN PGP SIGNATURE----- Version: GnuPG v2 iEYEARECAAYFAlogWxAACgkQtTMYHG2NR9UR5QCfXt9ZqR4Nowkr6YlRNe+fe+0q B7gAn0XbcjyUev9MakeFeKQKkDZQZLFn =iYSl -----END PGP SIGNATURE-----
Carlos E. R. wrote:
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1
Content-ID: <alpine.LSU.2.21.1711302023490.9933@Telcontar.valinor>
On Thursday, 2017-11-30 at 17:37 +0100, Per Jessen wrote:
El 2017-11-30 a las 17:37 +0100, Per Jessen escribió:
Date: Thu, 30 Nov 2017 17:37:25 +0100 From: Per Jessen <per@computer.org> To: opensuse@opensuse.org Subject: Re: [opensuse] How does one setup mythtv?
Carlos E. R. wrote:
On Thursday, 2017-11-30 at 16:16 -0000, Dave Howorth wrote:
El 2017-11-30 a las 16:16 -0000, Dave Howorth escribió:
Date: Thu, 30 Nov 2017 16:16:07 +0000 From: Dave Howorth <dave@howorth.org.uk> To: opensuse@opensuse.org Subject: Re: [opensuse] How does one setup mythtv?
On Thu, 30 Nov 2017 16:39:13 +0100 (CET) "Carlos E. R." <robin.listas@telefonica.net> wrote:
I figured out that I had to open the program "mysql" as root
Note that mysql root is not the same as linux root. mysql users are completely separate from linux users. So put the username on the command line as Per suggests.
The database is already created. I would have to remove it somehow and start again.
DROP DATABASE mythconverg.
And then, what do I do exactly?
Then you rerun the script you mentioned earlier - mc.sql I think it was.
mariadb is not configured at all. To run the above sql commands, which I think are wrong, I need a password, which I do not know.
When you install mysql or mariadb, the first thing to do is to set the mysql root password. mysql usually reminds you about that. When you run "mysql -u root -p" that is the password you need. You can always set it again using the mysqladmin utility.
Then I also need: «This guide assumes you have already installed MythTV, MySQL, created the MySQL user id and set up your backend to automatically start.»
I need to create that "mysql user id", whichever it is. And I also need the tzinfo thing, it also asks for a password.
The default mythtv database user is "mythtv", the password too. It is created by the script mentioned above. To run the tzinfo thing to load the timezone tables, you need the mysql root user password. -- Per Jessen, Zürich (1.0°C) http://www.hostsuisse.com/ - virtual servers, made in Switzerland. -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse+owner@opensuse.org
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On Thursday, 2017-11-30 at 20:37 +0100, Per Jessen wrote:
Carlos E. R. wrote:
On Thursday, 2017-11-30 at 17:37 +0100, Per Jessen wrote:
El 2017-11-30 a las 17:37 +0100, Per Jessen escribió:
Date: Thu, 30 Nov 2017 17:37:25 +0100 From: Per Jessen <per@computer.org> To: opensuse@opensuse.org Subject: Re: [opensuse] How does one setup mythtv?
Carlos E. R. wrote:
On Thursday, 2017-11-30 at 16:16 -0000, Dave Howorth wrote:
El 2017-11-30 a las 16:16 -0000, Dave Howorth escribió:
Date: Thu, 30 Nov 2017 16:16:07 +0000 From: Dave Howorth <dave@howorth.org.uk> To: opensuse@opensuse.org Subject: Re: [opensuse] How does one setup mythtv?
On Thu, 30 Nov 2017 16:39:13 +0100 (CET) "Carlos E. R." <robin.listas@telefonica.net> wrote:
I figured out that I had to open the program "mysql" as root
Note that mysql root is not the same as linux root. mysql users are completely separate from linux users. So put the username on the command line as Per suggests.
The database is already created. I would have to remove it somehow and start again.
DROP DATABASE mythconverg.
And then, what do I do exactly?
Then you rerun the script you mentioned earlier - mc.sql I think it was.
mariadb is not configured at all. To run the above sql commands, which I think are wrong, I need a password, which I do not know.
When you install mysql or mariadb, the first thing to do is to set the mysql root password. mysql usually reminds you about that. When you run "mysql -u root -p" that is the password you need. You can always set it again using the mysqladmin utility.
Then I also need: «This guide assumes you have already installed MythTV, MySQL, created the MySQL user id and set up your backend to automatically start.»
I need to create that "mysql user id", whichever it is. And I also need the tzinfo thing, it also asks for a password.
The default mythtv database user is "mythtv", the password too. It is created by the script mentioned above. To run the tzinfo thing to load the timezone tables, you need the mysql root user password.
Ok, done all that, see the other post. - -- Cheers, Carlos E. R. (from openSUSE 42.2 x86_64 "Malachite" at Telcontar) -----BEGIN PGP SIGNATURE----- Version: GnuPG v2 iEYEARECAAYFAlogeLIACgkQtTMYHG2NR9XlSwCfU4opsMsuZgPGTzn19/OjBQt8 L7wAnRaVq+4sG26eVplCozJVdOaVs8On =ceUN -----END PGP SIGNATURE-----
Carlos E. R. wrote:
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.
"plain" = "just". Nothing special, just sql.
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.
The timezone thing - it's not really a feature, AFAIK mysql needs that information for certain timezone-related functions to work. -- Per Jessen, Zürich (2.2°C) http://www.hostsuisse.com/ - dedicated server rental in Switzerland. -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse+owner@opensuse.org
participants (4)
-
Carlos E. R. -
Dave Howorth -
Patrick Shanahan -
Per Jessen