[mythtv] [PATCH] DBOX2 Feed Implementation 2005-05-10

[Andrew]

On Wednesday 11 May 2005 04:06, Levent Guendogdu wrote:
> Hi people,
>
> attached you will find the implementation for using the DBOX2 as a
> MythTV DVB source.
>
> Features:
>    - using the Nokia/Sagem/Philips DBOX2 as a video source for MythTV
>    - multiple DBOX2s can be used
>    - grabs a complete TS stream from the DBOX2 using SPTS mode (all
> audio streams available in myth)
>    - automatic EPG scan of all DBOX2 channels when recorder/livetv is
> inactive
>
> Please submit this to the current CVS.
>
> Have fun,
>  Levon

Just tried this and are having problems adding capture cards, you add capture 
card, can be dvb or whatever but they dont show up on the list, also any 
previous cards I had configured have gone from the list aswell.

The sql error is:

DB Error (simpledbstorage update):
Query was:

Thats it. I would have thought the database would have had a schema upgrade? 
The card does get added to the database but mythtv is unable to see it. Here 
is the output from the backend. I have 3 DVB cards in the database but since 
applying this patch mythbackend does not see them.

mythtv 11-05 # mythbackend
2005-05-11 13:23:54.937 New DB connection, total: 1
Starting up as the master server.
2005-05-11 13:23:54.971 New DB connection, total: 2
2005-05-11 13:23:54.973 mythbackend: MythBackend started as master server
DB Error (getdevices):
Query was:
SELECT 
videodevice,vbidevice,audiodevice,audioratelimit,defaultinput,cardtype,dvb_hw_decoder, 
dvb_recordts,dvb_wait_for_seqstart,dvb_dmx_buf_size,dvb_pkt_buf_size, 
skipbtaudio, dvb_on_demand,firewire_port, firewire_node, 
firewire_speed,firewire_model, firewire_connection, dbox2_port, dbox2_host, 
dbox2_httpport FROM capturecard WHERE cardid = 1 ;
Driver error was [2/1054]:
QMYSQL3: Unable to execute query
Database error was:
Unknown column 'dbox2_port' in 'field list'
2005-05-11 13:23:54.982 Channel()::Open(): Can't open video device, error "No 
such file or directory"
2005-05-11 13:23:54.984 Channel()::Open(): Can't open video device, error "No 
such file or directory"
2005-05-11 13:23:54.985 ChannelBase: Could not find input: Television on card 
when setting channel 3

DB Error (getdevices):
Query was:
SELECT 
videodevice,vbidevice,audiodevice,audioratelimit,defaultinput,cardtype,dvb_hw_decoder, 
dvb_recordts,dvb_wait_for_seqstart,dvb_dmx_buf_size,dvb_pkt_buf_size, 
skipbtaudio, dvb_on_demand,firewire_port, firewire_node, 
firewire_speed,firewire_model, firewire_connection, dbox2_port, dbox2_host, 
dbox2_httpport FROM capturecard WHERE cardid = 4 ;
Driver error was [2/1054]:
QMYSQL3: Unable to execute query
Database error was:
Unknown column 'dbox2_port' in 'field list'

2005-05-11 13:23:54.994 Channel()::Open(): Can't open video device, error "No 
such file or directory"
2005-05-11 13:23:54.996 Channel()::Open(): Can't open video device, error "No 
such file or directory"
2005-05-11 13:23:54.997 ChannelBase: Could not find input: Television on card 
when setting channel 3

DB Error (getdevices):
Query was:
SELECT 
videodevice,vbidevice,audiodevice,audioratelimit,defaultinput,cardtype,dvb_hw_decoder, 
dvb_recordts,dvb_wait_for_seqstart,dvb_dmx_buf_size,dvb_pkt_buf_size, 
skipbtaudio, dvb_on_demand,firewire_port, firewire_node, 
firewire_speed,firewire_model, firewire_connection, dbox2_port, dbox2_host, 
dbox2_httpport FROM capturecard WHERE cardid = 5 ;
Driver error was [2/1054]:
QMYSQL3: Unable to execute query
Database error was:
Unknown column 'dbox2_port' in 'field list'

2005-05-11 13:23:55.005 Channel()::Open(): Can't open video device, error "No 
such file or directory"
2005-05-11 13:23:55.006 Channel()::Open(): Can't open video device, error "No 
such file or directory"
2005-05-11 13:23:55.008 ChannelBase: Could not find input: Television on card 
when setting channel 3

DB Error (getdevices):
Query was:
SELECT 
videodevice,vbidevice,audiodevice,audioratelimit,defaultinput,cardtype,dvb_hw_decoder, 
dvb_recordts,dvb_wait_for_seqstart,dvb_dmx_buf_size,dvb_pkt_buf_size, 
skipbtaudio, dvb_on_demand,firewire_port, firewire_node, 
firewire_speed,firewire_model, firewire_connection, dbox2_port, dbox2_host, 
dbox2_httpport FROM capturecard WHERE cardid = 7 ;
Driver error was [2/1054]:
QMYSQL3: Unable to execute query
Database error was:
Unknown column 'dbox2_port' in 'field list'

2005-05-11 13:23:55.020 Channel()::Open(): Can't open video device, error "No 
such file or directory"
2005-05-11 13:23:55.022 Channel()::Open(): Can't open video device, error "No 
such file or directory"
2005-05-11 13:23:55.024 ChannelBase: Could not find input: Television on card 
when setting channel 3

DB Error (getdevices):
Query was:
SELECT 
videodevice,vbidevice,audiodevice,audioratelimit,defaultinput,cardtype,dvb_hw_decoder, 
dvb_recordts,dvb_wait_for_seqstart,dvb_dmx_buf_size,dvb_pkt_buf_size, 
skipbtaudio, dvb_on_demand,firewire_port, firewire_node, 
firewire_speed,firewire_model, firewire_connection, dbox2_port, dbox2_host, 
dbox2_httpport FROM capturecard WHERE cardid = 9 ;
Driver error was [2/1054]:
QMYSQL3: Unable to execute query
Database error was:
Unknown column 'dbox2_port' in 'field list'

2005-05-11 13:23:55.032 Channel()::Open(): Can't open video device, error "No 
such file or directory"
2005-05-11 13:23:55.033 Channel()::Open(): Can't open video device, error "No 
such file or directory"
2005-05-11 13:23:55.035 ChannelBase: Could not find input: Television on card 
when setting channel 3

2005-05-11 13:23:55.041 New DB scheduler connection
2005-05-11 13:23:55.047 mythbackend version: 0.18.20050504-1 www.mythtv.org
2005-05-11 13:23:55.048 Enabled verbose msgs : important general
2005-05-11 13:23:55.049 New DB connection, total: 3
2005-05-11 13:23:55.051 New DB connection, total: 4
2005-05-11 13:23:57.058 Reschedule requested for id -1.
2005-05-11 13:23:57.208 Scheduled 13 items in 0.1 = 0.06 match + 0.09 place
2005-05-11 13:23:57.221 scheduler: Scheduled items
2005-05-11 13:23:57.227 Seem to be woken up by USER
2005-05-11 13:24:05.056 mythbackend: Running housekeeping thread

I would love to beable to use this.
Thanks for your work.

Andrew.