SecuritySuite - SuiteCRM and CE Teams

Control what your users can access and save time, money, and frustrations. Lock down sensitive data in SugarCRM or SuiteCRM to specific groups or teams. Supports unlimited assigned users, unlimited group assignments to records, custom layouts for each group, login/sudo capabilities and much more.

Free Trial

By clicking you consent to share your profile with the developer

#79 - email attachments does not show

Open Bug? created by Noam 11 years ago

Thank you for this great addon module.

I installed the module on sugar version 6.5.9 and seems like it works as expected except from one issue. We use the inbound mail to open cases in the system (support helpdesk) and when an email contains an attachment (PDF, Image, Office Doc etc) , only admin user can view that attachment, regular users cannot see it at all although they can view the case and the mail.

Can you please check and see if this is a bug or just a missed configuration directive on our installation?

Thank you!

Noam

(Upgrading to newer Sugar version is not an option at the moment)

eggsurplus Provider Affiliate
11 years ago

Very interesting. I will try to recreate the issue. However, I don't recall attachments having separate permissions applied to them.

reply
Noam
11 years ago

Hi,

Thanks for the reply. Any good news about this issue? I tried various solutions but nothing worked for me.

Noam

reply
- eggsurplus Provider Affiliate
  11 years ago
  
  Curious, what are the permissions set to for the Emails module for the non-admin users that are having issues?
  
  reply
eggsurplus Provider Affiliate
11 years ago

So the group is inheriting to the email that gets created, but not to the note that gets created and associated to the email. It looks like the note is where the attachment is being stored. I'm not sure on the best long term solution yet. Do you happen to be able to code? If so, temporarily I'd suggest creating an after_relationship_add hook that checks for when a note gets added to an email. When it does then add all groups from the email to the note.

reply
Noam
11 years ago

Hi

Thank you once again for checking this issue. I do php coding for many years but am not so familiar with the SugarCRM system so solving it as you suggested is not a straight forward for me. However, i tried to deal with it on the MySQL level (tried to add the permissions directly via the DB) but could not find how to do that since i can't find what values i need to modify in which tables.

Do you think that such solution is possible? Can you guide me please and point me to the tables and fields that need to be modified? I can then run it through cron and make the changes once a new case is opened.

Noam

reply
- eggsurplus Provider Affiliate
  11 years ago
  
  Here is the key table for linking a record to a group. For linking a note to a group replace the variables: insert into securitygroups_records(id,securitygroup_id,record_id,module,date_modified,deleted) select uuid(),securitygroups.id,notes.id,'Notes',now(),0 from securitygroups, notes where securityroups.id = '{SECURITYGROUP_ID}' and notes.id = '{NOTE_ID}';
  
  Time is really tight the next 3 weeks. After SugarCon is over I'll work on a full solution for this.
  
  reply
suhas
10 years ago

Hi,I'm using sugarCE 6.5 I am having issue in email module, When I compose mail and try to attach some document from local system its uploading on server, but not showing in attachment. Its working fine on my local system. I think sugar is not creting record in notes. If problem is beacuse of permissions I have also given all read right permissons .

reply
- eggsurplus Provider Affiliate
  10 years ago
  
  That sounds like a completely different issue than what this support case is for. However, if it is working locally and not in production then it is almost always due to file permissions. For more general SugarCRM issues your best bet for help is to check out the community forums at: https://community.sugarcrm.com/sugarcrm
  
  reply