I've been spending some time last weeks researching about dedicated server rentals in Spain and, appart from all of them being really expensive, I found something that's bugging me.
So this is a range of IPs used by one of those providers (51.254.154.0/24). I got some of the ips, used some geo location tools and got back some weird results. While some of the ips seem to be located in Spain, others don't.
I then found out that the company linked to those IPs is OVH, which offers no services in Spain, having the nearest datacenter in France, where some of those IPs seem to be from.
As a final check, I wanted to simply ping these IPs and compare it to some I knew are located in OVH France's datacenter finding out that there was almost no difference, having between 53-54ms of response time.
mtrcheck on "spanish" IP (51.254.154.225) and one of my servers(192.0.2.50) in France from fr1 located there as well:
# mtr -c10 -r -n 51.254.154.225
Start: Mon Feb 27 14:14:23 2017
HOST: fr1 Loss% Snt Last Avg Best Wrst StDev
1.|-- 192.0.2.10 0.0% 10 974.0 208.1 0.3 1079. 432.2
2.|-- 10.95.68.132 0.0% 10 0.3 0.3 0.2 0.3 0.0
3.|-- 10.95.66.72 0.0% 10 0.2 0.2 0.2 0.4 0.0
4.|-- 37.187.231.253 0.0% 10 1.8 1.8 1.7 1.8 0.0
5.|-- 178.33.103.226 80.0% 10 2.0 8.7 2.0 15.5 9.5
6.|-- 51.254.154.225 0.0% 10 1.8 1.8 1.8 1.9 0.0
# mtr -c10 -r -n 192.0.2.50
Start: Mon Feb 27 14:14:24 2017
HOST: fr1 Loss% Snt Last Avg Best Wrst StDev
1.|-- 192.0.2.10 0.0% 10 1.8 156.6 0.3 1069. 342.6
2.|-- 10.95.68.196 0.0% 10 0.3 0.3 0.2 0.3 0.0
3.|-- 10.95.66.70 0.0% 10 0.2 0.3 0.2 0.3 0.0
4.|-- 37.187.232.120 70.0% 10 0.2 0.2 0.2 0.3 0.0
5.|-- 192.0.2.50 0.0% 10 0.6 0.6 0.5 0.7 0.0
So...
- Is this spanish provider lying about the location of their servers?
- If so, how can it be possible to show that the IP is located in Spain when it actually isn't?
- Might it be pure coincidence that I get same ping results as I live in the middle of France and Madrid datacenters?
If you got here with the same question I had and not just by clicking on the "Month/Week question feed, don't just read the correct answer, it's worth having a look at everything
Geolocation is not an exact science. The databases are full of errors and misinformation.
Note: OVH do not appear to have a Spanish DC.
Who is passing on terminological inexactitude I wouldn't like to say.
Looking at the output of mtr to both of the IPs listed, it appears that both systems are likely located in the OVH Gravelines DC in France.
and
There is another way to check, which is to query some BGP looking glasses.
This is generally more reliable than GeoIP (as mentionned by @Jacob, GeoIP databases vary in quality and freshness), since BGP is the protocol for routing the ranges across the cyberpipes (or is it interwebz).
Generally, you'll need to check a few locations to make sure you aren't seeing aggregated routes, BUT, ultimately, every IP belongs to AS, and that AS can easily be traced to a company.
Per the Hurricane Electric looking glass (http://bgp.he.net/ip/51.254.154.0#_ipinfo), OVH indeed owns that /24, and its supernet (51.254.0.0/15). Checking a Spanish looking glass, http://www.rediris.es/red/lg/lg.pl, seems to confirm as much (but this is nothing more than a quick check on my part).
Your traceroutes/mtr outputs seem to confirm as much: the IP is owned and announced by OVH, and routes, at least, via them (if not to them).
tl;dr: it seems your provider is using a French provider, and their data centers/infra. This isn't 100% certain, but seems the most likely explanation.
Edit: to be clear, the fact OVH is AS to which the IP is allocated doesn't necessarily mean anything about specific locations. Sadly, neither necessarily does mtr-output - even if (as seems to be the case) OVH are pushing out the whole /24 your provider is a part of with a peer in France, some internal transport (e.g. MPLS) could still be used. That wouldn't necessarily be the most sensible way of doing all this, but it isn't impossible.
Not that all of the other answers aren't great and really helpfull (it is worth reading every post in here) but I think I just found the answer myself yesterday.
So, we were in need of another IP for one of our servers located in France rent with So You Start, which is just like Kimsufi (they both are OVH companies) but a bit better and more expensive. When I got to the administration panel and clicked on "Add extra IP Addresses", they let me choose the location of the IP and, guess what? Spain was there.
Here's the screenshot that proves it. It is in spanish but I think it's quite easy to understand the concept.
Conclusion:
There's some spanish (and probably somewhere else) hosting companies reselling OVH dedicated servers located in France with spanish IPs as if they were located in Spain, increasing the monthly cost between 3 and 4 times.
Appart from being absolutely ilegal, it is insulting how these bastards keep on ripping off people with IT related stuff. Just be aware when spending your money (specially in Spain right now) and, just like a friend says, don't even trust a flower.