http://opendata.kedirikab.go.id/dataset?judul=produksi%20gula%20merah%20tebu%20&p=dataset

DatasetController :: index

Request

GET Parameters

Key Value
judul
"produksi gula merah tebu "
p
"dataset"

POST Parameters

No POST parameters

Uploaded Files

No files were uploaded

Request Attributes

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
"2d1c13"

Request Headers

Header Value
accept
"*/*"
accept-encoding
"gzip, deflate, br"
authorization
""
connection
"close"
from
"bingbot(at)microsoft.com"
host
"opendata.kedirikab.go.id"
user-agent
"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; bingbot/2.0; +http://www.bing.com/bingbot.htm) Chrome/116.0.1938.76 Safari/537.36"
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
"Sat, 30 Nov 2024 01:39:03 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
"7e45c3"
x-debug-token-link
"http://opendata.kedirikab.go.id/_profiler/46cea8"
x-previous-debug-token
"46cea8"
x-robots-tag
"noindex"

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
"*/*"
HTTP_ACCEPT_ENCODING
"gzip, deflate, br"
HTTP_AUTHORIZATION
""
HTTP_CONNECTION
"close"
HTTP_FROM
"bingbot(at)microsoft.com"
HTTP_HOST
"opendata.kedirikab.go.id"
HTTP_USER_AGENT
"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; bingbot/2.0; +http://www.bing.com/bingbot.htm) Chrome/116.0.1938.76 Safari/537.36"
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"
PHP_SELF
"/index.php"
QUERY_STRING
"p=dataset&judul=produksi%20gula%20merah%20tebu%20&p=dataset"
REDIRECT_QUERY_STRING
"p=dataset&judul=produksi%20gula%20merah%20tebu%20&p=dataset"
REDIRECT_STATUS
"200"
REDIRECT_URL
"/dataset"
REMOTE_ADDR
"172.16.25.100"
REMOTE_PORT
"34450"
REQUEST_METHOD
"GET"
REQUEST_SCHEME
"http"
REQUEST_TIME
1732930742
REQUEST_TIME_FLOAT
1732930742.8591
REQUEST_URI
"/dataset?judul=produksi%20gula%20merah%20tebu%20&p=dataset"
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"

Sub Requests 1

ErrorController (token = 46cea8)

Key Value
_controller
"error_controller"
_stopwatch_token
"02f205"
exception
Doctrine\DBAL\Exception\ConnectionException {#1348
  -driverException: Doctrine\DBAL\Driver\PDO\Exception {#1344 …}
  #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 {#1344 …}
  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:980 {
      Doctrine\DBAL\Connection->quote($value, $type = ParameterType::STRING) …
      › {    $connection = $this->getWrappedConnection();}
    /var/www/html/open_data/vendor/doctrine/orm/lib/Doctrine/ORM/Query/SqlWalker.php:2411 {
      Doctrine\ORM\Query\SqlWalker->walkLiteral($literal) …
      › case AST\Literal::STRING:    return $this->conn->quote($literal->value);}
    /var/www/html/open_data/vendor/doctrine/orm/lib/Doctrine/ORM/Query/AST/Literal.php:38 {
      Doctrine\ORM\Query\AST\Literal->dispatch($walker) …
      › {    return $walker->walkLiteral($this);}
    }
    /var/www/html/open_data/vendor/doctrine/orm/lib/Doctrine/ORM/Query/SqlWalker.php:2659 {
      Doctrine\ORM\Query\SqlWalker->walkArithmeticPrimary($primary) …
      › if ($primary instanceof AST\Node) {    return $primary->dispatch($this);}
    }
    /var/www/html/open_data/vendor/doctrine/orm/lib/Doctrine/ORM/Query/SqlWalker.php:2635 {
      Doctrine\ORM\Query\SqlWalker->walkArithmeticFactor($factor) …
      › if (! ($factor instanceof AST\ArithmeticFactor)) {    return $this->walkArithmeticPrimary($factor);}
    }
    /var/www/html/open_data/vendor/doctrine/orm/lib/Doctrine/ORM/Query/SqlWalker.php:2609 {
      Doctrine\ORM\Query\SqlWalker->walkArithmeticTerm($term) …
      › if (! ($term instanceof AST\ArithmeticTerm)) {    return $this->walkArithmeticFactor($term);}
    }
    /var/www/html/open_data/vendor/doctrine/orm/lib/Doctrine/ORM/Query/SqlWalker.php:2583 {
      Doctrine\ORM\Query\SqlWalker->walkSimpleArithmeticExpression($simpleArithmeticExpr) …
      › if (! ($simpleArithmeticExpr instanceof AST\SimpleArithmeticExpression)) {    return $this->walkArithmeticTerm($simpleArithmeticExpr);}
    }
    /var/www/html/open_data/vendor/doctrine/orm/lib/Doctrine/ORM/Query/AST/Functions/LowerFunction.php:29 {
      Doctrine\ORM\Query\AST\Functions\LowerFunction->getSql(SqlWalker $sqlWalker) …
      ›     'LOWER(%s)',    $sqlWalker->walkSimpleArithmeticExpression($this->stringPrimary));
    }
    /var/www/html/open_data/vendor/doctrine/orm/lib/Doctrine/ORM/Query/SqlWalker.php:1192 {
      Doctrine\ORM\Query\SqlWalker->walkFunction($function) …
      › {    return $function->getSql($this);}
    }
    /var/www/html/open_data/vendor/doctrine/orm/lib/Doctrine/ORM/Query/SqlWalker.php:2474 {
      Doctrine\ORM\Query\SqlWalker->walkLikeExpression($likeExpr) …
      › } elseif ($likeExpr->stringPattern instanceof AST\Functions\FunctionNode) {    $sql .= $this->walkFunction($likeExpr->stringPattern);} elseif ($likeExpr->stringPattern instanceof AST\PathExpression) {
    }
    /var/www/html/open_data/vendor/doctrine/orm/lib/Doctrine/ORM/Query/AST/LikeExpression.php:46 {
      Doctrine\ORM\Query\AST\LikeExpression->dispatch($sqlWalker) …
      › {    return $sqlWalker->walkLikeExpression($this);}
    }
    /var/www/html/open_data/vendor/doctrine/orm/lib/Doctrine/ORM/Query/SqlWalker.php:2118 {
      Doctrine\ORM\Query\SqlWalker->walkConditionalPrimary($primary) …
      › if ($primary->isSimpleConditionalExpression()) {    return $primary->simpleConditionalExpression->dispatch($this);}
    }
    /var/www/html/open_data/vendor/doctrine/orm/lib/Doctrine/ORM/Query/SqlWalker.php:2102 {
      Doctrine\ORM\Query\SqlWalker->walkConditionalFactor($factor) …
      › return ! ($factor instanceof AST\ConditionalFactor)    ? $this->walkConditionalPrimary($factor)    : ($factor->not ? 'NOT ' : '') . $this->walkConditionalPrimary($factor->conditionalPrimary);
    }
    Doctrine\ORM\Query\SqlWalker->walkConditionalFactor() {}
    /var/www/html/open_data/vendor/doctrine/orm/lib/Doctrine/ORM/Query/SqlWalker.php:2085 {
      Doctrine\ORM\Query\SqlWalker->walkConditionalTerm($condTerm) …
      › 
      ›     return implode(' AND ', array_map([$this, 'walkConditionalFactor'], $condTerm->conditionalFactors));}
    }
    /var/www/html/open_data/vendor/doctrine/orm/lib/Doctrine/ORM/Query/SqlWalker.php:2062 {
      Doctrine\ORM\Query\SqlWalker->walkConditionalExpression($condExpr) …
      › if (! ($condExpr instanceof AST\ConditionalExpression)) {    return $this->walkConditionalTerm($condExpr);}
    }
    /var/www/html/open_data/vendor/doctrine/orm/lib/Doctrine/ORM/Query/SqlWalker.php:2013 {
      Doctrine\ORM\Query\SqlWalker->walkWhereClause($whereClause) …
      › {    $condSql  = $whereClause !== null ? $this->walkConditionalExpression($whereClause->conditionalExpression) : '';    $discrSql = $this->generateDiscriminatorColumnConditionSQL($this->rootAliases);
    }
    /var/www/html/open_data/vendor/doctrine/orm/lib/Doctrine/ORM/Query/SqlWalker.php:554 {
      Doctrine\ORM\Query\SqlWalker->walkSelectStatement(SelectStatement $AST) …
      › . $this->walkFromClause($AST->fromClause). $this->walkWhereClause($AST->whereClause);}
    /var/www/html/open_data/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Exec/SingleSelectExecutor.php:21 {
      Doctrine\ORM\Query\Exec\SingleSelectExecutor->__construct(SelectStatement $AST, SqlWalker $sqlWalker) …
      › {    $this->_sqlStatements = $sqlWalker->walkSelectStatement($AST);}
    }
    /var/www/html/open_data/vendor/doctrine/orm/lib/Doctrine/ORM/Query/SqlWalker.php:302 {
      Doctrine\ORM\Query\SqlWalker->getExecutor($AST) …
      ›     default:        return new Exec\SingleSelectExecutor($AST, $this);}
    }
    /var/www/html/open_data/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php:397 {
      Doctrine\ORM\Query\Parser->parse() …
      › // Assign an SQL executor to the parser result$this->parserResult->setSqlExecutor($outputWalker->getExecutor($AST));}
    /var/www/html/open_data/vendor/doctrine/orm/lib/Doctrine/ORM/Tools/Pagination/Paginator.php:256 {
      Doctrine\ORM\Tools\Pagination\Paginator->unbindUnusedQueryParams(Query $query): void …
      › $parser            = new Parser($query);$parameterMappings = $parser->parse()->getParameterMappings();/** @var Collection|Parameter[] $parameters */
    }
    /var/www/html/open_data/vendor/doctrine/orm/lib/Doctrine/ORM/Tools/Pagination/Paginator.php:245 {
      Doctrine\ORM\Tools\Pagination\Paginator->getCountQuery(): Query …
      ›     $this->appendTreeWalker($countQuery, CountWalker::class);    $this->unbindUnusedQueryParams($countQuery);}
    }
    /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