LinHES Forums
http://forum.linhes.org/

MySQL issues about to give up
http://forum.linhes.org/viewtopic.php?f=1&t=4086		 Page 1 of 1
Author:  witmore [ Wed Apr 06, 2005 12:02 am ]
Post subject:  MySQL issues about to give up
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
Author:  Xsecrets [ Wed Apr 06, 2005 12:15 am ]
Post subject: 
did you read the knoppmyth install instructions where it tells you to comment out the skip networking line in the mysql config file?
Author:  witmore [ Wed Apr 06, 2005 7:59 am ]
Post subject: 
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
Author:  tjc [ Wed Apr 06, 2005 12:02 pm ]
Post subject: 
Almost always a good idea... ;-)
Author:  theDiver [ Tue Apr 26, 2005 12:41 pm ]
Post subject:  Re: MySQL issues about to give up
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
Author:  nigelpearson [ Wed Apr 27, 2005 11:48 pm ]
Post subject: 
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
Page 1 of 1 All times are UTC - 6 hours
Powered by phpBB® Forum Software © phpBB Group
http://www.phpbb.com/