rucio icon indicating copy to clipboard operation
rucio copied to clipboard

`IP` column of `tokens` table unable to hold the IPv6/v4 pair entry during authentication.

Open Geogouz opened this issue 1 year ago • 1 comments

Description

I noticed a problem related to the ip column of the tokens table in my deployment. Since it is of type varchar(39), I assume it is designed to be able to hold a fully expanded IPv6 address. However, after authenticating with a remote client, I ended up actually with a pair of addresses instead of one that needed to be stored there (more specifically, an IPv6 and an IPv4). Due to their total length, this is not possible and unless you increase the varchar length, it won't work.

Steps to reproduce

Deploy a Rucio developer environment and connect to it from a client using an IPv6-based connection.

Rucio Version

35.2.1

Additional Information

No response

Geogouz avatar Aug 30 '24 11:08 Geogouz

@mlassnig I don't remember ever storing pairs in this table?

bari12 avatar Sep 11 '24 12:09 bari12