View unanswered posts    View active topics

All times are UTC - 6 hours





Post new topic Reply to topic  [ 19 posts ] 
Go to page 1, 2  Next

Print view Previous topic   Next topic  
Author Message
Search for:
PostPosted: Thu May 17, 2007 11:38 pm 
Offline
Joined: Wed May 09, 2007 8:47 pm
Posts: 367
Location: Minnesota- Brrrrr!
I ran mythfilldatabase and rebooted several times: I am unable to see the tv guide data. I think the data was downloaded, however, I am not sure how to verify it made it to the database.

Myth TV Status
==========

http://mythtvhost/mythweb/status

Last mythfilldatabase run started on 2007-05-18 01:28 and ended on 2007-05-18 01:28.
Suggested next mythfilldatabase run: 2007-05-19 07:55.
There's no guide data available! Have you run mythfilldatabase?
DataDirect Status: Your subscription expires on 07/27/07 00:21:23

Is there a troubleshooting procedure: I could not find one that fits this problem.

_________________
R7.3: 0.22.20091023-1, Hauppauge PVR-500 (Philips FQ1236A MK4), Gigabyte Gigabyte EG45M-UD2H, E5200 2.4Ghz, 2GB RAM, NVIDIA GEFORCE 256MB


Top
 Profile  
 
 Post subject:
PostPosted: Fri May 18, 2007 7:15 am 
Offline
Joined: Wed Nov 16, 2005 8:55 pm
Posts: 1381
Location: Farmington, MI USA
gatorback wrote:
Is there a troubleshooting procedure: I could not find one that fits this problem.

Run mythfilldatabase in an xterm and see what errors spit out? Did you configure a lineup at labs.zap2it.com?


Top
 Profile  
 
 Post subject:
PostPosted: Fri May 18, 2007 7:29 am 
Offline
Joined: Tue Nov 08, 2005 7:31 am
Posts: 195
Location: Secret Lair
I remember a couple old threads on debugging a problem people had with a grabber that made bad assumptions about it's environment... Try searching for "mythfilldatabase" and "mysql" as I remember DB queries being used.


Top
 Profile  
 
 Post subject:
PostPosted: Fri May 18, 2007 8:15 am 
Offline
Joined: Wed May 09, 2007 8:47 pm
Posts: 367
Location: Minnesota- Brrrrr!
I did configure a channel lineup using labs.zap2it.com. I also mapped each tuner to the channel lineup in the 'Input Connections' menu. In addition a scan for channels was performed. The system's TV functionality works, however, the critical tv guide data is not there.

I believe the hardware is good because I was able to setup Knoppmyth with a bigger HDD. I am re-creating the system with a smaller HDD to perform tests and avoid monkeying up my good large HDD.

I recorded mythfilldatabase output:

2007-05-18 10:05:38.755 Using runtime prefix = /usr
2007-05-18 10:05:38.898 New DB connection, total: 1
2007-05-18 10:05:38.914 Connected to database 'mythconverg' at host: localhost
2007-05-18 10:05:38.993 New DB connection, total: 2
2007-05-18 10:05:38.994 Connected to database 'mythconverg' at host: localhost
2007-05-18 10:05:39.026 Updating source #1 (zap2it) with grabber datadirect
2007-05-18 10:05:39.027 Checking day @ offset 0, date: Fri May 18 2007
2007-05-18 10:05:39.052 Data refresh needed because no data exists for day @ offset 0 from 6PM - midnight.
2007-05-18 10:05:39.053 Refreshing data for Fri May 18 2007
2007-05-18 10:05:39.066 New DB DataDirect connection
2007-05-18 10:05:39.067 Connected to database 'mythconverg' at host: localhost
2007-05-18 10:05:39.083 Retrieving datadirect data.
2007-05-18 10:05:39.084 Grabbing data for Fri May 18 2007 offset 0
2007-05-18 10:05:39.084 From Fri May 18 04:00:00 2007 to Sat May 19 04:00:00 2007 (UTC)
2007-05-18 10:05:54.917 DataDirect: Your subscription expires on 07/27/07 00:21:23
2007-05-18 10:06:08.270 Grab complete. Actual data from Fri May 18 04:00:00 2007 to Sat May 19 04:00:00 2007 (UTC)
2007-05-18 10:06:08.281 Main temp tables populated.
2007-05-18 10:06:08.281 Updating myth channels.
2007-05-18 10:06:08.285 Updating icons for sourceid: 1
2007-05-18 10:06:08.293 New DB connection, total: 3
2007-05-18 10:06:08.294 Connected to database 'mythconverg' at host: localhost
2007-05-18 10:06:08.306 Channels updated.
2007-05-18 10:06:08.421 Did not find any new program data.
2007-05-18 10:06:08.421 Checking day @ offset 1, date: Sat May 19 2007
2007-05-18 10:06:08.421 Refreshing data for Sat May 19 2007
2007-05-18 10:06:08.422 Retrieving datadirect data.
2007-05-18 10:06:08.422 Grabbing data for Fri May 18 2007 offset 1
2007-05-18 10:06:08.422 From Sat May 19 04:00:00 2007 to Sun May 20 04:00:00 2007 (UTC)
2007-05-18 10:06:30.520 DataDirect: Your subscription expires on 07/27/07 00:21:23
2007-05-18 10:06:42.719 Grab complete. Actual data from Sat May 19 04:00:00 2007 to Sun May 20 04:00:00 2007 (UTC)
2007-05-18 10:06:42.720 Main temp tables populated.
2007-05-18 10:06:42.720 Updating myth channels.
2007-05-18 10:06:42.724 Updating icons for sourceid: 1
2007-05-18 10:06:42.726 Channels updated.
2007-05-18 10:06:42.842 Did not find any new program data.
2007-05-18 10:06:42.842 Checking day @ offset 2, date: Sun May 20 2007
2007-05-18 10:06:42.846 Data refresh needed because no data exists for day @ offset 2 from 6PM - midnight.
2007-05-18 10:06:42.847 Refreshing data for Sun May 20 2007
2007-05-18 10:06:42.847 Retrieving datadirect data.
2007-05-18 10:06:42.848 Grabbing data for Fri May 18 2007 offset 2
2007-05-18 10:06:42.848 From Sun May 20 04:00:00 2007 to Mon May 21 04:00:00 2007 (UTC)
2007-05-18 10:07:06.526 DataDirect: Your subscription expires on 07/27/07 00:21:23
2007-05-18 10:07:18.065 Grab complete. Actual data from Sun May 20 04:00:00 2007 to Mon May 21 04:00:00 2007 (UTC)
2007-05-18 10:07:18.066 Main temp tables populated.
2007-05-18 10:07:18.067 Updating myth channels.
2007-05-18 10:07:18.070 Updating icons for sourceid: 1
2007-05-18 10:07:18.072 Channels updated.
2007-05-18 10:07:18.187 Did not find any new program data.
2007-05-18 10:07:18.187 Checking day @ offset 3, date: Mon May 21 2007
2007-05-18 10:07:18.192 Data refresh needed because no data exists for day @ offset 3 from 6PM - midnight.
2007-05-18 10:07:18.192 Refreshing data for Mon May 21 2007
2007-05-18 10:07:18.193 Retrieving datadirect data.
2007-05-18 10:07:18.193 Grabbing data for Fri May 18 2007 offset 3
2007-05-18 10:07:18.193 From Mon May 21 04:00:00 2007 to Tue May 22 04:00:00 2007 (UTC)
2007-05-18 10:07:38.293 DataDirect: Your subscription expires on 07/27/07 00:21:23
2007-05-18 10:07:51.580 Grab complete. Actual data from Mon May 21 04:00:00 2007 to Tue May 22 04:00:00 2007 (UTC)
2007-05-18 10:07:51.582 Main temp tables populated.
2007-05-18 10:07:51.582 Updating myth channels.
2007-05-18 10:07:51.586 Updating icons for sourceid: 1
2007-05-18 10:07:51.587 Channels updated.
2007-05-18 10:07:51.701 Did not find any new program data.
2007-05-18 10:07:51.717 Checking day @ offset 4, date: Tue May 22 2007
2007-05-18 10:07:51.722 Data refresh needed because no data exists for day @ offset 4 from 6PM - midnight.
2007-05-18 10:07:51.722 Refreshing data for Tue May 22 2007
2007-05-18 10:07:51.723 Retrieving datadirect data.
2007-05-18 10:07:51.723 Grabbing data for Fri May 18 2007 offset 4
2007-05-18 10:07:51.723 From Tue May 22 04:00:00 2007 to Wed May 23 04:00:00 2007 (UTC)
2007-05-18 10:08:14.006 DataDirect: Your subscription expires on 07/27/07 00:21:23
2007-05-18 10:08:27.385 Grab complete. Actual data from Tue May 22 04:00:00 2007 to Wed May 23 04:00:00 2007 (UTC)
2007-05-18 10:08:27.386 Main temp tables populated.
2007-05-18 10:08:27.386 Updating myth channels.
2007-05-18 10:08:27.390 Updating icons for sourceid: 1
2007-05-18 10:08:27.391 Channels updated.
2007-05-18 10:08:27.506 Did not find any new program data.
2007-05-18 10:08:27.506 Checking day @ offset 5, date: Wed May 23 2007
2007-05-18 10:08:27.511 Data refresh needed because no data exists for day @ offset 5 from 6PM - midnight.
2007-05-18 10:08:27.511 Refreshing data for Wed May 23 2007
2007-05-18 10:08:27.512 Retrieving datadirect data.
2007-05-18 10:08:27.512 Grabbing data for Fri May 18 2007 offset 5
2007-05-18 10:08:27.513 From Wed May 23 04:00:00 2007 to Thu May 24 04:00:00 2007 (UTC)
2007-05-18 10:08:45.017 DataDirect: Your subscription expires on 07/27/07 00:21:23
2007-05-18 10:08:58.534 Grab complete. Actual data from Wed May 23 04:00:00 2007 to Thu May 24 04:00:00 2007 (UTC)
2007-05-18 10:08:58.535 Main temp tables populated.
2007-05-18 10:08:58.536 Updating myth channels.
2007-05-18 10:08:58.539 Updating icons for sourceid: 1
2007-05-18 10:08:58.541 Channels updated.
2007-05-18 10:08:58.655 Did not find any new program data.
2007-05-18 10:08:58.655 Checking day @ offset 6, date: Thu May 24 2007
2007-05-18 10:08:58.660 Data refresh needed because no data exists for day @ offset 6 from 6PM - midnight.
2007-05-18 10:08:58.660 Refreshing data for Thu May 24 2007
2007-05-18 10:08:58.661 Retrieving datadirect data.
2007-05-18 10:08:58.661 Grabbing data for Fri May 18 2007 offset 6
2007-05-18 10:08:58.661 From Thu May 24 04:00:00 2007 to Fri May 25 04:00:00 2007 (UTC)
2007-05-18 10:09:14.939 DataDirect: Your subscription expires on 07/27/07 00:21:23
2007-05-18 10:09:28.647 Grab complete. Actual data from Thu May 24 04:00:00 2007 to Fri May 25 04:00:00 2007 (UTC)
2007-05-18 10:09:28.648 Main temp tables populated.
2007-05-18 10:09:28.648 Updating myth channels.
2007-05-18 10:09:28.652 Updating icons for sourceid: 1
2007-05-18 10:09:28.654 Channels updated.
2007-05-18 10:09:28.770 Did not find any new program data.
2007-05-18 10:09:28.771 Checking day @ offset 7, date: Fri May 25 2007
2007-05-18 10:09:28.775 Data refresh needed because no data exists for day @ offset 7 from 6PM - midnight.
2007-05-18 10:09:28.775 Refreshing data for Fri May 25 2007
2007-05-18 10:09:28.776 Retrieving datadirect data.
2007-05-18 10:09:28.776 Grabbing data for Fri May 18 2007 offset 7
2007-05-18 10:09:28.777 From Fri May 25 04:00:00 2007 to Sat May 26 04:00:00 2007 (UTC)
2007-05-18 10:09:41.734 DataDirect: Your subscription expires on 07/27/07 00:21:23
2007-05-18 10:09:55.231 Grab complete. Actual data from Fri May 25 04:00:00 2007 to Sat May 26 04:00:00 2007 (UTC)
2007-05-18 10:09:55.232 Main temp tables populated.
2007-05-18 10:09:55.232 Updating myth channels.
2007-05-18 10:09:55.237 Updating icons for sourceid: 1
2007-05-18 10:09:55.238 Channels updated.
2007-05-18 10:09:55.353 Did not find any new program data.
2007-05-18 10:09:55.353 Checking day @ offset 8, date: Sat May 26 2007
2007-05-18 10:09:55.358 Data refresh needed because no data exists for day @ offset 8 from 6PM - midnight.
2007-05-18 10:09:55.358 Refreshing data for Sat May 26 2007
2007-05-18 10:09:55.359 Retrieving datadirect data.
2007-05-18 10:09:55.359 Grabbing data for Fri May 18 2007 offset 8
2007-05-18 10:09:55.359 From Sat May 26 04:00:00 2007 to Sun May 27 04:00:00 2007 (UTC)
2007-05-18 10:10:07.825 DataDirect: Your subscription expires on 07/27/07 00:21:23
2007-05-18 10:10:19.426 Grab complete. Actual data from Sat May 26 04:00:00 2007 to Sun May 27 04:00:00 2007 (UTC)
2007-05-18 10:10:19.427 Main temp tables populated.
2007-05-18 10:10:19.427 Updating myth channels.
2007-05-18 10:10:19.431 Updating icons for sourceid: 1
2007-05-18 10:10:19.432 Channels updated.
2007-05-18 10:10:19.539 Did not find any new program data.
2007-05-18 10:10:19.540 Checking day @ offset 9, date: Sun May 27 2007
2007-05-18 10:10:19.544 Data refresh needed because no data exists for day @ offset 9 from 6PM - midnight.
2007-05-18 10:10:19.545 Refreshing data for Sun May 27 2007
2007-05-18 10:10:19.546 Retrieving datadirect data.
2007-05-18 10:10:19.546 Grabbing data for Fri May 18 2007 offset 9
2007-05-18 10:10:19.546 From Sun May 27 04:00:00 2007 to Mon May 28 04:00:00 2007 (UTC)
2007-05-18 10:10:25.031 DataDirect: Your subscription expires on 07/27/07 00:21:23
2007-05-18 10:10:36.417 Grab complete. Actual data from Sun May 27 04:00:00 2007 to Mon May 28 04:00:00 2007 (UTC)
2007-05-18 10:10:36.418 Main temp tables populated.
2007-05-18 10:10:36.418 Updating myth channels.
2007-05-18 10:10:36.422 Updating icons for sourceid: 1
2007-05-18 10:10:36.423 Channels updated.
2007-05-18 10:10:36.527 Did not find any new program data.
2007-05-18 10:10:36.527 Checking day @ offset 10, date: Mon May 28 2007
2007-05-18 10:10:36.532 Data refresh needed because no data exists for day @ offset 10 from 6PM - midnight.
2007-05-18 10:10:36.532 Refreshing data for Mon May 28 2007
2007-05-18 10:10:36.533 Retrieving datadirect data.
2007-05-18 10:10:36.533 Grabbing data for Fri May 18 2007 offset 10
2007-05-18 10:10:36.533 From Mon May 28 04:00:00 2007 to Tue May 29 04:00:00 2007 (UTC)
2007-05-18 10:10:41.988 DataDirect: Your subscription expires on 07/27/07 00:21:23
2007-05-18 10:10:55.406 Grab complete. Actual data from Mon May 28 04:00:00 2007 to Tue May 29 04:00:00 2007 (UTC)
2007-05-18 10:10:55.408 Main temp tables populated.
2007-05-18 10:10:55.408 Updating myth channels.
2007-05-18 10:10:55.411 Updating icons for sourceid: 1
2007-05-18 10:10:55.413 Channels updated.
2007-05-18 10:10:55.525 Did not find any new program data.
2007-05-18 10:10:55.525 Checking day @ offset 11, date: Tue May 29 2007
2007-05-18 10:10:55.529 Data refresh needed because no data exists for day @ offset 11 from 6PM - midnight.
2007-05-18 10:10:55.530 Refreshing data for Tue May 29 2007
2007-05-18 10:10:55.530 Retrieving datadirect data.
2007-05-18 10:10:55.531 Grabbing data for Fri May 18 2007 offset 11
2007-05-18 10:10:55.531 From Tue May 29 04:00:00 2007 to Wed May 30 04:00:00 2007 (UTC)
2007-05-18 10:11:02.788 DataDirect: Your subscription expires on 07/27/07 00:21:23
2007-05-18 10:11:16.124 Grab complete. Actual data from Tue May 29 04:00:00 2007 to Wed May 30 04:00:00 2007 (UTC)
2007-05-18 10:11:16.125 Main temp tables populated.
2007-05-18 10:11:16.126 Updating myth channels.
2007-05-18 10:11:16.129 Updating icons for sourceid: 1
2007-05-18 10:11:16.130 Channels updated.
2007-05-18 10:11:16.245 Did not find any new program data.
2007-05-18 10:11:16.245 Checking day @ offset 12, date: Wed May 30 2007
2007-05-18 10:11:16.250 Data refresh needed because no data exists for day @ offset 12 from 6PM - midnight.
2007-05-18 10:11:16.250 Refreshing data for Wed May 30 2007
2007-05-18 10:11:16.251 Retrieving datadirect data.
2007-05-18 10:11:16.251 Grabbing data for Fri May 18 2007 offset 12
2007-05-18 10:11:16.251 From Wed May 30 04:00:00 2007 to Thu May 31 04:00:00 2007 (UTC)
2007-05-18 10:11:20.367 DataDirect: Your subscription expires on 07/27/07 00:21:23
2007-05-18 10:11:33.604 Grab complete. Actual data from Wed May 30 04:00:00 2007 to Thu May 31 04:00:00 2007 (UTC)
2007-05-18 10:11:33.605 Main temp tables populated.
2007-05-18 10:11:33.606 Updating myth channels.
2007-05-18 10:11:33.609 Updating icons for sourceid: 1
2007-05-18 10:11:33.611 Channels updated.
2007-05-18 10:11:33.726 Did not find any new program data.
2007-05-18 10:11:33.727 Checking day @ offset 13, date: Thu May 31 2007
2007-05-18 10:11:33.731 Data refresh needed because no data exists for day @ offset 13 from 6PM - midnight.
2007-05-18 10:11:33.732 Refreshing data for Thu May 31 2007
2007-05-18 10:11:33.732 Retrieving datadirect data.
2007-05-18 10:11:33.733 Grabbing data for Fri May 18 2007 offset 13
2007-05-18 10:11:33.733 From Thu May 31 04:00:00 2007 to Fri Jun 1 04:00:00 2007 (UTC)
2007-05-18 10:11:38.651 DataDirect: Your subscription expires on 07/27/07 00:21:23
2007-05-18 10:12:00.400 Grab complete. Actual data from Wed May 30 00:00:00 2007 to Thu May 31 23:59:59 2007 (UTC)
2007-05-18 10:12:00.401 Main temp tables populated.
2007-05-18 10:12:00.401 Updating myth channels.
2007-05-18 10:12:00.405 Updating icons for sourceid: 1
2007-05-18 10:12:00.406 Channels updated.
2007-05-18 10:12:00.624 Did not find any new program data.
2007-05-18 10:12:00.670 New DB connection, total: 4
2007-05-18 10:12:00.680 Connected to database 'mythconverg' at host: localhost
2007-05-18 10:12:00.700 New DB connection, total: 5
2007-05-18 10:12:00.701 Connected to database 'mythconverg' at host: localhost
2007-05-18 10:12:00.713 Failed to fetch some program info
2007-05-18 10:12:00.713 Adjusting program database end times.
2007-05-18 10:12:00.714 0 replacements made
2007-05-18 10:12:00.715 Marking generic episodes.
2007-05-18 10:12:00.729 Found 0
2007-05-18 10:12:00.729 Marking repeats.
2007-05-18 10:12:00.732 Found 0
2007-05-18 10:12:00.732 Unmarking new episode rebroadcast repeats.
2007-05-18 10:12:00.732 Found 0
2007-05-18 10:12:01.298 DataDirect: NextSuggestedTime is: 2007-05-19T11:41:51
2007-05-18 10:12:01.312
===============================================================
| Attempting to contact the master backend for rescheduling. |
| If the master is not running, rescheduling will happen when |
| the master backend is restarted. |
===============================================================
2007-05-18 10:12:01.367 Connecting to backend server: 127.0.0.1:6543 (try 1 of 5)
2007-05-18 10:12:01.409 Using protocol version 26
2007-05-18 10:12:01.655 mythfilldatabase run complete.

_________________
R7.3: 0.22.20091023-1, Hauppauge PVR-500 (Philips FQ1236A MK4), Gigabyte Gigabyte EG45M-UD2H, E5200 2.4Ghz, 2GB RAM, NVIDIA GEFORCE 256MB


Last edited by gatorback on Fri May 18, 2007 10:23 am, edited 1 time in total.


Top
 Profile  
 
 Post subject:
PostPosted: Fri May 18, 2007 10:10 am 
Offline
Joined: Thu Feb 12, 2004 2:54 pm
Posts: 392
Location: Beaumont, CA
are you running mythfilldatabase as root? If not try it and it should work

_________________
ASUS A7N266 Micro-ATX Motherboard
Athlon 2200 processor
512K Kingston PC2100 Memory
MicroAtx Case
2 PVR250's w/remote
eVGA e-GeForce mx4000 (64 Ram with Tv/Out (Svideo))
Lite-on DVD cd-rw combo
120 GB Western Digital


Top
 Profile  
 
 Post subject:
PostPosted: Fri May 18, 2007 10:16 am 
Offline
Joined: Wed May 09, 2007 8:47 pm
Posts: 367
Location: Minnesota- Brrrrr!
:) Excellent question: I have run mythfildatabase as root and as mythtv.

I would encourage readers to pose similar questions that dissect how setup and mythfilldabase procedure was performed.

_________________
R7.3: 0.22.20091023-1, Hauppauge PVR-500 (Philips FQ1236A MK4), Gigabyte Gigabyte EG45M-UD2H, E5200 2.4Ghz, 2GB RAM, NVIDIA GEFORCE 256MB


Top
 Profile  
 
 Post subject:
PostPosted: Fri May 18, 2007 10:22 am 
Offline
Joined: Thu Feb 12, 2004 2:54 pm
Posts: 392
Location: Beaumont, CA
As root try running mythfilldatabase --refresh-today. when it is finished check for guide data. If nothing there then look at /var/log/mysql.err and /var/log/mysql.log to see if there are any clues.

_________________
ASUS A7N266 Micro-ATX Motherboard
Athlon 2200 processor
512K Kingston PC2100 Memory
MicroAtx Case
2 PVR250's w/remote
eVGA e-GeForce mx4000 (64 Ram with Tv/Out (Svideo))
Lite-on DVD cd-rw combo
120 GB Western Digital


Top
 Profile  
 
 Post subject:
PostPosted: Fri May 18, 2007 11:38 am 
Offline
Joined: Wed Nov 16, 2005 8:55 pm
Posts: 1381
Location: Farmington, MI USA
What elgordo123 said.

It appears your guide data is filled, because you keep getting
Quote:
Did not find any new program data.
Strange you're not seeing the data... :?

If the --refresh-today option works for you, try --refresh-all to get all the guide data updated.


Top
 Profile  
 
 Post subject:
PostPosted: Fri May 18, 2007 12:07 pm 
Offline
Joined: Wed May 09, 2007 8:47 pm
Posts: 367
Location: Minnesota- Brrrrr!
Attempts with mythfilldatabase --refresh-today were not successful: tv data guide is unavailable. Is there a way (command) to look inside the database to see if the data made it into the database?

Unfortunately /var/log/mysql.err and /var/log/mysql.log were empty and did not reveal any clues.

I suspect the data is downloaded, however, maybe it is not finding its way into its final destination.

Should I just re-install?

_________________
R7.3: 0.22.20091023-1, Hauppauge PVR-500 (Philips FQ1236A MK4), Gigabyte Gigabyte EG45M-UD2H, E5200 2.4Ghz, 2GB RAM, NVIDIA GEFORCE 256MB


Top
 Profile  
 
 Post subject:
PostPosted: Fri May 18, 2007 12:35 pm 
Offline
Joined: Wed Nov 16, 2005 8:55 pm
Posts: 1381
Location: Farmington, MI USA
gatorback wrote:
Attempts with mythfilldatabase --refresh-today were not successful: tv data guide is unavailable. Is there a way (command) to look inside the database to see if the data made it into the database?
Try
Code:
mysql mythconverg <<EOF
select * from program;
quit
EOF
in an xterm. This should spit out everything in your program guide.

gatorback wrote:
Unfortunately /var/log/mysql.err and /var/log/mysql.log were empty and did not reveal any clues.

I suspect the data is downloaded, however, maybe it is not finding its way into its final destination.

Should I just re-install?
That seems drastic, especially without knowing what the problem is.

EDIT: You said you were using a small HD, does it have any available space? /EDIT


Top
 Profile  
 
 Post subject:
PostPosted: Fri May 18, 2007 1:24 pm 
Offline
Joined: Wed May 09, 2007 8:47 pm
Posts: 367
Location: Minnesota- Brrrrr!
When I said small HDD, it is actually 40GB: plenty of space for testing. The big HDD is 200GB.

As a newbie, I am not sure what I am looking for when I run the code. Was the output directed to a file? I did not see anything on the xterm display. I am not sure if:

1) the select statement returned nothing or
2) I do not have enough information to interpret the results or
3) I have somehow not pefromed the instructions correctly.

The first statement: mysql mythconverg <<EOF
puts the xterm in a state where all subsequent commands are executed at a different prompt:

root@mythtvhost:~# mysql mythconverg <<EOF
> select * from program;
> quit
> EOF

The xterm does not display any additional data.

I agree that reinstall is drastic. I would prefer to learn what the problem, especially if it is "low hanging fruit". However that being said, I do not want to 'burn' any more space on this board than necessary.

I really do appreciate these suggestions.

_________________
R7.3: 0.22.20091023-1, Hauppauge PVR-500 (Philips FQ1236A MK4), Gigabyte Gigabyte EG45M-UD2H, E5200 2.4Ghz, 2GB RAM, NVIDIA GEFORCE 256MB


Top
 Profile  
 
 Post subject:
PostPosted: Fri May 18, 2007 2:00 pm 
Offline
Joined: Wed Nov 16, 2005 8:55 pm
Posts: 1381
Location: Farmington, MI USA
gatorback wrote:
When I said small HDD, it is actually 40GB: plenty of space for testing. The big HDD is 200GB.
So space is not the issue...

gatorback wrote:
As a newbie, I am not sure what I am looking for when I run the code. Was the output directed to a file? I did not see anything on the xterm display. I am not sure if:

1) the select statement returned nothing or
2) I do not have enough information to interpret the results or
3) I have somehow not pefromed the instructions correctly.

The first statement: mysql mythconverg <<EOF
puts the xterm in a state where all subsequent commands are executed at a different prompt:

root@mythtvhost:~# mysql mythconverg <<EOF
> select * from program;
> quit
> EOF
Correct. After entering the last EOF and pressing return you should see the contents of the program table which holds the program guide data. A test to make sure your commands are working:
Code:
mysql mythconverg <<EOF
select * from settings;
quit
EOF
This should display all the data from the settings table. alternatively you could
Code:
mysql mythconverg <enter>
select * from settings; (or program;) <enter>
quit


gatorback wrote:
The xterm does not display any additional data.
That doesn't sound good. When you issue the mythfilldatabase command do you see that the guide data is actually being downloaded? You should see a series of "Connecting to DataDirect" and a bunch of download progress indicators.


Top
 Profile  
 
 Post subject:
PostPosted: Fri May 18, 2007 2:08 pm 
Offline
Joined: Thu Feb 12, 2004 2:54 pm
Posts: 392
Location: Beaumont, CA
To get into mysql you can also do this:
mysql -u mythtv -p mythconverg; (type in password)
then
select * from program; (enter)
and see if it shows anything there. It might say empty set, if so then there is nothing in that table.

_________________
ASUS A7N266 Micro-ATX Motherboard
Athlon 2200 processor
512K Kingston PC2100 Memory
MicroAtx Case
2 PVR250's w/remote
eVGA e-GeForce mx4000 (64 Ram with Tv/Out (Svideo))
Lite-on DVD cd-rw combo
120 GB Western Digital


Top
 Profile  
 
 Post subject:
PostPosted: Fri May 18, 2007 2:37 pm 
Offline
Joined: Wed May 09, 2007 8:47 pm
Posts: 367
Location: Minnesota- Brrrrr!
Excellent postings: The two latest snippets were effective at demonstrating mySQL queries. I captured the output below.

I also tried elgordo123's suggestion and it returned an empty set. That being said, I have come to the conclusion that I can not see the guide data because it was downloaded, but did not make it into the database.

I ran mythfilldatabase again and it seemed to download the guide data: 16:36:45 (76.25 KB/s).... saved [1692181]

Given that information, is there anything else that can be done (from a diagnostic standpoint) to identify the root cause of the problem?



MySQL Data from table = program
========================

value data hostname
mythfilldatabaseLastRunStart 2007-05-18 13:56 NULL
mythfilldatabaseLastRunEnd 2007-05-18 13:56 NULL
mythfilldatabaseLastRunStatus NULL NULL
DataDirectMessage Your subscription expires on 07/27/07 00:21:23 NULL
HaveRepeats 0 NULL
DBSchemaVer 1123 NULL
DefaultTranscoder 0 NULL
MythFillSuggestedRunTime 2007-05-19T09:01:04 NULL
MythFillGrabberSuggestsTime 1 NULL
BackendServerIP 127.0.0.1 mythtvhost40
BackendServerPort 6543 mythtvhost40
BackendStatusPort 6544 mythtvhost40
MasterServerIP 127.0.0.1 NULL
MasterServerPort 6543 NULL
RecordFilePrefix /myth/tv mythtvhost40
SaveTranscoding 0 NULL
TVFormat NTSC NULL
VbiFormat NTSC Closed Caption mythtvhost40
FreqTable us-cable NULL
TimeOffset None NULL
EITTransportTimeout 5 NULL
MasterBackendOverride 1 NULL
DeletesFollowLinks 1 NULL
startupCommand NULL
blockSDWUwithoutClient 1 NULL
idleTimeoutSecs 0 NULL
idleWaitForRecordingTime 15 NULL
StartupSecsBeforeRecording 120 NULL
WakeupTimeFormat hh:mm yyyy-MM-dd NULL
SetWakeuptimeCommand NULL
ServerHaltCommand sudo /sbin/halt -p NULL
preSDWUCheckCommand NULL
WOLbackendReconnectWaitTime 0 NULL
WOLbackendConnectRetry 5 NULL
WOLbackendCommand NULL
WOLslaveBackendsCommand NULL
JobQueueMaxSimultaneousJobs 1 mythtvhost40
JobQueueCheckFrequency 60 mythtvhost40
JobQueueWindowStart 00:00 mythtvhost40
JobQueueWindowEnd 23:59 mythtvhost40
JobQueueCPU 0 mythtvhost40
JobAllowCommFlag 1 mythtvhost40
JobAllowTranscode 1 mythtvhost40
JobAllowUserJob1 0 mythtvhost40
JobAllowUserJob2 0 mythtvhost40
JobAllowUserJob3 0 mythtvhost40
JobAllowUserJob4 0 mythtvhost40
JobsRunOnRecordHost 0 NULL
AutoTranscodeBeforeAutoCommflag 0 NULL
AutoCommflagWhileRecording 0 NULL
UserJobDesc1 User Job #1 NULL
UserJob1 NULL
UserJobDesc2 User Job #2 NULL
UserJob2 NULL
UserJobDesc3 User Job #3 NULL
UserJob3 NULL
UserJobDesc4 User Job #4 NULL
UserJob4 NULL
Deinterlace 1 mythtvhost40
DeinterlaceFilter linearblend mythtvhost40
CustomFilters mythtvhost40
PreferredMPEG2Decoder ffmpeg mythtvhost40
UseOpenGLVSync 0 mythtvhost40
RealtimePriority 1 mythtvhost40
UseVideoTimebase 0 mythtvhost40
DecodeExtraAudio 1 mythtvhost40
AspectOverride 0 mythtvhost40
PIPLocation 0 mythtvhost40
PlaybackExitPrompt 2 mythtvhost40
EndOfRecordingExitPrompt 1 mythtvhost40
ClearSavedPosition 1 mythtvhost40
AltClearSavedPosition 1 mythtvhost40
UseOutputPictureControls 0 mythtvhost40
AudioNag 1 mythtvhost40
UDPNotifyPort 6948 mythtvhost40
PlayBoxOrdering 1 mythtvhost40
PlayBoxEpisodeSort Date mythtvhost40
GeneratePreviewPixmaps 0 mythtvhost40
PreviewPixmapOffset 64 NULL
PreviewFromBookmark 1 mythtvhost40
PlaybackPreview 1 mythtvhost40
PlaybackPreviewLowCPU 1 mythtvhost40
PlaybackBoxStartInTitle 1 mythtvhost40
ShowGroupInfo 0 mythtvhost40
AllRecGroupPassword NULL
DisplayRecGroup All Programs mythtvhost40
QueryInitialFilter 0 mythtvhost40
RememberRecGroup 1 mythtvhost40
DispRecGroupAsAllProg 0 mythtvhost40
LiveTVInAllPrograms 1 mythtvhost40
DisplayGroupDefaultView 0 mythtvhost40
PVR350OutputEnable 0 mythtvhost40
PVR350VideoDev /dev/video16 mythtvhost40
PVR350EPGAlphaValue 164 mythtvhost40
PVR350InternalAudioOnly 0 mythtvhost40
SmartForward 0 mythtvhost40
StickyKeys 0 mythtvhost40
FFRewReposTime 100 mythtvhost40
FFRewReverse 1 mythtvhost40
ExactSeeking 0 mythtvhost40
AutoCommercialSkip 0 mythtvhost40
CommRewindAmount 0 mythtvhost40
CommNotifyAmount 0 mythtvhost40
CommSkipAllBlanks 1 NULL
VertScanPercentage 0 mythtvhost40
HorizScanPercentage 0 mythtvhost40
XScanDisplacement 0 mythtvhost40
YScanDisplacement 0 mythtvhost40
OSDTheme Titivillus-OSD mythtvhost40
OSDGeneralTimeout 2 mythtvhost40
OSDProgramInfoTimeout 3 mythtvhost40
OSDNotifyTimeout 5 mythtvhost40
OSDFont FreeMono.ttf mythtvhost40
OSDCCFont FreeMono.ttf mythtvhost40
OSDThemeFontSizeType default mythtvhost40
CCBackground 0 mythtvhost40
DefaultCCMode 0 mythtvhost40
PersistentBrowseMode 1 mythtvhost40
ChannelOrdering channum + 0 mythtvhost40
ChannelFormat <num> <sign> mythtvhost40
LongChannelFormat <num> <name> mythtvhost40
SmartChannelChange 0 mythtvhost40
LastFreeCard 0 NULL
AutoExpireMethod 2 NULL
AutoExpireDefault 1 NULL
AutoExpireLiveTVMaxAge 1 NULL
AutoCommercialFlag 1 NULL
CommercialSkipMethod 1 NULL
AggressiveCommDetect 1 NULL
AutoTranscode 0 NULL
AutoRunUserJob1 0 NULL
AutoRunUserJob2 0 NULL
AutoRunUserJob3 0 NULL
AutoRunUserJob4 0 NULL
AutoExpireExtraSpace 1 NULL
RecordPreRoll 0 NULL
RecordOverTime 0 NULL
OverTimeCategory category name NULL
CategoryOverTime 30 NULL
ATSCCheckSignalThreshold 65 NULL
ATSCCheckSignalWait 5000 NULL
HDRingbufferSize 9400 NULL
EPGFillType 12 mythtvhost40
EPGShowCategoryColors 1 mythtvhost40
EPGShowCategoryText 1 mythtvhost40
EPGScrollType 1 mythtvhost40
EPGShowChannelIcon 1 mythtvhost40
EPGShowFavorites 0 mythtvhost40
WatchTVGuide 0 mythtvhost40
chanPerPage 5 mythtvhost40
timePerPage 4 mythtvhost40
UnknownTitle Unknown mythtvhost40
UnknownCategory Unknown mythtvhost40
DefaultTVChannel 3 mythtvhost40
SelectChangesChannel 0 mythtvhost40
SelChangeRecThreshold 16 mythtvhost40
EPGEnableJumpToChannel 1 NULL
Theme Titivillus mythtvhost40
Style mythtvhost40
ThemeFontSizeType default mythtvhost40
RandomTheme 0 mythtvhost40
MenuTheme Default mythtvhost40
GuiWidth 0 mythtvhost40
GuiHeight 0 mythtvhost40
GuiOffsetX 0 mythtvhost40
GuiOffsetY 0 mythtvhost40
GuiSizeForTV 1 mythtvhost40
HideMouseCursor 1 mythtvhost40
RunFrontendInWindow 0 mythtvhost40
UseVideoModes 0 mythtvhost40
GuiVidModeResolution 640x480 mythtvhost40
TVVidModeResolution 400x300 mythtvhost40
TVVidModeForceAspect 0.0 mythtvhost40
VidModeWidth0 0 mythtvhost40
VidModeHeight0 0 mythtvhost40
TVVidModeResolution0 400x300 mythtvhost40
TVVidModeForceAspect0 0.0 mythtvhost40
VidModeWidth1 0 mythtvhost40
VidModeHeight1 0 mythtvhost40
TVVidModeResolution1 400x300 mythtvhost40
TVVidModeForceAspect1 0.0 mythtvhost40
VidModeWidth2 0 mythtvhost40
VidModeHeight2 0 mythtvhost40
TVVidModeResolution2 400x300 mythtvhost40
TVVidModeForceAspect2 0.0 mythtvhost40
DateFormat ddd MMM d mythtvhost40
ShortDateFormat M/d mythtvhost40
TimeFormat h:mm AP mythtvhost40
QtFontSmall 12 mythtvhost40
QtFontMedium 16 mythtvhost40
QtFontBig 25 mythtvhost40
PlayBoxTransparency 1 mythtvhost40
PlayBoxShading 0 mythtvhost40
UseVirtualKeyboard 1 mythtvhost40
LCDEnable 0 mythtvhost40
LCDShowTime 1 mythtvhost40
LCDShowMenu 1 mythtvhost40
LCDShowMusic 1 mythtvhost40
LCDShowMusicItems ArtistTitle mythtvhost40
LCDShowChannel 1 mythtvhost40
LCDShowRecStatus 0 mythtvhost40
LCDShowVolume 1 mythtvhost40
LCDShowGeneric 1 mythtvhost40
LCDBacklightOn 1 mythtvhost40
LCDHeartBeatOn 0 mythtvhost40
LCDKeyString ABCDEF mythtvhost40
LCDPopupTime 5 mythtvhost40
AudioOutputDevice /dev/dsp mythtvhost40
AC3PassThru 0 mythtvhost40
DTSPassThru 0 mythtvhost40
AggressiveSoundcardBuffer 0 mythtvhost40
MythControlsVolume 1 mythtvhost40
MixerDevice /dev/mixer mythtvhost40
MixerControl PCM mythtvhost40
MasterMixerVolume 70 mythtvhost40
PCMMixerVolume 70 mythtvhost40
IndividualMuteControl 0 mythtvhost40
AllowQuitShutdown 4 mythtvhost40
NoPromptOnExit 1 mythtvhost40
HaltCommand sudo halt mythtvhost40
LircKeyPressedApp mythtvhost40
UseArrowAccels 1 mythtvhost40
NetworkControlEnabled 0 mythtvhost40
NetworkControlPort 6546 mythtvhost40
SetupPinCodeRequired 0 mythtvhost40
MonitorDrives 1 mythtvhost40
EnableXbox 0 mythtvhost40
LogEnabled 0 NULL
LogPrintLevel 8 mythtvhost40
LogCleanEnabled 0 mythtvhost40
LogCleanPeriod 14 mythtvhost40
LogCleanDays 14 mythtvhost40
LogCleanMax 30 mythtvhost40
LogMaxCount 100 mythtvhost40
MythFillEnabled 1 NULL
MythFillDatabasePath /usr/bin/mythfilldatabase NULL
MythFillDatabaseArgs --quiet mythtvhost40
MythFillDatabaseLog NULL
MythFillPeriod 1 NULL
MythFillMinHour 9 NULL
MythFillMaxHour 11 NULL
SchedMoveHigher 0 NULL
SingleRecordRecPriority 1 NULL
OverrideRecordRecPriority 0 NULL
FindOneRecordRecPriority -1 NULL
WeekslotRecordRecPriority 0 NULL
TimeslotRecordRecPriority 0 NULL
ChannelRecordRecPriority 0 NULL
AllRecordRecPriority 0 NULL
BurnScriptPath /myth/mythburn mythtvhost40
BurnVideoFormat NTSC mythtvhost40
DVDDBSchemaVer 1001 NULL
DVDDeviceLocation /mnt/cdrom mythtvhost40
VCDDeviceLocation /mnt/cdrom mythtvhost40
DVDOnInsertDVD 1 mythtvhost40
DVDPlayerCommand xine -pfhq --no-splash dvd:// mythtvhost40
VCDPlayerCommand xine -pfhq --no-splash vcd:// mythtvhost40
DVDRipLocation /myth/tmp mythtvhost40
TitlePlayCommand mplayer dvd://%t -dvd-device %d -fs -zoom -vo xv -aid %a -channels %c mythtvhost40
SubTitleCommand -sid %s mythtvhost40
TranscodeCommand transcode mythtvhost40
MTDPort 2442 mythtvhost40
MTDNiceLevel 20 mythtvhost40
MTDConcurrentTranscodes 1 mythtvhost40
MTDRipSize 0 mythtvhost40
MTDLogFlag 0 mythtvhost40
MTDac3Flag 0 mythtvhost40
MTDxvidFlag 1 mythtvhost40
GalleryDBSchemaVer 1000 NULL
GalleryDir /myth/gallery mythtvhost40
GalleryThumbnailLocation 1 mythtvhost40
GalleryImportDirs /mnt/cdrom:/mnt/camera mythtvhost40
GalleryMoviePlayerCmd mplayer -fs %s mythtvhost40
SlideshowOpenGLTransition none mythtvhost40
SlideshowTransition none mythtvhost40
SlideshowBackground mythtvhost40
SlideshowDelay 5 mythtvhost40
GameDBSchemaVer 1012 NULL
MusicDBSchemaVer 1005 NULL
MusicLocation /myth/music/ mythtvhost40
MusicAudioDevice default mythtvhost40
CDDevice /dev/cdrom mythtvhost40
TreeLevels splitartist artist album title mythtvhost40
NonID3FileNameFormat GENRE/ARTIST/ALBUM/TRACK_TITLE mythtvhost40
Ignore_ID3 0 mythtvhost40
AutoLookupCD 1 mythtvhost40
AutoPlayCD 0 mythtvhost40
KeyboardAccelerators 1 mythtvhost40
CDWriterEnabled 1 mythtvhost40
CDWriterDevice ATA:1,0,0 mythtvhost40
CDDiskSize 1 mythtvhost40
CDCreateDir 1 mythtvhost40
CDWriteSpeed 0 mythtvhost40
CDBlankType fast mythtvhost40
PlayMode Normal mythtvhost40
IntelliRatingWeight 35 mythtvhost40
IntelliPlayCountWeight 25 mythtvhost40
IntelliLastPlayWeight 25 mythtvhost40
IntelliRandomWeight 15 mythtvhost40
MusicShowRatings 0 mythtvhost40
ShowWholeTree 0 mythtvhost40
ListAsShuffled 0 mythtvhost40
VisualMode Random mythtvhost40
VisualCycleOnSongChange 0 mythtvhost40
VisualModeDelay 0 mythtvhost40
VisualScaleWidth 1 mythtvhost40
VisualScaleHeight 1 mythtvhost40
ParanoiaLevel Full mythtvhost40
FilenameTemplate ARTIST/ALBUM/TRACK-TITLE mythtvhost40
TagSeparator - mythtvhost40
NoWhitespace 0 mythtvhost40
PostCDRipScript mythtvhost40
EjectCDAfterRipping 1 mythtvhost40
OnlyImportNewMusic 1 mythtvhost40
EncoderType ogg mythtvhost40
DefaultRipQuality 1 mythtvhost40
Mp3UseVBR 0 mythtvhost40
PhoneDBSchemaVer 1001 NULL
SipRegisterWithProxy 1 mythtvhost40
SipProxyName fwd.pulver.com mythtvhost40
SipProxyAuthName mythtvhost40
SipProxyAuthPassword mythtvhost40
MySipName Me mythtvhost40
SipAutoanswer 0 mythtvhost40
SipBindInterface eth0 mythtvhost40
SipLocalPort 5060 mythtvhost40
NatTraversalMethod None mythtvhost40
NatIpAddress http://checkip.dyndns.org mythtvhost40
AudioLocalPort 21232 mythtvhost40
VideoLocalPort 21234 mythtvhost40
MicrophoneDevice None mythtvhost40
CodecPriorityList GSM;G.711u;G.711a mythtvhost40
PlayoutAudioCall 40 mythtvhost40
PlayoutVideoCall 110 mythtvhost40
WebcamDevice /dev/video mythtvhost40
TxResolution 176x144 mythtvhost40
TransmitFPS 5 mythtvhost40
TransmitBandwidth 256 mythtvhost40
CaptureResolution 352x288 mythtvhost40
TimeToAnswer 10 mythtvhost40
DefaultVxmlUrl http://127.0.0.1/vxml/index.vxml mythtvhost40
DefaultVoicemailPrompt I am not at home, please leave a message after the tone mythtvhost40
VideoDBSchemaVer 1007 NULL
VideoStartupDir /myth/video mythtvhost40
VideoArtworkDir /myth/video/.covers mythtvhost40
VideoDefaultParentalLevel 4 mythtvhost40
VideoAggressivePC 0 mythtvhost40
VideoListUnknownFiletypes 1 mythtvhost40
VideoBrowserNoDB 0 mythtvhost40
VideoGalleryNoDB 0 mythtvhost40
VideoTreeNoDB 0 mythtvhost40
VideoTreeLoadMetaData 1 mythtvhost40
VideoNewBrowsable 1 mythtvhost40
Default MythVideo View 1 mythtvhost40
MovieListCommandLine /usr/share/mythtv/mythvideo/scripts/imdb.pl -M tv=no;video=no mythtvhost40
MoviePosterCommandLine /usr/share/mythtv/mythvideo/scripts/imdb.pl -P mythtvhost40
MovieDataCommandLine /usr/share/mythtv/mythvideo/scripts/imdb.pl -D mythtvhost40
VideoGalleryColsPerPage 4 mythtvhost40
VideoGalleryRowsPerPage 3 mythtvhost40
VideoGallerySubtitle 1 mythtvhost40
VideoGalleryAspectRatio 1 mythtvhost40
VideoDefaultPlayer mplayer -fs -zoom -quiet -vo xv %s mythtvhost40
TVVidModeRefreshRate 0 mythtvhost40
TVVidModeRefreshRate0 0 mythtvhost40
TVVidModeRefreshRate1 0 mythtvhost40
TVVidModeRefreshRate2 0 mythtvhost40
GalleryRecursiveSlideshow 1 mythtvhost40
GameAllTreeLevels system gamename mythtvhost40
GameFavTreeLevels gamename mythtvhost40
WebBrowserZoomLevel 20 mythtvhost40
WebBrowserCommand /usr/bin/mythbrowser mythtvhost40
WebBrowserScrollMode 1 mythtvhost40
WebBrowserScrollSpeed 4 mythtvhost40
WebBrowserHideScrollbars 0 mythtvhost40
SIUnits NO mythtvhost40
UseXvMcVld 0 mythtvhost40
Language EN mythtvhost40
locale 32080 mythtvhost40
ISO639Language0 eng mythtvhost40
ISO639Language1 eng mythtvhost40
WebDBSchemaVer 1 NULL

_________________
R7.3: 0.22.20091023-1, Hauppauge PVR-500 (Philips FQ1236A MK4), Gigabyte Gigabyte EG45M-UD2H, E5200 2.4Ghz, 2GB RAM, NVIDIA GEFORCE 256MB


Top
 Profile  
 
 Post subject:
PostPosted: Fri May 18, 2007 3:09 pm 
Offline
Joined: Wed Nov 16, 2005 8:55 pm
Posts: 1381
Location: Farmington, MI USA
gatorback wrote:
I did configure a channel lineup using labs.zap2it.com. I also mapped each tuner to the channel lineup in the 'Input Connections' menu. In addition a scan for channels was performed.
Just re-read this. As you are using an analog tuner (PVR-500), you do not want to scan for channels, it can muck up your database. I would remove the tuners in mythtv-setup and recreate them, as well as the Inputs.

gatorback wrote:
Excellent postings: The two latest snippets were effective at demonstrating mySQL queries. I captured the output below.
Yikes! No need to post the output, it was intended to verify whether you were able to query the database, and if anything was in the program table.


Top
 Profile  
 

Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 19 posts ] 
Go to page 1, 2  Next



All times are UTC - 6 hours




Who is online

Users browsing this forum: No registered users and 9 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:  
Powered by phpBB® Forum Software © phpBB Group

Theme Created By ceyhansuyu