System is Debian 12 (updated), osticket version is v1.18.2
Osticket was 1.18.1 and this was updated today.
Database size grew to 100GB compressed, Decided to change backends
Activated the plugin per the docs. In my case I've used /var/www/osticket-attachments as the storage location. Everything is set correctly (enabled, backend is set to the plugin, etc).
Tickets are still going to the database. I've fixed this for now with a cron job that runs:
php /var/www/osticket/upload/manage.php file migrate --backend D --to F | logger -t OSTICKET_FILES
Thanks for that command. It's pretty awesome that you made something so we don't have to manually move files from the database (or write our own).
I have noticed a couple of emails that have the following:
/tmp/php1xYSdE: Unable to move file
This seems to be tied to pasting a screenshot into to ticket window vs attachnging a file. I'm pretty sure this error exists, because a few years (versions?) ago debian wants subdirectories for all applications using the tmp directory. Read more about: sysctl fs.protected_regular and debian tmp directories.
It's my understanding that OsTicket should create /tmp/ost_tmp (or something) and dump all tmp files there.
Now, whether or not the pasted screenshot issue and the attached file issues are related to this tmp issue, I have no idea, but I'm happy to test.
Anyone have any ideas?
