fix(utils): use getaddrinfo for hostname check to support ipv6

[vin01]

fixes hostname validation: #21041

[github-actions]

Congrats on making your first PR and thank you for contributing to Superset! 🎉 ❤️
We hope to see you in our Slack community too!

[codecov]

Codecov Report

Merging #21042 (619c182) into master (ab6ec89) will increase coverage by 0.00%.
The diff coverage is 100.00%.

@@           Coverage Diff            @@
##           master   #21042    +/-   ##
========================================
  Coverage   66.26%   66.27%            
========================================
  Files        1769     1772     +3     
  Lines       67475    67774   +299     
  Branches     7171     7171            
========================================
+ Hits        44711    44914   +203     
- Misses      20933    21029    +96     
  Partials     1831     1831            

Flag	Coverage Δ
hive	53.01% <0.00%> (-0.14%)	⬇️
mysql	80.81% <100.00%> (-0.12%)	⬇️
postgres	80.86% <100.00%> (-0.12%)	⬇️
presto	52.91% <0.00%> (-0.14%)	⬇️
python	81.33% <100.00%> (-0.13%)	⬇️
sqlite	79.38% <100.00%> (-0.21%)	⬇️
unit	50.63% <0.00%> (+0.14%)	⬆️

Flags with carried forward coverage won't be shown. Click here to find out more.

Impacted Files	Coverage Δ
superset/utils/network.py	37.93% <100.00%> (ø)
superset/tasks/cache.py	61.15% <0.00%> (-12.76%)	⬇️
superset/charts/filters.py	85.41% <0.00%> (-9.46%)	⬇️
superset/dashboards/filters.py	88.76% <0.00%> (-4.99%)	⬇️
superset/db_engine_specs/trino.py	69.02% <0.00%> (-4.38%)	⬇️
superset/datasets/api.py	87.29% <0.00%> (-1.05%)	⬇️
superset/views/utils.py	80.00% <0.00%> (-0.85%)	⬇️
superset/examples/birth_names.py	71.42% <0.00%> (-0.65%)	⬇️
superset/databases/schemas.py	98.23% <0.00%> (-0.37%)	⬇️
superset/security/manager.py	95.07% <0.00%> (-0.32%)	⬇️
... and 42 more

📣 We’re building smart automated test selection to slash your CI/CD build times. Learn more

[betodealmeida]

Thanks for this PR!