937684478679eb2fa4ef180017a0bc8ed762f0ac
max
  Mon Oct 18 08:39:48 2021 -0700
fixing GBIC on newer linux distributions that use Mysql 8 by default now, refs #28348

diff --git src/product/installer/browserSetup.sh src/product/installer/browserSetup.sh
index 869b57f..06738c3 100755
--- src/product/installer/browserSetup.sh
+++ src/product/installer/browserSetup.sh
@@ -717,33 +717,35 @@
     # psxy is not that important, we just skip it for now
     #yum -y install GMT hdf5 --disablerepo=rpmforge
     
     if [ -f /etc/init.d/iptables ]; then
        echo2 Opening port 80 for incoming connections to Apache
        waitKey
        iptables -I INPUT 1 -p tcp --dport 80 -j ACCEPT
        iptables -I INPUT 1 -p tcp --dport 443 -j ACCEPT
        service iptables save
        service iptables restart
     fi
     
     # MYSQL INSTALL ON REDHAT, quite involved, as MariaDB is increasingly the default
 
     # centos7 provides only a package called mariadb-server
-    if yum list mysql-server 2> /dev/null ; then
-        MYSQLPKG=mysql-server
-    elif yum list mariadb-server 2> /dev/null ; then
+    # Mysql 8 does not allow copying MYISAM files anymore into the DB. 
+    # -> we cannot support Mysql 8 anymore
+    #if yum list mysql-server 2> /dev/null ; then
+       #MYSQLPKG=mysql-server
+    if yum list mariadb-server 2> /dev/null ; then
         MYSQLPKG=mariadb-server
     else
         echo2 Cannot find a mysql-server package in the current yum repositories
         exit 100
     fi
     
     # even mariadb packages currently call their binary /usr/bin/mysqld_safe
     if [ ! -f /usr/bin/mysqld_safe ]; then
         echo2 
         echo2 Installing the Mysql or MariaDB server and make it start at boot.
         waitKey
 
         moveAwayMyCnf
         yum -y install $MYSQLPKG
     
@@ -999,31 +1001,34 @@
           service apache2 restart
         fi
     fi
 
     if [[ ! -f /usr/sbin/mysqld ]]; then
         echo2
         echo2 Now installing the Mysql server. 
         echo2 The root password will be set to a random string and will be written
         echo2 to the file /root/.my.cnf so root does not have to provide a password on
         echo2 the command line.
         waitKey
         moveAwayMyCnf
 
         # do not prompt in apt-get, will set an empty mysql root password
         export DEBIAN_FRONTEND=noninteractive
-        apt-get --assume-yes install mysql-server
+	# Debian / Ubuntu 20 defaults to Mysql 8 and Mysql 8 does not allow rsync of myisam anymore
+	# -> we require mariaDb now
+        # apt-get --assume-yes install mysql-server
+        apt-get --assume-yes install mariadb-server
         # make sure that missing values do not trigger errors, #18368
 	setMYCNF
         sed -i '/^.mysqld.$/a sql_mode=' $MYCNF
         # flag so script will set mysql root password later to a random value
         SET_MYSQL_ROOT=1
     fi
 
 }
 
 # download apache mysql libpng openssl into the current dir
 # and build them into $APACHEDIR/ext
 function buildApacheMysqlOpensslLibpng () 
 {
 echo2
 echo2 Now building cmake, openssl, pcre, apache and mysql into $APACHEDIR/ext