The MySQL component for open.mp servers.

Current release: R42

Current maintainer: Knogle

• CI pipelines for GitHub Actions and GitLab CI (Linux + optional Windows).
• CI checks on every push and pull request.
• Automated package creation for GitHub and GitLab releases.
• Build and compatibility refresh for modern open.mp environments.
• Removed old samp-log-core/logcore dependency; logging now uses open.mp core logging (ICore::logLn) directly.

1. Download the latest release archive from the Releases page.
2. Extract it into your open.mp server root.
3. Copy the full release contents while preserving structure:
   • components/mysql.so (Linux) or components/mysql.dll (Windows)
   • libmariadb.so.3 (Linux) or libmariadb.dll (Windows) in the server root
4. No config.json changes are required.

The component supports open.mp config-based logging toggles:

• logging.mysql
• logging.mysql_debug
• logging.mysql_info
• logging.mysql_warning
• logging.mysql_error

libmariadb.so.3 must be available for the Linux component at runtime (32-bit).

If you use the official release archive, keep the bundled libmariadb.so.3 in the server root (components/..) and copy mysql.so to components/.

If you build/deploy manually without the bundled source build, install the 32-bit MariaDB connector library via your distro:

• Fedora:
  • sudo dnf install mariadb-connector-c.i686
• Ubuntu/Debian:
  • sudo dpkg --add-architecture i386
  • sudo apt update
  • sudo apt install libmariadb3:i386
• CentOS/RHEL/Alma/Rocky:
  • sudo dnf install mariadb-connector-c.i686

If you build this repository with the bundled Connector/C submodule (BUILD_BUNDLED_MARIADB_CONNECTOR=ON, default on Linux), libmariadb.so.3 is built from source and packaged automatically.

git clone https://github.com/Knogle/SA-MP-MySQL.git
cd SA-MP-MySQL
git submodule update --init --recursive

Default build is 32-bit (FORCE_32_BIT=ON).

Linux CI and local builds share the same Earthly targets and the same Docker build image.

Requirements:

• Docker
• Earthly

Build:

earthly --ci +linux-build --UBUNTU_VERSION=20.04

Release package:

earthly --ci +linux-package --UBUNTU_VERSION=20.04

Artifacts are exported locally to:

• dist/linux/mysql.so
• dist/linux/a_mysql.inc
• dist/linux/libmariadb.so.3
• dist/mysql-linux.tar.gz (package target)

For FORCE_32_BIT=ON, ensure 32-bit OpenSSL development files are installed:

• Ubuntu/Debian:
  • sudo dpkg --add-architecture i386
  • sudo apt update
  • sudo apt install libssl-dev:i386
• Fedora:
  • sudo dnf install openssl-devel.i686
• CentOS/RHEL/Alma/Rocky:
  • sudo dnf install openssl-devel.i686

cmake -S . -B build -DFORCE_32_BIT=ON -DCMAKE_POSITION_INDEPENDENT_CODE=ON
cmake --build build --parallel

Output:

• build/src/mysql.so

Build with the bundled MariaDB Connector/C to produce the packaged libmariadb.dll from source:

cmake -S . -B build -G "Visual Studio 17 2022" -A Win32 -DBUILD_BUNDLED_MARIADB_CONNECTOR=ON
cmake --build build --config Release --parallel

Output:

• build/src/Release/mysql.dll

Workflow file: .github/workflows/ci.yml GitLab pipeline file: .gitlab-ci.yml

Triggers:

• push
• pull_request (GitHub) / Merge Request pipeline (GitLab)
• release (published, GitHub) / Git tag pipeline (GitLab)
• workflow_dispatch (GitHub) / Run pipeline (web, GitLab)

Release behavior:

• Builds Linux and (optionally) Windows artifacts.
• Packages tagged builds via CPack.
• Publishes release entries automatically with package asset links.

Linux CI baseline:

• Ubuntu 20.04 is used inside docker/ci/linux-build.Dockerfile.
• Earthly targets in Earthfile are the single Linux build abstraction used by local and CI runs.

Migration path to Ubuntu 22.04:

• A dedicated compatibility probe job runs Linux Earthly builds with --UBUNTU_VERSION=22.04.
• The probe is non-blocking (allow_failure / continue-on-error) so release stability remains on 20.04 while migration is validated continuously.

Set the CI/CD variable WINDOWS_RUNNER_TAG to the tag of your Windows runner. If this variable is empty, GitLab CI builds/releases Linux only.

• Runtime target: open.mp servers
• SDK: open.mp SDK (submodule)
• Bundled dependencies in repo:
  • Boost headers
  • MariaDB Connector/C (Linux)

This project builds on the long work of the original SA-MP MySQL plugin contributors and maintainers.

R - Knogle's fork (R42) of the official SA-MP MySQL R41-4 plugin. B - Blefonix's fork (B42) of Knogle's fork.

This folder reproduces the R42 Linux release structure, but with binaries built locally from:

• repo: https://github.com/Knogle/SA-MP-MySQL
• branch: open.mp

• components/mysql.so
• libmariadb.so.3
• pawno/include/a_mysql.inc
• include/nonstd/string_view.hpp
• include/nonstd/span.hpp
• include/robin_hood.h
• lib/cmake/string-view-lite/*
• lib/cmake/span-lite/*
• lib/cmake/robin_hood/*
• LICENSE

Compared to the mysql-R42-Linux.tar.gz, these items were missing from a plain cmake --build output and were added during B42 packaging:

• LICENSE
• include/nonstd/string_view.hpp
• include/nonstd/span.hpp
• include/robin_hood.h
• lib/cmake/string-view-lite/*
• lib/cmake/span-lite/*
• lib/cmake/robin_hood/*

Already present from the build output:

• components/mysql.so
• libmariadb.so.3
• pawno/include/a_mysql.inc

Use components, not legacy SA-MP plugins.

1. Copy components/mysql.so -> <server_root>/components/mysql.so
2. Copy libmariadb.so.3 -> <server_root>/libmariadb.so.3
3. Copy pawno/include/a_mysql.inc -> your Pawn include path (usually <server_root>/pawno/include/)

Note: open.mp uses a Pawn toolchain fork often referred to as qawno. If your local setup uses qawno/include, place a_mysql.inc there (or keep a synced copy).

No config.json change is required for open.mp component loading.

Host: Ubuntu 24.04, x86_64, producing ELF32/i386 output.

Build deps used:

• cmake
• gcc-multilib
• g++-multilib
• libssl-dev:i386

Build commands:

cmake -S . -B build \
 -DFORCE_32_BIT=ON \
 -DCMAKE_POSITION_INDEPENDENT_CODE=ON \
 -DOPENSSL_INCLUDE_DIR=/usr/include \
 -DOPENSSL_CRYPTO_LIBRARY=/usr/lib/i386-linux-gnu/libcrypto.so \
 -DOPENSSL_SSL_LIBRARY=/usr/lib/i386-linux-gnu/libssl.so

cmake --build build --parallel

Why explicit OpenSSL paths: on this host, auto-detection picked incompatible/default paths for the bundled MariaDB Connector/C in 32-bit mode.

From tools/mysql directory:

tar -czf mysql-B42-Linux.tar.gz -C B42 .

• readelf -h components/mysql.so -> Class: ELF32, Machine: Intel 80386
• libmariadb.so.3 present in server root
• server starts and mysql component loads without missing library errors