Hi Friends,
I want to create a new column (field) inside cases_audit table and store the IP address of users who has modified or changed the audited field.
I am using SugarCRM community Edition 6.5.21 .
Any input would be of great help.
Regards,
AKG
Hi Friends,
I want to create a new column (field) inside cases_audit table and store the IP address of users who has modified or changed the audited field.
I am using SugarCRM community Edition 6.5.21 .
Any input would be of great help.
Regards,
AKG
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:
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.
I don't see any method with MysqliManager name. Can you please confirm?
Regards,
AKG
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.
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