Telling FR to conect to postres vi IPv4
Hi, Our database team have just migrated a postgres db from Ubuntu 15.04 -> 18.04 postgres 10 my FR server ( Ubuntu 16.04 / FR 3.0.20) has had dual ip stacks for ages but I guess the postgres db server hasn't The new server does have ipv6 and now FR is trying to connect to it via ipv6.... and is getting rejected Two options 1). Set postgres up to accept connections from the new ipv6 address 2). Tell the FR end to use ipv4 Fairly certain its not a FR thing but underlying postgres config. So how do I tell my FR server to connect via ipv4 ? Rgds A
On Wed, 2020-01-29 at 12:45 +0000, Alex Sharaz via Freeradius-Users wrote:
1). Set postgres up to accept connections from the new ipv6 address
Seems like the best solution.
2). Tell the FR end to use ipv4
Fairly certain its not a FR thing but underlying postgres config. So how do I tell my FR server to connect via ipv4 ?
Put the IPv4 address in the SQL config? If you've got a DNS name there, and that resolves to IPv4 and IPv6 addresses, you're saying "please connect on either". So it does. Or use another DNS name which only resolves to an IPv4 address? -- Matthew
Was a bit of a silly question really. The db end was set up with only ipv4 addresses instead of an FQDN As you said, specifying a static ipv4 address works but is a bit messy. We;re tidying up the postgres end to use FQDNs and everything working over ipv6 now Rgds Alex \ On Wed, 29 Jan 2020 at 12:56, Matthew Newton <mcn@freeradius.org> wrote:
On Wed, 2020-01-29 at 12:45 +0000, Alex Sharaz via Freeradius-Users wrote:
1). Set postgres up to accept connections from the new ipv6 address
Seems like the best solution.
2). Tell the FR end to use ipv4
Fairly certain its not a FR thing but underlying postgres config. So how do I tell my FR server to connect via ipv4 ?
Put the IPv4 address in the SQL config?
If you've got a DNS name there, and that resolves to IPv4 and IPv6 addresses, you're saying "please connect on either". So it does.
Or use another DNS name which only resolves to an IPv4 address?
-- Matthew
participants (2)
-
Alex Sharaz -
Matthew Newton