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.
