Re: [Emerald] ODBC Error 22001:8152

Eric ( ejensen@accnorwalk.com )
Sat, 04 Mar 2000 17:04:57 -0500

--=====================_19692995==_.ALT
Content-Type: text/plain; charset="us-ascii" format=flowed

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.

>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,'440
> 00 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
--=====================_19692995==_.ALT
Content-Type: text/html; charset="us-ascii"

Here is a capture of what is going on. Yes we do use proxy server tostrip out the "@domain.com" from login of the few users thatauthenticate with their email address.

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 TermReq"
    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,'44000LAPM/V42BIS',65198,257727,1,2,1,'209.45.192.224',224)

ODBC Error:22001:8152:
 [Microsoft][ODBC SQL Server Driver][SQL Server]String or binarydata 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 runRadius our
> logfile fills up with and ODBC Error "String or Binary Datawould be
> truncated." What does this mean and how do we fix it. I havelooked 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 theupdate
> database in Emerald Admin, but still no fix. I did go in and changethe
> size of "Domain" and "MailDomain" in the Emeralddatabase to Vchar 35.
> Any help would be appreciated!


Run RadiusNT in -x15 debug mode, and capture the insertstatement/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
--=====================_19692995==_.ALT--