[mythtv-users] Gentoo mythbackend setup and logging

[david brooke]

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"
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.mythtv.org/pipermail/mythtv-users/attachments/20150221/72e36abd/attachment.html>