Research
Security News
Quasar RAT Disguised as an npm Package for Detecting Vulnerabilities in Ethereum Smart Contracts
Socket researchers uncover a malicious npm package posing as a tool for detecting vulnerabilities in Etherium smart contracts.
bigquery-geoip
Advanced tools
Bigquery maxmind geoip loader
Sign up for an account at https://maxmind.com.
Download and extract the following databases:
GeoLite2-ASN-CSV
GeoLite2-City-CSV
bq mk geoip
First, cd
to the parent directory of the extracted database directories:
cd ~/Downloads
# These paths should exist:
ls GeoLite2-ASN-CSV*/GeoLite2-ASN-Blocks-IPv4.csv
ls GeoLite2-City-CSV*/GeoLite2-City-Blocks-IPv4.csv
ls GeoLite2-City-CSV*/GeoLite2-City-Locations-en.csv
Then run the load script:
npm install -g bigquery-geoip
bigquery-geoip
with ips as (
select "162.213.133.27" as ip
)
select city.*, ips.*
from ips
left join geoip.city
on CAST(NET.IPV4_TO_INT64(NET.IP_FROM_STRING(ips.ip))/(256*256*256) as INT64) = class_a
and NET.IPV4_TO_INT64(NET.IP_FROM_STRING(ips.ip)) between start_num and end_num
The default dataset name is geoip
. Customize it by adding an argument:
bigquery-geoip ipToCity
FAQs
Bigquery maxmind geoip loader
The npm package bigquery-geoip receives a total of 0 weekly downloads. As such, bigquery-geoip popularity was classified as not popular.
We found that bigquery-geoip demonstrated a not healthy version release cadence and project activity because the last version was released a year ago. It has 1 open source maintainer collaborating on the project.
Did you know?
Socket for GitHub automatically highlights issues in each pull request and monitors the health of all your open source dependencies. Discover the contents of your packages and block harmful activity before you install or update your dependencies.
Research
Security News
Socket researchers uncover a malicious npm package posing as a tool for detecting vulnerabilities in Etherium smart contracts.
Security News
Research
A supply chain attack on Rspack's npm packages injected cryptomining malware, potentially impacting thousands of developers.
Research
Security News
Socket researchers discovered a malware campaign on npm delivering the Skuld infostealer via typosquatted packages, exposing sensitive data.