Cannot open attachment

Version 6.5.11

We migrated our SugarCRM app to a new server, and while everything else is running fine, we found that the attachments uploaded cannot be opened, giving error in the log:

[Mon Oct 12 03:05:18.260478 2015] [core:error] [pid 49957] (13)Permission denied: [client 219.92.23.52:55972] AH00132: file permissions deny server access: /var/www/vhosts/crm.smssb.com/cache/jsLanguage/en_us.js, referer: http://crm.smssb.com/index.php?action=ajaxui

The user can view the attachment as successfully uploaded but when trying to open the file they see the below error in the web page:
This document is missing a file, most likely due to an error during upload.

How can I solve this?

0 Francesca Shiekh over 8 years ago

Check where you upload directory is (from your config file), generally I believe it's <sugar_root>/upload/ and make sure that when you moved your files to your new server you also copied the attachments directory. The actual attachments are stored on the file system by attachment.id, the files themselves are not the database.
What you see via the interface is the record in the database which in turn points to the file on the application server.

HTH
FrancescaS
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Karishma Tiwari over 8 years ago

FrancescaS, thanks for your reply. I do notice that the last file in the upoad folder was in April 2015, and we moved to a new server sometime in May 2015. All other uploads from then till now has never been update :(
My upload folder had this permission: drwxr-xr-x, should i open it to 775?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Francesca Shiekh over 8 years ago in reply to Karishma Tiwari

I have mine at 775, I use this from root to set all dirs at 775 and all files at 664:

sudo chown -R apache:apache *

sudo find . -type d -exec chmod 775 {} \;

sudo find . -type f -exec chmod 664 {} \;
Check your config and config_override files, the configs should tell you where your uploads are going. Maybe it was changed to point somewhere else. Also check disk space and make sure you have enough. I would have thought that you would get an error if the system could not write the attachments.
HTH
FrancescaS
Cancel
Vote Up +1 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Karishma Tiwari over 8 years ago in reply to Karishma Tiwari

is it necessary to change the file ownership to apache?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Karishma Tiwari over 8 years ago in reply to Karishma Tiwari

I tried the below, seems like we have no user as apache. Would it be ok to open the folder to 777?:

root@smsweb02:/var/www/vhosts/crm.smssb.com# sudo chown -R apache:apache uploadchown: invalid user: ‘apache:apache’
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Scott Aadal over 6 years ago in reply to Karishma Tiwari

Login to Sugar > Admin > Advanced > Set the max upload size, e.g 5000000. - This fixed it for us.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel