Connection to DB is refused only from the website.
PHP 8.2.4
laravel 10.31.0
i have 2 server have the website.
1- has master DB.
2- has slave DB.
.env file for the db master server:
DB_CONNECTION=mysql
DB_HOST=localhost
DB_WRITE_HOST=
DB_PORT=3306
DB_DATABASE=
DB_USERNAME=
DB_PASSWORD=
DB_SSL_MODE=
MYSQL_ATTR_SSL_VERIFY_SERVER_CERT=false
MYSQL_ATTR_SSL_CA=
MYSQL_ATTR_SSL_KEY=
MYSQL_ATTR_SSL_CERT=
The database.php:
'mysql' => [
'read' => [
'host' => env( 'DB_HOST', '127.0.0.1' ),
'options' => []
],
'write' => [
'host' => env( 'DB_WRITE_HOST', '127.0.0.1' ),
'sslmode' => env( 'DB_SSL_MODE', false ) ? 'require' : 'prefer',
'options' => [], // <-- i add the SSl configuration for the slave to connect to the master.
],
'driver' => 'mysql',
'url' => env( 'DATABASE_URL' ),
'port' => env( 'DB_PORT', '3306' ),
'database' => env( 'DB_DATABASE', 'forge' ),
'username' => env( 'DB_USERNAME', 'forge' ),
'password' => env( 'DB_PASSWORD', '' ),
'unix_socket' => env( 'DB_SOCKET', '' ),
'charset' => 'utf8mb4',
'collation' => 'utf8mb4_unicode_ci',
'prefix' => '',
'prefix_indexes' => true,
'strict' => true,
'engine' => null,
],
on the read connection to DB everything goes fine.
on the write of any query it fails.
example:
IlluminateDatabaseQueryException:
SQLSTATE[HY000] [2002] No such file or directory (Connection: mysql, SQL: update `posts` set `views` = 643, `posts`.`updated_at` = 2024-07-04 13:22:04 where `id` = 42)
at /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Connection.php:829
at IlluminateDatabaseConnection->runQueryCallback()
(/var/www/html/vendor/laravel/framework/src/Illuminate/Database/Connection.php:983)
at IlluminateDatabaseConnection->tryAgainIfCausedByLostConnection()
(/var/www/html/vendor/laravel/framework/src/Illuminate/Database/Connection.php:962)
at IlluminateDatabaseConnection->handleQueryException()
(/var/www/html/vendor/laravel/framework/src/Illuminate/Database/Connection.php:785)
at IlluminateDatabaseConnection->run()
(/var/www/html/vendor/laravel/framework/src/Illuminate/Database/Connection.php:600)
at IlluminateDatabaseConnection->affectingStatement()
(/var/www/html/vendor/laravel/framework/src/Illuminate/Database/Connection.php:552)
at IlluminateDatabaseConnection->update()
(/var/www/html/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php:3560)
at IlluminateDatabaseQueryBuilder->update()
(/var/www/html/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php:1061)
at IlluminateDatabaseEloquentBuilder->update()
(/var/www/html/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php:1213)
at IlluminateDatabaseEloquentModel->performUpdate()
(/var/www/html/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php:1130)
at IlluminateDatabaseEloquentModel->save()
(/var/www/html/vendor/tcg/voyager/src/Models/Post.php:30)
at TCGVoyagerModelsPost->save()
(/var/www/html/app/Http/Controllers/PostsController.php:62)
at AppHttpControllersPostsController->show()
(/var/www/html/vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54)
at IlluminateRoutingController->callAction()
(/var/www/html/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43)
at IlluminateRoutingControllerDispatcher->dispatch()
(/var/www/html/vendor/laravel/framework/src/Illuminate/Routing/Route.php:259)
at IlluminateRoutingRoute->runController()
(/var/www/html/vendor/laravel/framework/src/Illuminate/Routing/Route.php:205)
at IlluminateRoutingRoute->run()
(/var/www/html/vendor/laravel/framework/src/Illuminate/Routing/Router.php:806)
at IlluminateRoutingRouter->IlluminateRouting{closure}()
(/var/www/html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:144)
at IlluminatePipelinePipeline->IlluminatePipeline{closure}()
(/var/www/html/app/Http/Middleware/Language.php:23)
at AppHttpMiddlewareLanguage->handle()
(/var/www/html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183)
at IlluminatePipelinePipeline->IlluminatePipeline{closure}()
(/var/www/html/vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php:50)
at IlluminateRoutingMiddlewareSubstituteBindings->handle()
(/var/www/html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183)
at IlluminatePipelinePipeline->IlluminatePipeline{closure}()
(/var/www/html/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php:78)
at IlluminateFoundationHttpMiddlewareVerifyCsrfToken->handle()
(/var/www/html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183)
at IlluminatePipelinePipeline->IlluminatePipeline{closure}()
(/var/www/html/vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php:49)
at IlluminateViewMiddlewareShareErrorsFromSession->handle()
(/var/www/html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183)
at IlluminatePipelinePipeline->IlluminatePipeline{closure}()
(/var/www/html/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php:121)
at IlluminateSessionMiddlewareStartSession->handleStatefulRequest()
(/var/www/html/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php:64)
at IlluminateSessionMiddlewareStartSession->handle()
(/var/www/html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183)
at IlluminatePipelinePipeline->IlluminatePipeline{closure}()
(/var/www/html/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/AddQueuedCookiesToResponse.php:37)
at IlluminateCookieMiddlewareAddQueuedCookiesToResponse->handle()
(/var/www/html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183)
at IlluminatePipelinePipeline->IlluminatePipeline{closure}()
(/var/www/html/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/EncryptCookies.php:67)
at IlluminateCookieMiddlewareEncryptCookies->handle()
(/var/www/html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183)
at IlluminatePipelinePipeline->IlluminatePipeline{closure}()
(/var/www/html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:119)
at IlluminatePipelinePipeline->then()
(/var/www/html/vendor/laravel/framework/src/Illuminate/Routing/Router.php:805)
at IlluminateRoutingRouter->runRouteWithinStack()
(/var/www/html/vendor/laravel/framework/src/Illuminate/Routing/Router.php:784)
at IlluminateRoutingRouter->runRoute()
(/var/www/html/vendor/laravel/framework/src/Illuminate/Routing/Router.php:748)
at IlluminateRoutingRouter->dispatchToRoute()
(/var/www/html/vendor/laravel/framework/src/Illuminate/Routing/Router.php:737)
at IlluminateRoutingRouter->dispatch()
(/var/www/html/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php:200)
at IlluminateFoundationHttpKernel->IlluminateFoundationHttp{closure}()
(/var/www/html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:144)
at IlluminatePipelinePipeline->IlluminatePipeline{closure}()
(/var/www/html/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php:21)
at IlluminateFoundationHttpMiddlewareTransformsRequest->handle()
(/var/www/html/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ConvertEmptyStringsToNull.php:31)
at IlluminateFoundationHttpMiddlewareConvertEmptyStringsToNull->handle()
(/var/www/html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183)
at IlluminatePipelinePipeline->IlluminatePipeline{closure}()
(/var/www/html/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php:21)
at IlluminateFoundationHttpMiddlewareTransformsRequest->handle()
(/var/www/html/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TrimStrings.php:40)
at IlluminateFoundationHttpMiddlewareTrimStrings->handle()
(/var/www/html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183)
at IlluminatePipelinePipeline->IlluminatePipeline{closure}()
(/var/www/html/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ValidatePostSize.php:27)
at IlluminateFoundationHttpMiddlewareValidatePostSize->handle()
(/var/www/html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183)
at IlluminatePipelinePipeline->IlluminatePipeline{closure}()
(/var/www/html/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/PreventRequestsDuringMaintenance.php:99)
at IlluminateFoundationHttpMiddlewarePreventRequestsDuringMaintenance->handle()
(/var/www/html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183)
at IlluminatePipelinePipeline->IlluminatePipeline{closure}()
(/var/www/html/vendor/laravel/framework/src/Illuminate/Http/Middleware/TrustProxies.php:39)
at IlluminateHttpMiddlewareTrustProxies->handle()
(/var/www/html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183)
at IlluminatePipelinePipeline->IlluminatePipeline{closure}()
(/var/www/html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:119)
at IlluminatePipelinePipeline->then()
(/var/www/html/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php:175)
at IlluminateFoundationHttpKernel->sendRequestThroughRouter()
(/var/www/html/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php:144)
at IlluminateFoundationHttpKernel->handle()
(/var/www/html/public/index.php:51)
PDOException:
SQLSTATE[HY000] [2002] No such file or directory
at /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Connectors/Connector.php:65
at PDO->__construct()
(/var/www/html/vendor/laravel/framework/src/Illuminate/Database/Connectors/Connector.php:65)
at IlluminateDatabaseConnectorsConnector->createPdoConnection()
(/var/www/html/vendor/laravel/framework/src/Illuminate/Database/Connectors/Connector.php:83)
at IlluminateDatabaseConnectorsConnector->tryAgainIfCausedByLostConnection()
(/var/www/html/vendor/laravel/framework/src/Illuminate/Database/Connectors/Connector.php:48)
at IlluminateDatabaseConnectorsConnector->createConnection()
(/var/www/html/vendor/laravel/framework/src/Illuminate/Database/Connectors/MySqlConnector.php:24)
at IlluminateDatabaseConnectorsMySqlConnector->connect()
(/var/www/html/vendor/laravel/framework/src/Illuminate/Database/Connectors/ConnectionFactory.php:184)
at IlluminateDatabaseConnectorsConnectionFactory->IlluminateDatabaseConnectors{closure}()
at call_user_func()
(/var/www/html/vendor/laravel/framework/src/Illuminate/Database/Connection.php:1339)
at IlluminateDatabaseConnection->getPdo()
(/var/www/html/vendor/laravel/framework/src/Illuminate/Database/Connection.php:608)
at IlluminateDatabaseConnection->IlluminateDatabase{closure}()
(/var/www/html/vendor/laravel/framework/src/Illuminate/Database/Connection.php:816)
at IlluminateDatabaseConnection->runQueryCallback()
(/var/www/html/vendor/laravel/framework/src/Illuminate/Database/Connection.php:983)
at IlluminateDatabaseConnection->tryAgainIfCausedByLostConnection()
(/var/www/html/vendor/laravel/framework/src/Illuminate/Database/Connection.php:962)
at IlluminateDatabaseConnection->handleQueryException()
(/var/www/html/vendor/laravel/framework/src/Illuminate/Database/Connection.php:785)
at IlluminateDatabaseConnection->run()
(/var/www/html/vendor/laravel/framework/src/Illuminate/Database/Connection.php:600)
at IlluminateDatabaseConnection->affectingStatement()
(/var/www/html/vendor/laravel/framework/src/Illuminate/Database/Connection.php:552)
at IlluminateDatabaseConnection->update()
(/var/www/html/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php:3560)
at IlluminateDatabaseQueryBuilder->update()
(/var/www/html/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php:1061)
at IlluminateDatabaseEloquentBuilder->update()
(/var/www/html/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php:1213)
at IlluminateDatabaseEloquentModel->performUpdate()
(/var/www/html/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php:1130)
at IlluminateDatabaseEloquentModel->save()
(/var/www/html/vendor/tcg/voyager/src/Models/Post.php:30)
at TCGVoyagerModelsPost->save()
(/var/www/html/app/Http/Controllers/PostsController.php:62)
at AppHttpControllersPostsController->show()
(/var/www/html/vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54)
at IlluminateRoutingController->callAction()
(/var/www/html/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43)
at IlluminateRoutingControllerDispatcher->dispatch()
(/var/www/html/vendor/laravel/framework/src/Illuminate/Routing/Route.php:259)
at IlluminateRoutingRoute->runController()
(/var/www/html/vendor/laravel/framework/src/Illuminate/Routing/Route.php:205)
at IlluminateRoutingRoute->run()
(/var/www/html/vendor/laravel/framework/src/Illuminate/Routing/Router.php:806)
at IlluminateRoutingRouter->IlluminateRouting{closure}()
(/var/www/html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:144)
at IlluminatePipelinePipeline->IlluminatePipeline{closure}()
(/var/www/html/app/Http/Middleware/Language.php:23)
at AppHttpMiddlewareLanguage->handle()
(/var/www/html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183)
at IlluminatePipelinePipeline->IlluminatePipeline{closure}()
(/var/www/html/vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php:50)
at IlluminateRoutingMiddlewareSubstituteBindings->handle()
(/var/www/html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183)
at IlluminatePipelinePipeline->IlluminatePipeline{closure}()
(/var/www/html/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php:78)
at IlluminateFoundationHttpMiddlewareVerifyCsrfToken->handle()
(/var/www/html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183)
at IlluminatePipelinePipeline->IlluminatePipeline{closure}()
(/var/www/html/vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php:49)
at IlluminateViewMiddlewareShareErrorsFromSession->handle()
(/var/www/html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183)
at IlluminatePipelinePipeline->IlluminatePipeline{closure}()
(/var/www/html/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php:121)
at IlluminateSessionMiddlewareStartSession->handleStatefulRequest()
(/var/www/html/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php:64)
at IlluminateSessionMiddlewareStartSession->handle()
(/var/www/html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183)
at IlluminatePipelinePipeline->IlluminatePipeline{closure}()
(/var/www/html/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/AddQueuedCookiesToResponse.php:37)
at IlluminateCookieMiddlewareAddQueuedCookiesToResponse->handle()
(/var/www/html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183)
at IlluminatePipelinePipeline->IlluminatePipeline{closure}()
(/var/www/html/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/EncryptCookies.php:67)
at IlluminateCookieMiddlewareEncryptCookies->handle()
(/var/www/html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183)
at IlluminatePipelinePipeline->IlluminatePipeline{closure}()
(/var/www/html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:119)
at IlluminatePipelinePipeline->then()
(/var/www/html/vendor/laravel/framework/src/Illuminate/Routing/Router.php:805)
at IlluminateRoutingRouter->runRouteWithinStack()
(/var/www/html/vendor/laravel/framework/src/Illuminate/Routing/Router.php:784)
at IlluminateRoutingRouter->runRoute()
(/var/www/html/vendor/laravel/framework/src/Illuminate/Routing/Router.php:748)
at IlluminateRoutingRouter->dispatchToRoute()
(/var/www/html/vendor/laravel/framework/src/Illuminate/Routing/Router.php:737)
at IlluminateRoutingRouter->dispatch()
(/var/www/html/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php:200)
at IlluminateFoundationHttpKernel->IlluminateFoundationHttp{closure}()
(/var/www/html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:144)
at IlluminatePipelinePipeline->IlluminatePipeline{closure}()
(/var/www/html/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php:21)
at IlluminateFoundationHttpMiddlewareTransformsRequest->handle()
(/var/www/html/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ConvertEmptyStringsToNull.php:31)
at IlluminateFoundationHttpMiddlewareConvertEmptyStringsToNull->handle()
(/var/www/html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183)
at IlluminatePipelinePipeline->IlluminatePipeline{closure}()
(/var/www/html/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php:21)
at IlluminateFoundationHttpMiddlewareTransformsRequest->handle()
(/var/www/html/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TrimStrings.php:40)
at IlluminateFoundationHttpMiddlewareTrimStrings->handle()
(/var/www/html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183)
at IlluminatePipelinePipeline->IlluminatePipeline{closure}()
(/var/www/html/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ValidatePostSize.php:27)
at IlluminateFoundationHttpMiddlewareValidatePostSize->handle()
(/var/www/html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183)
at IlluminatePipelinePipeline->IlluminatePipeline{closure}()
(/var/www/html/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/PreventRequestsDuringMaintenance.php:99)
at IlluminateFoundationHttpMiddlewarePreventRequestsDuringMaintenance->handle()
(/var/www/html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183)
at IlluminatePipelinePipeline->IlluminatePipeline{closure}()
(/var/www/html/vendor/laravel/framework/src/Illuminate/Http/Middleware/TrustProxies.php:39)
at IlluminateHttpMiddlewareTrustProxies->handle()
(/var/www/html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183)
at IlluminatePipelinePipeline->IlluminatePipeline{closure}()
(/var/www/html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:119)
at IlluminatePipelinePipeline->then()
(/var/www/html/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php:175)
at IlluminateFoundationHttpKernel->sendRequestThroughRouter()
(/var/www/html/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php:144)
at IlluminateFoundationHttpKernel->handle()
(/var/www/html/public/index.php:51)
Tried to remove all Write host options,
tried to check mysql connection from command line it works fine. it fails only from the website.
check the cache
check the file permissions.
check to run the update query into DB using CMD running fine.
tried to change from
127.0.0.1 -> localhost & vise versa