summaryrefslogtreecommitdiffstats
path: root/Services/mariadb
diff options
context:
space:
mode:
authorstartxfr <clarue@startx.fr>2015-11-28 22:21:07 +0100
committerstartxfr <clarue@startx.fr>2015-11-28 22:21:07 +0100
commit73a7d45fe8fe7a69fd7689ce4d8283dc91f87fc9 (patch)
tree3faf37eda9e754b4dfe5afa9b6bf046c08580116 /Services/mariadb
parent7b3b27e440b076f7a599555eaf963e719caab080 (diff)
downloadphpmyadmin-73a7d45fe8fe7a69fd7689ce4d8283dc91f87fc9.tar.gz
phpmyadmin-73a7d45fe8fe7a69fd7689ce4d8283dc91f87fc9.tar.bz2
phpmyadmin-73a7d45fe8fe7a69fd7689ce4d8283dc91f87fc9.tar.xz
phpmyadmin-73a7d45fe8fe7a69fd7689ce4d8283dc91f87fc9.zip
finishing mariadb service
Diffstat (limited to 'Services/mariadb')
-rw-r--r--Services/mariadb/Dockerfile4
-rw-r--r--Services/mariadb/docker-compose.yml5
-rw-r--r--Services/mariadb/my.cnf49
-rw-r--r--Services/mariadb/run.sh139
-rw-r--r--Services/mariadb/sx/mariadb.sh178
-rw-r--r--Services/mariadb/sx/mariadb_run.sh21
6 files changed, 172 insertions, 224 deletions
diff --git a/Services/mariadb/Dockerfile b/Services/mariadb/Dockerfile
index fbeacce..09a7acb 100644
--- a/Services/mariadb/Dockerfile
+++ b/Services/mariadb/Dockerfile
@@ -21,9 +21,9 @@ RUN chmod 775 /bin/run.sh && \
mkdir $LOG_PATH && \
touch $STARTUPLOG && \
touch $DATA_PATH/.keep && \
- chown -R mariadb:mariadb $LOG_PATH $DATA_PATH $LOADSQL_PATH
+ chown -R mysql:mysql $LOG_PATH $DATA_PATH $LOADSQL_PATH
EXPOSE 3306
VOLUME [$DATA_PATH,$LOG_PATH]
-CMD ["/sx/run.sh"] \ No newline at end of file
+CMD ["/bin/run.sh"] \ No newline at end of file
diff --git a/Services/mariadb/docker-compose.yml b/Services/mariadb/docker-compose.yml
index b1f6807..f6a1143 100644
--- a/Services/mariadb/docker-compose.yml
+++ b/Services/mariadb/docker-compose.yml
@@ -10,6 +10,11 @@ server:
CONTAINER_TYPE: "service"
CONTAINER_SERVICE: "mariadb"
CONTAINER_INSTANCE: "sx-mariadb"
+ SERVER_NAME: "localhost"
+ MYSQL_ROOT_PASSWORD: "secretdemerde"
+ MYSQL_USER: "user-test"
+ MYSQL_PASSWORD: "pwd-test"
+ MYSQL_DATABASE: "db_test"
volumes:
- "/tmp/container/logs:/data/logs"
- "/tmp/container/mariadb:/data/mariadb" \ No newline at end of file
diff --git a/Services/mariadb/my.cnf b/Services/mariadb/my.cnf
index ac882ac..309cc10 100644
--- a/Services/mariadb/my.cnf
+++ b/Services/mariadb/my.cnf
@@ -1,29 +1,36 @@
[mysqld]
-datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
-# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0
-# Settings user and group are ignored when systemd is used.
-# If you need to run mysqld under a different user or group,
-# customize your systemd unit file for mysqld/mariadb according to the
-# instructions in http://fedoraproject.org/wiki/Systemd
-
-# Currently, there are mariadb and community-mysql packages in Fedora.
-# This particular config file is included in respective RPMs of both of them,
-# so the following settings are general and will be also used by both of them.
-# Otherwise the RPMs would be in conflict.
-# Settings for particular implementations like MariaDB are then
-# defined in appropriate sections; for MariaDB server in [mariadb] section in
-# /etc/my.cnf.d/server.cnf (part of mariadb-server).
-# It doesn't matter that we set these settings only for [mysqld] here,
-# because they will be read and used in mysqld_safe as well.
-log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
+[mariadb]
+pid-file=/var/run/mariadb/mariadb.pid
+
[mysqld_safe]
-#
-# include all files from the config directory
-#
-!includedir /etc/my.cnf.d
+[mysql]
+
+[mysql_upgrade]
+
+[mysqladmin]
+
+[mysqlbinlog]
+
+[mysqlcheck]
+
+[mysqldump]
+
+[mysqlimport]
+
+[mysqlshow]
+
+[mysqlslap]
+
+[client]
+
+[client-mariadb]
+
+[server]
+
+[embedded]
diff --git a/Services/mariadb/run.sh b/Services/mariadb/run.sh
index cd22b99..a2e4dfb 100644
--- a/Services/mariadb/run.sh
+++ b/Services/mariadb/run.sh
@@ -27,7 +27,7 @@ function display_container_mariadb_header {
echo "+====================================================="
echo "| Container : $HOSTNAME"
echo "| OS : $(</etc/redhat-release)"
- echo "| Engine : " mysql -V
+ echo "| Engine : $(mysql -V)"
if [ -v CONTAINER_TYPE ]; then
echo "| Type : $CONTAINER_TYPE"
fi
@@ -57,8 +57,138 @@ function display_container_mariadb_header {
# and start generating host keys
function begin_config {
echo "=> BEGIN MARIADB CONFIGURATION"
+ if [[ ! -d $DATA_PATH ]]; then
+ echo "log directory $DATA_PATH not found"
+ mkdir -p $DATA_PATH; chmod 0774 $DATA_PATH
+ echo "data directory $DATA_PATH CREATED"
+ else
+ echo "data directory $DATA_PATH EXIST"
+ fi
+ if [[ ! -d $LOG_PATH ]]; then
+ echo "log directory $LOG_PATH not found"
+ mkdir -p $LOG_PATH; chmod 0774 $LOG_PATH
+ echo "log directory $LOG_PATH CREATED"
+ else
+ echo "log directory $LOG_PATH EXIST"
+ fi
+ chmod 0774 $DATA_PATH $LOG_PATH;
+ chown mysql:mysql $DATA_PATH $LOG_PATH;
+ if [[ -d $LOADSQL_PATH ]]; then
+ echo "sql directory $LOADSQL_PATH EXIST"
+ chmod 0774 $LOADSQL_PATH;
+ chown mysql:mysql $LOADSQL_PATH
+ fi
+ VOLUME_HOME=$DATA_PATH/mysql
+ if [[ ! -d $VOLUME_HOME ]]; then
+ echo "mariadb directory is empty or uninitialized"
+ echo "Installing MariaDB in $DATA_PATH ..."
+ mysql_install_db > /dev/null 2>&1
+ chown mysql:mysql -R $DATA_PATH
+ echo "Installing MariaDB in $DATA_PATH is DONE !"
+ else
+ echo "mariadb directory is initialized"
+ echo "Reusing MariaDB in $DATA_PATH ..."
+ chown mysql:mysql -R $DATA_PATH
+ fi
+ echo "" >> $MY_CONF
+ echo "[mysqld]" >> $MY_CONF
+ echo "datadir=$DATA_PATH" >> $MY_CONF
+ echo "log-error=$LOG_PATH/mysqld.log" >> $MY_CONF
+ echo "" >> $MY_CONF
+ echo "[mariadb]" >> $MY_CONF
+ echo "log-error=$LOG_PATH/mariadb.log" >> $MY_CONF
+}
+
+function config_startserver {
+ echo "start database for initial setup"
+ /usr/bin/mysqld_safe > /dev/null 2>&1 &
+ RET=1
+ while [[ RET -ne 0 ]]; do
+ echo "- waiting for database response"
+ sleep 1
+ mysql -uroot -e "status" > /dev/null 2>&1
+ RET=$?
+ done
+}
+
+function config_stopserver {
+ echo "stop database after initial setup"
+ mysqladmin -uroot shutdown
+}
+
+
+function config_createadmin {
+ PASS=${MYSQL_ROOT_PASSWORD:-$(pwgen -s 12 1)}
+ _word=$( [ ${MYSQL_ROOT_PASSWORD} ] && echo "preset" || echo "random" )
+ echo "Creating MariaDB admin user with ${_word} password"
+ mysql -uroot -e "CREATE USER 'admin'@'%' IDENTIFIED BY '$PASS'"
+ mysql -uroot -e "GRANT ALL PRIVILEGES ON *.* TO 'admin'@'%' WITH GRANT OPTION"
+ echo ""
+ echo " +------------------------------------------------------"
+ echo " | You can now connect to this server using:"
+ echo " | user : admin"
+ echo " | password : $PASS"
+ echo " | shell : mysql -uadmin -p$PASS -h<host> -P<port>"
+ echo " +------------------------------------------------------"
+ echo ""
}
+function config_createuser {
+ if [[ -n "$MYSQL_USER" ]]; then
+ echo "Creating MariaDB $MYSQL_USER user with preset password"
+ mysql -uroot -e "CREATE USER '$MYSQL_USER'@'%' IDENTIFIED BY '$MYSQL_PASSWORD'"
+ mysql -uroot -e "GRANT ALL PRIVILEGES ON *.* TO '$MYSQL_USER'@'%' WITH GRANT OPTION"
+ echo ""
+ echo " +------------------------------------------------------"
+ echo " | You can now connect to this server using:"
+ echo " | user : $MYSQL_USER"
+ echo " | password : $MYSQL_PASSWORD"
+ echo " | shell : mysql -u$MYSQL_USER -p$MYSQL_PASSWORD -h<host> -P<port>"
+ echo " +------------------------------------------------------"
+ echo ""
+ fi
+}
+
+function config_createdatabase {
+ if [[ -n "$MYSQL_DATABASE" ]]; then
+ echo "processing database " $MYSQL_DATABASE
+ if [[ ! -d $DIR_DB_DATA/$MYSQL_DATABASE ]]; then
+ echo "database " $MYSQL_DATABASE " doesn't exist"
+ mysql -uroot -e "CREATE DATABASE $MYSQL_DATABASE DEFAULT CHARACTER SET utf8 DEFAULT COLLATE utf8_general_ci;"
+ echo "database " $MYSQL_DATABASE " CREATED"
+ else
+ echo "database " $MYSQL_DATABASE " already exist"
+ fi
+ else
+ echo "no database to create"
+ fi
+}
+
+function config_importsql {
+ if [[ -n "$LOADSQL_PATH" ]]; then
+ echo "import sql data into " $MYSQL_DATABASE
+ if [[ ! -d $LOADSQL_PATH ]]; then
+ SCHEMALIST=$(find $LOADSQL_PATH/schema-*.sql -type f -printf "%f\n")
+ for SCHEMAFILE in $SCHEMALIST; do
+ echo "SET NAMES utf8;"|cat - $LOADSQL_PATH/$SCHEMAFILE > /tmp/out && mv /tmp/out $LOADSQL_PATH/$SCHEMAFILE
+ echo -n "Creating schema " $SCHEMAFILE " ... "
+ mysql -uroot $MYSQL_DATABASE < $LOADSQL_PATH/$SCHEMAFILE
+ echo " DONE"
+ done
+ DATALIST=$(find $LOADSQL_PATH/data-*.sql -type f -printf "%f\n")
+ for DATAFILE in $DATALIST; do
+ echo "SET NAMES utf8;"|cat - $LOADSQL_PATH/$DATAFILE > /tmp/out && mv /tmp/out $LOADSQL_PATH/$DATAFILE
+ echo -n "Creating data " $DATAFILE " ... "
+ mysql -uroot $MYSQL_DATABASE < $LOADSQL_PATH/$DATAFILE
+ echo " DONE"
+ done
+ fi
+ else
+ echo "no sql data to import into " $MYSQL_DATABASE
+ fi
+}
+
+
# End configuration process just before starting daemon
function end_config {
echo "=> END MARIADB CONFIGURATION"
@@ -80,6 +210,11 @@ fi
check_mariadb_environment | tee -a $STARTUPLOG
display_container_mariadb_header | tee -a $STARTUPLOG
begin_config | tee -a $STARTUPLOG
+config_startserver | tee -a $STARTUPLOG
+config_createadmin | tee -a $STARTUPLOG
+config_createuser | tee -a $STARTUPLOG
+config_createdatabase | tee -a $STARTUPLOG
+config_importsql | tee -a $STARTUPLOG
+config_stopserver | tee -a $STARTUPLOG
end_config | tee -a $STARTUPLOG
-display_container_started | tee -a $STARTUPLOG
start_daemon | tee -a $STARTUPLOG
diff --git a/Services/mariadb/sx/mariadb.sh b/Services/mariadb/sx/mariadb.sh
deleted file mode 100644
index 7ff208e..0000000
--- a/Services/mariadb/sx/mariadb.sh
+++ /dev/null
@@ -1,178 +0,0 @@
-#!/bin/bash
-
-export TERM=dumb
-export logfile="/var/logs/mysql/mysqld.log"
-
-# Begin configuration before starting daemonized process
-# redirect mysql.log to /dev/stderr
-function begin_config {
- echo "=> Begin mariadb configuration for host $HOSTNAME"
- ln -s /dev/stderr $logfile
- if [ "$(ls -1 /var/lib/mysql | wc -l)" -le "3" ]; then
- echo "=> directory /var/lib/mysql is empty, start mysql installation ..."
- install_db
- else
- echo "=> data found in /var/lib/mysql, skip mysql installation ..."
- fi;
- if [ ! -f /var/lib/mysql/mysql.sock ]; then
- echo "=> mysqld is not running, start server ..."
- start_server
- else
- echo "=> mysqld is already running ..."
- fi;
- update_rootuser
-}
-
-# End configuration process just before starting daemon
-# stop output of mysql.log to /dev/stderr and create mysql.log file
-function end_config {
- stop_server
- rm $logfile
- touch $logfile
- echo "=> End mariadb configuration ..."
-}
-
-# Preform installation of database structure. Must be used when no
-# database is already set
-function install_db {
- echo "===> Installing mariadb databases ..."
- mysql_install_db -u mysql > /dev/null 2>&1
- chown -R mysql:mysql /var/lib/mysql
-}
-
-# Start the mysqld server in background. Used to perform config
-# against the database structure such as user creation
-function start_server {
- echo "===> Starting mariadb server ..."
- /usr/bin/mysqld_safe > /dev/null 2>&1 &
- sleep 8
-}
-
-# Stop the mysqld server running in background.
-function stop_server {
- echo "===> Stopping mariadb server ..."
- killall mysqld mysqld_safe
- sleep 8
-}
-
-# Start the mysqld server as a deamon and execute it inside
-# the running shell
-function start_daemon {
- echo "=> Starting mariadb daemon ..."
- exec /usr/libexec/mysqld
-}
-
-# Set new root password and grant permissions to all databases
-function update_rootuser {
- if [ "$mysql_newadminpwd" = "" ]; then
- export mysql_newadminpwd=$(pwgen 13 1);
- fi
- local n=$mysql_newadminpwd;
- echo "===> Update root user password and permission"
- mysqladmin -u root password $n
- mysql -u root -p$n -e "GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '$n' WITH GRANT OPTION; FLUSH PRIVILEGES;"
- unset mysql_newadminpwd;
- export MARIADB_ROOTPWD=$n;
- echo "========================================================================";
- echo "You can now connect to this MariaDB Server using the following credentials:";
- echo " ";
- echo " user type : administrator";
- echo " username : root";
- echo " password : $n";
- echo " ";
- echo " mysql -u root -p$n";
- echo "========================================================================";
- echo " ";
- return 0
-}
-
-# Find all sqlfiles in /tmp/ and import then using admin user
-function import_sqlfiles {
- local filedir=$1; local p=$MARIADB_ROOTPWD; local del=$2;
- if [ "$(ls -1 $filedir | wc -l)" -ge "1" ]; then
- echo "=> Found SQL files to import ..."
- for filename in "$filedir"; do
- import_sqlfile $filename $del
- done;
- fi;
- return 0
-}
-
-# Find all sqlfiles in /tmp/ and import then using admin user
-function import_sqlfile {
- local filename=$1; local p=$MARIADB_ROOTPWD; local del=$2;
- if [ -f "$filename" ]; then
- echo "===> Importing sql file : $filename"
- mysql -u root -p$p < $filename
- if [ "$del" = "delete"]; then
- rm -f $filename
- echo "====> Deleting $filename after import"
- fi;
- else
- echo "====> Could not find sql file $filename. Skip import..."
- fi;
- return 0
-}
-
-# Set new root password and grant permissions to all databases
-function create_userdb {
- local userdb="$1"; local pass="$2"; local p=$MARIADB_ROOTPWD;
- if [ "$pass" = "" ]; then
- local pass=$(pwgen 13 1);
- fi
- echo "===> Create new user $userdb with database $userdb"
- mysql -u root -p$p -e "CREATE USER '$userdb'@'%';SET PASSWORD FOR '$userdb'@'%' = PASSWORD('$pass');\
- CREATE USER '$userdb'@'localhost';SET PASSWORD FOR '$userdb'@'localhost' = PASSWORD('$pass');\
- DROP DATABASE IF EXISTS $userdb; \
- CREATE DATABASE $userdb DEFAULT CHARACTER SET utf8 DEFAULT COLLATE utf8_general_ci; \
- GRANT ALL PRIVILEGES ON $userdb.* TO '$userdb'@'%' IDENTIFIED BY '$pass'; \
- GRANT ALL PRIVILEGES ON $userdb.* TO '$userdb'@'localhost' IDENTIFIED BY '$pass'; \
- FLUSH PRIVILEGES;"
- echo "========================================================================";
- echo "You can now connect to this MariaDB Server using the following credentials:";
- echo " ";
- echo " user type : user ";
- echo " username : $userdb ";
- echo " password : $pass";
- echo " database : $userdb ";
- echo " ";
- echo " mysql -u $userdb -p$pass $userdb";
- echo "========================================================================";
- echo " ";
- return 0
-}
-
-# Set new root password and grant permissions to all databases
-function create_user {
- local user="$1"; local pass="$2"; local p=$MARIADB_ROOTPWD;
- if [ "$pass" = "" ]; then
- local pass=$(pwgen 13 1);
- fi
- echo "===> Create new user $user"
- mysql -u root -p$p -e "CREATE USER '$user'@'%';SET PASSWORD FOR '$user'@'%' = PASSWORD('$pass');\
- CREATE USER '$user'@'localhost';SET PASSWORD FOR '$user'@'localhost' = PASSWORD('$pass');"
- echo "========================================================================";
- echo "You can now connect to this MariaDB Server using the following credentials:";
- echo " ";
- echo " user type : user ";
- echo " username : $user ";
- echo " password : $pass ";
- echo " ";
- echo " mysql -u $user -p$pass";
- echo "========================================================================";
- echo " ";
- return 0
-}
-
-# Create a new database
-function create_db {
- local db=$1; local p=$MARIADB_ROOTPWD;
- echo "===> Create new database $db"
- mysql -u root -p$p -e "CREATE DATABASE $db DEFAULT CHARACTER SET utf8 DEFAULT COLLATE utf8_general_ci;";
- echo "===> New database $db CREATED"
- return 0
-}
-
-if [[ "$0" == *"mariadb.sh" && ! $1 = "" ]];then
- eval "$@";
-fi \ No newline at end of file
diff --git a/Services/mariadb/sx/mariadb_run.sh b/Services/mariadb/sx/mariadb_run.sh
deleted file mode 100644
index 7dcf9b2..0000000
--- a/Services/mariadb/sx/mariadb_run.sh
+++ /dev/null
@@ -1,21 +0,0 @@
-#!/bin/bash
-source /sx/mariadb.sh
-
-begin_config
-## if you wan't to add a new user with database
-#create_userdb 'dbuser1' 'password'
-## if you wan't to add a new user with database (generated password)
-#create_userdb 'dbuser2'
-## if you wan't to add a new user
-#create_user 'username' 'password'
-## if you wan't to add a new database
-#create_db 'dbname'
-## Execute an SQL request to get the user list
-#mysql -u root -p$MARIADB_ROOTPWD -e 'select user, host FROM mysql.user;'
-## Execute SQL scripts located into a directory
-#import_sqlfiles /tmp/sql/*.sql
-## Execute a single SQL script and delete it
-#import_sqlfile /tmp/sql/example.sql delete
-end_config
-
-start_daemon \ No newline at end of file