[midPoint] Midpoint Separate Audit Database Issues

[Richard Richter]

Hi Jeremiah 

This sounds more like running the wrong script on the wrong DB. There is no apply_change() in the audit upgrade script as seen here: [ https://github.com/Evolveum/midpoint/blob/support-4.4/config/sql/native-new/postgres-new-upgrade-audit.sql | https://github.com/Evolveum/midpoint/blob/support-4.4/config/sql/native-new/postgres-new-upgrade-audit.sql ] 
I also check unlikely possibility of some wrong build, but my local extracted build has the file ...\midpoint-4.4.1\doc\config\sql\native-new\postgres-new-upgrade-audit.sql - also without any apply_change , only apply_audit_change . 
m_org upgrade is in the main upgrade script, so it seems like it was run against the audit database. 

Weren't the scripts overwritten accidentally with one another? Please, check their content as well, and compare them with the original files from the distribution package - of course, just the beginning and end is more than enough. 

Regards 

Richard Richter 
Software Developer 
Evolveum 



From: "midPoint General Discussion" <midpoint at lists.evolveum.com> 
To: "midPoint General Discussion" <midpoint at lists.evolveum.com> 
Cc: "Jeremiah Haywood" <jhaywo1 at ilstu.edu> 
Sent: Tuesday, February 22, 2022 5:41:27 PM 
Subject: [midPoint] Midpoint Separate Audit Database Issues 



Hello all, 



At ISU we have been pursuing the implementation of auditing to a separate database with Midpoint. We are running into some issues when upgrading from 4.4 to 4.4.1 where it seems that there are procedures referenced in postgres-new-upgrade-audit.sql that only exist in the main database. Has anyone come across similar issues? 



Steps taken so far: 



4.4: 

    * postgres-new.sql on main db 
    * postgres-new-quartz.sql on main db 
    * postgres-new-audit.sql on audit db 




4.4.1: 

    * postgres-new-upgrade.sql on main db 
    * postgres-new-upgrade-audit.sql on audit db 
    * 
        * Ran into issues with procedure apply_change() not existing and relation "m_org" does not exist 




Thank you, 



Jeremiah Haywood 

Lead IAM Administrator 

Office of Technology Solutions | Illinois State University 

Phone Number (309) 438-3829 



_______________________________________________ 
midPoint mailing list 
midPoint at lists.evolveum.com 
https://lists.evolveum.com/mailman/listinfo/midpoint 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.evolveum.com/pipermail/midpoint/attachments/20220222/ee7f1620/attachment.htm>