From cbf3f7376c4636354fcc6c3890a7d3965fc8d959 Mon Sep 17 00:00:00 2001
From: Jean-Marc Pigeon <jmp@safe.c>
Date: Fri, 14 Nov 2025 06:11:37 -0500
Subject: [PATCH] Adding admin user preset value

---
 sql/preset.sql         | 7 +++++++
 support/do_database.sh | 3 +++
 support/starting.sh    | 3 +++
 3 files changed, 13 insertions(+)

diff --git a/sql/preset.sql b/sql/preset.sql
index 4a95c22..0e8cb67 100644
--- a/sql/preset.sql
+++ b/sql/preset.sql
@@ -12,5 +12,12 @@
 /*	Creating the bare minimun user configuration	*/
 /*							*/
 /********************************************************/
+//root is the default preset admin
 INSERT INTO admins (email)
 	VALUES ('root@$DOMAINNAME');
+
+//inserting the mail account
+INSERT INTO emails (email,password)
+	VALUES ('root','$RPASS');
+
+
diff --git a/support/do_database.sh b/support/do_database.sh
index 9d0daa1..30cb9b0 100755
--- a/support/do_database.sh
+++ b/support/do_database.sh
@@ -98,6 +98,9 @@ case "$DB_TYPE" in
   esac
 #loading database definition
 if [ -n "$MSQL" ] ; then
+  echo "#--------------- Create Database ----------------" >> $SQLLOG
   cpp -P -D$DB_TYPE /usr/share/$APPNAME/sql/$APPNAME.sql| tee -a $SQLLOG | $MSQL
+  echo "#--------------- Set Preset value ---------------" >> $SQLLOG
   cpp -P -D$DB_TYPE /usr/share/$APPNAME/sql/preset.sql	| tee -a $SQLLOG | $MSQL
+  echo "#--------------- Init Process Completed ---------" >> $SQLLOG
   fi
diff --git a/support/starting.sh b/support/starting.sh
index 2765045..534e860 100755
--- a/support/starting.sh
+++ b/support/starting.sh
@@ -183,6 +183,9 @@ case "$DB_TYPE" in
     exit -3;
     ;;
   esac
+#extracting local configuration value
+export DOMAINNAME=`dnsdomainname`;
+export RPASS=`grep root /etc/shadow | cut -d':' -f2 |sed -e 's:\\\\$:\\\\\\\\$:g'`;
 }
 #----------------------------------------------------------------------
 #creating mailleur local certificat
-- 
2.47.3