[SOLVED] Logging of system configuration changes

[kassaik]

Dear forum members,

I've already looked at a number of pages on Google, and i looked the documentation too about whether a change to the system configuration could be logged. But I didn't find any way to do that.

My question would be, is it possible to set this up at all? If so, where can this be done?

Thank you for your answers!

Regards,
kassaik

[root]

Hi,

Changes and the optional comments on the system configuration are availabe in the table sysconfig_deployment, no GUI option so far in the Community Edition.

- Roy

[skullz]

Either you can manually check exported modified configuration (System Configuration > Import/Export > Export)
or running the sql.

As a basic, the below sql should do

SQL For Current Changes (Unique)

Code: Select all

 SELECT 
  sm.NAME, 
  sm.effective_value AS MODIFIED_VALUE, 
  sd.effective_value AS DEFAULT_VALUE,
  sm.change_time AS MODIFIED_TIME, 
  CONCAT_WS(' ', u.first_name, u.last_name) AS MODIFIED_BY 
  FROM sysconfig_modified sm
  JOIN sysconfig_default sd ON (sm.sysconfig_default_id=sd.id)
  JOIN users u ON (sm.change_by=u.id)

SQL For All the System Configuration Changes (may contains multiple value per name)

Code: Select all

SELECT 
  smv.name, 
  smv.effective_value AS MODIFIED_VALUE, 
  sdv.effective_value AS DEFAULT_VALUE,
  smv.change_time AS MODIFIED_TIME, 
  CONCAT_WS(' ', u.first_name, u.last_name) AS MODIFIED_BY 
  FROM sysconfig_modified_version smv
  JOIN sysconfig_default_version sdv ON (smv.sysconfig_default_version_id=sdv.id)
  JOIN users u ON (smv.change_by=u.id)
  ORDER BY smv.name  

[kassaik]

Thank you so much for the quick answers Roy and Skullz!

I knew what was in the database, I would be interested at the level of linux files. In this case, it stays in the database.

Thanks again!

Regards,
kassaik