invalid ip should be scaped to `NULL`