From c64dbc4c4d4f4152c569f0bce2f0eb8290e2e525 Mon Sep 17 00:00:00 2001 From: Britney Fransen Date: Sun, 12 Apr 2026 11:52:42 -0400 Subject: linhes-templates: custom.sql: add settings needed for mythbackend v36 to start after install --- linhes/linhes-templates/PKGBUILD | 4 +- linhes/linhes-templates/templates/db/custom.sql | 71 +++++++++++++------------ 2 files changed, 39 insertions(+), 36 deletions(-) diff --git a/linhes/linhes-templates/PKGBUILD b/linhes/linhes-templates/PKGBUILD index fde8d9b..96f74d7 100644 --- a/linhes/linhes-templates/PKGBUILD +++ b/linhes/linhes-templates/PKGBUILD @@ -1,13 +1,13 @@ pkgname=linhes-templates pkgver=9.0.0 -pkgrel=17 +pkgrel=19 conflicts=() pkgdesc="Templates used for LinHES system configuration" depends=() makedepends=() arch=('x86_64') source=(templates.tar.gz) -sha256sums=('1889a59f9e7534328f371c663a83ccaf0a4962930711057f6e185695948f2006') +sha256sums=('3144255b6861af8041c511316341f6eb2d95e6d2d2d45f0696618d2eb4c63cb1') package() { MVDIR=$pkgdir/usr/share/linhes diff --git a/linhes/linhes-templates/templates/db/custom.sql b/linhes/linhes-templates/templates/db/custom.sql index 07b9add..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,24 +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', - 'MasterServerIP'); - -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), -('MasterServerIP','127.0.0.1' ,NULL); --- - -- Clear out old user jobs DELETE FROM `settings` where value in ('JobAllowUserJob1', @@ -92,7 +97,8 @@ DELETE FROM `settings` where value in 'UserJobDesc1', 'UserJobDesc2', 'UserJobDesc3', - 'UserJobDesc4'); + 'UserJobDesc4', + 'MiscStatusScript'); INSERT INTO `settings` (`value`, `data`, `hostname`) VALUES @@ -107,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 -- cgit v0.12