add support for Fedora42

[mirostauder]

add package builds for Fedora42
https://hub.docker.com/_/fedora/tags?name=42

build images:

• GCC
• CLang
• AMD64
• ARM64

packaging:

• GCC
• CLang
• AMD64
• ARM64

Fedora42 is using GCC15

• bool is a reserved keyword now - some dependencies need update/upgrade

upgrades needed to resolve issues:

• libconfig-1.7.3 => libconfig-1.8
• postgresql-16.3 => postgresql-16.9
• clickhouse-cpp-2.3.0 => clickhouse-cpp-2.5.1

[mirostauder]

errors in libconfig-1.7.3

...
make[5]: Entering directory '/opt/proxysql/deps/libconfig/libconfig-1.7.3/lib'
  CC       libconfig_la-grammar.lo
grammar.y: In function 'capture_parse_pos':
grammar.y:58:33: error: too many arguments to function 'libconfig_yyget_lineno'; expected 0, have 1
   58 |   setting->line = (unsigned int)libconfig_yyget_lineno(scanner);
      |                                 ^~~~~~~~~~~~~~~~~~~~~~ ~~~~~~~
grammar.y:44:12: note: declared here
   44 | extern int libconfig_yyget_lineno();
      |            ^~~~~~~~~~~~~~~~~~~~~~
grammar.y: In function 'libconfig_yyerror':
grammar.y:69:29: error: too many arguments to function 'libconfig_yyget_lineno'; expected 0, have 1
   69 |   ctx->config->error_line = libconfig_yyget_lineno(scanner);
      |                             ^~~~~~~~~~~~~~~~~~~~~~ ~~~~~~~
grammar.y:44:12: note: declared here
   44 | extern int libconfig_yyget_lineno();
      |            ^~~~~~~~~~~~~~~~~~~~~~
grammar.c: In function 'libconfig_yyparse':
grammar.c:64:25: error: too many arguments to function 'libconfig_yylex'; expected 0, have 2
   64 | #define yylex           libconfig_yylex
      |                         ^~~~~~~~~~~~~~~
grammar.c:1269:16: note: in expansion of macro 'yylex'
 1269 |       yychar = yylex (&yylval, scanner);
      |                ^~~~~
grammar.y:43:12: note: declared here
   43 | extern int libconfig_yylex();
      |            ^~~~~~~~~~~~~~~
make[5]: *** [Makefile:647: libconfig_la-grammar.lo] Error 1

upgrading to libconfig-1.8 fixes issue

[mirostauder]

errors in postgresql-16.3

...
gcc -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-statement -Werror=vla -Wendif-labels -Wmissing-format-attribute -Wimplicit-fallthrough=3 -Wcast-function-type -Wshadow=compatible-local -Wformat-security -fno-strict-aliasing -fwrapv -fexcess-precision=standard -Wno-format-truncation -Wno-stringop-truncation -O2 -I../../src/port -DFRONTEND -I../../src/include  -D_GNU_SOURCE  -I/usr/include  -c -o getpeereid.o getpeereid.c
In file included from getpeereid.c:15:
../../src/include/c.h:440:23: error: ‘bool’ cannot be defined via ‘typedef’
  440 | typedef unsigned char bool;
      |                       ^~~~
../../src/include/c.h:440:23: note: ‘bool’ is a keyword with ‘-std=c23’ onwards
../../src/include/c.h:440:1: warning: useless type name in empty declaration
  440 | typedef unsigned char bool;
      | ^~~~~~~
make: *** [<builtin>: getpeereid.o] Error 1
make: Leaving directory '/opt/proxysql/deps/postgresql/postgresql-16.3/src/port'

upgrading to postgresql-16.9 fixes issue

[mirostauder]

errors in clickhouse-cpp-2.3.0

...
n file included from /opt/proxysql/deps/clickhouse-cpp/clickhouse-cpp/contrib/absl/base/options.h:73,
                 from /opt/proxysql/deps/clickhouse-cpp/clickhouse-cpp/contrib/absl/base/config.h:66,
                 from /opt/proxysql/deps/clickhouse-cpp/clickhouse-cpp/contrib/absl/numeric/int128.h:33,
                 from /opt/proxysql/deps/clickhouse-cpp/clickhouse-cpp/contrib/absl/numeric/int128.cc:15:
/usr/include/c++/15/ciso646:46:4: error: #warning "<ciso646> is deprecated in C++17, use <version> to detect implementation-specific macros" [-Werror=cpp]
   46 | #  warning "<ciso646> is deprecated in C++17, use <version> to detect implementation-specific macros"
      |    ^~~~~~~

upgrading to clickhouse-cpp-2.5.1 did not fix the issue
replacing all <ciso646> references with <version> fixes the error

more errors:

...
++ -fPIC -c -o obj/PgSQL_Connection.oo PgSQL_Connection.cpp -std=c++17 -DCXX17 -I../include -I../deps/jemalloc/jemalloc/include/jemalloc -I../deps/mariadb-client-library/mariadb_client/include -I../deps/libconfig/libconfig/lib -I../deps/re2/re2 -I../deps/sqlite3/sqlite3 -I../deps/pcre/pcre -I/usr/local/include -I../deps/clickhouse-cpp/clickhouse-cpp -I../deps/clickhouse-cpp/clickhouse-cpp/contrib -I../deps/libmicrohttpd/libmicrohttpd -I../deps/libmicrohttpd/libmicrohttpd/src/include -I../deps/libhttpserver/libhttpserver/src -I../deps/libinjection/libinjection/src -I../deps/curl/curl/include -I../deps/libev/libev/ -I../deps/prometheus-cpp/prometheus-cpp/pull/include -I../deps/prometheus-cpp/prometheus-cpp/core/include -I../deps/libusual/libusual -I../deps/libscram/include -I../deps/postgresql/postgresql/src/interfaces/libpq -I../deps/postgresql/postgresql/src/include -I/usr/include -I../deps/coredumper/coredumper/include -O2 -ggdb  -Wall -DGITVERSION=\"3.0.2-6-gd29bf8c\"    -DPROXYSQLCLICKHOUSE -DENABLE_EPOLL 
In file included from ../deps/clickhouse-cpp/clickhouse-cpp/clickhouse/columns/column.h:3,
                 from ../deps/clickhouse-cpp/clickhouse-cpp/clickhouse/block.h:3,
                 from ../deps/clickhouse-cpp/clickhouse-cpp/clickhouse/query.h:3,
                 from ../deps/clickhouse-cpp/clickhouse-cpp/clickhouse/client.h:3,
                 from ClickHouse_Server.cpp:8:
../deps/clickhouse-cpp/clickhouse-cpp/clickhouse/columns/../types/types.h:3:10: fatal error: absl/numeric/int128.h: No such file or directory
    3 | #include "absl/numeric/int128.h"
      |          ^~~~~~~~~~~~~~~~~~~~~~~
compilation terminated.

adding include path in lib/Makefile fixes the issue

CLICKHOUSE_CPP_IDIR := ... -I$(CLICKHOUSE_CPP_PATH)/contrib/absl

[mirostauder]

error in ClickHouse_Server.cpp

...
g++ -fPIC -c -o obj/ClickHouse_Server.oo ClickHouse_Server.cpp -std=c++17 -DCXX17 -I../include -I../deps/jemalloc/jemalloc/include/jemalloc -I../deps/mariadb-client-library/mariadb_client/include -I../deps/libconfig/libconfig/lib -I../deps/re2/re2 -I../deps/sqlite3/sqlite3 -I../deps/pcre/pcre -I/usr/local/include -I../deps/clickhouse-cpp/clickhouse-cpp -I../deps/clickhouse-cpp/clickhouse-cpp/contrib -I../deps/clickhouse-cpp/clickhouse-cpp/contrib/absl -I../deps/libmicrohttpd/libmicrohttpd -I../deps/libmicrohttpd/libmicrohttpd/src/include -I../deps/libhttpserver/libhttpserver/src -I../deps/libinjection/libinjection/src -I../deps/curl/curl/include -I../deps/libev/libev/ -I../deps/prometheus-cpp/prometheus-cpp/pull/include -I../deps/prometheus-cpp/prometheus-cpp/core/include -I../deps/libusual/libusual -I../deps/libscram/include -I../deps/postgresql/postgresql/src/interfaces/libpq -I../deps/postgresql/postgresql/src/include -I/usr/include -I../deps/coredumper/coredumper/include -O2 -ggdb  -Wall -DGITVERSION=\"3.0.2-6-gd29bf8c\"    -DPROXYSQLCLICKHOUSE -DENABLE_EPOLL 
g++ -fPIC -c -o obj/PgSQL_Connection.oo PgSQL_Connection.cpp -std=c++17 -DCXX17 -I../include -I../deps/jemalloc/jemalloc/include/jemalloc -I../deps/mariadb-client-library/mariadb_client/include -I../deps/libconfig/libconfig/lib -I../deps/re2/re2 -I../deps/sqlite3/sqlite3 -I../deps/pcre/pcre -I/usr/local/include -I../deps/clickhouse-cpp/clickhouse-cpp -I../deps/clickhouse-cpp/clickhouse-cpp/contrib -I../deps/clickhouse-cpp/clickhouse-cpp/contrib/absl -I../deps/libmicrohttpd/libmicrohttpd -I../deps/libmicrohttpd/libmicrohttpd/src/include -I../deps/libhttpserver/libhttpserver/src -I../deps/libinjection/libinjection/src -I../deps/curl/curl/include -I../deps/libev/libev/ -I../deps/prometheus-cpp/prometheus-cpp/pull/include -I../deps/prometheus-cpp/prometheus-cpp/core/include -I../deps/libusual/libusual -I../deps/libscram/include -I../deps/postgresql/postgresql/src/interfaces/libpq -I../deps/postgresql/postgresql/src/include -I/usr/include -I../deps/coredumper/coredumper/include -O2 -ggdb  -Wall -DGITVERSION=\"3.0.2-6-gd29bf8c\"    -DPROXYSQLCLICKHOUSE -DENABLE_EPOLL 
PgSQL_Connection.cpp: In member function ‘void PgSQL_Connection::connect_start()’:
PgSQL_Connection.cpp:814:41: error: ‘PSERRORS_FORMATTED_DEFAULT’ was not declared in this scope
  814 |         PQsetErrorVerbosity(pgsql_conn, PSERRORS_FORMATTED_DEFAULT);
      |                                         ^~~~~~~~~~~~~~~~~~~~~~~~~~
make[1]: *** [Makefile:178: obj/PgSQL_Connection.oo] Error 1

applying missing patch fmt_err_msg.patch in deps/Makefile fixes issue

cd postgresql/postgresql && patch -p0 < ../fmt_err_msg.patch

[mirostauder]

error linking proxysql

...
g++ -o proxysql obj/main.o obj/proxysql_global.o obj/SQLite3_Server.o obj/proxy_tls.o  ../lib/libproxysql.a ../deps/cityhash/cityhash/src/.libs/libcityhash.a ../deps/clickhouse-cpp/clickhouse-cpp/clickhouse/libclickhouse-cpp-lib-static.a ../deps/lz4/lz4/lib/liblz4.a -std=c++17 -DCXX17 -I../include -I../deps/jemalloc/jemalloc/include/jemalloc -I../deps/mariadb-client-library/mariadb_client/include -I../deps/libconfig/libconfig/lib -I../deps/libdaemon/libdaemon -I../deps/re2/re2 -L../deps/pcre/pcre -I../deps/libmicrohttpd/libmicrohttpd/src/include -I../deps/libhttpserver/libhttpserver/src -I../deps/libinjection/libinjection/src -I../deps/curl/curl/include -I../deps/libev/libev/ -I../deps/prometheus-cpp/prometheus-cpp/pull/include -I../deps/prometheus-cpp/prometheus-cpp/core/include -I../deps/postgresql/postgresql/src/include -I../deps/postgresql/postgresql/src/interfaces/libpq -I../deps/libscram//include/ -I../deps/sqlite3/sqlite3 -I../deps/clickhouse-cpp/clickhouse-cpp -I../deps/clickhouse-cpp/clickhouse-cpp/contrib -I/usr/include -I -O2 -ggdb  -DPROXYSQLCLICKHOUSE -DGITVERSION=\"3.0.2-6-gd29bf8c\"     -L../lib -L../deps/jemalloc/jemalloc/lib -L../deps/mariadb-client-library/mariadb_client/libmariadb -L../deps/libconfig/libconfig/lib/.libs -L../deps/libdaemon/libdaemon/libdaemon/.libs -L../deps/re2/re2/obj -L../deps/pcre/pcre/.libs -L../deps/libmicrohttpd/libmicrohttpd/src/microhttpd/.libs -L../deps/libhttpserver/libhttpserver/build/src/.libs/ -L../deps/libinjection/libinjection/src -L../deps/curl/curl/lib/.libs -L../deps/libev/libev//.libs -L../deps/prometheus-cpp/prometheus-cpp/lib -L../deps/postgresql/postgresql/src/interfaces/libpq -L../deps/postgresql/postgresql/src/common -L../deps/postgresql/postgresql/src/port -L../deps/libusual/libusual/.libs/ -L../deps/libscram//lib/ -L/usr/lib64 -L../deps/coredumper/coredumper/src -L../deps/curl/curl/lib/.libs  -Wl,--export-dynamic -Wl,-Bstatic -lconfig -lproxysql -ldaemon -lconfig++ -lre2 -lpcrecpp -lpcre -lmariadbclient -lhttpserver -lmicrohttpd -linjection -lcurl -lev -lscram -lusual -lpq -lpgcommon -lpgport -ljemalloc -lcoredumper -Wl,-Bdynamic -lgnutls -lpthread -lssl -lcrypto -lm -lz -lrt -lprometheus-cpp-pull -lprometheus-cpp-core -luuid  -ldl
/usr/sbin/ld: cannot find ../deps/clickhouse-cpp/clickhouse-cpp/clickhouse/libclickhouse-cpp-lib-static.a: No such file or directory
/usr/sbin/ld: cannot find -lconfig: No such file or directory
/usr/sbin/ld: have you installed the static version of the config library ?
/usr/sbin/ld: cannot find -lconfig++: No such file or directory
/usr/sbin/ld: have you installed the static version of the config++ library ?
collect2: error: ld returned 1 exit status
make[1]: *** [Makefile:243: proxysql] Error 1

updating lib name to libclickhouse-cpp-lib.a in src/Makefile and deps/Makefile fixes the issue
fixing lib path to $(LIBCONFIG_PATH)/out in src/Makefile fixes the issue

[mirostauder]

error in mariadb-connector-c-3.3.8

...
In file included from /opt/proxysql/deps/mariadb-client-library/mariadb_client/libmariadb/ma_context.c:24:
/opt/proxysql/deps/mariadb-client-library/mariadb_client/include/ma_global.h:687:25: error: ‘bool’ cannot be defined via ‘typedef’
  687 | typedef char            bool;   /* Ordinary boolean values 0 1 */
      |                         ^~~~
/opt/proxysql/deps/mariadb-client-library/mariadb_client/include/ma_global.h:687:25: note: ‘bool’ is a keyword with ‘-std=c23’ onwards
/opt/proxysql/deps/mariadb-client-library/mariadb_client/include/ma_global.h:687:1: warning: useless type name in empty declaration
  687 | typedef char            bool;   /* Ordinary boolean values 0 1 */
      | ^~~~~~~

renaming bool to bbool in ./include/ma_global.h and ./unittest/libmariadb/ssl.c fixes the issue