Build mysql drivers under AlmaLinux 9

[ocgltd]

I have Qt Creator installed on Alma Linux 9 and need to build the MySQL driver for Qt 5.15.2. Its very hard to find (the right) instructions online...and even harder to find something specific to the Red Hat family (CentOS/RH/AlmaLinux/Rocky/Fedora).

Whenever I run configure --sql-mysql I get the warning that prerequisites are not met for libs.mysql

But what prerequisite? Can anyone on the RH family help with some specific instructions on packages to install?

[SGaist]

Hi,

As silly as it may sound but did you install the MySQL or MariaDB development packages ?

[ocgltd]

@SGaist Yes - the only mysql/mariadb package available with dev in the name is mariadb-connector-c-devel and that's installed. I discovered that mariadb-devel is NOT available on EPEL or base repo's for AlmaLinux 9, so I installed it from a CentOS 9 repo. But still same problem.

I feel like something is missing but just can't figure out what package. The libqsqlmysql.so files shows all dependencies found:

ldd /usr/lib64/qt5/plugins/sqldrivers/libqsqlmysql.so
        linux-vdso.so.1 (0x00007ffeb6ab1000)
        libQt5Sql.so.5 => /lib64/libQt5Sql.so.5 (0x00007feda4702000)
        libQt5Core.so.5 => /lib64/libQt5Core.so.5 (0x00007feda4000000)
        libmariadb.so.3 => /lib64/libmariadb.so.3 (0x00007feda46ac000)
        libstdc++.so.6 => /lib64/libstdc++.so.6 (0x00007feda3c00000)
        libc.so.6 => /lib64/libc.so.6 (0x00007feda3800000)
        libsystemd.so.0 => /lib64/libsystemd.so.0 (0x00007feda45cf000)
        libz.so.1 => /lib64/libz.so.1 (0x00007feda45b3000)
        libicui18n.so.67 => /lib64/libicui18n.so.67 (0x00007feda3400000)
        libicuuc.so.67 => /lib64/libicuuc.so.67 (0x00007feda3a15000)
        libpcre2-16.so.0 => /lib64/libpcre2-16.so.0 (0x00007feda3f71000)
        libglib-2.0.so.0 => /lib64/libglib-2.0.so.0 (0x00007feda3e37000)
        libm.so.6 => /lib64/libm.so.6 (0x00007feda3725000)
        libgcc_s.so.1 => /lib64/libgcc_s.so.1 (0x00007feda4596000)
        /lib64/ld-linux-x86-64.so.2 (0x00007feda4772000)
        libssl.so.3 => /lib64/libssl.so.3 (0x00007feda335a000)
        libcrypto.so.3 => /lib64/libcrypto.so.3 (0x00007feda2e00000)
        libcap.so.2 => /lib64/libcap.so.2 (0x00007feda458c000)
        libgcrypt.so.20 => /lib64/libgcrypt.so.20 (0x00007feda2cc7000)
        liblzma.so.5 => /lib64/liblzma.so.5 (0x00007feda332e000)
        libzstd.so.1 => /lib64/libzstd.so.1 (0x00007feda3257000)
        liblz4.so.1 => /lib64/liblz4.so.1 (0x00007feda3233000)
        libicudata.so.67 => /lib64/libicudata.so.67 (0x00007feda1000000)
        libpcre.so.1 => /lib64/libpcre.so.1 (0x00007feda2c4f000)
        libgpg-error.so.0 => /lib64/libgpg-error.so.0 (0x00007feda2c29000)

[SGaist]

Did you look at the output of the tests to see exactly what made the check fail ?

[ocgltd]

I got a little further! I deleted config.cache and ran configure again and this time I thought it worked. Make and make install also seemed to work.

I'll report back on if this now works! But for other almalinux users, the keys were:

1. Download mariadb-devel from the CentOS repos - it's not available for AlmaLinux 9 yet
2. Delete the config.cache and run configure again.

How can I check individual test outputs? (To see exactly what is missing)

[SGaist]

There's usually either a log, or an output folder in the build folder.