Troubleshooting PostgreSQL Integration

A.L.M.Buxey at A.L.M.Buxey at
Tue Aug 27 18:38:40 CEST 2013


yes, it was received....over a bank holiday weekend. not surprised
you didnt get an answer...we were all enjoying the break.

the DB seems to be loading up and being connected to (and you can
check this with loggin on the pgsql server...) however, THIS bit
is your problems

rlm_sql (sql): Reserving sql socket id: 4
[sql]   expand:  ->
[sql] Error generating query; rejecting user
rlm_sql (sql): Released sql socket id: 4
++[sql] returns fail
Invalid user: [radiususer/radiususerPW] (from client MY.PUBLIC.IP.ADDRESS port 1812)

a blank expansion for the SQL query - what have you done to the dialup.conf
file in the postgres directory of sql directory??

you can edit sql.conf to enable the SQL trace file to see whats going on too


More information about the Freeradius-Users mailing list