The errors aren't that strange -- you're inserting
rows with duplicate primary keys (or other constraints
which you've defined as unique). The constraint
is pk_Calls (primary key calls I'm guessing).
You should redefine your table's fields to not use
a primary key, select a different primary key that
is guaranteed to be unique, or use multiple
fields in your uniqueness constraint (ie: username,
framed address, timestamp).
At 02:02 PM 11/4/99 -0500, you wrote:
>Im using the default emerald.cfg file and i changed the odbc connection to
>point to the right thing.
>when i run perl radpwtst -user scttest -password scttest i get rejected and
>then ok and ok
>That username and password is correct.. and in the radiusd window open i get
>all kinds of strange odbc connection errors im guessing at leat thats what
>they are!
>
>---- CLIP---
> (UserName, CallDate, AcctStatusType, AcctDelayTime,
>AcctInputOct
>ets, AcctOutputOctets, AcctSessionId, AcctSessionTime, NASIdentifier,
>NASPort)
> values
> ('SCTTEST', 'Nov 4, 1999 13:40', 2, 0, 20000, 30000,
>'00001234',
> 1000, '203.63.154.1', 1234)': [Microsoft][ODBC SQL Server Driver][SQL
>Server]Vi
>olation of PRIMARY KEY constraint 'pk_Calls'. Cannot insert duplicate key in
>obj
>ect 'Calls'. (SQL-23000)
>[Microsoft][ODBC SQL Server Driver][SQL Server]The statement has been
>terminated
>. (SQL-01000)(DBD: st_execute/SQLExecute err=-1)
>DBD::ODBC::db do failed: [Microsoft][ODBC SQL Server Driver][SQL
>Server]Violatio
>n of PRIMARY KEY constraint 'pk_Calls'. Cannot insert duplicate key in
>object 'C
>alls'. (SQL-23000)
>[Microsoft][ODBC SQL Server Driver][SQL Server]The statement has been
>terminated
>. (SQL-01000)(DBD: st_execute/SQLExecute err=-1) at Radius/SqlDb.pm line
>228.
>Thu Nov 4 13:40:35 1999: ERR: do failed for 'insert into Calls
> (UserName, CallDate, AcctStatusType, AcctDelayTime,
>AcctInputOct
>ets, AcctOutputOctets, AcctSessionId, AcctSessionTime, NASIdentifier,
>NASPort)
> values
> ('SCTTEST', 'Nov 4, 1999 13:40', 2, 0, 20000, 30000,
>'00001234',
> 1000, '203.63.154.1', 1234)': [Microsoft][ODBC SQL Server Driver][SQL
>Server]Vi
>olation of PRIMARY KEY constraint 'pk_Calls'. Cannot insert duplicate key in
>obj
>ect 'Calls'. (SQL-23000)
>[Microsoft][ODBC SQL Server Driver][SQL Server]The statement has been
>terminated
>. (SQL-01000)(DBD: st_execute/SQLExecute err=-1)
>-----CLIP------
>
>Kelly Hamlin
>[EMAIL PROTECTED]
>Network Administrator
>(941) 332.4900
>http://www.neosmart.com
>
>
>===
>Archive at http://www.thesite.com.au/~radiator/
>To unsubscribe, email '[EMAIL PROTECTED]' with
>'unsubscribe radiator' in the body of the message.
===
Archive at http://www.thesite.com.au/~radiator/
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.
