SQLSTATE[HY000] [1045] Access denied for user 'apigateway'@'10.44.2.236' (using password: YES) (SQL: SELECT * FROM aggregators WHERE path=/web/list/contents) (500 Internal Server Error)

Symfony Exception

Symfony Docs

Symfony Support

PDOException QueryException

HTTP 500 Internal Server Error

SQLSTATE[HY000] [1045] Access denied for user 'apigateway'@'10.44.2.236' (using password: YES) (SQL: SELECT * FROM aggregators WHERE path=/web/list/contents)

Exceptions 2

Illuminate\Database\ QueryException

in /var/www/app/vendor/illuminate/database/Connection.php (line 671)

// If an exception occurs when attempting to run a query, we'll format the error
// message to include the bindings with SQL, which will make this exception a
// lot more helpful to the developer instead of just the database's errors.
catch (Exception $e) {
throw new QueryException(
$query, $this->prepareBindings($bindings), $e
);
}
return $result;

in /var/www/app/vendor/illuminate/database/Connection.php -> runQueryCallback (line 631)

// Here we will run this query. If an exception occurs we'll determine if it was
// caused by a connection that has been lost. If that is the cause, we'll try
// to re-establish connection and re-run the query with a fresh connection.
try {
$result = $this->runQueryCallback($query, $bindings, $callback);
} catch (QueryException $e) {
$result = $this->handleQueryException(
$e, $query, $bindings, $callback
);
}

in /var/www/app/vendor/illuminate/database/Connection.php -> run (line 339)

$this->bindValues($statement, $this->prepareBindings($bindings));
$statement->execute();
return $statement->fetchAll();
});
}
/**
* Run a select statement against the database and returns a generator.
*

in /var/www/app/vendor/illuminate/database/DatabaseManager.php -> select (line 367)

* @param array $parameters
* @return mixed
*/
public function __call($method, $parameters)
{
return $this->connection()->$method(...$parameters);
}
}

in /var/www/app/vendor/illuminate/support/Facades/Facade.php -> __call (line 261)

if (! $instance) {
throw new RuntimeException('A facade root has not been set.');
}
return $instance->$method(...$args);
}
}

Facade::__callStatic('select', array('SELECT * FROM aggregators WHERE path=?', array('/web/list/contents'))) in /var/www/app/app/Aggregator.php (line 89)

}else{
$this->parameters['pagination'] = new Parameter(['value' => '', 'isResolved' => true, 'type' => 'input']);
}
$this->registerAllParameters();
}else {
$rs = DB::select("SELECT * FROM aggregators WHERE path=?", [$this->path]);
if ($rs) {
//aggregator found
//register supplied parameters
foreach ($this->request->all() as $key => $value) {
$this->parameters[$key] = new Parameter(['value' => $value, 'isResolved' => true, 'type' => 'input']);

Aggregator->run() in /var/www/app/app/Http/Controllers/AggregatorController.php (line 24)

public function request(Request $request){
if ($request->is('aggregator/v1/*')) {
$path = substr($request->path(), 13);
$aggregator = new Aggregator($path, $request);
return $aggregator->run();
}
}
//

AggregatorController->request(object(Request), 'web/list/contents')

in /var/www/app/vendor/illuminate/container/BoundMethod.php call_user_func_array (line 37)

return static::callClass($container, $callback, $parameters, $defaultMethod);
}
return static::callBoundMethod($container, $callback, function () use ($container, $callback, $parameters) {
return call_user_func_array(
$callback, static::getMethodDependencies($container, $callback, $parameters)
);
});
}
/**

in /var/www/app/vendor/illuminate/container/Util.php :: Illuminate\Container\{closure} (line 37)

* @param mixed $value
* @return mixed
*/
public static function unwrapIfClosure($value)
{
return $value instanceof Closure ? $value() : $value;
}
/**
* Get the class name of the given parameter's type, if possible.
*

in /var/www/app/vendor/illuminate/container/BoundMethod.php :: unwrapIfClosure (line 95)

if ($container->hasMethodBinding($method)) {
return $container->callMethodBinding($method, $callback[0]);
}
return Util::unwrapIfClosure($default);
}
/**
* Normalize the given callback into a Class@method string.
*

in /var/www/app/vendor/illuminate/container/BoundMethod.php :: callBoundMethod (line 39)

return static::callBoundMethod($container, $callback, function () use ($container, $callback, $parameters) {
return call_user_func_array(
$callback, static::getMethodDependencies($container, $callback, $parameters)
);
});
}
/**
* Call a string reference to a class using Class@method syntax.
*

in /var/www/app/vendor/illuminate/container/Container.php :: call (line 596)

*
* @throws \InvalidArgumentException
*/
public function call($callback, array $parameters = [], $defaultMethod = null)
{
return BoundMethod::call($this, $callback, $parameters, $defaultMethod);
}
/**
* Get a closure to resolve the given type from the container.
*

in /var/www/app/vendor/laravel/lumen-framework/src/Concerns/RoutesRequests.php -> call (line 386)

*/
protected function callControllerCallable(callable $callable, array $parameters = [])
{
try {
return $this->prepareResponse(
$this->call($callable, $parameters)
);
} catch (HttpResponseException $e) {
return $e->getResponse();
}
}

in /var/www/app/vendor/laravel/lumen-framework/src/Concerns/RoutesRequests.php -> callControllerCallable (line 352)

return $this->callLumenControllerWithMiddleware(
$instance, $method, $routeInfo, $middleware
);
} else {
return $this->callControllerCallable(
[$instance, $method], $routeInfo[2]
);
}
}
/**

in /var/www/app/vendor/laravel/lumen-framework/src/Concerns/RoutesRequests.php -> callLumenController (line 326)

if (! method_exists($instance = $this->make($controller), $method)) {
throw new NotFoundHttpException;
}
if ($instance instanceof LumenController) {
return $this->callLumenController($instance, $method, $routeInfo);
} else {
return $this->callControllerCallable(
[$instance, $method], $routeInfo[2]
);
}

in /var/www/app/vendor/laravel/lumen-framework/src/Concerns/RoutesRequests.php -> callControllerAction (line 279)

protected function callActionOnArrayBasedRoute($routeInfo)
{
$action = $routeInfo[1];
if (isset($action['uses'])) {
return $this->prepareResponse($this->callControllerAction($routeInfo));
}
foreach ($action as $value) {
if ($value instanceof Closure) {
$callable = $value->bindTo(new RoutingClosure);

in /var/www/app/vendor/laravel/lumen-framework/src/Concerns/RoutesRequests.php -> callActionOnArrayBasedRoute (line 259)

// Pipe through route middleware...
if (isset($action['middleware'])) {
$middleware = $this->gatherMiddlewareClassNames($action['middleware']);
return $this->prepareResponse($this->sendThroughPipeline($middleware, function () {
return $this->callActionOnArrayBasedRoute($this['request']->route());
}));
}
return $this->prepareResponse(
$this->callActionOnArrayBasedRoute($routeInfo)

Application->Laravel\Lumen\Concerns\{closure}(object(Request))

in /var/www/app/vendor/laravel/lumen-framework/src/Routing/Pipeline.php call_user_func (line 48)

*/
protected function prepareDestination(BaseClosure $destination)
{
return function ($passable) use ($destination) {
try {
return call_user_func($destination, $passable);
} catch (Throwable $e) {
return $this->handleException($passable, $e);
}
};
}

Pipeline->Laravel\Lumen\Routing\{closure}(object(Request)) in /var/www/app/app/Http/Middleware/CorsMiddleware.php (line 46)

{
return response()->json('{"method":"OPTIONS"}', 200, $headers);
}
$response = $next($request);
foreach($headers as $key => $value)
{
$response->header($key, $value);
}

in /var/www/app/vendor/illuminate/pipeline/Pipeline.php -> handle (line 167)

// since the object we're given was already a fully instantiated object.
$parameters = [$passable, $stack];
}
$carry = method_exists($pipe, $this->method)
? $pipe->{$this->method}(...$parameters)
: $pipe(...$parameters);
return $this->handleCarry($carry);
} catch (Throwable $e) {
return $this->handleException($passable, $e);

Pipeline->Illuminate\Pipeline\{closure}(object(Request))

in /var/www/app/vendor/laravel/lumen-framework/src/Routing/Pipeline.php call_user_func (line 30)

return function ($stack, $pipe) {
return function ($passable) use ($stack, $pipe) {
try {
$slice = parent::carry();
return call_user_func($slice($stack, $pipe), $passable);
} catch (Throwable $e) {
return $this->handleException($passable, $e);
}
};
};

in /var/www/app/vendor/illuminate/pipeline/Pipeline.php -> Laravel\Lumen\Routing\{closure} (line 103)

{
$pipeline = array_reduce(
array_reverse($this->pipes()), $this->carry(), $this->prepareDestination($destination)
);
return $pipeline($this->passable);
}
/**
* Run the pipeline and return the result.
*

in /var/www/app/vendor/laravel/lumen-framework/src/Concerns/RoutesRequests.php -> then (line 423)

{
if (count($middleware) > 0 && ! $this->shouldSkipMiddleware()) {
return (new Pipeline($this))
->send($this->make('request'))
->through($middleware)
->then($then);
}
return $then($this->make('request'));
}

in /var/www/app/vendor/laravel/lumen-framework/src/Concerns/RoutesRequests.php -> sendThroughPipeline (line 260)

if (isset($action['middleware'])) {
$middleware = $this->gatherMiddlewareClassNames($action['middleware']);
return $this->prepareResponse($this->sendThroughPipeline($middleware, function () {
return $this->callActionOnArrayBasedRoute($this['request']->route());
}));
}
return $this->prepareResponse(
$this->callActionOnArrayBasedRoute($routeInfo)
);

in /var/www/app/vendor/laravel/lumen-framework/src/Concerns/RoutesRequests.php -> handleFoundRoute (line 234)

case Dispatcher::NOT_FOUND:
throw new NotFoundHttpException;
case Dispatcher::METHOD_NOT_ALLOWED:
throw new MethodNotAllowedHttpException($routeInfo[1]);
case Dispatcher::FOUND:
return $this->handleFoundRoute($routeInfo);
}
}
/**
* Handle a route found by the dispatcher.

in /var/www/app/vendor/laravel/lumen-framework/src/Concerns/RoutesRequests.php -> handleDispatcherResponse (line 170)

if (isset($this->router->getRoutes()[$method.$pathInfo])) {
return $this->handleFoundRoute([true, $this->router->getRoutes()[$method.$pathInfo]['action'], []]);
}
return $this->handleDispatcherResponse(
$this->createDispatcher()->dispatch($method, $pathInfo)
);
});
} catch (Throwable $e) {
return $this->prepareResponse($this->sendExceptionToHandler($e));
}

in /var/www/app/vendor/laravel/lumen-framework/src/Concerns/RoutesRequests.php -> Laravel\Lumen\Concerns\{closure} (line 426)

->send($this->make('request'))
->through($middleware)
->then($then);
}
return $then($this->make('request'));
}
/**
* Prepare the response for sending.
*

in /var/www/app/vendor/laravel/lumen-framework/src/Concerns/RoutesRequests.php -> sendThroughPipeline (line 172)

}
return $this->handleDispatcherResponse(
$this->createDispatcher()->dispatch($method, $pathInfo)
);
});
} catch (Throwable $e) {
return $this->prepareResponse($this->sendExceptionToHandler($e));
}
}

in /var/www/app/vendor/laravel/lumen-framework/src/Concerns/RoutesRequests.php -> dispatch (line 109)

* @param SymfonyRequest|null $request
* @return void
*/
public function run($request = null)
{
$response = $this->dispatch($request);
if ($response instanceof SymfonyResponse) {
$response->send();
} else {
echo (string) $response;

Application->run() in /var/www/app/public/index.php (line 27)

| the client's browser allowing them to enjoy the creative
| and wonderful application we have prepared for them.
|
*/
$app->run();

PDOException

SQLSTATE[HY000] [1045] Access denied for user 'apigateway'@'10.44.2.236' (using password: YES)

in /var/www/app/vendor/illuminate/database/Connectors/Connector.php (line 70)

{
if (class_exists(PDOConnection::class) && ! $this->isPersistentConnection($options)) {
return new PDOConnection($dsn, $username, $password, $options);
}
return new PDO($dsn, $username, $password, $options);
}
/**
* Determine if the connection is persistent.
*

in /var/www/app/vendor/illuminate/database/Connectors/Connector.php -> __construct (line 70)

{
if (class_exists(PDOConnection::class) && ! $this->isPersistentConnection($options)) {
return new PDOConnection($dsn, $username, $password, $options);
}
return new PDO($dsn, $username, $password, $options);
}
/**
* Determine if the connection is persistent.
*

in /var/www/app/vendor/illuminate/database/Connectors/Connector.php -> createPdoConnection (line 46)

$config['username'] ?? null, $config['password'] ?? null,
];
try {
return $this->createPdoConnection(
$dsn, $username, $password, $options
);
} catch (Exception $e) {
return $this->tryAgainIfCausedByLostConnection(
$e, $dsn, $username, $password, $options
);

in /var/www/app/vendor/illuminate/database/Connectors/MySqlConnector.php -> createConnection (line 24)

$options = $this->getOptions($config);
// We need to grab the PDO options that should be used while making the brand
// new connection instance. The PDO options control various aspects of the
// connection's behavior, and some might be specified by the developers.
$connection = $this->createConnection($dsn, $config, $options);
if (! empty($config['database'])) {
$connection->exec("use `{$config['database']}`;");
}

in /var/www/app/vendor/illuminate/database/Connectors/ConnectionFactory.php -> connect (line 184)

return function () use ($config) {
foreach (Arr::shuffle($hosts = $this->parseHosts($config)) as $key => $host) {
$config['host'] = $host;
try {
return $this->createConnector($config)->connect($config);
} catch (PDOException $e) {
continue;
}
}

ConnectionFactory->Illuminate\Database\Connectors\{closure}()

in /var/www/app/vendor/illuminate/database/Connection.php call_user_func (line 926)

* @return \PDO
*/
public function getPdo()
{
if ($this->pdo instanceof Closure) {
return $this->pdo = call_user_func($this->pdo);
}
return $this->pdo;
}

in /var/www/app/vendor/illuminate/database/Connection.php -> getPdo (line 961)

if ($this->readPdo instanceof Closure) {
return $this->readPdo = call_user_func($this->readPdo);
}
return $this->readPdo ?: $this->getPdo();
}
/**
* Get the current read PDO connection parameter without executing any reconnect logic.
*

in /var/www/app/vendor/illuminate/database/Connection.php -> getReadPdo (line 405)

* @param bool $useReadPdo
* @return \PDO
*/
protected function getPdoForSelect($useReadPdo = true)
{
return $useReadPdo ? $this->getReadPdo() : $this->getPdo();
}
/**
* Run an insert statement against the database.
*

in /var/www/app/vendor/illuminate/database/Connection.php -> getPdoForSelect (line 331)

// For select statements, we'll simply execute the query and return an array
// of the database result set. Each element in the array will be a single
// row from the database table, and will either be an array or objects.
$statement = $this->prepared(
$this->getPdoForSelect($useReadPdo)->prepare($query)
);
$this->bindValues($statement, $this->prepareBindings($bindings));
$statement->execute();

in /var/www/app/vendor/illuminate/database/Connection.php -> Illuminate\Database\{closure} (line 664)

{
// To execute the statement, we'll simply call the callback, which will actually
// run the SQL against the PDO connection. Then we can calculate the time it
// took to execute and log the query SQL, bindings and time in our memory.
try {
$result = $callback($query, $bindings);
}
// If an exception occurs when attempting to run a query, we'll format the error
// message to include the bindings with SQL, which will make this exception a
// lot more helpful to the developer instead of just the database's errors.

Sydney Jones

Om Sydney Jones

Karriere

Hent vores app

Fodbold

Turneringer

Info

Abonnement

Kontakt