[mythtv-users] Gentoo mythbackend setup and logging
david brooke
david2012brooke at gmail.com
Sat Feb 28 23:37:53 UTC 2015
On Mon, Feb 23, 2015 at 6:44 AM, Hika van den Hoven <hikavdh at gmail.com>
wrote:
> Hoi Karl,
>
> Monday, February 23, 2015, 6:33:10 AM, you wrote:
>
> > 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.
>
> OK, last summer when I did my last fresh install for mythtv it was
> mysql. But things change.
>
>
> Tot mails,
> Hika mailto:hikavdh at gmail.com
>
> "Zonder hoop kun je niet leven
> Zonder leven is er geen hoop
> Het eeuwige dilemma
> Zeker als je hoop moet vernietigen om te kunnen overleven!"
>
> De lerende Mens
>
> _______________________________________________
> 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
>
Update
I did an install and had an unexpected result. Step #2 happened as follows:
CI7 dbrooke # rc-update add mysql default && rc-service mysql start
* service mysql added to runlevel default
* Caching service dependencies ...
[ ok ]
* Checking mysqld configuration for mysql ...
[ ok ]
* Starting mysql ...
!!! SYNC setting found in make.conf.
This setting is Deprecated and no longer used. Please ensure your
'sync-type' and 'sync-uri' are set correctly in
/etc/portage/repos.conf/gentoo.conf
!!! SYNC setting found in make.conf.
This setting is Deprecated and no longer used. Please ensure your
'sync-type' and 'sync-uri' are set correctly in
/etc/portage/repos.conf/gentoo.conf
!!! SYNC setting found in make.conf.
This setting is Deprecated and no longer used. Please ensure your
'sync-type' and 'sync-uri' are set correctly in
/etc/portage/repos.conf/gentoo.conf
* You don't appear to have the mysql database installed yet.
* Please run `emerge --config =dev-db/mariadb-10.0.16` to have this done...
* ERROR: mysql failed to start
The "*!!! SYNC setting found in make.conf.*
* This setting is Deprecated and no longer used. Please ensure your
'sync-type' and 'sync-uri' are set correctly in
/etc/portage/repos.conf/gentoo.conf*"
can be overlooked as the new sync method wasn't in place yet.
But this is the important message:
** You don't appear to have the mysql database installed yet.*
* * Please run `emerge --config =dev-db/mariadb-10.0.16` to have this
done...*
So I did as requested:
CI7 dbrooke # emerge --config =dev-db/mariadb-10.0.16
Configuring pkg...
* Please provide a password for the mysql 'root' user now
* or through the /root/.my.cnf file.
* Avoid ["'\_%] characters in the password
>
* Retype the password
>
* Creating the mysql database and setting proper
* permissions on it ...
* Command: '/usr/share/mysql/scripts/mysql_install_db' '--basedir=/usr'
--loose-skip-grant-tables --loose-skip-host-cache
--loose-skip-name-resolve --loose-skip-networking --loose-skip-slave-start
--loose-skip-ssl --loose-skip-log-bin --loose-skip-relay-log
--loose-skip-slow-query-log --loose-skip-external-locking
--loose-skip-log-slave-updates --user=mysql '--datadir=///var/lib/mysql'
'--tmpdir=///tmp/'
* Starting mysqld ...
* Command //usr/sbin/mysqld --loose-skip-grant-tables
--loose-skip-host-cache --loose-skip-name-resolve --loose-skip-networking
--loose-skip-slave-start --loose-skip-ssl --loose-skip-log-bin
--loose-skip-relay-log --loose-skip-slow-query-log
--loose-skip-external-locking --loose-skip-log-slave-updates --user=mysql
--user=mysql --log-warnings=0
--basedir=//usr --datadir=///var/lib/mysql
--max_allowed_packet=8M --net_buffer_length=16K
--default-storage-engine=MyISAM
--socket=//var/run/mysqld/mysqld31550.sock
--pid-file=//var/run/mysqld/mysqld24737.pid
* --tmpdir=///tmp/
[ ok ]
* Setting root password ...
[ ok ]
* Loading "zoneinfo", this step may require a few seconds ... ...
[ ok ]
* Stopping the server ...
* Done
So I hope this was correct?
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.mythtv.org/pipermail/mythtv-users/attachments/20150228/ae92bd2c/attachment.html>
More information about the mythtv-users
mailing list