FREE LOOK

UK DVB Channel Numbers for MythDora 5

Mythtv, for those who dont know, is a very powerful, flexible, PVR tweakers paradise which can be run on top of an existing linux OS or from one of the customised distributions available. The new version of Mythdora, 5, has a really irritating problem: using UK freeview DVB-T it doesnt assign channel numbers as you would expect. So to the rescue is a small mysql script to do just that. The channel numbers come from the awesome DigitalSpy website, one of the best collections of information on transmitted media I have ever come across.


Script:

USE mythconverg;
UPDATE channel SET channum=1 WHERE name=BBC ONE; 
UPDATE channel SET channum=2 WHERE name=BBC TWO; 
UPDATE channel SET channum=3 WHERE name=ITV1; 
UPDATE channel SET channum=4 WHERE name=Channel 4; 
UPDATE channel SET channum=5 WHERE name=Five; 
UPDATE channel SET channum=6 WHERE name=ITV2; 
UPDATE channel SET channum=7 WHERE name=BBC THREE; 
UPDATE channel SET channum=9 WHERE name=BBC FOUR; 
UPDATE channel SET channum=10 WHERE name=ITV3; 
UPDATE channel SET channum=11 WHERE name=SKY THREE; 
UPDATE channel SET channum=12 WHERE name=UKTV History; 
UPDATE channel SET channum=13 WHERE name=Channel 4+1; 
UPDATE channel SET channum=14 WHERE name=More 4; 
UPDATE channel SET channum=16 WHERE name=QVC; 
UPDATE channel SET channum=18 WHERE name=The HITS; 
UPDATE channel SET channum=19 WHERE name=Dave; 
UPDATE channel SET channum=20 WHERE name=Virgin1; 
UPDATE channel SET channum=21 WHERE name=TMF; 
UPDATE channel SET channum=22 WHERE name=Ideal World; 
UPDATE channel SET channum=23 WHERE name=bid tv; 
UPDATE channel SET channum=24 WHERE name=price-drop tv;
UPDATE channel SET channum=28 WHERE name=ITV4; 
UPDATE channel SET channum=29 WHERE name=E4; 
UPDATE channel SET channum=30 WHERE name=E4+1; 
UPDATE channel SET channum=31 WHERE name=ITV2 +1; 
UPDATE channel SET channum=32 WHERE name=Film4; 
UPDATE channel SET channum=34 WHERE name=SETANTA SPORTS;
UPDATE channel SET channum=35 WHERE name=Five US; 
UPDATE channel SET channum=36 WHERE name=FIVER; 
UPDATE channel SET channum=37 WHERE name=smileTV; 
UPDATE channel SET channum=42 WHERE name=Nuts TV; 
UPDATE channel SET channum=43 WHERE name=Gems TV; 
UPDATE channel SET channum=44 WHERE name=GEMSTV1; 
UPDATE channel SET channum=45 WHERE name=Lottery Xtra; 
UPDATE channel SET channum=61 WHERE name=TVX / REDHOT; 
UPDATE channel SET channum=70 WHERE name=CBBC Channel;
UPDATE channel SET channum=71 WHERE name=CBeebies; 
UPDATE channel SET channum=75 WHERE name=CITV; 
UPDATE channel SET channum=80 WHERE name=BBC NEWS;
UPDATE channel SET channum=81 WHERE name=BBC Parliament;
UPDATE channel SET channum=82 WHERE name=Sky News; 
UPDATE channel SET channum=83 WHERE name=Sky Spts News;
UPDATE channel SET channum=87 WHERE name=Community; 
UPDATE channel SET channum=88 WHERE name=Teachers TV; 
UPDATE channel SET channum=100 WHERE name=Teletext; 
UPDATE channel SET channum=101 WHERE name=Ttext Holidays;
UPDATE channel SET channum=102 WHERE name=Rabbit; 
UPDATE channel SET channum=103 WHERE name=TeletextCasino;
UPDATE channel SET channum=104 WHERE name=Teletext on 4;
UPDATE channel SET channum=105 WHERE name=BBCi;
UPDATE channel SET channum=108 WHERE name=Sky Text; 
UPDATE channel SET channum=300 WHERE name=4TVinteractive;
UPDATE channel SET channum=301 WHERE name=301; 
UPDATE channel SET channum=302 WHERE name=302; 
UPDATE channel SET channum=303 WHERE name=303; 
UPDATE channel SET channum=304 WHERE name=tvtv DIGITAL; 
UPDATE channel SET channum=305 WHERE name=305; 
UPDATE channel SET channum=700 WHERE name=BBC Radio 1; 
UPDATE channel SET channum=701 WHERE name=1Xtra BBC; 
UPDATE channel SET channum=702 WHERE name=BBC Radio 2; 
UPDATE channel SET channum=703 WHERE name=BBC Radio 3; 
UPDATE channel SET channum=704 WHERE name=BBC Radio 4; 
UPDATE channel SET channum=705 WHERE name=BBC R5 Live; 
UPDATE channel SET channum=706 WHERE name=BBC 5L SportsX;
UPDATE channel SET channum=707 WHERE name=BBC 6 Music; 
UPDATE channel SET channum=708 WHERE name=BBC 7; 
UPDATE channel SET channum=709 WHERE name=BBC Asian Net.;
UPDATE channel SET channum=710 WHERE name=BBC World Sv.;
UPDATE channel SET channum=711 WHERE name=The Hits Radio;
UPDATE channel SET channum=712 WHERE name=Smash Hits!; 
UPDATE channel SET channum=713 WHERE name=Kiss; 
UPDATE channel SET channum=714 WHERE name=heat; 
UPDATE channel SET channum=715 WHERE name=Magic; 
UPDATE channel SET channum=716 WHERE name=Q; 
UPDATE channel SET channum=718 WHERE name=SMOOTH RADIO; 
UPDATE channel SET channum=721 WHERE name=MOJO; 
UPDATE channel SET channum=722 WHERE name=Kerrang!; 
UPDATE channel SET channum=723 WHERE name=talkSPORT; 
UPDATE channel SET channum=724 WHERE name=Clyde 1; 
UPDATE channel SET channum=725 WHERE name=Premier Radio;
UPDATE channel SET channum=727 WHERE name=Virgin Radio; 
UPDATE channel SET channum=728 WHERE name=Heart; 

To use it cut and paste the SQL into a text file called channel_num_fix.sql. Then run as root:

/etc/init.d/mythbackend stop
mysql -u mythtv -p < channel_num_fix.sql
/etc/init.d/mythbackend start

2 Potential warnings here: Firstly I get you to stop the backend. I am uncertain that is necessary, however on your own head be it. Also if you have channels not listed I would ensure they are not assigned to a channel number that one of the above channels want. I dont know what would happen, perhaps nothing bad as each channel has a unique ID as well as its number.

download file now

Unassigned numbers over SIP Trunk

As explained in the article
Create or modify an unassigned number range in Skype for Business Server 2015
"Skype for Business Server enables you to say what happens to incoming calls to phone numbers that are valid for your organization, but are not assigned to a user or a phone. To handle such calls, you set up an unassigned number table. You can use the table to route the calls to an Announcement application."

That is nice as a service to people dialing a wrong number, but the unassigned numbers feature can also be used to prevent loops as described in the article
How to prevent call looping between Lync Server and a VoIP gateway


Since loops in telecom systems never are a good thing, lets look at how to configure the unassigned numbers feature. The first step is to record the announcement you would like to play when an unassigned number is called. I used the free Audacity software for this, and then I exported the audio as a WMA version 2 FFmpeg file.

My message were something like:
"Welcome to <our org name>, you have called a number that is not in use.
Please check the number and call again."

Next get on your Skype4B standard or enterprise front-end server and start the Skype4B management shell to import and configure the announcement.

Get-Content "C: empUnassignedAnnouncement.wma" -ReadCount 0 -Encoding Byte | Import-CsAnnouncementFile -Parent ApplicationServer:skype4b.kressmark.com -FileName "UnassignedAnnouncement.wma" 

New-CsAnnouncement -Identity ApplicationServer:skype4b.kressmark.com -Name �Unassigned Announcement� -AudioFilePrompt �UnassignedAnnouncement.wma�

The last command will give you an output like this:

Identity           :Service:ApplicationServer:
                    skype4b.kressmark.com
                    /d5b4b757-df0a-494a-af52-0531f6f12b2d
Name               : Unassigned Announcement
AudioFilePrompt    : UnassignedAnnouncement.wma
TextToSpeechPrompt :
Language           :
TargetUri          :
AnnouncementId     : d5b4b757-df0a-494a-af52-0531f6f12b2d

Now open the Skype4B Control Panel (or restart it if you had it open already.)
Go to Voice Features / Unassigned numbers to configure the range of numbers that should be homed (accessed over the SIP Trunk) on the Skype4B system.



Please note that you could enter the number with a + sign but without a leading tel: so it is a bit different from other places in the Skype4B Control Panel. The help file says "This means the number may begin with the string tel: (if you don�t specify that string, it will be automatically added for you), a plus sign (+), and a digit 1 through 9." (But why is not tel: added automatically when assigning a number to a user?)

The unassigned number table can include both assigned and unassigned numbers, but it is invoked only when a caller dials a number that is not currently assigned. This means it is fine to add one of the numbers in the range to a user and a call to that number will go to the user, or the other way around, if you remove a number in the range from a user a call to that number will get the announcement.

After committing these changes you do not need to restart anything, simply grab an internal client with a user with enterprise voice and dial one of the numbers in the range. You should now hear the message you recorded, and on the server you should also find event 46041 from LS Outbound Routing which says "Vacant Number Settings Loaded Successfully".

Next up would be to test an unassigned number from an external telephone.

If this call does not reach the announcement service chances are that you have configured a PSTN usage for the trunk under Voice Routing / Trunk Configuration in the Control Panel. This PSTN usage will somehow take precedence over the internal announcement service and will not let calls through. Remove the PSTN usage from the Trunk Configuration and your external call should be hearing the announcement now, and you will not risk getting loops in your system.

For more info:
Redirecting inbound PSTN calls in Lync
PSTN to Lync 2013 Unassigned Number failure

download file now