(RADIATOR) Inquiry

[Hugh Irvine]

Hello Dave -

It looks to me like the ACCTSESSIONID field is not big enough in your 
database. The standard SQL creation scripts that we supply set this field to 
30 characters, and the string that is shown below is over 30 characters long. 
Therefore you will need to make this field larger - perhaps 50 characters.

hth

Hugh


On Thursday 20 September 2001 20:45, dave_vill wrote:
> Sir,
>
>    I already have my radiator running, and still have error messages on the
> accounting process. I am using a MS SQL200 as my database and it seems that
> when radiator inserts the accounting information it then generate errors. I
> hope you can help me figure out a solution regarding this problem.
>
>    Pasted below is the error message that was generated.
>
> regards,
> dave
>
>
>
> ERROR MESSAGES:
>
> Thu Sep 20 18:26:10 2001: ERR: do failed for 'insert into ACCOUNTING
> 		(USERNAME, TIME_STAMP, ACCTSTATUSTYPE, ACCTDELAYTIME, ACCTSESSIONID,
> NASIDENTIFIER, NASPORT, FRAMEDIPADDRESS) values
> 		('supercom', '1000981559', 'Start', '9', 'erx fastEthernet
> 1/0::0000028337', 'ERX-Makati', '268435456', '202.58.241.30')':
> [Microsoft][ODBC SQL Server Driver][SQL Server]String or binary data would
> be truncated. (SQL-22001) [Microsoft][ODBC SQL Server Driver][SQL
> Server]The statement has been terminated. (SQL-01000)(DBD:
> st_execute/SQLExecute
>
>
>
>
>
>
> , , 001029200011 ,
> e-mail: davevill at cdo.philcom.com.ph
>
>
> --
> Do you VisualMail?
>
> Grab a copy of the best WebMailer right now!
>
> http://www.mintersoft.com/visualmail
>
>
> ===
> 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.

-- 
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.