Web based family history software

Solved [Solved] Unable to install due to IPv6 address with network identifier

  • Fropper
  • Topic Author
  • Offline
  • New Member
  • New Member
More
3 years 2 months ago - 3 years 2 months ago #1 by Fropper
Hi, i just tried to install webtrees for the first time, but could not succeed. After entering my administrator information during the install process I am getting the following error:
Code:
PDOException: SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'ip_address' cannot be null in C:\Server\http\web\webtrees\vendor\doctrine\dbal\lib\Doctrine\DBAL\Driver\PDOStatement.php:117 Stack trace: #0 C:\Server\http\web\webtrees\vendor\doctrine\dbal\lib\Doctrine\DBAL\Driver\PDOStatement.php(117): PDOStatement->execute() #1 C:\Server\http\web\webtrees\vendor\illuminate\database\Connection.php(458): Doctrine\DBAL\Driver\PDOStatement->execute() #2 C:\Server\http\web\webtrees\vendor\illuminate\database\Connection.php(657): Illuminate\Database\Connection->Illuminate\Database\{closure}() #3 C:\Server\http\web\webtrees\vendor\illuminate\database\Connection.php(624): Illuminate\Database\Connection->runQueryCallback() #4 C:\Server\http\web\webtrees\vendor\illuminate\database\Connection.php(459): Illuminate\Database\Connection->run() #5 C:\Server\http\web\webtrees\vendor\illuminate\database\Connection.php(411): Illuminate\Database\Connection->statement() #6 C:\Server\http\web\webtrees\vendor\illuminate\database\Query\Builder.php(2646): Illuminate\Database\Connection->insert() #7 C:\Server\http\web\webtrees\app\SessionDatabaseHandler.php(95): Illuminate\Database\Query\Builder->insert() #8 [internal function]: Fisharebest\webtrees\SessionDatabaseHandler->write() #9 C:\Server\http\web\webtrees\app\Session.php(104): session_write_close() #10 C:\Server\http\web\webtrees\app\Http\Middleware\UseSession.php(73): Fisharebest\webtrees\Session::save() #11 C:\Server\http\web\webtrees\vendor\oscarotero\middleland\src\Dispatcher.php(136): Fisharebest\webtrees\Http\Middleware\UseSession->process() #12 C:\Server\http\web\webtrees\app\Http\Middleware\UpdateDatabaseSchema.php(58): Middleland\Dispatcher->handle() #13 C:\Server\http\web\webtrees\vendor\oscarotero\middleland\src\Dispatcher.php(136): Fisharebest\webtrees\Http\Middleware\UpdateDatabaseSchema->process() #14 C:\Server\http\web\webtrees\app\Http\Middleware\UseDebugbar.php(67): Middleland\Dispatcher->handle() #15 C:\Server\http\web\webtrees\vendor\oscarotero\middleland\src\Dispatcher.php(136): Fisharebest\webtrees\Http\Middleware\UseDebugbar->process() #16 C:\Server\http\web\webtrees\app\Http\Middleware\UseDatabase.php(117): Middleland\Dispatcher->handle() #17 C:\Server\http\web\webtrees\vendor\oscarotero\middleland\src\Dispatcher.php(136): Fisharebest\webtrees\Http\Middleware\UseDatabase->process() #18 C:\Server\http\web\webtrees\app\Http\Middleware\BadBotBlocker.php(212): Middleland\Dispatcher->handle() #19 C:\Server\http\web\webtrees\vendor\oscarotero\middleland\src\Dispatcher.php(136): Fisharebest\webtrees\Http\Middleware\BadBotBlocker->process() #20 C:\Server\http\web\webtrees\app\Http\Middleware\RegisterFactories.php(72): Middleland\Dispatcher->handle() #21 C:\Server\http\web\webtrees\vendor\oscarotero\middleland\src\Dispatcher.php(136): Fisharebest\webtrees\Http\Middleware\RegisterFactories->process() #22 C:\Server\http\web\webtrees\vendor\middlewares\client-ip\src\ClientIp.php(81): Middleland\Dispatcher->handle() #23 C:\Server\http\web\webtrees\app\Http\Middleware\ClientIp.php(47): Middlewares\ClientIp->process() #24 C:\Server\http\web\webtrees\vendor\oscarotero\middleland\src\Dispatcher.php(136): Fisharebest\webtrees\Http\Middleware\ClientIp->process() #25 C:\Server\http\web\webtrees\app\Http\Middleware\HandleExceptions.php(90): Middleland\Dispatcher->handle() #26 C:\Server\http\web\webtrees\vendor\oscarotero\middleland\src\Dispatcher.php(136): Fisharebest\webtrees\Http\Middleware\HandleExceptions->process() #27 C:\Server\http\web\webtrees\app\Http\Middleware\BaseUrl.php(77): Middleland\Dispatcher->handle() #28 C:\Server\http\web\webtrees\vendor\oscarotero\middleland\src\Dispatcher.php(136): Fisharebest\webtrees\Http\Middleware\BaseUrl->process() #29 C:\Server\http\web\webtrees\app\Http\Middleware\ReadConfigIni.php(69): Middleland\Dispatcher->handle() #30 C:\Server\http\web\webtrees\vendor\oscarotero\middleland\src\Dispatcher.php(136): Fisharebest\webtrees\Http\Middleware\ReadConfigIni->process() #31 C:\Server\http\web\webtrees\app\Http\Middleware\SecurityHeaders.php(47): Middleland\Dispatcher->handle() #32 C:\Server\http\web\webtrees\vendor\oscarotero\middleland\src\Dispatcher.php(136): Fisharebest\webtrees\Http\Middleware\SecurityHeaders->process() #33 C:\Server\http\web\webtrees\app\Http\Middleware\EmitResponse.php(57): Middleland\Dispatcher->handle() #34 C:\Server\http\web\webtrees\vendor\oscarotero\middleland\src\Dispatcher.php(136): Fisharebest\webtrees\Http\Middleware\EmitResponse->process() #35 C:\Server\http\web\webtrees\app\Http\Middleware\PhpEnvironment.php(49): Middleland\Dispatcher->handle() #36 C:\Server\http\web\webtrees\vendor\oscarotero\middleland\src\Dispatcher.php(136): Fisharebest\webtrees\Http\Middleware\PhpEnvironment->process() #37 C:\Server\http\web\webtrees\vendor\oscarotero\middleland\src\Dispatcher.php(118): Middleland\Dispatcher->handle() #38 C:\Server\http\web\webtrees\index.php(57): Middleland\Dispatcher->dispatch() #39 {main} Next Doctrine\DBAL\Driver\PDOException: SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'ip_address' cannot be null in C:\Server\http\web\webtrees\vendor\doctrine\dbal\lib\Doctrine\DBAL\Driver\PDOStatement.php:119 Stack trace: #0 C:\Server\http\web\webtrees\vendor\illuminate\database\Connection.php(458): Doctrine\DBAL\Driver\PDOStatement->execute() #1 C:\Server\http\web\webtrees\vendor\illuminate\database\Connection.php(657): Illuminate\Database\Connection->Illuminate\Database\{closure}() #2 C:\Server\http\web\webtrees\vendor\illuminate\database\Connection.php(624): Illuminate\Database\Connection->runQueryCallback() #3 C:\Server\http\web\webtrees\vendor\illuminate\database\Connection.php(459): Illuminate\Database\Connection->run() #4 C:\Server\http\web\webtrees\vendor\illuminate\database\Connection.php(411): Illuminate\Database\Connection->statement() #5 C:\Server\http\web\webtrees\vendor\illuminate\database\Query\Builder.php(2646): Illuminate\Database\Connection->insert() #6 C:\Server\http\web\webtrees\app\SessionDatabaseHandler.php(95): Illuminate\Database\Query\Builder->insert() #7 [internal function]: Fisharebest\webtrees\SessionDatabaseHandler->write() #8 C:\Server\http\web\webtrees\app\Session.php(104): session_write_close() #9 C:\Server\http\web\webtrees\app\Http\Middleware\UseSession.php(73): Fisharebest\webtrees\Session::save() #10 C:\Server\http\web\webtrees\vendor\oscarotero\middleland\src\Dispatcher.php(136): Fisharebest\webtrees\Http\Middleware\UseSession->process() #11 C:\Server\http\web\webtrees\app\Http\Middleware\UpdateDatabaseSchema.php(58): Middleland\Dispatcher->handle() #12 C:\Server\http\web\webtrees\vendor\oscarotero\middleland\src\Dispatcher.php(136): Fisharebest\webtrees\Http\Middleware\UpdateDatabaseSchema->process() #13 C:\Server\http\web\webtrees\app\Http\Middleware\UseDebugbar.php(67): Middleland\Dispatcher->handle() #14 C:\Server\http\web\webtrees\vendor\oscarotero\middleland\src\Dispatcher.php(136): Fisharebest\webtrees\Http\Middleware\UseDebugbar->process() #15 C:\Server\http\web\webtrees\app\Http\Middleware\UseDatabase.php(117): Middleland\Dispatcher->handle() #16 C:\Server\http\web\webtrees\vendor\oscarotero\middleland\src\Dispatcher.php(136): Fisharebest\webtrees\Http\Middleware\UseDatabase->process() #17 C:\Server\http\web\webtrees\app\Http\Middleware\BadBotBlocker.php(212): Middleland\Dispatcher->handle() #18 C:\Server\http\web\webtrees\vendor\oscarotero\middleland\src\Dispatcher.php(136): Fisharebest\webtrees\Http\Middleware\BadBotBlocker->process() #19 C:\Server\http\web\webtrees\app\Http\Middleware\RegisterFactories.php(72): Middleland\Dispatcher->handle() #20 C:\Server\http\web\webtrees\vendor\oscarotero\middleland\src\Dispatcher.php(136): Fisharebest\webtrees\Http\Middleware\RegisterFactories->process() #21 C:\Server\http\web\webtrees\vendor\middlewares\client-ip\src\ClientIp.php(81): Middleland\Dispatcher->handle() #22 C:\Server\http\web\webtrees\app\Http\Middleware\ClientIp.php(47): Middlewares\ClientIp->process() #23 C:\Server\http\web\webtrees\vendor\oscarotero\middleland\src\Dispatcher.php(136): Fisharebest\webtrees\Http\Middleware\ClientIp->process() #24 C:\Server\http\web\webtrees\app\Http\Middleware\HandleExceptions.php(90): Middleland\Dispatcher->handle() #25 C:\Server\http\web\webtrees\vendor\oscarotero\middleland\src\Dispatcher.php(136): Fisharebest\webtrees\Http\Middleware\HandleExceptions->process() #26 C:\Server\http\web\webtrees\app\Http\Middleware\BaseUrl.php(77): Middleland\Dispatcher->handle() #27 C:\Server\http\web\webtrees\vendor\oscarotero\middleland\src\Dispatcher.php(136): Fisharebest\webtrees\Http\Middleware\BaseUrl->process() #28 C:\Server\http\web\webtrees\app\Http\Middleware\ReadConfigIni.php(69): Middleland\Dispatcher->handle() #29 C:\Server\http\web\webtrees\vendor\oscarotero\middleland\src\Dispatcher.php(136): Fisharebest\webtrees\Http\Middleware\ReadConfigIni->process() #30 C:\Server\http\web\webtrees\app\Http\Middleware\SecurityHeaders.php(47): Middleland\Dispatcher->handle() #31 C:\Server\http\web\webtrees\vendor\oscarotero\middleland\src\Dispatcher.php(136): Fisharebest\webtrees\Http\Middleware\SecurityHeaders->process() #32 C:\Server\http\web\webtrees\app\Http\Middleware\EmitResponse.php(57): Middleland\Dispatcher->handle() #33 C:\Server\http\web\webtrees\vendor\oscarotero\middleland\src\Dispatcher.php(136): Fisharebest\webtrees\Http\Middleware\EmitResponse->process() #34 C:\Server\http\web\webtrees\app\Http\Middleware\PhpEnvironment.php(49): Middleland\Dispatcher->handle() #35 C:\Server\http\web\webtrees\vendor\oscarotero\middleland\src\Dispatcher.php(136): Fisharebest\webtrees\Http\Middleware\PhpEnvironment->process() #36 C:\Server\http\web\webtrees\vendor\oscarotero\middleland\src\Dispatcher.php(118): Middleland\Dispatcher->handle() #37 C:\Server\http\web\webtrees\index.php(57): Middleland\Dispatcher->dispatch() #38 {main} Next Illuminate\Database\QueryException: SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'ip_address' cannot be null (SQL: insert into `session` (`session_id`, `session_time`, `user_id`, `ip_address`, `session_data`) values (h2j7ehbkjrb1uik74t72r7f7j3, 2021-01-23 16:04:44, 0, ?, initiated|b:1;_GUEST_sessiontime|s:10:"1611417884";language|s:2:"de";theme|s:0:"";)) in C:\Server\http\web\webtrees\vendor\illuminate\database\Connection.php:664 Stack trace: #0 C:\Server\http\web\webtrees\vendor\illuminate\database\Connection.php(624): Illuminate\Database\Connection->runQueryCallback() #1 C:\Server\http\web\webtrees\vendor\illuminate\database\Connection.php(459): Illuminate\Database\Connection->run() #2 C:\Server\http\web\webtrees\vendor\illuminate\database\Connection.php(411): Illuminate\Database\Connection->statement() #3 C:\Server\http\web\webtrees\vendor\illuminate\database\Query\Builder.php(2646): Illuminate\Database\Connection->insert() #4 C:\Server\http\web\webtrees\app\SessionDatabaseHandler.php(95): Illuminate\Database\Query\Builder->insert() #5 [internal function]: Fisharebest\webtrees\SessionDatabaseHandler->write() #6 C:\Server\http\web\webtrees\app\Session.php(104): session_write_close() #7 C:\Server\http\web\webtrees\app\Http\Middleware\UseSession.php(73): Fisharebest\webtrees\Session::save() #8 C:\Server\http\web\webtrees\vendor\oscarotero\middleland\src\Dispatcher.php(136): Fisharebest\webtrees\Http\Middleware\UseSession->process() #9 C:\Server\http\web\webtrees\app\Http\Middleware\UpdateDatabaseSchema.php(58): Middleland\Dispatcher->handle() #10 C:\Server\http\web\webtrees\vendor\oscarotero\middleland\src\Dispatcher.php(136): Fisharebest\webtrees\Http\Middleware\UpdateDatabaseSchema->process() #11 C:\Server\http\web\webtrees\app\Http\Middleware\UseDebugbar.php(67): Middleland\Dispatcher->handle() #12 C:\Server\http\web\webtrees\vendor\oscarotero\middleland\src\Dispatcher.php(136): Fisharebest\webtrees\Http\Middleware\UseDebugbar->process() #13 C:\Server\http\web\webtrees\app\Http\Middleware\UseDatabase.php(117): Middleland\Dispatcher->handle() #14 C:\Server\http\web\webtrees\vendor\oscarotero\middleland\src\Dispatcher.php(136): Fisharebest\webtrees\Http\Middleware\UseDatabase->process() #15 C:\Server\http\web\webtrees\app\Http\Middleware\BadBotBlocker.php(212): Middleland\Dispatcher->handle() #16 C:\Server\http\web\webtrees\vendor\oscarotero\middleland\src\Dispatcher.php(136): Fisharebest\webtrees\Http\Middleware\BadBotBlocker->process() #17 C:\Server\http\web\webtrees\app\Http\Middleware\RegisterFactories.php(72): Middleland\Dispatcher->handle() #18 C:\Server\http\web\webtrees\vendor\oscarotero\middleland\src\Dispatcher.php(136): Fisharebest\webtrees\Http\Middleware\RegisterFactories->process() #19 C:\Server\http\web\webtrees\vendor\middlewares\client-ip\src\ClientIp.php(81): Middleland\Dispatcher->handle() #20 C:\Server\http\web\webtrees\app\Http\Middleware\ClientIp.php(47): Middlewares\ClientIp->process() #21 C:\Server\http\web\webtrees\vendor\oscarotero\middleland\src\Dispatcher.php(136): Fisharebest\webtrees\Http\Middleware\ClientIp->process() #22 C:\Server\http\web\webtrees\app\Http\Middleware\HandleExceptions.php(90): Middleland\Dispatcher->handle() #23 C:\Server\http\web\webtrees\vendor\oscarotero\middleland\src\Dispatcher.php(136): Fisharebest\webtrees\Http\Middleware\HandleExceptions->process() #24 C:\Server\http\web\webtrees\app\Http\Middleware\BaseUrl.php(77): Middleland\Dispatcher->handle() #25 C:\Server\http\web\webtrees\vendor\oscarotero\middleland\src\Dispatcher.php(136): Fisharebest\webtrees\Http\Middleware\BaseUrl->process() #26 C:\Server\http\web\webtrees\app\Http\Middleware\ReadConfigIni.php(69): Middleland\Dispatcher->handle() #27 C:\Server\http\web\webtrees\vendor\oscarotero\middleland\src\Dispatcher.php(136): Fisharebest\webtrees\Http\Middleware\ReadConfigIni->process() #28 C:\Server\http\web\webtrees\app\Http\Middleware\SecurityHeaders.php(47): Middleland\Dispatcher->handle() #29 C:\Server\http\web\webtrees\vendor\oscarotero\middleland\src\Dispatcher.php(136): Fisharebest\webtrees\Http\Middleware\SecurityHeaders->process() #30 C:\Server\http\web\webtrees\app\Http\Middleware\EmitResponse.php(57): Middleland\Dispatcher->handle() #31 C:\Server\http\web\webtrees\vendor\oscarotero\middleland\src\Dispatcher.php(136): Fisharebest\webtrees\Http\Middleware\EmitResponse->process() #32 C:\Server\http\web\webtrees\app\Http\Middleware\PhpEnvironment.php(49): Middleland\Dispatcher->handle() #33 C:\Server\http\web\webtrees\vendor\oscarotero\middleland\src\Dispatcher.php(136): Fisharebest\webtrees\Http\Middleware\PhpEnvironment->process() #34 C:\Server\http\web\webtrees\vendor\oscarotero\middleland\src\Dispatcher.php(118): Middleland\Dispatcher->handle() #35 C:\Server\http\web\webtrees\index.php(57): Middleland\Dispatcher->dispatch() #36 {main}

I am using a windows webserver IIS with PHP 7.4.14 and MariaDB 10.5.

I guess the problem has something to do with an unobtainable ip address.

insert into `session` (`session_id`, `session_time`, `user_id`, `ip_address`, `session_data`) values (h2j7ehbkjrb1uik74t72r7f7j3, 2021-01-23 16:04:44, 0, ?, initiated|b:1;_GUEST_sessiontime|s:10:"1611417884";language|s:2:"de";theme|s:0:"";

Last edit: 3 years 2 months ago by Fropper.

Please Log in or Create an account to join the conversation.

More
3 years 2 months ago #2 by fisharebest
Replied by fisharebest on topic Unable to install
> I guess the problem has something to do with an unobtainable ip address.

It certainly looks that way.

The IP address is provided by the webserver - in your case IIS.

Presumably IIS isn't sending the information to fastcgi / PHP.

To test this, create a simple PHP script (e.g. a file called phpinfo.php) containing the following, and view it in your browser.
Code:
<?php phpinfo(INFO_VARIABLES);

Does this have an entry for REMOTE_ADDR?
Does it contain an IP address?

Greg Roach - greg@subaqua.co.uk - @fisharebest@phpc.social - fisharebest.webtrees.net

Please Log in or Create an account to join the conversation.

  • Fropper
  • Topic Author
  • Offline
  • New Member
  • New Member
More
3 years 2 months ago - 3 years 2 months ago #3 by Fropper
Replied by Fropper on topic Unable to install
Hi Greg, it indeed contains an IP address, but an ipv6 address.

fe80::59c8:8be8:23ef:5f81%12
Last edit: 3 years 2 months ago by Fropper.

Please Log in or Create an account to join the conversation.

More
3 years 2 months ago #4 by fisharebest
Replied by fisharebest on topic Unable to install
The % character and the text after it is used to identify a network adapter.

I don't think it should be part of the IP address.

It fails PHP's built in validation, which is why it isn't recognised...
Code:
php > var_dump(filter_var('fe80::59c8:8be8:23ef:5f81%12', FILTER_VALIDATE_IP, FILTER_FLAG_IPV6)); bool(false)

Greg Roach - greg@subaqua.co.uk - @fisharebest@phpc.social - fisharebest.webtrees.net

Please Log in or Create an account to join the conversation.

  • Fropper
  • Topic Author
  • Offline
  • New Member
  • New Member
More
3 years 2 months ago #5 by Fropper
Replied by Fropper on topic Unable to install
I tried accessing the install page from another computer, but got the same error, although I now got a valid IPv6. It seems the malformed IPv6 entrry with the % was already saved in the database.

So I did a fresh reinstall with a new database and unzipping webtrees again and now it's working :)

Please Log in or Create an account to join the conversation.

Powered by Kunena Forum
}