Hi all,
I have problems trying to get accounting working to an Access database using windows
95.
I have a System DSN of "radacctlog" representing an Access database which includes two
tables of the same structure, called UserAccess and Users199907.
My radius.cfg contains the following
<Realm>
AuthByPolicy ContinueAlways
<AuthBy SQL>
AuthSelect
DBSource dbi:ODBC:radacctlog
DBUsername user
DBAuth access
AccountingTable Users%Y%m
AcctColumnDef UserName,User-Name
</AuthBy>
<AuthBy FILE>
...etc
The trace of an accounting request shows -
Thu Jul 15 17:22:07 1999: DEBUG: Handling request with Handler 'Realm='
Thu Jul 15 17:22:07 1999: DEBUG: Handling with Radius::AuthSQL
Thu Jul 15 17:22:07 1999: DEBUG: Handling accounting with Radius::AuthSQL
Thu Jul 15 17:22:08 1999: DEBUG: do query is: insert into Users199907
(UserName)
values
('test1')
Thu Jul 15 17:22:09 1999: ERR: do failed for 'insert into Users199907
(UserName)
values
('test1')': [Microsoft][ODBC Microsoft Access 97 Driver]
Couldn't find output table 'Users199907'. (SQL-S0002)(DBD: st_execute/SQLExecute
err=-1)
Thu Jul 15 17:22:09 1999: DEBUG: Handling with Radius::AuthFILE
Thu Jul 15 17:22:09 1999: DEBUG: Deleting session for test1, 193.129.12.232,
Thu Jul 15 17:22:09 1999: DEBUG: Accounting accepted
Thu Jul 15 17:22:10 1999: DEBUG: Packet dump:
*** Sending to
etc., etc.
I get exactly the same result if I try AccountingTable UserAccess.
Apparently Radiator has connected to the database but what reason might
there be for it not finding the table?
thanks in advance
Arnie
===
Archive at http://www.thesite.com.au/~radiator/
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.