freeradius-users at lists.freeradius.org

[Ivan Kalik]

> Is there any way to setup freeRADIUS to connect to "my_db" instead of
> "radius" database?

Yes.

> I have setup freeRADIUS successfully to connect to a backend PostgreSQL
> database. My original TEST setup is done by following the standard
> instruction bt creating a "radius" database & "radius" role/User.
> sql.con has the following instructions,which I believe make this
> connection;
>
> database   =      postgres
> server       =      "pg1"
> login         =      "radius"
> password   =   "radpass"
>
> When I start the RADIUS in the DEBUG mode, I see this line;
>
> radius at pg1:/radius
>
> and it connects & no error is displayed.
>
> --------------------
>
> No I want to change the database to"my_db" & a Schema "radius".
> PostgreSQL is both of them created. I changed "sql.conf" to:
>
> database   =      postgres
> server       =      "pg1"

> login         =      "my_db"

That's database login username you changed.

> password   =   "radpass"
>
> This does not work.

No wonder. What is the next config line in sql.conf, after these?

Ivan Kalik
Kalik Informatika ISP