[mythtvnz] Prime => Sky Open

[Robert Fisher]

I thought that my epg had previously had data for Sky Open but today 
there is nothing in

/home/mythtv/.mythtv/freeview.xml  for Sky Open (or Prime

I am a bit stuck now. Here is some supporting info if someone has any 
suggestions I would appreciate help.

When I ran journalctl -eu epg

I got:-

Sep 08 15:38:03 FishMyth bash[4818]: Getting channel info from MythTV 
database using mysql
Sep 08 15:38:03 FishMyth bash[4820]: mysql: [Warning] Using a password 
on the command line interface can be insecure.
Sep 08 15:38:03 FishMyth bash[4822]: mysql: [Warning] Using a password 
on the command line interface can be insecure.
Sep 08 15:38:03 FishMyth bash[4818]: Al Jazeera        Al Jazeera        
aljazeera.freeviewnz.tv
Sep 08 15:38:03 FishMyth bash[4818]: Radio NZ National Radio NZ 
National        rnz-national.freeviewnz.tv

etc etc etc and

Sep 08 15:38:03 FishMyth bash[4818]: Sky Open        Sky Open        
skyopen.freeviewnz.tv

so I tried changing the xmltvid from

skyopen.freeviewnz.tv to prime.freeviewnz.tv

and doing the same in Freeview.xmltv

Now I get (when I run journalctl -eu epg)

Sep 08 16:13:35 FishMyth bash[5729]: Sky Open        Sky Open        
prime.freeviewnz.tv

But no Prime or Sky Open in --- Channel Names ---

/home/mythtv/.mythtv/freeview.xml gets updated but has no reference to 
prime or sky open

In mythconverg I ran

mysql> select recordid,chanid,station,title from record where station 
like '%prime%';
Empty set (0.01 sec)

mysql> select recordid,chanid,station,title from record where station 
like '%skyopen%';
Empty set (0.00 sec)

mysql> select recordid,chanid,station,title from record where station 
like '%sky open%';
Empty set (0.00 sec)

mysql> select recordid,chanid,station,title from record where station 
like '%PRIME%';
Empty set (0.00 sec)

On 25/08/23 21:03, Stephen Worthington wrote:
> Yes, the EIT EPG does not use name matching for the channels and EPG 
> data. It does it using the service ID values. So name changes cause no 
> problems for EIT. I can now confirm I am getting the Sky Open EPG 
> properly, by adding a line to my channel mapping file, as in a 
> previous post. I also had to change my .xmltv file to change 
> "prime.freeviewnz.tv" to "skyopen.freeviewnz.tv". The .xmltv file is 
> used if you are having mythfilldatabase run by a tv_grab_nz*.py file, 
> rather than running mythfilldatabase directly. It is normally found in 
> /home/mythtv/.mythtv or /home/<mythfrontend user>/.mythtv, depending 
> on which user you have running the grabber. The name is: <videosource 
> name>.xmltv so mine is FreeviewHD.xmltv. If you are also recording 
> from Sky there will be another .xmltv file for that, and also possibly 
> another one for recording from Freeview DVB-S.