Hello,I am wondering if it is possible to put the files attached to the tickets out of the DB.I am seeing my osTicket DB growing up very quickly and before having a too big one, I want to know if I can do something to externalize the attachments but keep the link between them and the DB.Thanks,Alex
Yes, and its been covered before here on the forums.See the following threads:http://forum.osticket.com/d/discussion//attachments-plug-in-storage-fshttp://forum.osticket.com/d/discussion//file-chunk-too-large-upgrade-problems
Really happy to see it is possible.So to be sure I well understood the other topic, I have to:- Get the storage-fs plugin (according to my version of osTicket?)- Install >Enable | Configure it- Execute the command: $ php setup/cli/manage.php file migrate --backend=D --to=F --limit=xxx --min-size=yyyWhere:xxx is the maximum number of files I want to migrate in the FS.yyy is the maximal size of files before automatic moving to the FS.One question:1. To automatize the moving of files, do I have to schedule a task executing the command line? Or I just have to configure the plugin? I have my answer. It is automatic as soon as I configure the plugin.
OK I configure it.It is very easy to use.I also migrated the file and it worked really nice.However, I have on remark, I tested it on my sandbox system (v1.9.4RC1) and the files are uploaded on the FS as soon as I add them to the ticket. I mean that the file should be uploaded when I decide to open the ticket only not when I attach them.Do you agree?
If its an existing ticket, I would think that they would upload when you attach them.If its while opening a new ticket I would think that it would wait until ticket creation... unless there is a clean up routine that deletes orphaned files on a regular basis. But even then with a server, a script and a large file I could see this being used to fill a filesystem .I'll ping the devs for this thread and see what they think.
Any news about that?
I tested also in 1.9.4RC5 and the problem is still there.I opened a GitHub issuehttps://github.com/osTicket/osTicket-1.8/issues/1391
