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

Mysql problems ??
http://forum.linhes.org/viewtopic.php?f=17&t=13336		 Page 1 of 1
Author:  mal1ch1 [ Sat Jan 06, 2007 12:20 pm ]
Post subject:  Mysql problems ??
MythTV installed fine [.19] on my Chaintech mb w/PVRs 350 & 500 and everything seems to work fine, even the remote [didn't know that had changed :)]. The PVR-500's even give a good picture now !!
The only problem I'm having is mythfilldatabase is not working; I get the following:
I'm working on it, and have read some info on zap2it's forum, but still am having no luck.
Any help or comments appreciated, hopefully I'm not overlooking something really simple.
Thanks.

2007-01-06 12:14:52.456 Checking day @ offset 13, date: Fri Jan 19 2007
2007-01-06 12:14:52.457 Data refresh needed because no data exists for day @ offset 13 from 6PM - midnight.
2007-01-06 12:14:52.457 Refreshing data for Fri Jan 19 2007
2007-01-06 12:14:52.457 Retrieving datadirect data.
2007-01-06 12:14:52.457 Grabbing data for Sat Jan 6 2007 offset 13
2007-01-06 12:14:52.457 From Fri Jan 19 06:00:00 2007 to Sat Jan 20 06:00:00 2007 (UTC)
2007-01-06 12:14:52.930 Grab complete. Actual data from to (UTC)
2007-01-06 12:14:52.930 Main temp tables populated.
2007-01-06 12:14:52.930 Updating myth channels.
2007-01-06 12:14:52.932 Updating icons for sourceid: 3
2007-01-06 12:14:52.933 Channels updated.
2007-01-06 12:14:52.934 Did not find any new program data.
2007-01-06 12:14:52.937 New DB connection, total: 4
2007-01-06 12:14:52.938 Connected to database 'mythconverg' at host: localhost
2007-01-06 12:14:52.940 New DB connection, total: 5
2007-01-06 12:14:52.940 Connected to database 'mythconverg' at host: localhost
2007-01-06 12:14:52.942 Failed to fetch some program info
2007-01-06 12:14:52.942 Adjusting program database end times.
2007-01-06 12:14:52.942 0 replacements made
2007-01-06 12:14:52.942 Marking generic episodes.
2007-01-06 12:14:52.943 Found 0
2007-01-06 12:14:52.943 Marking repeats.
2007-01-06 12:14:52.944 Found 0
2007-01-06 12:14:52.944 Unmarking new episode rebroadcast repeats.
2007-01-06 12:14:52.944 Found 0
2007-01-06 12:14:53.439 DataDirect: NextSuggestedTime is: 2007-01-07T05:36:55
2007-01-06 12:14:53.441
===============================================================
| Attempting to contact the master backend for rescheduling. |
| If the master is not running, rescheduling will happen when |
| the master backend is restarted. |
===============================================================
2007-01-06 12:14:53.451 Connecting to backend server: 127.0.0.1:6543 (try 1 of 5)
2007-01-06 12:14:53.458 Using protocol version 26
2007-01-06 12:14:53.504 mythfilldatabase run complete.
Author:  tjc [ Sat Jan 06, 2007 12:28 pm ]
Post subject: 
Looks like you're rerunning it after the DB has already been filled... Try using the option for a full refresh. You can find this by running mythfilldatabase with the --help option.
Author:  mal1ch1 [ Sat Jan 06, 2007 12:39 pm ]
Post subject:  Whoops !!!!!!!! or is it Duh ???
Thank tjc, but the problem was a rather simple one.
My subscription had expired !!!
I was logging in and looking at the expiration date and not really thinking (obvious) and not remembering it was 2007 !
I renewed the subscription and the database is filling right now.
Thanks again.
It's all in the details !!!
Author:  mal1ch1 [ Sat Jan 06, 2007 1:17 pm ]
Post subject:  Didn't Work...
Well, I thought it was working, it showed data downloading, but there's still no data in the program guide. 'Guess I'll work on it some more; maybe mysql needs to just be reinitialized (wiped out) and start from square one ?
Author:  tjc [ Sat Jan 06, 2007 1:18 pm ]
Post subject: 
I wouldn't go there yet. Check the record counts in the DB first, and use the option I was talking about above. There's also a thread around here somewhere about a network interface setting that can help.

Oh, and make sure you've setup your tuner card(s) and the input connection(s) under mythtv-setup. No input connections, no program guide, because it only shows you stuff that's available through one of your inputs.
Author:  mal1ch1 [ Sat Jan 06, 2007 7:03 pm ]
Post subject:  Thanks
Thanks for the time tjc, but I took the chicken way out. I installed the latest version and all's well except that the remote's not working.
Possibly the problem with mysql was not setting the actual IP of the machine.
All inputs, etc... were good to go.
This lirc has me going now though. There's no lirc directory in /dev, which one script I ran across references. Also, I guess somehow the 350 is seen as
a 150 according to the logs. It tries, but there's no config info.
I may try that install again, as it went kinda' funny; when MythTV is installed & you reboot, you come to the small sign-on screen and go through several configuration steps; my install only went as far as asking if I wanted to set up the 350's TV-out, then jumped right to the actual card configuration screens.
Again, thanks, I'm just getting back into it with Knoppix; I went to Debian linux from KnoppMyth and then a couple more distros. I'm getting there :).
Page 1 of 1 All times are UTC - 6 hours
Powered by phpBB® Forum Software © phpBB Group
http://www.phpbb.com/