Hello Adam -
What does the Access log file show?
thanks
Hugh
>
> I've installed Radiator and i'm using Microsoft Access as databse it =
> works fine on windows 2000 but it doesnt work on Windows NT4 service =
> pack 5 although i'm using same cfg file
>
> Can anybody help me please.
>
> Below is the logfile i get:
>
> Wed May 2 13:43:31 2001: INFO: Server started: Radiator 2.18 on graphics =
> (DEMO)
>
> Wed May 2 13:43:56 2001: DEBUG: Packet dump:
>
> *** Received from 127.0.0.1 port 1042 ....
>
> Code: Access-Request
>
> Identifier: 249
>
> Authentic: 1234567890123456
>
> Attributes:
>
> User-Name =3D "adam"
>
> Service-Type =3D Framed
>
> NAS-IP-Address =3D 203.63.154.1
>
> NAS-Port =3D 1234
>
> Called-Station-Id =3D "123456789"
>
> Calling-Station-Id =3D "987654321"
>
> NAS-Port-Type =3D Async
>
> User-Password =3D =
> "<200><185>l<153><175>\<4><246><188>8<9><160><216>}x<153>"
>
> Wed May 2 13:43:56 2001: DEBUG: Handling request with Handler 'Realm=3D'
>
> Wed May 2 13:44:02 2001: DEBUG: OnlineUsers Deleting session for adam, =
> 203.63.154.1, 1234
>
> Wed May 2 13:44:02 2001: DEBUG: do query is: delete from RADONLINE where =
> NASIDENTIFIER=3D'203.63.154.1' and NASPORT=3D01234
>
> Wed May 2 13:44:04 2001: ERR: do failed for 'delete from RADONLINE where =
> NASIDENTIFIER=3D'203.63.154.1' and NASPORT=3D01234': [Microsoft][ODBC =
> Microsoft Access Driver] Too few parameters. Expected 1. =
> (SQL-07001)(DBD: st_execute/SQLExecute err=3D-1)
>
> Wed May 2 13:44:06 2001: ERR: do failed for 'delete from RADONLINE where =
> NASIDENTIFIER=3D'203.63.154.1' and NASPORT=3D01234': [Microsoft][ODBC =
> Microsoft Access Driver] Too few parameters. Expected 1. =
> (SQL-07001)(DBD: st_execute/SQLExecute err=3D-1)
>
> Wed May 2 13:44:07 2001: DEBUG: Query is: select NASIDENTIFIER, NASPORT, =
> ACCTSESSIONID, FRAMEDIPADDRESS from RADONLINE where USERNAME=3D'adam'
>
> Wed May 2 13:44:07 2001: ERR: Execute failed for 'select NASIDENTIFIER, =
> NASPORT, ACCTSESSIONID, FRAMEDIPADDRESS from RADONLINE where =
> USERNAME=3D'adam'': [Microsoft][ODBC Microsoft Access Driver] Too few =
> parameters. Expected 3. (SQL-07001)(DBD: st_execute/SQLExecute err=3D-1)
>
> Wed May 2 13:44:08 2001: ERR: Execute failed for 'select NASIDENTIFIER, =
> NASPORT, ACCTSESSIONID, FRAMEDIPADDRESS from RADONLINE where =
> USERNAME=3D'adam'': [Microsoft][ODBC Microsoft Access Driver] Too few =
> parameters. Expected 3. (SQL-07001)(DBD: st_execute/SQLExecute err=3D-1)
>
> Wed May 2 13:44:09 2001: DEBUG: Handling with Radius::AuthSQL
>
> Wed May 2 13:44:09 2001: DEBUG: Handling with Radius::AuthSQL
>
> Wed May 2 13:44:10 2001: DEBUG: Query is: select Password from =
> Authentication where USERNAME=3D'adam'
>
> Wed May 2 13:44:10 2001: DEBUG: Radius::AuthSQL looks for match with =
> adam
>
> Wed May 2 13:44:11 2001: DEBUG: Radius::AuthSQL ACCEPT:=20
>
> Wed May 2 13:44:11 2001: DEBUG: Access accepted for adam
>
> Wed May 2 13:44:12 2001: DEBUG: Packet dump:
>
> *** Sending to 127.0.0.1 port 1042 ....
>
> Code: Access-Accept
>
> Identifier: 249
>
> Authentic: 1234567890123456
>
> Attributes:
>
> Service-Type =3D Framed
>
> Framed-Protocol =3D PPP
>
> Wed May 2 13:44:13 2001: DEBUG: Packet dump:
>
> *** Received from 127.0.0.1 port 1042 ....
>
> Code: Accounting-Request
>
> Identifier: 250
>
> Authentic: =
> <18><131><195>}<226><208><255><180><180>`F<134><227><202><128>D
>
> Attributes:
>
> User-Name =3D "adam"
>
> Service-Type =3D Framed
>
> NAS-IP-Address =3D 203.63.154.1
>
> NAS-Port =3D 1234
>
> NAS-Port-Type =3D Async
>
> Acct-Session-Id =3D "00001234"
>
> Acct-Status-Type =3D Start
>
> Called-Station-Id =3D "123456789"
>
> Calling-Station-Id =3D "987654321"
>
> Wed May 2 13:44:13 2001: DEBUG: Handling request with Handler 'Realm=3D'
>
> Wed May 2 13:44:13 2001: DEBUG: OnlineUsers Adding session for adam, =
> 203.63.154.1, 1234
>
> Wed May 2 13:44:13 2001: DEBUG: do query is: delete from RADONLINE where =
> NASIDENTIFIER=3D'203.63.154.1' and NASPORT=3D01234
>
> Wed May 2 13:44:14 2001: ERR: do failed for 'delete from RADONLINE where =
> NASIDENTIFIER=3D'203.63.154.1' and NASPORT=3D01234': [Microsoft][ODBC =
> Microsoft Access Driver] Too few parameters. Expected 1. =
> (SQL-07001)(DBD: st_execute/SQLExecute err=3D-1)
>
> Wed May 2 13:44:16 2001: ERR: do failed for 'delete from RADONLINE where =
> NASIDENTIFIER=3D'203.63.154.1' and NASPORT=3D01234': [Microsoft][ODBC =
> Microsoft Access Driver] Too few parameters. Expected 1. =
> (SQL-07001)(DBD: st_execute/SQLExecute err=3D-1)
>
> Wed May 2 13:44:16 2001: DEBUG: do query is: insert into RADONLINE =
> (USERNAME, NASIDENTIFIER) values ('adam', '203.63.154.1')
>
> Wed May 2 13:44:17 2001: DEBUG: Handling with Radius::AuthSQL
>
> Wed May 2 13:44:17 2001: DEBUG: Handling accounting with Radius::AuthSQL
>
> Wed May 2 13:44:17 2001: DEBUG: do query is: insert into Accounting
>
> (UserName, CallDate, AcctStatusType, AcctSessionId, NASIdentifier)=20
>
> values=20
>
> ('adam', 'May 2, 2001 13:44', 1, '00001234', '203.63.154.1')
>
> Wed May 2 13:44:17 2001: ERR: do failed for 'insert into Accounting
>
> (UserName, CallDate, AcctStatusType, AcctSessionId, NASIdentifier)=20
>
> values=20
>
> ('adam', 'May 2, 2001 13:44', 1, '00001234', '203.63.154.1')': =
> [Microsoft][ODBC Microsoft Access Driver] The INSERT INTO statement =
> contains the following unknown field name: 'UserName'. Make sure you =
> have typed the name correctly, and try the operation again. =
> (SQL-S0022)(DBD: st_execute/SQLExecute err=3D-1)
>
> Wed May 2 13:44:18 2001: ERR: do failed for 'insert into Accounting
>
> (UserName, CallDate, AcctStatusType, AcctSessionId, NASIdentifier)=20
>
> values=20
>
> ('adam', 'May 2, 2001 13:44', 1, '00001234', '203.63.154.1')': =
> [Microsoft][ODBC Microsoft Access Driver] The INSERT INTO statement =
> contains the following unknown field name: 'UserName'. Make sure you =
> have typed the name correctly, and try the operation again. =
> (SQL-S0022)(DBD: st_execute/SQLExecute err=3D-1)
>
> Wed May 2 13:44:18 2001: DEBUG: Accounting accepted
>
> Wed May 2 13:44:18 2001: DEBUG: Packet dump:
>
> *** Sending to 127.0.0.1 port 1042 ....
>
> Code: Accounting-Response
>
> Identifier: 250
>
> Authentic: =
> <18><131><195>}<226><208><255><180><180>`F<134><227><202><128>D
>
> Attributes:
>
> Wed May 2 13:44:18 2001: DEBUG: Packet dump:
>
> *** Received from 127.0.0.1 port 1042 ....
>
> Code: Accounting-Request
>
> Identifier: 251
>
> Authentic: <217>{er<192><24><164><237><158><29>Jx<227>"o<174>
>
> Attributes:
>
> User-Name =3D "adam"
>
> Service-Type =3D Framed
>
> NAS-IP-Address =3D 203.63.154.1
>
> NAS-Port =3D 1234
>
> NAS-Port-Type =3D Async
>
> Acct-Session-Id =3D "00001234"
>
> Acct-Status-Type =3D Stop
>
> Called-Station-Id =3D "123456789"
>
> Calling-Station-Id =3D "987654321"
>
> Acct-Delay-Time =3D 0
>
> Acct-Session-Time =3D 1000
>
> Acct-Input-Octets =3D 20000
>
> Acct-Output-Octets =3D 30000
>
> Wed May 2 13:44:18 2001: DEBUG: Handling request with Handler 'Realm=3D'
>
> Wed May 2 13:44:19 2001: DEBUG: OnlineUsers Deleting session for adam, =
> 203.63.154.1, 1234
>
> Wed May 2 13:44:19 2001: DEBUG: do query is: delete from RADONLINE where =
> NASIDENTIFIER=3D'203.63.154.1' and NASPORT=3D01234
>
> Wed May 2 13:44:20 2001: ERR: do failed for 'delete from RADONLINE where =
> NASIDENTIFIER=3D'203.63.154.1' and NASPORT=3D01234': [Microsoft][ODBC =
> Microsoft Access Driver] Too few parameters. Expected 1. =
> (SQL-07001)(DBD: st_execute/SQLExecute err=3D-1)
>
> Wed May 2 13:44:21 2001: ERR: do failed for 'delete from RADONLINE where =
> NASIDENTIFIER=3D'203.63.154.1' and NASPORT=3D01234': [Microsoft][ODBC =
> Microsoft Access Driver] Too few parameters. Expected 1. =
> (SQL-07001)(DBD: st_execute/SQLExecute err=3D-1)
>
> Wed May 2 13:44:21 2001: DEBUG: Handling with Radius::AuthSQL
>
> Wed May 2 13:44:22 2001: DEBUG: Handling accounting with Radius::AuthSQL
>
> Wed May 2 13:44:22 2001: DEBUG: do query is: insert into Accounting
>
> (UserName, CallDate, AcctStatusType, AcctDelayTime, AcctInputOctets, =
> AcctOutputOctets, AcctSessionId, AcctSessionTime, NASIdentifier)=20
>
> values=20
>
> ('adam', 'May 2, 2001 13:44', 2, 0, 20000, 30000, '00001234', 1000, =
> '203.63.154.1')
>
> Wed May 2 13:44:23 2001: ERR: do failed for 'insert into Accounting
>
> (UserName, CallDate, AcctStatusType, AcctDelayTime, AcctInputOctets, =
> AcctOutputOctets, AcctSessionId, AcctSessionTime, NASIdentifier)=20
>
> values=20
>
> ('adam', 'May 2, 2001 13:44', 2, 0, 20000, 30000, '00001234', 1000, =
> '203.63.154.1')': [Microsoft][ODBC Microsoft Access Driver] The INSERT =
> INTO statement contains the following unknown field name: 'UserName'. =
> Make sure you have typed the name correctly, and try the operation =
> again. (SQL-S0022)(DBD: st_execute/SQLExecute err=3D-1)
>
> Wed May 2 13:44:24 2001: ERR: do failed for 'insert into Accounting
>
> (UserName, CallDate, AcctStatusType, AcctDelayTime, AcctInputOctets, =
> AcctOutputOctets, AcctSessionId, AcctSessionTime, NASIdentifier)=20
>
> values=20
>
> ('adam', 'May 2, 2001 13:44', 2, 0, 20000, 30000, '00001234', 1000, =
> '203.63.154.1')': [Microsoft][ODBC Microsoft Access Driver] The INSERT =
> INTO statement contains the following unknown field name: 'UserName'. =
> Make sure you have typed the name correctly, and try the operation =
> again. (SQL-S0022)(DBD: st_execute/SQLExecute err=3D-1)
>
> Wed May 2 13:44:24 2001: DEBUG: Accounting accepted
>
> Wed May 2 13:44:24 2001: DEBUG: Packet dump:
>
> *** Sending to 127.0.0.1 port 1042 ....
>
> Code: Accounting-Response
>
> Identifier: 251
>
> Authentic: <217>{er<192><24><164><237><158><29>Jx<227>"o<174>
>
> Attributes:
>
--
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.starport.net/~radiator/
Announcements on [EMAIL PROTECTED]
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.
