04 11 2023 10:03:12 El Archivo 2023-11-04 - log.txt se ha creado 04 11 2023 10:03:12 ###############Datos recibidos -- 04 11 2023 10:03:12 Envio Login Movil: 04 11 2023 10:03:12 Url=http://10.1.1.11:8094/ptat/login/login_movil 04 11 2023 10:03:12 Contenido:POST http://10.1.1.11:8094/ptat/login/login_movil HTTP/1.1 AUTHENTICATION: eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJ1c3VhcmlvIjoiQ1Y0MDM2NzIzMSIsImNsYXZlIjoibDViNDJSUGJEK0Z3NHc3ZXd1U3NTdz09XG4iLCJleHAiOjE2OTkxMTAyMzIsImlhdCI6MTY5OTExMDE4Mn0.E0c92iLaqp_Q2ZlEb3ALNjl4tvYNgo89KtZF54z3rAw Content-Length: 245 Content-Type: multipart/form-data; boundary="100d9b18.3fee2f54" --100d9b18.3fee2f54 Content-Disposition: form-data; name="json" [{"imeis":"fWsXPKKEHb0,ffffffff-c874-0103-ffff-ffffef49f440,3f2d60039094c695","ip":"","name_device":"Ciontek CS10","operador":"","version_app":"9.0.2"}] --100d9b18.3fee2f54-- 04 11 2023 10:03:31 HTTP/1.1 200 OK Date: Sat, 04 Nov 2023 15:03:12 GMT Server: Apache/2.4.41 (Ubuntu) X-Powered-By: PHP/8.1.18 Access-Control-Allow-Origin: * Access-Control-Allow-Headers: X-API-KEY, Origin, X-Requested-With, Content-Type, Accept, Access-Control-Request-Method, Authorization, Authentication Access-Control-Allow-Methods: GET, POST, OPTIONS, PUT, DELETE Allow: GET, POST, OPTIONS, PUT, DELETE Cache-Control: no-cache, private Http-Authentication: eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJ1c3VhcmlvIjoiQ1Y0MDM2NzIzMSIsImlhdCI6MTY5OTExMDIwOSwiZXhwIjoxNjk5MTEyMzA5fQ.bSVcLBJdwXfROXR-gPrln1zjJwgxrtgHfmF7VADeIyM Http-Refresh: eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJ1c3VhcmlvIjoiQ1Y0MDM2NzIzMSIsImlhdCI6MTY5OTExMDIwOSwiZXhwIjoxNjk5MTI4MjA5fQ.RsIxLPGxrirsYaycCnOH1cVQyUoe9B6nr_AULWTmXBM X-Robots-Tag: noindex Content-Type: application/json X-Original-Transfer-Encoding: chunked Content-Length: 304 {"code":1,"datos":[{"loginusr":"CV40367231","nivel":4,"nombre":"GEORGINA BARBOSA","solicitudes":[],"correo":"georginabc1962@gmail.com","fecha_n":"27\/02\/1962","time_expire":2100,"notificaciones":0}],"supervisores":[],"supervisores_visit":[],"vendedores":[],"sem_version":1,"mensajes":[],"menu":"6,9,10"} 04 11 2023 10:03:32 ********************Inicia Metodos Sem*********************** 04 11 2023 10:03:32 ###############Datos recibidos 29 -- {"id_mod":"1"} -- CV40367231 04 11 2023 10:03:32 headers eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJ1c3VhcmlvIjoiQ1Y0MDM2NzIzMSIsImlhdCI6MTY5OTExMDIwOSwiZXhwIjoxNjk5MTEyMzA5fQ.bSVcLBJdwXfROXR-gPrln1zjJwgxrtgHfmF7VADeIyM || 04 11 2023 10:03:32 headers {"AUTHENTICATION":"eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJ1c3VhcmlvIjoiQ1Y0MDM2NzIzMSIsImlhdCI6MTY5OTExMDIwOSwiZXhwIjoxNjk5MTEyMzA5fQ.bSVcLBJdwXfROXR-gPrln1zjJwgxrtgHfmF7VADeIyM"} 04 11 2023 10:03:32 Envio Metodos Sem: 04 11 2023 10:03:32 Url=http://10.1.1.11:8094/ptat/metodos/metodos 04 11 2023 10:03:32 Contenido:POST http://10.1.1.11:8094/ptat/metodos/metodos HTTP/1.1 AUTHENTICATION: eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJ1c3VhcmlvIjoiQ1Y0MDM2NzIzMSIsImlhdCI6MTY5OTExMDIwOSwiZXhwIjoxNjk5MTEyMzA5fQ.bSVcLBJdwXfROXR-gPrln1zjJwgxrtgHfmF7VADeIyM Content-Length: 282 Content-Type: multipart/form-data; boundary="65eb14ee.3fe6c867" --65eb14ee.3fe6c867 Content-Disposition: form-data; name="con[0][con]" 29 --65eb14ee.3fe6c867 Content-Disposition: form-data; name="datos" {"id_mod":"1"} --65eb14ee.3fe6c867 Content-Disposition: form-data; name="usuario[0][usuario]" CV40367231 --65eb14ee.3fe6c867-- 04 11 2023 10:03:34 HTTP/1.1 200 OK Date: Sat, 04 Nov 2023 15:03:32 GMT Server: Apache/2.4.41 (Ubuntu) X-Powered-By: PHP/8.1.18 Access-Control-Allow-Origin: * Access-Control-Allow-Headers: X-API-KEY, Origin, X-Requested-With, Content-Type, Accept, Access-Control-Request-Method, Authorization, Authentication Access-Control-Allow-Methods: GET, POST, OPTIONS, PUT, DELETE Allow: GET, POST, OPTIONS, PUT, DELETE Cache-Control: no-cache, private Http-Authentication: eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJ1c3VhcmlvIjoiQ1Y0MDM2NzIzMSIsImlhdCI6MTY5OTExMDIwOSwiZXhwIjoxNjk5MTEyMzA5fQ.bSVcLBJdwXfROXR-gPrln1zjJwgxrtgHfmF7VADeIyM X-Robots-Tag: noindex Content-Type: application/json X-Original-Transfer-Encoding: chunked Content-Length: 151 {"code":"1","status":"1","success":"1","message":"Modulos OK","info":"Modulos OK","ids":"1,3,4,5,7,8,2,11,6,9,10","id_sgc":null,"arr_informacion":null} 04 11 2023 10:03:34 datos:{"code":"1","status":"1","success":"1","message":"Modulos OK","info":"Modulos OK","ids":"1,3,4,5,7,8,2,11,6,9,10","id_sgc":null,"arr_informacion":null} 04 11 2023 10:11:34 ********************Inicia Login Movil*********************** 04 11 2023 10:11:34 ###############Datos recibidos -- 04 11 2023 10:11:34 Envio Login Movil: 04 11 2023 10:11:34 Url=http://10.1.1.11:8094/ptat/login/login_movil 04 11 2023 10:11:34 Contenido:POST http://10.1.1.11:8094/ptat/login/login_movil HTTP/1.1 AUTHENTICATION: eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJ1c3VhcmlvIjoiQ1Y0MDM2NzIzMSIsImNsYXZlIjoibDViNDJSUGJEK0Z3NHc3ZXd1U3NTdz09XG4iLCJleHAiOjE2OTkxMTA3MzQsImlhdCI6MTY5OTExMDY4NH0.kVTNC6yWGJfMKOZRJ6TXKL87LM8mjwVI3CjvDj0vUZ4 Content-Length: 245 Content-Type: multipart/form-data; boundary="b0330873.3feaad7b" --b0330873.3feaad7b Content-Disposition: form-data; name="json" [{"imeis":"fWsXPKKEHb0,ffffffff-c874-0103-ffff-ffffef49f440,3f2d60039094c695","ip":"","name_device":"Ciontek CS10","operador":"","version_app":"9.0.2"}] --b0330873.3feaad7b-- 04 11 2023 10:12:04 HTTP/1.1 500 Internal Server Error Date: Sat, 04 Nov 2023 15:12:04 GMT Server: Apache/2.4.41 (Ubuntu) X-Powered-By: PHP/8.1.18 Access-Control-Allow-Origin: * Access-Control-Allow-Headers: X-API-KEY, Origin, X-Requested-With, Content-Type, Accept, Access-Control-Request-Method, Authorization, Authentication Access-Control-Allow-Methods: GET, POST, OPTIONS, PUT, DELETE Allow: GET, POST, OPTIONS, PUT, DELETE X-Debug-Exception: An%20exception%20occurred%20in%20the%20driver%3A%20SQLSTATE%5B08006%5D%20%5B7%5D%20connection%20to%20server%20at%20%22172.31.23.79%22%2C%20port%205432%20failed%3A%20timeout%20expired X-Debug-Exception-File: %2Fwww%2Fphp81%2Fserversoap%2Frecaudos%2Fvendor%2Fdoctrine%2Fdbal%2Fsrc%2FDriver%2FAPI%2FPostgreSQL%2FExceptionConverter.php:77 Cache-Control: no-cache, private X-Robots-Tag: noindex Connection: close Content-Type: text/html; charset=UTF-8 X-Original-Transfer-Encoding: chunked Content-Length: 276892 An exception occurred in the driver: SQLSTATE[08006] [7] connection to server at "172.31.23.79", port 5432 failed: timeout expired (500 Internal Server Error)

Symfony Exception

Symfony Docs

PDOException Exception ConnectionException

HTTP 500 Internal Server Error

An exception occurred in the driver: SQLSTATE[08006] [7] connection to server at "172.31.23.79", port 5432 failed: timeout expired

Exceptions 3

Doctrine\DBAL\Exception\ ConnectionException

in vendor/doctrine/dbal/src/Driver/API/PostgreSQL/ExceptionConverter.php (line 77)
  2.             case '42P07':
  3.                 return new TableExistsException($exception, $query);
  5.             case '08006':
  6.                 return new ConnectionException($exception, $query);
  7.         }
  9.         // Prior to fixing https://bugs.php.net/bug.php?id=64705 (PHP 7.4.10),
  10.         // in some cases (mainly connection errors) the PDO exception wouldn't provide a SQLSTATE via its code.
  11.         // We have to match against the SQLSTATE in the error message in these cases.
in vendor/doctrine/dbal/src/Connection.php -> convert (line 1908)
  1.     private function handleDriverException(
  2.         Driver\Exception $driverException,
  3.         ?Query $query
  4.     ): DriverException {
  5.         $this->exceptionConverter ??= $this->_driver->getExceptionConverter();
  6.         $exception                  = $this->exceptionConverter->convert($driverException, $query);
  8.         if ($exception instanceof ConnectionLost) {
  9.             $this->close();
  10.         }
in vendor/doctrine/dbal/src/Connection.php -> handleDriverException (line 1857)
  1.     }
  3.     /** @internal */
  4.     final public function convertException(Driver\Exception $e): DriverException
  5.     {
  6.         return $this->handleDriverException($e, null);
  7.     }
  9.     /**
  10.      * @param array<int, mixed>|array<string, mixed>                               $params
  11.      * @param array<int, int|string|Type|null>|array<string, int|string|Type|null> $types
in vendor/doctrine/dbal/src/Connection.php -> convertException (line 348)
  1.         }
  3.         try {
  4.             $this->_conn = $this->_driver->connect($this->params);
  5.         } catch (Driver\Exception $e) {
  6.             throw $this->convertException($e);
  7.         }
  9.         if ($this->autoCommit === false) {
  10.             $this->beginTransaction();
  11.         }
in vendor/doctrine/dbal/src/Connection.php -> connect (line 1619)
  1.             'https://github.com/doctrine/dbal/issues/4966',
  2.             'Connection::getWrappedConnection() is deprecated.'
  3.                 . ' Use Connection::getNativeConnection() to access the native connection.',
  4.         );
  6.         $this->connect();
  8.         assert($this->_conn !== null);
  10.         return $this->_conn;
  11.     }
in vendor/doctrine/dbal/src/Connection.php -> getWrappedConnection (line 1013)
  1.      *
  2.      * @throws Exception
  3.      */
  4.     public function prepare(string $sql): Statement
  5.     {
  6.         $connection = $this->getWrappedConnection();
  8.         try {
  9.             $statement = $connection->prepare($sql);
  10.         } catch (Driver\Exception $e) {
  11.             throw $this->convertExceptionDuringQuery($e, $sql);
Connection->prepare() in src/Services/Conexion.php (line 227)
  1.       );
  2.       //$cnn = \Doctrine\DBAL\DriverManager::getConnection($connectionParams, $config);
  3.       // $this->log->logs("Inicio ejecucion sql0");
  4.       $this->cnn = \Doctrine\DBAL\DriverManager::getConnection($connectionParams, $config);
  5.       //$sql = "SELECT * FROM articles";
  6.       $stmt = $this->cnn->prepare($sql);
  7.       /* switch ($con) 
  8.       {
  9.         case 6:
  10.           case 5:
  11.             $resultSet = $stmt->executeQuery();
Conexion->query() in src/Controller/PtatController.php (line 1462)
  1.       return $response;
  2.       exit;
  3.     }
  5.     $sql_man = "SELECT estado_modulos FROM sem_versiones sv2 WHERE id = (SELECT max(id) FROM sem_versiones sv WHERE estado = 0) AND estado_modulos = 0";
  6.     $res_man = $this->cnn->query('0', $sql_man);
  7.     if (!(count($res_man) > 0))
  8.     {
  9.       $respuesta["code"] = 0;
  10.       $respuesta["datos"] = "SEM esta en mantenimiento";
  11.       $response->setContent(json_encode($respuesta));
in vendor/symfony/http-kernel/HttpKernel.php -> login_movil (line 163)
  1.         $this->dispatcher->dispatch($event, KernelEvents::CONTROLLER_ARGUMENTS);
  2.         $controller = $event->getController();
  3.         $arguments = $event->getArguments();
  5.         // call controller
  6.         $response = $controller(...$arguments);
  8.         // view
  9.         if (!$response instanceof Response) {
  10.             $event = new ViewEvent($this, $request, $type, $response, $event);
  11.             $this->dispatcher->dispatch($event, KernelEvents::VIEW);
in vendor/symfony/http-kernel/HttpKernel.php -> handleRaw (line 74)
  1.     {
  2.         $request->headers->set('X-Php-Ob-Level', (string) ob_get_level());
  4.         $this->requestStack->push($request);
  5.         try {
  6.             return $this->handleRaw($request, $type);
  7.         } catch (\Throwable $e) {
  8.             if ($e instanceof \Error && !$this->handleAllThrowables) {
  9.                 throw $e;
  10.             }
in vendor/symfony/http-kernel/Kernel.php -> handle (line 184)
  1.         $this->boot();
  2.         ++$this->requestStackSize;
  3.         $this->resetServices = true;
  5.         try {
  6.             return $this->getHttpKernel()->handle($request, $type, $catch);
  7.         } finally {
  8.             --$this->requestStackSize;
  9.         }
  10.     }
in vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php -> handle (line 35)
  1.         $this->request = $request;
  2.     }
  4.     public function run(): int
  5.     {
  6.         $response = $this->kernel->handle($this->request);
  7.         $response->send();
  9.         if ($this->kernel instanceof TerminableInterface) {
  10.             $this->kernel->terminate($this->request, $response);
  11.         }
in vendor/autoload_runtime.php -> run (line 29)
  1. $app = $app(...$args);
  3. exit(
  4.     $runtime
  5.         ->getRunner($app)
  6.         ->run()
  7. );
require_once('/www/php81/serversoap/recaudos/vendor/autoload_runtime.php') in public/index.php (line 16)
  1. $method = $_SERVER['REQUEST_METHOD'];
  2. if($method == "OPTIONS") {
  3.     die();
  4. }
  6. require_once dirname(__DIR__).'/vendor/autoload_runtime.php';
  8. return function (array $context) {
  9.     return new Kernel($context['APP_ENV'], (bool) $context['APP_DEBUG']);
  10. };

Doctrine\DBAL\Driver\PDO\ Exception

SQLSTATE[08006] [7] connection to server at "172.31.23.79", port 5432 failed: timeout expired

in vendor/doctrine/dbal/src/Driver/PDO/Exception.php (line 28)
  1.         } else {
  2.             $code     = $exception->getCode();
  3.             $sqlState = null;
  4.         }
  6.         return new self($exception->getMessage(), $sqlState, $code, $exception);
  7.     }
  8. }
in vendor/doctrine/dbal/src/Driver/PDO/PgSQL/Driver.php :: new (line 35)
  1.                 $params['user'] ?? '',
  2.                 $params['password'] ?? '',
  3.                 $driverOptions,
  4.             );
  5.         } catch (PDOException $exception) {
  6.             throw Exception::new($exception);
  7.         }
  9.         if (
  10.             ! isset($driverOptions[PDO::PGSQL_ATTR_DISABLE_PREPARES])
  11.             || $driverOptions[PDO::PGSQL_ATTR_DISABLE_PREPARES] === true
in vendor/doctrine/dbal/src/Connection.php -> connect (line 346)
  1.         if ($this->_conn !== null) {
  2.             return false;
  3.         }
  5.         try {
  6.             $this->_conn = $this->_driver->connect($this->params);
  7.         } catch (Driver\Exception $e) {
  8.             throw $this->convertException($e);
  9.         }
  11.         if ($this->autoCommit === false) {
in vendor/doctrine/dbal/src/Connection.php -> connect (line 1619)
  1.             'https://github.com/doctrine/dbal/issues/4966',
  2.             'Connection::getWrappedConnection() is deprecated.'
  3.                 . ' Use Connection::getNativeConnection() to access the native connection.',
  4.         );
  6.         $this->connect();
  8.         assert($this->_conn !== null);
  10.         return $this->_conn;
  11.     }
in vendor/doctrine/dbal/src/Connection.php -> getWrappedConnection (line 1013)
  1.      *
  2.      * @throws Exception
  3.      */
  4.     public function prepare(string $sql): Statement
  5.     {
  6.         $connection = $this->getWrappedConnection();
  8.         try {
  9.             $statement = $connection->prepare($sql);
  10.         } catch (Driver\Exception $e) {
  11.             throw $this->convertExceptionDuringQuery($e, $sql);
Connection->prepare() in src/Services/Conexion.php (line 227)
  1.       );
  2.       //$cnn = \Doctrine\DBAL\DriverManager::getConnection($connectionParams, $config);
  3.       // $this->log->logs("Inicio ejecucion sql0");
  4.       $this->cnn = \Doctrine\DBAL\DriverManager::getConnection($connectionParams, $config);
  5.       //$sql = "SELECT * FROM articles";
  6.       $stmt = $this->cnn->prepare($sql);
  7.       /* switch ($con) 
  8.       {
  9.         case 6:
  10.           case 5:
  11.             $resultSet = $stmt->executeQuery();
Conexion->query() in src/Controller/PtatController.php (line 1462)
  1.       return $response;
  2.       exit;
  3.     }
  5.     $sql_man = "SELECT estado_modulos FROM sem_versiones sv2 WHERE id = (SELECT max(id) FROM sem_versiones sv WHERE estado = 0) AND estado_modulos = 0";
  6.     $res_man = $this->cnn->query('0', $sql_man);
  7.     if (!(count($res_man) > 0))
  8.     {
  9.       $respuesta["code"] = 0;
  10.       $respuesta["datos"] = "SEM esta en mantenimiento";
  11.       $response->setContent(json_encode($respuesta));
in vendor/symfony/http-kernel/HttpKernel.php -> login_movil (line 163)
  1.         $this->dispatcher->dispatch($event, KernelEvents::CONTROLLER_ARGUMENTS);
  2.         $controller = $event->getController();
  3.         $arguments = $event->getArguments();
  5.         // call controller
  6.         $response = $controller(...$arguments);
  8.         // view
  9.         if (!$response instanceof Response) {
  10.             $event = new ViewEvent($this, $request, $type, $response, $event);
  11.             $this->dispatcher->dispatch($event, KernelEvents::VIEW);
in vendor/symfony/http-kernel/HttpKernel.php -> handleRaw (line 74)
  1.     {
  2.         $request->headers->set('X-Php-Ob-Level', (string) ob_get_level());
  4.         $this->requestStack->push($request);
  5.         try {
  6.             return $this->handleRaw($request, $type);
  7.         } catch (\Throwable $e) {
  8.             if ($e instanceof \Error && !$this->handleAllThrowables) {
  9.                 throw $e;
  10.             }
in vendor/symfony/http-kernel/Kernel.php -> handle (line 184)
  1.         $this->boot();
  2.         ++$this->requestStackSize;
  3.         $this->resetServices = true;
  5.         try {
  6.             return $this->getHttpKernel()->handle($request, $type, $catch);
  7.         } finally {
  8.             --$this->requestStackSize;
  9.         }
  10.     }
in vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php -> handle (line 35)
  1.         $this->request = $request;
  2.     }
  4.     public function run(): int
  5.     {
  6.         $response = $this->kernel->handle($this->request);
  7.         $response->send();
  9.         if ($this->kernel instanceof TerminableInterface) {
  10.             $this->kernel->terminate($this->request, $response);
  11.         }
in vendor/autoload_runtime.php -> run (line 29)
  1. $app = $app(...$args);
  3. exit(
  4.     $runtime
  5.         ->getRunner($app)
  6.         ->run()
  7. );
require_once('/www/php81/serversoap/recaudos/vendor/autoload_runtime.php') in public/index.php (line 16)
  1. $method = $_SERVER['REQUEST_METHOD'];
  2. if($method == "OPTIONS") {
  3.     die();
  4. }
  6. require_once dirname(__DIR__).'/vendor/autoload_runtime.php';
  8. return function (array $context) {
  9.     return new Kernel($context['APP_ENV'], (bool) $context['APP_DEBUG']);
  10. };

PDOException

SQLSTATE[08006] [7] connection to server at "172.31.23.79", port 5432 failed: timeout expired

in vendor/doctrine/dbal/src/Driver/PDO/PgSQL/Driver.php (line 29)
  1.             $driverOptions[PDO::ATTR_PERSISTENT] = true;
  2.         }
  4.         try {
  5.             $pdo = new PDO(
  6.                 $this->constructPdoDsn($params),
  7.                 $params['user'] ?? '',
  8.                 $params['password'] ?? '',
  9.                 $driverOptions,
  10.             );
  11.         } catch (PDOException $exception) {
in vendor/doctrine/dbal/src/Driver/PDO/PgSQL/Driver.php -> __construct (line 29)
  1.             $driverOptions[PDO::ATTR_PERSISTENT] = true;
  2.         }
  4.         try {
  5.             $pdo = new PDO(
  6.                 $this->constructPdoDsn($params),
  7.                 $params['user'] ?? '',
  8.                 $params['password'] ?? '',
  9.                 $driverOptions,
  10.             );
  11.         } catch (PDOException $exception) {
in vendor/doctrine/dbal/src/Connection.php -> connect (line 346)
  1.         if ($this->_conn !== null) {
  2.             return false;
  3.         }
  5.         try {
  6.             $this->_conn = $this->_driver->connect($this->params);
  7.         } catch (Driver\Exception $e) {
  8.             throw $this->convertException($e);
  9.         }
  11.         if ($this->autoCommit === false) {
in vendor/doctrine/dbal/src/Connection.php -> connect (line 1619)
  1.             'https://github.com/doctrine/dbal/issues/4966',
  2.             'Connection::getWrappedConnection() is deprecated.'
  3.                 . ' Use Connection::getNativeConnection() to access the native connection.',
  4.         );
  6.         $this->connect();
  8.         assert($this->_conn !== null);
  10.         return $this->_conn;
  11.     }
in vendor/doctrine/dbal/src/Connection.php -> getWrappedConnection (line 1013)
  1.      *
  2.      * @throws Exception
  3.      */
  4.     public function prepare(string $sql): Statement
  5.     {
  6.         $connection = $this->getWrappedConnection();
  8.         try {
  9.             $statement = $connection->prepare($sql);
  10.         } catch (Driver\Exception $e) {
  11.             throw $this->convertExceptionDuringQuery($e, $sql);
Connection->prepare() in src/Services/Conexion.php (line 227)
  1.       );
  2.       //$cnn = \Doctrine\DBAL\DriverManager::getConnection($connectionParams, $config);
  3.       // $this->log->logs("Inicio ejecucion sql0");
  4.       $this->cnn = \Doctrine\DBAL\DriverManager::getConnection($connectionParams, $config);
  5.       //$sql = "SELECT * FROM articles";
  6.       $stmt = $this->cnn->prepare($sql);
  7.       /* switch ($con) 
  8.       {
  9.         case 6:
  10.           case 5:
  11.             $resultSet = $stmt->executeQuery();
Conexion->query() in src/Controller/PtatController.php (line 1462)
  1.       return $response;
  2.       exit;
  3.     }
  5.     $sql_man = "SELECT estado_modulos FROM sem_versiones sv2 WHERE id = (SELECT max(id) FROM sem_versiones sv WHERE estado = 0) AND estado_modulos = 0";
  6.     $res_man = $this->cnn->query('0', $sql_man);
  7.     if (!(count($res_man) > 0))
  8.     {
  9.       $respuesta["code"] = 0;
  10.       $respuesta["datos"] = "SEM esta en mantenimiento";
  11.       $response->setContent(json_encode($respuesta));
in vendor/symfony/http-kernel/HttpKernel.php -> login_movil (line 163)
  1.         $this->dispatcher->dispatch($event, KernelEvents::CONTROLLER_ARGUMENTS);
  2.         $controller = $event->getController();
  3.         $arguments = $event->getArguments();
  5.         // call controller
  6.         $response = $controller(...$arguments);
  8.         // view
  9.         if (!$response instanceof Response) {
  10.             $event = new ViewEvent($this, $request, $type, $response, $event);
  11.             $this->dispatcher->dispatch($event, KernelEvents::VIEW);
in vendor/symfony/http-kernel/HttpKernel.php -> handleRaw (line 74)
  1.     {
  2.         $request->headers->set('X-Php-Ob-Level', (string) ob_get_level());
  4.         $this->requestStack->push($request);
  5.         try {
  6.             return $this->handleRaw($request, $type);
  7.         } catch (\Throwable $e) {
  8.             if ($e instanceof \Error && !$this->handleAllThrowables) {
  9.                 throw $e;
  10.             }
in vendor/symfony/http-kernel/Kernel.php -> handle (line 184)
  1.         $this->boot();
  2.         ++$this->requestStackSize;
  3.         $this->resetServices = true;
  5.         try {
  6.             return $this->getHttpKernel()->handle($request, $type, $catch);
  7.         } finally {
  8.             --$this->requestStackSize;
  9.         }
  10.     }
in vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php -> handle (line 35)
  1.         $this->request = $request;
  2.     }
  4.     public function run(): int
  5.     {
  6.         $response = $this->kernel->handle($this->request);
  7.         $response->send();
  9.         if ($this->kernel instanceof TerminableInterface) {
  10.             $this->kernel->terminate($this->request, $response);
  11.         }
in vendor/autoload_runtime.php -> run (line 29)
  1. $app = $app(...$args);
  3. exit(
  4.     $runtime
  5.         ->getRunner($app)
  6.         ->run()
  7. );
require_once('/www/php81/serversoap/recaudos/vendor/autoload_runtime.php') in public/index.php (line 16)
  1. $method = $_SERVER['REQUEST_METHOD'];
  2. if($method == "OPTIONS") {
  3.     die();
  4. }
  6. require_once dirname(__DIR__).'/vendor/autoload_runtime.php';
  8. return function (array $context) {
  9.     return new Kernel($context['APP_ENV'], (bool) $context['APP_DEBUG']);
  10. };

Logs

No log messages

Stack Traces 3

[3/3] ConnectionException 
Doctrine\DBAL\Exception\ConnectionException:
An exception occurred in the driver: SQLSTATE[08006] [7] connection to server at "172.31.23.79", port 5432 failed: timeout expired

  at vendor/doctrine/dbal/src/Driver/API/PostgreSQL/ExceptionConverter.php:77
  at Doctrine\DBAL\Driver\API\PostgreSQL\ExceptionConverter->convert()
     (vendor/doctrine/dbal/src/Connection.php:1908)
  at Doctrine\DBAL\Connection->handleDriverException()
     (vendor/doctrine/dbal/src/Connection.php:1857)
  at Doctrine\DBAL\Connection->convertException()
     (vendor/doctrine/dbal/src/Connection.php:348)
  at Doctrine\DBAL\Connection->connect()
     (vendor/doctrine/dbal/src/Connection.php:1619)
  at Doctrine\DBAL\Connection->getWrappedConnection()
     (vendor/doctrine/dbal/src/Connection.php:1013)
  at Doctrine\DBAL\Connection->prepare()
     (src/Services/Conexion.php:227)
  at App\Services\Conexion->query()
     (src/Controller/PtatController.php:1462)
  at App\Controller\PtatController->login_movil()
     (vendor/symfony/http-kernel/HttpKernel.php:163)
  at Symfony\Component\HttpKernel\HttpKernel->handleRaw()
     (vendor/symfony/http-kernel/HttpKernel.php:74)
  at Symfony\Component\HttpKernel\HttpKernel->handle()
     (vendor/symfony/http-kernel/Kernel.php:184)
  at Symfony\Component\HttpKernel\Kernel->handle()
     (vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php:35)
  at Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run()
     (vendor/autoload_runtime.php:29)
  at require_once('/www/php81/serversoap/recaudos/vendor/autoload_runtime.php')
     (public/index.php:16)
[2/3] Exception 
Doctrine\DBAL\Driver\PDO\Exception:
SQLSTATE[08006] [7] connection to server at "172.31.23.79", port 5432 failed: timeout expired

  at vendor/doctrine/dbal/src/Driver/PDO/Exception.php:28
  at Doctrine\DBAL\Driver\PDO\Exception::new()
     (vendor/doctrine/dbal/src/Driver/PDO/PgSQL/Driver.php:35)
  at Doctrine\DBAL\Driver\PDO\PgSQL\Driver->connect()
     (vendor/doctrine/dbal/src/Connection.php:346)
  at Doctrine\DBAL\Connection->connect()
     (vendor/doctrine/dbal/src/Connection.php:1619)
  at Doctrine\DBAL\Connection->getWrappedConnection()
     (vendor/doctrine/dbal/src/Connection.php:1013)
  at Doctrine\DBAL\Connection->prepare()
     (src/Services/Conexion.php:227)
  at App\Services\Conexion->query()
     (src/Controller/PtatController.php:1462)
  at App\Controller\PtatController->login_movil()
     (vendor/symfony/http-kernel/HttpKernel.php:163)
  at Symfony\Component\HttpKernel\HttpKernel->handleRaw()
     (vendor/symfony/http-kernel/HttpKernel.php:74)
  at Symfony\Component\HttpKernel\HttpKernel->handle()
     (vendor/symfony/http-kernel/Kernel.php:184)
  at Symfony\Component\HttpKernel\Kernel->handle()
     (vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php:35)
  at Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run()
     (vendor/autoload_runtime.php:29)
  at require_once('/www/php81/serversoap/recaudos/vendor/autoload_runtime.php')
     (public/index.php:16)
[1/3] PDOException 
PDOException:
SQLSTATE[08006] [7] connection to server at "172.31.23.79", port 5432 failed: timeout expired

  at vendor/doctrine/dbal/src/Driver/PDO/PgSQL/Driver.php:29
  at PDO->__construct()
     (vendor/doctrine/dbal/src/Driver/PDO/PgSQL/Driver.php:29)
  at Doctrine\DBAL\Driver\PDO\PgSQL\Driver->connect()
     (vendor/doctrine/dbal/src/Connection.php:346)
  at Doctrine\DBAL\Connection->connect()
     (vendor/doctrine/dbal/src/Connection.php:1619)
  at Doctrine\DBAL\Connection->getWrappedConnection()
     (vendor/doctrine/dbal/src/Connection.php:1013)
  at Doctrine\DBAL\Connection->prepare()
     (src/Services/Conexion.php:227)
  at App\Services\Conexion->query()
     (src/Controller/PtatController.php:1462)
  at App\Controller\PtatController->login_movil()
     (vendor/symfony/http-kernel/HttpKernel.php:163)
  at Symfony\Component\HttpKernel\HttpKernel->handleRaw()
     (vendor/symfony/http-kernel/HttpKernel.php:74)
  at Symfony\Component\HttpKernel\HttpKernel->handle()
     (vendor/symfony/http-kernel/Kernel.php:184)
  at Symfony\Component\HttpKernel\Kernel->handle()
     (vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php:35)
  at Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run()
     (vendor/autoload_runtime.php:29)
  at require_once('/www/php81/serversoap/recaudos/vendor/autoload_runtime.php')
     (public/index.php:16)
04 11 2023 10:12:04 Respuesta de conexion:HTTP/1.1 500 Internal Server Error Date: Sat, 04 Nov 2023 15:12:04 GMT Server: Apache/2.4.41 (Ubuntu) X-Powered-By: PHP/8.1.18 Access-Control-Allow-Origin: * Access-Control-Allow-Headers: X-API-KEY, Origin, X-Requested-With, Content-Type, Accept, Access-Control-Request-Method, Authorization, Authentication Access-Control-Allow-Methods: GET, POST, OPTIONS, PUT, DELETE Allow: GET, POST, OPTIONS, PUT, DELETE X-Debug-Exception: An%20exception%20occurred%20in%20the%20driver%3A%20SQLSTATE%5B08006%5D%20%5B7%5D%20connection%20to%20server%20at%20%22172.31.23.79%22%2C%20port%205432%20failed%3A%20timeout%20expired X-Debug-Exception-File: %2Fwww%2Fphp81%2Fserversoap%2Frecaudos%2Fvendor%2Fdoctrine%2Fdbal%2Fsrc%2FDriver%2FAPI%2FPostgreSQL%2FExceptionConverter.php:77 Cache-Control: no-cache, private X-Robots-Tag: noindex Connection: close Content-Type: text/html; charset=UTF-8 X-Original-Transfer-Encoding: chunked Content-Length: 276892 An exception occurred in the driver: SQLSTATE[08006] [7] connection to server at "172.31.23.79", port 5432 failed: timeout expired (500 Internal Server Error)

Symfony Exception

Symfony Docs

PDOException Exception ConnectionException

HTTP 500 Internal Server Error

An exception occurred in the driver: SQLSTATE[08006] [7] connection to server at "172.31.23.79", port 5432 failed: timeout expired

Exceptions 3

Doctrine\DBAL\Exception\ ConnectionException

in vendor/doctrine/dbal/src/Driver/API/PostgreSQL/ExceptionConverter.php (line 77)
  2.             case '42P07':
  3.                 return new TableExistsException($exception, $query);
  5.             case '08006':
  6.                 return new ConnectionException($exception, $query);
  7.         }
  9.         // Prior to fixing https://bugs.php.net/bug.php?id=64705 (PHP 7.4.10),
  10.         // in some cases (mainly connection errors) the PDO exception wouldn't provide a SQLSTATE via its code.
  11.         // We have to match against the SQLSTATE in the error message in these cases.
in vendor/doctrine/dbal/src/Connection.php -> convert (line 1908)
  1.     private function handleDriverException(
  2.         Driver\Exception $driverException,
  3.         ?Query $query
  4.     ): DriverException {
  5.         $this->exceptionConverter ??= $this->_driver->getExceptionConverter();
  6.         $exception                  = $this->exceptionConverter->convert($driverException, $query);
  8.         if ($exception instanceof ConnectionLost) {
  9.             $this->close();
  10.         }
in vendor/doctrine/dbal/src/Connection.php -> handleDriverException (line 1857)
  1.     }
  3.     /** @internal */
  4.     final public function convertException(Driver\Exception $e): DriverException
  5.     {
  6.         return $this->handleDriverException($e, null);
  7.     }
  9.     /**
  10.      * @param array<int, mixed>|array<string, mixed>                               $params
  11.      * @param array<int, int|string|Type|null>|array<string, int|string|Type|null> $types
in vendor/doctrine/dbal/src/Connection.php -> convertException (line 348)
  1.         }
  3.         try {
  4.             $this->_conn = $this->_driver->connect($this->params);
  5.         } catch (Driver\Exception $e) {
  6.             throw $this->convertException($e);
  7.         }
  9.         if ($this->autoCommit === false) {
  10.             $this->beginTransaction();
  11.         }
in vendor/doctrine/dbal/src/Connection.php -> connect (line 1619)
  1.             'https://github.com/doctrine/dbal/issues/4966',
  2.             'Connection::getWrappedConnection() is deprecated.'
  3.                 . ' Use Connection::getNativeConnection() to access the native connection.',
  4.         );
  6.         $this->connect();
  8.         assert($this->_conn !== null);
  10.         return $this->_conn;
  11.     }
in vendor/doctrine/dbal/src/Connection.php -> getWrappedConnection (line 1013)
  1.      *
  2.      * @throws Exception
  3.      */
  4.     public function prepare(string $sql): Statement
  5.     {
  6.         $connection = $this->getWrappedConnection();
  8.         try {
  9.             $statement = $connection->prepare($sql);
  10.         } catch (Driver\Exception $e) {
  11.             throw $this->convertExceptionDuringQuery($e, $sql);
Connection->prepare() in src/Services/Conexion.php (line 227)
  1.       );
  2.       //$cnn = \Doctrine\DBAL\DriverManager::getConnection($connectionParams, $config);
  3.       // $this->log->logs("Inicio ejecucion sql0");
  4.       $this->cnn = \Doctrine\DBAL\DriverManager::getConnection($connectionParams, $config);
  5.       //$sql = "SELECT * FROM articles";
  6.       $stmt = $this->cnn->prepare($sql);
  7.       /* switch ($con) 
  8.       {
  9.         case 6:
  10.           case 5:
  11.             $resultSet = $stmt->executeQuery();
Conexion->query() in src/Controller/PtatController.php (line 1462)
  1.       return $response;
  2.       exit;
  3.     }
  5.     $sql_man = "SELECT estado_modulos FROM sem_versiones sv2 WHERE id = (SELECT max(id) FROM sem_versiones sv WHERE estado = 0) AND estado_modulos = 0";
  6.     $res_man = $this->cnn->query('0', $sql_man);
  7.     if (!(count($res_man) > 0))
  8.     {
  9.       $respuesta["code"] = 0;
  10.       $respuesta["datos"] = "SEM esta en mantenimiento";
  11.       $response->setContent(json_encode($respuesta));
in vendor/symfony/http-kernel/HttpKernel.php -> login_movil (line 163)
  1.         $this->dispatcher->dispatch($event, KernelEvents::CONTROLLER_ARGUMENTS);
  2.         $controller = $event->getController();
  3.         $arguments = $event->getArguments();
  5.         // call controller
  6.         $response = $controller(...$arguments);
  8.         // view
  9.         if (!$response instanceof Response) {
  10.             $event = new ViewEvent($this, $request, $type, $response, $event);
  11.             $this->dispatcher->dispatch($event, KernelEvents::VIEW);
in vendor/symfony/http-kernel/HttpKernel.php -> handleRaw (line 74)
  1.     {
  2.         $request->headers->set('X-Php-Ob-Level', (string) ob_get_level());
  4.         $this->requestStack->push($request);
  5.         try {
  6.             return $this->handleRaw($request, $type);
  7.         } catch (\Throwable $e) {
  8.             if ($e instanceof \Error && !$this->handleAllThrowables) {
  9.                 throw $e;
  10.             }
in vendor/symfony/http-kernel/Kernel.php -> handle (line 184)
  1.         $this->boot();
  2.         ++$this->requestStackSize;
  3.         $this->resetServices = true;
  5.         try {
  6.             return $this->getHttpKernel()->handle($request, $type, $catch);
  7.         } finally {
  8.             --$this->requestStackSize;
  9.         }
  10.     }
in vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php -> handle (line 35)
  1.         $this->request = $request;
  2.     }
  4.     public function run(): int
  5.     {
  6.         $response = $this->kernel->handle($this->request);
  7.         $response->send();
  9.         if ($this->kernel instanceof TerminableInterface) {
  10.             $this->kernel->terminate($this->request, $response);
  11.         }
in vendor/autoload_runtime.php -> run (line 29)
  1. $app = $app(...$args);
  3. exit(
  4.     $runtime
  5.         ->getRunner($app)
  6.         ->run()
  7. );
require_once('/www/php81/serversoap/recaudos/vendor/autoload_runtime.php') in public/index.php (line 16)
  1. $method = $_SERVER['REQUEST_METHOD'];
  2. if($method == "OPTIONS") {
  3.     die();
  4. }
  6. require_once dirname(__DIR__).'/vendor/autoload_runtime.php';
  8. return function (array $context) {
  9.     return new Kernel($context['APP_ENV'], (bool) $context['APP_DEBUG']);
  10. };

Doctrine\DBAL\Driver\PDO\ Exception

SQLSTATE[08006] [7] connection to server at "172.31.23.79", port 5432 failed: timeout expired

in vendor/doctrine/dbal/src/Driver/PDO/Exception.php (line 28)
  1.         } else {
  2.             $code     = $exception->getCode();
  3.             $sqlState = null;
  4.         }
  6.         return new self($exception->getMessage(), $sqlState, $code, $exception);
  7.     }
  8. }
in vendor/doctrine/dbal/src/Driver/PDO/PgSQL/Driver.php :: new (line 35)
  1.                 $params['user'] ?? '',
  2.                 $params['password'] ?? '',
  3.                 $driverOptions,
  4.             );
  5.         } catch (PDOException $exception) {
  6.             throw Exception::new($exception);
  7.         }
  9.         if (
  10.             ! isset($driverOptions[PDO::PGSQL_ATTR_DISABLE_PREPARES])
  11.             || $driverOptions[PDO::PGSQL_ATTR_DISABLE_PREPARES] === true
in vendor/doctrine/dbal/src/Connection.php -> connect (line 346)
  1.         if ($this->_conn !== null) {
  2.             return false;
  3.         }
  5.         try {
  6.             $this->_conn = $this->_driver->connect($this->params);
  7.         } catch (Driver\Exception $e) {
  8.             throw $this->convertException($e);
  9.         }
  11.         if ($this->autoCommit === false) {
in vendor/doctrine/dbal/src/Connection.php -> connect (line 1619)
  1.             'https://github.com/doctrine/dbal/issues/4966',
  2.             'Connection::getWrappedConnection() is deprecated.'
  3.                 . ' Use Connection::getNativeConnection() to access the native connection.',
  4.         );
  6.         $this->connect();
  8.         assert($this->_conn !== null);
  10.         return $this->_conn;
  11.     }
in vendor/doctrine/dbal/src/Connection.php -> getWrappedConnection (line 1013)
  1.      *
  2.      * @throws Exception
  3.      */
  4.     public function prepare(string $sql): Statement
  5.     {
  6.         $connection = $this->getWrappedConnection();
  8.         try {
  9.             $statement = $connection->prepare($sql);
  10.         } catch (Driver\Exception $e) {
  11.             throw $this->convertExceptionDuringQuery($e, $sql);
Connection->prepare() in src/Services/Conexion.php (line 227)
  1.       );
  2.       //$cnn = \Doctrine\DBAL\DriverManager::getConnection($connectionParams, $config);
  3.       // $this->log->logs("Inicio ejecucion sql0");
  4.       $this->cnn = \Doctrine\DBAL\DriverManager::getConnection($connectionParams, $config);
  5.       //$sql = "SELECT * FROM articles";
  6.       $stmt = $this->cnn->prepare($sql);
  7.       /* switch ($con) 
  8.       {
  9.         case 6:
  10.           case 5:
  11.             $resultSet = $stmt->executeQuery();
Conexion->query() in src/Controller/PtatController.php (line 1462)
  1.       return $response;
  2.       exit;
  3.     }
  5.     $sql_man = "SELECT estado_modulos FROM sem_versiones sv2 WHERE id = (SELECT max(id) FROM sem_versiones sv WHERE estado = 0) AND estado_modulos = 0";
  6.     $res_man = $this->cnn->query('0', $sql_man);
  7.     if (!(count($res_man) > 0))
  8.     {
  9.       $respuesta["code"] = 0;
  10.       $respuesta["datos"] = "SEM esta en mantenimiento";
  11.       $response->setContent(json_encode($respuesta));
in vendor/symfony/http-kernel/HttpKernel.php -> login_movil (line 163)
  1.         $this->dispatcher->dispatch($event, KernelEvents::CONTROLLER_ARGUMENTS);
  2.         $controller = $event->getController();
  3.         $arguments = $event->getArguments();
  5.         // call controller
  6.         $response = $controller(...$arguments);
  8.         // view
  9.         if (!$response instanceof Response) {
  10.             $event = new ViewEvent($this, $request, $type, $response, $event);
  11.             $this->dispatcher->dispatch($event, KernelEvents::VIEW);
in vendor/symfony/http-kernel/HttpKernel.php -> handleRaw (line 74)
  1.     {
  2.         $request->headers->set('X-Php-Ob-Level', (string) ob_get_level());
  4.         $this->requestStack->push($request);
  5.         try {
  6.             return $this->handleRaw($request, $type);
  7.         } catch (\Throwable $e) {
  8.             if ($e instanceof \Error && !$this->handleAllThrowables) {
  9.                 throw $e;
  10.             }
in vendor/symfony/http-kernel/Kernel.php -> handle (line 184)
  1.         $this->boot();
  2.         ++$this->requestStackSize;
  3.         $this->resetServices = true;
  5.         try {
  6.             return $this->getHttpKernel()->handle($request, $type, $catch);
  7.         } finally {
  8.             --$this->requestStackSize;
  9.         }
  10.     }
in vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php -> handle (line 35)
  1.         $this->request = $request;
  2.     }
  4.     public function run(): int
  5.     {
  6.         $response = $this->kernel->handle($this->request);
  7.         $response->send();
  9.         if ($this->kernel instanceof TerminableInterface) {
  10.             $this->kernel->terminate($this->request, $response);
  11.         }
in vendor/autoload_runtime.php -> run (line 29)
  1. $app = $app(...$args);
  3. exit(
  4.     $runtime
  5.         ->getRunner($app)
  6.         ->run()
  7. );
require_once('/www/php81/serversoap/recaudos/vendor/autoload_runtime.php') in public/index.php (line 16)
  1. $method = $_SERVER['REQUEST_METHOD'];
  2. if($method == "OPTIONS") {
  3.     die();
  4. }
  6. require_once dirname(__DIR__).'/vendor/autoload_runtime.php';
  8. return function (array $context) {
  9.     return new Kernel($context['APP_ENV'], (bool) $context['APP_DEBUG']);
  10. };

PDOException

SQLSTATE[08006] [7] connection to server at "172.31.23.79", port 5432 failed: timeout expired

in vendor/doctrine/dbal/src/Driver/PDO/PgSQL/Driver.php (line 29)
  1.             $driverOptions[PDO::ATTR_PERSISTENT] = true;
  2.         }
  4.         try {
  5.             $pdo = new PDO(
  6.                 $this->constructPdoDsn($params),
  7.                 $params['user'] ?? '',
  8.                 $params['password'] ?? '',
  9.                 $driverOptions,
  10.             );
  11.         } catch (PDOException $exception) {
in vendor/doctrine/dbal/src/Driver/PDO/PgSQL/Driver.php -> __construct (line 29)
  1.             $driverOptions[PDO::ATTR_PERSISTENT] = true;
  2.         }
  4.         try {
  5.             $pdo = new PDO(
  6.                 $this->constructPdoDsn($params),
  7.                 $params['user'] ?? '',
  8.                 $params['password'] ?? '',
  9.                 $driverOptions,
  10.             );
  11.         } catch (PDOException $exception) {
in vendor/doctrine/dbal/src/Connection.php -> connect (line 346)
  1.         if ($this->_conn !== null) {
  2.             return false;
  3.         }
  5.         try {
  6.             $this->_conn = $this->_driver->connect($this->params);
  7.         } catch (Driver\Exception $e) {
  8.             throw $this->convertException($e);
  9.         }
  11.         if ($this->autoCommit === false) {
in vendor/doctrine/dbal/src/Connection.php -> connect (line 1619)
  1.             'https://github.com/doctrine/dbal/issues/4966',
  2.             'Connection::getWrappedConnection() is deprecated.'
  3.                 . ' Use Connection::getNativeConnection() to access the native connection.',
  4.         );
  6.         $this->connect();
  8.         assert($this->_conn !== null);
  10.         return $this->_conn;
  11.     }
in vendor/doctrine/dbal/src/Connection.php -> getWrappedConnection (line 1013)
  1.      *
  2.      * @throws Exception
  3.      */
  4.     public function prepare(string $sql): Statement
  5.     {
  6.         $connection = $this->getWrappedConnection();
  8.         try {
  9.             $statement = $connection->prepare($sql);
  10.         } catch (Driver\Exception $e) {
  11.             throw $this->convertExceptionDuringQuery($e, $sql);
Connection->prepare() in src/Services/Conexion.php (line 227)
  1.       );
  2.       //$cnn = \Doctrine\DBAL\DriverManager::getConnection($connectionParams, $config);
  3.       // $this->log->logs("Inicio ejecucion sql0");
  4.       $this->cnn = \Doctrine\DBAL\DriverManager::getConnection($connectionParams, $config);
  5.       //$sql = "SELECT * FROM articles";
  6.       $stmt = $this->cnn->prepare($sql);
  7.       /* switch ($con) 
  8.       {
  9.         case 6:
  10.           case 5:
  11.             $resultSet = $stmt->executeQuery();
Conexion->query() in src/Controller/PtatController.php (line 1462)
  1.       return $response;
  2.       exit;
  3.     }
  5.     $sql_man = "SELECT estado_modulos FROM sem_versiones sv2 WHERE id = (SELECT max(id) FROM sem_versiones sv WHERE estado = 0) AND estado_modulos = 0";
  6.     $res_man = $this->cnn->query('0', $sql_man);
  7.     if (!(count($res_man) > 0))
  8.     {
  9.       $respuesta["code"] = 0;
  10.       $respuesta["datos"] = "SEM esta en mantenimiento";
  11.       $response->setContent(json_encode($respuesta));
in vendor/symfony/http-kernel/HttpKernel.php -> login_movil (line 163)
  1.         $this->dispatcher->dispatch($event, KernelEvents::CONTROLLER_ARGUMENTS);
  2.         $controller = $event->getController();
  3.         $arguments = $event->getArguments();
  5.         // call controller
  6.         $response = $controller(...$arguments);
  8.         // view
  9.         if (!$response instanceof Response) {
  10.             $event = new ViewEvent($this, $request, $type, $response, $event);
  11.             $this->dispatcher->dispatch($event, KernelEvents::VIEW);
in vendor/symfony/http-kernel/HttpKernel.php -> handleRaw (line 74)
  1.     {
  2.         $request->headers->set('X-Php-Ob-Level', (string) ob_get_level());
  4.         $this->requestStack->push($request);
  5.         try {
  6.             return $this->handleRaw($request, $type);
  7.         } catch (\Throwable $e) {
  8.             if ($e instanceof \Error && !$this->handleAllThrowables) {
  9.                 throw $e;
  10.             }
in vendor/symfony/http-kernel/Kernel.php -> handle (line 184)
  1.         $this->boot();
  2.         ++$this->requestStackSize;
  3.         $this->resetServices = true;
  5.         try {
  6.             return $this->getHttpKernel()->handle($request, $type, $catch);
  7.         } finally {
  8.             --$this->requestStackSize;
  9.         }
  10.     }
in vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php -> handle (line 35)
  1.         $this->request = $request;
  2.     }
  4.     public function run(): int
  5.     {
  6.         $response = $this->kernel->handle($this->request);
  7.         $response->send();
  9.         if ($this->kernel instanceof TerminableInterface) {
  10.             $this->kernel->terminate($this->request, $response);
  11.         }
in vendor/autoload_runtime.php -> run (line 29)
  1. $app = $app(...$args);
  3. exit(
  4.     $runtime
  5.         ->getRunner($app)
  6.         ->run()
  7. );
require_once('/www/php81/serversoap/recaudos/vendor/autoload_runtime.php') in public/index.php (line 16)
  1. $method = $_SERVER['REQUEST_METHOD'];
  2. if($method == "OPTIONS") {
  3.     die();
  4. }
  6. require_once dirname(__DIR__).'/vendor/autoload_runtime.php';
  8. return function (array $context) {
  9.     return new Kernel($context['APP_ENV'], (bool) $context['APP_DEBUG']);
  10. };

Logs

No log messages

Stack Traces 3

[3/3] ConnectionException 
Doctrine\DBAL\Exception\ConnectionException:
An exception occurred in the driver: SQLSTATE[08006] [7] connection to server at "172.31.23.79", port 5432 failed: timeout expired

  at vendor/doctrine/dbal/src/Driver/API/PostgreSQL/ExceptionConverter.php:77
  at Doctrine\DBAL\Driver\API\PostgreSQL\ExceptionConverter->convert()
     (vendor/doctrine/dbal/src/Connection.php:1908)
  at Doctrine\DBAL\Connection->handleDriverException()
     (vendor/doctrine/dbal/src/Connection.php:1857)
  at Doctrine\DBAL\Connection->convertException()
     (vendor/doctrine/dbal/src/Connection.php:348)
  at Doctrine\DBAL\Connection->connect()
     (vendor/doctrine/dbal/src/Connection.php:1619)
  at Doctrine\DBAL\Connection->getWrappedConnection()
     (vendor/doctrine/dbal/src/Connection.php:1013)
  at Doctrine\DBAL\Connection->prepare()
     (src/Services/Conexion.php:227)
  at App\Services\Conexion->query()
     (src/Controller/PtatController.php:1462)
  at App\Controller\PtatController->login_movil()
     (vendor/symfony/http-kernel/HttpKernel.php:163)
  at Symfony\Component\HttpKernel\HttpKernel->handleRaw()
     (vendor/symfony/http-kernel/HttpKernel.php:74)
  at Symfony\Component\HttpKernel\HttpKernel->handle()
     (vendor/symfony/http-kernel/Kernel.php:184)
  at Symfony\Component\HttpKernel\Kernel->handle()
     (vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php:35)
  at Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run()
     (vendor/autoload_runtime.php:29)
  at require_once('/www/php81/serversoap/recaudos/vendor/autoload_runtime.php')
     (public/index.php:16)
[2/3] Exception 
Doctrine\DBAL\Driver\PDO\Exception:
SQLSTATE[08006] [7] connection to server at "172.31.23.79", port 5432 failed: timeout expired

  at vendor/doctrine/dbal/src/Driver/PDO/Exception.php:28
  at Doctrine\DBAL\Driver\PDO\Exception::new()
     (vendor/doctrine/dbal/src/Driver/PDO/PgSQL/Driver.php:35)
  at Doctrine\DBAL\Driver\PDO\PgSQL\Driver->connect()
     (vendor/doctrine/dbal/src/Connection.php:346)
  at Doctrine\DBAL\Connection->connect()
     (vendor/doctrine/dbal/src/Connection.php:1619)
  at Doctrine\DBAL\Connection->getWrappedConnection()
     (vendor/doctrine/dbal/src/Connection.php:1013)
  at Doctrine\DBAL\Connection->prepare()
     (src/Services/Conexion.php:227)
  at App\Services\Conexion->query()
     (src/Controller/PtatController.php:1462)
  at App\Controller\PtatController->login_movil()
     (vendor/symfony/http-kernel/HttpKernel.php:163)
  at Symfony\Component\HttpKernel\HttpKernel->handleRaw()
     (vendor/symfony/http-kernel/HttpKernel.php:74)
  at Symfony\Component\HttpKernel\HttpKernel->handle()
     (vendor/symfony/http-kernel/Kernel.php:184)
  at Symfony\Component\HttpKernel\Kernel->handle()
     (vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php:35)
  at Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run()
     (vendor/autoload_runtime.php:29)
  at require_once('/www/php81/serversoap/recaudos/vendor/autoload_runtime.php')
     (public/index.php:16)
[1/3] PDOException 
PDOException:
SQLSTATE[08006] [7] connection to server at "172.31.23.79", port 5432 failed: timeout expired

  at vendor/doctrine/dbal/src/Driver/PDO/PgSQL/Driver.php:29
  at PDO->__construct()
     (vendor/doctrine/dbal/src/Driver/PDO/PgSQL/Driver.php:29)
  at Doctrine\DBAL\Driver\PDO\PgSQL\Driver->connect()
     (vendor/doctrine/dbal/src/Connection.php:346)
  at Doctrine\DBAL\Connection->connect()
     (vendor/doctrine/dbal/src/Connection.php:1619)
  at Doctrine\DBAL\Connection->getWrappedConnection()
     (vendor/doctrine/dbal/src/Connection.php:1013)
  at Doctrine\DBAL\Connection->prepare()
     (src/Services/Conexion.php:227)
  at App\Services\Conexion->query()
     (src/Controller/PtatController.php:1462)
  at App\Controller\PtatController->login_movil()
     (vendor/symfony/http-kernel/HttpKernel.php:163)
  at Symfony\Component\HttpKernel\HttpKernel->handleRaw()
     (vendor/symfony/http-kernel/HttpKernel.php:74)
  at Symfony\Component\HttpKernel\HttpKernel->handle()
     (vendor/symfony/http-kernel/Kernel.php:184)
  at Symfony\Component\HttpKernel\Kernel->handle()
     (vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php:35)
  at Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run()
     (vendor/autoload_runtime.php:29)
  at require_once('/www/php81/serversoap/recaudos/vendor/autoload_runtime.php')
     (public/index.php:16)