User Defined Variables

[roninhaf]

Hi, I'm trying to create a User Defined Variable using the example described here https://php-audit.readthedocs.io/en/stable/miscellaneous.html#explicit-query-from-php

Unfortunately, the result logged is always NULL even though we're able to log everything else with PHP-Audit.

The environment used is CodeIgniter 3.1.11 and PHP 8.1.

I create the query as soon as the user is logged in.

How do you do it?

Any help would be appreciated :)

[prwater]

Hello Hafid,

It hard the tell what is the cause of your issue without access to your audit configuration file.

Here are some tips:

• Did you include the user defined variable in de expression for the column like in example 7?
• Rerun the audit command after you have modified the audit configuration file, e.g. bin/audit audit etc/audit.cfg.
• Look in the code of the triggers, the user defined variable must be in generated SQL statements.

If you can't solve your issue, share your audit configuration file with me.

Greetings,
Paul

[roninhaf]

Hello, thanks for your reply Paul,

Here is the config file audit.json

So we use the example 8 and yes we rerun the audit command but the configuration file has not been modified recently.

Here is how the user defined variable is triggered in the code:

protected function user_defined_variable_audit($id) { $this->db->query(sprintf('SET @audit_usr_id = %s', $id ?? 'null')); }

And the method is called as soon as the user successfully logs in.

[prwater]

Everything looks fine. This case is covered by this unit test. The only difference is query vs real_query, this should not mater.

• The variable $id is not null?
• Some data has been changed after the user logs in during the same page request?
• At next page requests the variable @audit_usr_id must be set again (this time using data stored in the session).

[roninhaf]

I can confirm that the variable $id is not null.

When you say at next page request to set the variable again using data stored in the session, are you talking about database session or PHP session?

[prwater]

The PHP session. The MySQL user defined variable @audit_usr_id will be lost as soon as PHP closes the connection to the MySQL instance (i.e. at the end of serving the page request).