From 4e95fc76770c8601123546151c0f8c1af8704e9c Mon Sep 17 00:00:00 2001
From: =?utf8?q?Zolt=C3=A1n=20Felleg?= <zoltan.felleg@userrendszerhaz.hu>
Date: Thu, 6 Jun 2024 10:52:53 +0200
Subject: [PATCH] Updated db2.in (added slycrm and slycpx users).

---
 sources/db2.in/c3d/firstboot/data/bashrc.db2  |  5 +++++
 .../db2.in/c3d/firstboot/data/chpasswd.data   |  2 ++
 .../c3d/firstboot/scripts/03_addusers.sh      |  5 +++++
 .../c3d/firstboot/scripts/20_setupdb2.sh      | 21 +++++++++++++++++++
 sources/db2.in/config                         |  2 +-
 5 files changed, 34 insertions(+), 1 deletion(-)
 create mode 100644 sources/db2.in/c3d/firstboot/data/bashrc.db2

diff --git a/sources/db2.in/c3d/firstboot/data/bashrc.db2 b/sources/db2.in/c3d/firstboot/data/bashrc.db2
new file mode 100644
index 0000000..9ba3285
--- /dev/null
+++ b/sources/db2.in/c3d/firstboot/data/bashrc.db2
@@ -0,0 +1,5 @@
+
+# The following three lines have been added by UDB DB2.
+if [ -f /home/db2admin/sqllib/db2profile ]; then
+    . /home/db2admin/sqllib/db2profile
+fi
diff --git a/sources/db2.in/c3d/firstboot/data/chpasswd.data b/sources/db2.in/c3d/firstboot/data/chpasswd.data
index 0331525..9b87a69 100644
--- a/sources/db2.in/c3d/firstboot/data/chpasswd.data
+++ b/sources/db2.in/c3d/firstboot/data/chpasswd.data
@@ -1,2 +1,4 @@
 db2admin:Passw@rd01
 db2fncd:Passw@rd01
+slycrm:Passw@rdcrm
+slycpx:Passw@rdcpx
diff --git a/sources/db2.in/c3d/firstboot/scripts/03_addusers.sh b/sources/db2.in/c3d/firstboot/scripts/03_addusers.sh
index 56ef62c..788634d 100755
--- a/sources/db2.in/c3d/firstboot/scripts/03_addusers.sh
+++ b/sources/db2.in/c3d/firstboot/scripts/03_addusers.sh
@@ -11,6 +11,11 @@ useradd --uid 11982 --gid 11982 db2admin
 groupadd --gid 13347 db2fgrp
 useradd --uid 13347 --gid 13347 db2fncd
 
+useradd --uid 14079 --user-group slycrm
+cat $DATA_PATH/bashrc.db2 >>/home/slycrm/.bashrc
+useradd --uid 17759 --user-group slycpx
+cat $DATA_PATH/bashrc.db2 >>/home/slycpx/.bashrc
+
 while read UP
 do
     echo $UP | chpasswd
diff --git a/sources/db2.in/c3d/firstboot/scripts/20_setupdb2.sh b/sources/db2.in/c3d/firstboot/scripts/20_setupdb2.sh
index d4992be..ce56fa6 100755
--- a/sources/db2.in/c3d/firstboot/scripts/20_setupdb2.sh
+++ b/sources/db2.in/c3d/firstboot/scripts/20_setupdb2.sh
@@ -8,3 +8,24 @@ DATA_PATH=$(realpath $REAL_PATH/../data)
 su --login db2admin --command "db2iauto -on db2admin"
 su --login db2admin --command "db2 update dbm cfg using diagsize 2"
 /usr/local/bin/catalog-objects.sh
+exit 0
+su --login db2admin --command "db2 connect to slycrm; \
+                               db2 revoke connect \
+                                   on database \
+                                   from public; \
+                               db2 grant dbadm \
+                                   with dataaccess \
+                                   without accessctrl \
+                                   on database \
+                                   to user slycrm;
+                               db2 terminate"
+su --login db2admin --command "db2 connect to slycpx; \
+                               db2 revoke connect \
+                                   on database \
+                                   from public; \
+                               db2 grant dbadm \
+                                   with dataaccess \
+                                   without accessctrl \
+                                   on database \
+                                   to user slycpx;
+                               db2 terminate"
diff --git a/sources/db2.in/config b/sources/db2.in/config
index ad30ede..8e79470 100644
--- a/sources/db2.in/config
+++ b/sources/db2.in/config
@@ -3,7 +3,7 @@ lxc.include = /usr/share/lxc/config/common.conf
 lxc.arch = x86_64
 lxc.uts.name = db2.in.useribm.hu
 lxc.rootfs.path = __CONTAINER_PATH__/rootfs
-lxc.mount.auto = proc:rw sys:ro
+lxc.mount.auto = cgroup proc sys
 lxc.mount.entry = __CONTAINER_FILESYSTEMS_PATH__ data none bind,create=dir 0 0
 
 lxc.net.0.type = veth
-- 
2.54.0