Python Script Fails to Get IP from a List of Hostnames

Asked Jul 01 '15 at 19:37

Active Jul 01 '15 at 19:37

Viewed 158 times

Here is my code:

    import socket
import csv

with open('afile.csv','r') as csv:
    a_csv = csv.reader(csv)
    next(a_csv)
    csvList = list(a_csv)
count = 0
for row in csvList:
    if count == len(csvList):
        count = len(csvList)-1
    hostname = socket.gethostbyname(csvList[count][0])
    count += 1

The error I'm getting through the interpreter: socket.gaierror: [Errno 11001] getaddrinfo failed

The purpose of this little python script is to loop through a list that was generated form a csv file, extract the hostname and lookup the IP address. Once it's done with that it should add it back into the list right after the original hostname (I have an open "space" within the csv for this). So my question is what maybe causing this error to occur?

asked Jul 01 '15 at 19:37

brievolz84

http://stackoverflow.com/questions/7334199/getaddrinfo-failed-what-does-that-mean – o-90 Jul 01 '15 at 19:42
How does your csv look like? – Anand S Kumar Jul 01 '15 at 20:04
@AnandSKumar stuff,stuff,stuff,stuff,stuff. The way that an excel spread sheet typically saves as a csv. – brievolz84 Jul 02 '15 at 20:48

Python Script Fails to Get IP from a List of Hostnames

0 Answers0