The Ultimate Guide to High Availability with MariaDB

Comments - MariaDB Audit Plugin - Log Settings

8 years, 7 months ago Joseph Martinez
Re: About the MariaDB Audit Plugin

How do I get the server audit function to record triggers and functions? This is what I have,:

CREATE TRIGGER `UpdateTransation` 
AFTER INSERT ON `Transactions` FOR EACH ROW 
BEGIN 
Declare vLastID int(10);
Declare vOrigQty int(10);
Declare vAmount int(10);
Declare vUpdateID int(10);
Select () into vLastID;
Select `Qty` From `Inventory`.`Transactions` Where `Transactions`.`idTransaction` = vLastID into vOrigQty;
Select `idInventory` From `Inventory`.`Transactions` Where `Transactions`.`idTransaction` = vLastID into vUpdateID;
Select `Qty` From `Inventory`.`Inventory` Where `idInventory` = vUpdateID into vAmount;
Update `Inventory`.`Inventory` Set `Inventory`.`Qty` = vOrigQty + vAmount Where `Inventory`.`idInventory` = vUpdateID;
End;

With this Insert statement:

Insert into `Inventory`.`Transactions` (`DTGofEntry`, `idAction`, `Qty`, `idUOM`, `Memo`, `User`, `Computer`, `idInventory`) Values ("2015-09-05 02:09:00", "2", "65", "2", "N/A", "martinez", "172.16.10.50", "1");

But I can not find out why it is not working, and that it is not being entered into the log.

 
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.