Hi
I'm on a osTicket 1.12 installation, downloaded from an online server to my local MacBookPro in this directory "/Users/myuser/www/project-name/osticket/upload". I use MAMP for Apache and MySQL.
Notice: osTicket was already installed in "osticket/upload" on the remote server.

Version osTicket	v1.12.5 (933bb1f) 
Web Server Software	Apache/2.4.46 (Unix) OpenSSL/1.0.2u PHP/7.4.12 mod_wsgi/3.5 Python/2.7.13 mod_fastcgi/mod_fastcgi-SNAP-0910052141 mod_perl/2.0.11 Perl/v5.30.1
Version MySQL	5.7.32
Version PHP	7.4.12

I installed the plugin "Attachments on the Filesystem".
It works well, new uploaded attachments goes to filesystem instead of DB but I also had a lot of existing attachments in the DB that I need to migrate to files.

I launch from this folder "/Users/myuser/www/project-name/osticket/upload" the command:
php manage.php file backends
it prints

D -- In the database (AttachmentChunkedData)
6 -- upload_dir folder (from osTicket v1.6) (OneSixAttachments)
F -- Filesystem: /Users/myuser/www/project-name/osticket/upload/osTicketAttachments (FilesystemStorage)

osTicketAttachments is the attachments folder, so it seems all ok.

Now I launch
sudo php manage.php file migrate --backend D --to F --limit=1
but I get this error
IOError: /Users/myuser/www/project-name/osticket/upload/osTicketAttachments/b/b56944cb4722cc5cda9d1e23a3ea7fbc: Unable to open for reading Migrated 0 files

If I launch from "/setup/cli" I get this:

#!/usr/bin/env php
PHP Warning:  ini_set(): Headers already sent. You cannot change the session module's ini settings at this time in /........../osticket/upload/bootstrap.php on line 19

Warning: ini_set(): Headers already sent. You cannot change the session module's ini settings at this time in /......../osticket/upload/bootstrap.php on line 19
PHP Warning:  session_cache_limiter(): Cannot change cache limiter when headers already sent in /......../osticket/upload/bootstrap.php on line 21

Warning: session_cache_limiter(): Cannot change cache limiter when headers already sent in /......../osticket/upload/bootstrap.php on line 21
PHP Warning:  session_set_save_handler(): Cannot change save handler when headers already sent in /......../osticket/upload/manage.php on line 28
IOError: /......../osticket/upload/osTicketAttachments/b/b56944cb4722cc5cda9d1e23a3ea7fbc: Unable to open for reading
Migrated 0 files

Firstly, it's not clear from where I need to launch commands. It seems launching from project root gives less error than from setup/cli.

Since the problem seems the folder/files permissions I tried various things found on this forum.
At the moment the osTicketAttachments folder has this permission
drwxrwxrwx 43 myuser staff 1376 16 Gen 12:26 osTicketAttachments
and all the folders inside have these:
drwxrwxrwx 2 myuser staff 64 16 Gen 12:26 K

What user is Apache using? I launched this ps aux | egrep '(apache|httpd)' and it lists myuser (10 times).

Hope someone could help me. Thanks

  • KevinTheJedi replied to this.

  • Ok, after some manual work (creating 2 folder per letter (for example 'a' and 'A') and switching over the files starting with a lowercase letter into the lowercase letter folder and vice versa, i have no more errors.

    These are the linux command i used (in example 'a' and 'A'):

    1. first create all missing folders

    2. move correct files to folders

    3. when in folder 'a' >
      find . -name '[[:upper:]]*' -exec mv -t ../A {} +

    4. when in folder 'A'
      find . -name '[[:lower:]]*' -exec mv -t ../a {} +

    You can mark this as solved

    infocart

    That means it was able to create a file under /path/to/osTicketAttachments/ but it was unable to read from it after creating it. I would try setting the attachment folder (osTicketAttachments/) user/group to the apache user/group and retest.

    Cheers.

        KevinTheJedi Remember I'm working on my local machine with MAMP.
        Could you explain more your suggestion?

        Another consideration on this error:
        IOError: /Users/myuser/www/project-name/osticket/upload/osTicketAttachments/b/b56944cb4722cc5cda9d1e23a3ea7fbc: Unable to open for reading Migrated 0 files

        It says it's unable to read the file b56944cb4722cc5cda9d1e23a3ea7fbc but there is no file in that folder. No file in any folders. So the problem could be that it can't write

        Thanks

          It sounds like a permissions issue to me. Like it cannot write to that folder. Check the permissions on the folder.

          Hi
          I have a similar problem.

          For instance

          (root)/attachments/r/rgURzeAHNhxNAMcE2WuqRrsqCe9KmGI0: Unable to read from file

          #0 (root)/include/class.file.php(123): FilesystemStorage->passthru()
          #1 (root)/include/class.file.php(283): AttachmentFile->sendData()
          #2 (root)/file.php(67): AttachmentFile->download()
          #3 {main}

          I think it's a problem with uppercase and lowercase letters.

            I think it does.
            For example:

            Example 1

            (root)/attachments/P/P0Kr5omJ9Ic-gMyGGEqbk93DanvNWbfo: Unable to read from file

            #0 (root)/include/class.file.php(123): FilesystemStorage->passthru()
            #1 (root)/include/class.file.php(283): AttachmentFile->sendData()
            #2 (root)/file.php(67): AttachmentFile->download()
            #3 {main}

            https://<url helpdesk>

            It does create a 'P' (uppercase) folder (with different permissions) while i already have a 'p' (lowercase) folder. No files in the 'P' folder.

            Example 2

            (root)/attachments/j/jhLNlIgkUH26HUWfDdi4gGwY1AmWwp78: Unable to read from file

            #0 (root)/include/class.file.php(123): FilesystemStorage->passthru()
            #1 (root)/include/class.file.php(283): AttachmentFile->sendData()
            #2 (root)/file.php(67): AttachmentFile->download()
            #3 {main}

            https://<url helpdesk>


            It does create a 'j' (lowercase) folder (with different permissions) while i already have a 'J' (uppercase) folder. No files in the 'j' folder.

            Setup
            osTicket versie v1.17.2 (8fbc7ee)
            Web Server Software Apache/2.4.52 (Ubuntu)
            MySQLversie 10.6.11
            PHPversie 8.0.27
            Attachments on the filesystem plugin v0.3

              stiman

              Yea but if the file starts with a lowercase letter it should go into the lowercase letter folder and vice versa so it should have no issues with finding that file. Also, the permissions on the newer folders are indeed correct, should be 0751.

              Cheers.

                  OOH, i see. I did a backup of my old osTicket on Windows en placed it back. All my letter folder where merged by this backup.

                  Ok, after some manual work (creating 2 folder per letter (for example 'a' and 'A') and switching over the files starting with a lowercase letter into the lowercase letter folder and vice versa, i have no more errors.

                  These are the linux command i used (in example 'a' and 'A'):

                  1. first create all missing folders

                  2. move correct files to folders

                  3. when in folder 'a' >
                    find . -name '[[:upper:]]*' -exec mv -t ../A {} +

                  4. when in folder 'A'
                    find . -name '[[:lower:]]*' -exec mv -t ../a {} +

                  You can mark this as solved

                  7 months later

                  Had the same issue when migrating from AWS to Azure. Upper and lower case files were somehow in the same folder even though i did a direct copy. Moving them to the forrect case sensitive folder was the fix for me as well! Thanks

                  Write a Reply...