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/