My problem was network related. I also through into my sql.conf:
connect_failure_retry_delay = 60
not sure what it does but it looks nice 8-)
> -----Original Message-----
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]]On Behalf Of Guillermo
> Schimmel
> Sent: Friday, February 07, 2003 1:04 PM
> To: [EMAIL PROTECTED]
> Subject: Re: PostgreSQL Problem
>
>
> I have the same problem. Until now, the only solution was kill -9 in the
> crontab, every half an hour or so.
>
> The suggestion from the list is recompile the fr with the same version
> of psql client libraries and server. I havent done that yet because I'm
> waiting for a PostgreSQL upgrade, scheduled to the next week, but if you
> try that and tell me the result, it would be really useful.
>
> Regards
>
>
> Guillermo
>
>
> Eric Dean wrote:
>
> >I was having pgsql problem between freeradius 0.7.1 and my
> postgres database
> >whereby freeradius would lose it's db connection. I upgraded to
> 0.8.1 and I
> >still get the same errors. However, with 7.1, freeradiusd would keep
> >running and responding to queries...however, 8.1 just
> stops...dead...I have
> >to kill -9 it. Then it restarts...for a little bit...minutes to
> hours at a
> >time:
> >
> >Fri Feb 7 04:40:14 2003 : Error: rlm_sql_postgresql: Couldn't connect
> >socket to PostgreSQL server [EMAIL PROTECTED]:bar
> >Fri Feb 7 04:40:14 2003 : Error: rlm_sql_postgresql: Postgresql error ''
> >Fri Feb 7 04:40:14 2003 : Error: rlm_sql_postgresql: PostgreSQL Query
> >failed Error: no connection to the server
> >Fri Feb 7 04:40:14 2003 : Error: rlm_sql (sql): failed after re-connect
> >
> >
> >-
> >List info/subscribe/unsubscribe? See
http://www.freeradius.org/list/users.html
>
>
>
>
-
List info/subscribe/unsubscribe? See
http://www.freeradius.org/list/users.html
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
