ODBC: SQLExecDirect Error:
[Microsoft][ODBC SQL Server Driver][SQL Server]Violation of PRIMARY KEY
constraint 'pk_Calls': Attempt to insert duplicate key in object
'Calls'.
Response Time: 266
radrecv: Request from host 7f000001 code=1, id=1, length=0
NAS-Identifier = 127.0.0.1
NAS-Port = 0
User-Name = "hello"
Password = "(\342\250\331#\013\320-\275\030\357\005;\300\267\271"
rad_authenticate_ODBC()
Password = "(\342\250\331#\013\320-\275\030\357\005;\300\267\271"
Decrypted Password: hellos
Allocating Statement...
SQL Statement: Select DateAdd(Day, (ma.extension + ma.overdue),
maExpireDate), DateAdd(Day, sa.extension, saExpireDate), sa.AccountID,
sa.AccountType, sa.Password, sa.Login, sa.Shell From MasterAccounts ma,
SubAccounts sa Where (sa.Login='hello' or sa.Shell='hello') AND
ma.CustomerID=sa.CustomerID
and sa.Active<>0 and ma.Active<>0
Database Password: hellos
Freeing SQL Statement...
Allocating Statement...
SQL Statement: Select ra.RadAttributeID, Name, Data, Value, Type From
RadConfigs rc, RadAttributes ra Where
ra.RadAttributeID=rc.RadAttributeID AND rc.AccountID=9
Freeing SQL Statement...
Loading radius defaults for this type...
Allocating Statement...
Allocating Statement...
SQL Statement: Select ra.RadAttributeID, Name, Data, Value, Type From
RadATConfigs rc, RadAttributes ra Where
ra.RadAttributeID=rc.RadAttributeID AND rc.AccountType='PPP'
User-Service = 2 (2)
Framed-Protocol = 1 (1)
Freeing SQL Statement...
Sending Ack of id 1 to 7f000001 (localhost)
User-Service = Framed-User
Framed-Protocol = PPP
Response Time: 375
^C
Dale E. Reed Jr. wrote:
>
> On Mon, 31 Mar 1997, Philip Thomas wrote:
>
> > > This is just accounting. What about the authentication
> > > attempts RadiusNT receives? Don't worry about the
> > > above unless its happening alot. Post the Auth attempt
> > > from -x15 and we can see whats wrong.
>
> > radrecv: Request from host d0cb4b05 code=4, id=70, length=113
> > Acct-Session-Id = "1A00001D"
> > User-Name = "phil"
> > NAS-Identifier = 208.203.75.5
> > NAS-Port = 1
> > NAS-Port-Type = Async
> > Acct-Status-Type = Start
> > Acct-Authentic = Local
> > NAS-Port-DNIS = "8260470"
> > Caller-Id = "\200\2037029728923"
> > User-Service = Framed-User
> > Framed-Protocol = PPP
> > Framed-Address = 208.203.75.212
> > Acct-Delay-Time = 5670
> > Allocating Statement...
>
> This is STILL accounting. Authentication will have the
> Password = "" attribute in it.
>
> Dale
>
> ----------------------------------------------------------
> RadiusNT Mailing List listserver@emerald.iea.com