That is fantastic! It works. Thank you.
Does anyone have this updated scraper?
So for posterity, this was fixed a couple ways. No longer download the original oui.txt file. It has the carriage return issues which infects other aspects of netdb. Start using the sanitized one from this site: https://linuxnet.ca/ieee/oui/ I backed up the database and performed a search & replace to remove the ^M after the vendor descriptions. sed "s/\\r',NULL/',NULL/g" backup.sql > fixed.sql Restored database (both backup and restore via the netdbctl command)
Did you find out how to refresh the Vendor info when changing out the OUI file?
I'm doing wget from the IEEE source so if that's the case then there is no Unix version, but I'll give that a shot. What I'd like to find is the code syntax that creates the CSV files for you. Maybe I can alter the regex to remove ctrl-M. Edit: It does appear the oui.txt file now includes carriage returns. There is a sanitized version that does not. https://linuxnet.ca/ieee/oui/ However, it is still happening. I think I need to delete the part of the database that has the OUI matches to IP's and...
I'm doing wget from the IEEE source so if that's the case then there is no Unix version, but I'll give that a shot. What I'd like to find is the code syntax that creates the CSV files for you. Maybe I can alter the regex to remove ctrl-M.
My CSV reports that NetDB creates are having an issue when loaded in Excel. Every other line has the firstseen,lastseen dates on a second line, instead of all fields pertaining to that record in a single line. I never used to have this problem until I started importing the OUI.txt file from the Internet. Sure enough, I took a look at the netdbreport.csv file created on the server under /var/www and it appears there are ^M returns after every vendor code. This puts the firstseen,lastseen on a second...
My CSV reports that NetDB creates are having an issue when loaded in Excel. Every other line has the firstseen,lastseen dates on a second line, instead of all fields pertaining to that record in a single line. I never used to have this problem until I started importing the OUI.txt file from the Internet. Sure enough, I took a look at the netdbreport.csv file created on the server under /var/www and it appears there are ^M returns after every vendor code. This puts the firstseen,lastseen on a second...