SQLSTATE[HY000] [2002] Connection refused

[stephenmeehanuk]

Hi,

I've got a fresh install, but I keep seeing this error on my staging server.

(PDOException(code: 2002): SQLSTATE[HY000] [2002] Connection refused at /home/ploi/lbf.website.uk/vendor/laravel/framework/src/Illuminate/Database/Connectors/Connector.php:65)

• I'm using Ploi, Ploi installs PHPRedis by default.
• I've installed Horizon, it's working
• commands like php please assets:generate-presets --queue and php please static:warm --queue work. I can see them in Horizon

Is there anything below that would trigger this error?

Here's the parts of the env that are related to Redis

BROADCAST_DRIVER=log
CACHE_DRIVER=redis
FILESYSTEM_DISK=local
QUEUE_CONNECTION=redis
REDIS_DATABASE=0
SESSION_DRIVER=file
SESSION_LIFETIME=120

MEMCACHED_HOST=127.0.0.1

REDIS_HOST=127.0.0.1
REDIS_PASSWORD=null
REDIS_PORT=6379

Here's my composer file (from staging server)

{
    "name": "statamic/statamic",
    "description": "Statamic",
    "keywords": [
        "statamic",
        "cms",
        "flat file",
        "laravel"
    ],
    "type": "project",
    "require": {
        "php": "^8.1",
        "guzzlehttp/guzzle": "^7.2",
        "laravel/framework": "^10.8",
        "laravel/horizon": "^5.16",
        "laravel/sanctum": "^3.2",
        "laravel/tinker": "^2.8",
        "statamic/cms": "^4.0"
    },
    "require-dev": {
        "barryvdh/laravel-debugbar": "^3.8.1",
        "fakerphp/faker": "^1.9.1",
        "laravel/pint": "^1.0",
        "laravel/sail": "^1.18",
        "mockery/mockery": "^1.4.4",
        "nunomaduro/collision": "^7.0",
        "phpunit/phpunit": "^10.1",
        "predis/predis": "^2.1",
        "spatie/laravel-ignition": "^2.0"
    },
    "config": {
        "optimize-autoloader": true,
        "preferred-install": "dist",
        "sort-packages": true,
        "allow-plugins": {
            "composer/package-versions-deprecated": true,
            "pestphp/pest-plugin": true,
            "php-http/discovery": true,
            "pixelfear/composer-dist-plugin": true
        }
    },
    "extra": {
        "laravel": {
            "dont-discover": []
        }
    },
    "autoload": {
        "psr-4": {
            "App\\": "app/",
            "Database\\Factories\\": "database/factories/",
            "Database\\Seeders\\": "database/seeders/"
        }
    },
    "autoload-dev": {
        "psr-4": {
            "Tests\\": "tests/"
        }
    },
    "minimum-stability": "dev",
    "prefer-stable": true,
    "scripts": {
        "pre-update-cmd": [
            "Statamic\\Console\\Composer\\Scripts::preUpdateCmd"
        ],
        "post-autoload-dump": [
            "Illuminate\\Foundation\\ComposerScripts::postAutoloadDump",
            "@php artisan package:discover --ansi",
            "@php artisan statamic:install --ansi"
        ],
        "post-root-package-install": [
            "@php -r \"file_exists('.env') || copy('.env.example', '.env');\""
        ],
        "post-create-project-cmd": [
            "@php artisan key:generate --ansi"
        ],
        "post-update-cmd": [
            "@php artisan vendor:publish --tag=laravel-assets --ansi --force"
        ]
    }
}

Environment

Environment
Application Name: Statamic
Laravel Version: 10.13.2
PHP Version: 8.2.7
Composer Version: 2.5.7
Environment: local
Debug Mode: OFF
URL: xxxxxxxxxxx
Maintenance Mode: OFF

Cache
Config: CACHED
Events: NOT CACHED
Routes: CACHED
Views: CACHED

Drivers
Broadcasting: log
Cache: redis
Database: mysql
Logs: stack / single
Mail: smtp
Queue: redis
Session: file

Statamic
Addons: 0
Antlers: runtime
Stache Watcher: Enabled
Static Caching: half
Version: 4.6.0 PRO

[duncanmcclean]

When do you see that error? When visiting your site / deploying code?

[stephenmeehanuk]

This happens when uploading images via the control panel

[duncanmcclean]

Are you able to provide the full stack trace?

[stephenmeehanuk]

Just spotted, this is a different error than I originally posted. I've not seen the original error since I updated the env settings. I'm using different env settings now.

BROADCAST_DRIVER=log
CACHE_DRIVER=file
FILESYSTEM_DISK=local
QUEUE_CONNECTION=redis
SESSION_DRIVER=file
REDIS_DATABASE=0
REDIS_CLIENT=phpredis
SESSION_LIFETIME=120

Here's the full error shown in laravel.log. This error is repeatable.

#29 /home/ploi/demo.website.co.uk/vendor/league/glide/src/Manipulators/Size.php(265): League\\Glide\\Manipulators\\Size->runCropResize()
#30 /home/ploi/demo.website.co.uk/vendor/league/glide/src/Manipulators/Size.php(73): League\\Glide\\Manipulators\\Size->runResize()
#31 /home/ploi/demo.website.co.uk/vendor/league/glide/src/Api/Api.php(102): League\\Glide\\Manipulators\\Size->run()
#32 /home/ploi/demo.website.co.uk/vendor/league/glide/src/Server.php(652): League\\Glide\\Api\\Api->run()
#33 /home/ploi/demo.website.co.uk/vendor/statamic/cms/src/Imaging/ImageGenerator.php(264): League\\Glide\\Server->makeImage()
#34 /home/ploi/demo.website.co.uk/vendor/statamic/cms/src/Imaging/ImageGenerator.php(172): Statamic\\Imaging\\ImageGenerator->generate()
#35 /home/ploi/demo.website.co.uk/vendor/statamic/cms/src/Imaging/ImageGenerator.php(155): Statamic\\Imaging\\ImageGenerator->doGenerateByAsset()
#36 /home/ploi/demo.website.co.uk/vendor/laravel/framework/src/Illuminate/Cache/Repository.php(438): Statamic\\Imaging\\ImageGenerator->Statamic\\Imaging\\{closure}()
#37 /home/ploi/demo.website.co.uk/vendor/statamic/cms/src/Imaging/ImageGenerator.php(153): Illuminate\\Cache\\Repository->rememberForever()
#38 /home/ploi/demo.website.co.uk/vendor/statamic/cms/src/Imaging/PresetGenerator.php(34): Statamic\\Imaging\\ImageGenerator->generateByAsset()
#39 /home/ploi/demo.website.co.uk/vendor/laravel/framework/src/Illuminate/Collections/Traits/EnumeratesValues.php(236): Statamic\\Imaging\\PresetGenerator->Statamic\\Imaging\\{closure}()
#40 /home/ploi/demo.website.co.uk/vendor/statamic/cms/src/Imaging/PresetGenerator.php(33): Illuminate\\Support\\Collection->each()
#41 /home/ploi/demo.website.co.uk/vendor/statamic/cms/src/Listeners/GeneratePresetImageManipulations.php(53): Statamic\\Imaging\\PresetGenerator->generate()
#42 /home/ploi/demo.website.co.uk/vendor/laravel/framework/src/Illuminate/Events/CallQueuedListener.php(107): Statamic\\Listeners\\GeneratePresetImageManipulations->handle()
#43 /home/ploi/demo.website.co.uk/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): Illuminate\\Events\\CallQueuedListener->handle()
#44 /home/ploi/demo.website.co.uk/vendor/laravel/framework/src/Illuminate/Container/Util.php(41): Illuminate\\Container\\BoundMethod::Illuminate\\Container\\{closure}()
#45 /home/ploi/demo.website.co.uk/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(93): Illuminate\\Container\\Util::unwrapIfClosure()
#46 /home/ploi/demo.website.co.uk/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(35): Illuminate\\Container\\BoundMethod::callBoundMethod()
#47 /home/ploi/demo.website.co.uk/vendor/laravel/framework/src/Illuminate/Container/Container.php(662): Illuminate\\Container\\BoundMethod::call()
#48 /home/ploi/demo.website.co.uk/vendor/laravel/framework/src/Illuminate/Bus/Dispatcher.php(128): Illuminate\\Container\\Container->call()
#49 /home/ploi/demo.website.co.uk/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(141): Illuminate\\Bus\\Dispatcher->Illuminate\\Bus\\{closure}()
#50 /home/ploi/demo.website.co.uk/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(116): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#51 /home/ploi/demo.website.co.uk/vendor/laravel/framework/src/Illuminate/Bus/Dispatcher.php(132): Illuminate\\Pipeline\\Pipeline->then()
#52 /home/ploi/demo.website.co.uk/vendor/laravel/framework/src/Illuminate/Queue/CallQueuedHandler.php(123): Illuminate\\Bus\\Dispatcher->dispatchNow()
#53 /home/ploi/demo.website.co.uk/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(141): Illuminate\\Queue\\CallQueuedHandler->Illuminate\\Queue\\{closure}()
#54 /home/ploi/demo.website.co.uk/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(116): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#55 /home/ploi/demo.website.co.uk/vendor/laravel/framework/src/Illuminate/Queue/CallQueuedHandler.php(122): Illuminate\\Pipeline\\Pipeline->then()
#56 /home/ploi/demo.website.co.uk/vendor/laravel/framework/src/Illuminate/Queue/CallQueuedHandler.php(70): Illuminate\\Queue\\CallQueuedHandler->dispatchThroughMiddleware()
#57 /home/ploi/demo.website.co.uk/vendor/laravel/framework/src/Illuminate/Queue/Jobs/Job.php(98): Illuminate\\Queue\\CallQueuedHandler->call()
#58 /home/ploi/demo.website.co.uk/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(439): Illuminate\\Queue\\Jobs\\Job->fire()
#59 /home/ploi/demo.website.co.uk/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(389): Illuminate\\Queue\\Worker->process()
#60 /home/ploi/demo.website.co.uk/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(176): Illuminate\\Queue\\Worker->runJob()
#61 /home/ploi/demo.website.co.uk/vendor/laravel/framework/src/Illuminate/Queue/Console/WorkCommand.php(137): Illuminate\\Queue\\Worker->daemon()
#62 /home/ploi/demo.website.co.uk/vendor/laravel/framework/src/Illuminate/Queue/Console/WorkCommand.php(120): Illuminate\\Queue\\Console\\WorkCommand->runWorker()
#63 /home/ploi/demo.website.co.uk/vendor/laravel/horizon/src/Console/WorkCommand.php(51): Illuminate\\Queue\\Console\\WorkCommand->handle()
#64 /home/ploi/demo.website.co.uk/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): Laravel\\Horizon\\Console\\WorkCommand->handle()
#65 /home/ploi/demo.website.co.uk/vendor/laravel/framework/src/Illuminate/Container/Util.php(41): Illuminate\\Container\\BoundMethod::Illuminate\\Container\\{closure}()
#66 /home/ploi/demo.website.co.uk/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(93): Illuminate\\Container\\Util::unwrapIfClosure()
#67 /home/ploi/demo.website.co.uk/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(35): Illuminate\\Container\\BoundMethod::callBoundMethod()
#68 /home/ploi/demo.website.co.uk/vendor/laravel/framework/src/Illuminate/Container/Container.php(662): Illuminate\\Container\\BoundMethod::call()
#69 /home/ploi/demo.website.co.uk/vendor/laravel/framework/src/Illuminate/Console/Command.php(208): Illuminate\\Container\\Container->call()
#70 /home/ploi/demo.website.co.uk/vendor/symfony/console/Command/Command.php(326): Illuminate\\Console\\Command->execute()
#71 /home/ploi/demo.website.co.uk/vendor/laravel/framework/src/Illuminate/Console/Command.php(177): Symfony\\Component\\Console\\Command\\Command->run()
#72 /home/ploi/demo.website.co.uk/vendor/symfony/console/Application.php(1081): Illuminate\\Console\\Command->run()
#73 /home/ploi/demo.website.co.uk/vendor/symfony/console/Application.php(320): Symfony\\Component\\Console\\Application->doRunCommand()
#74 /home/ploi/demo.website.co.uk/vendor/symfony/console/Application.php(174): Symfony\\Component\\Console\\Application->doRun()
#75 /home/ploi/demo.website.co.uk/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(200): Symfony\\Component\\Console\\Application->run()
#76 /home/ploi/demo.website.co.uk/artisan(35): Illuminate\\Foundation\\Console\\Kernel->handle()
#77 {main}
"}

[stephenmeehanuk]

I have 26 glide presets (in this example website), I'm using max_upload_size preset and that's being used in Process Source Images I've left the default setting Intelligently Warm Presets on. I'm using Redis and Horizon.

Statamic generates an additional image depending on the format of the image being uploaded cp_thumbnail_small_landscape cp_thumbnail_small_square or cp_thumbnail_small_portrait so each directory in /public/img/containers/assets should have 27 images.

But, some of the directories only have three images? I'm not sure if this is related to the above error.

[stephenmeehanuk]

I've deleted one of the folders in /public/img/containers/assets that only had three images. Uploaded it again and all 27 image presets have been generated.

[stephenmeehanuk]

Here's my PHP setting

• Max upload filesize in MB 100
• Memory limit in MB 128
• Max execution time in seconds 30

[stephenmeehanuk]

I think the original issue was related to a mis-configured env. The other issue I'm not sure what's causing it. I'll close this and open a new discussion that's about the problem I'm having now.
#8321