[mythtvnz] Manually adding Imparja...

[Steve Holdoway]

I'm having loads of fun attempting to update the database directly to add imparja to my gutsy mythbuntu setup using info off lyngsat. Can anyone help???

I've updated dtv_multiplex with the following data:

mysql> select * from dtv_multiplex;
+---------+----------+-------------+-----------+-----------+-----------+------------+------+----------+------------+-----------+--------------+-------------------+----------------+---------+---------------+-----------+--------------+------------+----------------+---------------------+
| mplexid | sourceid | transportid | networkid | frequency | inversion | symbolrate | fec  | polarity | modulation | bandwidth | lp_code_rate | transmission_mode | guard_interval | visible | constellation | hierarchy | hp_code_rate | sistandard | serviceversion | updatetimestamp     |
+---------+----------+-------------+-----------+-----------+-----------+------------+------+----------+------------+-----------+--------------+-------------------+----------------+---------+---------------+-----------+--------------+------------+----------------+---------------------+
|       1 |        1 |          21 |        47 |  12456000 | a         |   22500000 | 3/4  | h        | qpsk       | NULL      | NULL         | NULL              | NULL           |       0 | NULL          | NULL      | NULL         | dvb        |             13 | 2007-12-25 18:32:15 | 
|       2 |        1 |          22 |        47 |  12483000 | a         |   22500000 | 3/4  | h        | qpsk       | NULL      | NULL         | NULL              | NULL           |       0 | NULL          | NULL      | NULL         | dvb        |              4 | 2007-12-12 17:10:15 | 
|       5 |        1 |        NULL |      NULL |  12643000 | a         |    6874000 | 3/4  | v        | auto       | a         | auto         | a                 | auto           |       0 | auto          | auto      | auto         | dvb        |             33 | 2008-02-24 18:44:26 | 

The first two work fine, but the last is what I entered. I think I need values for the transportid and network id as well. Not sure what the serviceversion should be either.

mysql> select * from channel where chanid = 1025;
+--------+---------+--------+----------+----------+---------+------+----------+--------------+---------+-------------+----------+------------+--------+-------+----------+----------+---------+---------------+---------------+---------+-----------+-----------+----------+-----------------+-----------------+
| chanid | channum | freqid | sourceid | callsign | name    | icon | finetune | videofilters | xmltvid | recpriority | contrast | brightness | colour | hue   | tvformat | commfree | visible | outputfilters | useonairguide | mplexid | serviceid | atscsrcid | tmoffset | atsc_major_chan | atsc_minor_chan |
+--------+---------+--------+----------+----------+---------+------+----------+--------------+---------+-------------+----------+------------+--------+-------+----------+----------+---------+---------------+---------------+---------+-----------+-----------+----------+-----------------+-----------------+
|   1025 | 21      | NULL   |        1 | Imparja  | Imparja |      |     NULL |              |         |           0 |    32768 |      32768 |  32768 | 32768 |          |        0 |       1 |               |             1 |       5 |      1024 |      NULL |        0 |               0 |               0 | 
+--------+---------+--------+----------+----------+---------+------+----------+--------------+---------+-------------+----------+------------+--------+-------+----------+----------+---------+---------------+---------------+---------+-----------+-----------+----------+-----------------+-----------------+
1 row in set (0.00 sec)


Is what I've added to channels in an attempt to get Imparja on channel 22 of my remote - using the lyngsat sid as serviceid, and nid as chanid. Should I be just using serviceid+1000 as channelid?

As you've guessed, it's not working. Can anyone point me at what's wrong?

Cheers,

Steve


-- 
Steve Holdoway <steve at greengecko.co.nz>