Unable to login into Lychee after upgrade

[niladrishekhar]

This is my old diagnostics -

 Config Information
    --------------
    version:                         040501
    check_for_updates:               1
    sorting_photos_col:              taken_at
    sorting_photos_order:            ASC
    sorting_albums_col:              max_taken_at
    sorting_albums_order:            ASC
    imagick:                         1
    skip_duplicates:                 0
    small_max_width:                 0
    small_max_height:                360
    medium_max_width:                1920
    medium_max_height:               1080
    lang:                            en
    layout:                          1
    image_overlay_type:              desc
    default_license:                 none
    compression_quality:             90
    full_photo:                      1
    delete_imported:                 0
    Mod_Frame:                       1
    Mod_Frame_refresh:               30
    thumb_2x:                        1
    small_2x:                        1
    medium_2x:                       1
    landing_page_enable:             0
    landing_owner:                   John Smith
    landing_title:                   John Smith
    landing_subtitle:                Cats, Dogs & Humans Photography
    landing_facebook:                https://www.facebook.com/JohnSmith
    landing_flickr:                  https://www.flickr.com/JohnSmith
    landing_twitter:                 https://www.twitter.com/JohnSmith
    landing_instagram:               https://instagram.com/JohnSmith
    landing_youtube:                 https://www.youtube.com/JohnSmith
    landing_background:              dist/cat.jpg
    site_title:                      Lychee v4
    site_copyright_enable:           1
    site_copyright_begin:            2019
    site_copyright_end:              2019
    additional_footer_text:          
    display_social_in_gallery:       0
    public_search:                   0
    SL_enable:                       0
    SL_for_admin:                    0
    public_recent:                   0
    recent_age:                      1
    public_starred:                  0
    downloadable:                    0
    photos_wraparound:               1
    map_display:                     0
    zip64:                           1
    map_display_public:              0
    map_provider:                    Wikimedia
    force_32bit_ids:                 0
    map_include_subalbums:           0
    update_check_every_days:         3
    has_exiftool:                    1
    share_button_visible:            0
    import_via_symlink:              0
    has_ffmpeg:                      1
    location_decoding:               0
    location_decoding_timeout:       30
    location_show:                   1
    location_show_public:            0
    rss_enable:                      0
    rss_recent_days:                 7
    rss_max_items:                   100
    prefer_available_xmp_metadata:   0
    editor_enabled:                  1
    lossless_optimization:           0
    swipe_tolerance_x:               150
    swipe_tolerance_y:               250
    local_takestamp_video_formats:   .avi|.mov
    log_max_num_line:                1000
    unlock_password_photos_with_url_param: 0
    nsfw_visible:                    1
    nsfw_blur:                       0
    nsfw_warning:                    0
    nsfw_warning_admin:              0
    map_display_direction:           1
    album_subtitle_type:             oldstyle
    upload_processing_limit:         4
    public_photos_hidden:            1
    new_photos_notification:         0
    legacy_id_redirection:           1

I was facing some issues with exif adapter and hence tried to upgrade - post upgrade I am not able to login.
Application tells me Wrong login or password.

I have the back up of the database - and have tried both ways

1. Git pull and upgrade
2. Also installed a fresh version of Lychee - moved the files under /public/uploads etc.

How can I go for fixing this - any lead will be appreciated.

[ildyria]

Hi,
do have:

• ssh access?
• DB access either via CLI or are able to enter commands from e.g. phpmyadmin

[niladrishekhar]

Hi @ildyria this is locally hosted. I have full access.

[ildyria]

Can you try:

git pull # that will put you on master
php artisan migrate # that will put the database on the latest version

If you know the username, you can try:

php artisan lychee:update_user <username> <password>

If that fails (because username is still hashed in the database, then try from the CLI:

mysql -u <DB USER> -p <DB NAME> -e 'UPDATE users SET username = "admin", password = "$2y$10$YXmyoVbQYcsvTqUpesuTFezp9y6IZmIvssxcIihESfnqiy12yN93y" WHERE id = 1;' 

This will update your admin user to username admin and password admin. From that point you should be able to login and change things.

[niladrishekhar]

Hi @ildyria thank you so much - I am now able to access Lychee - however I am not able to view the images - there is this rectangular box that shows the placeholder but not the image

Here is the diagnostics -

    Diagnostics
    -----------
        Warning: Dropbox import not working. dropbox_key is empty.
        Info: Latest version of PHP is 8.3
        Warning: Default timezone not properly set; you might experience strange results when importing photos without explicit EXIF timezone
        Error: /v***************git (and subdirectories) are not executable, check the permissions
        Info: Found 5 medium that could be generated.
              You can use `php artisan lychee:generate_thumbs medium 5` to generate them.
    
    System Information
    ------------------
        Lychee Version (git):                    master (0e1f7f8) -- Up to date (2 hours ago).
        DB Version:                              5.3.0
        
        composer install:                        --no-dev
        APP_ENV:                                 production
        APP_DEBUG:                               false
        APP_URL:                                 set
        APP_DIR:                                 default
        LOG_VIEWER_ENABLED:                      true
        LIVEWIRE_ENABLED:                        true
        
        System:                                  Linux
        PHP Version:                             8.2.19
        PHP User agent:                          Lychee/4 (https://lycheeorg.github.io/)
        Timezone:                                UTC
        Max uploaded file size:                  2G
        Max post size:                           2G
        Livewire chunk size:                     12.00 MB
        Max execution time:                      7200
        MySQL Version:                           10.11.6-MariaDB-0+deb12u1
        
        exec() Available:                        yes
        Imagick Available:                       1
        Imagick Enabled:                         1
        Imagick Version:                         1691
        GD Version:                              2.3.3
        Number of foreign key:                   12 found.
    
    Config Information
    ------------------
        version:                                 050300
        check_for_updates:                       1
        sorting_photos_col:                      taken_at
        sorting_photos_order:                    ASC
        sorting_albums_col:                      max_taken_at
        sorting_albums_order:                    ASC
        imagick:                                 1
        skip_duplicates:                         0
        small_max_width:                         0
        small_max_height:                        360
        medium_max_width:                        1920
        medium_max_height:                       1080
        lang:                                    en
        image_overlay_type:                      desc
        default_license:                         none
        compression_quality:                     90
        grants_full_photo_access:                1
        delete_imported:                         0
        mod_frame_enabled:                       1
        mod_frame_refresh:                       30
        thumb_2x:                                1
        small_2x:                                1
        medium_2x:                               1
        landing_page_enable:                     0
        force_migration_in_production:           1
        search_public:                           0
        hide_version_number:                     0
        SL_enable:                               0
        SL_for_admin:                            0
        recent_age:                              1
        grants_download:                         0
        photos_wraparound:                       1
        map_display:                             0
        zip64:                                   1
        map_display_public:                      0
        map_provider:                            Wikimedia
        force_32bit_ids:                         0
        map_include_subalbums:                   0
        update_check_every_days:                 3
        has_exiftool:                            1
        share_button_visible:                    0
        import_via_symlink:                      0
        has_ffmpeg:                              1
        location_decoding:                       0
        location_decoding_timeout:               30
        location_show:                           1
        location_show_public:                    0
        rss_enable:                              0
        rss_recent_days:                         7
        rss_max_items:                           100
        prefer_available_xmp_metadata:           0
        editor_enabled:                          1
        lossless_optimization:                   0
        swipe_tolerance_x:                       150
        swipe_tolerance_y:                       250
        local_takestamp_video_formats:           .avi|.mov
        log_max_num_line:                        1000
        unlock_password_photos_with_url_param:   0
        nsfw_visible:                            1
        nsfw_blur:                               0
        nsfw_warning:                            0
        nsfw_warning_admin:                      0
        nsfw_banner_override:                    
        map_display_direction:                   1
        album_subtitle_type:                     oldstyle
        upload_processing_limit:                 4
        new_photos_notification:                 0
        legacy_id_redirection:                   1
        zip_deflate_level:                       6
        SA_enabled:                              1
        default_album_protection:                1
        album_decoration:                        layers
        album_decoration_orientation:            row
        allow_username_change:                   1
        auto_fix_orientation:                    1
        use_job_queues:                          0
        random_album_id:                         starred
        use_last_modified_date_when_no_exif_date: 0
        layout:                                  justified
        date_format_photo_thumb:                 M j, Y, g:i:s A e
        date_format_photo_overlay:               M j, Y, g:i:s A e
        date_format_sidebar_uploaded:            M j, Y, g:i:s A e
        date_format_sidebar_taken_at:            M j, Y, g:i:s A e
        date_format_hero_min_max:                F Y
        date_format_hero_created_at:             M j, Y, g:i:s A T
        date_format_album_thumb:                 M Y
        upload_chunk_size:                       0
        nsfw_banner_blur_backdrop:               0
        search_pagination_limit:                 1000
        search_minimum_length_required:          4
        photo_layout_justified_row_height:       320
        photo_layout_masonry_column_width:       300
        photo_layout_grid_column_width:          250
        photo_layout_square_column_width:        200
        photo_layout_gap:                        12
        display_thumb_album_overlay:             always
        display_thumb_photo_overlay:             hover
        default_album_thumb_aspect_ratio:        1/1
        use_album_compact_header:                0
        login_button_position:                   left
        back_button_enabled:                     0
        back_button_text:                        Return to Home
        current_job_processing_visible:          1
        SA_random_thumbs:                        0

the nginx errorlog gives something like this -

2024/05/26 22:45:40 [error] 2419#2419: *312 FastCGI sent in stderr: "Passing INI directive through FastCGI: unable to set 'client_max_body_size'" while reading response header from upstream, client: 127.0.0.1, >
2024/05/26 22:45:45 [error] 2419#2419: *312 FastCGI sent in stderr: "Passing INI directive through FastCGI: unable to set 'client_max_body_size'" while reading response header from upstream, client: 127.0.0.1, >
2024/05/26 22:45:45 [error] 2419#2419: *312 FastCGI sent in stderr: "Passing INI directive through FastCGI: unable to set 'client_max_body_size'" while reading response header from upstream, client: 127.0.0.1, >
2024/05/26 22:45:47 [error] 2419#2419: *312 FastCGI sent in stderr: "Passing INI directive through FastCGI: unable to set 'client_max_body_size'" while reading response header from upstream, client: 127.0.0.1, >
2024/05/26 22:45:49 [error] 2419#2419: *312 FastCGI sent in stderr: "Passing INI directive through FastCGI: unable to set 'client_max_body_size'" while reading response header from upstream, client: 127.0.0.1, >
2024/05/26 22:45:50 [error] 2419#2419: *312 FastCGI sent in stderr: "Passing INI directive through FastCGI: unable to set 'client_max_body_size'" while reading response header from upstream, client: 127.0.0.1, >
2024/05/26 22:45:54 [error] 2419#2419: *312 FastCGI sent in stderr: "Passing INI directive through FastCGI: unable to set 'client_max_body_size'" while reading response header from upstream, client: 127.0.0.1, >
2024/05/26 22:45:54 [error] 2419#2419: *312 FastCGI sent in stderr: "Passing INI directive through FastCGI: unable to set 'client_max_body_size'" while reading response header from upstream, client: 127.0.0.1,

on trying to generate medium 5

root@Cerulean:/var/www/Lychee# php artisan lychee:generate_thumbs medium 5
PHP Warning:  Module "curl" is already loaded in Unknown on line 0
PHP Warning:  Module "exif" is already loaded in Unknown on line 0
PHP Warning:  Module "FFI" is already loaded in Unknown on line 0
PHP Warning:  Module "fileinfo" is already loaded in Unknown on line 0
PHP Warning:  Module "ftp" is already loaded in Unknown on line 0
PHP Warning:  Module "gd" is already loaded in Unknown on line 0
PHP Warning:  Module "gettext" is already loaded in Unknown on line 0
PHP Warning:  Module "gmp" is already loaded in Unknown on line 0
PHP Warning:  Module "imap" is already loaded in Unknown on line 0
PHP Warning:  Module "intl" is already loaded in Unknown on line 0
PHP Warning:  Module "mbstring" is already loaded in Unknown on line 0
PHP Warning:  Module "odbc" is already loaded in Unknown on line 0
PHP Warning:  Module "pgsql" is already loaded in Unknown on line 0
PHP Warning:  Module "shmop" is already loaded in Unknown on line 0
PHP Warning:  Module "snmp" is already loaded in Unknown on line 0
PHP Warning:  Module "soap" is already loaded in Unknown on line 0
PHP Warning:  Module "sockets" is already loaded in Unknown on line 0
PHP Warning:  Module "sqlite3" is already loaded in Unknown on line 0
PHP Warning:  Module "tidy" is already loaded in Unknown on line 0
PHP Warning:  Module "zip" is already loaded in Unknown on line 0
Will attempt to generate up to 5 medium images with a timeout of 600 seconds...
 0/5 [░░░░░░░░░░░░░░░░░░░░░░░░░░░░]   0%
In ImageHandler.php line 78:
                                   
  No suitable image handler found  
                                   

In FlysystemFile.php line 44:
                                 
  Filesystem::readStream failed  
                                 

In FlysystemFile.php line 41:
                                 
  Filesystem::readStream failed  
                                 

the logs contain two type of errors

Error	2024-05-26 19:48:00	production	App\Actions\HoneyPot\BasePipe::throwNotFound:42 The route uploads/small/6948aa632e25f87601ee54476620aad7.jpg could not be found.	Log index 507. Click the button to copy link to this log entry.
507
App\Actions\HoneyPot\BasePipe::throwNotFound:42 The route uploads/small/6948aa632e25f87601ee54476620aad7.jpg could not be found.

Error	2024-05-26 19:47:09	production	App\Image\Files\FlysystemFile::read:41 Filesystem::readStream failed	Log index 497. Click the button to copy link to this log entry.
497
App\Image\Files\FlysystemFile::read:41 Filesystem::readStream failed
App\Image\Files\FlysystemFile::read:44 Filesystem::readStream failed; caused by
App\Image\Handlers\ImageHandler::load:78 No suitable image handler found; caused by

Also when I try to download an image it gives an error message

Error 500 - HttpException
Unable to retrieve the file_size for file at location: big/b626baf0995ecd82013bbc7db169de0d.jpg.

[ildyria]

Error 2024-05-26 19:48:00 production App\Actions\HoneyPot\BasePipe::throwNotFound:42 The route uploads/small/6948aa632e25f87601ee54476620aad7.jpg could not be found. Log index 507. Click the button to copy link to this log entry.

This means that your router does not find the file and forwards the call to Lychee.
Can you check that there is indeed a file in your /public/ulpoads/small/6948aa632e25f87601ee54476620aad7.jpg ?

[niladrishekhar]

hi @ildyria
No file is present only index.html
but in /var/www/Lychee/public/uploads/uploads there are folders
thumb, big, medium,small etc.
the small folder contains all the files

should I move the directory var/www/Lychee/public/uploads/uploads to var/www/Lychee/public/uploads ?

[niladrishekhar]

hi @ildyria - the stupid and silly mistake I did was to place the uploads folder in a wrong place - and now that I have corrected it I am able to access the application and perform all the action - except for one - uploading a file - this gives an error -

HttpException

Given path () to the exiftool binary is invalid

PHPExif\Adapter\Exiftool::setToolPath:48 Given path () to the exiftool binary is invalid
App\Metadata\Extractor::createFromFile:98 Given path () to the exiftool binary is invalid; caused by

Error | 2024-05-30 13:59:28 | production | 128:/var/www/Lychee/app/Jobs/ProcessImageJob.php  Given path () to the exiftool binary is invalid  [{"file":"/var/www/Lychee/vendor/lychee-org/php-exif/lib/PHPExif/Adapter/Exiftool.php","line":101,"function":"setToolPath","class":"PHPExif\\Adapter\\Exiftool","type":"->"},{"file":"/var/www/Lychee/vendor/lychee-org/php-exif/lib/PHPExif/Adapter/Exiftool.php","line":132,"function":"getToolPath","class":"PHPExif\\Adapter\\Exiftool","type":"->"},{"file":"/var/www/Lychee/vendor/lychee-org/php-exif/lib/PHPExif/Reader/Reader.php","line":60,"function":"getExifFromFile","class":"PHPExif\\Adapter\\Exiftool","type":"->"},{"file":"/var/www/Lychee/app/Metadata/Extractor.php","line":98,"function":"read","class":"PHPExif\\Reader\\Reader","type":"->"},{"file":"/var/www/Lychee/app/Legacy/Actions/Photo/Create.php","line":132,"function":"createFromFile","class":"App\\Metadata\\Extractor","type":"::"},{"file":"/var/www/Lychee/app/Legacy/Actions/Photo/Create.php","line": |  
-- | -- | -- | -- | --




Error | 2024-05-30 13:59:28 | production | 128:/var/www/Lychee/app/Jobs/ProcessImageJob.php  Given path () to the exiftool binary is invalid  [{"file":"/var/www/Lychee/vendor/lychee-org/php-exif/lib/PHPExif/Adapter/Exiftool.php","line":101,"function":"setToolPath","class":"PHPExif\\Adapter\\Exiftool","type":"->"},{"file":"/var/www/Lychee/vendor/lychee-org/php-exif/lib/PHPExif/Adapter/Exiftool.php","line":132,"function":"getToolPath","class":"PHPExif\\Adapter\\Exiftool","type":"->"},{"file":"/var/www/Lychee/vendor/lychee-org/php-exif/lib/PHPExif/Reader/Reader.php","line":60,"function":"getExifFromFile","class":"PHPExif\\Adapter\\Exiftool","type":"->"},{"file":"/var/www/Lychee/app/Metadata/Extractor.php","line":98,"function":"read","class":"PHPExif\\Reader\\Reader","type":"->"},{"file":"/var/www/Lychee/app/Legacy/Actions/Photo/Create.php","line":132,"function":"createFromFile","class":"App\\Metadata\\Extractor","type":"::"},{"file":"/var/www/Lychee/app/Legacy/Actions/Photo/Create.php","line": |  
-- | -- | -- | -- | --

[ildyria]

Can you do command -v exiftool ?

[niladrishekhar]

[root@cerulean-gl62m7rd ~]# command -v exiftool
/usr/bin/vendor_perl/exiftool

[niladrishekhar]

[root@cerulean-gl62m7rd Downloads]# exiftool IMG-20240425-WA0016.jpg
ExifTool Version Number : 12.76
File Name : IMG-20240425-WA0016.jpg
Directory : .
File Size : 149 kB
File Modification Date/Time : 2024:05:05 14:24:19+05:30
File Access Date/Time : 2024:05:05 14:24:19+05:30
File Inode Change Date/Time : 2024:05:05 14:24:19+05:30
File Permissions : -rw-r--r--
File Type : JPEG
File Type Extension : jpg
MIME Type : image/jpeg
JFIF Version : 1.01
Resolution Unit : None
X Resolution : 1
Y Resolution : 1
Image Width : 964
Image Height : 1600
Encoding Process : Progressive DCT, Huffman coding
Bits Per Sample : 8
Color Components : 3
Y Cb Cr Sub Sampling : YCbCr4:2:0 (2 2)
Image Size : 964x1600
Megapixels : 1.5