View previous topic :: View next topic |
Author |
Message |
umproko5 n00b
Joined: 11 Aug 2005 Posts: 17
|
Posted: Thu Mar 05, 2009 2:58 am Post subject: MythTV Post Recording Processing |
|
|
Hi,
Post Recording Processing doesn't seem to be working on my Mythbox.
Configuration:
mythtv-0.21_p18314-r1
checked allow transcoding under recording options
checked enable transcoding under ALL recording profiles
Any ideas???
/Jason |
|
Back to top |
|
|
eduardhc Tux's lil' helper
Joined: 25 Jan 2007 Posts: 97
|
Posted: Thu Mar 05, 2009 10:34 am Post subject: Re: MythTV Post Recording Processing |
|
|
umproko5 wrote: | Hi,
Post Recording Processing doesn't seem to be working on my Mythbox.
Configuration:
mythtv-0.21_p18314-r1
checked allow transcoding under recording options
checked enable transcoding under ALL recording profiles
Any ideas???
/Jason |
Hi,
Check /var/log/mythtv/mythbackend.log to see if there are any errors starting the transcode process. Also, IIRC you need to add 'mtd' (mythtv transcode daemon) to default runlevel for transcoding to take place.
Check also through mythtv-setup that transcoding jobs are enabled for this backend.
Regards |
|
Back to top |
|
|
umproko5 n00b
Joined: 11 Aug 2005 Posts: 17
|
Posted: Fri Mar 06, 2009 1:56 am Post subject: |
|
|
Thanks, there were no errors in the log but the mtd wasn't running or in the default running level. I will see if it works tonight. |
|
Back to top |
|
|
umproko5 n00b
Joined: 11 Aug 2005 Posts: 17
|
Posted: Sat Mar 07, 2009 1:06 pm Post subject: |
|
|
Still no go ... here's part of a log file ... the only thing that queues up is the comflag.
And I set the "allow" transcode option under myth-setup, recording options and the recording profile. And if manually set a program to transcode via the job options it works ... the program is manually queued and transcoded.
2009-03-07 03:01:55.175 JobQueue: Commercial Flagging Starting for Marketplace recorded from channel 6 at Fri Mar 6 20:29:00 2009
2009-03-07 03:01:55.204 commflag: Commercial Flagging Starting: Marketplace recorded from channel 6 at Fri Mar 6 20:29:00 2009
2009-03-07 03:01:57.335 Using runtime prefix = /usr
2009-03-07 03:01:57.365 Empty LocalHostName.
2009-03-07 03:01:57.368 Using localhost value of mythtvbox
2009-03-07 03:01:57.589 New DB connection, total: 1
2009-03-07 03:01:57.635 Connected to database 'mythconverg' at host: localhost
2009-03-07 03:01:57.643 Closing DB connection named 'DBManager0'
2009-03-07 03:01:57.646 Connected to database 'mythconverg' at host: localhost
2009-03-07 03:01:57.656 New DB connection, total: 2
2009-03-07 03:01:57.665 Connected to database 'mythconverg' at host: localhost
2009-03-07 03:01:57.796 Connecting to backend server: 127.0.0.1:6543 (try 1 of 5)
2009-03-07 03:01:57.801 Using protocol version 40
2009-03-07 03:01:57.802 MainServer::HandleAnnounce Monitor
2009-03-07 03:01:57.804 adding: mythtvbox as a client (events: 0)
2009-03-07 03:01:57.806 MainServer::HandleAnnounce Monitor
2009-03-07 03:01:57.807 adding: mythtvbox as a client (events: 1)
2009-03-07 03:01:58.181 AFD: Opened codec 0x82304d0, id(MPEG2VIDEO) type(Video)
2009-03-07 03:01:58.185 AFD: codec MP2 has 2 channels
2009-03-07 03:01:58.186 AFD: Opened codec 0x8230950, id(MP2) type(Audio)
2009-03-07 03:02:54.100 AutoExpire: CalcParams(): Max required Free Space: 1.0 GB w/freq: 15 min
2009-03-07 03:17:54.741 AutoExpire: CalcParams(): Max required Free Space: 1.0 GB w/freq: 15 min
2009-03-07 03:24:53.032 [mpeg2video @ 0xb7333028]ac-tex damaged at 12 8
2009-03-07 03:24:53.070 [mpeg2video @ 0xb7333028]Warning MVs not available
2009-03-07 03:24:57.273 Using runtime prefix = /usr
2009-03-07 03:24:57.356 Empty LocalHostName.
2009-03-07 03:24:57.360 Using localhost value of mythtvbox
2009-03-07 03:24:57.580 New DB connection, total: 1
2009-03-07 03:24:57.644 Connected to database 'mythconverg' at host: localhost
2009-03-07 03:24:57.666 Closing DB connection named 'DBManager0'
2009-03-07 03:24:57.669 Connected to database 'mythconverg' at host: localhost
2009-03-07 03:24:57.683 New DB connection, total: 2
2009-03-07 03:24:57.685 Connected to database 'mythconverg' at host: localhost
2009-03-07 03:24:57.692 Current Schema Version: 1214
2009-03-07 03:24:58.150 AFD: Opened codec 0x82ccb20, id(MPEG2VIDEO) type(Video)
2009-03-07 03:24:58.152 AFD: codec MP2 has 2 channels
2009-03-07 03:24:58.153 AFD: Opened codec 0x82ccfa0, id(MP2) type(Audio)
2009-03-07 03:24:58.467 Preview: Grabbed preview '/recordings/6_20090306202900.mpg' 480x480@124s
2009-03-07 03:24:58.920 commflag: Commercial Flagging Finished: Marketplace recorded from channel 6 at Fri Mar 6 20:29:00 2009 (4 commercial break(s)) |
|
Back to top |
|
|
umproko5 n00b
Joined: 11 Aug 2005 Posts: 17
|
Posted: Sat Mar 07, 2009 1:50 pm Post subject: |
|
|
I think I found the problem ...
I had a look in the database and found this,
+-----+------------+---------------------+---------------------+------+------+-------+--------+---------------------+-----------+---------------+----------------------------------+---------------------+
| id | chanid | starttime | inserttime | type | cmds | flags | status | statustime | hostname | args | comment | schedruntime |
+-----+------------+---------------------+---------------------+------+------+-------+--------+---------------------+-----------+---------------+----------------------------------+---------------------+
| 177 | 2147483647 | 2008-02-18 17:11:38 | 2008-02-18 18:13:08 | 2 | 0 | 0 | 1 | 2008-02-18 18:13:08 | | | | 2007-01-01 00:00:00 |
A transcode job stuck in the queue. Does anyone know if I can safely remove it with breaking anything?
/Jason |
|
Back to top |
|
|
eduardhc Tux's lil' helper
Joined: 25 Jan 2007 Posts: 97
|
Posted: Sat Mar 07, 2009 1:54 pm Post subject: |
|
|
umproko5 wrote: | I think I found the problem ...
I had a look in the database and found this,
+-----+------------+---------------------+---------------------+------+------+-------+--------+---------------------+-----------+---------------+----------------------------------+---------------------+
| id | chanid | starttime | inserttime | type | cmds | flags | status | statustime | hostname | args | comment | schedruntime |
+-----+------------+---------------------+---------------------+------+------+-------+--------+---------------------+-----------+---------------+----------------------------------+---------------------+
| 177 | 2147483647 | 2008-02-18 17:11:38 | 2008-02-18 18:13:08 | 2 | 0 | 0 | 1 | 2008-02-18 18:13:08 | | | | 2007-01-01 00:00:00 |
A transcode job stuck in the queue. Does anyone know if I can safely remove it with breaking anything?
/Jason |
Hi,
If the transcode process is not actually running (check for mythtranscode process) then yes, you can safely purge this entry. Try to, and see if then new shows are being transcoded.
Regards |
|
Back to top |
|
|
umproko5 n00b
Joined: 11 Aug 2005 Posts: 17
|
Posted: Sat Mar 07, 2009 3:43 pm Post subject: |
|
|
Still no go ...
It seems in that the "automatically queued" transcode job are not being queued at all. I am watching the job queue table
Code: |
mysql> select * from jobqueue;
+-----+--------+---------------------+---------------------+------+------+-------+--------+---------------------+-----------+---------------+----------------------------------+---------------------+
| id | chanid | starttime | inserttime | type | cmds | flags | status | statustime | hostname | args | comment | schedruntime |
+-----+--------+---------------------+---------------------+------+------+-------+--------+---------------------+-----------+---------------+----------------------------------+---------------------+
| 936 | 7 | 2009-03-07 08:29:00 | 2009-03-07 08:46:36 | 2 | 0 | 4 | 272 | 2009-03-07 08:47:28 | mythtvbox | | Finished, 0 break(s) found. | 2009-03-07 08:46:36 |
| 937 | 13 | 2009-03-07 08:48:00 | 2009-03-07 09:01:30 | 2 | 0 | 0 | 272 | 2009-03-07 09:11:26 | mythtvbox | | 2 commercial break(s) | 2009-03-07 09:01:30 |
| 935 | 6 | 2009-03-07 07:55:00 | 2009-03-07 08:45:53 | 2 | 0 | 4 | 272 | 2009-03-07 08:46:36 | mythtvbox | | Finished, 0 break(s) found. | 2009-03-07 08:45:53 |
| 923 | 9 | 2009-03-05 23:59:00 | 2009-03-06 00:30:03 | 2 | 0 | 0 | 272 | 2009-03-06 01:47:23 | mythtvbox | | 4 commercial break(s) | 2009-03-06 00:30:03 |
| 924 | 9 | 2009-03-06 00:30:00 | 2009-03-06 01:01:30 | 2 | 0 | 0 | 272 | 2009-03-06 02:07:38 | mythtvbox | | 3 commercial break(s) | 2009-03-06 01:01:30 |
| 925 | 9 | 2009-03-04 23:59:00 | 2009-03-06 06:54:56 | 1 | 0 | 1 | 272 | 2009-03-07 02:00:42 | mythtvbox | RENAME_TO_NUV | High Quality: 1.2 GB => 420.0 MB | 2009-03-06 06:54:56 |
| 926 | 9 | 2009-03-05 23:59:00 | 2009-03-06 06:55:07 | 1 | 0 | 1 | 272 | 2009-03-07 02:31:02 | mythtvbox | RENAME_TO_NUV | High Quality: 1.1 GB => 400.1 MB | 2009-03-06 06:55:07 |
| 927 | 9 | 2009-03-06 00:30:00 | 2009-03-06 06:55:21 | 1 | 0 | 1 | 272 | 2009-03-07 03:01:00 | mythtvbox | RENAME_TO_NUV | High Quality: 1.1 GB => 407.7 MB | 2009-03-06 06:55:21 |
| 931 | 6 | 2009-03-07 07:33:00 | 2009-03-07 07:41:30 | 2 | 0 | 0 | 272 | 2009-03-07 08:18:34 | mythtvbox | | 0 commercial break(s) | 2009-03-07 07:41:30 |
| 932 | 6 | 2009-03-07 07:44:00 | 2009-03-07 07:55:02 | 2 | 0 | 0 | 272 | 2009-03-07 08:55:46 | mythtvbox | | 1 commercial break(s) | 2009-03-07 07:55:02 |
| 929 | 9 | 2009-03-06 23:59:00 | 2009-03-07 00:30:02 | 2 | 0 | 0 | 272 | 2009-03-07 03:48:19 | mythtvbox | | 3 commercial break(s) | 2009-03-07 00:30:02 |
| 930 | 9 | 2009-03-07 00:30:00 | 2009-03-07 01:01:31 | 2 | 0 | 0 | 272 | 2009-03-07 04:09:24 | mythtvbox | | 3 commercial break(s) | 2009-03-07 01:01:31 |
| 922 | 9 | 2009-03-04 23:59:00 | 2009-03-05 00:31:31 | 2 | 0 | 0 | 272 | 2009-03-05 01:51:11 | mythtvbox | | 3 commercial break(s) | 2009-03-05 00:31:31 |
| 928 | 6 | 2009-03-06 20:29:00 | 2009-03-06 21:01:31 | 2 | 0 | 0 | 272 | 2009-03-07 03:24:54 | mythtvbox | | 4 commercial break(s) | 2009-03-06 21:01:31 |
+-----+--------+---------------------+---------------------+------+------+-------+--------+---------------------+-----------+---------------+----------------------------------+---------------------+
|
NOTE: The type 1 rows are the manually transcode jobs. The type 2 jobs are the comflag jobs.
Does anyone the transcode settings that should be set from the within the database? |
|
Back to top |
|
|
eduardhc Tux's lil' helper
Joined: 25 Jan 2007 Posts: 97
|
Posted: Sat Mar 07, 2009 4:24 pm Post subject: |
|
|
Hi,
Could you please post the contents of the following database tables?
· profilegroups
· recordingprofiles
· codecparams
Also the result of the following query:
Code: |
SELECT * FROM settings where value like '%job%'
|
EDIT: include please also this one:
Code: |
SELECT * FROM record
|
I'll try to discover if there is anything wrong with your setup.
Regards |
|
Back to top |
|
|
umproko5 n00b
Joined: 11 Aug 2005 Posts: 17
|
Posted: Sat Mar 07, 2009 4:48 pm Post subject: |
|
|
Code: |
mysql> select * from profilegroups;
+----+----------------------------------------------------------+-----------+------------+-----------+
| id | name | cardtype | is_default | hostname |
+----+----------------------------------------------------------+-----------+------------+-----------+
| 1 | Software Encoders (v4l based) | V4L | 1 | NULL |
| 2 | MPEG-2 Encoders (PVR-x50, PVR-500) | MPEG | 1 | NULL |
| 3 | Hardware MJPEG Encoders (Matrox G200-TV, Miro DC10, etc) | MJPEG | 1 | NULL |
| 4 | Hardware HDTV | HDTV | 1 | NULL |
| 5 | Hardware DVB Encoders | DVB | 1 | NULL |
| 6 | Transcoders | TRANSCODE | 1 | NULL |
| 7 | FireWire Input | FIREWIRE | 1 | NULL |
| 8 | USB Mpeg-4 Encoder (Plextor ConvertX, etc) | GO7007 | 1 | NULL |
| 9 | DBOX2 Input | DBOX2 | 1 | NULL |
| 10 | Freebox Input | Freebox | 1 | NULL |
| 11 | HDHomeRun Recorders | HDHOMERUN | 1 | NULL |
| 12 | CRC IP Recorders | CRC_IP | 1 | NULL |
| 13 | Movies | MPEG | 0 | mythtvbox |
| 14 | tv series | V4L | 0 | mythtvbox |
+----+----------------------------------------------------------+-----------+------------+-----------+
14 rows in set (0.00 sec)
|
Code: |
mysql> select * from recordingprofiles;
+----+----------------+-------------------------+-------------------------+--------------+
| id | name | videocodec | audiocodec | profilegroup |
+----+----------------+-------------------------+-------------------------+--------------+
| 1 | Default | NULL | NULL | 1 |
| 2 | Live TV | NULL | NULL | 1 |
| 3 | High Quality | NULL | NULL | 1 |
| 4 | Low Quality | NULL | NULL | 1 |
| 5 | Default | MPEG-2 Hardware Encoder | MPEG-2 Hardware Encoder | 2 |
| 6 | Live TV | MPEG-2 Hardware Encoder | MPEG-2 Hardware Encoder | 2 |
| 7 | High Quality | MPEG-2 Hardware Encoder | MPEG-2 Hardware Encoder | 2 |
| 8 | Low Quality | MPEG-2 Hardware Encoder | MPEG-2 Hardware Encoder | 2 |
| 9 | Default | NULL | NULL | 3 |
| 10 | Live TV | NULL | NULL | 3 |
| 11 | High Quality | NULL | NULL | 3 |
| 12 | Low Quality | NULL | NULL | 3 |
| 13 | Default | NULL | NULL | 4 |
| 14 | Live TV | NULL | NULL | 4 |
| 15 | High Quality | NULL | NULL | 4 |
| 16 | Low Quality | NULL | NULL | 4 |
| 17 | Default | NULL | NULL | 5 |
| 18 | Live TV | NULL | NULL | 5 |
| 19 | High Quality | NULL | NULL | 5 |
| 20 | Low Quality | NULL | NULL | 5 |
| 21 | RTjpeg/MPEG4 | MPEG-4 | MP3 | 6 |
| 22 | MPEG2 | MPEG-4 | MP3 | 6 |
| 23 | Default | NULL | NULL | 8 |
| 24 | Live TV | NULL | NULL | 8 |
| 25 | High Quality | NULL | NULL | 8 |
| 26 | Low Quality | NULL | NULL | 8 |
| 27 | High Quality | MPEG-4 | MP3 | 6 |
| 28 | Medium Quality | MPEG-4 | MP3 | 6 |
| 29 | Low Quality | MPEG-4 | MP3 | 6 |
| 30 | Default | NULL | NULL | 10 |
| 31 | Live TV | NULL | NULL | 10 |
| 32 | High Quality | NULL | NULL | 10 |
| 33 | Low Quality | NULL | NULL | 10 |
| 34 | Default | NULL | NULL | 11 |
| 35 | Live TV | NULL | NULL | 11 |
| 36 | High Quality | NULL | NULL | 11 |
| 37 | Low Quality | NULL | NULL | 11 |
| 38 | Default | NULL | NULL | 12 |
| 39 | Live TV | NULL | NULL | 12 |
| 40 | High Quality | NULL | NULL | 12 |
| 41 | Low Quality | NULL | NULL | 12 |
| 42 | Default | NULL | NULL | 13 |
| 43 | Live TV | MPEG-2 Hardware Encoder | MPEG-2 Hardware Encoder | 13 |
| 44 | High Quality | MPEG-2 Hardware Encoder | MPEG-2 Hardware Encoder | 13 |
| 45 | Low Quality | NULL | NULL | 13 |
| 46 | Default | MPEG-4 | MP3 | 14 |
| 47 | Live TV | RTjpeg | MP3 | 14 |
| 48 | High Quality | MPEG-4 | MP3 | 14 |
| 49 | Low Quality | RTjpeg | MP3 | 14 |
| 50 | Default | NULL | NULL | 7 |
| 51 | Live TV | NULL | NULL | 7 |
| 52 | High Quality | NULL | NULL | 7 |
| 53 | Low Quality | NULL | NULL | 7 |
| 54 | Default | NULL | NULL | 9 |
| 55 | Live TV | NULL | NULL | 9 |
| 56 | High Quality | NULL | NULL | 9 |
| 57 | Low Quality | NULL | NULL | 9 |
+----+----------------+-------------------------+-------------------------+--------------+
57 rows in set (0.00 sec)
|
Code: |
mysql> select * from codecparams;
+---------+--------------------------+-----------+
| profile | name | value |
+---------+--------------------------+-----------+
| 5 | autotranscode | 1 |
| 5 | width | 480 |
| 5 | height | 480 |
| 5 | rtjpegquality | 170 |
| 5 | rtjpeglumafilter | 0 |
| 5 | rtjpegchromafilter | 0 |
| 5 | mpeg4bitrate | 2200 |
| 5 | mpeg4maxquality | 2 |
| 5 | mpeg4minquality | 15 |
| 5 | mpeg4qualdiff | 3 |
| 5 | mpeg4scalebitrate | 1 |
| 5 | mpeg4optionvhq | 0 |
| 5 | mpeg4option4mv | 0 |
| 5 | mpeg4optionidct | 0 |
| 5 | mpeg4optionime | 0 |
| 5 | hardwaremjpegquality | 100 |
| 5 | hardwaremjpeghdecimation | 4 |
| 5 | hardwaremjpegvdecimation | 4 |
| 5 | mpeg2streamtype | MPEG-2 PS |
| 5 | mpeg2aspectratio | 4:3 |
| 5 | mpeg2bitrate | 4500 |
| 5 | mpeg2maxbitrate | 6000 |
| 5 | samplerate | 48000 |
| 5 | mp3quality | 7 |
| 5 | volume | 90 |
| 5 | mpeg2audtype | Layer II |
| 5 | mpeg2audbitratel1 | 448 |
| 5 | mpeg2audbitratel2 | 384 |
| 5 | mpeg2audvolume | 90 |
| 6 | autotranscode | 1 |
| 6 | width | 480 |
| 6 | height | 480 |
| 6 | rtjpegquality | 170 |
| 6 | rtjpeglumafilter | 0 |
| 6 | rtjpegchromafilter | 0 |
| 6 | mpeg4bitrate | 2200 |
| 6 | mpeg4maxquality | 2 |
| 6 | mpeg4minquality | 15 |
| 6 | mpeg4qualdiff | 3 |
| 6 | mpeg4scalebitrate | 1 |
| 6 | mpeg4optionvhq | 0 |
| 6 | mpeg4option4mv | 0 |
| 6 | mpeg4optionidct | 0 |
| 6 | mpeg4optionime | 0 |
| 6 | hardwaremjpegquality | 100 |
| 6 | hardwaremjpeghdecimation | 4 |
| 6 | hardwaremjpegvdecimation | 4 |
| 6 | mpeg2streamtype | MPEG-2 PS |
| 6 | mpeg2aspectratio | 4:3 |
| 6 | mpeg2bitrate | 4500 |
| 6 | mpeg2maxbitrate | 6000 |
| 6 | samplerate | 48000 |
| 6 | mp3quality | 7 |
| 6 | volume | 90 |
| 6 | mpeg2audtype | Layer II |
| 6 | mpeg2audbitratel1 | 448 |
| 6 | mpeg2audbitratel2 | 384 |
| 6 | mpeg2audvolume | 90 |
| 21 | transcodelossless | 0 |
| 21 | transcoderesize | 0 |
| 21 | width | 480 |
| 21 | height | 480 |
| 21 | rtjpegquality | 170 |
| 21 | rtjpeglumafilter | 0 |
| 21 | rtjpegchromafilter | 0 |
| 21 | mpeg4bitrate | 2200 |
| 21 | mpeg4maxquality | 2 |
| 21 | mpeg4minquality | 15 |
| 21 | mpeg4qualdiff | 3 |
| 21 | mpeg4scalebitrate | 1 |
| 21 | mpeg4optionvhq | 0 |
| 21 | mpeg4option4mv | 0 |
| 21 | mpeg4optionidct | 0 |
| 21 | mpeg4optionime | 1 |
| 21 | hardwaremjpegquality | 100 |
| 21 | hardwaremjpeghdecimation | 4 |
| 21 | hardwaremjpegvdecimation | 4 |
| 21 | mpeg2streamtype | MPEG-2 PS |
| 21 | mpeg2aspectratio | 4:3 |
| 21 | mpeg2bitrate | 4500 |
| 21 | mpeg2maxbitrate | 6000 |
| 21 | samplerate | 32000 |
| 21 | mp3quality | 7 |
| 21 | volume | 90 |
| 21 | mpeg2audtype | Layer II |
| 21 | mpeg2audbitratel1 | 448 |
| 21 | mpeg2audbitratel2 | 384 |
| 21 | mpeg2audvolume | 90 |
| 22 | transcodelossless | 0 |
| 22 | transcoderesize | 0 |
| 22 | width | 480 |
| 22 | height | 480 |
| 22 | rtjpegquality | 170 |
| 22 | rtjpeglumafilter | 0 |
| 22 | rtjpegchromafilter | 0 |
| 22 | mpeg4bitrate | 2200 |
| 22 | mpeg4maxquality | 2 |
| 22 | mpeg4minquality | 15 |
| 22 | mpeg4qualdiff | 3 |
| 22 | mpeg4scalebitrate | 1 |
| 22 | mpeg4optionvhq | 0 |
| 22 | mpeg4option4mv | 0 |
| 22 | mpeg4optionidct | 0 |
| 22 | mpeg4optionime | 0 |
| 22 | hardwaremjpegquality | 100 |
| 22 | hardwaremjpeghdecimation | 4 |
| 22 | hardwaremjpegvdecimation | 4 |
| 22 | mpeg2streamtype | MPEG-2 PS |
| 22 | mpeg2aspectratio | 4:3 |
| 22 | mpeg2bitrate | 4500 |
| 22 | mpeg2maxbitrate | 6000 |
| 22 | samplerate | 32000 |
| 22 | mp3quality | 7 |
| 22 | volume | 90 |
| 22 | mpeg2audtype | Layer II |
| 22 | mpeg2audbitratel1 | 448 |
| 22 | mpeg2audbitratel2 | 384 |
| 22 | mpeg2audvolume | 90 |
| 44 | autotranscode | 0 |
| 44 | width | 480 |
| 44 | height | 480 |
| 44 | rtjpegquality | 170 |
| 44 | rtjpeglumafilter | 0 |
| 44 | rtjpegchromafilter | 0 |
| 44 | mpeg4bitrate | 2200 |
| 44 | mpeg4maxquality | 2 |
| 44 | mpeg4minquality | 15 |
| 44 | mpeg4qualdiff | 3 |
| 44 | mpeg4scalebitrate | 1 |
| 44 | mpeg4optionvhq | 0 |
| 44 | mpeg4option4mv | 0 |
| 44 | mpeg4optionidct | 0 |
| 44 | mpeg4optionime | 0 |
| 44 | hardwaremjpegquality | 100 |
| 44 | hardwaremjpeghdecimation | 4 |
| 44 | hardwaremjpegvdecimation | 4 |
| 44 | mpeg2streamtype | MPEG-2 PS |
| 44 | mpeg2aspectratio | 4:3 |
| 44 | mpeg2bitrate | 4500 |
| 44 | mpeg2maxbitrate | 6000 |
| 44 | samplerate | 48000 |
| 44 | mp3quality | 7 |
| 44 | volume | 90 |
| 44 | mpeg2audtype | Layer II |
| 44 | mpeg2audbitratel1 | 448 |
| 44 | mpeg2audbitratel2 | 384 |
| 44 | mpeg2audvolume | 90 |
| 43 | autotranscode | 0 |
| 43 | width | 480 |
| 43 | height | 480 |
| 43 | rtjpegquality | 170 |
| 43 | rtjpeglumafilter | 0 |
| 43 | rtjpegchromafilter | 0 |
| 43 | mpeg4bitrate | 2200 |
| 43 | mpeg4maxquality | 2 |
| 43 | mpeg4minquality | 15 |
| 43 | mpeg4qualdiff | 3 |
| 43 | mpeg4scalebitrate | 1 |
| 43 | mpeg4optionvhq | 0 |
| 43 | mpeg4option4mv | 0 |
| 43 | mpeg4optionidct | 0 |
| 43 | mpeg4optionime | 0 |
| 43 | hardwaremjpegquality | 100 |
| 43 | hardwaremjpeghdecimation | 4 |
| 43 | hardwaremjpegvdecimation | 4 |
| 43 | mpeg2streamtype | MPEG-2 PS |
| 43 | mpeg2aspectratio | 4:3 |
| 43 | mpeg2bitrate | 4500 |
| 43 | mpeg2maxbitrate | 6000 |
| 43 | samplerate | 48000 |
| 43 | mp3quality | 7 |
| 43 | volume | 90 |
| 43 | mpeg2audtype | Layer II |
| 43 | mpeg2audbitratel1 | 448 |
| 43 | mpeg2audbitratel2 | 384 |
| 43 | mpeg2audvolume | 90 |
| 27 | transcodelossless | 0 |
| 27 | transcoderesize | 0 |
| 27 | width | 480 |
| 27 | height | 480 |
| 27 | rtjpegquality | 170 |
| 27 | rtjpeglumafilter | 0 |
| 27 | rtjpegchromafilter | 0 |
| 27 | mpeg4bitrate | 2200 |
| 27 | mpeg4maxquality | 2 |
| 27 | mpeg4minquality | 15 |
| 27 | mpeg4qualdiff | 3 |
| 27 | mpeg4scalebitrate | 1 |
| 27 | mpeg4optionvhq | 0 |
| 27 | mpeg4option4mv | 0 |
| 27 | mpeg4optionidct | 0 |
| 27 | mpeg4optionime | 0 |
| 27 | hardwaremjpegquality | 100 |
| 27 | hardwaremjpeghdecimation | 4 |
| 27 | hardwaremjpegvdecimation | 4 |
| 27 | mpeg2streamtype | MPEG-2 PS |
| 27 | mpeg2aspectratio | 4:3 |
| 27 | mpeg2bitrate | 4500 |
| 27 | mpeg2maxbitrate | 6000 |
| 27 | samplerate | 32000 |
| 27 | mp3quality | 7 |
| 27 | volume | 90 |
| 27 | mpeg2audtype | Layer II |
| 27 | mpeg2audbitratel1 | 448 |
| 27 | mpeg2audbitratel2 | 384 |
| 27 | mpeg2audvolume | 90 |
| 28 | transcodelossless | 0 |
| 28 | transcoderesize | 0 |
| 28 | width | 480 |
| 28 | height | 480 |
| 28 | rtjpegquality | 170 |
| 28 | rtjpeglumafilter | 0 |
| 28 | rtjpegchromafilter | 0 |
| 28 | mpeg4bitrate | 2200 |
| 28 | mpeg4maxquality | 2 |
| 28 | mpeg4minquality | 15 |
| 28 | mpeg4qualdiff | 3 |
| 28 | mpeg4scalebitrate | 1 |
| 28 | mpeg4optionvhq | 0 |
| 28 | mpeg4option4mv | 0 |
| 28 | mpeg4optionidct | 0 |
| 28 | mpeg4optionime | 0 |
| 28 | hardwaremjpegquality | 100 |
| 28 | hardwaremjpeghdecimation | 4 |
| 28 | hardwaremjpegvdecimation | 4 |
| 28 | mpeg2streamtype | MPEG-2 PS |
| 28 | mpeg2aspectratio | 4:3 |
| 28 | mpeg2bitrate | 4500 |
| 28 | mpeg2maxbitrate | 6000 |
| 28 | samplerate | 32000 |
| 28 | mp3quality | 7 |
| 28 | volume | 90 |
| 28 | mpeg2audtype | Layer II |
| 28 | mpeg2audbitratel1 | 448 |
| 28 | mpeg2audbitratel2 | 384 |
| 28 | mpeg2audvolume | 90 |
| 29 | transcodelossless | 0 |
| 29 | transcoderesize | 0 |
| 29 | width | 480 |
| 29 | height | 480 |
| 29 | rtjpegquality | 170 |
| 29 | rtjpeglumafilter | 0 |
| 29 | rtjpegchromafilter | 0 |
| 29 | mpeg4bitrate | 2200 |
| 29 | mpeg4maxquality | 2 |
| 29 | mpeg4minquality | 15 |
| 29 | mpeg4qualdiff | 3 |
| 29 | mpeg4scalebitrate | 1 |
| 29 | mpeg4optionvhq | 0 |
| 29 | mpeg4option4mv | 0 |
| 29 | mpeg4optionidct | 0 |
| 29 | mpeg4optionime | 0 |
| 29 | hardwaremjpegquality | 100 |
| 29 | hardwaremjpeghdecimation | 4 |
| 29 | hardwaremjpegvdecimation | 4 |
| 29 | mpeg2streamtype | MPEG-2 PS |
| 29 | mpeg2aspectratio | 4:3 |
| 29 | mpeg2bitrate | 4500 |
| 29 | mpeg2maxbitrate | 6000 |
| 29 | samplerate | 32000 |
| 29 | mp3quality | 7 |
| 29 | volume | 90 |
| 29 | mpeg2audtype | Layer II |
| 29 | mpeg2audbitratel1 | 448 |
| 29 | mpeg2audbitratel2 | 384 |
| 29 | mpeg2audvolume | 90 |
| 48 | autotranscode | 1 |
| 48 | width | 480 |
| 48 | height | 480 |
| 48 | rtjpegquality | 170 |
| 48 | rtjpeglumafilter | 0 |
| 48 | rtjpegchromafilter | 0 |
| 48 | mpeg4bitrate | 2200 |
| 48 | mpeg4maxquality | 2 |
| 48 | mpeg4minquality | 15 |
| 48 | mpeg4qualdiff | 3 |
| 48 | mpeg4scalebitrate | 1 |
| 48 | mpeg4optionvhq | 0 |
| 48 | mpeg4option4mv | 0 |
| 48 | mpeg4optionidct | 0 |
| 48 | mpeg4optionime | 0 |
| 48 | hardwaremjpegquality | 100 |
| 48 | hardwaremjpeghdecimation | 4 |
| 48 | hardwaremjpegvdecimation | 4 |
| 48 | mpeg2streamtype | MPEG-2 PS |
| 48 | mpeg2aspectratio | 4:3 |
| 48 | mpeg2bitrate | 4500 |
| 48 | mpeg2maxbitrate | 6000 |
| 48 | samplerate | 32000 |
| 48 | mp3quality | 7 |
| 48 | volume | 90 |
| 48 | mpeg2audtype | Layer II |
| 48 | mpeg2audbitratel1 | 448 |
| 48 | mpeg2audbitratel2 | 384 |
| 48 | mpeg2audvolume | 90 |
| 47 | autotranscode | 0 |
| 47 | width | 480 |
| 47 | height | 480 |
| 47 | rtjpegquality | 170 |
| 47 | rtjpeglumafilter | 0 |
| 47 | rtjpegchromafilter | 0 |
| 47 | mpeg4bitrate | 2200 |
| 47 | mpeg4maxquality | 2 |
| 47 | mpeg4minquality | 15 |
| 47 | mpeg4qualdiff | 3 |
| 47 | mpeg4scalebitrate | 1 |
| 47 | mpeg4optionvhq | 0 |
| 47 | mpeg4option4mv | 0 |
| 47 | mpeg4optionidct | 0 |
| 47 | mpeg4optionime | 0 |
| 47 | hardwaremjpegquality | 100 |
| 47 | hardwaremjpeghdecimation | 4 |
| 47 | hardwaremjpegvdecimation | 4 |
| 47 | mpeg2streamtype | MPEG-2 PS |
| 47 | mpeg2aspectratio | 4:3 |
| 47 | mpeg2bitrate | 4500 |
| 47 | mpeg2maxbitrate | 6000 |
| 47 | samplerate | 32000 |
| 47 | mp3quality | 7 |
| 47 | volume | 90 |
| 47 | mpeg2audtype | Layer II |
| 47 | mpeg2audbitratel1 | 448 |
| 47 | mpeg2audbitratel2 | 384 |
| 47 | mpeg2audvolume | 90 |
| 46 | autotranscode | 1 |
| 46 | width | 480 |
| 46 | height | 480 |
| 46 | rtjpegquality | 170 |
| 46 | rtjpeglumafilter | 0 |
| 46 | rtjpegchromafilter | 0 |
| 46 | mpeg4bitrate | 2200 |
| 46 | mpeg4maxquality | 2 |
| 46 | mpeg4minquality | 15 |
| 46 | mpeg4qualdiff | 3 |
| 46 | mpeg4scalebitrate | 1 |
| 46 | mpeg4optionvhq | 0 |
| 46 | mpeg4option4mv | 0 |
| 46 | mpeg4optionidct | 0 |
| 46 | mpeg4optionime | 0 |
| 46 | hardwaremjpegquality | 100 |
| 46 | hardwaremjpeghdecimation | 4 |
| 46 | hardwaremjpegvdecimation | 4 |
| 46 | mpeg2streamtype | MPEG-2 PS |
| 46 | mpeg2aspectratio | 4:3 |
| 46 | mpeg2bitrate | 4500 |
| 46 | mpeg2maxbitrate | 6000 |
| 46 | samplerate | 32000 |
| 46 | mp3quality | 7 |
| 46 | volume | 90 |
| 46 | mpeg2audtype | Layer II |
| 46 | mpeg2audbitratel1 | 448 |
| 46 | mpeg2audbitratel2 | 384 |
| 46 | mpeg2audvolume | 90 |
| 49 | autotranscode | 1 |
| 49 | width | 480 |
| 49 | height | 480 |
| 49 | rtjpegquality | 170 |
| 49 | rtjpeglumafilter | 0 |
| 49 | rtjpegchromafilter | 0 |
| 49 | mpeg4bitrate | 2200 |
| 49 | mpeg4maxquality | 2 |
| 49 | mpeg4minquality | 15 |
| 49 | mpeg4qualdiff | 3 |
| 49 | mpeg4scalebitrate | 1 |
| 49 | mpeg4optionvhq | 0 |
| 49 | mpeg4option4mv | 0 |
| 49 | mpeg4optionidct | 0 |
| 49 | mpeg4optionime | 0 |
| 49 | hardwaremjpegquality | 100 |
| 49 | hardwaremjpeghdecimation | 4 |
| 49 | hardwaremjpegvdecimation | 4 |
| 49 | mpeg2streamtype | MPEG-2 PS |
| 49 | mpeg2aspectratio | 4:3 |
| 49 | mpeg2bitrate | 4500 |
| 49 | mpeg2maxbitrate | 6000 |
| 49 | samplerate | 32000 |
| 49 | mp3quality | 7 |
| 49 | volume | 90 |
| 49 | mpeg2audtype | Layer II |
| 49 | mpeg2audbitratel1 | 448 |
| 49 | mpeg2audbitratel2 | 384 |
| 49 | mpeg2audvolume | 90 |
| 5 | scalebitrate | 1 |
| 6 | scalebitrate | 1 |
| 21 | scalebitrate | 1 |
| 22 | scalebitrate | 1 |
| 44 | scalebitrate | 1 |
| 43 | scalebitrate | 1 |
| 27 | scalebitrate | 1 |
| 28 | scalebitrate | 1 |
| 29 | scalebitrate | 1 |
| 48 | scalebitrate | 1 |
| 47 | scalebitrate | 1 |
| 46 | scalebitrate | 1 |
| 49 | scalebitrate | 1 |
| 22 | encodingthreadcount | 1 |
| 5 | encodingthreadcount | 1 |
| 5 | mpeg2audbitratel3 | 192 |
| 5 | mpeg2language | 0 |
| 46 | encodingthreadcount | 1 |
| 47 | encodingthreadcount | 1 |
| 6 | encodingthreadcount | 1 |
| 6 | mpeg2audbitratel3 | 192 |
| 6 | mpeg2language | 0 |
| 7 | autotranscode | 1 |
| 7 | width | 720 |
| 7 | height | 480 |
| 7 | rtjpegquality | 170 |
| 7 | mpeg4bitrate | 2200 |
| 7 | mpeg4maxquality | 2 |
| 7 | mpeg4minquality | 15 |
| 7 | mpeg4qualdiff | 3 |
| 7 | scalebitrate | 1 |
| 7 | mpeg4optionvhq | 0 |
| 7 | mpeg4option4mv | 0 |
| 7 | mpeg4optionidct | 0 |
| 7 | mpeg4optionime | 0 |
| 7 | encodingthreadcount | 1 |
| 7 | mpeg2bitrate | 4500 |
| 7 | hardwaremjpegquality | 100 |
| 7 | hardwaremjpeghdecimation | 4 |
| 7 | hardwaremjpegvdecimation | 4 |
| 7 | mpeg2streamtype | MPEG-2 PS |
| 7 | mpeg2aspectratio | 4:3 |
| 7 | mpeg2maxbitrate | 6000 |
| 7 | samplerate | 48000 |
| 7 | mpeg2audtype | Layer II |
| 7 | mpeg2audbitratel1 | 448 |
| 7 | mpeg2audbitratel2 | 384 |
| 7 | mpeg2audbitratel3 | 192 |
| 7 | mpeg2language | 0 |
| 7 | mpeg2audvolume | 90 |
| 8 | autotranscode | 1 |
| 8 | width | 720 |
| 8 | height | 480 |
| 8 | rtjpegquality | 170 |
| 8 | mpeg4bitrate | 2200 |
| 8 | mpeg4maxquality | 2 |
| 8 | mpeg4minquality | 15 |
| 8 | mpeg4qualdiff | 3 |
| 8 | scalebitrate | 1 |
| 8 | mpeg4optionvhq | 0 |
| 8 | mpeg4option4mv | 0 |
| 8 | mpeg4optionidct | 0 |
| 8 | mpeg4optionime | 0 |
| 8 | encodingthreadcount | 1 |
| 8 | mpeg2bitrate | 4500 |
| 8 | hardwaremjpegquality | 100 |
| 8 | hardwaremjpeghdecimation | 4 |
| 8 | hardwaremjpegvdecimation | 4 |
| 8 | mpeg2streamtype | MPEG-2 PS |
| 8 | mpeg2aspectratio | 4:3 |
| 8 | mpeg2maxbitrate | 6000 |
| 8 | samplerate | 48000 |
| 8 | mpeg2audtype | Layer II |
| 8 | mpeg2audbitratel1 | 448 |
| 8 | mpeg2audbitratel2 | 384 |
| 8 | mpeg2audbitratel3 | 192 |
| 8 | mpeg2language | 0 |
| 8 | mpeg2audvolume | 90 |
| 49 | encodingthreadcount | 1 |
+---------+--------------------------+-----------+
461 rows in set (0.09 sec)
|
Code: |
mysql> SELECT * FROM settings where value like '%job%';
+-----------------------------+---------------+-----------+
| value | data | hostname |
+-----------------------------+---------------+-----------+
| JobQueueMaxSimultaneousJobs | 1 | mythtvbox |
| JobQueueCheckFrequency | 300 | mythtvbox |
| JobQueueWindowStart | 02:00 | mythtvbox |
| JobQueueWindowEnd | 10:00 | mythtvbox |
| JobQueueCPU | 0 | mythtvbox |
| JobAllowCommFlag | 1 | mythtvbox |
| JobAllowTranscode | 1 | mythtvbox |
| JobAllowUserJob1 | 1 | mythtvbox |
| JobAllowUserJob2 | 1 | mythtvbox |
| JobAllowUserJob3 | 1 | mythtvbox |
| JobAllowUserJob4 | 1 | mythtvbox |
| JobsRunOnRecordHost | 0 | NULL |
| JobQueueCommFlagCommand | mythcommflag | NULL |
| JobQueueTranscodeCommand | mythtranscode | NULL |
| UserJobDesc1 | User Job #1 | NULL |
| UserJob1 | | NULL |
| UserJobDesc2 | User Job #2 | NULL |
| UserJob2 | | NULL |
| UserJobDesc3 | User Job #3 | NULL |
| UserJob3 | | NULL |
| UserJobDesc4 | User Job #4 | NULL |
| UserJob4 | | NULL |
| AutoRunUserJob1 | 0 | NULL |
| AutoRunUserJob2 | 0 | NULL |
| AutoRunUserJob3 | 0 | NULL |
| AutoRunUserJob4 | 0 | NULL |
+-----------------------------+---------------+-----------+
26 rows in set (0.00 sec)
|
Code: |
mysql> SELECT * FROM record;
+----------+------+--------+-----------+------------+----------+------------+--------------------------+--------------------------+---------------------------------------------------------------------------------------------+----------------+---------+-------------+------------+-------------+-----------+-------------+-----------+----------+-----------+-------+----------+-----------+----------------+--------+---------------+--------------+--------------+--------------+--------------+--------------+---------+----------+--------+----------+----------+------------+-----------+-----------+-----------+---------------------+---------------------+---------------------+--------------+-----------+
| recordid | type | chanid | starttime | startdate | endtime | enddate | title | subtitle | description | category | profile | recpriority | autoexpire | maxepisodes | maxnewest | startoffset | endoffset | recgroup | dupmethod | dupin | station | seriesid | programid | search | autotranscode | autocommflag | autouserjob1 | autouserjob2 | autouserjob3 | autouserjob4 | findday | findtime | findid | inactive | parentid | transcoder | tsdefault | playgroup | prefinput | next_record | last_record | last_delete | storagegroup | avg_delay |
+----------+------+--------+-----------+------------+----------+------------+--------------------------+--------------------------+---------------------------------------------------------------------------------------------+----------------+---------+-------------+------------+-------------+-----------+-------------+-----------+----------+-----------+-------+----------+-----------+----------------+--------+---------------+--------------+--------------+--------------+--------------+--------------+---------+----------+--------+----------+----------+------------+-----------+-----------+-----------+---------------------+---------------------+---------------------+--------------+-----------+
| 25 | 10 | 1013 | 20:00:00 | 2008-07-04 | 21:00:00 | 2008-07-04 | Smallville | Wrath |
A battle between Lana and Lex.
| Action | Default | 10 | 0 | 0 | 0 | 0 | 0 | Default | 6 | 15 | 13CHM | 54092453 | | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 5 | 20:00:00 | 733592 | 0 | 0 | 27 | 1 | Default | 0 | 2009-03-13 20:00:00 | 2009-02-20 19:59:01 | 2009-02-21 15:43:16 | Default | 100 |
| 24 | 10 | 1013 | 00:00:00 | 2009-02-26 | 00:00:00 | 2009-02-26 | Everybody Hates Chris | Everybody Hates Bad Boys |
Julius is employee of the month.
| Sitcom | Default | 5 | 0 | 0 | 0 | 0 | 0 | Default | 6 | 15 | 13CHM | 43560115 | | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 16:30:00 | 0 | 0 | 0 | 27 | 1 | Default | 0 | 2009-03-08 20:30:00 | 2009-02-18 20:00:05 | 2009-02-27 18:53:58 | Default | 169 |
| 23 | 10 | 1006 | 00:00:00 | 2009-02-26 | 00:00:00 | 2009-02-26 | The Tudors | Episode 8 | The pope's envoy hears Henry's petition. | 0 | Default | -1 | 1 | 0 | 0 | 0 | 0 | Default | 6 | 15 | 6CBWT | 96344291 | | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 3 | 21:00:00 | 733829 | 0 | 0 | 27 | 1 | Default | 0 | 0000-00-00 00:00:00 | 2008-12-02 20:59:01 | 2008-12-07 10:43:00 | Default | 100 |
| 22 | 5 | 1034 | 12:00:00 | 2008-07-05 | 13:00:00 | 2008-07-05 | Daily Planet | |
Technology and nature.
| Nature | Default | -6 | 1 | 0 | 0 | 0 | 0 | Default | 6 | 15 | 7CKY | 31098740 | | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 12:00:00 | 733593 | 0 | 0 | 27 | 1 | Default | 0 | 0000-00-00 00:00:00 | 2009-02-21 11:59:01 | 2009-03-05 17:00:42 | Default | 144 |
| 21 | 10 | 1006 | 17:30:00 | 2008-07-05 | 23:00:00 | 2008-07-05 | Marketplace | |
Investigative consumer reports.
| | Default | 1 | 1 | 1 | 1 | 0 | 0 | Default | 6 | 15 | 6CBWT | 216444549 | | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 4 | 19:30:00 | 733590 | 0 | 0 | 27 | 1 | Default | 0 | 0000-00-00 00:00:00 | 2009-03-06 20:29:02 | 2009-03-01 11:04:17 | Default | 73 |
| 18 | 10 | 1006 | 20:00:00 | 2007-11-19 | 21:00:00 | 2007-11-19 | Dragon's Den | | Budding entrepreneurs pitch their ideas to wealthy investors. | Bus./financial | Default | -5 | 1 | 0 | 0 | 0 | 0 | Default | 6 | 15 | 6CBWT | 73217246 | | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 2 | 20:00:00 | 0 | 1 | 0 | 0 | 1 | Default | 0 | 0000-00-00 00:00:00 | 0000-00-00 00:00:00 | 0000-00-00 00:00:00 | Default | 100 |
| 27 | 5 | 1006 | 20:00:00 | 2009-02-24 | 20:30:00 | 2009-02-24 | Rick Mercer Report | | | Comedy | Default | -5 | 1 | 0 | 0 | 0 | 0 | Default | 6 | 15 | UNKNOWN6 | 63666052 | | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 3 | 20:00:00 | 733827 | 0 | 0 | 27 | 1 | Default | 0 | 0000-00-00 00:00:00 | 2009-02-24 20:26:06 | 2009-02-24 20:35:05 | Default | 57 |
| 28 | 10 | 1013 | 21:00:00 | 2008-03-05 | 22:00:00 | 2008-03-05 | Men in Trees | Sonata in Three Parts | Marin focuses on helping Cash. | Drama | Default | 5 | 0 | 2 | 0 | 0 | 0 | Default | 6 | 15 | 13CHM | 90672323 | | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 6 | 19:00:00 | 733369 | 0 | 0 | 0 | 1 | Default | 0 | 0000-00-00 00:00:00 | 2008-06-11 20:59:01 | 2008-07-08 16:29:20 | Default | 100 |
| 258 | 10 | 1013 | 00:00:00 | 2009-02-26 | 00:00:00 | 2009-02-26 | Crusoe | Hour 6 - Long Pig | Cannibals arrive on the island. | Drama | Default | 1 | 1 | 0 | 0 | 0 | 0 | Default | 6 | 15 | 13CHM | 78236245 | | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 6 | 21:00:00 | 0 | 0 | 0 | 27 | 1 | Default | 0 | 2009-03-15 22:00:00 | 2009-02-27 21:08:06 | 2009-02-27 21:16:43 | Default | 77 |
| 263 | 3 | 1009 | 00:00:00 | 2009-02-26 | 00:00:00 | 2009-02-26 | Seinfeld | The Chaperone | Kramer chaperons Jerry's date. | Sitcom | Default | -1 | 1 | 6 | 0 | 0 | 0 | Default | 6 | 2 | | 201641908 | | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 13:30:00 | 0 | 0 | 0 | 27 | 1 | Default | 0 | 0000-00-00 00:00:00 | 2009-02-15 14:00:03 | 2009-02-20 17:09:37 | Default | 100 |
| 47 | 3 | 1009 | 19:00:00 | 2008-01-14 | 20:00:00 | 2008-01-14 | Prison Break | Boxed In | Michael is in solitary. | Adventure | Default | 10 | 0 | 0 | 0 | 1 | 0 | Default | 6 | 15 | | 87064859 | | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 2 | 19:00:00 | 733421 | 0 | 0 | 27 | 1 | Default | 0 | 0000-00-00 00:00:00 | 2008-12-22 19:58:01 | 2009-01-02 11:10:09 | Default | 100 |
| 61 | 10 | 1013 | 23:30:00 | 2009-02-05 | 00:00:00 | 2009-02-06 | Reviews on the Run | | Reviews of the current gaming systems. | How-to | Default | 0 | 1 | 0 | 0 | 0 | 0 | Default | 6 | 15 | 13CHM | 20772366 | | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 5 | 16:30:00 | 733808 | 0 | 0 | 27 | 1 | Default | 0 | 0000-00-00 00:00:00 | 2009-02-28 16:59:01 | 2009-03-05 17:01:30 | Default | 101 |
| 265 | 3 | 1009 | 00:00:00 | 2009-02-26 | 00:00:00 | 2009-02-26 | That '70s Show | That Disco Episode | Gang visits a disco. | Sitcom | Default | 0 | 1 | 10 | 0 | 0 | 0 | Default | 6 | 2 | | 164868711 | | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 00:00:00 | 0 | 0 | 0 | 27 | 1 | Default | 0 | 0000-00-00 00:00:00 | 2009-02-20 00:30:03 | 2009-03-01 18:03:18 | Default | 199 |
| 99 | 10 | 1013 | 18:00:00 | 2009-02-14 | 18:30:00 | 2009-02-14 | Prairie Farm Report | Inventions | | Bus./financial | Default | -5 | 1 | 0 | 0 | 0 | 0 | Default | 6 | 31 | 13CHM | 88667844 | | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 1 | 12:30:00 | 733811 | 0 | 0 | 27 | 1 | Default | 0 | 0000-00-00 00:00:00 | 2009-02-08 12:29:01 | 2009-02-08 17:19:36 | Default | 100 |
| 132 | 10 | 1013 | 04:00:00 | 2009-02-06 | 05:00:00 | 2009-02-06 | The Lab With Leo Laporte | | Leo Laporte solves computer troubles and answers gadget questions. | | Default | 0 | 1 | 0 | 0 | 0 | 0 | Default | 6 | 15 | 13CHM | 171998581 | | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 1 | 07:00:00 | 733804 | 1 | 0 | 27 | 1 | Default | 0 | 0000-00-00 00:00:00 | 2009-02-02 03:59:01 | 2009-02-05 18:55:25 | Default | 100 |
| 283 | 1 | 6 | 07:30:00 | 2009-03-07 | 07:45:00 | 2009-03-07 | Animal Mechanicals | | The Animal Mechanicals and their missions. | Children | Default | 0 | 1 | 0 | 0 | 0 | -5 | Default | 6 | 15 | 6 | 244919971 | SH010792750000 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 07:30:00 | 733838 | 0 | 0 | 27 | 1 | Default | 0 | 0000-00-00 00:00:00 | 2009-03-07 07:33:03 | 2009-03-07 08:46:27 | Default | 57 |
+----------+------+--------+-----------+------------+----------+------------+--------------------------+--------------------------+---------------------------------------------------------------------------------------------+----------------+---------+-------------+------------+-------------+-----------+-------------+-----------+----------+-----------+-------+----------+-----------+----------------+--------+---------------+--------------+--------------+--------------+--------------+--------------+---------+----------+--------+----------+----------+------------+-----------+-----------+-----------+---------------------+---------------------+---------------------+--------------+-----------+
34 rows in set (0.00 sec)
|
Note: setting "job options" to transcode programs works.
Thanks,
/Jason
Last edited by umproko5 on Sat Mar 07, 2009 6:04 pm; edited 1 time in total |
|
Back to top |
|
|
eduardhc Tux's lil' helper
Joined: 25 Jan 2007 Posts: 97
|
Posted: Sat Mar 07, 2009 5:43 pm Post subject: |
|
|
H
I don't see any problem here. You say that setting job options to "transcode program" works? This is the way I always use transcoding, at least. I've never managed )never tried, in fact) to configure the backend to automatically transcode every recording it does, even LiveTV ones. Is that what you are trying to do?
Anyone, the only difference I find with my computer is the JobsRunOnRecordHost setting, which I have set to 1.
I don't know if this can be of any help to you.
Regards, |
|
Back to top |
|
|
umproko5 n00b
Joined: 11 Aug 2005 Posts: 17
|
Posted: Sat Mar 07, 2009 5:58 pm Post subject: |
|
|
I will try the JobsRunOnRecordHost setting.
Can you try auto transcoding?
You set on a per recording basis,
Find a recording in "up coming recordings"
Choose a recording
select edit options
select post recording processing
the second option should be related to trancoding ... select trancode new recordings
select the "trancode using" option to something like HIgh Quality
Give that a try and see if it works for you.
I am contemplating about blowing away my DB and starting from scratch.
Thanks,
/Jason |
|
Back to top |
|
|
eduardhc Tux's lil' helper
Joined: 25 Jan 2007 Posts: 97
|
Posted: Sat Mar 07, 2009 6:20 pm Post subject: |
|
|
This is the way I always set up transcoding: when I schedule a show I manually configure post processing options for transcoding. This makes every show recorded from that schedule (i.e. when using "record always", etc... modes) to being transcoded automatically.
I mean, I've never needed to manually queue the job once recorded for transcoding, it just obeys what I've configured in schedule.
Anyway, the basic rules for transcoding to work are these (if I'm not missing something....):
· you must enable transcoding at host level (JobAllowTranscode setting, yet set to 1)
· you must have 'mtd' daemon running
· you must enable "autotranscoding" for the "Default" (or the one you use but, according to your record table this is) recording profile. This is set through mythfrontend in Setup -> TV Setup -> Recording. Configure the transcoding profiles inside "Transcoder", then enable autotranscoding for the "Default" profile of the card type you use (which should appear there).
· you must select the transcoding profile to use in post-processing options when scheduling
If and only if all these options are correctly configured will transcoding work for you...
Regards,
Eduard |
|
Back to top |
|
|
umproko5 n00b
Joined: 11 Aug 2005 Posts: 17
|
Posted: Sun Mar 08, 2009 1:35 pm Post subject: |
|
|
I deleted the database and reloaded a fresh template and the problem is resolved. Is there any easy way to import recorded programs? |
|
Back to top |
|
|
eduardhc Tux's lil' helper
Joined: 25 Jan 2007 Posts: 97
|
Posted: Sun Mar 08, 2009 3:24 pm Post subject: |
|
|
umproko5 wrote: | I deleted the database and reloaded a fresh template and the problem is resolved. Is there any easy way to import recorded programs? |
Well, if you backed up your previous database you could try to import 'recorded', 'recordedprogram' and 'oldrecorded' tables into your new database. This will more or less do the job, but ensure that your current channels have the same 'chanid' number than before.
I'm glad transcoding works for you now, anyway.
Regards,
Eduard |
|
Back to top |
|
|
|