Cdr_mysql.c:199:51: error:

[for.ggame.playing]

I wanted to install asterisk on my FreeBSD 12.1-Stable(32bit) server from freebsd /usr/ports/net/asterisk16 port.
I managed to install mysql 8.0.20. and enabled support for mysql and odbc connector to install asterisk16 on( I have trouble connecting /databases/mysql-connector-odbc port too)

Here is error output

cd /usr/ports/net/asterisk16
make install clean

cdr_mysql.c:199:51: error: use of undeclared identifier 'my_bool_true'
                if (mysql_options(&mysql, MYSQL_OPT_RECONNECT, &my_bool_true) != 0) {
                                                                ^
cdr_mysql.c:487:50: error: use of undeclared identifier 'my_bool_true'
        if (mysql_options(&mysql, MYSQL_OPT_RECONNECT, &my_bool_true) != 0) {
                                                        ^
2 errors generated.
gmake[3]: *** [/usr/ports/net/asterisk16/work/asterisk-16.11.1/Makefile.rules:164: cdr_mysql.o] Error 1
gmake[3]: *** Waiting for unfinished jobs....
gmake[3]: Leaving directory '/usr/ports/net/asterisk16/work/asterisk-16.11.1/addons'
gmake[2]: *** [Makefile:387: addons] Error 2
gmake[2]: Leaving directory '/usr/ports/net/asterisk16/work/asterisk-16.11.1'
===> Compilation failed unexpectedly.
the maintainer.
*** Error code 1

Stop.
make[1]: stopped in /usr/ports/net/asterisk16
*** Error code 1

Stop.

[ambiorixg12]

If you use odbc, you dont need to use the deprecated mysql module

[for.ggame.playing]

So, what you are suggesting is either to disable mysql support or odbc support? is that what you mean?

[david551]

He’s saying disable mysql native support and forget about your library compatibility issue, as you can access mysql through ODBC.