LinHES Forums http://forum.linhes.org/ |
|
MySQL Access, Frontend? http://forum.linhes.org/viewtopic.php?f=6&t=10640 |
Page 1 of 1 |
Author: | opel70 [ Tue Jun 27, 2006 7:03 am ] |
Post subject: | MySQL Access, Frontend? |
Hello, Well, I had this posted in Installation, but it got deleted. I thought it was a problem with my Installation of KnoppMyth, but I guess not. So here goes again. I installed KnoppMyth on a PC at home and it seemed to install fine. Except that when I try to run a frontend on a different PC it cannot connect to the MySQL database. I tried running SQLyog from my PC, but I get a "Can't connect to MySQL server on ...." error. I figured I'd do a port scan to see if MySQL was listening on a non-standard port, and nothing showed up. I mean there were a lot of open ports, but none of them were for MySQL. Is there something I was supposed to do during the installation (guess not since it was deleted from the Installation forum), or some configuration option, to make it available to connect a different Frontend to this system? Tim |
Author: | datobin1 [ Tue Jun 27, 2006 7:19 am ] |
Post subject: | |
You did a port scan before a search scan of the forum? LOL This is well documented but, here it is copied from the instructions found here: http://www.mysettopbox.tv/doc.html#autoinstall Frontend This allows you to use the CD as a frontend if you have a MythTV backend setup. You can select this option by pressing <ENTER>. After providing the requested information, the CD will boot X and start mythfronted. Note: Using the CD as a frontend is dependant upon the backend being configured with MySQL listening on the network. If you are running KnoppMyth as your backend server, Then on the backend: Edit /etc/mysql/my.cnf, comment out 'skip-networking'. The backend will only accept the mythtv user with a password of mythtv. Before: skip-networking After # skip-networking Restart MySQL(as root) # /etc/init.d/mysql restart Reconfigure MythTV (as the mythtv user) $ mythtv-setup On screen 1 change 127.0.0.1(both instances) to the actual IP of the backend server. <ESC> out of the myth-setup. End of backend section. |
Author: | Atamido [ Thu Jun 29, 2006 10:09 am ] |
Post subject: | |
It's good to see competent troubleshooting like that. Of course, searching the forums afterwards probably would have been a good idea. |
Page 1 of 1 | All times are UTC - 6 hours |
Powered by phpBB® Forum Software © phpBB Group http://www.phpbb.com/ |