04 02 2025 06:32:02 El Archivo 2025-02-04 - log_error.txt se ha creado ************************************************************ -- LM-ERROR: HTTP/1.1 500 Internal Server Error Date: Tue, 04 Feb 2025 11:32:02 GMT Server: Apache/2.4.41 (Ubuntu) X-Powered-By: PHP/8.1.27 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%2210.231.0.132%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: 298333
case '42P07':
return new TableExistsException($exception, $query);
case '08006':
return new ConnectionException($exception, $query);
}
// Prior to fixing https://bugs.php.net/bug.php?id=64705 (PHP 7.4.10),
// in some cases (mainly connection errors) the PDO exception wouldn't provide a SQLSTATE via its code.
// We have to match against the SQLSTATE in the error message in these cases.
private function handleDriverException(
Driver\Exception $driverException,
?Query $query
): DriverException {
$this->exceptionConverter ??= $this->_driver->getExceptionConverter();
$exception = $this->exceptionConverter->convert($driverException, $query);
if ($exception instanceof ConnectionLost) {
$this->close();
}
}
/** @internal */
final public function convertException(Driver\Exception $e): DriverException
{
return $this->handleDriverException($e, null);
}
/**
* @param array<int, mixed>|array<string, mixed> $params
* @param array<int, int|string|Type|null>|array<string, int|string|Type|null> $types
}
try {
$this->_conn = $this->_driver->connect($this->params);
} catch (Driver\Exception $e) {
throw $this->convertException($e);
}
if ($this->autoCommit === false) {
$this->beginTransaction();
}
'https://github.com/doctrine/dbal/issues/4966',
'Connection::getWrappedConnection() is deprecated.'
. ' Use Connection::getNativeConnection() to access the native connection.',
);
$this->connect();
assert($this->_conn !== null);
return $this->_conn;
}
*
* @throws Exception
*/
public function prepare(string $sql): Statement
{
$connection = $this->getWrappedConnection();
try {
$statement = $connection->prepare($sql);
} catch (Driver\Exception $e) {
throw $this->convertExceptionDuringQuery($e, $sql);
);
//$cnn = \Doctrine\DBAL\DriverManager::getConnection($connectionParams, $config);
// $this->log->logs("Inicio ejecucion sql0");
$this->cnn = \Doctrine\DBAL\DriverManager::getConnection($connectionParams, $config);
//$sql = "SELECT * FROM articles";
$stmt = $this->cnn->prepare($sql);
/* switch ($con)
{
case 6:
case 5:
$resultSet = $stmt->executeQuery();
case 24:
case 25:
return $this->consulta_socket($con,$sql);
break;
default:
return $this->query_normal($con,$sql);
break;
}
}
}
$name_device = (!empty($params[0]->name_device)) ? $params[0]->name_device : null;
$operador = (!empty($params[0]->operador)) ? $params[0]->operador : null;
$version_app = (!empty($params[0]->version_app)) ? $params[0]->version_app : null;
$sql_man = "SELECT version,estado_modulos FROM sem_versiones sv2 WHERE id = (SELECT max(id) FROM sem_versiones sv WHERE estado = 0)";
$res_man = $this->cnn->query('0', $sql_man);
if (count($res_man) <= 0)
{
$respuesta["datos"] = "No se encontro ninguna version de SEM";
return $response->setContent(json_encode($respuesta));
}
$this->dispatcher->dispatch($event, KernelEvents::CONTROLLER_ARGUMENTS);
$controller = $event->getController();
$arguments = $event->getArguments();
// call controller
$response = $controller(...$arguments);
// view
if (!$response instanceof Response) {
$event = new ViewEvent($this, $request, $type, $response, $event);
$this->dispatcher->dispatch($event, KernelEvents::VIEW);
{
$request->headers->set('X-Php-Ob-Level', (string) ob_get_level());
$this->requestStack->push($request);
try {
return $this->handleRaw($request, $type);
} catch (\Throwable $e) {
if ($e instanceof \Error && !$this->handleAllThrowables) {
throw $e;
}
$this->boot();
++$this->requestStackSize;
$this->resetServices = true;
try {
return $this->getHttpKernel()->handle($request, $type, $catch);
} finally {
--$this->requestStackSize;
}
}
$this->request = $request;
}
public function run(): int
{
$response = $this->kernel->handle($this->request);
$response->send();
if ($this->kernel instanceof TerminableInterface) {
$this->kernel->terminate($this->request, $response);
}
$app = $app(...$args);
exit(
$runtime
->getRunner($app)
->run()
);
$method = $_SERVER['REQUEST_METHOD'];
if($method == "OPTIONS") {
die();
}
require_once dirname(__DIR__).'/vendor/autoload_runtime.php';
return function (array $context) {
return new Kernel($context['APP_ENV'], (bool) $context['APP_DEBUG']);
};
} else {
$code = $exception->getCode();
$sqlState = null;
}
return new self($exception->getMessage(), $sqlState, $code, $exception);
}
}
$params['user'] ?? '',
$params['password'] ?? '',
$driverOptions,
);
} catch (PDOException $exception) {
throw Exception::new($exception);
}
if (
! isset($driverOptions[PDO::PGSQL_ATTR_DISABLE_PREPARES])
|| $driverOptions[PDO::PGSQL_ATTR_DISABLE_PREPARES] === true
if ($this->_conn !== null) {
return false;
}
try {
$this->_conn = $this->_driver->connect($this->params);
} catch (Driver\Exception $e) {
throw $this->convertException($e);
}
if ($this->autoCommit === false) {
'https://github.com/doctrine/dbal/issues/4966',
'Connection::getWrappedConnection() is deprecated.'
. ' Use Connection::getNativeConnection() to access the native connection.',
);
$this->connect();
assert($this->_conn !== null);
return $this->_conn;
}
*
* @throws Exception
*/
public function prepare(string $sql): Statement
{
$connection = $this->getWrappedConnection();
try {
$statement = $connection->prepare($sql);
} catch (Driver\Exception $e) {
throw $this->convertExceptionDuringQuery($e, $sql);
);
//$cnn = \Doctrine\DBAL\DriverManager::getConnection($connectionParams, $config);
// $this->log->logs("Inicio ejecucion sql0");
$this->cnn = \Doctrine\DBAL\DriverManager::getConnection($connectionParams, $config);
//$sql = "SELECT * FROM articles";
$stmt = $this->cnn->prepare($sql);
/* switch ($con)
{
case 6:
case 5:
$resultSet = $stmt->executeQuery();
case 24:
case 25:
return $this->consulta_socket($con,$sql);
break;
default:
return $this->query_normal($con,$sql);
break;
}
}
}
$name_device = (!empty($params[0]->name_device)) ? $params[0]->name_device : null;
$operador = (!empty($params[0]->operador)) ? $params[0]->operador : null;
$version_app = (!empty($params[0]->version_app)) ? $params[0]->version_app : null;
$sql_man = "SELECT version,estado_modulos FROM sem_versiones sv2 WHERE id = (SELECT max(id) FROM sem_versiones sv WHERE estado = 0)";
$res_man = $this->cnn->query('0', $sql_man);
if (count($res_man) <= 0)
{
$respuesta["datos"] = "No se encontro ninguna version de SEM";
return $response->setContent(json_encode($respuesta));
}
$this->dispatcher->dispatch($event, KernelEvents::CONTROLLER_ARGUMENTS);
$controller = $event->getController();
$arguments = $event->getArguments();
// call controller
$response = $controller(...$arguments);
// view
if (!$response instanceof Response) {
$event = new ViewEvent($this, $request, $type, $response, $event);
$this->dispatcher->dispatch($event, KernelEvents::VIEW);
{
$request->headers->set('X-Php-Ob-Level', (string) ob_get_level());
$this->requestStack->push($request);
try {
return $this->handleRaw($request, $type);
} catch (\Throwable $e) {
if ($e instanceof \Error && !$this->handleAllThrowables) {
throw $e;
}
$this->boot();
++$this->requestStackSize;
$this->resetServices = true;
try {
return $this->getHttpKernel()->handle($request, $type, $catch);
} finally {
--$this->requestStackSize;
}
}
$this->request = $request;
}
public function run(): int
{
$response = $this->kernel->handle($this->request);
$response->send();
if ($this->kernel instanceof TerminableInterface) {
$this->kernel->terminate($this->request, $response);
}
$app = $app(...$args);
exit(
$runtime
->getRunner($app)
->run()
);
$method = $_SERVER['REQUEST_METHOD'];
if($method == "OPTIONS") {
die();
}
require_once dirname(__DIR__).'/vendor/autoload_runtime.php';
return function (array $context) {
return new Kernel($context['APP_ENV'], (bool) $context['APP_DEBUG']);
};
$driverOptions[PDO::ATTR_PERSISTENT] = true;
}
try {
$pdo = new PDO(
$this->constructPdoDsn($params),
$params['user'] ?? '',
$params['password'] ?? '',
$driverOptions,
);
} catch (PDOException $exception) {
$driverOptions[PDO::ATTR_PERSISTENT] = true;
}
try {
$pdo = new PDO(
$this->constructPdoDsn($params),
$params['user'] ?? '',
$params['password'] ?? '',
$driverOptions,
);
} catch (PDOException $exception) {
if ($this->_conn !== null) {
return false;
}
try {
$this->_conn = $this->_driver->connect($this->params);
} catch (Driver\Exception $e) {
throw $this->convertException($e);
}
if ($this->autoCommit === false) {
'https://github.com/doctrine/dbal/issues/4966',
'Connection::getWrappedConnection() is deprecated.'
. ' Use Connection::getNativeConnection() to access the native connection.',
);
$this->connect();
assert($this->_conn !== null);
return $this->_conn;
}
*
* @throws Exception
*/
public function prepare(string $sql): Statement
{
$connection = $this->getWrappedConnection();
try {
$statement = $connection->prepare($sql);
} catch (Driver\Exception $e) {
throw $this->convertExceptionDuringQuery($e, $sql);
);
//$cnn = \Doctrine\DBAL\DriverManager::getConnection($connectionParams, $config);
// $this->log->logs("Inicio ejecucion sql0");
$this->cnn = \Doctrine\DBAL\DriverManager::getConnection($connectionParams, $config);
//$sql = "SELECT * FROM articles";
$stmt = $this->cnn->prepare($sql);
/* switch ($con)
{
case 6:
case 5:
$resultSet = $stmt->executeQuery();
case 24:
case 25:
return $this->consulta_socket($con,$sql);
break;
default:
return $this->query_normal($con,$sql);
break;
}
}
}
$name_device = (!empty($params[0]->name_device)) ? $params[0]->name_device : null;
$operador = (!empty($params[0]->operador)) ? $params[0]->operador : null;
$version_app = (!empty($params[0]->version_app)) ? $params[0]->version_app : null;
$sql_man = "SELECT version,estado_modulos FROM sem_versiones sv2 WHERE id = (SELECT max(id) FROM sem_versiones sv WHERE estado = 0)";
$res_man = $this->cnn->query('0', $sql_man);
if (count($res_man) <= 0)
{
$respuesta["datos"] = "No se encontro ninguna version de SEM";
return $response->setContent(json_encode($respuesta));
}
$this->dispatcher->dispatch($event, KernelEvents::CONTROLLER_ARGUMENTS);
$controller = $event->getController();
$arguments = $event->getArguments();
// call controller
$response = $controller(...$arguments);
// view
if (!$response instanceof Response) {
$event = new ViewEvent($this, $request, $type, $response, $event);
$this->dispatcher->dispatch($event, KernelEvents::VIEW);
{
$request->headers->set('X-Php-Ob-Level', (string) ob_get_level());
$this->requestStack->push($request);
try {
return $this->handleRaw($request, $type);
} catch (\Throwable $e) {
if ($e instanceof \Error && !$this->handleAllThrowables) {
throw $e;
}
$this->boot();
++$this->requestStackSize;
$this->resetServices = true;
try {
return $this->getHttpKernel()->handle($request, $type, $catch);
} finally {
--$this->requestStackSize;
}
}
$this->request = $request;
}
public function run(): int
{
$response = $this->kernel->handle($this->request);
$response->send();
if ($this->kernel instanceof TerminableInterface) {
$this->kernel->terminate($this->request, $response);
}
$app = $app(...$args);
exit(
$runtime
->getRunner($app)
->run()
);
$method = $_SERVER['REQUEST_METHOD'];
if($method == "OPTIONS") {
die();
}
require_once dirname(__DIR__).'/vendor/autoload_runtime.php';
return function (array $context) {
return new Kernel($context['APP_ENV'], (bool) $context['APP_DEBUG']);
};
No log messages
[3/3]
ConnectionException
|
---|
Doctrine\DBAL\Exception\ConnectionException: An exception occurred in the driver: SQLSTATE[08006] [7] connection to server at "10.231.0.132", 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:551) at App\Services\Conexion->query_normal() (src/Services/Conexion.php:525) at App\Services\Conexion->query() (src/Controller/PtatController.php:1773) 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 "10.231.0.132", 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:551) at App\Services\Conexion->query_normal() (src/Services/Conexion.php:525) at App\Services\Conexion->query() (src/Controller/PtatController.php:1773) 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 "10.231.0.132", 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:551) at App\Services\Conexion->query_normal() (src/Services/Conexion.php:525) at App\Services\Conexion->query() (src/Controller/PtatController.php:1773) 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) |
case '42P07':
return new TableExistsException($exception, $query);
case '08006':
return new ConnectionException($exception, $query);
}
// Prior to fixing https://bugs.php.net/bug.php?id=64705 (PHP 7.4.10),
// in some cases (mainly connection errors) the PDO exception wouldn't provide a SQLSTATE via its code.
// We have to match against the SQLSTATE in the error message in these cases.
private function handleDriverException(
Driver\Exception $driverException,
?Query $query
): DriverException {
$this->exceptionConverter ??= $this->_driver->getExceptionConverter();
$exception = $this->exceptionConverter->convert($driverException, $query);
if ($exception instanceof ConnectionLost) {
$this->close();
}
}
/** @internal */
final public function convertException(Driver\Exception $e): DriverException
{
return $this->handleDriverException($e, null);
}
/**
* @param array<int, mixed>|array<string, mixed> $params
* @param array<int, int|string|Type|null>|array<string, int|string|Type|null> $types
}
try {
$this->_conn = $this->_driver->connect($this->params);
} catch (Driver\Exception $e) {
throw $this->convertException($e);
}
if ($this->autoCommit === false) {
$this->beginTransaction();
}
'https://github.com/doctrine/dbal/issues/4966',
'Connection::getWrappedConnection() is deprecated.'
. ' Use Connection::getNativeConnection() to access the native connection.',
);
$this->connect();
assert($this->_conn !== null);
return $this->_conn;
}
*
* @throws Exception
*/
public function prepare(string $sql): Statement
{
$connection = $this->getWrappedConnection();
try {
$statement = $connection->prepare($sql);
} catch (Driver\Exception $e) {
throw $this->convertExceptionDuringQuery($e, $sql);
);
//$cnn = \Doctrine\DBAL\DriverManager::getConnection($connectionParams, $config);
// $this->log->logs("Inicio ejecucion sql0");
$this->cnn = \Doctrine\DBAL\DriverManager::getConnection($connectionParams, $config);
//$sql = "SELECT * FROM articles";
$stmt = $this->cnn->prepare($sql);
/* switch ($con)
{
case 6:
case 5:
$resultSet = $stmt->executeQuery();
case 24:
case 25:
return $this->consulta_socket($con,$sql);
break;
default:
return $this->query_normal($con,$sql);
break;
}
}
}
$name_device = (!empty($params[0]->name_device)) ? $params[0]->name_device : null;
$operador = (!empty($params[0]->operador)) ? $params[0]->operador : null;
$version_app = (!empty($params[0]->version_app)) ? $params[0]->version_app : null;
$sql_man = "SELECT version,estado_modulos FROM sem_versiones sv2 WHERE id = (SELECT max(id) FROM sem_versiones sv WHERE estado = 0)";
$res_man = $this->cnn->query('0', $sql_man);
if (count($res_man) <= 0)
{
$respuesta["datos"] = "No se encontro ninguna version de SEM";
return $response->setContent(json_encode($respuesta));
}
$this->dispatcher->dispatch($event, KernelEvents::CONTROLLER_ARGUMENTS);
$controller = $event->getController();
$arguments = $event->getArguments();
// call controller
$response = $controller(...$arguments);
// view
if (!$response instanceof Response) {
$event = new ViewEvent($this, $request, $type, $response, $event);
$this->dispatcher->dispatch($event, KernelEvents::VIEW);
{
$request->headers->set('X-Php-Ob-Level', (string) ob_get_level());
$this->requestStack->push($request);
try {
return $this->handleRaw($request, $type);
} catch (\Throwable $e) {
if ($e instanceof \Error && !$this->handleAllThrowables) {
throw $e;
}
$this->boot();
++$this->requestStackSize;
$this->resetServices = true;
try {
return $this->getHttpKernel()->handle($request, $type, $catch);
} finally {
--$this->requestStackSize;
}
}
$this->request = $request;
}
public function run(): int
{
$response = $this->kernel->handle($this->request);
$response->send();
if ($this->kernel instanceof TerminableInterface) {
$this->kernel->terminate($this->request, $response);
}
$app = $app(...$args);
exit(
$runtime
->getRunner($app)
->run()
);
$method = $_SERVER['REQUEST_METHOD'];
if($method == "OPTIONS") {
die();
}
require_once dirname(__DIR__).'/vendor/autoload_runtime.php';
return function (array $context) {
return new Kernel($context['APP_ENV'], (bool) $context['APP_DEBUG']);
};
} else {
$code = $exception->getCode();
$sqlState = null;
}
return new self($exception->getMessage(), $sqlState, $code, $exception);
}
}
$params['user'] ?? '',
$params['password'] ?? '',
$driverOptions,
);
} catch (PDOException $exception) {
throw Exception::new($exception);
}
if (
! isset($driverOptions[PDO::PGSQL_ATTR_DISABLE_PREPARES])
|| $driverOptions[PDO::PGSQL_ATTR_DISABLE_PREPARES] === true
if ($this->_conn !== null) {
return false;
}
try {
$this->_conn = $this->_driver->connect($this->params);
} catch (Driver\Exception $e) {
throw $this->convertException($e);
}
if ($this->autoCommit === false) {
'https://github.com/doctrine/dbal/issues/4966',
'Connection::getWrappedConnection() is deprecated.'
. ' Use Connection::getNativeConnection() to access the native connection.',
);
$this->connect();
assert($this->_conn !== null);
return $this->_conn;
}
*
* @throws Exception
*/
public function prepare(string $sql): Statement
{
$connection = $this->getWrappedConnection();
try {
$statement = $connection->prepare($sql);
} catch (Driver\Exception $e) {
throw $this->convertExceptionDuringQuery($e, $sql);
);
//$cnn = \Doctrine\DBAL\DriverManager::getConnection($connectionParams, $config);
// $this->log->logs("Inicio ejecucion sql0");
$this->cnn = \Doctrine\DBAL\DriverManager::getConnection($connectionParams, $config);
//$sql = "SELECT * FROM articles";
$stmt = $this->cnn->prepare($sql);
/* switch ($con)
{
case 6:
case 5:
$resultSet = $stmt->executeQuery();
case 24:
case 25:
return $this->consulta_socket($con,$sql);
break;
default:
return $this->query_normal($con,$sql);
break;
}
}
}
$name_device = (!empty($params[0]->name_device)) ? $params[0]->name_device : null;
$operador = (!empty($params[0]->operador)) ? $params[0]->operador : null;
$version_app = (!empty($params[0]->version_app)) ? $params[0]->version_app : null;
$sql_man = "SELECT version,estado_modulos FROM sem_versiones sv2 WHERE id = (SELECT max(id) FROM sem_versiones sv WHERE estado = 0)";
$res_man = $this->cnn->query('0', $sql_man);
if (count($res_man) <= 0)
{
$respuesta["datos"] = "No se encontro ninguna version de SEM";
return $response->setContent(json_encode($respuesta));
}
$this->dispatcher->dispatch($event, KernelEvents::CONTROLLER_ARGUMENTS);
$controller = $event->getController();
$arguments = $event->getArguments();
// call controller
$response = $controller(...$arguments);
// view
if (!$response instanceof Response) {
$event = new ViewEvent($this, $request, $type, $response, $event);
$this->dispatcher->dispatch($event, KernelEvents::VIEW);
{
$request->headers->set('X-Php-Ob-Level', (string) ob_get_level());
$this->requestStack->push($request);
try {
return $this->handleRaw($request, $type);
} catch (\Throwable $e) {
if ($e instanceof \Error && !$this->handleAllThrowables) {
throw $e;
}
$this->boot();
++$this->requestStackSize;
$this->resetServices = true;
try {
return $this->getHttpKernel()->handle($request, $type, $catch);
} finally {
--$this->requestStackSize;
}
}
$this->request = $request;
}
public function run(): int
{
$response = $this->kernel->handle($this->request);
$response->send();
if ($this->kernel instanceof TerminableInterface) {
$this->kernel->terminate($this->request, $response);
}
$app = $app(...$args);
exit(
$runtime
->getRunner($app)
->run()
);
$method = $_SERVER['REQUEST_METHOD'];
if($method == "OPTIONS") {
die();
}
require_once dirname(__DIR__).'/vendor/autoload_runtime.php';
return function (array $context) {
return new Kernel($context['APP_ENV'], (bool) $context['APP_DEBUG']);
};
$driverOptions[PDO::ATTR_PERSISTENT] = true;
}
try {
$pdo = new PDO(
$this->constructPdoDsn($params),
$params['user'] ?? '',
$params['password'] ?? '',
$driverOptions,
);
} catch (PDOException $exception) {
$driverOptions[PDO::ATTR_PERSISTENT] = true;
}
try {
$pdo = new PDO(
$this->constructPdoDsn($params),
$params['user'] ?? '',
$params['password'] ?? '',
$driverOptions,
);
} catch (PDOException $exception) {
if ($this->_conn !== null) {
return false;
}
try {
$this->_conn = $this->_driver->connect($this->params);
} catch (Driver\Exception $e) {
throw $this->convertException($e);
}
if ($this->autoCommit === false) {
'https://github.com/doctrine/dbal/issues/4966',
'Connection::getWrappedConnection() is deprecated.'
. ' Use Connection::getNativeConnection() to access the native connection.',
);
$this->connect();
assert($this->_conn !== null);
return $this->_conn;
}
*
* @throws Exception
*/
public function prepare(string $sql): Statement
{
$connection = $this->getWrappedConnection();
try {
$statement = $connection->prepare($sql);
} catch (Driver\Exception $e) {
throw $this->convertExceptionDuringQuery($e, $sql);
);
//$cnn = \Doctrine\DBAL\DriverManager::getConnection($connectionParams, $config);
// $this->log->logs("Inicio ejecucion sql0");
$this->cnn = \Doctrine\DBAL\DriverManager::getConnection($connectionParams, $config);
//$sql = "SELECT * FROM articles";
$stmt = $this->cnn->prepare($sql);
/* switch ($con)
{
case 6:
case 5:
$resultSet = $stmt->executeQuery();
case 24:
case 25:
return $this->consulta_socket($con,$sql);
break;
default:
return $this->query_normal($con,$sql);
break;
}
}
}
$name_device = (!empty($params[0]->name_device)) ? $params[0]->name_device : null;
$operador = (!empty($params[0]->operador)) ? $params[0]->operador : null;
$version_app = (!empty($params[0]->version_app)) ? $params[0]->version_app : null;
$sql_man = "SELECT version,estado_modulos FROM sem_versiones sv2 WHERE id = (SELECT max(id) FROM sem_versiones sv WHERE estado = 0)";
$res_man = $this->cnn->query('0', $sql_man);
if (count($res_man) <= 0)
{
$respuesta["datos"] = "No se encontro ninguna version de SEM";
return $response->setContent(json_encode($respuesta));
}
$this->dispatcher->dispatch($event, KernelEvents::CONTROLLER_ARGUMENTS);
$controller = $event->getController();
$arguments = $event->getArguments();
// call controller
$response = $controller(...$arguments);
// view
if (!$response instanceof Response) {
$event = new ViewEvent($this, $request, $type, $response, $event);
$this->dispatcher->dispatch($event, KernelEvents::VIEW);
{
$request->headers->set('X-Php-Ob-Level', (string) ob_get_level());
$this->requestStack->push($request);
try {
return $this->handleRaw($request, $type);
} catch (\Throwable $e) {
if ($e instanceof \Error && !$this->handleAllThrowables) {
throw $e;
}
$this->boot();
++$this->requestStackSize;
$this->resetServices = true;
try {
return $this->getHttpKernel()->handle($request, $type, $catch);
} finally {
--$this->requestStackSize;
}
}
$this->request = $request;
}
public function run(): int
{
$response = $this->kernel->handle($this->request);
$response->send();
if ($this->kernel instanceof TerminableInterface) {
$this->kernel->terminate($this->request, $response);
}
$app = $app(...$args);
exit(
$runtime
->getRunner($app)
->run()
);
$method = $_SERVER['REQUEST_METHOD'];
if($method == "OPTIONS") {
die();
}
require_once dirname(__DIR__).'/vendor/autoload_runtime.php';
return function (array $context) {
return new Kernel($context['APP_ENV'], (bool) $context['APP_DEBUG']);
};
No log messages
[3/3]
ConnectionException
|
---|
Doctrine\DBAL\Exception\ConnectionException: An exception occurred in the driver: SQLSTATE[08006] [7] connection to server at "10.231.0.132", 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:551) at App\Services\Conexion->query_normal() (src/Services/Conexion.php:525) at App\Services\Conexion->query() (src/Controller/PtatController.php:1773) 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 "10.231.0.132", 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:551) at App\Services\Conexion->query_normal() (src/Services/Conexion.php:525) at App\Services\Conexion->query() (src/Controller/PtatController.php:1773) 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 "10.231.0.132", 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:551) at App\Services\Conexion->query_normal() (src/Services/Conexion.php:525) at App\Services\Conexion->query() (src/Controller/PtatController.php:1773) 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) |