Symfony Profiler

"dataset/4033/dataset_table"

[
  [
    "data" => "0"
    "name" => ""
    "searchable" => "true"
    "orderable" => "false"
    "search" => [
      "value" => ""
      "regex" => "false"
    ]
  ]
  [
    "data" => "1"
    "name" => ""
    "searchable" => "true"
    "orderable" => "false"
    "search" => [
      "value" => ""
      "regex" => "false"
    ]
  ]
  [
    "data" => "2"
    "name" => ""
    "searchable" => "true"
    "orderable" => "false"
    "search" => [
      "value" => ""
      "regex" => "false"
    ]
  ]
  [
    "data" => "3"
    "name" => ""
    "searchable" => "true"
    "orderable" => "false"
    "search" => [
      "value" => ""
      "regex" => "false"
    ]
  ]
  [
    "data" => "4"
    "name" => ""
    "searchable" => "true"
    "orderable" => "false"
    "search" => [
      "value" => ""
      "regex" => "false"
    ]
  ]
]

"1"

"10"

""

""

""

""

[
  "value" => ""
  "regex" => "false"
]

"0"

""

"error_controller"

"99ce91"

Doctrine\DBAL\Exception\ConnectionException {#946
  -driverException: Doctrine\DBAL\Driver\PDO\Exception {#948 …}
  #message: """
    An exception occurred in driver: SQLSTATE[08006] [7] connection to server at "127.0.0.1", port 5432 failed: Connection refused\n
    \tIs the server running on that host and accepting TCP/IP connections?
    """
  #code: 0
  #file: "/var/www/html/open_data/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractPostgreSQLDriver.php"
  #line: 88
  -previous: Doctrine\DBAL\Driver\PDO\Exception {#948 …}
  trace: {
    /var/www/html/open_data/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractPostgreSQLDriver.php:88 {
      Doctrine\DBAL\Driver\AbstractPostgreSQLDriver->convertException($message, DriverException $exception) …
      › case '08006':
      ›     return new Exception\ConnectionException($message, $exception);
      › 
    }
    /var/www/html/open_data/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php:182 {
      Doctrine\DBAL\DBALException::wrapException(Driver $driver, Throwable $driverEx, string $msg) …
      › if ($driver instanceof ExceptionConverterDriver && $driverEx instanceof DeprecatedDriverException) {
      ›     return $driver->convertException($msg, $driverEx);
      › }
    }
    /var/www/html/open_data/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php:169 {
      Doctrine\DBAL\DBALException::driverException(Driver $driver, Throwable $driverEx) …
      › {
      ›     return self::wrapException($driver, $driverEx, 'An exception occurred in driver: ' . $driverEx->getMessage());
      › }
    }
    /var/www/html/open_data/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOPgSql/Driver.php:52 {
      Doctrine\DBAL\Driver\PDOPgSql\Driver->connect(array $params, $username = null, $password = null, array $driverOptions = []) …
      › } catch (PDOException $e) {
      ›     throw Exception::driverException($this, $e);
      › }
    }
    /var/www/html/open_data/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:412 {
      Doctrine\DBAL\Connection->connect() …
      › 
      › $this->_conn = $this->_driver->connect($this->params, $user, $password, $driverOptions);
      › 
    }
    /var/www/html/open_data/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:1952 {
      Doctrine\DBAL\Connection->getWrappedConnection() …
      › {
      ›     $this->connect();
      › 
    }
    /var/www/html/open_data/vendor/doctrine/dbal/lib/Doctrine/DBAL/Statement.php:84 {
      Doctrine\DBAL\Statement->__construct($sql, Connection $conn) …
      › $this->sql      = $sql;
      › $this->stmt     = $conn->getWrappedConnection()->prepare($sql);
      › $this->conn     = $conn;
    }
    /var/www/html/open_data/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:1258 {
      Doctrine\DBAL\Connection->prepare($sql) …
      › try {
      ›     $stmt = new Statement($sql, $this);
      › } catch (Throwable $e) {
    }
    /var/www/html/open_data/src/Controller/Frontend/DatasetController.php:565 {
      App\Controller\Frontend\DatasetController->getDataTableFront($managerRegistry, $id, $limit, $page, $get, $state = null, $row = null) …
      › $tbl_func = "CREATE EXTENSION IF NOT EXISTS tablefunc; ";
      › $stmt = $connection->prepare($tbl_func);
      › $stmt->execute();
    }
    /var/www/html/open_data/src/Controller/Frontend/DatasetController.php:298 {
      App\Controller\Frontend\DatasetController->dataset_table(?string $id, Request $request, ManagerRegistry $managerRegistry) …
      › 
      › $dataset = $this->getDataTableFront($managerRegistry, $id, 10, $page, $_POST);
      › $jumlah = count($this->getDataTableFront($managerRegistry, $id, null, null, $_POST));
    }
    /var/www/html/open_data/vendor/symfony/http-kernel/HttpKernel.php:163 {
      Symfony\Component\HttpKernel\HttpKernel->handleRaw(Request $request, int $type = self::MAIN_REQUEST): Response …
      › // call controller
      › $response = $controller(...$arguments);
      › 
    }
    /var/www/html/open_data/vendor/symfony/http-kernel/HttpKernel.php:75 {
      Symfony\Component\HttpKernel\HttpKernel->handle(Request $request, int $type = HttpKernelInterface::MAIN_REQUEST, bool $catch = true) …
      › try {
      ›     return $this->handleRaw($request, $type);
      › } catch (\Exception $e) {
    }
    /var/www/html/open_data/vendor/symfony/http-kernel/Kernel.php:202 {
      Symfony\Component\HttpKernel\Kernel->handle(Request $request, int $type = HttpKernelInterface::MAIN_REQUEST, bool $catch = true) …
      › try {
      ›     return $this->getHttpKernel()->handle($request, $type, $catch);
      › } finally {
    }
    /var/www/html/open_data/public/index.php:20 {
      › $request = Request::createFromGlobals();
      › $response = $kernel->handle($request);
      › $response->send();
    }
  }
}

null

"application/json, text/javascript, */*; q=0.01"

"gzip, deflate, br"

"en-US"

""

"close"

"1208"

"application/x-www-form-urlencoded; charset=UTF-8"

"opendata.kedirikab.go.id"

"https://opendata.kedirikab.go.id"

"https://opendata.kedirikab.go.id/dataset/4033/detail"

"empty"

"cors"

"same-origin"

"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; bingbot/2.0; +http://www.bing.com/bingbot.htm) Chrome/112.0.0.0 Safari/537.36"

"192.168.60.9"

"https"

"https"

"1"

"192.168.60.9"

"XMLHttpRequest"

"no-cache, private"

"text/html; charset=UTF-8"

"Fri, 29 Nov 2024 22:47:49 GMT"

"An%20exception%20occurred%20in%20driver%3A%20SQLSTATE%5B08006%5D%20%5B7%5D%20connection%20to%20server%20at%20%22127.0.0.1%22%2C%20port%205432%20failed%3A%20Connection%20refused%0A%09Is%20the%20server%20running%20on%20that%20host%20and%20accepting%20TCP%2FIP%20connections%3F"

"%2Fvar%2Fwww%2Fhtml%2Fopen_data%2Fvendor%2Fdoctrine%2Fdbal%2Flib%2FDoctrine%2FDBAL%2FDriver%2FAbstractPostgreSQLDriver.php:88"

"353cfb"

"4a81432adf56aeb6aadfffa65ab70ab1"

"http://172.16.16.68/api_/opendata.php"

"Jl. Sekartaji No.2, Sumber, Doko, Kec. Ngasem, Kabupaten Kediri, Jawa Timur"

"Telp. (0354) 682152"

""

"Kabupaten Kediri"

"Kabupaten Kediri"

"dev"

"assets/logo/logo_masbup.png"

"assets/logo/kota_kediri.png"

"Open Data Kediri"

"302717838b52f3d1699a25e8e3ef6a9d"

"#b20238;"

"#e8d21d;"

"#039fbe;"

"#cf1578;"

"postgresql://postgres:opendata2022!@127.0.0.1:5432/open_data_kediri?serverVersion=13&charset=utf8"

"assets/logo/logo_masbup_merah.png"

"1"

"1208"

"application/x-www-form-urlencoded; charset=UTF-8"

"/var/www/html/open_data/public/"

""

"/var/www/html/open_data/public/"

"CGI/1.1"

"application/json, text/javascript, */*; q=0.01"

"gzip, deflate, br"

"en-US"

""

"close"

"opendata.kedirikab.go.id"

"https://opendata.kedirikab.go.id"

"https://opendata.kedirikab.go.id/dataset/4033/detail"

"empty"

"cors"

"same-origin"

"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; bingbot/2.0; +http://www.bing.com/bingbot.htm) Chrome/112.0.0.0 Safari/537.36"

"192.168.60.9"

"https"

"https"

"192.168.60.9"

"XMLHttpRequest"

"/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/snap/bin"

"/index.php"

"p=dataset/4033/dataset_table"

"p=dataset/4033/dataset_table"

"200"

"/dataset/4033/dataset_table"

"172.16.25.100"

"48818"

"GET"

"http"

1732920469

1732920469.2489

"/dataset/4033/dataset_table"

"/var/www/html/open_data/public/index.php"

"/index.php"

"172.16.16.52"

"[no address given]"

"opendata.kedirikab.go.id"

"80"

"HTTP/1.1"

""

"Apache"

"APP_ENV,APP_SECRET,DATABASE_URL,API_URL,API_TOKEN,APP_NAME,OPEN_DATA_ICON,APP_ICON,APP_ICON_LOGO,APP_CLIENT_NAME,APP_CLIENT_SHORTNAME,APP_CLIENT_ADDRESS,APP_CLIENT_CONTACT,APP_CLIENT_EMAIL,COLOR_PRIMARY,COLOR_WARNING,COLOR_INFO,COLOR_DANGER"

"App\Controller\Frontend\DatasetController::dataset_table"

"security.firewall.map.context.main"

true

"dataset_dataset_table"

[
  "id" => "4033"
]

"_security_main"

"a77272"

"4033"