Re: [Emerald] failed radius attempts not showing up

Dale E. Reed Jr. ( (no email) )
Sat, 06 Mar 1999 22:52:04 -0800

Ben Conner wrote:
> What I'm seeing is:
> SQL Statement: INSERT INTO RadLogs(RadLogMsgID, LogDate, Username, Data,
> CallerID
> ) VALUES (14, GetDate(), 'ccarmichael', '1', '9495980426')
> ODBC Error:37000:260:
> [Microsoft][ODBC SQL Server Driver][SQL Server]Disallowed implicit conversion
> from datatype 'varchar' to datatype 'int'
> Table: 'Emerald.dbo.RadLogs', Column: 'CallerID'
> Use the CONVERT function to run this query.
> Looks like the radlogs table has callerid defined as an int(4) and Emerald is
> trying to put it in as character.
> This worked prior to going to 2.5.263. Could something have changed in there?
> More to the point, how can I fix this now?

There was an error in the RadiusNT update script that caused this. The
easiest way to change it is to rename your current CallerID field to
CallerID_OLD, and then create a new column named CallerID, varchar(12).


Dale E. Reed Jr. Emerald and RadiusNT__________________________________________IEA Software, Inc.

For more information about this list, including removal,please see