-
Notifications
You must be signed in to change notification settings - Fork 0
Changelog
Xyranaut edited this page Jun 1, 2026
·
2 revisions
All notable changes to omp-MySQL. Dates are release dates.
The first public, stable release.
Core
- Native open.mp component (Component SDK), drops into
components/. - Mandatory TLS, fail-closed — TLS 1.3 (MySQL 8.0+) / TLS 1.2 (5.7); refuses unencrypted connections.
- Fully asynchronous engine — one worker thread per connection; the main server tick never blocks.
- MariaDB Connector/C statically linked; OpenSSL as the TLS backend on all platforms (bundled on Windows).
API
- Industry-standard (JDBC/DB-API) naming:
mysql_connect,mysql_execute,mysql_prepare/mysql_stmt_*(1-based params),mysql_rs_*result sets. -
Prepared statements (injection-safe),
mysql_format%e/%q. -
Argon2id password hashing:
mysql_hash/mysql_verify(+ sync forms). -
Active-record models:
mysql_model_*. - VECTOR helpers for MySQL 9.0+ similarity search.
- Result cache API; connection compression (zstd/zlib).
-
${ENV}credential expansion; optional operator-keyed config obfuscation. - Connection guards: multi-statements off by default, opt-in rate/length/pending limits.
-
/-friendly debug logging (mysql_debug) + version/update reporting.
Tested
- Live MySQL 5.7.44, 8.0.46, 8.4.9 LTS, 9.2.0 — TLS + queries + prepared statements + caching_sha2 all pass. VECTOR verified on 9.x.
- Memory-clean under AddressSanitizer + UBSan; static leak/UAF/thread audit.
- Pentested: SQL injection (login/registration/command args), auth bypass (rejoin/slot-reuse), persistent-login enforcement, privilege bootstrap. See Security.
Platforms
- Ships Windows
.dll(+ bundledlibssl/libcrypto) and Linux.so, 32-bit (i386). - macOS
.dylibis a dev-only build (no macOS open.mp server), not released.
Demo
-
mysql-adminfilterscript: login/register, full player persistence, admin levels, RCON/mysqldiagnostics. Ships with the release.
Future releases will be listed here. Each entry documents what changed and what was tested/pentested for that version.
Understand
Use
- Installing MySQL
- Docker Compose
- Getting started
- Configuration
- SQL crash course
- Designing your tables
- Storing game data
- Dates & times
- First queries
- Async patterns
- Reading results
- Prepared statements
- Passwords & hashing
- Transactions
- Models (active-record)
- Tutorial: login system
- mysql-admin demo
Deeper
Reference