For PostgreSQL, upgrade the DAM sensor and PostgreSQL plug-in to the versions released in Database Security 4.8.1.
For MySQL, upgrade the MySQL plug-in to the latest version released in Database Security 4.8.1.
For MariaDB, upgrade the MariaDB plug-in to the latest version released in Database Security 4.8.2.
MySQL extra details:
The MySQL client must send the
OS User and Application name for the Database Security to report the details. Not all versions and client programs send these details.
Currently, the
OS User and Application Name is only available when using the MySQL client (MySQL command-line client) in the following versions:
- MySQL client 5.6.15 and later report the Application Name.
- MySQL client 8.0.17 and later report the OS User and Application Name.
If you connect to MySQL using MySQL Connector, the
OS User is
NOT reported from the MySQL connector.
| Connection Type |
Client sends OS user |
Is value reported by Database Security? |
Comment |
| Remote |
Yes |
Yes |
The OS user sent by the MySQL client |
| Remote |
No |
No |
MySQL client didn't send the OS user |
| Local (Unix Socket) |
Yes |
Yes |
The OS user sent by the MySQL client |
| Local (Unix Socket) |
No |
Yes |
The user account under which the client process runs |
MySQL Application Name
| Connection Type |
Client sends Application Name |
Is value reported by Database Security? |
Comment |
| Remote |
Yes |
Yes |
The Application Name sent by the MySQL client |
| Remote |
No |
No |
MySQL client didn't send the Application Name |
| Local (UNIX Socket) |
Yes |
Yes |
The Application Name sent by the MySQL client |
| Local (UNIX Socket) |
No |
Yes |
The client executable name |
PostgreSQL extra details:
- Database Security reports the Application name if the PostgreSQL client sends the details.
- PostgreSQL clients don't report the OS User. Hence, Database Security is unable to report OS user details in most of the scenarios. Example: Remote connect.
- Database Security can only report the OS User when the connection is established via UNIX socket, local connection.
| Connection Type |
Client sends Application Name |
Is value reported by Database Security? |
Comment |
| Remote |
No |
No |
PostgreSQL client isn't sending the OS User of the running process |
| Local (UNIX Socket) |
No |
Yes |
The user account under which the client process runs |
Postgres Application Name
| Connection Type |
Client sends Application Name |
Is value reported by Database Security? |
Comment |
| Remote |
Yes |
Yes |
The Application Name sent by the PostgreSQLclient |
| Remote |
No |
No |
PostgreSQL client didn't send the Application Name |
| Local (UNIX Socket) |
Yes |
Yes |
The Application Name sent by the PostgreSQL client |
| Local (UNIX Socket) |
No |
Yes |
The client executable name |
MariaDB extra details:
Connecting to MariaDB using the MySQL client:
The MySQL client must send the
OS User and Application name for the Database Security to report the details. Not all versions and client programs send these details.
Currently, the
OS User and Application Name is only available when using the MySQL client (the MySQL command-line client) in the following versions:
- MySQL client 5.6.15 and later report the Application Name.
- MySQL client 8.0.17 and later report the OS User and Application Name.
It's also needed to enable the Performance Schema feature for the monitored
MariaDB instance for the
MySQL client to report
Application Name and
OS User.
For the exact steps, see the
MariaDB documentation.
If you connect to MariaDB using MySQL Connector, the
OS User is NOT reported from the MySQL connector.
Connecting to MariaDB using the MariaDB client:
Currently, Application Name is only available when using the MariaDB client (the MariaDb command-line client) in the following versions:
- MariaDB client 10.0.5 and later report the Application Name.
IMPORTANT: None of the MariaDB client versions from 10.0.5 and later report the
OS User.
MariaDB OS User
| Connection Type |
Client sends OS User |
Is value reported by Database Security? |
Comment |
| Remote |
Yes |
Yes |
The OS User sent by the MySQL client
IMPORTANT: MariaDB client isn't sending the OS User |
| Remote |
No |
No |
MySQL/MariaDB client didn't send the OS User |
| Local (Unix Socket) |
Yes |
Yes |
The OS User sent by the MySQL/MariaDB client |
| Local (Unix Socket) |
No |
Yes |
The user account under which the client process runs |
MariaDB Application Name
| Connection Type |
Client sends Application Name |
Is value reported by Database Security? |
Comment |
| Remote |
Yes |
Yes |
The Application Name sent by the MySQL/MariaDB client |
| Remote |
No |
No |
MySQL/MariaDB client didn't send the Application Name |
| Local (Unix Socket) |
Yes |
Yes |
The Application Name sent by the MySQL/MariaDB client |
| Local (Unix Socket) |
No |
Yes |
The client executable name |
