Either Upgrade to 2.5.212 and see the changes.txt (ie, set Trimname to
to trim the names off the accounting records
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 = "firstname.lastname@example.org"
> > NAS-Identifier = 184.108.40.206
> > 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 = 220.127.116.11
> > 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.','18.104.22.168',20,0,2,487,'44000
> > LAPM/V42BIS',65198,257727,1,2,1,'22.214.171.124',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?
> 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