Re: [Emerald] ODBC Error 22001:8152
Eric ( ejensen@accnorwalk.com )
Sat, 04 Mar 2000 17:30:14 -0500
Ok, thanks Dale!
Thanks,
Eric Jensen
At 02:20 PM 3/4/2000 -0800, you wrote:
>Eric wrote:
> >
> > Here is a capture of what is going on. Yes we do use proxy server to
> > strip out the "@domain.com" from login of the few users that
> > authenticate with their email address.
>
>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,AcctSta
> tusType,AcctSessionTime,ConnectInfo,AcctInputOctets,AcctOutputOctets,AcctT
> erminateCause,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
Eric Jensen
Advanced Computer Connections, Inc.
9 West Main St.
Norwalk, Ohio 44857
(419) 668-4080
For more information about this list (including removal) go to:
http://www.iea-software.com/support/maillists/liststart