Author |
Message |
witmore
|
Posted: Wed Apr 06, 2005 12:02 am |
|
Joined: Mon Mar 07, 2005 12:59 am
Posts: 5
|
Okay I have had a successful Fedora Core 2 setup where I could use Knoppmyth live cd as a Front end. I was going to attempt to rebuild with FC3 and ran out of time, so I decided to try knoppmyth, I am currently using R5A12
I am using 2 PVR 250 Freestyle Cards (Gateway OEM)
AMD 2200+
256mb ram
Soltek 75DRV4 (VIA 82xx chipset
onboard audio
3com 1GB Network (tg3 driver)
3 120GB hard drives /Video LVM XFS
Geforce 4 mx 440 (not using tv out)
Currently the machine is working as a FE/BE combination. although I have bugs with the front end, my buffer both on the LVM and on the System partition (ext3) and after so long the front end will go black, and the backend will crash.
If I dont attach a frontend the backend will record programs and playback. Although in playback or playing a show that is being recorded currently there will be audio breaks, where the audio clicks out every so often. even when nothing else is recording
I wanted to try a remote frontend for playback and see if it was this VIA chipset DMA issue I have seen before, as on a remote front end I would assume system resources on the backend wouldnt be used as much.
I pop in my R5A10 or my R5A12 cd and attempt to just run a front end, and cannot says cannot connect to mysql server. I have tried the command line on both the knoppmyth frontend, and a debian woody box and gets an error
witmore@Cat-Bert:~$ mysql -h 172.16.1.101 -u mythtv -p mythconverg
Enter password:
ERROR 2003: Can't connect to MySQL server on '172.16.1.101' (111)
I have followed the instructions on the mythtv.org doc on how to give access, I have tried no security access, giving unlimited access, restricting access to my subnet etc. no change, even backed up the database, wiped all my mysql users and settings and databases and then re-ran the mythtv database configure, then set to allow mythtv@%
I am not a linux expert, but I have installed Myth a few times on Fedora with and without Jarods guide, and cant understand what I am missing.
The only thing that I can think of is when I did an
#apt-get update && apt-get dist-upgrade
after running the installer that a firewall was installed that is conflicting with outside hosts connecting to the mysql database
because I did find that after a recent upgrade I found no network connectivity and found that a new package Laptop-net was to blame, once removed my network connectivity returned
|
|
Top |
|
 |
Xsecrets
|
Posted: Wed Apr 06, 2005 12:15 am |
|
Joined: Mon Oct 06, 2003 10:38 am
Posts: 4978
Location:
Nashville, TN
|
did you read the knoppmyth install instructions where it tells you to comment out the skip networking line in the mysql config file?
_________________ Have a question search the forum and have a look at the KnoppMythWiki.
Xsecrets
|
|
Top |
|
 |
witmore
|
Posted: Wed Apr 06, 2005 7:59 am |
|
Joined: Mon Mar 07, 2005 12:59 am
Posts: 5
|
I used vi and actually sent a search and replace skip-networking with #skip-networking but it seems the file has changed and no longer uses skip-networking
#
# Instead of #skip-networking the default is now to listen only on
# localhost which is more compatible and is not less secure.
bind-address = 127.0.0.1
so I changed it, guess I shoulda read the config instead of blindly making the change
|
|
Top |
|
 |
tjc
|
Posted: Wed Apr 06, 2005 12:02 pm |
|
Joined: Thu Mar 25, 2004 11:00 am
Posts: 9551
Location:
Arlington, MA
|
Almost always a good idea... 
|
|
Top |
|
 |
theDiver
|
Posted: Tue Apr 26, 2005 12:41 pm |
|
Joined: Tue Apr 26, 2005 12:39 pm
Posts: 9
|
witmore wrote: The only thing that I can think of is when I did an #apt-get update && apt-get dist-upgrade after running the installer that a firewall was installed that is conflicting with outside hosts connecting to the mysql database
because I did find that after a recent upgrade I found no network connectivity and found that a new package Laptop-net was to blame, once removed my network connectivity returned
Hi witmore.
Thanks a lot for the help about the 'laptop-net' package.
Now my system has network access as well
But i would really really like to know, how did you figure out it was that package that did make the problem ?
Best regards
theDiver
|
|
Top |
|
 |
nigelpearson
|
Posted: Wed Apr 27, 2005 11:48 pm |
|
Joined: Wed Mar 03, 2004 7:43 pm
Posts: 748
Location:
Sydney, Australia
|
witmore wrote: I used vi and actually sent a search and replace skip-networking with #skip-networking but it seems the file has changed and no longer uses skip-networking
Hmmm. Are you sure?
% sudo vi /etc/mysql/my.cnf
...
#
# The skip-networking option will no longer be set via debconf menu.
# You have to manually change it if you want networking i.e. the server
# listening on port 3306. The default is "disable" - for security reasons.
skip-networking
_________________ | Nigel Pearson, nigel.pearson.au@gmail.com| "Things you own end up owning you" - Tyler, Fight Club
|
|
Top |
|
 |