Querying GenericIPAddressField with a space crashes with DataError on PostgreSQL

[Vlada Macek]

When I have a GenericIPAddressField of the model in search_fields of a ModelAdmin and then search for example a space, the admin dies with 500 and

DataError: invalid input syntax for type inet: " "

exception is e-mailed.

[Tim Graham]

The problem isn't in the admin. For example, GenericIPAddress.objects.filter(ip=' ') also crashes (using the model in tests/model_fields/test_genericipaddressfield.py).

[Vlada Macek]

I was't this much specific in the Summary as not only space causes the DataError, but apparently a syntactically wrong IPv4/IPv6 address, any of 'string', '10.10.10.300', 'fffg::'.

I selected admin component as I considered the DataError from ORM as part of correct "user interface" to the developer. What is clearly wrong IMHO is 500 from using the admin.

Thanks.

[Claude Paroz]

A possible solution would be to validate the value in DatabaseOperations.adapt_ipaddressfield_value. Possibly trying first with our own validator, then round-tripping to the database as last resort. Maybe a ValidationError before running the query may be catched easier than the error coming from the database.

[Can Sarıgöl]

​PR

[Simon Charette]

I know some lookup raise ValueError or TypeError when an invalid value is provided but none raise ValidationError AFAIK. IMO this is an issue similar to #29915 where a specialized __contains lookup must be implemented for GenericIPAddressField.

[Carlton Gibson]

What is clearly wrong IMHO is 500 from using the admin.

#30064 adds a form to ChangeList to validate the search query input. You'll be able to subclass ChangeList, and override get_changelist(), to customise that form (adding an additional validator for IP addresses, say).

If you have multiple search fields, you'll likely need to override get_search_results() ​see the docs for that, since the same query value is used to filter on all the fields. (Something like django-filter would allow per field validation and filtering, but not from a single search box normally...)

From the UI perspective, I think that's more or less all we can really do here. Simon's comment from #30064 sums it up:

In my opinion the issue is that the ​admin is relying on unsanitized request.GET passing to the ORM, that looks like the same class of issues as Model.objects.get(int_field='foo'). The admin should use a form to sanitize the input...

(See too the "User input should be sanitized before feeding it to the ORM." below that.)

Validating against null characters is something we can apply to all input, but IP addresses, say, are only going to apply sometimes, so the developer needs to adjust the form themselves. (Short of a django-filter like mechanism that will generate a full model-form, which is out of scope here.)

As per the rest of the discussion here, what that leaves for this ticket is the ORM behaviour: to raise a ValueError before hitting the DB in this case.