#!/bin/sh

#-------------------------------------------------------------
# ClearOS 6 Fixes below here, bail if later
#-------------------------------------------------------------

[ -e /usr/lib/systemd/system/system-mariadb.service ] && exit 0

# Add critical tuning
#-------------------

CHECK=`grep "^innodb_buffer_pool_size=" /usr/clearos/sandbox/etc/my.cnf 2>/dev/null`
if [ -z "$CHECK" ]; then
    logger -p local6.notice -t installer "app-system-database-core - adding innodb_buffer_pool_size configuration default"
    sed -i -e "s/\[mysqld\]/\[mysqld]\ninnodb_buffer_pool_size=500M/" /usr/clearos/sandbox/etc/my.cnf

    /sbin/service system-mysqld restart
fi

# FIXME: remove in ClearOS 7
# Make sure old innodb parameters are not upgraded
#-------------------------------------------------

CHECK=`md5sum /usr/clearos/sandbox/etc/my.cnf 2>/dev/null | awk '{ print $1 }'`
if [ "$CHECK" = "68fc0ed9daf4a3935c1df44b0ee08a47" ]; then
    logger -p local6.notice -t installer "app-system-database-core - crystallizing old innodb configuration"
    echo "" >> /usr/clearos/sandbox/etc/my.cnf
fi

# FIXME: remove in ClearOS 7
# Reset ib_logfile - tracker #1226

if ( [ ! -e /var/clearos/system_database/state/ib_log_reset ] && [ -e /var/lib/system-mysql/ib_logfile0 ] ); then
    logger -p local6.notice -t installer "app-system-database-core - crystallizing ib_logfile"
    
    # Yes, twice
    /sbin/service system-mysqld stop >/dev/null 2>&1
    sleep 3
    /sbin/service system-mysqld stop >/dev/null 2>&1
    rm -f /var/lib/system-mysql/ib_logfile[01]

    # Yes, twice again
    /sbin/service system-mysqld start >/dev/null 2>&1
    sleep 3
    /sbin/service system-mysqld start >/dev/null 2>&1

    touch /var/clearos/system_database/state/ib_log_reset
fi
