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