Windows下CMake配置C++项目链接MariaDB与POCO框架的问题

首次尝试在CMake中为C++程序链接MariaDB（版本10.5.21），使用POCO库的DataMySQL模块，但构建时提示"MariaDB not found"。自定义的MariaDB路径变量未被POCO识别，根据POCO文档，其依赖MYSQL_ROOT_DIR、MYSQL_ROOT_INCLUDE_DIRS、MYSQL_ROOT_LIBRARY_DIRS这几个变量来定位数据库库文件。

核心问题 #

你自定义的变量是MARIADB_*前缀，但POCO的FindMySQL模块只识别MYSQL_前缀的变量；同时你的find_library调用未匹配Windows下MariaDB的实际库文件名（比如带前缀的libmariadb.lib或Debug版本的libmariadbd.lib）。

修改后的CMakeLists.txt #

cmake_minimum_required(VERSION 3.20)

project(Dance_Syllabuses_Backend VERSION 0.1 LANGUAGES CXX)

set(CMAKE_CXX_STANDARD 23)
set(CMAKE_CXX_STANDARD_REQUIRED ON)

set(CMAKE_ARCHIVE_OUTPUT_DIRECTORY ${CMAKE_BINARY_DIR}/lib)
set(CMAKE_LIBRARY_OUTPUT_DIRECTORY ${CMAKE_BINARY_DIR}/lib)
set(CMAKE_RUNTIME_OUTPUT_DIRECTORY ${CMAKE_BINARY_DIR}/bin)

# 改用POCO识别的MYSQL_前缀变量
set(MYSQL_ROOT_DIR "C:/Program Files/MariaDB 10.5")
set(MYSQL_ROOT_INCLUDE_DIRS "${MYSQL_ROOT_DIR}/include")
set(MYSQL_ROOT_LIBRARY_DIRS "${MYSQL_ROOT_DIR}/lib")

# 调整find_library，匹配Windows下MariaDB的库文件名，同时区分Debug/Release
find_library(MARIADB_LIB 
    NAMES mariadb libmariadb mariadbd libmariadbd
    PATHS ${MYSQL_ROOT_LIBRARY_DIRS}
    PATH_SUFFIXES debug release
)

if (MARIADB_LIB)
    message(STATUS "Found MariaDB: ${MARIADB_LIB}")
else()
    message(FATAL_ERROR "MariaDB not found")
endif()

# POCO配置选项必须放在add_subdirectory之前
set(ENABLE_NET OFF CACHE BOOL "Enable Net" FORCE)
set(ENABLE_ENCODINGS OFF CACHE BOOL "Enable Encodings" FORCE)
set(ENABLE_XML OFF CACHE BOOL "Enable XML" FORCE)
set(ENABLE_JSON OFF CACHE BOOL "Enable JSON" FORCE)
set(ENABLE_MONGODB OFF CACHE BOOL "Enable MongoDB" FORCE)
set(ENABLE_DATA_SQLITE OFF CACHE BOOL "Enable Data SQlite" FORCE)
set(ENABLE_REDIS OFF CACHE BOOL "Enable Redis" FORCE)
set(ENABLE_ZIP OFF CACHE BOOL "Enable Zip" FORCE)
set(ENABLE_PAGECOMPILER OFF CACHE BOOL "Enable PageCompiler" FORCE)
set(ENABLE_PAGECOMPILER_FILE2PAGE OFF CACHE BOOL "Enable File2Page" FORCE)
set(ENABLE_ACTIVERECORD OFF CACHE BOOL "Enable ActiveRecord" FORCE)
set(ENABLE_ACTIVERECORD_COMPILER OFF CACHE BOOL "Enable ActiveRecord Compiler" FORCE)
set(ENABLE_DATA_MYSQL ON CACHE BOOL "Enable MySQL" FORCE)

add_subdirectory(external/POCO)

add_executable(application
    include/customer_dao.hpp
    include/customer.hpp
    include/scope_guard.hpp
    src/customer_dao.cpp
    src/customer.cpp
    src/main.cpp)
target_include_directories(application PRIVATE ${CMAKE_CURRENT_SOURCE_DIR}/include)
target_link_libraries(application PRIVATE Poco::Data Poco::DataMySQL)

关键修改点 #

• 变量前缀替换：将MARIADB_*改为MYSQL_*，确保POCO的配置脚本能读取到MariaDB的路径信息。
• 优化find_library：
  • 增加多个可能的库文件名（Windows下MariaDB的库可能是libmariadb.lib或mariadb.lib，Debug版本可能带d后缀）
  • 添加PATH_SUFFIXES debug release，覆盖MariaDB安装目录下的Debug/Release子目录
• 保持配置顺序：POCO的ENABLE_*选项必须放在add_subdirectory(external/POCO)之前，确保配置生效。

额外检查项 #

1. 确认MariaDB安装路径C:/Program Files/MariaDB 10.5下存在include/mysql.h（或include/mariadb/mysql.h）头文件
2. 确认lib目录下存在对应的库文件（比如libmariadb.lib或mariadb.lib）
3. 如果使用64位编译器，确保MariaDB安装的是64位版本，避免架构不匹配

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