[MDEV-18975] Can't got correct message in server audit log when using ProxySQL with MariaDB Created: 2019-03-20  Updated: 2023-05-30  Resolved: 2023-05-30

Status: Closed
Project: MariaDB Server
Component/s: Plugin - Audit, Server
Affects Version/s: 10.3.13
Fix Version/s: N/A

Type: Bug Priority: Major
Reporter: Shawn Yan Assignee: Unassigned
Resolution: Incomplete Votes: 0
Labels: audit-plugin
Environment:

cat /etc/redhat-release
CentOS Linux release 7.6.1810 (Core)

uname -r
3.10.0-957.5.1.el7.x86_64

mysqld --version
mysqld Ver 10.3.13-MariaDB for Linux on x86_64 (MariaDB Server)

proxysql --version
ProxySQL version 1.4.15-1-g61bc777, codename Truls

mysqld --version
mysqld Ver 5.7.25-28 for Linux on x86_64 (Percona Server (GPL), Release 28, Revision c335905)

Attachments: Text File reappear.log     Text File testpercona.log    

 Description   

When using ProxySQL with MariaDB, we need using server audit plugin to record user connection information, like CONNECT/DISCONNECT/CHANGEUSER, but when we trigger CHANGEUSER operation, we can't get right message in server_audit.log, that replace with 'O' x 982.

But, when I test ProxySQL with Percona server for MySQL, I found that it display normally.

The reappear steps and more test result, please reference the attachment.

 Comments   
Comment by Ralf Gebhardt [ 2023-04-24 ]

shawn2016, can you do us a favor to verify if you still see the issues with a current version?

Generated at Thu Feb 08 08:48:09 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.