[mythtv-users] Gentoo mythbackend setup and logging

[Karl Newman]

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