AUDIT LOG some tables works and some not Why?

Questions and Answers on installation, deployment, management, locking, tranasactions of Servoy Application Server

AUDIT LOG some tables works and some not Why?

Postby Juan Etec » Sun Feb 28, 2021 9:21 am

Hi,
I am using the audit log form long.
I have realised that some tables that I thought that are logged does not work.
The audit log from this tables works in developer but not in the server.
Is there any way to know by process if that table has the JSSecurity.TRACKING in on?
Or how can I know which tables are with the TRACKING enabled?
It's seem that this property does not upload to the server.
when I import the solution in the server I check "Overwrite repository group security settings with import version"
Is this the way to upload that property?

I am using servoy version 2020.12.1 -releaseNumber 3623

Un Saludo
Un Saludo

Juan Ramírez
Juan Etec
 
Posts: 59
Joined: Mon Apr 20, 2009 8:23 pm
Location: Gran Canaria - Spain

Re: AUDIT LOG some tables works and some not Why?

Postby swingman » Mon Mar 01, 2021 1:07 am

Hi, in the 'Database Server' page in the servoy-admin pages of the server,
have you have selected your log server database as the current log server?

If you forget to do this you will not get any logging...
Christian Batchelor
Certified Servoy Developer
Batchelor Associates Ltd, London, UK
http://www.batchelorassociates.co.uk

http://www.postgresql.org - The world's most advanced open source database.
User avatar
swingman
 
Posts: 1374
Joined: Wed Oct 01, 2003 10:20 am
Location: London

Re: AUDIT LOG some tables works and some not Why?

Postby Juan Etec » Mon Mar 01, 2021 8:30 am

Hi Christian,
yes it is selected.
It's works in some tables.
Un Saludo

Juan Ramírez
Juan Etec
 
Posts: 59
Joined: Mon Apr 20, 2009 8:23 pm
Location: Gran Canaria - Spain

Re: AUDIT LOG some tables works and some not Why?

Postby swingman » Mon Mar 01, 2021 9:14 am

Strange. Are the users on the server in the same user groups as you have sent tracking for in Developer?
Christian Batchelor
Certified Servoy Developer
Batchelor Associates Ltd, London, UK
http://www.batchelorassociates.co.uk

http://www.postgresql.org - The world's most advanced open source database.
User avatar
swingman
 
Posts: 1374
Joined: Wed Oct 01, 2003 10:20 am
Location: London

Re: AUDIT LOG some tables works and some not Why?

Postby Juan Etec » Mon Mar 01, 2021 10:09 am

Yes.
I use only one group for all user.
Un Saludo

Juan Ramírez
Juan Etec
 
Posts: 59
Joined: Mon Apr 20, 2009 8:23 pm
Location: Gran Canaria - Spain

Re: AUDIT LOG some tables works and some not Why?

Postby swingman » Mon Mar 01, 2021 10:36 am

I have run out of ideas based on my own mistakes...
Christian Batchelor
Certified Servoy Developer
Batchelor Associates Ltd, London, UK
http://www.batchelorassociates.co.uk

http://www.postgresql.org - The world's most advanced open source database.
User avatar
swingman
 
Posts: 1374
Joined: Wed Oct 01, 2003 10:20 am
Location: London


Return to Servoy Server

Who is online

Users browsing this forum: No registered users and 1 guest