Hide Forgot
Description of problem: freeradius couldn't connect to postgresql server Version-Release number of selected component (if applicable): freeradius-3.0.0-4.el7 How reproducible: Steps to Reproduce: 1.setup postgresql server, create data using 2./etc/raddb/mods-config/sql/main/postgresql/setup.sql and chema.sql scripts 3.add users to database 4. set postgresql driver in sql config (driver = "rlm_sql_postgresql" in /etc/raddb/mods-available/sql file) 5. Enable sql module - ln -s /etc/raddb/mods-available/sql /etc/raddb/mods-enabled/sql Actual results: radiusd -X shows: rlm_sql (sql): Opening additional connection (0) rlm_sql_postgresql: Couldn't connect socket to PostgreSQL server @localhost:radius rlm_sql_postgresql: Socket destructor called, closing socket rlm_sql (sql): Opening connection failed (0) rlm_sql (sql): Removing connection pool /etc/raddb/mods-enabled/sql[19]: Instantiation failed for module "sql" Expected results: Successfull connect to postgresql server Additional info:
Data in postgresql database: su - postgres -c 'psql -c "SELECT * FROM radcheck" radius' id | username | attribute | op | value ----+--------------+--------------------+----+------------ 1 | paptestuser | Cleartext-Password | := | mypassword 2 | paptestuser | Auth-Type | := | PAP 3 | chaptestuser | Cleartext-Password | := | mypassword 4 | chaptestuser | Auth-Type | := | CHAP (4 rows)
This is not a bug in FreeRADIUS, it was a failure of the test to set the SQL login credentials for the postgres server in the FreeRADIUS SQL configuration file. It's the exact same issue seen in the MySQL test. I have updated the postgresql-auth-test/runtest.sh file with several fixes and will attach it to bug #1021541 which is the bug report being used to accumulate FreeRADIUS 3 test porting fixes.