I would try copying that SQL statement into the interactive parser in
postgres. May give you a better idea as to what the problem is with it.
But it does look like you have a problem connecting to your postgres
server.
Also ensure your postmaster is accepting connections on port 5432.
also check that the entries in the pg_hba.conf file are correct for
postgres to allow freeradius to connect to the accounting database
I use postgres here for accounting without any problems.
Graeme
On Thu, 20 May 2004 17:32:22 +0200
"Roberto Pioli" <[EMAIL PROTECTED]> wrote:
> I'm using freeradius with postgres with cisco 5300 for voip
> accounting. The accounting on file is ok but in postgres doesn't work.
>
> This is the problem
>
> rlm_sql (sql): sql_set_user escaped user --> '0034620220'
> radius_xlat: 'INSERT into StopTelephony ??(RadiusServerName,
> UserName, NASIPAddress, AcctTime, ??AcctSessionTime, AcctInputOctets,
> AcctOutputOctets, CalledStationId, CallingStationId, ??AcctDelayTime,
> H323RemoteAddress, CiscoNASPort, h323callorigin, h323confid,
> ??h323connecttime, h323disconnectcause, h323disconnecttime, h323gwid,
> h323setuptime) ??values('myservername', '0034620220',
> '213.144.73.200', now(), '0', ??'16032', '56760', '3280438652',
> '0034620220', ??'10', NULLIF('', '')::inet, 'ISDN 0:D:8',
> ??'originate', '5392A4C9 13F351F9 0 58DEF568', strip_dot('17:26:46.159
> cest Thu May 20 2004'), '10',??strip_dot('17:26:46.159 cest Thu May 20
> 2004'), 'gw0-PDF.reteitaly.com', strip_dot('17:25:49.350 cest Thu May
> 20 2004'))' rlm_sql (sql): Reserving sql socket id: 14
> rlm_sql_postgresql: Status: PGRES_FATAL_ERROR
> rlm_sql_postgresql: affected rows =
> rlm_sql_postgresql: Postgresql check_error: PGRES_FATAL_ERROR,
> returning SQL_DOWN
> rlm_sql (sql): Attempting to connect rlm_sql_postgresql #14
> rlm_sql (sql): Connected new DB handle, #14
> rlm_sql_postgresql: Status: PGRES_FATAL_ERROR
> rlm_sql_postgresql: affected rows =
> rlm_sql_postgresql: Postgresql check_error: PGRES_FATAL_ERROR,
> returning SQL_DOWN
> rlm_sql (sql): failed after re-connect
> rlm_sql (sql): Couldn't update SQL accounting STOP record - ERROR:
> function strip_dot("unknown") does not exist
>
> Thanks
>
> Roberto
>
>
> -
> List info/subscribe/unsubscribe? See
> http://www.freeradius.org/list/users.html
--
-----
Graeme Hinchliffe (BSc)
Core Internet Systems Designer
Zen Internet (http://www.zen.co.uk/)
ICQ 3842605 (link)
Direct: 0845 058 9074
Main : 0845 058 9000
Fax : 0845 058 9005
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
