problem solved: "Couldn't connect socket to PostgreSQL server"
Hi Community. I spent about two hours to figure out following problem: although my configuration was correct, freeradius didn't connect with my postgres database. following error was logged: Info: rlm_sql (sql): Attempting to connect to radius@127.0.0.1:5432/radius Info: rlm_sql (sql): Attempting to connect rlm_sql_postgresql #0 Error: rlm_sql_postgresql: Couldn't connect socket to PostgreSQL server radius@127.0.0.1:radius Error: rlm_sql (sql): Failed to connect DB handle #0 after searching for (not existent) configuration failures i looked into the postgres log. (wow, what for an idea!) There was an entry: CEST LOG: could not accept SSL connection: EOF detected Postgres was configured to work over SSL. Freeradius does not seem to support Postgres over SSL. I deactivated SSL in Postgres and the freeradius server connected. Because no such info seems to exist in Internet, i decided to write it into this list. greetings...
On 18 Sep 2015, at 10:56, A.L.M.Buxey@lboro.ac.uk wrote:
Hi,
Freeradius does not seem to support Postgres over SSL.
I think version 3 fixes that
It's more it allows access to the PG (libpq) options string via the radius_db config item. You can put your SSL options in there: https://github.com/FreeRADIUS/freeradius-server/blob/v3.1.x/raddb/mods-avail... Arran Cudbard-Bell <a.cudbardb@freeradius.org> FreeRADIUS development team FD31 3077 42EC 7FCD 32FE 5EE2 56CF 27F9 30A8 CAA2
Might be worth having a fully loaded commented out example string in the config alan
participants (4)
-
A.L.M.Buxey@lboro.ac.uk -
Alan Buxey -
Arran Cudbard-Bell -
Kurt Weiß