Osticket: attachments to file system error

[iromih]

i did activate plugin to save attachments to file server
i did follow this steps
https://github.com/osTicket/osTicket/issues/1243#issuecomment-54715803

but still the attachment save in database and in the attachments folder only create new empty folder every time i upload new attach

the attachments folder looks from inside like that new folder for every new attach

[JediKev]

@iromih

What are the errors from Apache/PHP error logs as well as Linux System Logs?

Cheers.

[iromih]

@iromih

What are the errors from Apache/PHP error logs as well as Linux System Logs?

Cheers.

where i can get this error , by the way i host it to host gator

[JediKev]

@iromih

Ask your host.

Also, ensure the attachments directory has the appropriate permissions/ownership.

Cheers.

[iromih]

i give it 777 permissions

[JediKev]

@iromih

Okay, is it owned by the Apache User/Group?

Cheers.

[iromih]

@iromih

Okay, is it owned by the Apache User/Group?

Cheers.

honestly i dont i dont know how how to do it it's cpanal web host, can u tell me how i can do it ?

[JediKev]

@iromih

Ask your host to do it. Or look it up online, either way.

Cheers.

[iromih]

ok, thanks alot

[iromih]

now after i changed permission to all the folders under attachment folder to 777 the the attach files appear in it but the database size didn't change, and the new attach cant appear in it is new folder till i change the folder permission to 777 manual

[JediKev]

@iromih

What do you mean? The db size isn’t supposed to change..?

Something is up with your permissions/ownership then. Make sure the folder is owned by Apache User/Group.

Cheers.

[iromih]

supposed DB size decrease after the attach file save to attach folder but its not ,
ill back to host again to see the Apache permission

[JediKev]

@iromih

When you upload a file with the FS plugin installed, a File record is created in the db under ost_file (which should _increase_ the db size VERY slightly), then the file data is stored on the filesystem (which does nothing to the db size), lastly an Attachment record is created in the database under ost_attachment (which should _increase_ the db size VERY slightly).

Do you mean the files that were SUPPOSED to be uploaded to the folder but instead was stored in the database should be moved to the Filesystem? If so, you are supposed to do this manually via the command line module:
php manage.php file migrate --backend D --to F

You will have to have command line access to your server though. (contact your host if you're not sure)

Cheers.

[iromih]

@iromih

When you upload a file with the FS plugin installed, a File record is created in the db under ost_file (which should _increase_ the db size VERY slightly), then the file data is stored on the filesystem (which does nothing to the db size), lastly an Attachment record is created in the database under ost_attachment (which should _increase_ the db size VERY slightly).

Do you mean the files that were SUPPOSED to be uploaded to the folder but instead was stored in the database should be moved to the Filesystem? If so, you are supposed to do this manually via the command line module:
php manage.php file migrate --backend D --to F

You will have to have command line access to your server though. (contact your host if you're not sure)

Cheers.

i understand this but in my case if i upload attach 10MB file size the DB increase the same 10 DB and the attach didn't appear in the attachment folder till i go to the new created folder and changed its permission from 1355 sometimes its 3355 sometimes other thing but when i change to 0777 then the attach appear in the folder, and still the data base the same size

[JediKev]

@iromih

Then it’s not actually uploading to the FS properly. You need the errors from Apache/PHP error logs.

Cheers.

[iromih]

i couldn't get the Apache/PHP error logs because my host account is shared account, what i should do now , and any advice which better host to for ostickets , by the way i tried bluehost and hostgator and same error i got

[iromih]

@JediKev in the data base have table name ost_file_chunk its the biggest one its contain the most size of the DB its size 173 MB and overhead with 53 MB however the whole DB size is 227 MB

[iromih]

UPADTE : files not stored in the DB i watch the DB size before and after upload attach nothing change , and also it didn't appear in the attach folder till i go manually change the new created folder permission too 775 however that i can download the attach before change the permission and before it appear in the folder , i cant understand what happend but that it what i found

[ntozier]

With out webserver/php error logs I do not think that anyone will be able to assist you. I recommend that you talk to your web host.

[iromih]

It's shared web host can't get error log

[ntozier]

So you talked to your web host and they will not give you the errors from the logs that your site is generating?

[yellowscream]

i'm facing the same issue..., when editing the PHAR file and letting the plugin make directories with CHMOD 0777 then folders are created and files are put into the folder.
But this only happens when creating a new ticket and adding an attachments. When sending a mail that gets fetched automatically , the file is not stored on the filesystem ... (my webuser = cpanel-username)

[JediKev]

@yellowscream

Have you:
1.) Enabled the plug-in.
2.) Saved the Changes in the plugin configs to ensure it can read from/write to the directory.
3.) Gone to Admin Panel > Settings > System and set the Store Attachments setting to the attachment directory.

Cheers.