#!/bin/bash

echo "----------------demo------------------"

#--------------------new--mysql--dockerfile----------

if [[ ! -e ./Dockerfile ]]; then

   cat  > ./Dockerfile <<\EOF

FROM docker.io/centos

MAINTAINER Mrchen  <@qq.com>

ENV DATA_DIR /var/lib/mysql

# Install Mariadb

RUN yum install -y mariadb mariadb-server

RUN yum clean all

ADD mysqld_charset.cnf /etc/my.cnf.d/

COPY scripts /scripts

RUN chmod +x /scripts/start

EXPOSE 

VOLUME ["/var/lib/mysql"]

CMD ["/bin/bash"]

ENTRYPOINT ["/scripts/start"]

EOF

else

echo "Docker 已经存在"

fi

#---------------new-mysql.config--------------------

if [[ ! -e ./mysqld_charset.cnf ]]; then

cat > ./mysqld_charset.cnf <<\EOF

[mysqld]

character_set_server=utf8

character_set_filesystem=utf8

collation-server=utf8_general_ci

init-connect='SET NAMES utf8'

init_connect='SET collation_connection = utf8_general_ci'

EOF

else

echo "mysqld.config 已存在！"

fi

#--------------new-start脚本---------------------

if [[ ! -d ./scripts  ]]; then

mkdir ./scripts && touch ./scripts/firstrun

cat > ./scripts/start <<\EOF

#!/bin/bash

ROOT_USER=${ROOT_USER:-admin}

ROOT_PASS=${ROOT_PASS:-}

#DB  user password

SQL_DB=${SQL_DB:-opsmanage}

DB_USER=${DB_USER:-chen}

DB_PASS=${DB_PASS:-}

MARIADB_NEW=true

run_maria() {

        # First install mariadb

        if [[ ! -d ${DATA_DIR}/mysql ]]; then

            echo "===> MariaDB not install..."

             echo "===> Initializing maria database... "

           mysql_install_db --user=mysql --ldata=${DATA_DIR}

        echo "===> System databases initialized..."

           # Start mariadb

        /usr/bin/mysqld_safe --user mysql > /dev/null >& &

         echo "===> Waiting for MariaDB to start..."

                STA=

        while [[ STA -ne  ]]; do

            printf "."

                        sleep

                        mysql -uroot -e "status" > /dev/null >&

                        STA=$?

                done

        echo "===> Start OK..."

                # . Create a localhost-only admin account

        mysql -u root -e "CREATE USER '$ROOT_USER'@'%' IDENTIFIED BY '$ROOT_PASS'"

      mysql -u root -e "CREATE USER '$ROOT_USER'@'localhost' IDENTIFIED BY '$ROOT_PASS'"

       mysql -u root -e "CREATE USER '$ROOT_USER'@'127.0.0.1' IDENTIFIED BY '$ROOT_PASS'"

       mysql -u root -e "GRANT ALL PRIVILEGES ON *.* TO '$DB_USER'@'%' WITH GRANT OPTION"

                mysql -u root -e "CREATE DATABASE $SQL_DB"

    mysql -u root -e "grant all privileges on $SQL_DB.* TO '$DB_USER'@'%' identified by '$DB_PASS'"

        echo "===> Create localhost completed..."

                # shutdown mariadb to wait for supervisor

                mysqladmin -u root shutdown

        else

        if [[ -e ${DATA_DIR}/mysql.sock ]]; then

            rm -f ${DATA_DIR}/mysql.sock

        fi

        MARIADB_NEW=false

                echo "===> Using an existing volume of MariaDB"

        fi

}

#

# When Startup Container script

#

if [[ -e /scripts/firstrun ]]; then

        # config mariadb

        run_maria

        rm /scripts/firstrun

else

        # Cleanup previous mariadb sockets

        if [[ -e ${DATA_DIR}/mysql.sock ]]; then

                rm -f ${DATA_DIR}/mysql.sock

        fi

fi

exec /usr/bin/mysqld_safe

EOF

else

echo "Dir scripts 已存在！"

fi

echo "----------mkdir----mysql-----DB----------------"

mkdir -p  /data/mysql

echo "------------------run_build--Dockerfile-----------------"

docker build -t python-mariadb:sql-v2  .

echo "------------------run_docker-Images-Mriadb---------------------------------"

docker   run  --name python-mariadb-v2   --privileged=true  -v /data/mysql:/var/lib/mysql   -p :      -d  python-mariadb:sql-v2