(RADIATOR) Redback SMS and NASPort

[Hugh Irvine]

Hello Rami -

This is a problem with the database table definitions. The column defined for 
"NASPORT" cannot accept a value of "03841982464". It will have to be 
redefined (possibly as a string) to be able to accept the value.

regards

Hugh


On Thu, 2 May 2002 19:36, Rami Yaseen wrote:
> Hi,
>
> I am a network engineer specialist in Redback SMS, and currently preparing
> for installation of one box at an ISP site.
>
> The ISP is using Radiator as Radius, and I have conducted some tests before
> going live but I got the following error message
> whenever I use Radiator to authenticate the Dial-up users.
>
> Can you help please,
>
>
> DBD::ODBC::db do failed: [Microsoft][ODBC SQL Server Driver][SQL
> Server]Arithmet
> ic overflow error converting numeric to type int. (SQL-22003)(DBD:
> st_prepare/SQ
> LPrepare err=-1) at Radius/SqlDb.pm line 247.
> Wed May 29 15:41:41 2002: ERR: do failed for 'delete from RADONLINE where
> NASIDE
> NTIFIER='212.81.32.15' and NASPORT=03841982464': [Microsoft][ODBC SQL
> Server Dri
> ver][SQL Server]Arithmetic overflow error converting numeric to type int.
> (SQL-2
> 2003)(DBD: st_prepare/SQLPrepare err=-1)
> DBD::ODBC::db do failed: [Microsoft][ODBC SQL Server Driver][SQL
> Server]Arithmet
> ic overflow error converting numeric to type int. (SQL-22003)(DBD:
> st_prepare/SQ
> LPrepare err=-1) at Radius/SqlDb.pm line 247.
> Wed May 29 15:41:41 2002: ERR: do failed for 'delete from RADONLINE where
> NASIDE
> NTIFIER='212.81.32.15'  and NASPORT=03841982464': [Microsoft][ODBC SQL
> Server Dri
> ver][SQL Server]Arithmetic overflow error converting numeric to type int.
> (SQL-2
> 2003)(DBD: st_prepare/SQLPrepare err=-1)
>
> Best Regards

-- 
Radiator: the most portable, flexible and configurable RADIUS server
anywhere. Available on *NIX, *BSD, Windows 95/98/2000, NT, MacOS X.
-
Nets: internetwork inventory and management - graphical, extensible,
flexible with hardware, software, platform and database independence.
===
Archive at http://www.open.com.au/archives/radiator/
Announcements on radiator-announce at open.com.au
To unsubscribe, email 'majordomo at open.com.au' with
'unsubscribe radiator' in the body of the message.