View unanswered posts    View active topics

All times are UTC - 6 hours





Post new topic Reply to topic  [ 3 posts ] 
Print view Previous topic   Next topic  
Author Message
Search for:
 Post subject: MySQL Access, Frontend?
PostPosted: Tue Jun 27, 2006 7:03 am 
Offline
Joined: Tue Apr 11, 2006 7:44 am
Posts: 287
Location: Los Angeles, CA
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


Top
 Profile  
 
 Post subject:
PostPosted: Tue Jun 27, 2006 7:19 am 
Offline
Joined: Wed Dec 21, 2005 1:14 pm
Posts: 145
Location: Charlotte NC USA
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.


Top
 Profile  
 
 Post subject:
PostPosted: Thu Jun 29, 2006 10:09 am 
Offline
Joined: Wed Jun 15, 2005 9:14 pm
Posts: 72
It's good to see competent troubleshooting like that. Of course, searching the forums afterwards probably would have been a good idea.


Top
 Profile  
 

Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 3 posts ] 


All times are UTC - 6 hours




Who is online

Users browsing this forum: No registered users and 34 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Jump to:  
cron
Powered by phpBB® Forum Software © phpBB Group

Theme Created By ceyhansuyu