(RADIATOR) Doesn't write sessiondb

[Kadir Saruhan]

Hi,
I have a problem while writing session db. You can see my config and
trace 4 debugging at below.
It doesn't write anything (there is no insert querry in debugging).

Debugging:
Mon Feb  7 00:00:00 2005: DEBUG: Handling request with Handler
'Realm=DEFAULT'
Mon Feb  7 00:00:00 2005: DEBUG: Rewrote user name to selmakozleme
Mon Feb  7 00:00:00 2005: DEBUG: Adding session for selmakozleme,
10.10.20.7, 6313
Mon Feb  7 00:00:00 2005: DEBUG: Handling with Radius::AuthSQL
Mon Feb  7 00:00:00 2005: DEBUG: Handling accounting with
Radius::AuthSQL
Mon Feb  7 00:00:00 2005: DEBUG: Accounting accepted
Mon Feb  7 00:00:00 2005: DEBUG: Packet dump:
*** Sending to 10.10.20.7 port 2048 ....

Config:

<Realm DEFAULT>

SessionDatabase SDB1
MaxSessions 1

RewriteUsername s/^([^@]+).*/$1/
AuthByPolicy ContinueAlways


<AuthBy SQL>
FailureBackoffTime 45
        AccountingStopsOnly

        DBSource dbi:ODBC:DSN=RADIUS
        DBUsername  radiususer
        DBAuth  radiuspass


AcctSQLStatement EXEC Sp_INS_AccountingLog\
'%n',\
'%m.%d.%Y %H:%M:%S',\
'%{Acct-Status-Type}',\
'%{Acct-Delay-Time}',\
'%{Acct-Input-Octets}',\
'%{Acct-Output-Octets}',\
'%{Acct-Session-Id}',\
'%{Acct-Session-Time}',\
'%{Ascend-Disconnect-Cause}',\
'%{NAS-IP-Address}',\
'%{NAS-Port}',\
'%{Framed-IP-Address}',\
'%{Called-Station-Id}',\
'%{Calling-Station-Id}',\
'213.243.1.36:1646',\
'%{Ascend-Xmit-Rate}'

AcctFailedLogFileName /radiator/logs/missedaccounting_1646_-%Y-%m-%d.log


</AuthBy>

</Realm>

<SessionDatabase SQL>
Identifier SDB1
FailureBackoffTime 10
DBSource        dbi:mysql:hostname=213.243.1.230:RADIUS
        DBUsername      xxxx
        DBAuth      xxxx
</SessionDatabase>






Kadir Saruhan
DOL System Administrator

ksaruhan at e-kolay.com
Tel: +90 212 498 35 16
Fax:+90 212 677 05 92
   www.e-kolay.net


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.open.com.au/pipermail/radiator/attachments/20050207/7e6b020d/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: guvenlik.gif
Type: image/gif
Size: 30784 bytes
Desc: not available
URL: <http://www.open.com.au/pipermail/radiator/attachments/20050207/7e6b020d/attachment.gif>