| 1 |
#!/bin/bash |
| 2 |
|
| 3 |
# autopkgtest check: Run the connectivity "mysql" test |
| 4 |
# and prepare the db needed beforehand |
| 5 |
# (c) 2021 Software in the Public Interest, Inc. |
| 6 |
# Authors: Rene Engelhard <[email protected]> |
| 7 |
|
| 8 |
SRCDIR=`pwd` |
| 9 |
CHECK_PARALLELISM=1 |
| 10 |
if [ -n "$AUTOPKGTEST_TMP" ]; then |
| 11 |
WORKDIR=`mktemp -q -d -p $AUTOPKGTEST_TMP` |
| 12 |
else |
| 13 |
WORKDIR=`mktemp -q -d` |
| 14 |
fi |
| 15 |
|
| 16 |
if [ -x /usr/bin/mariadbd-safe ]; then |
| 17 |
db=mariadb |
| 18 |
db_safe_command=mariadbd-safe |
| 19 |
db_rundir=/run/mysqld |
| 20 |
else |
| 21 |
db=mysql |
| 22 |
db_safe_command=mysqld_safe |
| 23 |
db_rundir=/var/run/mysqld |
| 24 |
fi |
| 25 |
db_user=root |
| 26 |
db_pw=`pwgen -1` |
| 27 |
db_name=test |
| 28 |
db_host=localhost |
| 29 |
db_port=3306 |
| 30 |
db_conn_string="$db_user/$db_pw@sdbc:mysql:mysqlc:$db_host:$db_port/$db_name" |
| 31 |
|
| 32 |
trap "cleanup" ERR |
| 33 |
|
| 34 |
if [ -f $AUTOPKGTEST_TMP/build-tests-skipped ]; then exit 77; fi |
| 35 |
|
| 36 |
function cleanup() { |
| 37 |
stop_db |
| 38 |
} |
| 39 |
|
| 40 |
function stop_db() { |
| 41 |
service $db stop || true |
| 42 |
# in case we are trying in a chroot without running autopkgtest for "quick" testing |
| 43 |
if ischroot && test -f $db_rundir/mysqld.pid; then |
| 44 |
kill `cat $db_rundir/mysqld.pid` |
| 45 |
fi |
| 46 |
} |
| 47 |
|
| 48 |
echo |
| 49 |
echo "====== Enabling core dumps ======" |
| 50 |
# yes, we want core dumps and stack traces |
| 51 |
ulimit -c unlimited || true |
| 52 |
|
| 53 |
echo "====== Resetting $db_user password ======" |
| 54 |
$db_safe_command --skip-grant-tables & |
| 55 |
sleep 5 # wait for startup |
| 56 |
if test "$db" = "mariadb"; then |
| 57 |
echo "FLUSH PRIVILEGES; SET PASSWORD FOR '$db_user'@'$db_host' = PASSWORD('$db_pw');" | \ |
| 58 |
$db -v -u $db_user mysql |
| 59 |
else |
| 60 |
echo "SET PASSWORD FOR '$db_user'@'$db_host' = '$db_pw'; FLUSH PRIVILEGES;" | \ |
| 61 |
$db -v -u $db_user mysql |
| 62 |
fi |
| 63 |
|
| 64 |
stop_db |
| 65 |
|
| 66 |
service $db start |
| 67 |
|
| 68 |
set -e |
| 69 |
|
| 70 |
echo |
| 71 |
echo "====== Creating database "$db_name" ======" |
| 72 |
echo "DROP DATABASE IF EXISTS $db_name; CREATE DATABASE $db_name;" | \ |
| 73 |
$db -v -u $db_user mysql |
| 74 |
|
| 75 |
# ensure we use the version from the package |
| 76 |
echo |
| 77 |
echo "====== Symlinking libraries... ======" |
| 78 |
#rene@frodo:~/LibreOffice/git/master$ objdump -p instdir/program/libmysqlclo.so | grep NEED |
| 79 |
# NEEDED libmariadb.so.3 |
| 80 |
# NEEDED libuno_cppu.so.3 |
| 81 |
# NEEDED libdbtoolslo.so |
| 82 |
# NEEDED libuno_sal.so.3 |
| 83 |
# NEEDED libuno_salhelpergcc3.so.3 |
| 84 |
# NEEDED libcomphelper.so |
| 85 |
# NEEDED libuno_cppuhelpergcc3.so.3 |
| 86 |
# NEEDED libstdc++.so.6 |
| 87 |
# NEEDED libm.so.6 |
| 88 |
# NEEDED libgcc_s.so.1 |
| 89 |
# NEEDED libpthread.so.0 |
| 90 |
# NEEDED libc.so.6 |
| 91 |
# VERNEED 0x0000000000004b28 |
| 92 |
# VERNEEDNUM 0x0000000000000007 |
| 93 |
cd $SRCDIR/instdir/program |
| 94 |
LIBS="libuno_cppu.so.3 libuno_sal.so.3 libuno_salhelpergcc3.so.3 libuno_cppuhelpergcc3.so.3 libmysqlclo.so" |
| 95 |
# FIXME: libdbtoolslo.so and libcomphelper.so are in libmerged.so with enable-mergelibs, thus do not |
| 96 |
# exist on 64bit... |
| 97 |
# Maybe until then this test shall only be run on 32bit? |
| 98 |
if [ "`dpkg-architecture -qDEB_HOST_ARCH_BITS`" = "32" ]; then |
| 99 |
LIBS="$LIBS libdbtoolslo.so libcomphelper.so" |
| 100 |
# done below |
| 101 |
else |
| 102 |
LIBS="$LIBS libmergedlo.so" |
| 103 |
ln -svf /usr/lib/libreoffice/program/libmergedlo.so libdbtoolslo.so |
| 104 |
# DOESN'T WORK, CAUSES LINK ERROR |
| 105 |
#ln -svf /usr/lib/libreoffice/program/libmergedlo.so libcomphelper.so |
| 106 |
fi |
| 107 |
for i in $LIBS; do \ |
| 108 |
ln -svf /usr/lib/libreoffice/program/$i; \ |
| 109 |
done |
| 110 |
|
| 111 |
echo |
| 112 |
echo "====== Starting MySQL Test with ${CHECK_PARALLELISM} job ======" |
| 113 |
cd $SRCDIR/connectivity && \ |
| 114 |
make -rj$CHECK_PARALLELISM CppunitTest_connectivity_mysql_test \ |
| 115 |
CONNECTIVITY_TEST_MYSQL_DRIVER="$db_conn_string" \ |
| 116 |
verbose=t || exit 1 |
| 117 |
|
| 118 |
echo |
| 119 |
echo "====== Dropping database "$db_name" ======" |
| 120 |
echo "DROP DATABASE $db_name;" | \ |
| 121 |
$db -v -u $db_user mysql |
| 122 |
|
| 123 |
cleanup |