#!/bin/bash
#===========================
# UMVIRT LINUX FROM SCRATCH 
#===========================
# Compilation script.
# Network mode. 
#===========================
# Release: 0.1
# Package: mariadb-server
#===========================
# DB commit: d35a620850806ab581b32cb34d268a904c9c0a5f
# APP commit: 1ca4178aea919e4c9e869e3d650ff8af9678bd6f
#===========================

echo "ULFS Package installation start"
echo "==============================="
echo "Package: mariadb-server" 
echo "Release: 0.1" 

echo "checking config file"
if [ -f $ULFS_CONFIG_FILE ]
then
echo "loading config file $ULFS_CONFIG_FILE..."
. $ULFS_CONFIG_FILE
fi
#Creating log directory
mkdir -p /var/log/ulfs-packages/mariadb-server/
#Saving start timestamp
date +%s > /var/log/ulfs-packages/mariadb-server/start.time
#Going to source directory...
cd /sources
#Checking dependances...
      #Checking cmake...
      if [ ! -f /var/cache/ulfs-packages/cmake ]; then
           echo "Dependance \"cmake\" not found. Trying to install...";
           wget --no-check-certificate https://umvirt.com/linux/packages//0.1/cmake/install -O - | bash
           if [ ! -f /var/cache/ulfs-packages/cmake ]; then
	             echo "Dependance \"cmake\" is not installed. Exiting..."
               exit
           fi
      fi
      #Checking blfs-systemd-units...
      if [ ! -f /var/cache/ulfs-packages/blfs-systemd-units ]; then
           echo "Dependance \"blfs-systemd-units\" not found. Trying to install...";
           wget --no-check-certificate https://umvirt.com/linux/packages//0.1/blfs-systemd-units/install -O - | bash
           if [ ! -f /var/cache/ulfs-packages/blfs-systemd-units ]; then
	             echo "Dependance \"blfs-systemd-units\" is not installed. Exiting..."
               exit
           fi
      fi
      #Checking libevent...
      if [ ! -f /var/cache/ulfs-packages/libevent ]; then
           echo "Dependance \"libevent\" not found. Trying to install...";
           wget --no-check-certificate https://umvirt.com/linux/packages//0.1/libevent/install -O - | bash
           if [ ! -f /var/cache/ulfs-packages/libevent ]; then
	             echo "Dependance \"libevent\" is not installed. Exiting..."
               exit
           fi
      fi
#Saving downloading timestamp
date +%s > /var/log/ulfs-packages/mariadb-server/download.time
#Downloading source package archive...
wget --no-check-certificate -nc https://umvirt.com/linux/downloads/0.1/packages/m/mariadb-10.4.7.tar.gz.md5sum
wget --no-check-certificate -nc https://umvirt.com/linux/downloads/0.1/packages/m/mariadb-10.4.7.tar.gz
#Checking source package file existance
if [ ! -f mariadb-10.4.7.tar.gz ]; then
echo "Error: Can't find mariadb-10.4.7.tar.gz. Exiting!"
exit
fi
#Checking source package file checksum
if [ -f mariadb-10.4.7.tar.gz.md5sum ]; then
    MD5=`LANG=C md5sum -c mariadb-10.4.7.tar.gz.md5sum | grep OK`
    if [ "$MD5" == "" ] ; then
    echo "Error: Checksum of mariadb-10.4.7.tar.gz is wrong. Exiting!"
    exit
    fi
fi
    #Saving cleanup timestamp
    date +%s > /var/log/ulfs-packages/mariadb-server/cleanup.time
rm -rfv /sources/mariadb-10.4.7/
#Saving extracting timestamp
date +%s > /var/log/ulfs-packages/mariadb-server/unpack.time
#Extracting tar source package archive with default parameters...
tar -xf mariadb-10.4.7.tar.gz
#Checking package directory size after unpack...
du -s mariadb-10.4.7 | awk 'NR==1 {print $1}' > /var/log/ulfs-packages/mariadb-server/unpack.size 
#Going to source package directory...
cd mariadb-10.4.7
#Saving configuration timestamp
date +%s > /var/log/ulfs-packages/mariadb-server/configure.time
#Sleep 1 second
sleep 1
#Running configuration script...
groupadd -g 40 mysql &&
useradd -c "MySQL Server" -d /srv/mysql -g mysql -s /bin/false -u 40 mysql

sed -i "s@data/test@\\${INSTALL_MYSQLTESTDIR}@g" sql/CMakeLists.txt &&

mkdir build &&
cd build    &&

cmake -DCMAKE_BUILD_TYPE=Release                      \
      -DCMAKE_INSTALL_PREFIX=/usr                     \
      -DINSTALL_DOCDIR=share/doc/mariadb-10.3.9       \
      -DINSTALL_DOCREADMEDIR=share/doc/mariadb-10.3.9 \
      -DINSTALL_MANDIR=share/man                      \
      -DINSTALL_MYSQLSHAREDIR=share/mysql             \
      -DINSTALL_MYSQLTESTDIR=share/mysql/test         \
      -DINSTALL_PLUGINDIR=lib/mysql/plugin            \
      -DINSTALL_SBINDIR=sbin                          \
      -DINSTALL_SCRIPTDIR=bin                         \
      -DINSTALL_SQLBENCHDIR=share/mysql/bench         \
      -DINSTALL_SUPPORTFILESDIR=share/mysql           \
      -DMYSQL_DATADIR=/srv/mysql                      \
      -DMYSQL_UNIX_ADDR=/run/mysqld/mysqld.sock       \
      -DWITH_EXTRA_CHARSETS=complex                   \
      -DWITH_EMBEDDED_SERVER=ON                       \
      -DSKIP_TESTS=ON                                 \
      -DTOKUDB_OK=0                                   \
      .. 
#Saving build timestamp
date +%s > /var/log/ulfs-packages/mariadb-server/build.time
#Running build script...
make
#Saving install timestamp
date +%s > /var/log/ulfs-packages/mariadb-server/install.time
#Running install script...
cat > ulfs_install.sh << EOIS
make install

install -v -dm 755 /etc/mysql &&
cat > /etc/mysql/my.cnf << "EOF"
# Begin /etc/mysql/my.cnf

# The following options will be passed to all MySQL clients
[client]
#password       = your_password
port            = 3306
socket          = /run/mysqld/mysqld.sock

# The MySQL server
[mysqld]
port            = 3306
socket          = /run/mysqld/mysqld.sock
datadir         = /srv/mysql
skip-external-locking
key_buffer_size = 16M
max_allowed_packet = 1M
sort_buffer_size = 512K
net_buffer_length = 16K
myisam_sort_buffer_size = 8M

# Don't listen on a TCP/IP port at all.
skip-networking

# required unique id between 1 and 2^32 - 1
server-id       = 1

# Uncomment the following if you are using BDB tables
#bdb_cache_size = 4M
#bdb_max_lock = 10000

# InnoDB tables are now used by default
innodb_data_home_dir = /srv/mysql
innodb_log_group_home_dir = /srv/mysql
# All the innodb_xxx values below are the default ones:
innodb_data_file_path = ibdata1:12M:autoextend
# You can set .._buffer_pool_size up to 50 - 80 %
# of RAM but beware of setting memory usage too high
innodb_buffer_pool_size = 128M
innodb_log_file_size = 48M
innodb_log_buffer_size = 16M
innodb_flush_log_at_trx_commit = 1
innodb_lock_wait_timeout = 50

[mysqldump]
quick
max_allowed_packet = 16M

[mysql]
no-auto-rehash
# Remove the next comment character if you are not familiar with SQL
#safe-updates

[isamchk]
key_buffer = 20M
sort_buffer_size = 20M
read_buffer = 2M
write_buffer = 2M

[myisamchk]
key_buffer_size = 20M
sort_buffer_size = 20M
read_buffer = 2M
write_buffer = 2M

[mysqlhotcopy]
interactive-timeout

# End /etc/mysql/my.cnf
EOF

mysql_install_db --basedir=/usr --datadir=/srv/mysql --user=mysql &&
chown -R mysql:mysql /srv/mysql

install -v -m755 -o mysql -g mysql -d /run/mysqld
EOIS
USER=`whoami`
if [ "$USER" == "root" ] ; then 
cat ulfs_install.sh | bash 2>&1 | tee /var/log/ulfs-packages/mariadb-server/install.log 
else
cat ulfs_install.sh | sudo bash 2>&1 | tee /var/log/ulfs-packages/mariadb-server/install.log 
fi
#Saving finish timestamp
date +%s > /var/log/ulfs-packages/mariadb-server/finish.time
#Checking package directory size after unpack...
cd /sources 
du -s mariadb-10.4.7 | awk 'NR==1 {print $1}' > /var/log/ulfs-packages/mariadb-server/install.size 
echo "ULFS package installation completed."
#Producing files list
echo "Looking for installed files..."
if [  -f /var/log/ulfs-packages/mariadb-server/files.txt ]; then
rm /var/log/ulfs-packages/mariadb-server/files.txt
fi
USER=`whoami`
if [ "$USER" == "root" ] ; then 
find /bin -type f -newer /var/log/ulfs-packages/mariadb-server/configure.time \! -newer /var/log/ulfs-packages/mariadb-server/finish.time >> /var/log/ulfs-packages/mariadb-server/files.txt
find /sbin -type f -newer /var/log/ulfs-packages/mariadb-server/configure.time \! -newer /var/log/ulfs-packages/mariadb-server/finish.time >> /var/log/ulfs-packages/mariadb-server/files.txt
find /usr -type f -newer /var/log/ulfs-packages/mariadb-server/configure.time \! -newer /var/log/ulfs-packages/mariadb-server/finish.time >> /var/log/ulfs-packages/mariadb-server/files.txt
find /etc -type f -newer /var/log/ulfs-packages/mariadb-server/configure.time \! -newer /var/log/ulfs-packages/mariadb-server/finish.time >> /var/log/ulfs-packages/mariadb-server/files.txt
find /opt -type f -newer /var/log/ulfs-packages/mariadb-server/configure.time \! -newer /var/log/ulfs-packages/mariadb-server/finish.time >> /var/log/ulfs-packages/mariadb-server/files.txt
find /lib -type f -newer /var/log/ulfs-packages/mariadb-server/configure.time \! -newer /var/log/ulfs-packages/mariadb-server/finish.time >> /var/log/ulfs-packages/mariadb-server/files.txt
find /lib64 -type f -newer /var/log/ulfs-packages/mariadb-server/configure.time \! -newer /var/log/ulfs-packages/mariadb-server/finish.time >> /var/log/ulfs-packages/mariadb-server/files.txt
find /var -type f -newer /var/log/ulfs-packages/mariadb-server/configure.time \! -newer /var/log/ulfs-packages/mariadb-server/finish.time \! -path "/var/log/ulfs-packages/mariadb-server/*" >> /var/log/ulfs-packages/mariadb-server/files.txt
else
sudo find /bin -type f -newer /var/log/ulfs-packages/mariadb-server/configure.time \! -newer /var/log/ulfs-packages/mariadb-server/finish.time >> /var/log/ulfs-packages/mariadb-server/files.txt
sudo find /sbin -type f -newer /var/log/ulfs-packages/mariadb-server/configure.time \! -newer /var/log/ulfs-packages/mariadb-server/finish.time >> /var/log/ulfs-packages/mariadb-server/files.txt
sudo find /usr -type f -newer /var/log/ulfs-packages/mariadb-server/configure.time \! -newer /var/log/ulfs-packages/mariadb-server/finish.time >> /var/log/ulfs-packages/mariadb-server/files.txt
sudo find /etc -type f -newer /var/log/ulfs-packages/mariadb-server/configure.time \! -newer /var/log/ulfs-packages/mariadb-server/finish.time >> /var/log/ulfs-packages/mariadb-server/files.txt
sudo find /opt -type f -newer /var/log/ulfs-packages/mariadb-server/configure.time \! -newer /var/log/ulfs-packages/mariadb-server/finish.time >> /var/log/ulfs-packages/mariadb-server/files.txt
sudo find /lib -type f -newer /var/log/ulfs-packages/mariadb-server/configure.time \! -newer /var/log/ulfs-packages/mariadb-server/finish.time >> /var/log/ulfs-packages/mariadb-server/files.txt
sudo find /lib64 -type f -newer /var/log/ulfs-packages/mariadb-server/configure.time \! -newer /var/log/ulfs-packages/mariadb-server/finish.time >> /var/log/ulfs-packages/mariadb-server/files.txt
sudo find /var -type f -newer /var/log/ulfs-packages/mariadb-server/configure.time \! -newer /var/log/ulfs-packages/mariadb-server/finish.time \!  -path "/var/log/ulfs-packages/mariadb-server/*" >> /var/log/ulfs-packages/mariadb-server/files.txt
fi
#Marking package as installed...
mkdir -p /var/cache/ulfs-packages
USER=`whoami`
if [ "$USER" == "root" ] ; then 
touch /var/cache/ulfs-packages/mariadb-server
else
sudo touch /var/cache/ulfs-packages/mariadb-server
fi
#Calculate delta size
a=`cat /var/log/ulfs-packages/mariadb-server/unpack.size`
b=`cat /var/log/ulfs-packages/mariadb-server/install.size`
c=$(($b-$a))
echo $c > /var/log/ulfs-packages/mariadb-server/delta.size 
#Calculate prepare time
a=`cat /var/log/ulfs-packages/mariadb-server/start.time`
b=`cat /var/log/ulfs-packages/mariadb-server/configure.time`
dp=$(($b-$a))
#Calculate download time
a=`cat /var/log/ulfs-packages/mariadb-server/download.time`
b=`cat /var/log/ulfs-packages/mariadb-server/unpack.time`
dd=$(($b-$a))
#Calculate delta time
a=`cat /var/log/ulfs-packages/mariadb-server/configure.time`
b=`cat /var/log/ulfs-packages/mariadb-server/finish.time`
db=$(($b-$a))
echo $db > /var/log/ulfs-packages/mariadb-server/delta.time 
#Report
echo ""
echo "ULFS Package installation report"
echo "================================"
echo "Package: mariadb-server" 
echo "Release: 0.1" 
echo "Build size: $c" 
echo "Prepare time: $dp sec." 
echo "Download time: $dd sec." 
echo "Build time: $db sec." 

#End of script