Re: [Emerald] failed radius attempts not showing up

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

Messages sorted by: [ date ][ thread ][ subject ][ author ]
Previous message: Kenneth D. Lenox: "[Emerald] Vircom Mail Server"
Next message: David Moore: "[Emerald] TS Graph"
Maybe in reply to: Ben Conner: "[Emerald] failed radius attempts not showing up"

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. www.iea-software.com

For more information about this list, including removal,please see http://www.iea-software.com/maillist.html

Previous message: Kenneth D. Lenox: "[Emerald] Vircom Mail Server"
Next message: David Moore: "[Emerald] TS Graph"
Maybe in reply to: Ben Conner: "[Emerald] failed radius attempts not showing up"