[prev in list] [next in list] [prev in thread] [next in thread]
List: freeradius-users
Subject: Re: Cannot insert duplicate key row in object 'dbo.radacct' with unique index 'AcctUniqueId'
From: Alan DeKok <aland () deployingradius ! com>
Date: 2014-06-27 12:24:08
Message-ID: 53AD6268.1010704 () deployingradius ! com
[Download RAW message or body]
info Redlibre wrote:
> 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
>
> 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....
That seems clear.
> the problem is the radacct table is not registering info like,
> acctstoptime, acctsessiontime and others, only acctstarttime
The raddacct table doesn't invent information. It gets information
from accounting packets. So... the accounting packets don't have the
information you're looking for.
> i'm using the following schema
>
> https://github.com/FreeRADIUS/freeradius-server/blob/master/raddb/mods-config/sql/main/mssql/schema.sql
>
> and the query from
>
> https://github.com/FreeRADIUS/freeradius-server/blob/master/raddb/mods-config/sql/main/mssql/queries.conf
>
That's really not recommended. The code in v2 is VERY different from
v3. You MUST use the v2 schema and queries with v2.
> I am wondering if can i use the mysql query file to achieve this?
> (obviously, making a little changes into querys )
Using queries intended for other SQL servers is completely wrong.
Alan DeKok.
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic