For PostgreSQL, upgrade DAM sensor and PostgreSQL plug-in to the versions released in Database Security 4.8.1.
For MySQL, upgrade MySQL plug-in to the latest version released in Database Security 4.8.1.
For MariaDB, upgrade MariaDB plug-in to the latest version released in Database Security 4.8.2.
MySQL extra details:
The MySQL client must send
OS User and Application name for the Database Security to report the details. Not all versions and client programs send these details.
Currently,
OS User and Application Name is only available when using the MySQL client (the MySQL command-line client) in the following versions:
- MySQL client versions 5.6.15 and later, report the Application Name.
- MySQL client versions 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 did not 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 did not 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 do not 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 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 is not sending 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 did not 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
OS User and Application name for the Database Security to report the details. Not all versions and client programs send these details.
Currently,
OS User and Application Name is only available when using the MySQL client (the MySQL command-line client) in the following versions:
- MySQL client versions 5.6.15 and later, report the Application Name.
- MySQL client versions 8.0.17 and later, report the OS User and Application Name.
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 versions 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 is not sending the OS User) |
| Remote |
No |
No |
MySQL/MariaDB client did not 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 did not 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. |
