All Questions
Tagged with ip-address mysql
83
questions
0
votes
1
answer
53
views
How can i match user ipaddress from my mysql database ip lookup table?
I have network addresses of ipv4 and ipv6 in table and want to calculate its ranges in columns from_ip ,to_ip in ipaddress and in bigint numeric form of both ipv4 and ipv6 networks so that i can ...
0
votes
1
answer
2k
views
SequelizeConnectionError: connect ETIMEDOUT Google Cloud Run
I have to build a platform to retrieve data from a sql database on another host,for this project I use js nodes with sequels.Locally I can connect without problems using id from the database and ...
0
votes
0
answers
127
views
unique visitor count not working with cookies
I am Beginner and want to learn how to count unique visitors by using PHP cookies. I tried to write this code. And also I am storing it in a database. The problem is I am not getting real visitors ...
- 33
1
vote
1
answer
1k
views
How to allow-list certain IP ranges in MySQL settings to use Google Apps Script
I am finding a way to connect MySQL to Google Spreadsheet and one of the ways that I found was to use the Google Apps Script. But before using, need to allow list certain IP address from Google. I ...
- 19
4
votes
3
answers
499
views
Mysql compare ip address
I have a database which stores IP address with its location. I only store the first 3 network ID of IP address in the table.
+-------------------+-----------------+
|ip_address(varchar)|location(...
- 299
1
vote
1
answer
238
views
Comparing IPv4 IP address with Network address stored on MYSQL
I have a large table containing 3 Million network addresses and their location info
basic fields:
network: eg. 74.142.124.116/30,
latitude: eg. 40475,
longitude: eg. 37.7548
The system also ...
- 731
0
votes
0
answers
92
views
Multiple machines, one mysql server on my laptop (Master Machine), one or multiple database
I hope everyone reading this is doing well in all aspects of life. I have a question(s) I've been struggling with and I'm looking for the help of the community.
I have recently ventured into the ...
0
votes
2
answers
483
views
How can I sort IP addresses in MySql, so ipv4 comes before ipv6 addresses?
I have a table in MySQL with a column containing ip addresses - stored as 'VARCHAR(40)'. Both ipv4 and ipv6 addresses are used.
Now I want to sort those addresses, but I want all ipv4 addresses to ...
- 10.8k
1
vote
1
answer
396
views
Insert user IP Address into MySql table using Prepared Statement in java
I need to insert user IP Address into MySql table using PreparedStatement. How can I do it?
I tried with following code in Servlet.
InetAddress ipaddress;
try {
ipaddress = InetAddress....
- 761
0
votes
3
answers
8k
views
How to filter a range of IP addresses in a SQL query?
I am working in a web apps, I made some checking/limitation when user trying to login my application. Now i need to make a white list function to pass these checking make use of user ip address.
I'm ...
- 72
2
votes
6
answers
5k
views
Mysql connecting ok with local host but not connecting with ip address
I have a java program which takes its information from MySQL it works fine when I use localhost to connect to it but whenever i put ipaddress in it it does not work.
My connection code and exception ...
- 133
2
votes
1
answer
3k
views
Checking if IP is in a range in MYSQL
I have a simple table with IP ranges like this (they are saved as varchar, but I can change that if needed):
1.0.0.0/24
1.0.1.0/24
1.0.2.0/23
1.0.4.0/22
...etc
How can I select the row where the IP ...
- 827
0
votes
1
answer
544
views
Which type has INET6_ATON? / Max length of INET6_ATON?
I wanted to know how to save an INET6_ATON result to MYSQL. So I've read the MYSQL-Help article and it says, I should use VARBINARY(16). But now, with an IPv4-Address it has the content 0x7F000001 and ...
- 345
1
vote
1
answer
1k
views
How to convert ipv4 strings to varbinary in MySQL?
I have a mysql database table that contains ipv4 addresses in a varchar(15) column, and I am trying to insert them into another table that has ip addresses in a varbinary(16) column. How do I do this ...
- 1,031
1
vote
2
answers
3k
views
Storing and retrieving IPv4 and IPv6 addresses
There's a million questions on SO about the best way to store IPv4 and IPv6 addresses on a PHP/MySQL setup, but the answers are either out of date (only IPv4) or they're contradictory/incomplete.
I'...
- 48.3k