koiv.igor@gmail.com said:
But there is no path <path to freeradius>/etc/raddb/postgresql.conf
You are supposed to create this file and make sure it is included from radiusd.conf. Or you can just edit the default sql.conf. Depending if which version of Freeradius you are using the file you need to modify might be located somwhere else.
From README.rst in freeradius-2.2.9:
" rlm_sql ~~~~~~~
The SQL configuration has been moved from ``sql.conf`` to ``mods-available/sql``. "
(You probably need to make a softlink or something from mods-enabled, but check the manual. - We use current software but our config "just works" and has been copied from older to newer software versions for ages...)
You want to use
driver = "rlm_sql_postgresql"
As for where the changes in SQL-queries goes I am really not sure. The file seems to be mods-config/sql/main/postgresql/queries.conf but the format has changed completely from when we made our config.
--Ingeborg