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!
If anyone could helpme, as im a lil clueless when it comes to SQL... thanks
in advance
---- 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
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)
DDBD::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)
This is my config file
--
Foreground
LogStdout
LogDir .
DbDir .
# You will probably want to change this to suit your site.
<Client DEFAULT>
Secret mysecret
DupInterval 0
</Client>
<Realm DEFAULT>
<AuthBy EMERALD>
# Change DBSource, DBUsername, DBAuth for your database
# See the reference manual
DBSource dbi:ODBC:Platypus
DBUsername *******
DBAuth *******
AccountingTable Calls
AcctColumnDef UserName,User-Name
AcctColumnDef CallDate,Timestamp,integer-date
AcctColumnDef AcctStatusType,Acct-Status-Type,integer
AcctColumnDef AcctDelayTime,Acct-Delay-Time,integer
AcctColumnDef AcctInputOctets,Acct-Input-Octets,integer
AcctColumnDef AcctOutputOctets,Acct-Output-Octets,integer
AcctColumnDef AcctSessionId,Acct-Session-Id
AcctColumnDef AcctSessionTime,Acct-Session-Time,integer
AcctColumnDef AcctTerminateCause,Acct-Terminate-Cause,integer
AcctColumnDef NASIdentifier,NAS-Identifier
AcctColumnDef NASIdentifier,NAS-IP-Address
AcctColumnDef NASPort,NAS-Port,integer
TimeBanking
</AuthBy>
</Realm>
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.
