Bug 1036347

Summary:	freeradius couldn't connect to postgresql server
Product:	Red Hat Enterprise Linux 7	Reporter:	David Spurek <dspurek>
Component:	freeradius	Assignee:	John Dennis <jdennis>
Status:	CLOSED NOTABUG	QA Contact:	BaseOS QE Security Team <qe-baseos-security>
Severity:	high	Docs Contact:
Priority:	high
Version:	7.0	CC:	dspurek, ebenes
Target Milestone:	rc
Target Release:	---
Hardware:	Unspecified
OS:	Unspecified
Whiteboard:
Fixed In Version:		Doc Type:	Bug Fix
Doc Text:		Story Points:	---
Clone Of:		Environment:
Last Closed:	2013-12-13 01:01:34 UTC	Type:	Bug
Regression:	---	Mount Type:	---
Documentation:	---	CRM:
Verified Versions:		Category:	---
oVirt Team:	---	RHEL 7.3 requirements from Atomic Host:
Cloudforms Team:	---	Target Upstream Version:

Description David Spurek 2013-12-01 09:54:08 UTC

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:

Comment 2 David Spurek 2013-12-01 10:00:20 UTC

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)

Comment 3 John Dennis 2013-12-13 01:01:34 UTC

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.