All machines (front and backend) store their setup settings in the database on the backend machine. If you have a frontend only machine like an xbox with no keyboard attached its hard to type stuff in on the setup dialogs. So the easiest way is to create an SQL command file and execute it to change the values directly. Here's how
Remember to backup your database first on the backend machine, either via webmin or knoppmyth menu | Backup.
Here's the main settings that I needed to change. Create a local file mythtv_setup.sql, copy and paste the SQL lines below and add any others you may need (most others can easily be done with the remote). Search and replace xebian% with the hostname you wish to modify (the % means any chars, if you use exact hostname change LIKE to =). Then replace the Set Data part of each line with the data pertinent to your system within quotes.
Go into Webmin | Servers | mythconverg | Execute SQL. Goto 'Select an SQL commands file to execute on database mythconverg' and select 'From Uploaded file'. Press Choose and select mythtv_setup.sql. Then Execute.
Code:
UPDATE settings SET data = '/myth/music' WHERE value = 'MusicLocation' and hostname LIKE 'xebian%';
UPDATE settings SET data = '/myth/video' WHERE value = 'VideoStartupDir' and hostname LIKE 'xebian%';
UPDATE settings SET data = '/myth/gallery' WHERE value = 'GalleryDir' and hostname LIKE 'xebian%';
UPDATE settings SET data = 'VideoArtworkDir' WHERE value = '/home/live/.mythtv/MythVideo' and hostname LIKE 'xebian%';
UPDATE settings SET data = '/mnt/cdrom:/mnt/camera' WHERE value = 'GalleryImportDirs' and hostname LIKE 'xebian%';
UPDATE settings SET data = '/dev/dsp' WHERE value = 'AudioDevice' and hostname LIKE 'xebian%';
UPDATE settings SET data = '/dev/dsp' WHERE value = 'AudioOutputDevice' and hostname LIKE 'xebian%';
UPDATE settings SET data = '/dev/dvd' WHERE value = 'DVDDeviceLocation' and hostname LIKE 'xebian%';
UPDATE settings SET data = 'mplayer dvd:// -dvd-device %d -fs -zoom -vo xv' WHERE value = 'DVDPlayerCommand' and hostname LIKE 'xebian%';
UPDATE settings SET data = '/dev/cdrom' WHERE value = 'CDDevice' and hostname LIKE 'xebian%';
UPDATE settings SET data = 'directory' WHERE value = 'TreeLevels' and hostname LIKE 'xebian%';
UPDATE settings SET data = 'ARTIST/ALBUM/TRACK_TITLE' WHERE value = 'NonID3FileNameFormat' and hostname LIKE 'xebian%';
UPDATE settings SET data = 'ARTIST/ALBUM/TRACK-TITLE' WHERE value = 'FilenameTemplate' and hostname LIKE 'xebian%';
UPDATE settings SET data = 'mplayer -fs -zoom -quiet -vo xv %s' WHERE value = 'VideoDefaultPlayer' and hostname LIKE 'xebian%';
UPDATE settings SET data = '640x480' WHERE value = 'TVVidModeResolution' and hostname LIKE 'xebian%';
UPDATE settings SET data = '0' WHERE value = 'AC3PassThru' and hostname LIKE 'xebian%';
UPDATE settings SET data = '100' WHERE value = 'MasterMixerVolume' and hostname LIKE 'xebian%';
UPDATE settings SET data = '100' WHERE value = 'PCMMixerVolume' and hostname LIKE 'xebian%';
UPDATE settings SET data = 'UKXX0215' WHERE value = 'locale' and hostname LIKE 'xebian%';
UPDATE settings SET data = 'YES' WHERE value = 'SIUnits' and hostname LIKE 'xebian%';
SELECT * FROM settings WHERE hostname LIKE 'xebian%';
If not running webmin then tsh using putty to the backend machine, login as root and do :-
# mysql
# mythconverg
# update settings ... (copy/paste all lines from mythtv_setup)
# quit
# /etc/init.d/mysql restart
You can always run just the SELECT line (last line) to check you got the hostname correct.
------------------------------------------------------------------
If you want to change any other settings here's a complete list
Code:
COMPLETE LIST OF FIELDS IN SETTINGS TABLE
value | data
+---------------------------+-------------
| Deinterlace | 0
| DeinterlaceFilter | linearblend
| CustomFilters |
| UseMPEG2Dec | 0
| RealtimePriority | 1
| UseVideoTimebase | 0
| DecodeExtraAudio | 1
| AspectOverride | 0
| PIPLocation | 0
| PlaybackExitPrompt | 0
| EndOfRecordingExitPrompt | 0
| ClearSavedPosition | 1
| AltClearSavedPosition | 1
| UseOutputPictureControls | 0
| CCBufferWarnings | 0
| UDPNotifyPort | 6948
| PlayBoxOrdering | 1
| PlayBoxEpisodeSort | Date
| GeneratePreviewPixmaps | 0
| PlaybackPreview | 1
| PlaybackPreviewLowCPU | 0
| PlaybackBoxStartInTitle | 1
| ShowGroupInfo | 0
| DisplayRecGroup | All Programs
| RememberRecGroup | 1
| UseCategoriesAsRecGroups | 0
| DispRecGroupAsAllProg | 0
| PVR350OutputEnable | 0
| PVR350VideoDev | /dev/video16
| PVR350EPGAlphaValue | 164
| PVR350InternalAudioOnly | 0
| FastForwardAmount | 30
| RewindAmount | 5
| SmartForward | 0
| StickyKeys | 0
| FFRewRepos | 1
| FFRewReverse | 1
| ExactSeeking | 0
| JumpAmount | 10
| AutoCommercialSkip | 0
| CommRewindAmount | 0
| CommNotifyAmount | 0
| TryUnflaggedSkip | 0
| VertScanPercentage | 0
| HorizScanPercentage | 0
| XScanDisplacement | 0
| YScanDisplacement | 0
| OSDTheme | blueosd
| OSDDisplayTime | 3
| OSDFont | FreeMono.ttf
| OSDCCFont | FreeMono.ttf
| OSDThemeFontSizeType | default
| CCBackground | 0
| DefaultCCMode | 0
| PersistentBrowseMode | 0
| ChannelOrdering | channum + 0
| SmartChannelChange | 0
| ChannelFormat | <num> <sign>
| LongChannelFormat | <num> <name>
| EPGFillType | 10
| EPGShowCategoryColors | 1
| EPGShowCategoryText | 1
| EPGScrollType | 1
| EPGShowChannelIcon | 1
| EPGShowFavorites | 0
| WatchTVGuide | 0
| chanPerPage | 5
| timePerPage | 4
| UnknownTitle | Unknown
| UnknownCategory | Unknown
| DefaultTVChannel | 3
| SelectChangesChannel | 0
| SelChangeRecThreshold | 16
| Theme | G.A.N.T.
| Style |
| ThemeFontSizeType | default
| RandomTheme | 0
| MenuTheme | Default
| GuiWidth | 0
| GuiHeight | 0
| GuiOffsetX | 0
| GuiOffsetY | 0
| GuiSizeForTV | 1
| HideMouseCursor | 1
| RunFrontendInWindow | 0
| UseVideoModes | 0
| GuiVidModeResolution | 640x480
| TVVidModeResolution | 640x480
| TVVidModeForceAspect | 0.0
| VidModeWidth0 | 0
| VidModeHeight0 | 0
| TVVidModeResolution0 | 320x240
| TVVidModeForceAspect0 | 0.0
| VidModeWidth1 | 0
| VidModeHeight1 | 0
| TVVidModeResolution1 | 320x240
| TVVidModeForceAspect1 | 0.0
| VidModeWidth2 | 0
| VidModeHeight2 | 0
| TVVidModeResolution2 | 320x240
| TVVidModeForceAspect2 | 0.0
| Language | EN
| DateFormat | ddd MMM d
| ShortDateFormat | M/d
| TimeFormat | h:mm AP
| QtFontSmall | 12
| QtFontMedium | 16
| QtFontBig | 25
| PlayBoxTransparency | 1
| PlayBoxShading | 0
| LCDEnable | 0
| LCDShowTime | 1
| LCDShowMenu | 1
| LCDShowMusic | 1
| LCDShowChannel | 1
| LCDShowVolume | 1
| LCDShowGeneric | 1
| LCDBacklightOn | 1
| LCDPopupTime | 5
| AudioOutputDevice | /dev/dsp
| AC3PassThru | 0
| AggressiveSoundcardBuffer | 0
| MythControlsVolume | 1
| MixerDevice | /dev/mixer
| MixerControl | PCM
| MasterMixerVolume | 100
| PCMMixerVolume | 100
| IndividualMuteControl | 0
| AllowQuitShutdown | 4
| NoPromptOnExit | 1
| HaltCommand | halt
| LircKeyPressedApp |
| UseArrowAccels | 1
| SetupPinCodeRequired | 0
| MonitorDrives | 0
| EnableXbox | 0
| LogPrintLevel | 8
| LogCleanEnabled | 0
| LogCleanPeriod | 14
| LogCleanDays | 14
| LogCleanMax | 30
| LogMaxCount | 100
| TVVidModeRefreshRate | 0
| TVVidModeRefreshRate0 | 0
| TVVidModeRefreshRate1 | 0
| TVVidModeRefreshRate2 | 0
| DVDDeviceLocation | /dev/dvd
| DVDOnInsertDVD | 2
| DVDPlayerCommand | mplayer dvd:// -dvd-device %d -fs -zoom -vo xv
| GalleryDir | /myth/gallery
| GalleryImportDirs | /mnt/cdrom:/mnt/camera
| GalleryMoviePlayerCmd | mplayer -fs %s
| SlideshowOpenGLTransition | none
| SlideshowTransition | none
| SlideshowBackground |
| SlideshowDelay | 5
| MusicLocation | /myth/music
| AudioDevice | /dev/dsp
| CDDevice | /dev/cdrom
| TreeLevels | directory
| NonID3FileNameFormat | ARTIST/ALBUM/TRACK_TITLE
| Ignore_ID3 | 1
| AutoLookupCD | 0
| KeyboardAccelerators | 1
| CDWriterEnabled | 1
| CDDiskSize | 1
| CDCreateDir | 0
| CDWriteSpeed | 0
| CDBlankType | fast
| PlayMode | none
| IntelliRatingWeight | 35
| IntelliPlayCountWeight | 25
| IntelliLastPlayWeight | 25
| IntelliRandomWeight | 15
| MusicShowRatings | 0
| ShowWholeTree | 1
| ListAsShuffled | 0
| VisualMode | Random
| VisualCycleOnSongChange | 0
| VisualModeDelay | 0
| VisualScaleWidth | 1
| VisualScaleHeight | 1
| ParanoiaLevel | Full
| FilenameTemplate | ARTIST/ALBUM/TRACK-TITLE
| TagSeparator | -
| NoWhitespace | 0
| PostCDRipScript |
| EjectCDAfterRipping | 1
| EncoderType | ogg
| DefaultRipQuality | 0
| Mp3UseVBR | 0
| VideoStartupDir | /myth/video
| VideoArtworkDir | /home/live/.mythtv/MythVideo
| VideoDefaultParentalLevel | 4
| VideoAggressivePC | 0
| VideoListUnknownFiletypes | 1
| VideoTreeNoDB | 0
| VideoNewBrowsable | 1
| Default MythVideo View | 1
| MovieListCommandLine | /usr/share/mythtv/mythvideo/scripts/imdb.pl -M tv=no;video=no
| MoviePosterCommandLine | /usr/share/mythtv/mythvideo/scripts/imdb.pl -P
| MovieDataCommandLine | /usr/share/mythtv/mythvideo/scripts/imdb.pl -D
| VideoGalleryColsPerPage | 4
| VideoGalleryRowsPerPage | 3
| VideoGallerySubtitle | 1
| VideoGalleryAspectRatio | 1
| VideoDefaultPlayer | mplayer -fs -zoom -quiet -vo xv %s
| locale | UKXX0215
| SIUnits | YES
| WeatherAggressiveLvl | 1
| VideoDefaultView | 0
| RepeatMode | all
| LastMusicPlaylistPush | 0
+---------------------------+-----------------------------------
View unanswered posts
View active topics
KnoppMyth 
Print view
Previous topic Next topic 
LinHES Home
Board index
FAQ
Search
Login 
Register
