File storage plugin - still storing in Database

xmanflash

I have installed, enabled, setup the path (with a valid pathname - no path error) and sent a couple of test tickets and yet the files are still being stored in the database (checked in Mysql and file folder).What now?

ntozier

You have not provided us with any information about your setup, so I'm not real sure how it is you think that we could assist you troubleshooting this. Please help us to help you by reading and following the posting guidelines located in this thread: Please read before requesting assistance. The more information you give us the better we will be able to assist you.

peter

@[deleted] - did you change the storage backend in Admin Panel > Settings > Attachments?

xmanflash

Peter, you were right - this was not turned on - I have turned it on and the same thing happens - the file (a .jpg) is stored in the database.,Admin Panel > Settings > Tickets > "Store Attachments"Changed to "FileSystem"ntozier: I looked at your link but there is not much helpfulness there.The ticket system works really well, I am using the email redirection to fling emails into osTicket directly. These emails have attachments (I am not uploading them via teh web form) I get the email, I get the attachment in the right place and can view it. It just gets stored in the DB still, not the file folder as expected (now that I have it configured correctly)What should I do to help debug this?I am running 1.8.1 on PHP 5.3 with MySql 5+database, I am running suPHP mode, I have plenty of disk and memory - I suspect a small bug in the plugin architecture, which might be addressed by the new Amazon S3 code (design/bug fixes) but who knows!I would like to know if anyone actually has this working..Thanks,Pete

ntozier

The link that I provided was a not so subtle hint that you did not provide us with enough information to help you. I've installed the plugin on my 1.8.1ST system, configured it, enabled it, and tested it. It works okay for me. It does not work perfectly... and the file names get totally borked. But it puts the files exactly where I expected it to put them although I did have to rename it to open it in the file system because the file extension disappeared.If you properly configured the plugin and made sure that the path is writtable then when you go to: Admin Panel -> Settings -> Tickets -> "Store Attachments"The drop down should look like:"Filesystem: c:\path\to\osticket\attachments"If you are not seeing the path after the word "Filesystem" then I think that there is a problem. Also the plugin does not gracefully handle what happens if you disable it.

xmanflash

Hi Ntozier,Thanks for checking this out - I had to dip out for a while but am back now.By your investigations, it looks like the filename is unnecessarily still being converted to a database compatible name? (maybe MD5?)I did get your hint, but (as an ok php dev) the only thing that seemed relevant that I had not provided was the logs - there were no logs in the root folder, but I found /api/error_log was 700k - but no errors relating to file saving that I can see..The link I am using is "Filesystem: ../../osticketattachments" (one directory under the root).. But if the filenames are being borked, I probably would prefer to leave this option until it works properly..In the folder "osticketattachments" there are 50+ folders, all either letters of alphabet (both upper and lower case) and also numeric.The file permissions are 355 and there are no files in them.I just disabled and then deleted the file attachments plugin, and now am not getting any attachments at all in my tickets.. sigh!Who was working on this code? - I think he was also working on the S3 storage plugin.. Might be worth having a chat with him?Thanks,Pete

xmanflash

Actually - on further investigation..When I changed the filesystem folders from 355 to 755 , I can then see the files are all being created, with MD5 encoded name and in the correct folders (a A b B c C e.. etc)But when I click on the Link to the file in the ticket, I get a page that says:"The image “http://www.website.com/scp/attachment.php?id=10208&h=2b8ab8a8b36c2bc8774c6ab54ae298f8” cannot be displayed because it contains errors."The error page has a mime type of image/jpeg and this message is the alt text. I suspect the path is not correct but whatever the problem, the file is 0 bytes length. I made changes to the file class from 1.8.1.1 but that didn't seem to help at all.No error Log is generated. PHP 5.3, CENTOS 5Cheers,Pete

xmanflash

OK - Upgrading to 1.8.1.1 fixed it!!!!!My 1.8.1.1 manual updates didn't work properly obviously..I am a very happy camper again - thanks for all the assistance!

ntozier

Glad to help and thanks for posting your solution here. Hopefully someone else who is having a similar issue will see this thread and it will also help them. I'm going to close this thread since your issue has been resolved, but please feel free to post again if you have another question. :)