Debian Codegraph @

debian/tests/cppunit-connectivity-mysql

raw
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