Re: [Help-gnu-radius] SQL configuration changed: closing existing connections

[Sergey Poznyakoff]

Hi Andrew,

> Oct 11 19:34:13 Main.notice: SQL configuration changed: closing existing 
> connections

This is perfectly normal message. Moreover, you will see it after each
reconfiguration (radctl restart), since to carry the reconfiguration
radiusd needs to close all existing database connections.

> Oct 11 19:34:13 Main.info: Ready
> Oct 11 19:34:13 Main.info: Ready to process requests.
> Oct 11 19:34:25 Acct.debug: postgres.c:101:rad_postgres_query: query: INSERT 
> INTO calls VALUES(2,'33320756405','2003-10-11 
> 18:34:25','81.188.7.98',0,'00006AED',111,915120,697803,10,0,'9732477473034',33320756405,0,12,'9932EF01
>  FB4711D7 9E6499DB D4AE14EA','cp-be1.Brudcom.com','a','v','17:31:36.226 UTC 
> Sat Oct 11 2003','17:31:47.073 UTC Sat Oct 11 2003','17:33:38.523 UTC Sat Oct 
> 11 2003',10,0,1,'9932EF01 FB4711D7 9E6499DB 
> D4AE14EA',3813,4413,0,'Unknown',0,0,0,'')
> Oct 11 19:34:25 Acct.debug: postgres.c:115:rad_postgres_query: status: 
> PGRES_COMMAND_OK

This means that the previous INSERT statement was processed
successfully. If the data do not appear in the database table
after PGRES_COMMAND_OK, then it is some postgres problem.

Regards,
Sergey