mysql80-server + apache24 -> [dbd/apr_dbd_mysql.lo] Error code 1

From: ICT builder <builder_at_vernuftiger.nl>
Date: Tue, 31 May 2022 15:05:11 UTC
Hello,

I'm trying to build apache24 from ports on a amd64 13.1 jail after I 
successfully build and installed mysql80-server to it.

(This jail is intended for nexcloud which suggests use mysql80)

When I do:
cd /usr/ports/www/apache24 && make install clean

and change no settings I get a popup for dependency apr where I 
unselected BDB and selected MySQL.

The build of apache24 then fails with:



--- crypto/apr_crypto_openssl.lo ---
/bin/sh /var/ports/work/usr/ports/devel/apr1/work/apr-1.7.0/libtool 
--silent --mode=compile cc   -O2 -pipe  -DLIBICONV_PLUG 
-fstack-protector-strong -fno-strict-aliasing -DHAVE_CONFIG_H 
-DLIBICONV_PLUG 
-I/var/ports/work/usr/ports/devel/apr1/work/apr-util-1.6.1/include 
-I/var/ports/work/usr/ports/devel/apr1/work/apr-util-1.6.1/include/private 
-I/usr/local/include/mysql 
-I/var/ports/work/usr/ports/devel/apr1/work/apr-1.7.0/include 
-I/usr/include -I/usr/local/include  -o crypto/apr_crypto_openssl.lo -c 
crypto/apr_crypto_openssl.c && touch crypto/apr_crypto_openssl.lo
--- dbd/apr_dbd_mysql.lo ---
/bin/sh /var/ports/work/usr/ports/devel/apr1/work/apr-1.7.0/libtool 
--silent --mode=compile cc   -O2 -pipe  -DLIBICONV_PLUG 
-fstack-protector-strong -fno-strict-aliasing -DHAVE_CONFIG_H 
-DLIBICONV_PLUG 
-I/var/ports/work/usr/ports/devel/apr1/work/apr-util-1.6.1/include 
-I/var/ports/work/usr/ports/devel/apr1/work/apr-util-1.6.1/include/private 
-I/usr/local/include/mysql 
-I/var/ports/work/usr/ports/devel/apr1/work/apr-1.7.0/include 
-I/usr/include -I/usr/local/include  -o dbd/apr_dbd_mysql.lo -c 
dbd/apr_dbd_mysql.c && touch dbd/apr_dbd_mysql.lo
dbd/apr_dbd_mysql.c:716:5: error: use of undeclared identifier 'my_bool'
	my_bool *is_nullr;
	^
dbd/apr_dbd_mysql.c:716:14: error: use of undeclared identifier 'is_nullr'
	my_bool *is_nullr;
			 ^
dbd/apr_dbd_mysql.c:718:5: error: use of undeclared identifier 'my_bool'
	my_bool *error;
	^
dbd/apr_dbd_mysql.c:718:14: error: use of undeclared identifier 'error'
	my_bool *error;
			 ^
dbd/apr_dbd_mysql.c:741:17: error: use of undeclared identifier 'error'
				error = apr_palloc(pool, nfields*sizeof(my_bool));
				^
dbd/apr_dbd_mysql.c:741:57: error: use of undeclared identifier 
'my_bool'; did you mean '_Bool'?
				error = apr_palloc(pool, nfields*sizeof(my_bool));
														^~~~~~~
														_Bool
dbd/apr_dbd_mysql.c:741:56: error: reference to overloaded function 
could not be resolved; did you mean to call it?
				error = apr_palloc(pool, nfields*sizeof(my_bool));
													   ^~~~~~~~~
dbd/apr_dbd_mysql.c:743:17: error: use of undeclared identifier 'is_nullr'
				is_nullr = apr_pcalloc(pool, nfields*sizeof(my_bool));
				^
dbd/apr_dbd_mysql.c:743:61: error: use of undeclared identifier 
'my_bool'; did you mean '_Bool'?
				is_nullr = apr_pcalloc(pool, nfields*sizeof(my_bool));
															^~~~~~~
															_Bool
/var/ports/work/usr/ports/devel/apr1/work/apr-1.7.0/include/apr_pools.h:465:51: 
note: expanded from macro 'apr_pcalloc'
#define apr_pcalloc(p, size) memset(apr_palloc(p, size), 0, size)
												  ^
dbd/apr_dbd_mysql.c:743:60: error: reference to overloaded function 
could not be resolved; did you mean to call it?
				is_nullr = apr_pcalloc(pool, nfields*sizeof(my_bool));
														   ^~~~~~~~~
/var/ports/work/usr/ports/devel/apr1/work/apr-1.7.0/include/apr_pools.h:465:51: 
note: expanded from macro 'apr_pcalloc'
#define apr_pcalloc(p, size) memset(apr_palloc(p, size), 0, size)
												  ^~~~
dbd/apr_dbd_mysql.c:743:61: error: use of undeclared identifier 
'my_bool'; did you mean '_Bool'?
				is_nullr = apr_pcalloc(pool, nfields*sizeof(my_bool));
															^~~~~~~
															_Bool
/var/ports/work/usr/ports/devel/apr1/work/apr-1.7.0/include/apr_pools.h:465:61: 
note: expanded from macro 'apr_pcalloc'
#define apr_pcalloc(p, size) memset(apr_palloc(p, size), 0, size)
															^
dbd/apr_dbd_mysql.c:743:60: error: reference to overloaded function 
could not be resolved; did you mean to call it?
				is_nullr = apr_pcalloc(pool, nfields*sizeof(my_bool));
														   ^~~~~~~~~
/var/ports/work/usr/ports/devel/apr1/work/apr-1.7.0/include/apr_pools.h:465:61: 
note: expanded from macro 'apr_pcalloc'
#define apr_pcalloc(p, size) memset(apr_palloc(p, size), 0, size)
															^~~~
dbd/apr_dbd_mysql.c:756:47: error: use of undeclared identifier 'is_nullr'
					(*res)->bind[i].is_null = is_nullr+i;
											  ^
dbd/apr_dbd_mysql.c:758:45: error: use of undeclared identifier 'error'
					(*res)->bind[i].error = error+i;
											^
dbd/apr_dbd_mysql.c:1107:5: error: use of undeclared identifier 'my_bool'
	my_bool do_reconnect = 1;
	^
dbd/apr_dbd_mysql.c:1179:10: error: use of undeclared identifier 
'do_reconnect'
		 do_reconnect = atoi(fields[9].value) ? 1 : 0;
		 ^
dbd/apr_dbd_mysql.c:1185:52: error: use of undeclared identifier 
'do_reconnect'
	mysql_options(sql->conn, MYSQL_OPT_RECONNECT, &do_reconnect);
												   ^
dbd/apr_dbd_mysql.c:1203:52: error: use of undeclared identifier 
'do_reconnect'
	mysql_options(sql->conn, MYSQL_OPT_RECONNECT, &do_reconnect);
												   ^
dbd/apr_dbd_mysql.c:1266:5: warning: implicit declaration of function 
'my_init' is invalid in C99 [-Wimplicit-function-declaration]
	my_init();
	^
1 warning and 18 errors generated.
*** [dbd/apr_dbd_mysql.lo] Error code 1

make[5]: stopped in /var/ports/work/usr/ports/devel/apr1/work/apr-util-1.6.1
1 error

make[5]: stopped in /var/ports/work/usr/ports/devel/apr1/work/apr-util-1.6.1
*** [all-recursive] Error code 1

make[4]: stopped in /var/ports/work/usr/ports/devel/apr1/work/apr-util-1.6.1
1 error

make[4]: stopped in /var/ports/work/usr/ports/devel/apr1/work/apr-util-1.6.1
*** Error code 2

Stop.
make[3]: stopped in /usr/ports/devel/apr1
*** Error code 1

Stop.
make[2]: stopped in /usr/ports/devel/apr1
*** Error code 1

Stop.
make[1]: stopped in /usr/ports/www/apache24
*** Error code 1

Stop.
make: stopped in /usr/ports/www/apache24



googling the error I find:
https://bugs.freebsd.org/bugzilla/show_bug.cgi?id=230538

I'm not sure how to proceed to get apache24 installed when 
mysql80-server is already installed. With mysql57-server same steps work ok.

Any pointers are appreciated.