Ubuntu 6.2下MariaDB ODBC连接报错：无法打开libmaodbc.so

在Ubuntu 6.2系统上尝试通过ODBC连接MariaDB时，出现报错：Can't open lib '/usr/lib64/libmaodbc.so' : file not found，已尝试多种方法但问题仍未解决，相关排查信息如下：

操作系统信息 #

Linux ubuntu 6.2.0-1013-raspi #15-Ubuntu SMP PREEMPT Fri Sep  8 18:53:11 UTC 2023 aarch64 aarch64 aarch64 GNU/Linux

文件权限 #

root@ubuntu:/usr/lib64# ls -l
total 2316
-rwxrwxrwx 1 root root 2365512 Sep 24 19:07 libmaodbc.so

libmaodbc.so文件信息 #

readelf -l /usr/lib64/libmaodbc.so

Elf file type is DYN (Shared object file)
Entry point 0x172d0
There are 7 program headers, starting at offset 64

ODBC配置 #

odbcinst -j
unixODBC 2.3.11
DRIVERS............: /etc/odbcinst.ini
SYSTEM DATA SOURCES: /etc/odbc.ini
FILE DATA SOURCES..: /etc/ODBCDataSources
USER DATA SOURCES..: /root/.odbc.ini
SQLULEN Size.......: 8
SQLLEN Size........: 8
SQLSETPOSIROW Size.: 8

cat /etc/odbcinst.ini
[MariaDB]
Description=MariaDB
Driver=/usr/lib64/libmaodbc.so
UsageCount=4

测试结果 #

isql -v -k "DRIVER={MariaDB};127.0.0.1;UID=admin;PWD=password"
[01000][unixODBC][Driver Manager]Can't open lib '/usr/lib64/libmaodbc.so' : file not found
[ISQL]ERROR: Could not SQLDriverConnect

内容的提问来源于stack exchange，提问作者Shoother