| LinHES Forums http://forum.linhes.org/ |
|
| How to Edit Transcoder/Encoder bitrates via SSH http://forum.linhes.org/viewtopic.php?f=11&t=10577 |
Page 1 of 1 |
| Author: | rando [ Wed Jun 21, 2006 3:15 pm ] |
| Post subject: | How to Edit Transcoder/Encoder bitrates via SSH |
I'm not at home currently, but have SSH access to my mythbackend. I've got two PVR 150's in my system, and was wondering if there is a way to change the bitrate values in the recording profiles for them via SSH without having to actually be in front of my myth system. Are they just stored in a config file somewhere, or is it pretty messy to get in there and change my "medium" quality profile from 4500 down to 3000 or something like that? |
|
| Author: | tjc [ Wed Jun 21, 2006 6:02 pm ] |
| Post subject: | |
They're stored in the database so you can change them with the mysql command line client. |
|
| Author: | grante [ Mon Jun 26, 2006 9:48 am ] |
| Post subject: | |
tjc wrote: They're stored in the database so you can change them with the mysql command line client.
I would kill for a half-way usable way to change MythTV configuration. What I'd really prefer is text files I could edit, but any sort of mysql client would be better than using the MythTV GUI where I have to choose between fonts too small to read and fields/controls being off-screen. Entering text with nothing but a remote is also very un-fun. Having either a text-mode or a simple GUI-based (gtk would be my choice) mysql table-browser would be be wonderful. Has anybody found such a thing? |
|
| Author: | tjc [ Mon Jun 26, 2006 6:45 pm ] |
| Post subject: | |
The one in webmin is pretty usable for low volume stuff, I once added the missing subtitles for a whole series that way, cutting and pasting from one browser tab to another. For anyhting bigger or more complicated than that I tend to write or generate the appropriate SQL commands and feed them into mysql. |
|
| Author: | grante [ Wed Jun 28, 2006 2:17 pm ] |
| Post subject: | |
I tried mysql-query-browser, but that just seems to be a fancy SQL query editor. There doesn't seem to be a simple way of displaying the rows in a table and changing them. I'll look into webmin -- I didn't know it had a mysql table browser built into it. |
|
| Author: | grante [ Wed Jun 28, 2006 3:27 pm ] |
| Post subject: | |
The webmin mysql browser isn't too bad except for for the fact that the "settings" tables have no primary key, so webmin won't edit them. Where are frontend configuration/settings stored? |
|
| Author: | tjc [ Wed Jun 28, 2006 9:46 pm ] |
| Post subject: | |
Which ones? The ones you were asking about originally are in the recording profiles so those should work fine. A search of the forums should turn up the SQL needed to change a value in the settings table. Once you've browsed it using the table viewer, hit the return to table list link, then hit the Execute SQL button. That'll give you a nice entry screen where you can enter the command and keep a history. It's not perfect, but... |
|
| Author: | grante [ Thu Jun 29, 2006 9:33 am ] |
| Post subject: | |
tjc wrote: Which ones? Things like playback overscan, GUI size and offset, font sizes, guide settings, etc. Quote: The ones you were asking about originally are in the recording profiles so those should work fine. That was somebody else. I didn't mention any particular settings. Quote: A search of the forums should turn up the SQL needed to change a value in the settings table. I know enough SQL to come up with the commands to change items. I was just looking for something a bit easier/safer. Quote: Once you've browsed it using the table viewer, hit the return to table list link, then hit the Execute SQL button. That'll give you a nice entry screen where you can enter the command and keep a history. It's not perfect, but...
Is there any reason those tables can't have a primary key assigned? |
|
| Page 1 of 1 | All times are UTC - 6 hours |
| Powered by phpBB® Forum Software © phpBB Group http://www.phpbb.com/ |
|