diff options
Diffstat (limited to 'linhes')
| -rw-r--r-- | linhes/linhes-templates/PKGBUILD | 4 | ||||
| -rw-r--r-- | linhes/linhes-templates/templates/db/custom.sql | 129 |
2 files changed, 131 insertions, 2 deletions
diff --git a/linhes/linhes-templates/PKGBUILD b/linhes/linhes-templates/PKGBUILD index 38d5be5..65abf49 100644 --- a/linhes/linhes-templates/PKGBUILD +++ b/linhes/linhes-templates/PKGBUILD @@ -1,13 +1,13 @@ pkgname=linhes-templates pkgver=9.0.0 -pkgrel=8 +pkgrel=9 conflicts=() pkgdesc="Templates used for LinHES system configuration" depends=() makedepends=() arch=('x86_64') source=(templates.tar.gz) -sha256sums=('5f849178d475842122a6dab667e6bba536c3d0513f016f45c1f8ea5338a14003') +sha256sums=('1eb6d7a26aab77e6e822db9f00dd621a45754085cc81d4790729f7a9007cfdea') package() { MVDIR=$pkgdir/usr/share/linhes diff --git a/linhes/linhes-templates/templates/db/custom.sql b/linhes/linhes-templates/templates/db/custom.sql new file mode 100644 index 0000000..1f91bae --- /dev/null +++ b/linhes/linhes-templates/templates/db/custom.sql @@ -0,0 +1,129 @@ +-- +DELETE FROM `settings` where `value`='HostMyhostname'; +-- +INSERT INTO `settings` (`value`,`data`,`hostname`) VALUES ('HostMyhostname','type_hostname_here','apheleia'); +-- + +-- Clear out old values because mysql is mysql +DELETE from settings where value in +( + 'AllowQuitShutdown', + 'AllowConnFromAll', + 'ListenOnAllIps', + 'BackendServerIP', + 'BackendServerIP6', + 'HaltCommand', + 'RebootCommand', + 'Theme' + ); + +INSERT INTO `settings` (`value`, `data`, `hostname`) VALUES + ('AllowQuitShutdown' ,'4' , 'apheleia'), + ('AllowConnFromAll' ,'0' , 'apheleia'), + ('ListenOnAllIps' ,'0' , 'apheleia'), + ('BackendServerIP' ,'127.0.0.1' , 'apheleia'), + ('BackendServerIP6' ,'::1' , 'apheleia'), + ('HaltCommand' ,'sudo /sbin/halt' , 'apheleia'), + ('RebootCommand' ,'sudo /sbin/reboot' , 'apheleia'), + ('Theme' ,'LinHES' , 'apheleia'), +-- + +--INSERT INTO `settings` (`value`, `data`, `hostname`) VALUES +-- ('NonID3FileNameFormat' ,'GENRE/ARTIST/ALBUM/TRACK_TITLE' , 'apheleia'), +-- ('CDDevice' ,'/dev/cdrom' , 'apheleia'), +-- ('MusicAudioDevice' ,'default' , 'apheleia'), +-- ('MythArchiveCopyRemoteFiles' ,'1' , 'apheleia'), +-- ('GalleryDir' ,'/myth/gallery' , 'apheleia'), +-- ('MusicLocation' ,'/myth/music/' , 'apheleia'), +-- ('mythgame.screenshotdir' ,'/myth/games/screenshots' , 'apheleia'), +-- ('mythgame.fanartdir' ,'/myth/games/fanart' , 'apheleia'), +-- ('mythgame.boxartdir' ,'/myth/games/boxart' , 'apheleia'), +-- ('MythArchiveTempDir' ,'/myth/tmp' , 'apheleia'); + + +-- MythVideo old local dir..replaced by storage groups, but should set values to null +INSERT INTO `settings` (`value`, `data`, `hostname`) VALUES +('VideoStartupDir' ,'' , 'apheleia'), +('mythvideo.TrailersDir' ,'' , 'apheleia'), +('VideoArtworkDir' ,'' , 'apheleia'), +('ScreenShotPath' ,'' , 'apheleia'), +('mythvideo.screenshotDir' ,'' , 'apheleia'), +('mythvideo.bannerDir' ,'' , 'apheleia'), +('mythvideo.fanartDir' ,'' , 'apheleia'); + + +-- /myth based storage groups are obsolete, add_storage.py will create the ones it needs. +INSERT INTO `storagegroup` (`groupname`, `hostname`, `dirname`) VALUES +-- ('Default' ,'apheleia' ,'/myth/tv/'), +-- ('LiveTV' ,'apheleia' ,'/myth/tv/live/'), +-- ('Videos' ,'apheleia' ,'/myth/video/'), +('Coverart' ,'apheleia' ,'/data/storage/disk0/media/artwork/coverart/'), +('Banners' ,'apheleia' ,'/data/storage/disk0/media/artwork/banners/'), +('Fanart' ,'apheleia' ,'/data/storage/disk0/media/artwork/fanart/'), +('Screenshots' ,'apheleia' ,'/data/storage/disk0/media/artwork/screenshots/'), +('Trailers' ,'apheleia' ,'/data/storage/disk0/media/artwork/trailers/'), +-- ('Streaming' ,'apheleia' ,'/myth/streaming'), +('DB Backups' ,'apheleia' ,'/data/storage/disk0/backup/mythtv_backups/'); + + +-- Clear out old values because mysql is mysql +DELETE from settings where value in +('OverrideExitMenu', + 'NetworkControlEnabled', + 'SecurityPin', + 'BackendStopCommand', + 'BackendStartCommand'); + +INSERT INTO `settings` (`value`, `data`, `hostname`) VALUES +('OverrideExitMenu','3','apheleia'), +('NetworkControlEnabled','1','apheleia'), +('SecurityPin','0000','apheleia'), +('BackendStopCommand','sudo systemctl stop mythbackend.service' ,NULL), +('BackendStartCommand','sudo systemctl start mythbackend.service' ,NULL); +-- + +-- Clear out old user jobs +DELETE FROM `settings` where value in +('JobAllowUserJob1', + 'JobAllowUserJob2', + 'JobAllowUserJob3', + 'JobAllowUserJob4', + 'UserJob1', + 'UserJob2', + 'UserJob3', + 'UserJob4', + 'UserJobDesc1', + 'UserJobDesc2', + 'UserJobDesc3', + 'UserJobDesc4'); + + +INSERT INTO `settings` (`value`, `data`, `hostname`) VALUES + ('JobAllowUserJob1','1','apheleia'), + ('JobAllowUserJob2','1','apheleia'), + ('JobAllowUserJob3','1','apheleia'), + ('JobAllowUserJob4','0','apheleia'), + ('UserJob1','/usr/bin/mythvidexport.py %JOBID%','apheleia'), + ('UserJob2','/usr/bin/myth2mkv "%DIR%/%FILE%" "%CHANID%" "%STARTTIME%" "%TITLE%" "%SUBTITLE%" "%JOBID%" "HP"','apheleia'), + ('UserJob3','/usr/bin/myth2mp3 "%DIR%/%FILE%" "%TITLE% - %SUBTITLE%" "%CHANID%" "%STARTTIME%"','apheleia'), + ('UserJob4','','apheleia'), + ('UserJobDesc1','Copy to Videos','apheleia'), + ('UserJobDesc2','Encode to x264 mkv','apheleia'), + ('UserJobDesc3','Encode Audio to mp3','apheleia'), + ('UserJobDesc4','','apheleia'); +-- + + + +INSERT INTO `settings` (`value`, `data`, `hostname`) VALUES +('MiscStatusScript','/usr/bin/misc_status_info.sh','apheleia'); + + +--UPDATE `keybindings` set `keylist` = "Alt+Esc" WHERE `action` = 'EXITPROMPT' ; + +-- Add a dummy tuner so BE will at least start +INSERT INTO `capturecard` (`videodevice`,`cardtype`,`defaultinput`,`hostname`,`sourceid`) VALUES +('file://tmp/demo.mpg' , 'DEMO', 'Television', 'apheleia', '1'); + +INSERT INTO `videosource` (`name`, `xmltvgrabber`) VALUES +('DEMO_VIDEO_SOURCE' , '/bin/true'); |