http://opendata.kedirikab.go.id/dataset/request?p=dataset%2Frequest

Method
GET
HTTP Status
500
IP
172.16.25.100
Profiled on
Token
4b743a

ErrorController

Request

GET Parameters

Key Value
p 
"dataset/request"

POST Parameters

No POST parameters

Uploaded Files

No files were uploaded

Request Attributes

Key Value
_controller 
"error_controller"
_stopwatch_token 
"ea7c0c"
exception 
Doctrine\DBAL\Exception\ConnectionException {#1416
  -driverException: Doctrine\DBAL\Driver\PDO\Exception {#1421 …}
  #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 {#1421 …}
  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/symfony/doctrine-bridge/Form/ChoiceList/ORMQueryBuilderLoader.php:49 {
      Symfony\Bridge\Doctrine\Form\ChoiceList\ORMQueryBuilderLoader->getEntities() …
      › {
      ›     return $this->queryBuilder->getQuery()->execute();
      › }
    }
    /var/www/html/open_data/vendor/symfony/doctrine-bridge/Form/ChoiceList/DoctrineChoiceLoader.php:58 {
      Symfony\Bridge\Doctrine\Form\ChoiceList\DoctrineChoiceLoader->loadChoices(): iterable …
      › return $this->objectLoader
      ›     ? $this->objectLoader->getEntities()
      ›     : $this->manager->getRepository($this->class)->findAll();
    }
    /var/www/html/open_data/vendor/symfony/form/ChoiceList/Loader/AbstractChoiceLoader.php:36 {
      Symfony\Component\Form\ChoiceList\Loader\AbstractChoiceLoader->loadChoiceList(callable $value = null): ChoiceListInterface …
      › {
      ›     return new ArrayChoiceList($this->choices ?? $this->choices = $this->loadChoices(), $value);
      › }
    }
    /var/www/html/open_data/vendor/symfony/form/ChoiceList/LazyChoiceList.php:61 {
      Symfony\Component\Form\ChoiceList\LazyChoiceList->getChoices() …
      › {
      ›     return $this->loader->loadChoiceList($this->value)->getChoices();
      › }
    }
    /var/www/html/open_data/vendor/symfony/form/ChoiceList/Factory/DefaultChoiceListFactory.php:81 {
      Symfony\Component\Form\ChoiceList\Factory\DefaultChoiceListFactory->createView(ChoiceListInterface $list, $preferredChoices = null, $label = null, callable $index = null, callable $groupBy = null, $attr = null) …
      › $otherViews = [];
      › $choices = $list->getChoices();
      › $keys = $list->getOriginalKeys();
    }
    /var/www/html/open_data/vendor/symfony/form/ChoiceList/Factory/PropertyAccessDecorator.php:230 {
      Symfony\Component\Form\ChoiceList\Factory\PropertyAccessDecorator->createView(ChoiceListInterface $list, $preferredChoices = null, $label = null, $index = null, $groupBy = null, $attr = null) …
      › return $this->decoratedFactory->createView(
      ›     $list,
      ›     $preferredChoices,
    }
    /var/www/html/open_data/vendor/symfony/form/ChoiceList/Factory/CachingFactoryDecorator.php:235 {
      Symfony\Component\Form\ChoiceList\Factory\CachingFactoryDecorator->createView(ChoiceListInterface $list, $preferredChoices = null, $label = null, $index = null, $groupBy = null, $attr = null) …
      › $this->views[$hash] = $this->decoratedFactory->createView(
      ›     $list,
      ›     $preferredChoices,
    }
    /var/www/html/open_data/vendor/symfony/form/Extension/Core/Type/ChoiceType.php:496 {
      Symfony\Component\Form\Extension\Core\Type\ChoiceType->createChoiceListView(ChoiceListInterface $choiceList, array $options) …
      ›     $options['choice_attr'],
      ›     $options['choice_translation_parameters']
      › );
    }
    /var/www/html/open_data/vendor/symfony/form/Extension/Core/Type/ChoiceType.php:253 {
      Symfony\Component\Form\Extension\Core\Type\ChoiceType->buildView(FormView $view, FormInterface $form, array $options) …
      › ? $form->getConfig()->getAttribute('choice_list_view')
      › : $this->createChoiceListView($choiceList, $options);
      › 
    }
    /var/www/html/open_data/vendor/symfony/form/ResolvedFormType.php:147 {
      Symfony\Component\Form\ResolvedFormType->buildView(FormView $view, FormInterface $form, array $options) …
      › 
      › $this->innerType->buildView($view, $form, $options);
      › 
    }
    /var/www/html/open_data/vendor/symfony/form/Extension/DataCollector/Proxy/ResolvedTypeDataCollectorProxy.php:103 {
      Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildView(FormView $view, FormInterface $form, array $options) …
      › {
      ›     $this->proxiedType->buildView($view, $form, $options);
      › }
    }
    /var/www/html/open_data/vendor/symfony/form/ResolvedFormType.php:144 {
      Symfony\Component\Form\ResolvedFormType->buildView(FormView $view, FormInterface $form, array $options) …
      › if (null !== $this->parent) {
      ›     $this->parent->buildView($view, $form, $options);
      › }
    }
    /var/www/html/open_data/vendor/symfony/form/Extension/DataCollector/Proxy/ResolvedTypeDataCollectorProxy.php:103 {
      Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildView(FormView $view, FormInterface $form, array $options) …
      › {
      ›     $this->proxiedType->buildView($view, $form, $options);
      › }
    }
    /var/www/html/open_data/vendor/symfony/form/Form.php:1062 {
      Symfony\Component\Form\Form->createView(FormView $parent = null) …
      › 
      › $type->buildView($view, $this, $options);
      › 
    }
    /var/www/html/open_data/vendor/symfony/form/Form.php:1065 {
      Symfony\Component\Form\Form->createView(FormView $parent = null) …
      › foreach ($this->children as $name => $child) {
      ›     $view->children[$name] = $child->createView($view);
      › }
    }
    /var/www/html/open_data/src/Controller/Frontend/DatasetController.php:284 {
      App\Controller\Frontend\DatasetController->form(?string $id = null, Request $request, TPermohonanRepository $tPermohonanRepository) …
      › return $this->render('/frontend/dataset/form.html.twig', [
      ›     'form' => $form->createView(),
      ›     'header_kategori' => $this->getHeaderKategori(),
    }
    /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.204 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, 22 Dec 2024 08:22:18 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 
"4b743a"

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.204 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"
PHP_SELF 
"/index.php"
QUERY_STRING 
"p=dataset/request"
REDIRECT_QUERY_STRING 
"p=dataset/request"
REDIRECT_STATUS 
"200"
REDIRECT_URL 
"/dataset/request"
REMOTE_ADDR 
"172.16.25.100"
REMOTE_PORT 
"59164"
REQUEST_METHOD 
"GET"
REQUEST_SCHEME 
"http"
REQUEST_TIME 
1734855738
REQUEST_TIME_FLOAT 
1734855738.3595
REQUEST_URI 
"/dataset/request"
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 = d58313)

Key Value
_controller 
"App\Controller\Frontend\DatasetController::form"
_firewall_context 
"security.firewall.map.context.main"
_remove_csp_headers 
true
_route 
"dataset_form"
_route_params 
[
  "id" => null
]
_security_firewall_run 
"_security_main"
_stopwatch_token 
"141111"
id 
null