diff options
| author | Britney Fransen <brfransen@gmail.com> | 2022-12-07 21:41:59 (GMT) |
|---|---|---|
| committer | Britney Fransen <brfransen@gmail.com> | 2022-12-07 21:41:59 (GMT) |
| commit | dfd71a19b63b0784bff6ac79ccdf368650ec72ad (patch) | |
| tree | a5fd2272782b6b3311e078be1d56f17e78f958c0 | |
| parent | 6991e62328389fbbfd9b4d62041ab55af02901c4 (diff) | |
| download | linhes_pkgbuild-dfd71a19b63b0784bff6ac79ccdf368650ec72ad.zip linhes_pkgbuild-dfd71a19b63b0784bff6ac79ccdf368650ec72ad.tar.gz linhes_pkgbuild-dfd71a19b63b0784bff6ac79ccdf368650ec72ad.tar.bz2 | |
linhes-templates: add permissions.sql
| -rw-r--r-- | linhes/linhes-templates/PKGBUILD | 4 | ||||
| -rwxr-xr-x | linhes/linhes-templates/mp_preflight (renamed from linhes/linhes-templates/createTemplateSource.sh) | 3 | ||||
| -rw-r--r-- | linhes/linhes-templates/templates/db/permissions.sql | 9 |
3 files changed, 12 insertions, 4 deletions
diff --git a/linhes/linhes-templates/PKGBUILD b/linhes/linhes-templates/PKGBUILD index 6e93ca8..dc3af34 100644 --- a/linhes/linhes-templates/PKGBUILD +++ b/linhes/linhes-templates/PKGBUILD @@ -1,13 +1,13 @@ pkgname=linhes-templates pkgver=9.0.0 -pkgrel=5 +pkgrel=7 conflicts=() pkgdesc="Templates used for LinHES system configuration" depends=() makedepends=() arch=('x86_64') source=(templates.tar.gz) -sha256sums=('6d959c2c25d860b7e74d493900fa0de412975ab5652317dd442388db6ee97f83') +sha256sums=('08b953c8a1f90d4a7e94392d612b168c9d7eb98fb56d8b4ac5d614793aac16ef') package() { MVDIR=$pkgdir/usr/share/linhes diff --git a/linhes/linhes-templates/createTemplateSource.sh b/linhes/linhes-templates/mp_preflight index b18fe01..2017567 100755 --- a/linhes/linhes-templates/createTemplateSource.sh +++ b/linhes/linhes-templates/mp_preflight @@ -1,4 +1,3 @@ #!/usr/bin/bash -#run this before building the PKGBUILD - +echo " Starting mp_preflight" tar -czvf templates.tar.gz ./templates diff --git a/linhes/linhes-templates/templates/db/permissions.sql b/linhes/linhes-templates/templates/db/permissions.sql new file mode 100644 index 0000000..108a1ab --- /dev/null +++ b/linhes/linhes-templates/templates/db/permissions.sql @@ -0,0 +1,9 @@ +CREATE DATABASE IF NOT EXISTS mythconverg; +GRANT ALL ON mythconverg.* TO 'mythtv'@localhost IDENTIFIED BY 'mythtv'; +GRANT ALL ON mythconverg.* TO 'mythtv'@'%' IDENTIFIED BY 'mythtv'; +GRANT FILE ON *.* TO 'mythtv'@"%"; +FLUSH PRIVILEGES; +GRANT CREATE TEMPORARY TABLES ON mythconverg.* TO 'mythtv'@localhost IDENTIFIED BY 'mythtv'; +GRANT CREATE TEMPORARY TABLES ON mythconverg.* TO 'mythtv'@'%' IDENTIFIED BY 'mythtv'; +FLUSH PRIVILEGES; +ALTER DATABASE mythconverg DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci; |