Mailing List Archive: MythTV: Users

troubles with xmltv and mythfilldatabase

Index | Next | Previous | View Threaded

michael.messner_edv at inode

Oct 31, 2004, 4:18 AM

Post #1 of 19 (2115 views)
Permalink

troubles with xmltv and mythfilldatabase

Hello,

now I've tried to get the TV-guide working on mythTV (without a
TV-card).

tv_grab_de_tvtoday --config-file /root/.mythtv/channel.xmltv
--output ~/.mythtv/listings.xml

getting list of channels:
##################################################
grabbing: ##################################################

/usr/local/bin/mythfilldatabase --file 1 0 ~/.mythtv/listings.xml

### bypassing grabbers, reading directly from file
Query was:
SELECT channum FROM channel WHERE chanid = 1000;
No error type from QSqlError? Strange...
Query was:
SELECT channum FROM channel WHERE chanid = 1000;
No error type from QSqlError? Strange...
Query was:
SELECT channum FROM channel WHERE chanid = 1000;
No error type from QSqlError? Strange...
......

is there any mistake from me?
anybody knows whats going wrong there?

thanks and cu mIke

--
"Der Computer ist die logische Weiterentwicklung des Menschen:
Intelligenz ohne Moral."
John Osborne, engl. Dramatiker

michael.messner_edv at inode

Nov 1, 2004, 2:59 AM

Post #2 of 19 (2105 views)
Permalink

Re: troubles with xmltv and mythfilldatabase [In reply to]

Hello,

nobody an idea whats going wrong?

mfg mIke

Am Sonntag, 31. Oktober 2004 13:18 schrieb Michael Messner:
> Hello,
>
> now I've tried to get the TV-guide working on mythTV (without a
> TV-card).
>
> tv_grab_de_tvtoday --config-file /root/.mythtv/channel.xmltv
> --output ~/.mythtv/listings.xml
>
> getting list of channels:
> ##################################################
> grabbing: ##################################################
>
> /usr/local/bin/mythfilldatabase --file 1 0
> ~/.mythtv/listings.xml
>
> ### bypassing grabbers, reading directly from file
> Query was:
> SELECT channum FROM channel WHERE chanid = 1000;
> No error type from QSqlError? Strange...
> Query was:
> SELECT channum FROM channel WHERE chanid = 1000;
> No error type from QSqlError? Strange...
> Query was:
> SELECT channum FROM channel WHERE chanid = 1000;
> No error type from QSqlError? Strange...
> ......
>
> is there any mistake from me?
> anybody knows whats going wrong there?
>
> thanks and cu mIke

--
Selflinux
http://www.selflinux.org/portal/

ryszard99 at gmail

Nov 1, 2004, 4:08 AM

Post #3 of 19 (2104 views)
Permalink

Re: troubles with xmltv and mythfilldatabase [In reply to]

did you log onto mysql and do a select on the channel table? i'm not
an expert but it looks like the 1st place to start looking.

On Mon, 1 Nov 2004 12:59:56 +0200, Michael Messner
<michael.messner_edv [at] inode> wrote:
> Hello,
>
> nobody an idea whats going wrong?
>
> mfg mIke
>
> Am Sonntag, 31. Oktober 2004 13:18 schrieb Michael Messner:
>
>
> > Hello,
> >
> > now I've tried to get the TV-guide working on mythTV (without a
> > TV-card).
> >
> > tv_grab_de_tvtoday --config-file /root/.mythtv/channel.xmltv
> > --output ~/.mythtv/listings.xml
> >
> > getting list of channels:
> > ##################################################
> > grabbing: ##################################################
> >
> > /usr/local/bin/mythfilldatabase --file 1 0
> > ~/.mythtv/listings.xml
> >
> > ### bypassing grabbers, reading directly from file
> > Query was:
> > SELECT channum FROM channel WHERE chanid = 1000;
> > No error type from QSqlError? Strange...
> > Query was:
> > SELECT channum FROM channel WHERE chanid = 1000;
> > No error type from QSqlError? Strange...
> > Query was:
> > SELECT channum FROM channel WHERE chanid = 1000;
> > No error type from QSqlError? Strange...
> > ......
> >
> > is there any mistake from me?
> > anybody knows whats going wrong there?
> >
> > thanks and cu mIke
>
> --
> Selflinux
> http://www.selflinux.org/portal/
>
>
> _______________________________________________
> mythtv-users mailing list
> mythtv-users [at] mythtv
> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
>
>
>

michael.messner_edv at inode

Nov 1, 2004, 4:28 AM

Post #4 of 19 (2107 views)
Permalink

Re: troubles with xmltv and mythfilldatabase [In reply to]

Hi,

Am Montag, 1. November 2004 13:08 schrieb Ryszard:
> did you log onto mysql and do a select on the channel table?

I'm not a mysql expert so what do you mean with a select on the
channel table?
If I open mysql I can see a complete empty channel table.

cu mIke

> i'm
> not an expert but it looks like the 1st place to start looking.
>
>
> On Mon, 1 Nov 2004 12:59:56 +0200, Michael Messner
>
> <michael.messner_edv [at] inode> wrote:
> > Hello,
> >
> > nobody an idea whats going wrong?
> >
> > mfg mIke
> >
> > Am Sonntag, 31. Oktober 2004 13:18 schrieb Michael Messner:
> > > Hello,
> > >
> > > now I've tried to get the TV-guide working on mythTV
> > > (without a TV-card).
> > >
> > > tv_grab_de_tvtoday --config-file /root/.mythtv/channel.xmltv
> > > --output ~/.mythtv/listings.xml
> > >
> > > getting list of channels:
> > > ##################################################
> > > grabbing: ##################################################
> > >
> > > /usr/local/bin/mythfilldatabase --file 1 0
> > > ~/.mythtv/listings.xml
> > >
> > > ### bypassing grabbers, reading directly from file
> > > Query was:
> > > SELECT channum FROM channel WHERE chanid = 1000;
> > > No error type from QSqlError? Strange...
> > > Query was:
> > > SELECT channum FROM channel WHERE chanid = 1000;
> > > No error type from QSqlError? Strange...
> > > Query was:
> > > SELECT channum FROM channel WHERE chanid = 1000;
> > > No error type from QSqlError? Strange...
> > > ......
> > >
> > > is there any mistake from me?
> > > anybody knows whats going wrong there?
> > >
> > > thanks and cu mIke
> >
> > --
> > Selflinux
> > http://www.selflinux.org/portal/
> >
> >
> > _______________________________________________
> > mythtv-users mailing list
> > mythtv-users [at] mythtv
> > http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users

--
Eine Katze hat einen Schwanz mehr als keine Katze. Keine Katze hat
zwei Schw�nze, also hat eine Katze drei Schw�nze.
[Bernd Brodesser in suse-linux]

nezar.nielsen at gmail

Nov 1, 2004, 4:42 AM

Post #5 of 19 (2114 views)
Permalink

Re: troubles with xmltv and mythfilldatabase [In reply to]

On Mon, 1 Nov 2004 14:28:54 +0200, Michael Messner

> If I open mysql I can see a complete empty channel table.
>

And that is probably your problem.
I had the same thing initially, you have to set up all the
channels(with frequencies and stuff) via the setup program before you
try to load up program listings.

--
Nezar Nielsen
http://fez.dk

anders at smiths

Nov 1, 2004, 5:00 AM

Post #6 of 19 (2071 views)
Permalink

Re: troubles with xmltv and mythfilldatabase [In reply to]

mysql > select * from channel;

I seem to remember this will give you everything in the channel table
anders

----- Original Message -----
From: "Michael Messner" <michael.messner_edv [at] inode>
To: <mythtv-users [at] mythtv>
Sent: Monday, November 01, 2004 1:28 PM
Subject: Re: [mythtv-users] troubles with xmltv and mythfilldatabase

Hi,

Am Montag, 1. November 2004 13:08 schrieb Ryszard:
> did you log onto mysql and do a select on the channel table?

I'm not a mysql expert so what do you mean with a select on the
channel table?
If I open mysql I can see a complete empty channel table.

cu mIke

> i'm
> not an expert but it looks like the 1st place to start looking.
>
>
> On Mon, 1 Nov 2004 12:59:56 +0200, Michael Messner
>
> <michael.messner_edv [at] inode> wrote:
> > Hello,
> >
> > nobody an idea whats going wrong?
> >
> > mfg mIke
> >
> > Am Sonntag, 31. Oktober 2004 13:18 schrieb Michael Messner:
> > > Hello,
> > >
> > > now I've tried to get the TV-guide working on mythTV
> > > (without a TV-card).
> > >
> > > tv_grab_de_tvtoday --config-file /root/.mythtv/channel.xmltv
> > > --output ~/.mythtv/listings.xml
> > >
> > > getting list of channels:
> > > ##################################################
> > > grabbing: ##################################################
> > >
> > > /usr/local/bin/mythfilldatabase --file 1 0
> > > ~/.mythtv/listings.xml
> > >
> > > ### bypassing grabbers, reading directly from file
> > > Query was:
> > > SELECT channum FROM channel WHERE chanid = 1000;
> > > No error type from QSqlError? Strange...
> > > Query was:
> > > SELECT channum FROM channel WHERE chanid = 1000;
> > > No error type from QSqlError? Strange...
> > > Query was:
> > > SELECT channum FROM channel WHERE chanid = 1000;
> > > No error type from QSqlError? Strange...
> > > ......
> > >
> > > is there any mistake from me?
> > > anybody knows whats going wrong there?
> > >
> > > thanks and cu mIke
> >
> > --
> > Selflinux
> > http://www.selflinux.org/portal/
> >
> >
> > _______________________________________________
> > mythtv-users mailing list
> > mythtv-users [at] mythtv
> > http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users

--
Eine Katze hat einen Schwanz mehr als keine Katze. Keine Katze hat
zwei Schw�nze, also hat eine Katze drei Schw�nze.
[Bernd Brodesser in suse-linux]

----------------------------------------------------------------------------
----

_______________________________________________
mythtv-users mailing list
mythtv-users [at] mythtv
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users

jman at neonramp

Nov 1, 2004, 5:04 AM

Post #7 of 19 (2102 views)
Permalink

Re: troubles with xmltv and mythfilldatabase [In reply to]

Nezar Nielsen wrote ..
> On Mon, 1 Nov 2004 14:28:54 +0200, Michael Messner
>
> > If I open mysql I can see a complete empty channel table.
> >
>
> And that is probably your problem.
> I had the same thing initially, you have to set up all the
> channels(with frequencies and stuff) via the setup program before you
> try to load up program listings.
>
> --
> Nezar Nielsen
> http://fez.dk
In doing this, how is the channel guide displayed? In hour segments? Half hour?

John

michael.messner_edv at inode

Nov 1, 2004, 3:35 PM

Post #8 of 19 (2083 views)
Permalink

Re: troubles with xmltv and mythfilldatabase [In reply to]

Am Montag, 1. November 2004 13:42 schrieb Nezar Nielsen:
> On Mon, 1 Nov 2004 14:28:54 +0200, Michael Messner
>
> > If I open mysql I can see a complete empty channel table.
>
> And that is probably your problem.
> I had the same thing initially, you have to set up all the
> channels(with frequencies and stuff) via the setup program before
> you try to load up program listings.

do I really need the frequencies and so on also? I don't have a TV
card!
Now I've some input in my mysql table, the channel name and the
xmltv ID but:

23:55:35 linuxmike /reserve/ltsp/i386/etc [root]tv_grab_de_tvtoday
--config-file /root/.mythtv/tv_grab_de_tvtoday.conf
| /usr/local/bin/mythfilldatabase --update --file 1 -1 -
### bypassing grabbers, reading directly from file
getting list of channels:
##################################################
grabbing: ##################################################
Updating icons for sourceid: 1
Unknown xmltv channel identifier: C1.orf.at
Skipping channel.
Unknown xmltv channel identifier: C2.orf.at
Skipping channel.
Unknown xmltv channel identifier: C3.br-online.de
Skipping channel.
....

but whats really the ID? Is it as example C1.orf.at like you see
above or is it from the ~/.mythtv/tv_grab_de_tvtoday.conf file
channel ORF%201 #ORF 1
ORF%201?

I've tried both possiblities in the setup but the output is
everytime the same!

hope for any more helping
cu mIke

--
> Ich brauche
> produktive Systeme. Kein so ein Gefrickel!

OK; Windows verwendtest Du also auch nicht. Bist Du ein Apple User?

phill_edwards at hotmail

Nov 1, 2004, 4:29 PM

Post #9 of 19 (2087 views)
Permalink

Re: troubles with xmltv and mythfilldatabase [In reply to]

You have set your channels up, haven't you? If you haven't then I think the
mythfilldatabase may be failing because it's trying to put entries into the
program guide for channels that it doesn't know about. I believe that if
you're outside US you may need go into the setup screens in mythtsetup or
mythfrontend (can't remember which one) and enter them manually. You'll need
to know which channel number they broadcast on so that it can tune to the
right frequency. Then when you run mythfilldatabase it should work OK.

Also, it could be that the program guide has actually loaded and it's just
spitting out some warnings. That happened to me - I got lots of errors but
when I looked at the program guide it was all there as it should be.

Regards,
Phill

>From: Michael Messner <michael.messner_edv [at] inode>
>Reply-To: Discussion about mythtv <mythtv-users [at] mythtv>
>To: mythtv-users [at] mythtv
>Subject: Re: [mythtv-users] troubles with xmltv and mythfilldatabase
>Date: Mon, 1 Nov 2004 12:59:56 +0200
>
>Hello,
>
> nobody an idea whats going wrong?
>
>mfg mIke
>
>
>Am Sonntag, 31. Oktober 2004 13:18 schrieb Michael Messner:
> > Hello,
> >
> > now I've tried to get the TV-guide working on mythTV (without a
> > TV-card).
> >
> > tv_grab_de_tvtoday --config-file /root/.mythtv/channel.xmltv
> > --output ~/.mythtv/listings.xml
> >
> > getting list of channels:
> > ##################################################
> > grabbing: ##################################################
> >
> > /usr/local/bin/mythfilldatabase --file 1 0
> > ~/.mythtv/listings.xml
> >
> > ### bypassing grabbers, reading directly from file
> > Query was:
> > SELECT channum FROM channel WHERE chanid = 1000;
> > No error type from QSqlError? Strange...
> > Query was:
> > SELECT channum FROM channel WHERE chanid = 1000;
> > No error type from QSqlError? Strange...
> > Query was:
> > SELECT channum FROM channel WHERE chanid = 1000;
> > No error type from QSqlError? Strange...
> > ......
> >
> > is there any mistake from me?
> > anybody knows whats going wrong there?
> >
> > thanks and cu mIke
>
>--
>Selflinux
>http://www.selflinux.org/portal/
>_______________________________________________
>mythtv-users mailing list
>mythtv-users [at] mythtv
>http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users

phill_edwards at hotmail

Nov 1, 2004, 4:32 PM

Post #10 of 19 (2100 views)
Permalink

Re: troubles with xmltv and mythfilldatabase [In reply to]

Bit more to it than that I think. After logging into mysql you have to
connect to the right database before you can query any tables. I think the
syntax is "connect mythconverg;" or something like that. Find the file
mc.sql and look in there for exact syntax.

Regards,
Phill

>From: "anders smith" <anders [at] smiths>
>Reply-To: Discussion about mythtv <mythtv-users [at] mythtv>
>To: "Discussion about mythtv" <mythtv-users [at] mythtv>
>Subject: Re: [mythtv-users] troubles with xmltv and mythfilldatabase
>Date: Mon, 1 Nov 2004 14:00:05 +0100
>
>mysql > select * from channel;
>
>I seem to remember this will give you everything in the channel table
>anders
>
>----- Original Message -----
>From: "Michael Messner" <michael.messner_edv [at] inode>
>To: <mythtv-users [at] mythtv>
>Sent: Monday, November 01, 2004 1:28 PM
>Subject: Re: [mythtv-users] troubles with xmltv and mythfilldatabase
>
>
>Hi,
>
>Am Montag, 1. November 2004 13:08 schrieb Ryszard:
> > did you log onto mysql and do a select on the channel table?
>
>I'm not a mysql expert so what do you mean with a select on the
>channel table?
>If I open mysql I can see a complete empty channel table.
>
>cu mIke
>
>
> > i'm
> > not an expert but it looks like the 1st place to start looking.
> >
> >
> > On Mon, 1 Nov 2004 12:59:56 +0200, Michael Messner
> >
> > <michael.messner_edv [at] inode> wrote:
> > > Hello,
> > >
> > > nobody an idea whats going wrong?
> > >
> > > mfg mIke
> > >
> > > Am Sonntag, 31. Oktober 2004 13:18 schrieb Michael Messner:
> > > > Hello,
> > > >
> > > > now I've tried to get the TV-guide working on mythTV
> > > > (without a TV-card).
> > > >
> > > > tv_grab_de_tvtoday --config-file /root/.mythtv/channel.xmltv
> > > > --output ~/.mythtv/listings.xml
> > > >
> > > > getting list of channels:
> > > > ##################################################
> > > > grabbing: ##################################################
> > > >
> > > > /usr/local/bin/mythfilldatabase --file 1 0
> > > > ~/.mythtv/listings.xml
> > > >
> > > > ### bypassing grabbers, reading directly from file
> > > > Query was:
> > > > SELECT channum FROM channel WHERE chanid = 1000;
> > > > No error type from QSqlError? Strange...
> > > > Query was:
> > > > SELECT channum FROM channel WHERE chanid = 1000;
> > > > No error type from QSqlError? Strange...
> > > > Query was:
> > > > SELECT channum FROM channel WHERE chanid = 1000;
> > > > No error type from QSqlError? Strange...
> > > > ......
> > > >
> > > > is there any mistake from me?
> > > > anybody knows whats going wrong there?
> > > >
> > > > thanks and cu mIke
> > >
> > > --
> > > Selflinux
> > > http://www.selflinux.org/portal/
> > >
> > >
> > > _______________________________________________
> > > mythtv-users mailing list
> > > mythtv-users [at] mythtv
> > > http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
>
>--
>Eine Katze hat einen Schwanz mehr als keine Katze. Keine Katze hat
>zwei Schw�nze, also hat eine Katze drei Schw�nze.
>[Bernd Brodesser in suse-linux]
>
>
>
>----------------------------------------------------------------------------
>----
>
>
>_______________________________________________
>mythtv-users mailing list
>mythtv-users [at] mythtv
>http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
>
>_______________________________________________
>mythtv-users mailing list
>mythtv-users [at] mythtv
>http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users

phill_edwards at hotmail

Nov 1, 2004, 4:36 PM

Post #11 of 19 (2101 views)
Permalink

Re: troubles with xmltv and mythfilldatabase [In reply to]

For me in Australia the channel IDs were things like
free.Sydney.9.d1.com.au, free.Sydney.ABC.d1.com.au - I think it therefore
depends on who's providing your program guide data. For me it's d1.com.au.

You're going to find this heavy going, though, if you don't have a TV card -
you really need that to verify along the way that everything's working.

Regards,
Phill

>From: Michael Messner <michael.messner_edv [at] inode>
>Reply-To: Discussion about mythtv <mythtv-users [at] mythtv>
>To: mythtv-users [at] mythtv
>Subject: Re: [mythtv-users] troubles with xmltv and mythfilldatabase
>Date: Tue, 2 Nov 2004 01:35:08 +0200
>
>Am Montag, 1. November 2004 13:42 schrieb Nezar Nielsen:
> > On Mon, 1 Nov 2004 14:28:54 +0200, Michael Messner
> >
> > > If I open mysql I can see a complete empty channel table.
> >
> > And that is probably your problem.
> > I had the same thing initially, you have to set up all the
> > channels(with frequencies and stuff) via the setup program before
> > you try to load up program listings.
>
>do I really need the frequencies and so on also? I don't have a TV
>card!
>Now I've some input in my mysql table, the channel name and the
>xmltv ID but:
>
>23:55:35 linuxmike /reserve/ltsp/i386/etc [root]tv_grab_de_tvtoday
>--config-file /root/.mythtv/tv_grab_de_tvtoday.conf
>| /usr/local/bin/mythfilldatabase --update --file 1 -1 -
>### bypassing grabbers, reading directly from file
>getting list of channels:
>##################################################
>grabbing: ##################################################
>Updating icons for sourceid: 1
>Unknown xmltv channel identifier: C1.orf.at
>Skipping channel.
>Unknown xmltv channel identifier: C2.orf.at
>Skipping channel.
>Unknown xmltv channel identifier: C3.br-online.de
>Skipping channel.
>....
>
>but whats really the ID? Is it as example C1.orf.at like you see
>above or is it from the ~/.mythtv/tv_grab_de_tvtoday.conf file
> channel ORF%201 #ORF 1
>ORF%201?
>
>I've tried both possiblities in the setup but the output is
>everytime the same!
>
>hope for any more helping
>cu mIke
>
>--
> > Ich brauche
> > produktive Systeme. Kein so ein Gefrickel!
>
>OK; Windows verwendtest Du also auch nicht. Bist Du ein Apple User?
>_______________________________________________
>mythtv-users mailing list
>mythtv-users [at] mythtv
>http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users

nezar.nielsen at gmail

Nov 2, 2004, 2:02 AM

Post #12 of 19 (2096 views)
Permalink

Re: troubles with xmltv and mythfilldatabase [In reply to]

On Tue, 2 Nov 2004 01:35:08 +0200, Michael Messner wrote:
> do I really need the frequencies and so on also? I don't have a TV
> card!

I don't think you *need* the frequencies if you have no use for them,

> Now I've some input in my mysql table, the channel name and the
> xmltv ID but:
...
> Updating icons for sourceid: 1
> Unknown xmltv channel identifier: C1.orf.at

And you did put C1.orf.at as the XMLTV-id for the channel?
As someone else said, you'll get this kind of error for each channel
that you haven't set up in the channel-list, but this doesn't
specifically say that you don't get ANY program data stored at all,
just not for the channels it's complaining about.

--
Mvh. Nezar Nielsen
http://fez.dk

anders at smiths

Nov 2, 2004, 2:58 AM

Post #13 of 19 (2095 views)
Permalink

Re: troubles with xmltv and mythfilldatabase [In reply to]

I've seen lots of the same errors and have still gotten data in the
database....it's quite puzzling.

I've tried running the grabber by it self and output to a file and then run
mythfildatabase on that file and I get eorrs while generating the file and
while importing it in the database, but still get data in the database......

I'm still investigating, but have no clues so far. Channels have been setup
and the indentifiers are there in the database format '142.tv.tv2.dk', while
in the tv2.xmltv file it's 'channel 142 tv.tv2.dk'

rgds
anders

----- Original Message -----
From: "Nezar Nielsen" <nezar.nielsen [at] gmail>
To: "Discussion about mythtv" <mythtv-users [at] mythtv>
Sent: Tuesday, November 02, 2004 11:02 AM
Subject: Re: [mythtv-users] troubles with xmltv and mythfilldatabase

> On Tue, 2 Nov 2004 01:35:08 +0200, Michael Messner wrote:
> > do I really need the frequencies and so on also? I don't have a TV
> > card!
>
> I don't think you *need* the frequencies if you have no use for them,
>
> > Now I've some input in my mysql table, the channel name and the
> > xmltv ID but:
> ...
> > Updating icons for sourceid: 1
> > Unknown xmltv channel identifier: C1.orf.at
>
> And you did put C1.orf.at as the XMLTV-id for the channel?
> As someone else said, you'll get this kind of error for each channel
> that you haven't set up in the channel-list, but this doesn't
> specifically say that you don't get ANY program data stored at all,
> just not for the channels it's complaining about.
>
> --
> Mvh. Nezar Nielsen
> http://fez.dk
>

----------------------------------------------------------------------------
----

_______________________________________________
mythtv-users mailing list
mythtv-users [at] mythtv
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users

_______________________________________________
mythtv-users mailing list
mythtv-users [at] mythtv
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users

michael.messner_edv at inode

Nov 2, 2004, 7:58 AM

Post #14 of 19 (2064 views)
Permalink

Re: troubles with xmltv and mythfilldatabase [In reply to]

hello,

Am Dienstag, 2. November 2004 00:35 schrieb Michael Messner:
> Am Montag, 1. November 2004 13:42 schrieb Nezar Nielsen:
> > On Mon, 1 Nov 2004 14:28:54 +0200, Michael Messner
> >
> > > If I open mysql I can see a complete empty channel table.
> >
> > And that is probably your problem.
> > I had the same thing initially, you have to set up all the
> > channels(with frequencies and stuff) via the setup program
> > before you try to load up program listings.

So, now I can see my channels with the IDs in the mysql db and also
in mythweb and I can see the names of the channels in the
mythfrontend (but no guide). If I try to update the database:

14:45:29 linuxmike /srv/www/htdocs/myLTSPtv/en
[root]tv_grab_de_tvtoday
--config-file /root/.xmltv/tv_grab_de_tvtoday.conf
| /usr/local/bin/mythfilldatabase --update --file 1 -1 -
.....
--15:24:25--
http://www.tvtoday.de/tv/programm/bilder/senderlogos/3sat.gif
=> `3sat.gif'
Resolving www.tvtoday.de... done.
Connecting to www.tvtoday.de[194.12.210.36]:80... connected.
HTTP request sent, awaiting response... 200 OK
Length: 396 [image/gif]

100%[====================================>] 396 386.72K/s
ETA 00:00

15:24:25 (386.72 KB/s) - `3sat.gif' saved [396/396]
....
Updating icons for sourceid: 1
Unknown xmltv channel identifier: C1.orf.at
Skipping channel.
Unknown xmltv channel identifier: C2.orf.at
Skipping channel.
Unknown xmltv channel identifier: C2.sfdrs.ch
Skipping channel.
Unknown xmltv channel identifier: C3.br-online.de
Skipping channel.
Unknown xmltv channel identifier: C3sat.de
Skipping channel.
....

the same errors like before.

16:55:45 linuxmike /srv/www/htdocs/myLTSPtv/en [root]ls ~/.xmltv/
. .. tv_grab_de_tvtoday.conf

16:55:58 linuxmike /srv/www/htdocs/myLTSPtv/en [root]ls ~/.mythtv/
. MythNews MythWeather channels mythstream
tv_grab_de_tvtoday.conf
.. MythVideo lircrc themecache

16:56:02 linuxmike /srv/www/htdocs/myLTSPtv/en [root]ls
~/.mythtv/channels/
. bbc_world.gif kabel1.gif orf1.gif sf2.gif
zdf.gif
.. cnn.gif kinderkanal.gif orf2.gif tele5.gif
3sat.gif dsf.gif mtv.gif pro7.gif viva.gif
ard.gif euronews.gif mtv2.gif rtl.gif vivaplus.gif
arte.gif eurosport.gif n24.gif rtl2.gif vox.gif
bayern.gif hamburg1.gif ntv.gif sat1.gif west.gif

cu mIke

--
"Die Realit�t begrenzt mich in meinem Recht auf freie Entfaltung!"

nezar.nielsen at gmail

Nov 2, 2004, 8:44 AM

Post #15 of 19 (2087 views)
Permalink

Re: troubles with xmltv and mythfilldatabase [In reply to]

On Tue, 2 Nov 2004 17:58:02 +0200, Michael Messner wrote:

> So, now I can see my channels with the IDs in the mysql db and also
> in mythweb and I can see the names of the channels in the
> mythfrontend (but no guide). If I try to update the database:

And their xmltv-ids in the channels table match with these:

> Unknown xmltv channel identifier: C1.orf.at
> Unknown xmltv channel identifier: C2.orf.at
> Unknown xmltv channel identifier: C2.sfdrs.ch
> Unknown xmltv channel identifier: C3.br-online.de
> Unknown xmltv channel identifier: C3sat.de

?

Then I don't know what could be wrong, I was assuming it was your
xmltv-id's that were wrongly set up in the table..

--
Mvh. Nezar Nielsen
http://fez.dk

zaakiy at nticon

Nov 4, 2004, 3:56 AM

Post #16 of 19 (2087 views)
Permalink

RE: troubles with xmltv and mythfilldatabase [In reply to]

Apologies if someone has already come up with an answer (I'm viewing and responding offline so there will be a delay).

I'm not that experienced with MythTV yet, but I think you have to do the following:

cat root/.xmltv/tv_grab_de_tvtoday.conf

This should list out the XMLTV IDs, like C1.orf.at, etc

Run mythtvsetup

Enter the channel editor.

If your channels are already set up, go into each of them and make sure that the XMLTV id corresponds with what is in the tv_grab_de_tvtoday.conf file (this will populate your channel table).

If channels are not already set up, then set them up and do the same.

If you want to check the settings in your channel table:
use mythconverg;
select * from channel;

Regards,
Zaakiy

-----Original Message-----
From: mythtv-users-bounces [at] mythtv [mailto:mythtv-users-bounces [at] mythtv] On Behalf Of Michael Messner
Sent: Wednesday, 3 November 2004 2:58 AM
To: mythtv-users [at] mythtv
Subject: Re: [mythtv-users] troubles with xmltv and mythfilldatabase

hello,

Am Dienstag, 2. November 2004 00:35 schrieb Michael Messner:
> Am Montag, 1. November 2004 13:42 schrieb Nezar Nielsen:
> > On Mon, 1 Nov 2004 14:28:54 +0200, Michael Messner
> >
> > > If I open mysql I can see a complete empty channel table.
> >
> > And that is probably your problem.
> > I had the same thing initially, you have to set up all the
> > channels(with frequencies and stuff) via the setup program
> > before you try to load up program listings.

So, now I can see my channels with the IDs in the mysql db and also
in mythweb and I can see the names of the channels in the
mythfrontend (but no guide). If I try to update the database:

14:45:29 linuxmike /srv/www/htdocs/myLTSPtv/en
[root]tv_grab_de_tvtoday
--config-file /root/.xmltv/tv_grab_de_tvtoday.conf
| /usr/local/bin/mythfilldatabase --update --file 1 -1 -
.....
--15:24:25--
http://www.tvtoday.de/tv/programm/bilder/senderlogos/3sat.gif
=> `3sat.gif'
Resolving www.tvtoday.de... done.
Connecting to www.tvtoday.de[194.12.210.36]:80... connected.
HTTP request sent, awaiting response... 200 OK
Length: 396 [image/gif]

100%[====================================>] 396 386.72K/s
ETA 00:00

15:24:25 (386.72 KB/s) - `3sat.gif' saved [396/396]
....
Updating icons for sourceid: 1
Unknown xmltv channel identifier: C1.orf.at
Skipping channel.
Unknown xmltv channel identifier: C2.orf.at
Skipping channel.
Unknown xmltv channel identifier: C2.sfdrs.ch
Skipping channel.
Unknown xmltv channel identifier: C3.br-online.de
Skipping channel.
Unknown xmltv channel identifier: C3sat.de
Skipping channel.
....

the same errors like before.

16:55:45 linuxmike /srv/www/htdocs/myLTSPtv/en [root]ls ~/.xmltv/
. .. tv_grab_de_tvtoday.conf

16:55:58 linuxmike /srv/www/htdocs/myLTSPtv/en [root]ls ~/.mythtv/
. MythNews MythWeather channels mythstream
tv_grab_de_tvtoday.conf
.. MythVideo lircrc themecache

16:56:02 linuxmike /srv/www/htdocs/myLTSPtv/en [root]ls
~/.mythtv/channels/
. bbc_world.gif kabel1.gif orf1.gif sf2.gif
zdf.gif
.. cnn.gif kinderkanal.gif orf2.gif tele5.gif
3sat.gif dsf.gif mtv.gif pro7.gif viva.gif
ard.gif euronews.gif mtv2.gif rtl.gif vivaplus.gif
arte.gif eurosport.gif n24.gif rtl2.gif vox.gif
bayern.gif hamburg1.gif ntv.gif sat1.gif west.gif

cu mIke

--
"Die Realit�t begrenzt mich in meinem Recht auf freie Entfaltung!"

_______________________________________________
mythtv-users mailing list
mythtv-users [at] mythtv
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users

michael.messner_edv at inode

Nov 4, 2004, 8:06 AM

Post #17 of 19 (2093 views)
Permalink

Re: troubles with xmltv and mythfilldatabase [In reply to]

Hello,

Am Donnerstag, 4. November 2004 12:56 schrieb Zaakiy Siddiqui:
>
> cat root/.xmltv/tv_grab_de_tvtoday.conf

the file looks like the following:

channel ARD #ARD
channel ARTE #ARTE
channel BAYERN #BAYERN
channel BBCWORLD #BBC World
channel CNN #CNN
.....

>
> This should list out the XMLTV IDs, like C1.orf.at, etc
>
> Run mythtvsetup

I've tried it with C1.orf.at and also with the input from the file
above

cu mIke
>
> Enter the channel editor.
>
> If your channels are already set up, go into each of them and
> make sure that the XMLTV id corresponds with what is in the
> tv_grab_de_tvtoday.conf file (this will populate your channel
> table).
>
> If channels are not already set up, then set them up and do the
> same.
>
> If you want to check the settings in your channel table:
> use mythconverg;
> select * from channel;
>
>
> Regards,
> Zaakiy
>
>
> -----Original Message-----
> From: mythtv-users-bounces [at] mythtv
> [mailto:mythtv-users-bounces [at] mythtv] On Behalf Of Michael
> Messner Sent: Wednesday, 3 November 2004 2:58 AM
> To: mythtv-users [at] mythtv
> Subject: Re: [mythtv-users] troubles with xmltv and
> mythfilldatabase
>
> hello,
>
> Am Dienstag, 2. November 2004 00:35 schrieb Michael Messner:
> > Am Montag, 1. November 2004 13:42 schrieb Nezar Nielsen:
> > > On Mon, 1 Nov 2004 14:28:54 +0200, Michael Messner
> > >
> > > > If I open mysql I can see a complete empty channel table.
> > >
> > > And that is probably your problem.
> > > I had the same thing initially, you have to set up all the
> > > channels(with frequencies and stuff) via the setup program
> > > before you try to load up program listings.
>
> So, now I can see my channels with the IDs in the mysql db and
> also in mythweb and I can see the names of the channels in the
> mythfrontend (but no guide). If I try to update the database:
>
> 14:45:29 linuxmike /srv/www/htdocs/myLTSPtv/en
> [root]tv_grab_de_tvtoday
> --config-file /root/.xmltv/tv_grab_de_tvtoday.conf
>
> | /usr/local/bin/mythfilldatabase --update --file 1 -1 -
>
> .....
> --15:24:25--
> http://www.tvtoday.de/tv/programm/bilder/senderlogos/3sat.gif
> => `3sat.gif'
> Resolving www.tvtoday.de... done.
> Connecting to www.tvtoday.de[194.12.210.36]:80... connected.
> HTTP request sent, awaiting response... 200 OK
> Length: 396 [image/gif]
>
> 100%[====================================>] 396
> 386.72K/s ETA 00:00
>
> 15:24:25 (386.72 KB/s) - `3sat.gif' saved [396/396]
> ....
> Updating icons for sourceid: 1
> Unknown xmltv channel identifier: C1.orf.at
> Skipping channel.
> Unknown xmltv channel identifier: C2.orf.at
> Skipping channel.
> Unknown xmltv channel identifier: C2.sfdrs.ch
> Skipping channel.
> Unknown xmltv channel identifier: C3.br-online.de
> Skipping channel.
> Unknown xmltv channel identifier: C3sat.de
> Skipping channel.
> ....
>
> the same errors like before.
>
> 16:55:45 linuxmike /srv/www/htdocs/myLTSPtv/en [root]ls ~/.xmltv/
> . .. tv_grab_de_tvtoday.conf
>
> 16:55:58 linuxmike /srv/www/htdocs/myLTSPtv/en [root]ls
> ~/.mythtv/ . MythNews MythWeather channels mythstream
> tv_grab_de_tvtoday.conf
> .. MythVideo lircrc themecache
>
> 16:56:02 linuxmike /srv/www/htdocs/myLTSPtv/en [root]ls
> ~/.mythtv/channels/
> . bbc_world.gif kabel1.gif orf1.gif sf2.gif
> zdf.gif
> .. cnn.gif kinderkanal.gif orf2.gif tele5.gif
> 3sat.gif dsf.gif mtv.gif pro7.gif viva.gif
> ard.gif euronews.gif mtv2.gif rtl.gif
> vivaplus.gif arte.gif eurosport.gif n24.gif rtl2.gif
> vox.gif bayern.gif hamburg1.gif ntv.gif sat1.gif
> west.gif
>
> cu mIke

--
> Gibt es Alternativen?

Zu was? Zum Wahnsinn, jederzeit erreichbar zu sein?
_______________________________________________
mythtv-users mailing list
mythtv-users [at] mythtv
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users

hamish at cloud

Nov 16, 2004, 4:38 AM

Post #18 of 19 (2036 views)
Permalink

Re: troubles with xmltv and mythfilldatabase [In reply to]

On Sun, Oct 31, 2004 at 02:18:26PM +0200, Michael Messner wrote:
> now I've tried to get the TV-guide working on mythTV (without a
> TV-card).
>
> tv_grab_de_tvtoday --config-file /root/.mythtv/channel.xmltv
> --output ~/.mythtv/listings.xml
>
> getting list of channels:
> ##################################################
> grabbing: ##################################################
>
> /usr/local/bin/mythfilldatabase --file 1 0 ~/.mythtv/listings.xml

I tried these recently while testing a new grabber. --file didn't seem
to work properly, it always reported errors like what you saw.

When I made the actual grabber just do a cat of the .xml file, it worked
fine. It seemed to be a problem just with --file, not the data or the
configuration.

Hamish
--
Hamish Moffatt VK3SB <hamish [at] debian> <hamish [at] cloud>

dlbrett at zoominternet

Nov 16, 2004, 7:18 PM

Post #19 of 19 (2038 views)
Permalink

Re: troubles with xmltv and mythfilldatabase [In reply to]

Just thought I'd add a little fuel to the fire. Sql commands:

- To enter into the linux mysql client
#mysql -uroot -pyourpassword

or, using the mythtv user and password,

#mysql -umythtv -pmythtv

Once into the client:

- to display databases:
mysql>show databases:

- to switch to a particular database (in this case 'mythconverg'):
mysql>use mythconverg;

- to display all tables in a database:
mysql>show tables;

- to display all contents of all rows of a table (in this case, the
channel table):
mysql>select * from channel;

- to display only selected columns of a table (in this case chanid,
channum, and freqid from the channel table):
mysql>select chanid, channum, freqid from channel;

Or, you can get the MySql-Front query analyzer client. It's allot more
useful.

http://www.mysql-front.com/

Have fun,
Don

Index | Next | Previous | View Threaded

Interested in having your list archived? Contact Gossamer Threads