How to store a socket.io ipv6 to mysql?

Asked Nov 23 '15 at 13:23

Active Nov 23 '15 at 13:23

Viewed 77 times

When running any of these methods on socket.io

        console.log('Ip:', socket.request.connection);
        console.log('client IP: ',socket.handshake.address);
        console.log('client IP: ',socket.client.conn.remoteAddress);
        console.log('client IP: ',socket.conn.remoteAddress);

They all give me the result: ::ffff:86.228.xx.yy I guess it is a ipv6 result.

I try to store that with mysql INET6_ATON("::ffff:86.228.xx.yy") and this gives me the result of NULL

What is the proper way to store a socket.io IP address into mysql (as INTEGER) ?

Maybe convert that to a proper ipv6 address ?

asked Nov 23 '15 at 13:23

yarek

11,278
30
120
219

does it really have to be stored as number? – kaytrance Nov 23 '15 at 13:51
`::ffff:86.228.xx.yy` doesn't look like an ipv6 address – Vatev Nov 23 '15 at 13:51
xx & yy are the problems - to use INET6_ATON it needs to be a valid IP address – PaulF Nov 23 '15 at 13:52
For the storage type take a look at [this question](http://stackoverflow.com/questions/6964143/storing-ipv6-addresses-in-mysql) – Vatev Nov 23 '15 at 13:52
come on ! I put xx and yy to hide my IP !!! – yarek Nov 23 '15 at 16:55

How to store a socket.io ipv6 to mysql?

0 Answers0