<div dir="ltr"><div class="gmail_extra"><div class="gmail_quote">On Mon, Feb 23, 2015 at 6:44 AM, Hika van den Hoven <span dir="ltr"><<a href="mailto:hikavdh@gmail.com" target="_blank">hikavdh@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex">Hoi Karl,<br>
<div><div class="h5"><br>
Monday, February 23, 2015, 6:33:10 AM, you wrote:<br>
<br>
> On Sun, Feb 22, 2015 at 12:33 AM, Hika van den Hoven <<a href="mailto:hikavdh@gmail.com">hikavdh@gmail.com</a>><br>
> wrote:<br>
<br>
>> Hoi Karl,<br>
>><br>
>> Sunday, February 22, 2015, 6:40:18 AM, you wrote:<br>
>><br>
>> > On Sat, Feb 21, 2015 at 2:57 PM, david brooke <<a href="mailto:david2012brooke@gmail.com">david2012brooke@gmail.com</a><br>
>> ><br>
>> > wrote:<br>
>><br>
>> >> On Sat, Feb 21, 2015 at 12:28 PM, Bill Meek <<a href="mailto:keemllib@gmail.com">keemllib@gmail.com</a>> wrote:<br>
>> >><br>
>> >>> On 02/21/2015 11:10 AM, Karl Newman wrote:<br>
>> >>><br>
>> >>>> On Sat, Feb 21, 2015 at 1:49 AM, Mike Perkins <<br>
>> >>>> <a href="mailto:mikep@randomtraveller.org.uk">mikep@randomtraveller.org.uk</a>><br>
>> >>>> wrote:<br>
>> >>>><br>
>> >>>> On 21/02/15 04:56, david brooke wrote:<br>
>> >>>>><br>
>> >>>> ...<br>
>> >>><br>
>> >>>> 4. You'll also need to check that the "networking" feature of MySQL is<br>
>> >>>>>> turned on. Check that /etc/mysql/my.cnf does not contain<br>
>> >>>>>> skip-networking.<br>
>> >>>>>> If it does, either remove that line or comment it out. Also verify<br>
>> that<br>
>> >>>>>> bind-address is set to your IP address instead of 127.0.0.1. If you<br>
>> >>>>>> change<br>
>> >>>>>> either of these items, restart MySQL.<br>
>> >>>>>><br>
>> >>>>> ...<br>
>> >>><br>
>> >>> I would check the /etc/mysql/my.cnf file and see if it has a line<br>
>> >>> like this:<br>
>> >>><br>
>> >>> !includedir /etc/mysql/conf.d<br>
>> >>><br>
>> >>> probably at the end of the file. If so, then make any changes to<br>
>> >>> the configuration in a file under conf.d. Call the file there<br>
>> >>> anything you like but it must end in .cnf. As an example:<br>
>> >>><br>
>> >>> [mysqld]<br>
>> >>> bind-address=::<br>
>> >>> max_connections = 100<br>
>> >>><br>
>> >>> In the *buntu world, the package maintainer may change the my.cnf<br>
>> >>> file and even though users are given a prompt, sometimes it's<br>
>> >>> missed/ignored and local changes vanish. Maybe not true for Gentoo.<br>
>> >>><br>
>> >>> --<br>
>> >>> Bill<br>
>> >>><br>
>> >>> _______________________________________________<br>
>> >>> mythtv-users mailing list<br>
>> >>> <a href="mailto:mythtv-users@mythtv.org">mythtv-users@mythtv.org</a><br>
>> >>> <a href="http://lists.mythtv.org/mailman/listinfo/mythtv-users" target="_blank">http://lists.mythtv.org/mailman/listinfo/mythtv-users</a><br>
>> >>> <a href="http://wiki.mythtv.org/Mailing_List_etiquette" target="_blank">http://wiki.mythtv.org/Mailing_List_etiquette</a><br>
>> >>> MythTV Forums: <a href="https://forum.mythtv.org" target="_blank">https://forum.mythtv.org</a><br>
>> >>><br>
>> >><br>
>> >> I have made the adjustments suggested by others.<br>
>> >><br>
>> >><br>
>> >> 1. Install the MythTV<br>
>> >><br>
>> >> # emerge -av mythtv<br>
>> >><br>
>> >> 2. Enable and start MySQL<br>
>> >><br>
>> >> # rc-update add mysql default && rc-service mysql start<br>
>> >><br>
>> >> 3. You'll also need to check that the "networking" feature of MySQL is<br>
>> >> turned on. Check that /etc/mysql/my.cnf does not contain<br>
>> skip-networking.<br>
>> >> If it does, either remove that line or comment it out. Also verify that<br>
>> >> bind-address is set to your IP address instead of 127.0.0.1.<br>
>> Alternatively<br>
>> >> /etc/conf.d/mysql can be used to address skip-networking and<br>
>> bind-address.<br>
>> >> Set MY_ARGS="--bind-address=masterbackendipaddress" and skip-networking<br>
>> >> default is off. If you change either of these items, restart MySQL.<br>
>> >><br>
>> >> 4. Setup mysql and add a password:<br>
>> >><br>
>> >> # mysql_secure_installation<br>
>> >><br>
>> >> 5. Create the database structure: (See example using root as user and<br>
>> 1234<br>
>> >> as password)<br>
>> >><br>
>> >> # mysql -u root -p1234 /usr/share/mythtv/database/mc.sql<br>
>> >><br>
>> >> 6. Update your database (Optional with new install): (See example using<br>
>> >> root as user and 1234 as password)<br>
>> >><br>
>> >> # mysql_upgrade -u root -p1234<br>
>> >><br>
>> >> 7. Add time zone tables: (See example using root as user and 1234 as<br>
>> >> password)<br>
>> >><br>
>> >> $ mysql_tzinfo_to_sql /usr/share/zoneinfo | mysql -u root -p1234 mysql<br>
>> >><br>
>> >> 8. Allow remote frontends access: (See example using mythtv as user,<br>
>> >> mythtv as password and root as user, 1234 as password)<br>
>> >><br>
>> >> # mysql -u root -p1234<br>
>> >> MariaDB [(none)]> GRANT ALL ON mythconverg.* TO 'mythtv'@'192.168.97.%'<br>
>> >> IDENTIFIED BY 'mythtv';<br>
>> >> ***Query OK, 0 rows affected (0.00 sec)***output only!<br>
>> >> MariaDB [(none)]> FLUSH PRIVILEGES;<br>
>> >> ***Query OK, 0 rows affected (0.00 sec)***output only!<br>
>> >> MariaDB [(none)]> exit<br>
>> >> ***Bye***output only!<br>
>> >><br>
>> >> 9. Enable mythbackend<br>
>> >><br>
>> >> # rc-update add mythbackend default<br>
>> >><br>
>> >> 10. Setup mythbackend<br>
>> >><br>
>> >> $ mythtv-setup<br>
>> >><br>
>> >> 11. Setup logging for mythfrontend and mythbackend.<br>
>> >><br>
>> >> Edit /etc/conf.d/mythfrontend<br>
>> >> Replace<br>
>> >> #MYTHFRONTEND_OPTS="--syslog local7"<br>
>> >> With<br>
>> >> MYTHFRONTEND_OPTS="--quiet --logpath /var/log/mythtv"<br>
>> >><br>
>> >> Edit /etc/conf.d/mythbackend<br>
>> >> Replace<br>
>> >> #MYTHBACKEND_OPTS=""<br>
>> >> With<br>
>> >> MYTHBACKEND_OPTS="--quiet --logpath /var/log/mythtv"<br>
>> >><br>
>> >> Looks reasonable. Don't forget to start mythbackend once everything is<br>
>> set<br>
>> > up. And there may (will) be detours along the way dealing with<br>
>> > configuration of various dependencies, etc. Gentoo takes a bit of work,<br>
>> > probably more than other distros, but on the plus side you usually know<br>
>> > exactly what's running/installed on your system.<br>
>><br>
>> > Karl<br>
>><br>
>> a few remarks:<br>
>> mariadb versus mysql. I don't know which is preferred, but the<br>
>> dependency will go with whichever already is installed and if neither<br>
>> is installed will install mysql.<br>
<br>
<br>
> Actually mariadb is first in the list of dependencies which satisfy<br>
> virtual/mysql, so unless otherwise specified mariadb will be installed.<br>
<br>
</div></div>OK, last summer when I did my last fresh install for mythtv it was<br>
mysql. But things change.<br>
<span class="im"><br>
<br>
Tot mails,<br>
Hika mailto:<a href="mailto:hikavdh@gmail.com">hikavdh@gmail.com</a><br>
<br>
"Zonder hoop kun je niet leven<br>
Zonder leven is er geen hoop<br>
Het eeuwige dilemma<br>
Zeker als je hoop moet vernietigen om te kunnen overleven!"<br>
<br>
De lerende Mens<br>
<br>
</span><div class=""><div class="h5">_______________________________________________<br>
mythtv-users mailing list<br>
<a href="mailto:mythtv-users@mythtv.org">mythtv-users@mythtv.org</a><br>
<a href="http://lists.mythtv.org/mailman/listinfo/mythtv-users" target="_blank">http://lists.mythtv.org/mailman/listinfo/mythtv-users</a><br>
<a href="http://wiki.mythtv.org/Mailing_List_etiquette" target="_blank">http://wiki.mythtv.org/Mailing_List_etiquette</a><br>
MythTV Forums: <a href="https://forum.mythtv.org" target="_blank">https://forum.mythtv.org</a><br>
</div></div></blockquote></div><br></div><div class="gmail_extra">Update</div><div class="gmail_extra">I did an install and had an unexpected result. Step #2 happened as follows:</div><div class="gmail_extra"><br></div><div class="gmail_extra"><div class="gmail_extra">CI7 dbrooke # rc-update add mysql default && rc-service mysql start</div><div class="gmail_extra"> * service mysql added to runlevel default</div><div class="gmail_extra"> * Caching service dependencies ... [ ok ]</div><div class="gmail_extra"> * Checking mysqld configuration for mysql ... [ ok ]</div><div class="gmail_extra"> * Starting mysql ...</div><div class="gmail_extra">!!! SYNC setting found in make.conf.</div><div class="gmail_extra"> 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</div><div class="gmail_extra">!!! SYNC setting found in make.conf.</div><div class="gmail_extra"> 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</div><div class="gmail_extra">!!! SYNC setting found in make.conf.</div><div class="gmail_extra"> 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</div><div class="gmail_extra"> * You don't appear to have the mysql database installed yet.</div><div class="gmail_extra"> * Please run `emerge --config =dev-db/mariadb-10.0.16` to have this done...</div><div class="gmail_extra"> * ERROR: mysql failed to start</div><div class="gmail_extra"><br></div><div class="gmail_extra">The "<b>!!! SYNC setting found in make.conf.</b></div><div class="gmail_extra"><b> 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</b>"</div><div class="gmail_extra">can be overlooked as the new sync method wasn't in place yet.</div><div class="gmail_extra">But this is the important message:</div><div class="gmail_extra"><div class="gmail_extra"> <b>* You don't appear to have the mysql database installed yet.</b></div><div class="gmail_extra"><b> * Please run `emerge --config =dev-db/mariadb-10.0.16` to have this done...</b></div><div class="gmail_extra">So I did as requested:</div><div class="gmail_extra"><div class="gmail_extra">CI7 dbrooke # emerge --config =dev-db/mariadb-10.0.16</div><div class="gmail_extra">Configuring pkg...<br></div><div class="gmail_extra"><br></div><div class="gmail_extra"> * Please provide a password for the mysql 'root' user now</div><div class="gmail_extra"> * or through the /root/.my.cnf file.</div><div class="gmail_extra"> * Avoid ["'\_%] characters in the password</div><div class="gmail_extra"> ></div><div class="gmail_extra"> * Retype the password</div><div class="gmail_extra"> ></div><div class="gmail_extra"> * Creating the mysql database and setting proper</div><div class="gmail_extra"> * permissions on it ...</div><div class="gmail_extra"> * 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/'</div><div class="gmail_extra"> * Starting mysqld ...</div><div class="gmail_extra"> * 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</div><div class="gmail_extra"> * --tmpdir=///tmp/ [ ok ]</div><div class="gmail_extra"> * Setting root password ... [ ok ]</div><div class="gmail_extra"> * Loading "zoneinfo", this step may require a few seconds ... ... [ ok ]</div><div class="gmail_extra"> * Stopping the server ...</div><div class="gmail_extra"> * Done</div><div class="gmail_extra"><br></div><div class="gmail_extra">So I hope this was correct?</div></div></div></div></div>