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

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

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 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.2.2/libevent/install -O - | bash
           if [ ! -f /var/cache/ulfs-packages/libevent ]; then
	             echo "Dependance \"libevent\" is not installed. Exiting..."
               exit
           fi
      fi
      #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.2.2/cmake/install -O - | bash
           if [ ! -f /var/cache/ulfs-packages/cmake ]; then
	             echo "Dependance \"cmake\" 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.2.2/packages/m/mariadb-10.11.8.tar.gz.md5sum
wget --no-check-certificate -nc https://umvirt.com/linux/downloads/0.2.2/packages/m/mariadb-10.11.8.tar.gz
#Checking source package file existance
if [ ! -f mariadb-10.11.8.tar.gz ]; then
echo "Error: Can't find mariadb-10.11.8.tar.gz. Exiting!"
exit
fi
#Checking source package file checksum
if [ -f mariadb-10.11.8.tar.gz.md5sum ]; then
    MD5=`LANG=C md5sum -c mariadb-10.11.8.tar.gz.md5sum | grep OK`
    if [ "$MD5" == "" ] ; then
    echo "Error: Checksum of mariadb-10.11.8.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.11.8/
#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.11.8.tar.gz
#Checking package directory size after unpack...
du -s mariadb-10.11.8 | awk 'NR==1 {print $1}' > /var/log/ulfs-packages/mariadb-server/unpack.size 
#Going to source package directory...
cd mariadb-10.11.8
#Saving configuration timestamp
date +%s > /var/log/ulfs-packages/mariadb-server/configure.time
#Sleep 1 second
sleep 1
if [[ "$ULFS_PKG_DATERESET" == "YES" ]]
then
#Changing all files creation time (except build configuration files) in source directory to find them after installation
find /sources/mariadb-10.11.8 \! -path "*/configure*" \! -path "*/Makefile*" \! -path "*.make" \! -path "*.m4" \! -path "*.am" \! -path "*.mk" \! -path "*.stamp" \! -path "*gentpl.py"  -exec touch -m {} +
fi
#Running configuration script...
echo "checking config file"
if [ -f $ULFS_CONFIG_FILE ]
then
echo "loading config file $ULFS_CONFIG_FILE..."
. $ULFS_CONFIG_FILE
fi
cat > ulfs_configure.sh << EOIS
echo "Initializing distributed build environment... "
if [[ "\$ULFS_ICECC" == "YES" ]]
then
    export PATH="\$ULFS_ICECC_PATH:\$PATH"
    echo "ICECC"
fi

echo "Environment debug..."
echo "PATH: \$PATH"
echo "MAKEFLAGS: \$MAKEFLAGS"
echo "NINJAJOBS: \$NINJAJOBS"
env | grep ULFS


groupadd -g 40 mysql &&
useradd -c "MySQL Server" -d /srv/mysql -g mysql -s /bin/false -u 40 mysql

mkdir build &&
cd    build &&

cmake -D CMAKE_BUILD_TYPE=Release                       \\
      -D CMAKE_INSTALL_PREFIX=/usr                      \\
      -D GRN_LOG_PATH=/var/log/groonga.log              \\
      -D INSTALL_DOCDIR=share/doc/mariadb-10.11.8       \\
      -D INSTALL_DOCREADMEDIR=share/doc/mariadb-10.11.8 \\
      -D INSTALL_MANDIR=share/man                       \\
      -D INSTALL_MYSQLSHAREDIR=share/mysql              \\
      -D INSTALL_MYSQLTESTDIR=share/mysql/test          \\
      -D INSTALL_PAMDIR=lib/security                    \\
      -D INSTALL_PAMDATADIR=/etc/security               \\
      -D INSTALL_PLUGINDIR=lib/mysql/plugin             \\
      -D INSTALL_SBINDIR=sbin                           \\
      -D INSTALL_SCRIPTDIR=bin                          \\
      -D INSTALL_SQLBENCHDIR=share/mysql/bench          \\
      -D INSTALL_SUPPORTFILESDIR=share/mysql            \\
      -D MYSQL_DATADIR=/srv/mysql                       \\
      -D MYSQL_UNIX_ADDR=/run/mysqld/mysqld.sock        \\
      -D WITH_EXTRA_CHARSETS=complex                    \\
      -D WITH_EMBEDDED_SERVER=ON                        \\
      -D SKIP_TESTS=ON                                  \\
      -D TOKUDB_OK=0                                    \\
      ..
EOIS
cat ulfs_configure.sh | bash 2>&1 | tee /var/log/ulfs-packages/mariadb-server/configure.log 
#Saving build timestamp
date +%s > /var/log/ulfs-packages/mariadb-server/build.time
#Running build script...
echo "checking config file"
if [ -f $ULFS_CONFIG_FILE ]
then
echo "loading config file $ULFS_CONFIG_FILE..."
. $ULFS_CONFIG_FILE
fi
cat > ulfs_build.sh << EOIS
echo "Initializing distributed build environment... "
if [[ "\$ULFS_ICECC" == "YES" ]]
then
    export PATH="\$ULFS_ICECC_PATH:\$PATH"
    echo "ICECC"
fi

echo "Environment debug..."
echo "PATH: \$PATH"
echo "MAKEFLAGS: \$MAKEFLAGS"
echo "NINJAJOBS: \$NINJAJOBS"
env | grep ULFS


cd    build &&
make
EOIS
cat ulfs_build.sh | bash 2>&1 | tee /var/log/ulfs-packages/mariadb-server/build.log 
#Saving install timestamp
date +%s > /var/log/ulfs-packages/mariadb-server/install.time
#Running install script...
cat > ulfs_install.sh << EOIS
cd    build &&
make install

mv -v /usr/share/pam_use_map.so /lib/security &&
mv -v /usr/share/user_map.conf /etc/security

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.11.8 | 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
touch /var/cache/ulfs-packages/mariadb-server
else
sudo touch /var/cache/ulfs-packages/mariadb-server
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.2.2" 
echo "Build size: $c" 
echo "Prepare time: $dp sec." 
echo "Download time: $dd sec." 
echo "Build time: $db sec." 

#End of script