<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"><html>
<head>
<meta name="Generator" content="Zarafa WebAccess v7.0.2-29470">
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<title>Cannot insert duplicate key row in object 'dbo.radacct' with unique index 'AcctUniqueId'</title>
<style type="text/css">
body
{
font-family: Arial, Verdana, Sans-Serif ! important;
font-size: 12px;
padding: 5px 5px 5px 5px;
margin: 0px;
border-style: none;
background-color: #ffffff;
}
p, ul, li
{
margin-top: 0px;
margin-bottom: 0px;
}
</style>
</head>
<body>
<p>Hello, i'am using freeradius 2.1.12+dfsg-1.2 on debian wheezy, AAA is in MS-SQL backend using iodbc, the system is a hotspot with mikrotik routerboard using radius client, everything is fine the users can authenticate from radcheck table but in accounting log i receive this message<br /><br />Error: sql_query: failed: [FreeTDS][SQL Server]Cannot insert duplicate key row in object 'dbo.radacct' with unique index 'AcctUniqueId'. The duplicate key value is (4785db03c....</p><p> </p><p>the problem is the radacct table is not registering info like, acctstoptime, acctsessiontime and others, only acctstarttime</p><p> </p><p>if i modify the index unique of acctuniqueid like not unique is worst because in radacct table the start time and stoptime is inserted in two different rows <br /><br />i'm using the following schema<br /><br />https://github.com/FreeRADIUS/freeradius-server/blob/master/raddb/mods-config/sql/main/mssql/schema.sql<br /><br />and the query from<br /><br />https://github.com/FreeRADIUS/freeradius-server/blob/master/raddb/mods-config/sql/main/mssql/queries.conf<br /><br />by the way i had to modified the query.conf file because there is an error in variable NASPortId column, it is called from query.conf by NASPort , anyway my problem is the radacct table is not registering info like, acctstoptime, acctsessiontime and others<br /><br />I am wondering if can i use the mysql query file to achieve this? (obviously, making a little changes into querys )<br /><br />for example i've put the postauth definition from mysql on mssql and it works.<br /> </p><p>before always i've used freeradius + mysql and accounting is fine, unfortunately at this time i have to use MSSQL like backend, is not my fault ;)</p><p><br />regards<br />pablou</p>
</body>
</html>