Re: (RADIATOR) Microsoft Access problems
On Jul 19, 2:58pm, Arnie Roberts wrote: > Subject: RE: (RADIATOR) Microsoft Access problems > On Monday, July 19, 1999 12:58 PM, Arnie Roberts [SMTP:[EMAIL PROTECTED]] wrote: > > On Tuesday, July 20, 1999 3:44 AM, Mike McCauley [SMTP:[EMAIL PROTECTED]] wrote: > > > Hi Arnie, > > > what is the data tpe of your TimeStamp column in Access? > > > > > > I have just been experimenting with an Access database where the Timestamp > > > column was a 'Number' (ie an int in SQL talk) with no problem . > > > > > > Cheers. > > > > > Hi Mike, > > > > I've tried Number and Text with no success. I will scratch the database and re-create with > > TimeStamp field as Number and let you know. > > > > Thanks > > > > Arnie > > > > > > > > > I've just figured this out. > Re-creating the table didn't work! > In desperation I renamed the field title to StartTime and it worked!!! > Presumably "TimeStamp" is a reserved name in Access and I was lucky enough to choose it. > Mike did you use TimeStamp or some other name? I used TIME_STAMP I see there is a mention of 'Timstamp' being a problem column name for MS-Access in the Radiator FAQ. I will be bundling an example radius.mdb that will work with the example sql.cfg in the next release. Anyone interested in it in the meantime? It includes a couple of example queries and charts too. Just a starting point really. Sure would be nice if an interested party fleshed it out and contributed it back! Cheers. -- Mike McCauley [EMAIL PROTECTED] Open System Consultants Pty. LtdUnix, Perl, Motif, C++, WWW 24 Bateman St Hampton, VIC 3188 Australia http://www.open.com.au Phone +61 3 9598-0985 Fax +61 3 9598-0955 Radiator: the most portable, flexible and configurable RADIUS server anywhere. SQL, proxy, DBM, files, LDAP, NIS+, password, NT, Emerald, Platypus, Freeside, TACACS+, PAM, external, etc etc on Unix, Win95/8, NT, Rhapsody === Archive at http://www.thesite.com.au/~radiator/ To unsubscribe, email '[EMAIL PROTECTED]' with 'unsubscribe radiator' in the body of the message.
RE: (RADIATOR) Microsoft Access problems
On Monday, July 19, 1999 12:58 PM, Arnie Roberts [SMTP:[EMAIL PROTECTED]] wrote: > On Tuesday, July 20, 1999 3:44 AM, Mike McCauley [SMTP:[EMAIL PROTECTED]] wrote: > > Hi Arnie, > > what is the data tpe of your TimeStamp column in Access? > > > > I have just been experimenting with an Access database where the Timestamp > > column was a 'Number' (ie an int in SQL talk) with no problem . > > > > Cheers. > > > Hi Mike, > > I've tried Number and Text with no success. I will scratch the database and >re-create with > TimeStamp field as Number and let you know. > > Thanks > > Arnie > > > I've just figured this out. Re-creating the table didn't work! In desperation I renamed the field title to StartTime and it worked!!! Presumably "TimeStamp" is a reserved name in Access and I was lucky enough to choose it. Mike did you use TimeStamp or some other name? Thanks for your help. Arnie === Archive at http://www.thesite.com.au/~radiator/ To unsubscribe, email '[EMAIL PROTECTED]' with 'unsubscribe radiator' in the body of the message.
RE: (RADIATOR) Microsoft Access problems
On Tuesday, July 20, 1999 3:44 AM, Mike McCauley [SMTP:[EMAIL PROTECTED]] wrote: > Hi Arnie, > what is the data tpe of your TimeStamp column in Access? > > I have just been experimenting with an Access database where the Timestamp > column was a 'Number' (ie an int in SQL talk) with no problem . > > Cheers. > Hi Mike, I've tried Number and Text with no success. I will scratch the database and re-create with TimeStamp field as Number and let you know. Thanks Arnie === Archive at http://www.thesite.com.au/~radiator/ To unsubscribe, email '[EMAIL PROTECTED]' with 'unsubscribe radiator' in the body of the message.
RE: (RADIATOR) Microsoft Access problems
On Sunday, July 18, 1999 1:36 AM, Aaron Miles [SMTP:[EMAIL PROTECTED]]
wrote:
> Arnie,
> Try no ' marks for the numbers as they are not needed, this
> could be even if the output field is text. Try this anyway :-)
>
>
> Cheers.
> Aaron
Aaron,
Do you mean have timestamp set as an integer? as in
AcctColumnDef TimeStamp,Timestamp,integer
problem stays the same
DBD::ODBC::db do failed: [Microsoft][ODBC Microsoft Access 97 Driver] Syntax err
or in INSERT INTO statement. (SQL-37000)(DBD: st_prepare/SQLPrepare err=-1) at R
adius/SqlDb.pm line 189.
Mon Jul 19 12:10:25 1999: ERR: do failed for 'insert into Users199907
(UserName, NasIPAddress, InputOctets, ServiceType, OutputOctets,
SessionTime, TimeStamp)
values
('test', '193.129.12.232', 134, 'Framed-User', 132, 50, 93238262
3)': [Microsoft][ODBC Microsoft Access 97 Driver] Syntax error in INSERT INTO st
atement. (SQL-37000)(DBD: st_prepare/SQLPrepare err=-1)
Is anyone using Access successfully and including the Timestamp?
Arnie
===
Archive at http://www.thesite.com.au/~radiator/
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.
Re: (RADIATOR) Microsoft Access problems
Hi Arnie,
what is the data tpe of your TimeStamp column in Access?
I have just been experimenting with an Access database where the Timestamp
column was a 'Number' (ie an int in SQL talk) with no problem .
Cheers.
On Jul 19, 12:37pm, Arnie Roberts wrote:
> Subject: RE: (RADIATOR) Microsoft Access problems
> On Sunday, July 18, 1999 1:36 AM, Aaron Miles
[SMTP:[EMAIL PROTECTED]] wrote:
> > Arnie,
> > Try no ' marks for the numbers as they are not needed, this
> > could be even if the output field is text. Try this anyway :-)
> >
> >
> > Cheers.
> > Aaron
>
> Aaron,
>
> Do you mean have timestamp set as an integer? as in
>
> AcctColumnDef TimeStamp,Timestamp,integer
>
> problem stays the same
>
> DBD::ODBC::db do failed: [Microsoft][ODBC Microsoft Access 97 Driver] Syntax
err
> or in INSERT INTO statement. (SQL-37000)(DBD: st_prepare/SQLPrepare err=-1)
at R
> adius/SqlDb.pm line 189.
> Mon Jul 19 12:10:25 1999: ERR: do failed for 'insert into Users199907
> (UserName, NasIPAddress, InputOctets, ServiceType,
OutputOctets,
> SessionTime, TimeStamp)
> values
> ('test', '193.129.12.232', 134, 'Framed-User', 132, 50,
93238262
> 3)': [Microsoft][ODBC Microsoft Access 97 Driver] Syntax error in INSERT INTO
st
> atement. (SQL-37000)(DBD: st_prepare/SQLPrepare err=-1)
>
> Is anyone using Access successfully and including the Timestamp?
>
> Arnie
>
>
> ===
> Archive at http://www.thesite.com.au/~radiator/
> To unsubscribe, email '[EMAIL PROTECTED]' with
> 'unsubscribe radiator' in the body of the message.
>-- End of excerpt from Arnie Roberts
--
Mike McCauley [EMAIL PROTECTED]
Open System Consultants Pty. LtdUnix, Perl, Motif, C++, WWW
24 Bateman St Hampton, VIC 3188 Australia http://www.open.com.au
Phone +61 3 9598-0985 Fax +61 3 9598-0955
Radiator: the most portable, flexible and configurable RADIUS server
anywhere. SQL, proxy, DBM, files, LDAP, NIS+, password, NT, Emerald,
Platypus, Freeside, TACACS+, PAM, external, etc etc on Unix, Win95/8,
NT, Rhapsody
===
Archive at http://www.thesite.com.au/~radiator/
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.
(RADIATOR) Microsoft Access problems
On Friday, July 16, 1999 9:36 AM, Arnie Roberts [SMTP:[EMAIL PROTECTED]] wrote:
> Couldn't find output table 'Users199907'. (SQL-S0002)(DBD: st_execute/SQLExecute
>err=-1)
I've solved this. The answer was the obvious one - the tables were indeed not there.
How they
got deleted I don't know but on re-creating the table this morning I have made much
progress.
Apologies for my stupidity.
I am now unable to log the Timestamp for the accounting request.
If I have
AccountingTable Users%Y%m
AcctColumnDef UserName,User-Name
# AcctColumnDef TimeStamp,Timestamp
AcctColumnDef CLI,Calling-Station-Id
AcctColumnDef ServiceType,Service-Type
AcctColumnDef SessionTime,Acct-Session-Time,integer
AcctColumnDef InputOctets,Acct-Input-Octets,integer
AcctColumnDef OutputOctets,Acct-Output-Octets,integer
AcctColumnDef TerminateCause,Acct-Terminate-Cause
AcctColumnDef NasIPAddress,NAS-IP-Address
then no problem - everything works fine. If I delete the # for Timestamp then I get
DBD::ODBC::db do failed: [Microsoft][ODBC Microsoft Access 97 Driver] Syntax err
or in INSERT INTO statement. (SQL-37000)(DBD: st_prepare/SQLPrepare err=-1) at R
adius/SqlDb.pm line 189.
Fri Jul 16 11:29:06 1999: ERR: do failed for 'insert into Users199907
(UserName, NasIPAddress, InputOctets, OutputOctets, SessionTime,
ServiceType, TimeStamp)
values
('testuser', '193.129.12.232', 283, 165, 225, 'Framed-User', '93
2120944')': [Microsoft][ODBC Microsoft Access 97 Driver] Syntax error in INSERT
INTO statement. (SQL-37000)(DBD: st_prepare/SQLPrepare err=-1)
Fri Jul 16 11:29:07 1999: DEBUG: Handling with Radius::AuthFILE
The detail file shows
Fri Jul 16 11:29:07 1999
User-Name = "testuser"
NAS-IP-Address = 193.129.12.232
Service-Type = Framed-User
Acct-Status-Type = Stop
Acct-Input-Octets = 283
Acct-Output-Octets = 165
Acct-Session-Id = "0001"
Acct-Session-Time = 225
Timestamp = 932120944
I've tried changing the TimeStamp table column Data Type between number and text
formats but
the problem is the same.
Any ideas anyone please?
thanks
Arnie
===
Archive at http://www.thesite.com.au/~radiator/
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.
(RADIATOR) Microsoft Access problems
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
AuthByPolicy ContinueAlways
AuthSelect
DBSource dbi:ODBC:radacctlog
DBUsername user
DBAuth access
AccountingTable Users%Y%m
AcctColumnDef UserName,User-Name
...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.
