[mythtv-users] Recording profiles changed from Myth .11 to .12 - how to do a per backend profile?

cmisip cmisip at insightbb.com
Sun Oct 26 16:53:15 EST 2003


Just another FYI, I tried to dumb down the settings of the default
"Software Encoders" group to see if it is actually being used.  It is
indeed being used but only if there are no host specific profile
groups.   So mythtv is in fact using the host specific profile groups if
they are present but for some reason, the values it uses for Live TV and
Default are the default values (not the ones I entered).

I am trying now to restore my database to before I even created the host
specific profiles.


I used mysql to delete the entries you mentioned:
mysql> delete from profilegroups where id>6;
mysql> delete from recordingprofiles where profilegroup>6;
mysql> delete from codecparams where profile>22;


I attached a copy of the output of mysql.

In recordingprofiles ,I seem to have a lot of:

 27 | NULL         | MPEG-4     | MP3        |            0 |

Should I delete this? with "delete from recordingprofiles where id>22;"

I should have backed up the database before changing the profilegroups.
i hope i didn't hose it.

Thanks.









On Sun, 2003-10-26 at 15:40, Bruce Markey wrote: 
> cmisip wrote:
> > So there is no current workaround for actually telling the backends to
> > use the host specific profiles? 
> 
> I didn't quite parse this. The "(Create new profile group)"
> does intend to create host specific profiles. Once the bugs are
> fixed, or if you work around them for now, it will do what you
> need it to do.
> 
> >  I didn't need to reenter the host
> > specific profiles anyway to change resolutions at this time.  I think I
> > entered the correct values.  It would be nice to be able to do this
> > though without having to change profile names like you said in the
> > future.  
> 
> Perhaps I wasn't being clear enough that you did find a real
> bug and what I was suggesting was a temporary way I found to
> get around the bug until it is fixed.
> 
> If you do successfully create a new group for your slower
> machine's hostname and successfully set the parameters for
> that new group, your slower host should use those parameters.
> 
> --  bjm
> 
> 
> ______________________________________________________________________
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
-------------- next part --------------
mysql> select * from profilegroups;
+----+----------------------------------------------------------+-----------+------------+---------
| id | name                                                     | cardtype  | is_default | hostname
+----+----------------------------------------------------------+-----------+------------+---------
|  1 | Software Encoders (v4l based)                            | V4L       |          1 | NULL    
|  2 | MPEG-2 Encoders (PVR-250, PVR-350)                       | 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    
+----+----------------------------------------------------------+-----------+------------+---------
6 rows in set (0.00 sec)
 
mysql> select * from recordingprofiles;
+----+--------------+------------+------------+--------------+
| id | name         | videocodec | audiocodec | profilegroup |
+----+--------------+------------+------------+--------------+
|  1 | Default      | MPEG-4     | MP3        |            1 |
|  2 | Live TV      | MPEG-4     | MP3        |            1 |
|  3 | High Quality | RTjpeg     | MP3        |            1 |
|  4 | Low Quality  | RTjpeg     | MP3        |            1 |
|  5 | Default      | NULL       | NULL       |            2 |
|  6 | Live TV      | NULL       | NULL       |            2 |
|  7 | High Quality | NULL       | NULL       |            2 |
|  8 | Low Quality  | NULL       | NULL       |            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 | RTjpeg     | MP3        |            6 |
| 22 | MPEG2        | NULL       | NULL       |            6 |
| 27 | NULL         | MPEG-4     | MP3        |            0 |
| 62 | NULL         | MPEG-4     | MP3        |            0 |
| 61 | NULL         | MPEG-4     | MP3        |            0 |
| 32 | NULL         | MPEG-4     | MP3        |            0 |
| 33 | NULL         | MPEG-4     | MP3        |            0 |
| 38 | NULL         | MPEG-4     | MP3        |            0 |
| 39 | NULL         | MPEG-4     | MP3        |            0 |
| 56 | NULL         | MPEG-4     | MP3        |            0 |
| 55 | NULL         | MPEG-4     | MP3        |            0 |
| 48 | NULL         | MPEG-4     | MP3        |            0 |
| 49 | NULL         | MPEG-4     | MP3        |            0 |
| 50 | NULL         | MPEG-4     | MP3        |            0 |
+----+--------------+------------+------------+--------------+
34 rows in set (0.00 sec)
 
mysql> select * from codecparams;
+---------+--------------------------+-----------+
| profile | name                     | value     |
+---------+--------------------------+-----------+
|       3 | autotranscode            | 0         |
|       3 | width                    | 480       |
|       3 | height                   | 480       |
|       3 | rtjpegquality            | 170       |
|       3 | rtjpeglumafilter         | 0         |
|       3 | rtjpegchromafilter       | 0         |
|       3 | mpeg4bitrate             | 2200      |
|       3 | mpeg4maxquality          | 2         |
|       3 | mpeg4minquality          | 15        |
|       3 | mpeg4qualdiff            | 3         |
|       3 | mpeg4scalebitrate        | 1         |
|       3 | mpeg4optionvhq           | 0         |
|       3 | mpeg4option4mv           | 0         |
|       3 | hardwaremjpegquality     | 100       |
|       3 | hardwaremjpeghdecimation | 4         |
|       3 | hardwaremjpegvdecimation | 4         |
|       3 | mpeg2streamtype          | MPEG-2 PS |
|       3 | mpeg2aspectratio         | 4:3       |
|       3 | mpeg2bitrate             | 4500      |
|       3 | mpeg2maxbitrate          | 6000      |
|       3 | samplerate               | 32000     |
|       3 | mp3quality               | 7         |
|       3 | mpeg2audtype             | Layer II  |
|       3 | mpeg2audbitratel1        | 448       |
|       3 | mpeg2audbitratel2        | 384       |
|       3 | mpeg2audvolume           | 90        |
|       4 | autotranscode            | 0         |
|       4 | width                    | 480       |
|       4 | height                   | 480       |
|       4 | rtjpegquality            | 170       |
|       4 | rtjpeglumafilter         | 0         |
|       4 | rtjpegchromafilter       | 0         |
|       4 | mpeg4bitrate             | 2200      |
|       4 | mpeg4maxquality          | 2         |
|       4 | mpeg4minquality          | 15        |
|       4 | mpeg4qualdiff            | 3         |
|       4 | mpeg4scalebitrate        | 1         |
|       4 | mpeg4optionvhq           | 0         |
|       4 | mpeg4option4mv           | 0         |
|       4 | hardwaremjpegquality     | 100       |
|       4 | hardwaremjpeghdecimation | 4         |
|       4 | hardwaremjpegvdecimation | 4         |
|       4 | mpeg2streamtype          | MPEG-2 PS |
|       4 | mpeg2aspectratio         | 4:3       |
|       4 | mpeg2bitrate             | 4500      |
|       4 | mpeg2maxbitrate          | 6000      |
|       4 | samplerate               | 32000     |
|       4 | mp3quality               | 7         |
|       4 | mpeg2audtype             | Layer II  |
|       4 | mpeg2audbitratel1        | 448       |
|       4 | mpeg2audbitratel2        | 384       |
|       4 | mpeg2audvolume           | 90        |
|       1 | autotranscode            | 0         |
|       1 | width                    | 480       |
|       1 | height                   | 480       |
|       1 | rtjpegquality            | 170       |
|       1 | rtjpeglumafilter         | 0         |
|       1 | rtjpegchromafilter       | 0         |
|       1 | mpeg4bitrate             | 2200      |
|       1 | mpeg4maxquality          | 2         |
|       1 | mpeg4minquality          | 15        |
|       1 | mpeg4qualdiff            | 3         |
|       1 | mpeg4scalebitrate        | 0         |
|       1 | mpeg4optionvhq           | 0         |
|       1 | mpeg4option4mv           | 0         |
|       1 | hardwaremjpegquality     | 100       |
|       1 | hardwaremjpeghdecimation | 4         |
|       1 | hardwaremjpegvdecimation | 4         |
|       1 | mpeg2streamtype          | MPEG-2 PS |
|       1 | mpeg2aspectratio         | 4:3       |
|       1 | mpeg2bitrate             | 4500      |
|       1 | mpeg2maxbitrate          | 6000      |
|       1 | samplerate               | 32000     |
|       1 | mp3quality               | 1         |
|       1 | mpeg2audtype             | Layer II  |
|       1 | mpeg2audbitratel1        | 448       |
|       1 | mpeg2audbitratel2        | 384       |
|       1 | mpeg2audvolume           | 90        |
|       2 | autotranscode            | 0         |
|       2 | width                    | 480       |
|       2 | height                   | 480       |
|       2 | rtjpegquality            | 170       |
|       2 | rtjpeglumafilter         | 0         |
|       2 | rtjpegchromafilter       | 0         |
|       2 | mpeg4bitrate             | 2200      |
|       2 | mpeg4maxquality          | 2         |
|       2 | mpeg4minquality          | 15        |
|       2 | mpeg4qualdiff            | 3         |
|       2 | mpeg4scalebitrate        | 0         |
|       2 | mpeg4optionvhq           | 0         |
|       2 | mpeg4option4mv           | 0         |
|       2 | hardwaremjpegquality     | 100       |
|       2 | hardwaremjpeghdecimation | 4         |
|       2 | hardwaremjpegvdecimation | 4         |
|       2 | mpeg2streamtype          | MPEG-2 PS |
|       2 | mpeg2aspectratio         | 4:3       |
|       2 | mpeg2bitrate             | 4500      |
|       2 | mpeg2maxbitrate          | 6000      |
|       2 | samplerate               | 32000     |
|       2 | mp3quality               | 1         |
|       2 | mpeg2audtype             | Layer II  |
|       2 | mpeg2audbitratel1        | 448       |
|       2 | mpeg2audbitratel2        | 384       |
|       2 | mpeg2audvolume           | 90        |
|      21 | autotranscode            | 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 | 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 | mpeg2audtype             | Layer II  |
|      21 | mpeg2audbitratel1        | 448       |
|      21 | mpeg2audbitratel2        | 384       |
|      21 | mpeg2audvolume           | 90        |
+---------+--------------------------+-----------+
130 rows in set (0.03 sec)
 
mysql>






More information about the mythtv-users mailing list