eis

#!/bin/bash

# ----------------------------------------------------------------------------

# /var/install/bin/cui-phpmyadmin-tools-pma-user.sh

#

# Creation:     2007-01-22 starwarsfan

#

# Copyright (c) 2007-2013 The eisfair Team, <team(at)eisfair(dot)org>

# Maintained by Y. Schumann <yves(at)eisfair(dot)org>

#

# This program is free software; you can redistribute it and/or modify

# it under the terms of the GNU General Public License as published by

# the Free Software Foundation; either version 2 of the License, or

# (at your option) any later version.

# ----------------------------------------------------------------------------

​

#exec 2>/public/phpmyadmin-trace$$.log

#set -x

​

. /etc/config.d/phpmyadmin

. /var/install/include/eislib

​

mysql_data_dir=/var/lib/mysql

mysql_base_dir=/usr/local/mysql

​

​

​

# ----------------------------------------------------------------------------

# create the sql script and execute it

doDBOperation ()

{

    givenServernumber=$1

​

    # check if $givenServernumber is in range

    if [ "${givenServernumber}" -gt 0 -a "${givenServernumber}" -le "${PHPMYADMIN_SERVER_N}" ] ; then

​

        # check if entered server is active

        eval active='${PHPMYADMIN_SERVER_'${givenServernumber}'_ACTIVE}'

        if [ "${active}" = "yes" ] ; then

​

            # check if advanced features are activated

            eval advancedFeaturesActive='${PHPMYADMIN_SERVER_'${givenServernumber}'_ADVANCED_FEATURES}'

            if [ "${advancedFeaturesActive}" == "yes" ] ; then

                eval host='${PHPMYADMIN_SERVER_'${givenServernumber}'_HOST}'

                eval port='${PHPMYADMIN_SERVER_'${givenServernumber}'_PORT}'

                eval pmadb='${PHPMYADMIN_SERVER_'${givenServernumber}'_PMADB}'

                eval controluser='${PHPMYADMIN_SERVER_'${givenServernumber}'_CONTROLUSER}'

                eval controlpass='${PHPMYADMIN_SERVER_'${givenServernumber}'_CONTROLPASS}'

​

                mecho ""

                dbAdmin=`/var/install/bin/ask "Please enter name of DB admin for server '${host}': " "" "+"`

                mecho -n "Please enter password: "

                stty -echo

                read dbAdminPass

                stty echo

                mecho ""

                mecho "Please enter host from which the pma user accesses server '${host}'."

                pmaHost=`/var/install/bin/ask "Normally this should be the IP or FQDN of this machine: " "" "+"`

​

                mecho ""

                mecho -n "Setting rights for pma user '"

                mecho -n --info "${controluser}@${pmaHost}"

                mecho -n "' on server '"

                mecho -n --info "${host}"