On Thu, May 25, 2006 at 05:20:03PM -0400, Alan DeKok wrote: > andy <[EMAIL PROTECTED]> wrote: > > MySQL clusters require an auto-incrementing field to be the primary key. > > Within the default table definitions for freeradius, which I have used, in > > the table radius.radius_radacct there is an > > auto-incrementing field that is not defined as a primary key. > > In 1.1.1 the RadAcctID field is auto-increment, and PRIMARY KEY. > See doc/examples/mysql.sql. > > Which version are you looking at? > > Alan DeKok. > - > List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html >
The version im looking at is freeradius from ports: dhcp1# radiusd -v radiusd: FreeRADIUS Version 1.1.1, for host , built on May 18 2006 at 18:06:18 I have re-imported the radacct table from this source and the error is slightly different but is still happening: rlm_sql (primary): Reserving sql socket id: 89 rlm_sql_mysql: query: INSERT into RADIUS_RADACCT (AcctSessionId, AcctUniqueId, UserName, Realm, NASIPAddress, NASPortId, NASPortType, AcctStartTime, AcctStopTime, AcctSessionTime, AcctAuthentic, ConnectInfo_start, ConnectInfo_stop, AcctInputOctets, AcctOutputOctets, CalledStationId, CallingStationId, AcctTerminateCause, ServiceType, FramedProtocol, FramedIPAddress, AcctStartDelay, AcctStopDelay) values('0300FFFF78001E5D-4476C727', '52213596cf7e22f9', '00:0a:e4:56:e2:7c', '', '62.231.32.50', '67174400', 'Virtual', '2006-05-26 10:15:19', '0', '0', 'RADIUS', '', '', '0', '0', '', '', '', 'Dialout-Framed-User', '', '', '', '0') rlm_sql_mysql: MYSQL check_error: 2006, returning SQL_DOWN rlm_sql (primary): Attempting to connect rlm_sql_mysql #89 rlm_sql_mysql: Starting connect to MySQL server for #89 rlm_sql (primary): Connected new DB handle, #89 rlm_sql_mysql: query: INSERT into RADIUS_RADACCT (AcctSessionId, AcctUniqueId, UserName, Realm, NASIPAddress, NASPortId, NASPortType, AcctStartTime, AcctStopTime, AcctSessionTime, AcctAuthentic, ConnectInfo_start, ConnectInfo_stop, AcctInputOctets, AcctOutputOctets, CalledStationId, CallingStationId, AcctTerminateCause, ServiceType, FramedProtocol, FramedIPAddress, AcctStartDelay, AcctStopDelay) values('0300FFFF78001E5D-4476C727', '52213596cf7e22f9', '00:0a:e4:56:e2:7c', '', '62.231.32.50', '67174400', 'Virtual', '2006-05-26 10:15:19', '0', '0', 'RADIUS', '', '', '0', '0', '', '', '', 'Dialout-Framed-User', '', '', '', '0') rlm_sql (primary): Released sql socket id: 89 It now doesnt move onto the next socket, but retries the current connection. I have also updated the default queries from sql.conf.example so everything is default. cheers -- andy [EMAIL PROTECTED] ----------------------------------------------- Never argue with an idiot. They drag you down to their level, then beat you with experience. ----------------------------------------------- - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html