Greetings --
I hope this is in the correct forum. Please advise if it is not.

I managed to hose my knoppmyth which has been running fine for several months now. The story -- my provider (Charter) has done a major change in the lineup and most of my listing information was incorrect. I tried going into mythtv-setup and grabbing the lineup which froze the machine. I changed to a text terminal and reset the machine. I went back and scanned channels which worked, but didn't give me a new lineup. Back to setup and deleted the video source and reinstalled with same name - no joy, reinstalled with new name - no joy. Tried geting lineup again from Zapit and it froze again. Now when it starts up, it hangs, it is saying it cant connect to mysql on xxx (correct ip address). This is also true of mythtv-setup. Is there a way to recover this installation? Will using the upgrade section of Knoppmyth save me? I did make a mysqldump of my data so hopefully that is safe. Also what is the correct procedure when the channel lineup changes?

Thanks so much in advance

Rich

Doing a backup and an upgrade will cure a lot of evils, but in this case it would just keep the same settings that are giving you problems.

First things first. Fire up your browser, go to the http://labs.zap2it.com/ website, verify that you can log in and that your account has not expired, and setup your new lineup(s).

Now get into mythtv-setup and under 2. Capture cards and 3. Video sources drop all of the exisiting ones. Now go into 1. General and make sure that your IP address is right. If you're using DHCP make sure that this is the loopback address "127.0.0.1", if you're using a static IP you can use either that or the lookpback.

After verfying your network connection is working and you can DNS resolve labs.zap2it.com go back and under #2 recreate the capture card(s), under #3 recreate your video source, under #4 recreate your input connection(s). After saving and exiting run "su - mythtv "/usr/bin/mythfilldatabase".

Finally reboot the box and make sure that mysql and the mythbackend come up. Check the logfiles (see http://www.knoppmythwiki.org/index.php?page=CheckingLogFiles) to make sure that they came up OK.

Thanks for the first part, should have done that earlier I guess.

When I try to get into mythtv-setup it gives me an error --
Can't connect to MYSQL server on 192.168.xx.xx,
( the correct ip of the mythtv box). It keeps giving this error until I stop it

Rich

Have you tried checking that the mysql server is running (check with pgrep -fl mysql), that it is listening on the right port (check with netstat -an | grep 'tcp.*LISTEN'), and that the IP is really what you think it is (check with ifconfig)?

yes - I can log directly into the mysql server and verify that the database and tables exist and have data, I also ran myisamcheck to verify the contents of the file.

Rich

Not quite what I asked. I don't think the mysql command line client bothers with the network port when you're on the same box, since it has a unix (vs. tcp) domain socket for that. Run those diagnostics. Are you using DHCP or static IP?

BTW - No need to mask a private IP addr like that, not unless your firewall router is wide open, and in that case it's closiing the barn after the livestock has wandered off.

Good call -- I can NOT get to mysql via tcp/ip. Need to find out if it is permissions based (localhost vs localnet)

Thanks
Rich