create custom fields in cases_audit table and save ip address

Hello Ashok Gupta,

Why you want to store the IP Address in audit table and why not in custom table ?

You can update the field using bean if fields are there in custom table when users modified the field.

Hi Venkatesh Prabhu,

I am creating a report where I need to track from which IP Address users has modified or changed the record.

Regards,

Ashok Gupta

Hi,

Let me know in case of any other information is required. Thanks.

Regards,

AKG

Hi Ashok Gupta 

It is not an easy task. Follow the steps to accomplish:

• Copy the script metadata/audit_templateMetaData.php into custom/metadata/audit_templateMetaData.php and add into custom metadata the field for storing the IP.
• Edit your config.php and update the attribute $sugar_config['dbconfig']['db_manager'] to 'CustomMysqliManager' (I'm considering your database is MySQL).
• Copy the file include/database/MysqliManager.php into custom/include/database/MysqliManager.php, update the class name to CustomMysqliManager and make it extends the original MysqliManager class.
• Remove all existing methods and copy the method MysqliManager from include/database/DBManager.php.
• Inside this new method setup the value of new field.

Go to Admin -> Repair -> Quick Repair and Rebuild

Hi Ashok Gupta 

It is not an easy task. Follow the steps to accomplish:

• Copy the script metadata/audit_templateMetaData.php into custom/metadata/audit_templateMetaData.php and add into custom metadata the field for storing the IP.
• Edit your config.php and update the attribute $sugar_config['dbconfig']['db_manager'] to 'CustomMysqliManager' (I'm considering your database is MySQL).
• Copy the file include/database/MysqliManager.php into custom/include/database/MysqliManager.php, update the class name to CustomMysqliManager and make it extends the original MysqliManager class.
• Remove all existing methods and copy the method MysqliManager from include/database/DBManager.php.
• Inside this new method setup the value of new field.

Go to Admin -> Repair -> Quick Repair and Rebuild

Hi Andre Lopes,

Thanks for your input. i am trying as mentioned above.

I have made the class like class CustomMysqliManager  extends MysqliManager 

However, point no 4. ie. 

• Remove all existing methods and copy the method MysqliManager from include/database/DBManager.php.

   I don't see any method with MysqliManager name. Can you please confirm?

Regards,

AKG

My bad!

The method to copy from DbManager is "auditSQL".

Regards

I have made the changes and done repair rebuild . But I get an error when we modify  config.php and change 

'dbconfig' to 'db_manager' => 'CustomMysqliManager',

Error: Fatal error: require_once(): Failed opening required 'include/database/CustomMysqliManager.php' 

Please let me know if i am missing any thing?

Regards,

AKG

Debug the method "getTypeInstance" in the script include/database/DBManagerFactory.php in order to identify why it didn't load the custom one.

Hi Andre Lopes,

Thanks its working now . 

I changed the file name to CustomMysqliManager.php from MysqliManager.php inside custom/include/database folder.

Its working now and storing something like   ::1  , which I believe for  localhost(IP)  its stores this way 

Regards,

AKG