Either Upgrade to 2.5.212 and see the changes.txt (ie, set Trimname to
3)
to trim the names off the accounting records
or
increase your username field to allow for the increased size.
> > radrecv: Request from host cf57dd0c code=4, id=217, length=185
> > Acct-Session-Id = "0D00BA10"
> > User-Name = "rwelch@accnorwalk.com"
> > NAS-Identifier = 207.87.221.12
> > NAS-Port = 20
> > NAS-Port-Type = Async
> > Acct-Status-Type = Stop
> > Acct-Session-Time = 487
> > Acct-Authentic = RADIUS
> > Connect-Info = "44000 LAPM/V42BIS"
> > Acct-Input-Octets = 65198
> > Acct-Output-Octets = 257727
> > Acct-Terminate-Cause = User-Request
> > LE-Terminate-Detail = "User Request - PPP Term Req"
> > User-Service = Framed-User
> > Framed-Protocol = PPP
> > Framed-Address = 209.45.192.224
> > Acct-Delay-Time = 224
> >
> > SQL Statement: INSERT INTO Calls
> > (CallDate,AcctSessionId,UserName,NASIdentifier,NASPort,NASPortType,AcctStatusType,AcctSessionTime,ConnectInfo,AcctInputOctets,AcctOutputOctets,AcctTerminateCause,UserService,FramedProtocol,FramedAddress,AcctDelayTime)
> > VALUES
> > (GetDate(),'0D00BA10','rwelch@accnorwalk.','207.87.221.12',20,0,2,487,'44000
> > LAPM/V42BIS',65198,257727,1,2,1,'209.45.192.224',224)
> >
> > ODBC Error:22001:8152:
> > [Microsoft][ODBC SQL Server Driver][SQL Server]String or binary
> > data would be truncated.
> >
> > Resp Time: 62 Auth: 0/0 -> 0 Acct: 3/1/0 -> 4
>
> Any thoughts?
>
> Thanks,
> Eric Jensen
>
> At 01:47 PM 3/4/2000 -0800, you wrote:
>
> > Eric wrote:
> > >
> > > We just upgraded to SQL7 and that went fine, but now when we run
> > Radius our
> > > logfile fills up with and ODBC Error "String or Binary Data would
> > be
> > > truncated." What does this mean and how do we fix it. I have
> > looked through
> > > the mail archives and only found a few instances of this problem,
> > but no
> > > fixes that worked. I have run the latest CheckDB.sql and run the
> > update
> > > database in Emerald Admin, but still no fix. I did go in and
> > change the
> > > size of "Domain" and "MailDomain" in the Emerald database to Vchar
> > 35.
> > > Any help would be appreciated!
> >
> >
> > Run RadiusNT in -x15 debug mode, and capture the insert
> > statement/error.
> > It should tell you what the problem is. If its accounting records,
> > it
> > might be AcctSessionID or username (if you are doing proxy).
> >
> > --
> >
> > Dale E. Reed Jr. Emerald and RadiusNT
> > __________________________________________
> > IEA Software, Inc. www.iea-software.com
> >
> > For more information about this list (including removal) go to:
> > http://www.iea-software.com/support/maillists/liststart
>
> Eric Jensen
> Advanced Computer Connections, Inc.
> 9 West Main St.
> Norwalk, Ohio 44857
> (419) 668-4080
--Dale E. Reed Jr. Emerald and RadiusNT__________________________________________IEA Software, Inc. www.iea-software.com
For more information about this list (including removal) go to:http://www.iea-software.com/support/maillists/liststart