[mythtv-users] Gentoo mythbackend setup and logging

[Karl Newman]

On Sun, Feb 22, 2015 at 12:33 AM, Hika van den Hoven <hikavdh at gmail.com>
wrote:

> Hoi Karl,
>
> Sunday, February 22, 2015, 6:40:18 AM, you wrote:
>
> > On Sat, Feb 21, 2015 at 2:57 PM, david brooke <david2012brooke at gmail.com
> >
> > wrote:
>
> >> On Sat, Feb 21, 2015 at 12:28 PM, Bill Meek <keemllib at gmail.com> wrote:
> >>
> >>> On 02/21/2015 11:10 AM, Karl Newman wrote:
> >>>
> >>>> On Sat, Feb 21, 2015 at 1:49 AM, Mike Perkins <
> >>>> mikep at randomtraveller.org.uk>
> >>>> wrote:
> >>>>
> >>>>  On 21/02/15 04:56, david brooke wrote:
> >>>>>
> >>>> ...
> >>>
> >>>> 4. You'll also need to check that the "networking" feature of MySQL is
> >>>>>> turned on. Check that /etc/mysql/my.cnf does not contain
> >>>>>> skip-networking.
> >>>>>> If it does, either remove that line or comment it out. Also verify
> that
> >>>>>> bind-address is set to your IP address instead of 127.0.0.1. If you
> >>>>>> change
> >>>>>> either of these items, restart MySQL.
> >>>>>>
> >>>>> ...
> >>>
> >>> I would check the /etc/mysql/my.cnf file and see if it has a line
> >>> like this:
> >>>
> >>>     !includedir /etc/mysql/conf.d
> >>>
> >>> probably at the end of the file. If so, then make any changes to
> >>> the configuration in a file under conf.d. Call the file there
> >>> anything you like but it must end in .cnf. As an example:
> >>>
> >>>     [mysqld]
> >>>     bind-address=::
> >>>     max_connections = 100
> >>>
> >>> In the *buntu world, the package maintainer may change the my.cnf
> >>> file and even though users are given a prompt, sometimes it's
> >>> missed/ignored and local changes vanish. Maybe not true for Gentoo.
> >>>
> >>> --
> >>> Bill
> >>>
> >>> _______________________________________________
> >>> mythtv-users mailing list
> >>> mythtv-users at mythtv.org
> >>> http://lists.mythtv.org/mailman/listinfo/mythtv-users
> >>> http://wiki.mythtv.org/Mailing_List_etiquette
> >>> MythTV Forums: https://forum.mythtv.org
> >>>
> >>
> >> I have made the adjustments suggested by others.
> >>
> >>
> >> 1. Install the MythTV
> >>
> >> # emerge -av mythtv
> >>
> >> 2. Enable and start MySQL
> >>
> >> # rc-update add mysql default && rc-service mysql start
> >>
> >> 3. You'll also need to check that the "networking" feature of MySQL is
> >> turned on. Check that /etc/mysql/my.cnf does not contain
> skip-networking.
> >> If it does, either remove that line or comment it out. Also verify that
> >> bind-address is set to your IP address instead of 127.0.0.1.
> Alternatively
> >> /etc/conf.d/mysql can be used to address skip-networking and
> bind-address.
> >> Set MY_ARGS="--bind-address=masterbackendipaddress" and skip-networking
> >> default is off. If you change either of these items, restart MySQL.
> >>
> >> 4. Setup mysql and add a password:
> >>
> >> # mysql_secure_installation
> >>
> >> 5. Create the database structure: (See example using root as user and
> 1234
> >> as password)
> >>
> >> # mysql -u root -p1234 /usr/share/mythtv/database/mc.sql
> >>
> >> 6. Update your database (Optional with new install): (See example using
> >> root as user and 1234 as password)
> >>
> >> # mysql_upgrade -u root -p1234
> >>
> >> 7. Add time zone tables: (See example using root as user and 1234 as
> >> password)
> >>
> >> $ mysql_tzinfo_to_sql /usr/share/zoneinfo | mysql -u root -p1234 mysql
> >>
> >> 8. Allow remote frontends access: (See example using mythtv as user,
> >> mythtv as password and root as user, 1234 as password)
> >>
> >> # mysql -u root -p1234
> >> MariaDB [(none)]> GRANT ALL ON mythconverg.* TO 'mythtv'@'192.168.97.%'
> >> IDENTIFIED BY 'mythtv';
> >> ***Query OK, 0 rows affected (0.00 sec)***output only!
> >> MariaDB [(none)]> FLUSH PRIVILEGES;
> >> ***Query OK, 0 rows affected (0.00 sec)***output only!
> >> MariaDB [(none)]> exit
> >> ***Bye***output only!
> >>
> >> 9. Enable mythbackend
> >>
> >> # rc-update add mythbackend default
> >>
> >> 10. Setup mythbackend
> >>
> >> $ mythtv-setup
> >>
> >> 11. Setup logging for mythfrontend and mythbackend.
> >>
> >> Edit /etc/conf.d/mythfrontend
> >> Replace
> >> #MYTHFRONTEND_OPTS="--syslog local7"
> >> With
> >> MYTHFRONTEND_OPTS="--quiet --logpath /var/log/mythtv"
> >>
> >> Edit /etc/conf.d/mythbackend
> >> Replace
> >> #MYTHBACKEND_OPTS=""
> >> With
> >> MYTHBACKEND_OPTS="--quiet --logpath /var/log/mythtv"
> >>
> >> Looks reasonable. Don't forget to start mythbackend once everything is
> set
> > up. And there may (will) be detours along the way dealing with
> > configuration of various dependencies, etc. Gentoo takes a bit of work,
> > probably more than other distros, but on the plus side you usually know
> > exactly what's running/installed on your system.
>
> > Karl
>
> a few remarks:
> mariadb versus mysql. I don't know which is preferred, but the
> dependency will go with whichever already is installed and if neither
> is installed will install mysql.


Actually mariadb is first in the list of dependencies which satisfy
virtual/mysql, so unless otherwise specified mariadb will be installed.

Karl
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.mythtv.org/pipermail/mythtv-users/attachments/20150222/b1c74c28/attachment.html>