http://opendata.kedirikab.go.id/index.php/dataset?page=101

Method
GET
HTTP Status
500
IP
172.16.25.100
Profiled on
Token
44482b

ErrorController

Request

GET Parameters

Key Value
page 
"101"

POST Parameters

No POST parameters

Uploaded Files

No files were uploaded

Request Attributes

Key Value
_controller 
"error_controller"
_stopwatch_token 
"a63c73"
exception 
Doctrine\DBAL\Exception\ConnectionException {#1323
  -driverException: Doctrine\DBAL\Driver\PDO\Exception {#1340 …}
  #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 {#1340 …}
  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/Connection.php:1290 {
      Doctrine\DBAL\Connection->executeQuery($sql, array $params = [], $types = [], QueryCacheProfile $qcp = null) …
      › 
      › $connection = $this->getWrappedConnection();
      › 
    }
    /var/www/html/open_data/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Exec/SingleSelectExecutor.php:31 {
      Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute(Connection $conn, array $params, array $types) …
      › {
      ›     return $conn->executeQuery($this->_sqlStatements, $params, $types, $this->queryCacheProfile);
      › }
    }
    /var/www/html/open_data/vendor/doctrine/orm/lib/Doctrine/ORM/Query.php:325 {
      Doctrine\ORM\Query->_doExecute() …
      › 
      ›     return $executor->execute($this->_em->getConnection(), $sqlParams, $types);
      › }
    }
    /var/www/html/open_data/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php:1212 {
      Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache($parameters = null, $hydrationMode = null) …
      › 
      › $stmt = $this->_doExecute();
      › 
    }
    /var/www/html/open_data/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php:1166 {
      Doctrine\ORM\AbstractQuery->execute($parameters = null, $hydrationMode = null) …
      › 
      ›     return $this->executeIgnoreQueryCache($parameters, $hydrationMode);
      › }
    }
    /var/www/html/open_data/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php:937 {
      Doctrine\ORM\AbstractQuery->getScalarResult() …
      › {
      ›     return $this->execute(null, self::HYDRATE_SCALAR);
      › }
    }
    /var/www/html/open_data/vendor/doctrine/orm/lib/Doctrine/ORM/Tools/Pagination/Paginator.php:118 {
      Doctrine\ORM\Tools\Pagination\Paginator->count() …
      › try {
      ›     $this->count = (int) array_sum(array_map('current', $this->getCountQuery()->getScalarResult()));
      › } catch (NoResultException $e) {
    }
    Doctrine\ORM\Tools\Pagination\Paginator->count() {}
    /var/www/html/open_data/vendor/knplabs/knp-components/src/Knp/Component/Pager/Event/Subscriber/Paginate/Doctrine/ORM/QuerySubscriber.php:46 {
      Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\ORM\QuerySubscriber->items(ItemsEvent $event): void …
      › } else {
      ›     $event->count = count($paginator);
      › }
    }
    /var/www/html/open_data/vendor/symfony/event-dispatcher/Debug/WrappedListener.php:118 {
      Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke(object $event, string $eventName, EventDispatcherInterface $dispatcher): void …
      › try {
      ›     ($this->optimizedListener ?? $this->listener)($event, $eventName, $dispatcher);
      › } finally {
    }
    /var/www/html/open_data/vendor/symfony/event-dispatcher/EventDispatcher.php:230 {
      Symfony\Component\EventDispatcher\EventDispatcher->callListeners(iterable $listeners, string $eventName, object $event) …
      ›     }
      ›     $listener($event, $eventName, $this);
      › }
    }
    /var/www/html/open_data/vendor/symfony/event-dispatcher/EventDispatcher.php:59 {
      Symfony\Component\EventDispatcher\EventDispatcher->dispatch(object $event, string $eventName = null): object …
      › if ($listeners) {
      ›     $this->callListeners($listeners, $eventName, $event);
      › }
    }
    /var/www/html/open_data/vendor/symfony/event-dispatcher/Debug/TraceableEventDispatcher.php:154 {
      Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch(object $event, string $eventName = null): object …
      › try {
      ›     $this->dispatcher->dispatch($event, $eventName);
      › } finally {
    }
    /var/www/html/open_data/vendor/knplabs/knp-components/src/Knp/Component/Pager/Paginator.php:93 {
      Knp\Component\Pager\Paginator->paginate($target, int $page = 1, int $limit = null, array $options = []): PaginationInterface …
      › $itemsEvent->target = &$target;
      › $this->eventDispatcher->dispatch($itemsEvent, 'knp_pager.items');
      › if (!$itemsEvent->isPropagationStopped()) {
    }
    /var/www/html/open_data/var/cache/dev/ContainerF3J4NcO/PaginatorInterface_82dac15.php:30 {
      ContainerF3J4NcO\PaginatorInterface_82dac15->paginate($target, int $page = 1, int $limit = null, array $options = []): PaginationInterface …
      › 
      › if ($this->valueHolderd14db === $returnValue = $this->valueHolderd14db->paginate($target, $page, $limit, $options)) {
      ›     return $this;
    }
    /var/www/html/open_data/src/Controller/Frontend/DatasetController.php:79 {
      App\Controller\Frontend\DatasetController->index(SeoPageInterface $seoPage, Request $request, MKategoriRepository $mKategoriRepo, MKategoriDetailRepository $mKategoriDetailRepo, PaginatorInterface $paginatorInterface, TDivRepository $tDivRepo, MSektorRepository $mSektorRepo, MUrusanRepository $mUrusanRepo, MUrusanDetailRepository $mUrusanDetailRepository, TPublikasiRepository $tPublikasiRepository): Response …
      › 
      › $pagination = $paginatorInterface->paginate($queryBuilder, $request->query->getInt('page', 1), 10);
      › 
    }
    /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();
    }
  }
}
logger 
null

Request Headers

Header Value
accept 
"text/html,application/xhtml+xml,application/signed-exchange;v=b3,application/xml;q=0.9,*/*;q=0.8"
accept-encoding 
"gzip, deflate, br"
amp-cache-transform 
"google;v="1..8""
authorization 
""
connection 
"close"
from 
"googlebot(at)googlebot.com"
host 
"opendata.kedirikab.go.id"
user-agent 
"Mozilla/5.0 (Linux; Android 6.0.1; Nexus 5X Build/MMB29P) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/131.0.6778.69 Mobile Safari/537.36 (compatible; Googlebot/2.1; +http://www.google.com/bot.html)"
x-forwarded-for 
"192.168.60.9"
x-forwarded-proto 
"https"
x-forwarded-scheme 
"https"
x-php-ob-level 
"1"
x-real-ip 
"192.168.60.9"

Request Content

Request content not available (it was retrieved as a resource).

Response

Response Headers

Header Value
cache-control 
"no-cache, private"
content-type 
"text/html; charset=UTF-8"
date 
"Sun, 24 Nov 2024 11:42:09 GMT"
x-debug-exception 
"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"
x-debug-exception-file 
"%2Fvar%2Fwww%2Fhtml%2Fopen_data%2Fvendor%2Fdoctrine%2Fdbal%2Flib%2FDoctrine%2FDBAL%2FDriver%2FAbstractPostgreSQLDriver.php:88"
x-debug-token 
"44482b"

Cookies

Request Cookies

No request cookies

Response Cookies

No response cookies

Session

Session Metadata

No session metadata

Session Attributes

No session attributes

Session Usage

0 Usages
Stateless check enabled

Session not used.

Flashes

Flashes

No flash messages were created.

Server Parameters

Server Parameters

Defined in .env

Key Value
API_TOKEN 
"4a81432adf56aeb6aadfffa65ab70ab1"
API_URL 
"http://172.16.16.68/api_/opendata.php"
APP_CLIENT_ADDRESS 
"Jl. Sekartaji No.2, Sumber, Doko, Kec. Ngasem, Kabupaten Kediri, Jawa Timur"
APP_CLIENT_CONTACT 
"Telp. (0354) 682152"
APP_CLIENT_EMAIL 
""
APP_CLIENT_NAME 
"Kabupaten Kediri"
APP_CLIENT_SHORTNAME 
"Kabupaten Kediri"
APP_ENV 
"dev"
APP_ICON 
"assets/logo/logo_masbup.png"
APP_ICON_LOGO 
"assets/logo/kota_kediri.png"
APP_NAME 
"Open Data Kediri"
APP_SECRET 
"302717838b52f3d1699a25e8e3ef6a9d"
COLOR_DANGER 
"#b20238;"
COLOR_INFO 
"#e8d21d;"
COLOR_PRIMARY 
"#039fbe;"
COLOR_WARNING 
"#cf1578;"
DATABASE_URL 
"postgresql://postgres:opendata2022!@127.0.0.1:5432/open_data_kediri?serverVersion=13&charset=utf8"
OPEN_DATA_ICON 
"assets/logo/logo_masbup_merah.png"

Defined as regular env variables

Key Value
APP_DEBUG 
"1"
CONTEXT_DOCUMENT_ROOT 
"/var/www/html/open_data/public/"
CONTEXT_PREFIX 
""
DOCUMENT_ROOT 
"/var/www/html/open_data/public/"
GATEWAY_INTERFACE 
"CGI/1.1"
HTTP_ACCEPT 
"text/html,application/xhtml+xml,application/signed-exchange;v=b3,application/xml;q=0.9,*/*;q=0.8"
HTTP_ACCEPT_ENCODING 
"gzip, deflate, br"
HTTP_AMP_CACHE_TRANSFORM 
"google;v="1..8""
HTTP_AUTHORIZATION 
""
HTTP_CONNECTION 
"close"
HTTP_FROM 
"googlebot(at)googlebot.com"
HTTP_HOST 
"opendata.kedirikab.go.id"
HTTP_USER_AGENT 
"Mozilla/5.0 (Linux; Android 6.0.1; Nexus 5X Build/MMB29P) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/131.0.6778.69 Mobile Safari/537.36 (compatible; Googlebot/2.1; +http://www.google.com/bot.html)"
HTTP_X_FORWARDED_FOR 
"192.168.60.9"
HTTP_X_FORWARDED_PROTO 
"https"
HTTP_X_FORWARDED_SCHEME 
"https"
HTTP_X_REAL_IP 
"192.168.60.9"
PATH 
"/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/snap/bin"
PATH_INFO 
"/dataset"
PATH_TRANSLATED 
"redirect:/index.php"
PHP_SELF 
"/index.php/dataset"
QUERY_STRING 
"page=101"
REMOTE_ADDR 
"172.16.25.100"
REMOTE_PORT 
"36804"
REQUEST_METHOD 
"GET"
REQUEST_SCHEME 
"http"
REQUEST_TIME 
1732448529
REQUEST_TIME_FLOAT 
1732448529.1768
REQUEST_URI 
"/index.php/dataset?page=101"
SCRIPT_FILENAME 
"/var/www/html/open_data/public/index.php"
SCRIPT_NAME 
"/index.php"
SERVER_ADDR 
"172.16.16.52"
SERVER_ADMIN 
"[no address given]"
SERVER_NAME 
"opendata.kedirikab.go.id"
SERVER_PORT 
"80"
SERVER_PROTOCOL 
"HTTP/1.1"
SERVER_SIGNATURE 
""
SERVER_SOFTWARE 
"Apache"
SYMFONY_DOTENV_VARS 
"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"

Parent Request

Return to parent request (token = fe6e9c)

Key Value
_controller 
"App\Controller\Frontend\DatasetController::index"
_firewall_context 
"security.firewall.map.context.main"
_remove_csp_headers 
true
_route 
"dataset"
_route_params 
[]
_security_firewall_run 
"_security_main"
_stopwatch_token 
"df1dfb"