You are not logged in.
Recently my mariadb was upgraded to 10.3.12-2 (and later on til 10.3.12-5)
At the same time apr-util was upgraded to to 1.6.1-5
Ever since that moment I can not use the "DBDriver mysql" with apache 2.4 anymore (using mod_dbd and mod_authn_dbd)
My config is like this (and did not change for a long time)
DBDriver mysql
DBDParams "socket=/var/run/mysqld/mysqld.sock dbname=some_databasename user=some_username pass=some_password"
<Directory "/srv/http/somefolder">
AuthName "Private"
AuthType Basic
AuthBasicProvider dbd
AuthDBDUserPWQuery "SELECT password AS password FROM sometable WHERE username = %s"
Require valid-user
</Directory>
I now get the following error from apache when starting httpd:
Can't load driver file apr_dbd_mysql.so
This file does still exist and is located in /usr/lib/apr-util-1/apr_dbd_mysql.so
I even tried copying and linking it to /usr/lib/httpd/modules/apr_dbd_mysql.so but still get the same error.
Does apr-util perhaps not support MariaDB 10.3 ? Or is does anyone else know how to fix this ?
Last edited by robin67 (2019-02-11 18:05:14)
Offline
I am still phasing this problem, but saw no replies but am curious to know if others use this functionality as well?
And if so, do or don't you have/had this issue with apr-util ?
Offline
you could have posted a link to the arch bugreport you created https://bugs.archlinux.org/task/61774 .
Many (old) messages about this error suggest it may be due to apr-util not being build against the installed version of that library.
Have you tried rebuilding apr-util locally ?
Disliking systemd intensely, but not satisfied with alternatives so focusing on taming systemd.
clean chroot building not flexible enough ?
Try clean chroot manager by graysky
Offline
I didn't include the bug I posted because it was still not confirmed, but maybe I should have ..
I tried building it myself but am running in an failure doing so
[dbd_odbc] SQLConnect returned SQL_ERROR (-1) at dbd/apr_dbd_odbc.c:1146 [unixODBC][Driver Manager]Data source name not found and no default driver specified IM002
Failed to open odbc[]
Offline
I tried building it myself but am running in an failure doing so
[dbd_odbc] SQLConnect returned SQL_ERROR (-1) at dbd/apr_dbd_odbc.c:1146 [unixODBC][Driver Manager]Data source name not found and no default driver specified IM002 Failed to open odbc[]
https://bbs.archlinux.org/viewtopic.php?id=57855
cd test && make all check
make[1]: Entering directory '/build/apr-util/src/apr-util-1.6.1/test'
make[2]: Entering directory '/build/apr-util/src/apr-util-1.6.1/test'
/bin/sh /usr/share/apr-1/build/libtool --silent --mode=compile gcc -pthread -march=x86-64 -mtune=generic -O2 -pipe -fstack-protector-strong -fno-plt -DHAVE_CONFIG_H -DLINUX -D_REENTRANT -D_GNU_SOURCE -D_FORTIFY_SOURCE=2 -I/build/apr-util/src/apr-util-1.6.1/include -I/build/apr-util/src/apr-util-1.6.1/include/private -I/usr/include/nss -I/usr/include/nss3 -I/usr/include/nspr -I/usr/include/nspr4 -I/usr/include -I/usr/../public -I/usr/include/mysql -I/usr/include/mysql/mysql -I/usr/include/apr-1 -I/usr/include -o dbd.lo -c dbd.c && touch dbd.lo
/bin/sh /usr/share/apr-1/build/libtool --silent --mode=link gcc -pthread -march=x86-64 -mtune=generic -O2 -pipe -fstack-protector-strong -fno-plt -DHAVE_CONFIG_H -DLINUX -D_REENTRANT -D_GNU_SOURCE -D_FORTIFY_SOURCE=2 -I/build/apr-util/src/apr-util-1.6.1/include -I/build/apr-util/src/apr-util-1.6.1/include/private -I/usr/include/nss -I/usr/include/nss3 -I/usr/include/nspr -I/usr/include/nspr4 -I/usr/include -I/usr/../public -I/usr/include/mysql -I/usr/include/mysql/mysql -I/usr/include/apr-1 -I/usr/include -Wl,-O1,--sort-common,--as-needed,-z,relro,-z,now -no-install -L/usr/lib -o dbd dbd.lo ../libaprutil-1.la -lexpat -L/usr/lib -R/usr/lib -lapr-1
/bin/sh /usr/share/apr-1/build/libtool --silent --mode=compile gcc -pthread -march=x86-64 -mtune=generic -O2 -pipe -fstack-protector-strong -fno-plt -DHAVE_CONFIG_H -DLINUX -D_REENTRANT -D_GNU_SOURCE -D_FORTIFY_SOURCE=2 -I/build/apr-util/src/apr-util-1.6.1/include -I/build/apr-util/src/apr-util-1.6.1/include/private -I/usr/include/nss -I/usr/include/nss3 -I/usr/include/nspr -I/usr/include/nspr4 -I/usr/include -I/usr/../public -I/usr/include/mysql -I/usr/include/mysql/mysql -I/usr/include/apr-1 -I/usr/include -o abts.lo -c abts.c && touch abts.lo
/bin/sh /usr/share/apr-1/build/libtool --silent --mode=compile gcc -pthread -march=x86-64 -mtune=generic -O2 -pipe -fstack-protector-strong -fno-plt -DHAVE_CONFIG_H -DLINUX -D_REENTRANT -D_GNU_SOURCE -D_FORTIFY_SOURCE=2 -I/build/apr-util/src/apr-util-1.6.1/include -I/build/apr-util/src/apr-util-1.6.1/include/private -I/usr/include/nss -I/usr/include/nss3 -I/usr/include/nspr -I/usr/include/nspr4 -I/usr/include -I/usr/../public -I/usr/include/mysql -I/usr/include/mysql/mysql -I/usr/include/apr-1 -I/usr/include -o testutil.lo -c testutil.c && touch testutil.lo
/bin/sh /usr/share/apr-1/build/libtool --silent --mode=compile gcc -pthread -march=x86-64 -mtune=generic -O2 -pipe -fstack-protector-strong -fno-plt -DHAVE_CONFIG_H -DLINUX -D_REENTRANT -D_GNU_SOURCE -D_FORTIFY_SOURCE=2 -I/build/apr-util/src/apr-util-1.6.1/include -I/build/apr-util/src/apr-util-1.6.1/include/private -I/usr/include/nss -I/usr/include/nss3 -I/usr/include/nspr -I/usr/include/nspr4 -I/usr/include -I/usr/../public -I/usr/include/mysql -I/usr/include/mysql/mysql -I/usr/include/apr-1 -I/usr/include -o teststrmatch.lo -c teststrmatch.c && touch teststrmatch.lo
/bin/sh /usr/share/apr-1/build/libtool --silent --mode=compile gcc -pthread -march=x86-64 -mtune=generic -O2 -pipe -fstack-protector-strong -fno-plt -DHAVE_CONFIG_H -DLINUX -D_REENTRANT -D_GNU_SOURCE -D_FORTIFY_SOURCE=2 -I/build/apr-util/src/apr-util-1.6.1/include -I/build/apr-util/src/apr-util-1.6.1/include/private -I/usr/include/nss -I/usr/include/nss3 -I/usr/include/nspr -I/usr/include/nspr4 -I/usr/include -I/usr/../public -I/usr/include/mysql -I/usr/include/mysql/mysql -I/usr/include/apr-1 -I/usr/include -o testuri.lo -c testuri.c && touch testuri.lo
/bin/sh /usr/share/apr-1/build/libtool --silent --mode=compile gcc -pthread -march=x86-64 -mtune=generic -O2 -pipe -fstack-protector-strong -fno-plt -DHAVE_CONFIG_H -DLINUX -D_REENTRANT -D_GNU_SOURCE -D_FORTIFY_SOURCE=2 -I/build/apr-util/src/apr-util-1.6.1/include -I/build/apr-util/src/apr-util-1.6.1/include/private -I/usr/include/nss -I/usr/include/nss3 -I/usr/include/nspr -I/usr/include/nspr4 -I/usr/include -I/usr/../public -I/usr/include/mysql -I/usr/include/mysql/mysql -I/usr/include/apr-1 -I/usr/include -o testuuid.lo -c testuuid.c && touch testuuid.lo
/bin/sh /usr/share/apr-1/build/libtool --silent --mode=compile gcc -pthread -march=x86-64 -mtune=generic -O2 -pipe -fstack-protector-strong -fno-plt -DHAVE_CONFIG_H -DLINUX -D_REENTRANT -D_GNU_SOURCE -D_FORTIFY_SOURCE=2 -I/build/apr-util/src/apr-util-1.6.1/include -I/build/apr-util/src/apr-util-1.6.1/include/private -I/usr/include/nss -I/usr/include/nss3 -I/usr/include/nspr -I/usr/include/nspr4 -I/usr/include -I/usr/../public -I/usr/include/mysql -I/usr/include/mysql/mysql -I/usr/include/apr-1 -I/usr/include -o testbuckets.lo -c testbuckets.c && touch testbuckets.lo
/bin/sh /usr/share/apr-1/build/libtool --silent --mode=compile gcc -pthread -march=x86-64 -mtune=generic -O2 -pipe -fstack-protector-strong -fno-plt -DHAVE_CONFIG_H -DLINUX -D_REENTRANT -D_GNU_SOURCE -D_FORTIFY_SOURCE=2 -I/build/apr-util/src/apr-util-1.6.1/include -I/build/apr-util/src/apr-util-1.6.1/include/private -I/usr/include/nss -I/usr/include/nss3 -I/usr/include/nspr -I/usr/include/nspr4 -I/usr/include -I/usr/../public -I/usr/include/mysql -I/usr/include/mysql/mysql -I/usr/include/apr-1 -I/usr/include -o testpass.lo -c testpass.c && touch testpass.lo
/bin/sh /usr/share/apr-1/build/libtool --silent --mode=compile gcc -pthread -march=x86-64 -mtune=generic -O2 -pipe -fstack-protector-strong -fno-plt -DHAVE_CONFIG_H -DLINUX -D_REENTRANT -D_GNU_SOURCE -D_FORTIFY_SOURCE=2 -I/build/apr-util/src/apr-util-1.6.1/include -I/build/apr-util/src/apr-util-1.6.1/include/private -I/usr/include/nss -I/usr/include/nss3 -I/usr/include/nspr -I/usr/include/nspr4 -I/usr/include -I/usr/../public -I/usr/include/mysql -I/usr/include/mysql/mysql -I/usr/include/apr-1 -I/usr/include -o testmd4.lo -c testmd4.c && touch testmd4.lo
/bin/sh /usr/share/apr-1/build/libtool --silent --mode=compile gcc -pthread -march=x86-64 -mtune=generic -O2 -pipe -fstack-protector-strong -fno-plt -DHAVE_CONFIG_H -DLINUX -D_REENTRANT -D_GNU_SOURCE -D_FORTIFY_SOURCE=2 -I/build/apr-util/src/apr-util-1.6.1/include -I/build/apr-util/src/apr-util-1.6.1/include/private -I/usr/include/nss -I/usr/include/nss3 -I/usr/include/nspr -I/usr/include/nspr4 -I/usr/include -I/usr/../public -I/usr/include/mysql -I/usr/include/mysql/mysql -I/usr/include/apr-1 -I/usr/include -o testmd5.lo -c testmd5.c && touch testmd5.lo
/bin/sh /usr/share/apr-1/build/libtool --silent --mode=compile gcc -pthread -march=x86-64 -mtune=generic -O2 -pipe -fstack-protector-strong -fno-plt -DHAVE_CONFIG_H -DLINUX -D_REENTRANT -D_GNU_SOURCE -D_FORTIFY_SOURCE=2 -I/build/apr-util/src/apr-util-1.6.1/include -I/build/apr-util/src/apr-util-1.6.1/include/private -I/usr/include/nss -I/usr/include/nss3 -I/usr/include/nspr -I/usr/include/nspr4 -I/usr/include -I/usr/../public -I/usr/include/mysql -I/usr/include/mysql/mysql -I/usr/include/apr-1 -I/usr/include -o testldap.lo -c testldap.c && touch testldap.lo
/bin/sh /usr/share/apr-1/build/libtool --silent --mode=compile gcc -pthread -march=x86-64 -mtune=generic -O2 -pipe -fstack-protector-strong -fno-plt -DHAVE_CONFIG_H -DLINUX -D_REENTRANT -D_GNU_SOURCE -D_FORTIFY_SOURCE=2 -I/build/apr-util/src/apr-util-1.6.1/include -I/build/apr-util/src/apr-util-1.6.1/include/private -I/usr/include/nss -I/usr/include/nss3 -I/usr/include/nspr -I/usr/include/nspr4 -I/usr/include -I/usr/../public -I/usr/include/mysql -I/usr/include/mysql/mysql -I/usr/include/apr-1 -I/usr/include -o testdate.lo -c testdate.c && touch testdate.lo
/bin/sh /usr/share/apr-1/build/libtool --silent --mode=compile gcc -pthread -march=x86-64 -mtune=generic -O2 -pipe -fstack-protector-strong -fno-plt -DHAVE_CONFIG_H -DLINUX -D_REENTRANT -D_GNU_SOURCE -D_FORTIFY_SOURCE=2 -I/build/apr-util/src/apr-util-1.6.1/include -I/build/apr-util/src/apr-util-1.6.1/include/private -I/usr/include/nss -I/usr/include/nss3 -I/usr/include/nspr -I/usr/include/nspr4 -I/usr/include -I/usr/../public -I/usr/include/mysql -I/usr/include/mysql/mysql -I/usr/include/apr-1 -I/usr/include -o testdbm.lo -c testdbm.c && touch testdbm.lo
/bin/sh /usr/share/apr-1/build/libtool --silent --mode=compile gcc -pthread -march=x86-64 -mtune=generic -O2 -pipe -fstack-protector-strong -fno-plt -DHAVE_CONFIG_H -DLINUX -D_REENTRANT -D_GNU_SOURCE -D_FORTIFY_SOURCE=2 -I/build/apr-util/src/apr-util-1.6.1/include -I/build/apr-util/src/apr-util-1.6.1/include/private -I/usr/include/nss -I/usr/include/nss3 -I/usr/include/nspr -I/usr/include/nspr4 -I/usr/include -I/usr/../public -I/usr/include/mysql -I/usr/include/mysql/mysql -I/usr/include/apr-1 -I/usr/include -o testdbd.lo -c testdbd.c && touch testdbd.lo
/bin/sh /usr/share/apr-1/build/libtool --silent --mode=compile gcc -pthread -march=x86-64 -mtune=generic -O2 -pipe -fstack-protector-strong -fno-plt -DHAVE_CONFIG_H -DLINUX -D_REENTRANT -D_GNU_SOURCE -D_FORTIFY_SOURCE=2 -I/build/apr-util/src/apr-util-1.6.1/include -I/build/apr-util/src/apr-util-1.6.1/include/private -I/usr/include/nss -I/usr/include/nss3 -I/usr/include/nspr -I/usr/include/nspr4 -I/usr/include -I/usr/../public -I/usr/include/mysql -I/usr/include/mysql/mysql -I/usr/include/apr-1 -I/usr/include -o testxml.lo -c testxml.c && touch testxml.lo
/bin/sh /usr/share/apr-1/build/libtool --silent --mode=compile gcc -pthread -march=x86-64 -mtune=generic -O2 -pipe -fstack-protector-strong -fno-plt -DHAVE_CONFIG_H -DLINUX -D_REENTRANT -D_GNU_SOURCE -D_FORTIFY_SOURCE=2 -I/build/apr-util/src/apr-util-1.6.1/include -I/build/apr-util/src/apr-util-1.6.1/include/private -I/usr/include/nss -I/usr/include/nss3 -I/usr/include/nspr -I/usr/include/nspr4 -I/usr/include -I/usr/../public -I/usr/include/mysql -I/usr/include/mysql/mysql -I/usr/include/apr-1 -I/usr/include -o testrmm.lo -c testrmm.c && touch testrmm.lo
/bin/sh /usr/share/apr-1/build/libtool --silent --mode=compile gcc -pthread -march=x86-64 -mtune=generic -O2 -pipe -fstack-protector-strong -fno-plt -DHAVE_CONFIG_H -DLINUX -D_REENTRANT -D_GNU_SOURCE -D_FORTIFY_SOURCE=2 -I/build/apr-util/src/apr-util-1.6.1/include -I/build/apr-util/src/apr-util-1.6.1/include/private -I/usr/include/nss -I/usr/include/nss3 -I/usr/include/nspr -I/usr/include/nspr4 -I/usr/include -I/usr/../public -I/usr/include/mysql -I/usr/include/mysql/mysql -I/usr/include/apr-1 -I/usr/include -o testreslist.lo -c testreslist.c && touch testreslist.lo
/bin/sh /usr/share/apr-1/build/libtool --silent --mode=compile gcc -pthread -march=x86-64 -mtune=generic -O2 -pipe -fstack-protector-strong -fno-plt -DHAVE_CONFIG_H -DLINUX -D_REENTRANT -D_GNU_SOURCE -D_FORTIFY_SOURCE=2 -I/build/apr-util/src/apr-util-1.6.1/include -I/build/apr-util/src/apr-util-1.6.1/include/private -I/usr/include/nss -I/usr/include/nss3 -I/usr/include/nspr -I/usr/include/nspr4 -I/usr/include -I/usr/../public -I/usr/include/mysql -I/usr/include/mysql/mysql -I/usr/include/apr-1 -I/usr/include -o testqueue.lo -c testqueue.c && touch testqueue.lo
/bin/sh /usr/share/apr-1/build/libtool --silent --mode=compile gcc -pthread -march=x86-64 -mtune=generic -O2 -pipe -fstack-protector-strong -fno-plt -DHAVE_CONFIG_H -DLINUX -D_REENTRANT -D_GNU_SOURCE -D_FORTIFY_SOURCE=2 -I/build/apr-util/src/apr-util-1.6.1/include -I/build/apr-util/src/apr-util-1.6.1/include/private -I/usr/include/nss -I/usr/include/nss3 -I/usr/include/nspr -I/usr/include/nspr4 -I/usr/include -I/usr/../public -I/usr/include/mysql -I/usr/include/mysql/mysql -I/usr/include/apr-1 -I/usr/include -o testxlate.lo -c testxlate.c && touch testxlate.lo
/bin/sh /usr/share/apr-1/build/libtool --silent --mode=compile gcc -pthread -march=x86-64 -mtune=generic -O2 -pipe -fstack-protector-strong -fno-plt -DHAVE_CONFIG_H -DLINUX -D_REENTRANT -D_GNU_SOURCE -D_FORTIFY_SOURCE=2 -I/build/apr-util/src/apr-util-1.6.1/include -I/build/apr-util/src/apr-util-1.6.1/include/private -I/usr/include/nss -I/usr/include/nss3 -I/usr/include/nspr -I/usr/include/nspr4 -I/usr/include -I/usr/../public -I/usr/include/mysql -I/usr/include/mysql/mysql -I/usr/include/apr-1 -I/usr/include -o testmemcache.lo -c testmemcache.c && touch testmemcache.lo
/bin/sh /usr/share/apr-1/build/libtool --silent --mode=compile gcc -pthread -march=x86-64 -mtune=generic -O2 -pipe -fstack-protector-strong -fno-plt -DHAVE_CONFIG_H -DLINUX -D_REENTRANT -D_GNU_SOURCE -D_FORTIFY_SOURCE=2 -I/build/apr-util/src/apr-util-1.6.1/include -I/build/apr-util/src/apr-util-1.6.1/include/private -I/usr/include/nss -I/usr/include/nss3 -I/usr/include/nspr -I/usr/include/nspr4 -I/usr/include -I/usr/../public -I/usr/include/mysql -I/usr/include/mysql/mysql -I/usr/include/apr-1 -I/usr/include -o testcrypto.lo -c testcrypto.c && touch testcrypto.lo
/bin/sh /usr/share/apr-1/build/libtool --silent --mode=compile gcc -pthread -march=x86-64 -mtune=generic -O2 -pipe -fstack-protector-strong -fno-plt -DHAVE_CONFIG_H -DLINUX -D_REENTRANT -D_GNU_SOURCE -D_FORTIFY_SOURCE=2 -I/build/apr-util/src/apr-util-1.6.1/include -I/build/apr-util/src/apr-util-1.6.1/include/private -I/usr/include/nss -I/usr/include/nss3 -I/usr/include/nspr -I/usr/include/nspr4 -I/usr/include -I/usr/../public -I/usr/include/mysql -I/usr/include/mysql/mysql -I/usr/include/apr-1 -I/usr/include -o testsiphash.lo -c testsiphash.c && touch testsiphash.lo
/bin/sh /usr/share/apr-1/build/libtool --silent --mode=compile gcc -pthread -march=x86-64 -mtune=generic -O2 -pipe -fstack-protector-strong -fno-plt -DHAVE_CONFIG_H -DLINUX -D_REENTRANT -D_GNU_SOURCE -D_FORTIFY_SOURCE=2 -I/build/apr-util/src/apr-util-1.6.1/include -I/build/apr-util/src/apr-util-1.6.1/include/private -I/usr/include/nss -I/usr/include/nss3 -I/usr/include/nspr -I/usr/include/nspr4 -I/usr/include -I/usr/../public -I/usr/include/mysql -I/usr/include/mysql/mysql -I/usr/include/apr-1 -I/usr/include -o testredis.lo -c testredis.c && touch testredis.lo
/bin/sh /usr/share/apr-1/build/libtool --silent --mode=link gcc -pthread -march=x86-64 -mtune=generic -O2 -pipe -fstack-protector-strong -fno-plt -DHAVE_CONFIG_H -DLINUX -D_REENTRANT -D_GNU_SOURCE -D_FORTIFY_SOURCE=2 -I/build/apr-util/src/apr-util-1.6.1/include -I/build/apr-util/src/apr-util-1.6.1/include/private -I/usr/include/nss -I/usr/include/nss3 -I/usr/include/nspr -I/usr/include/nspr4 -I/usr/include -I/usr/../public -I/usr/include/mysql -I/usr/include/mysql/mysql -I/usr/include/apr-1 -I/usr/include -Wl,-O1,--sort-common,--as-needed,-z,relro,-z,now -no-install -L/usr/lib -o testall abts.lo testutil.lo teststrmatch.lo testuri.lo testuuid.lo testbuckets.lo testpass.lo testmd4.lo testmd5.lo testldap.lo testdate.lo testdbm.lo testdbd.lo testxml.lo testrmm.lo testreslist.lo testqueue.lo testxlate.lo testmemcache.lo testcrypto.lo testsiphash.lo testredis.lo ../libaprutil-1.la -lexpat -L/usr/lib -R/usr/lib -lapr-1 -lldap -llber
if test ! -d "./data"; then cp -r ./data data; fi
make[2]: Leaving directory '/build/apr-util/src/apr-util-1.6.1/test'
teststatus=0; \
progfailed=""; \
for prog in dbd testall; do \
if test "$prog" = 'dbd'; then \
for driver in none pgsql mysql sqlite3 odbc; do \
if test "$driver" != 'none'; then \
LD_LIBRARY_PATH="`echo "../crypto/.libs:../dbm/.libs:../dbd/.libs:../ldap/.libs:$LD_LIBRARY_PATH" | sed -e 's/::*$//'`" \
./$prog $driver; \
status=$?; \
if test $status != 0; then \
teststatus=$status; \
progfailed="$progfailed '$prog $driver'"; \
fi; \
fi; \
done; \
else \
LD_LIBRARY_PATH="`echo "../crypto/.libs:../dbm/.libs:../dbd/.libs:../ldap/.libs:$LD_LIBRARY_PATH" | sed -e 's/::*$//'`" \
./$prog; \
status=$?; \
if test $status != 0; then \
teststatus=$status; \
progfailed="$progfailed $prog"; \
fi; \
fi; \
done; \
if test $teststatus != 0; then \
echo "Programs failed:$progfailed"; \
fi; \
exit $teststatus
Loaded pgsql driver OK.
Failed to open pgsql[]
Failed to load driver file apr_dbd_mysql.so
Loaded sqlite3 driver OK.
Opened sqlite3[] OK
======== create table ========
create table test successful
======== insert rows ========
insert rows test successful
======== invalid op ========
invalid op returned 1 (should be nonzero). Error msg follows
'no such table: apr_dbd_test1'
valid op returned 0 (should be zero; error shouldn't affect subsequent ops)
invalid op test successful
======== select random ========
ROW 5: wibble nothing 5
ROW 1: asdfgh bar 1
select random test successful
======== select sequential ========
ROW 1: asdfgh bar 1
ROW 2: bar foo (null)
ROW 3: foo (null) (null)
ROW 4: qwerty foo 0
ROW 5: wibble nothing 5
ROW 6: wibble other 5
select sequential test successful
======== transactions ========
Transaction 1
6 rows updated
Valid insert returned 1. Should be nonzero (fail) because transaction is bad
Transaction ended (should be rollback) - viewing table
A column of "failed" indicates transaction failed (no rollback)
ROW 1: asdfgh bar 1
ROW 2: bar foo (null)
ROW 3: foo (null) (null)
ROW 4: qwerty foo 0
ROW 5: wibble nothing 5
ROW 6: wibble other 5
Transaction 2
6 rows updated
Valid insert returned 0. Should be zero (OK)
Transaction ended (should be commit) - viewing table
ROW 1: aaa zzz 3
ROW 2: asdfgh success 1
ROW 3: bar success (null)
ROW 4: foo success (null)
ROW 5: qwerty success 0
ROW 6: wibble success 5
ROW 7: wibble success 5
transactions test successful
======== prepared select ========
Selecting rows where col3 <= 3 and bar row where it's unset.
Should show four rows.
ROW 1: qwerty success 0
ROW 2: asdfgh success 1
ROW 3: bar success (null)
ROW 4: aaa zzz 3
prepared select test successful
======== prepared query ========
Showing table (should now contain row "prepared insert 2")
ROW 1: aaa zzz 3
ROW 2: asdfgh success 1
ROW 3: bar success (null)
ROW 4: foo success (null)
ROW 5: prepared insert 2
ROW 6: qwerty success 0
ROW 7: wibble success 5
ROW 8: wibble success 5
prepared query test successful
======== drop table ========
drop table test successful
Loaded odbc driver OK.
[Mon Feb 25 16:59:58 2019] [dbd_odbc] SQLConnect returned SQL_ERROR (-1) at dbd/apr_dbd_odbc.c:1146 [unixODBC][Driver Manager]Data source name not found and no default driver specified IM002
Failed to open odbc[]
teststrmatch : SUCCESS
testuri : SUCCESS
testuuid : SUCCESS
testbuckets : SUCCESS
testpass : SUCCESS
testmd4 : SUCCESS
testmd5 : SUCCESS
testcrypto : SUCCESS
testldap : SUCCESS
testdbd : SUCCESS
testdate : SUCCESS
testmemcache : SUCCESS
testredis : SUCCESS
testxml : SUCCESS
testxlate : SUCCESS
testrmm : SUCCESS
testdbm : SUCCESS
testqueue : SUCCESS
testreslist : SUCCESS
testsiphash : SUCCESS
All tests passed.
make[1]: Leaving directory '/build/apr-util/src/apr-util-1.6.1/test'
All checks passed despite the message and the package built successfully on this system using extra-x86_64-build
Offline
Here is how Ubuntu solve this issue: https://bugs.launchpad.net/ubuntu/+sour … ug/1859773
Offline
Upstream bug report https://bz.apache.org/bugzilla/show_bug.cgi?id=61517
Edit:
Looks as though the patch needed is r1872061 from the 1.7 branch excluding the hunk for CHANGES.
Last edited by loqs (2020-05-28 18:01:12)
Offline