REMOTE_IP gets saved partially when using IPV6

[keevitaja]

When customer is using IPV6 address, the remote_ip might get saved only partially into sales_order and quote tables depending on the address str length.

Problem is in the remote_ip column length which currently is VARCHAR(32)

https://en.wikipedia.org/wiki/IPv6

Preconditions

1. tested on 2.1.5, but InstallSchema in 2.1.7 has also VARCHAR(32)

Steps to reproduce

1. Customer creates new order

Expected result

1. 2001:7d0:84ae:8d80:704b:bca4:b3a8:197

Actual result

1. 2001:7d0:84ae:8d80:704b:bca4:b3a

To fix this, the remote_ip column in sales_order and quote tables must be VARCHAR(45)

[andypieters]

Same issue here.
We need a valid enduser ip address for starting a payment.
If the ipaddress is invalid, customers cannot pay the order

[magento-engcom-team]

@keevitaja, thank you for your report.
We've created internal ticket(s) MAGETWO-83202 to track progress on the issue.