View unanswered posts    View active topics

Board index Linux MythTV

All times are UTC - 6 hours





Post new topic Reply to topic  Page 2 of 4
  [ 56 posts ] 
Go to page Previous  1, 2, 3, 4  Next
Print view Previous topic   Next topic  
Author Message
Search for:
nigelpearson
 Post subject:
PostPosted: Sun Jan 23, 2005 11:24 pm 
Offline
Joined: Wed Mar 03, 2004 7:43 pm
Posts: 748
Location: Sydney, Australia
sammo2828 wrote:
1) How do I see what's in the mythtv database?
2) How do I flush or reset it to make sure there is no corrupt data?
3) Do I need to restart mythtv backend?
4) How do I check if the backend is running properly?

4) Where does mythtv store the channel information?
5) Can I edit the channel information file directly?
6) Can I convert my channels.conf file generated by scan util in dvb-apps into one that mythtv can use?


1) mysql -u root mythconverg
select * from channel;

To show what tables are in the database:

mysql> show tables;


2) mysql
mysql -u root mythconverg < /usr/local/share/knoppmyth/drop.sql
mysqladmin -u root create $DATABASE


3) Often :-)


4) In this MySQL database


5) Only with an SQL database editor. I use a graphical editor on my Mac sometimes.


6) Yes, using the channels.conf-import.pl script I described earlier

_________________
| Nigel Pearson, nigel.pearson.au@gmail.com
| "Things you own end up owning you" - Tyler, Fight Club
Top
 Profile  
 
sammo2828
 Post subject:
PostPosted: Sun Jan 23, 2005 11:32 pm 
Offline
Joined: Sat Sep 18, 2004 9:07 pm
Posts: 94
Okay, this has cleared things up heaps for me .. thanks :)

Now the thing I'm still confused about is the Video Source and Input sections of mythtv-setup. In Video Source, I have just created a new one with any name (I called it "NineMSN"). I'm guessing it automatically uses tv_grab_au if Australia is selected? In Video Input, do I just link the DVB cards to "NineMSN"?

Ummm, if I use that channels.conf-import.pl script, do I even need to go into mythtv-setup at all?
Top
 Profile  
 
nigelpearson
 Post subject:
PostPosted: Sun Jan 23, 2005 11:41 pm 
Offline
Joined: Wed Mar 03, 2004 7:43 pm
Posts: 748
Location: Sydney, Australia
sammo2828 wrote:
Now the thing I'm still confused about is the Video Source and Input sections of mythtv-setup. In Video Source, I have just created a new one with any name (I called it "NineMSN"). I'm guessing it automatically uses tv_grab_au if Australia is selected? In Video Input, do I just link the DVB cards to "NineMSN"?


Correct on both counts.

sammo2828 wrote:
Ummm, if I use that channels.conf-import.pl script, do I even need to go into mythtv-setup at all?


Yes. You might need to configure the machine's IP address to that other Myth boxes (frontend only machines) can use it. You need to add your Video Input cards, and connect them to a Video Source.

All that script does is saves you having to enter in frequencies and PIDs for channels that have been defined in the database (by setup, or mythfilldatabase --manual)

_________________
| Nigel Pearson, nigel.pearson.au@gmail.com
| "Things you own end up owning you" - Tyler, Fight Club
Top
 Profile  
 
sammo2828
 Post subject:
PostPosted: Mon Jan 24, 2005 4:56 am 
Offline
Joined: Sat Sep 18, 2004 9:07 pm
Posts: 94
Hi Nigel,

I found your channels.conf-import.pl script at http://cvs.mythtv.org/cgi-bin/viewcvs.c ... v/contrib/
Top
 Profile  
 
sammo2828
 Post subject:
PostPosted: Mon Jan 24, 2005 5:28 am 
Offline
Joined: Sat Sep 18, 2004 9:07 pm
Posts: 94
What is XMLTVID_URL?
Top
 Profile  
 
Greg Frost
 Post subject:
PostPosted: Mon Jan 24, 2005 5:42 am 
Offline
Joined: Mon May 10, 2004 8:08 pm
Posts: 1891
Location: Adelaide, Australia
Heres the code I use to set the channels up in the database. It's specific to Adelaide foothills but you can get the drift. I used this because the tv_grab_au path was not an option for me (my box is not networked).
Code:
  echo "INSERT INTO channel VALUES (1000,'2','64',1,'ABC 2','ABC TV Adelaide','/usr/share/icons/2.gif',NULL,'','593.dvb.guide',0,32768,32768,32768,32768,'Default',0,1,'');" | mysql mythconverg
  echo "INSERT INTO channel VALUES (1001,'7','57',1,'ADS 7','7 Digital','/usr/share/icons/7.gif',NULL,'','1360.dvb.guide',0,32768,32768,32768,32768,'Default',0,1,'');" | mysql mythconverg
  echo "INSERT INTO channel VALUES (1002,'9','66',1,'NWS 9','NINE Digital','/usr/share/icons/9.gif',NULL,'','1105.dvb.guide',0,32768,32768,32768,32768,'Default',0,1,'');" | mysql mythconverg
  echo "INSERT INTO channel VALUES (1003,'10','54',1,'ADS 10','TEN Digital','/usr/share/icons/10.gif',NULL,'','1617.dvb.guide',0,32768,32768,32768,32768,'Default',0,1,'');" | mysql mythconverg
  echo "INSERT INTO channel VALUES (1004,'28','61',1,'SBS 28','SBS Digital','/usr/share/icons/28.gif',NULL,'','833.dvb.guide',0,32768,32768,32768,32768,'Default',0,1,'');" | mysql mythconverg

  echo "INSERT INTO dvb_channel VALUES (1000,NULL,NULL,NULL,NULL,781625000,'a',NULL,'auto','h',0,'auto','7','auto','8','1/16','a',NULL);" | mysql mythconverg
  echo "INSERT INTO dvb_channel VALUES (1001,NULL,NULL,NULL,NULL,732500000,'a',NULL,'auto','h',0,'auto','7','auto','8','1/8','a',NULL);" | mysql mythconverg
  echo "INSERT INTO dvb_channel VALUES (1002,NULL,NULL,NULL,NULL,795500000,'a',NULL,'auto','h',0,'auto','7','auto','8','1/16','a',NULL);" | mysql mythconverg
  echo "INSERT INTO dvb_channel VALUES (1003,NULL,NULL,NULL,NULL,711500000,'a',NULL,'auto','h',0,'auto','7','auto','8','1/16','a',NULL);" | mysql mythconverg
  echo "INSERT INTO dvb_channel VALUES (1004,NULL,NULL,NULL,NULL,760625000,'a',NULL,'auto','h',0,'auto','7','auto','8','1/8','a',NULL);" | mysql mythconverg

  echo "INSERT INTO dvb_pids VALUES (1000,512,'v','');" | mysql mythconverg
  echo "INSERT INTO dvb_pids VALUES (1000,650,'a','');" | mysql mythconverg
  echo "INSERT INTO dvb_pids VALUES (1001,1281,'v','');" | mysql mythconverg
  echo "INSERT INTO dvb_pids VALUES (1001,1282,'a','');" | mysql mythconverg
  echo "INSERT INTO dvb_pids VALUES (1002,512,'v','');" | mysql mythconverg
  echo "INSERT INTO dvb_pids VALUES (1002,650,'a','');" | mysql mythconverg
  echo "INSERT INTO dvb_pids VALUES (1003,512,'v','');" | mysql mythconverg
  echo "INSERT INTO dvb_pids VALUES (1003,650,'a','');" | mysql mythconverg
  echo "INSERT INTO dvb_pids VALUES (1004,161,'v','');" | mysql mythconverg
  echo "INSERT INTO dvb_pids VALUES (1004,81,'a','');" | mysql mythconverg
Top
 Profile  
 
sammo2828
 Post subject:
PostPosted: Mon Jan 24, 2005 6:22 am 
Offline
Joined: Sat Sep 18, 2004 9:07 pm
Posts: 94
Problem. I got tv_grab_au and copied it to /usr/bin.

When I run mythfilldatabase --manual, it says:

Code:
###
### Running in manual channel configuration mode.
### This will ask you questions about every channel
###
--------------------Start of XMLTV output ------------------------
grabing Sydney freesd for 7 days into /tmp/mythw0Jqzb
starting 5 threads
loading queue
23012005 downloading
24012005 downloading
25012005 downloading
26012005 downloading
27012005 downloading
28012005 downloading
29012005 downloading
30012005 downloading
queue is complete

After this, it stays there without any messages.

When I press control-c, it says:
Code:
-------------------- End of XMLTV output -----------------------
Error in 1:1: unexpected end of file
Updating icons for sourceid: 1
Failed to fetch some program info
sh-2.05b$

Any ideas?
Top
 Profile  
 
jbman
 Post subject:
PostPosted: Mon Jan 24, 2005 6:40 am 
yeh now leave it while it grabs the data from the site.

it will take a while depending on your connection
Top
  
 
sammo2828
 Post subject:
PostPosted: Mon Jan 24, 2005 6:48 am 
Offline
Joined: Sat Sep 18, 2004 9:07 pm
Posts: 94
Okay, I'll try again.

Why does it say "queue is complete" if it hasn't completed?

It does take a while .. so much that i was wondering if i should just go to sleep .. well, it finally finished, and now i have another problem (see next msg)


Last edited by sammo2828 on Mon Jan 24, 2005 8:34 am, edited 1 time in total.
Top
 Profile  
 
sammo2828
 Post subject:
PostPosted: Mon Jan 24, 2005 7:09 am 
Offline
Joined: Sat Sep 18, 2004 9:07 pm
Posts: 94
Code:
###
### New channel found
###
### name       = SBS Sydney
### callsign  =
### channum  =
### finetune  =
### tvformat  =
### icon         =
###
Choose a channel ID (positive integer)
Choose a channel name (any string, long version)
Choose a channel callsign (any string, short version)
Choose a channel number (just like xawtv)
Choose a channel fine tune offset (just like xawtv)
Choose a TV format (PAL/SECAM/NSTSC/ATSC/Default)
Choose a channel icon image (any path name)
I entered default values for everything ..
Code:
...
Unknown xmltv channel identifier:  freesd.Sydney.10.d1.com.au
Skipping channel.
Unknown xmltv channel identifier:  freesd.Sydney.2.d1.com.au
Skipping channel.
etc...
Looks like something is wrong here
Top
 Profile  
 
sammo2828
 Post subject:
PostPosted: Mon Jan 24, 2005 7:17 am 
Offline
Joined: Sat Sep 18, 2004 9:07 pm
Posts: 94
Tried running channels.conf-import.pl
It just exits without saying anything, presumably because there is no channel data in the database??
Top
 Profile  
 
sammo2828
 Post subject:
PostPosted: Mon Jan 24, 2005 8:47 am 
Offline
Joined: Sat Sep 18, 2004 9:07 pm
Posts: 94
okay, now i'm pissed off :x
Top
 Profile  
 
sammo2828
 Post subject:
PostPosted: Mon Jan 24, 2005 3:13 pm 
Offline
Joined: Sat Sep 18, 2004 9:07 pm
Posts: 94
sammo2828 wrote:
Code:
...
Unknown xmltv channel identifier:  freesd.Sydney.10.d1.com.au
Skipping channel.
Unknown xmltv channel identifier:  freesd.Sydney.2.d1.com.au
Skipping channel.
etc...
Looks like something is wrong here
Looks like somebody in Switzerland was having the same problem last night. Here is the link http://mysettopbox.tv/phpBB2/viewtopic. ... 8355#18355

I haven't tested it, but it sounds like it may work
Top
 Profile  
 
nigelpearson
 Post subject:
PostPosted: Tue Jan 25, 2005 9:22 am 
Offline
Joined: Wed Mar 03, 2004 7:43 pm
Posts: 748
Location: Sydney, Australia
sammo2828 wrote:
Problem. I got tv_grab_au and copied it to /usr/bin.

When I run mythfilldatabase --manual, it says:

Code:
###
### Running in manual channel configuration mode.
### This will ask you questions about every channel
###
--------------------Start of XMLTV output ------------------------
grabing Sydney freesd for 7 days into /tmp/mythw0Jqzb
starting 5 threads
loading queue
23012005 downloading
24012005 downloading
25012005 downloading
26012005 downloading
27012005 downloading
28012005 downloading
29012005 downloading
30012005 downloading
queue is complete

After this, it stays there without any messages.


That tv_grab_au script generates a file /usr/local/tv_grab_au/guide.xml instead of what mythfilldatabase expects (a tv_grab_au which outputs its data to the standard output).

You can either grab the other tv_grab_au script (I think from www.onlinetractorparts.com.au), or modify your current one so that it prints the data as it writes it to that file.

_________________
| Nigel Pearson, nigel.pearson.au@gmail.com
| "Things you own end up owning you" - Tyler, Fight Club
Top
 Profile  
 
sammo2828
 Post subject:
PostPosted: Tue Jan 25, 2005 9:32 am 
Offline
Joined: Sat Sep 18, 2004 9:07 pm
Posts: 94
sammo2828 wrote:
Looks like somebody in Switzerland was having the same problem last night. Here is the link http://mysettopbox.tv/phpBB2/viewtopic. ... 8355#18355

I haven't tested it, but it sounds like it may work

Yes, it works. I had to:

Code:
apt-get install xmltv


I did not use the onlinetractorparts tv_grab_au script. Instead, I used this one: http://users.on.net/~manser/dvb/tv_grab_au

The only thing I had to change was to add a line for "SBS News" in the Sydney section. This is because the NineMSN guide has "SBS Sydney" as well as "SBS News".

After running mythfilldatabase --manual without errors, I proceeded to run the channels.conf-import.pl file from http://cvs.mythtv.org/cgi-bin/viewcvs.c ... v/contrib/ without errors :)
Top
 Profile  
 

Display posts from previous:  Sort by  
Post new topic Reply to topic  Page 2 of 4
  [ 56 posts ] 
Go to page Previous  1, 2, 3, 4  Next


Board index Linux MythTV

All times are UTC - 6 hours




Who is online

Users browsing this forum: No registered users and 121 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