<div dir="ltr"><div class="gmail_extra"><div class="gmail_quote">On Sat, Feb 21, 2015 at 12:28 PM, Bill Meek <span dir="ltr"><<a href="mailto:keemllib@gmail.com" target="_blank">keemllib@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"><span class="">On 02/21/2015 11:10 AM, Karl Newman 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">
On Sat, Feb 21, 2015 at 1:49 AM, Mike Perkins <<a href="mailto:mikep@randomtraveller.org.uk" target="_blank">mikep@randomtraveller.org.uk</a>><br>
wrote:<br>
<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">
On 21/02/15 04:56, david brooke wrote:<br>
</blockquote></blockquote></span>
...<span class=""><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"><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"><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">
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 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. If you change<br>
either of these items, restart MySQL.<br>
</blockquote></blockquote></blockquote></span>
...<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.<span class=""><font color="#888888"><br>
<br>
-- <br>
Bill</font></span><div class=""><div class="h5"><br>
______________________________<u></u>_________________<br>
mythtv-users mailing list<br>
<a href="mailto:mythtv-users@mythtv.org" target="_blank">mythtv-users@mythtv.org</a><br>
<a href="http://lists.mythtv.org/mailman/listinfo/mythtv-users" target="_blank">http://lists.mythtv.org/<u></u>mailman/listinfo/mythtv-users</a><br>
<a href="http://wiki.mythtv.org/Mailing_List_etiquette" target="_blank">http://wiki.mythtv.org/<u></u>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">I have made the adjustments suggested by others.</div><div class="gmail_extra"><br></div><div class="gmail_extra"><div class="gmail_extra"><br></div><div class="gmail_extra">1. Install the MythTV</div><div class="gmail_extra"><br></div><div class="gmail_extra"># emerge -av mythtv</div><div class="gmail_extra"><br></div><div class="gmail_extra">2. Enable and start MySQL</div><div class="gmail_extra"><br></div><div class="gmail_extra"># rc-update add mysql default && rc-service mysql start</div><div class="gmail_extra"><br></div><div class="gmail_extra">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.</div><div class="gmail_extra"><br></div><div class="gmail_extra">4. Setup mysql and add a password:</div><div class="gmail_extra"><br></div><div class="gmail_extra"># mysql_secure_installation</div><div class="gmail_extra"><br></div><div class="gmail_extra">5. Create the database structure: (See example using root as user and 1234 as password)</div><div class="gmail_extra"><br></div><div class="gmail_extra"># mysql -u root -p1234 /usr/share/mythtv/database/mc.sql</div><div class="gmail_extra"><br></div><div class="gmail_extra">6. Update your database (Optional with new install): (See example using root as user and 1234 as password)</div><div class="gmail_extra"><br></div><div class="gmail_extra"># mysql_upgrade -u root -p1234</div><div class="gmail_extra"><br></div><div class="gmail_extra">7. Add time zone tables: (See example using root as user and 1234 as password)</div><div class="gmail_extra"><br></div><div class="gmail_extra">$ mysql_tzinfo_to_sql /usr/share/zoneinfo | mysql -u root -p1234 mysql</div><div class="gmail_extra"><br></div><div class="gmail_extra">8. Allow remote frontends access: (See example using mythtv as user, mythtv as password and root as user, 1234 as password)</div><div class="gmail_extra"><br></div><div class="gmail_extra"># mysql -u root -p1234</div><div class="gmail_extra">MariaDB [(none)]> GRANT ALL ON mythconverg.* TO 'mythtv'@'192.168.97.%' IDENTIFIED BY 'mythtv';</div><div class="gmail_extra">***Query OK, 0 rows affected (0.00 sec)***output only!</div><div class="gmail_extra">MariaDB [(none)]> FLUSH PRIVILEGES;</div><div class="gmail_extra">***Query OK, 0 rows affected (0.00 sec)***output only!</div><div class="gmail_extra">MariaDB [(none)]> exit</div><div class="gmail_extra">***Bye***output only!</div><div class="gmail_extra"><br></div><div class="gmail_extra">9. Enable mythbackend</div><div class="gmail_extra"><br></div><div class="gmail_extra"># rc-update add mythbackend default</div><div class="gmail_extra"><br></div><div class="gmail_extra">10. Setup mythbackend</div><div class="gmail_extra"><br></div><div class="gmail_extra">$ mythtv-setup</div><div class="gmail_extra"><br></div><div class="gmail_extra">11. Setup logging for mythfrontend and mythbackend.</div><div class="gmail_extra"><br></div><div class="gmail_extra">Edit /etc/conf.d/mythfrontend</div><div class="gmail_extra">Replace</div><div class="gmail_extra">#MYTHFRONTEND_OPTS="--syslog local7"</div><div class="gmail_extra">With</div><div class="gmail_extra">MYTHFRONTEND_OPTS="--quiet --logpath /var/log/mythtv"</div><div class="gmail_extra"><br></div><div class="gmail_extra">Edit /etc/conf.d/mythbackend</div><div class="gmail_extra">Replace</div><div class="gmail_extra">#MYTHBACKEND_OPTS=""</div><div class="gmail_extra">With</div><div class="gmail_extra">MYTHBACKEND_OPTS="--quiet --logpath /var/log/mythtv"</div></div></div>