Hello Raymond -
Can you send us a trace 4 showing what is going on?
thanks
Hugh
On Fri, 24 Nov 2000, Raymond Brighenti wrote:
> Hi,
>
> I've had Radiator Auth/Acc to a MySQL database for a while now and
> everything's been fine timstamp wise, so I just thought I'd also
> use SessionDatabase SQL, I set up the table the same as the Accounting
> table but the date/time in the Radonline table is way out from the
> Accounting, just checking now the latest timestamp is 14/11/2000 5:05:12 AM
> when it should be about 24/11/2000 5:20 PM.
>
> Any ideas?
>
> </Client>
>
>
> <AuthBy SQL>
> Identifier SQL_Accounting
> DBSource dbi:mysql:table:555.555.555.555
> DBUsername
> DBAuth
>
> AcctColumnDef USERNAME,User-Name
> AcctColumnDef TIME_STAMP,Timestamp,integer
> AcctColumnDef ACCTSTATUSTYPE,Acct-Status-Type
> 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 NASIDENTIFIER,NAS-Identifier,string
> AcctColumnDef NASPORT,NAS-Port,integer
> AcctColumnDef CALLERID,Caller-Id,integer
> AcctColumnDef DISCONNECT,Ascend-Disconnect-Cause,integer
> AcctColumnDef CAUSE,Ascend-Connect-Progress,integer
> AcctColumnDef TXRATE,Ascend-Xmit-Rate,integer
> AcctColumnDef RXRATE,Ascend-Data-Rate,integer
> AcctColumnDef DNIS,Client-Port-DNIS,integer
> AcctColumnDef FRAMEDIPADDRESS,Framed-Address
> AcctColumnDef TIME_STAMP_NORM,Timestamp,formatted-date,'%Y/%m/%e %H:%M:%S'
>
> </AuthBy>
>
>
>
> <SessionDatabase SQL>
> # This database spec usually should be exactly the same
> # as in <AuthBy> above
> DBSource dbi:mysql:table:555.555.555.555
> DBUsername root
> DBAuth
>
> AddQuery insert into RADONLINE \
> (USERNAME, NASIDENTIFIER, NASPORT, ACCTSESSIONID, TIME_STAMP,
> FRAMEDIPADDRESS, CALLERID, DNIS) values \
> ('%n', '%N', %{NAS-Port}, '%{Acct-Session-Id}', %{Timestamp},
> '%{Framed-Address}', '%{Caller-Id}', '%{Client-Port-DNIS}')
>
> </SessionDatabase>
>
>
> ===
> 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.
--
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.
