Sessions not being audited when connecting through some IDEs

[vicmarbev]

Versions:

• webapp version: 1.35.9
• gateway version: 1.31.28

When connecting through pgcli and pgadmin the session audit is being stored properly:

But not when connecting through dbeaver:

Have you run into this issue? Is it something configuration-related?

[sandromello]

Hey @vicmarbev ,

Thank you for reporting this issue. I'm currently investigating it and will get back to you as soon as I have an update.

[sandromello]

Hey @vicmarbev .
This issue occurs when your client is not using the "simple query" protocol. We plan to add support in the near future for auditing the "extended query" protocol.

In DBeaver IDE for example, you need to change the option preferQueryMode to simple.

We're updating our documentation to add this information.
I'll keep this issue open until we have support to this type of protocol

[vicmarbev]

I can confirm that setting the preferQueryMode to simple in the driver makes it so the queries are audited. Thanks for the information!