You say, "everything works fine...". Looking at your Calls table in the
database, are there any entries in the "Username" column? Or are they just
NULL?
Dave
On Monday, November 22, 1999 2:24 PM, Kelly Hamlin
[SMTP:[EMAIL PROTECTED]] wrote:
> Im using Ascend 6000 series NAS's and im using radiator to authenticate
off
> the platypus database, everything works fine, cept i get a lot of errors
in
> the window. Im using the ascend dictionary file and below i have my
config
> and below that, are the errors im getting in log window.
> Any help would be great!! thanks..
> ---config---
>
> Foreground
> LogStdout
> LogDir .
> DbDir .
>
>
> # You will probably want to change this to suit your site.
> <Client DEFAULT>
> Secret mysecret
> DupInterval 0
> </Client>
>
> <Client 209.xx.xxx.xx>
> Secret xxxxxxxx
> </Client>
>
> <Client 209.xx.xxx.xx>
> Secret xxxxxxxxx
> </Client>
> <Realm DEFAULT>
> <AuthBy EMERALD>
> DBSource dbi:ODBC:Platypus
> DBUsername xxxxxx
> DBAuth xxxxxxxx
> # You can add to or change these if you want.
> AccountingTable Calls
> AcctColumnDef UserName,User-Name
> AcctColumnDef CallDate,Timestamp,integer-date
> AcctColumnDef AcctStatusType,Acct-Status-Type,integer
> AcctColumnDef AcctDelayTime,Acct-Delay-Time,integer
> AcctColumnDef AcctInputOctets,Acct-Input-Octets,integer
> AcctColumnDef AcctOutputOctets,Acct-Output-Octets,integer
> AcctColumnDef AcctSessionId,Acct-Session-Id
> AcctColumnDef AcctSessionTime,Acct-Session-Time,integer
> AcctColumnDef AcctTerminateCause,Ascend-Disconnect-Cause ,integer
> AcctColumnDef NASIdentifier,NAS-Identifier
> AcctColumnDef NASIdentifier,NAS-IP-Address
> AcctColumnDef NASPort,NAS-Port,integer
> TimeBanking
> # AuthSelect ,sa.maxsessions
> # AuthColumnDef 0,Simultaneous-Use,check
> </AuthBy>
> </Realm>
> ---/Config----
> ---Errors---
> C:\Radiator>perl radiusd -config_file emerald.cfg
> DBD::ODBC::db do failed: [Microsoft][ODBC SQL Server Driver][SQL
> Server]Cannot i
> nsert the value NULL into column 'UserName', table 'platypus.dbo.Calls';
> column
> does not allow nulls. INSERT fails. (SQL-23000)
> [Microsoft][ODBC SQL Server Driver][SQL Server]The statement has been
> terminated
> . (SQL-01000)(DBD: st_execute/SQLExecute err=-1) at Radius/SqlDb.pm line
> 228.
> Mon Nov 22 14:05:56 1999: ERR: do failed for 'insert into Calls
> (CallDate, AcctStatusType, AcctDelayTime, AcctSessionId,
> NASIden
> tifier)
> values
> ('Nov 22, 1999 14:5', 7, 0, '919990609',
'209.26.171.130')':
> [Mi
> crosoft][ODBC SQL Server Driver][SQL Server]Cannot insert the value NULL
> into co
> lumn 'UserName', table 'platypus.dbo.Calls'; column does not allow nulls.
> INSERT
> fails. (SQL-23000)
> [Microsoft][ODBC SQL Server Driver][SQL Server]The statement has been
> terminated
> . (SQL-01000)(DBD: st_execute/SQLExecute err=-1)
> DBD::ODBC::db do failed: [Microsoft][ODBC SQL Server Driver][SQL
> Server]Cannot i
> nsert the value NULL into column 'UserName', table 'platypus.dbo.Calls';
> column
> does not allow nulls. INSERT fails. (SQL-23000)
> [Microsoft][ODBC SQL Server Driver][SQL Server]The statement has been
> terminated
> . (SQL-01000)(DBD: st_execute/SQLExecute err=-1) at Radius/SqlDb.pm line
> 228.
> Mon Nov 22 14:05:57 1999: ERR: do failed for 'insert into Calls
> (CallDate, AcctStatusType, AcctDelayTime, AcctSessionId,
> NASIden
> tifier)
> values
> ('Nov 22, 1999 14:5', 7, 0, '919990609',
'209.26.171.130')':
> [Mi
> crosoft][ODBC SQL Server Driver][SQL Server]Cannot insert the value NULL
> into co
> lumn 'UserName', table 'platypus.dbo.Calls'; column does not allow nulls.
> INSERT
> fails. (SQL-23000)
> [Microsoft][ODBC SQL Server Driver][SQL Server]The statement has been
> terminated
> . (SQL-01000)(DBD: st_execute/SQLExecute err=-1)
> Mon Nov 22 14:06:17 1999: ERR: Attribute number 62 (vendor ) is not
defined
> in y
> our dictionary
> Mon Nov 22 14:06:20 1999: ERR: Attribute number 62 (vendor ) is not
defined
> in y
> our dictionary
> Mon Nov 22 14:06:23 1999: ERR: Attribute number 62 (vendor ) is not
defined
> in y
> our dictionary
> DBD::ODBC::db do failed: [Microsoft][ODBC SQL Server Driver][SQL
> Server]Cannot i
> nsert the value NULL into column 'UserName', table 'platypus.dbo.Calls';
> column
> does not allow nulls. INSERT fails. (SQL-23000)
> [Microsoft][ODBC SQL Server Driver][SQL Server]The statement has been
> terminated
> . (SQL-01000)(DBD: st_execute/SQLExecute err=-1) at Radius/SqlDb.pm line
> 228.
> Mon Nov 22 14:06:29 1999: ERR: do failed for 'insert into Calls
> (CallDate, AcctStatusType, AcctDelayTime, AcctSessionId,
> NASIden
> tifier)
> values
> ('Nov 22, 1999 14:6', 7, 0, '919991612', '209.26.171.1
38')':
> [Mi
> crosoft][ODBC SQL Server Driver][SQL Server]Cannot insert the value NULL
> into co
> lumn 'UserName', table 'platypus.dbo.Calls'; column does not allow nulls.
> INSERT
> fails. (SQL-23000)
> [Microsoft][ODBC SQL Server Driver][SQL Server]The statement has been
> terminated
> . (SQL-01000)(DBD: st_execute/SQLExecute err=-1)
> DBD::ODBC::db do failed: [Microsoft][ODBC SQL Server Driver][SQL
> Server]Cannot i
> nsert the value NULL into column 'UserName', table 'platypus.dbo.Calls';
> column
> does not allow nulls. INSERT fails. (SQL-23000)
> [Microsoft][ODBC SQL Server Driver][SQL Server]The statement has been
> terminated
> . (SQL-01000)(DBD: st_execute/SQLExecute err=-1) at Radius/SqlDb.pm line
> 228.
> Mon Nov 22 14:06:29 1999: ERR: do failed for 'insert into Calls
> (CallDate, AcctStatusType, AcctDelayTime, AcctSessionId,
> NASIden
> tifier)
> values
> ('Nov 22, 1999 14:6', 7, 0, '919991612', '209.26.171.1
38')':
> [Mi
> crosoft][ODBC SQL Server Driver][SQL Server]Cannot insert the value NULL
> into co
> lumn 'UserName', table 'platypus.dbo.Calls'; column does not allow nulls.
> INSERT
> fails. (SQL-23000)
> [Microsoft][ODBC SQL Server Driver][SQL Server]The statement has been
> terminated
> . (SQL-01000)(DBD: st_execute/SQLExecute err=-1)
> Mon Nov 22 14:06:31 1999: ERR: Attribute number 62 (vendor ) is not
defined
> in y
> our dictionary
> DBD::ODBC::db do failed: [Microsoft][ODBC SQL Server Driver][SQL
> Server]Cannot i
> nsert the value NULL into column 'UserName', table 'platypus.dbo.Calls';
> column
> does not allow nulls. INSERT fails. (SQL-23000)
> [Microsoft][ODBC SQL Server Driver][SQL Server]The statement has been
> terminated
> . (SQL-01000)(DBD: st_execute/SQLExecute err=-1) at Radius/SqlDb.pm line
> 228.
> Mon Nov 22 14:06:34 1999: ERR: do failed for 'insert into Calls
> (CallDate, AcctStatusType, AcctDelayTime, AcctSessionId,
> AcctTer
> minateCause, NASIdentifier, NASPort)
> values
> ('Nov 22, 1999 14:6', 2, 0, '294548961', 101,
> '209.26.171.130',
> 10122)': [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot insert the
> value
> NULL into column 'UserName', table 'platypus.dbo.Calls'; column does not
> allow n
> ulls. INSERT fails. (SQL-23000)
> [Microsoft][ODBC SQL Server Driver][SQL Server]The statement has been
> terminated
> . (SQL-01000)(DBD: st_execute/SQLExecute err=-1)
> DBD::ODBC::db do failed: [Microsoft][ODBC SQL Server Driver][SQL
> Server]Cannot i
> nsert the value NULL into column 'UserName', table 'platypus.dbo.Calls';
> column
> does not allow nulls. INSERT fails. (SQL-23000)
> [Microsoft][ODBC SQL Server Driver][SQL Server]The statement has been
> terminated
> . (SQL-01000)(DBD: st_execute/SQLExecute err=-1) at Radius/SqlDb.pm line
> 228.
> Mon Nov 22 14:06:35 1999: ERR: do failed for 'insert into Calls
> (CallDate, AcctStatusType, AcctDelayTime, AcctSessionId,
> AcctTer
> minateCause, NASIdentifier, NASPort)
> values
> ('Nov 22, 1999 14:6', 2, 0, '294548961', 101,
> '209.26.171.130',
> 10122)': [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot insert the
> value
> NULL into column 'UserName', table 'platypus.dbo.Calls'; column does not
> allow n
> ulls. INSERT fails. (SQL-23000)
> [Microsoft][ODBC SQL Server Driver][SQL Server]The statement has been
> terminated
> . (SQL-01000)(DBD: st_execute/SQLExecute err=-1)
> Mon Nov 22 14:06:44 1999: ERR: Attribute number 62 (vendor ) is not
defined
> in y
> our dictionary
> ---/Errors---
>
> Though tyhis is probably a sql/platypus problem i thought some one might
> have had this or a similar problem, thanks
>
> Kelly Hamlin
> [EMAIL PROTECTED]
> Network Administrator
> (941) 332.4900
> http://www.neosmart.com
>
>
> ===
> Archive at http://www.thesite.com.au/~radiator/
> To unsubscribe, email '[EMAIL PROTECTED]' with
> 'unsubscribe radiator' in the body of the message.
===
Archive at http://www.thesite.com.au/~radiator/
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.
