Hi Hugh, I have changed the field data type to numeric and it's working fine now.
As I told you in the previous e-mail that I am working with Redback SMS, but whe I opened the default dictionary our installed Radiator uses I didn't see any attribute related to redback. Because of this the Raddiator couldn't recognize SMS attribute and the process didn't continue. Would you help us how we can update the default dictionary so that it read Redback attributes, Best Regards -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Hugh Irvine Sent: Monday, June 03, 2002 12:26 AM To: Rami Yaseen; [EMAIL PROTECTED] Subject: Re: (RADIATOR) Redback SMS and NASPort 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 [EMAIL PROTECTED] To unsubscribe, email '[EMAIL PROTECTED]' with 'unsubscribe radiator' in the body of the message. === Archive at http://www.open.com.au/archives/radiator/ Announcements on [EMAIL PROTECTED] To unsubscribe, email '[EMAIL PROTECTED]' with 'unsubscribe radiator' in the body of the message.
