diff options
Diffstat (limited to 'linhes/linhes-templates/templates/db/custom.sql')
| -rw-r--r-- | linhes/linhes-templates/templates/db/custom.sql | 69 |
1 files changed, 37 insertions, 32 deletions
diff --git a/linhes/linhes-templates/templates/db/custom.sql b/linhes/linhes-templates/templates/db/custom.sql index 9be8ab0..8928c53 100644 --- a/linhes/linhes-templates/templates/db/custom.sql +++ b/linhes/linhes-templates/templates/db/custom.sql @@ -3,23 +3,46 @@ DELETE from settings where value in ( 'AllowQuitShutdown', 'AllowConnFromAll', + 'AllowLinkLocal', 'ListenOnAllIps', + 'BackendServerAddr', 'BackendServerIP', 'BackendServerIP6', + 'BackendServerPort', + 'BackendStatusPort', 'HaltCommand', 'RebootCommand', - 'Theme' - ); + 'Theme', + 'OverrideExitMenu', + 'NetworkControlEnabled', + 'SecurityPin', + 'BackendStopCommand', + 'BackendStartCommand', + 'MasterServerIP', + 'MasterServerName', + 'MasterServerPort'); 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'); + ('AllowQuitShutdown' ,'4' , 'apheleia'), + ('AllowConnFromAll' ,'0' , 'apheleia'), + ('AllowLinkLocal' ,'0' , 'apheleia'), + ('ListenOnAllIps' ,'0' , 'apheleia'), + ('BackendServerAddr' ,'127.0.0.1' , 'apheleia'), + ('BackendServerIP' ,'127.0.0.1' , 'apheleia'), + ('BackendServerIP6' ,'::1' , 'apheleia'), + ('BackendServerPort' ,'6543' , 'apheleia'), + ('BackendStatusPort' ,'6544' , 'apheleia'), + ('HaltCommand' ,'sudo /bin/halt' , 'apheleia'), + ('RebootCommand' ,'sudo /bin/reboot' , 'apheleia'), + ('Theme' ,'LinHES' , 'apheleia'), + ('OverrideExitMenu' ,'3' , 'apheleia'), + ('NetworkControlEnabled' ,'1' , 'apheleia'), + ('SecurityPin' ,'0000' , 'apheleia'), + ('BackendStopCommand' ,'sudo systemctl stop mythbackend.service' ,NULL), + ('BackendStartCommand' ,'sudo systemctl start mythbackend.service' ,NULL), + ('MasterServerIP' ,'127.0.0.1' ,NULL), + ('MasterServerName' ,'apheleia' ,NULL), + ('MasterServerPort' ,'6543' ,NULL); -- --INSERT INTO `settings` (`value`, `data`, `hostname`) VALUES @@ -61,22 +84,6 @@ INSERT INTO `storagegroup` (`groupname`, `hostname`, `dirname`) VALUES ('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', @@ -90,7 +97,8 @@ DELETE FROM `settings` where value in 'UserJobDesc1', 'UserJobDesc2', 'UserJobDesc3', - 'UserJobDesc4'); + 'UserJobDesc4', + 'MiscStatusScript'); INSERT INTO `settings` (`value`, `data`, `hostname`) VALUES @@ -105,13 +113,10 @@ INSERT INTO `settings` (`value`, `data`, `hostname`) VALUES ('UserJobDesc1','Copy to Videos','apheleia'), ('UserJobDesc2','Encode to x264 mkv','apheleia'), ('UserJobDesc3','Encode Audio to mp3','apheleia'), - ('UserJobDesc4','','apheleia'); + ('UserJobDesc4','','apheleia'), + ('MiscStatusScript','/usr/bin/misc_status_info.sh','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 and videosource so BE will at least start |