Here is a snippet of my config. What I am doing is authenticating multiple
realms, with an empty AuthSelect (since I am pulling passwords out of the
shadow file, not the DB). What happens at Trace 4 is that for realm1.com it
authenticates and stuffs them into the online SessionDatabase SQL (defined
globally) as well as the accounting table. So realm1.com is cool.
But realm2 users don't make it into the SessionDatabase or the accounting
table. At Trace 4 I don't even see the INSERT statements happening. So I
obviously have some kind of structural problem with the way I have arranged
the realm blocks with the AuthBy clauases inside them in here.
Can anyone give me a hint?
Thanks,
Chris
<Realm realm1.com>
# keep going through all AuthBy clauses
AuthByPolicy ContinueAlways
# strip realm, etc in here (missing for brevity)
<AuthBy SQL>
DefaultSimultaneousUse 1
# Adjust DBSource, DBUsername, DBAuth to suit your DB
DBSource dbi:mysql:radiator_db
DBUsername mydbuser
DBAuth BiteMe
Timeout 60
FailureBackoffTime 600
AuthSelect
AccountingTable ACCOUNTING
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 ACCTTERMINATECAUSE,Acct-Terminate-Cause
AcctColumnDef PORTTYPE,NAS-Port-Type
AcctColumnDef NASPORT,NAS-Port,integer
AcctColumnDef NASIP,NAS-IP-Address
AcctColumnDef FRAMEDIPADDRESS,Framed-IP-Address
AcctColumnDef CONNECTINFO,Connect-Info
AcctColumnDef CALLINGSTATION,Calling-Station-Id
AcctColumnDef CALLEDSTATION,Called-Station-Id
AcctColumnDef ASCENDDATARATE,Ascend-Data-Rate,integer
AcctColumnDef ASCENDXMITRATE,Ascend-Xmit-Rate,integer
AcctColumnDef ASCENDDISCONNECT,Ascend-Disconnect-Cause
AcctColumnDef USERREALM,User-Realm
AcctColumnDef LIVINGSTON,Livingston
AcctColumnDef NASIDENTIFIER,NAS-Identifier
</AuthBy>
<AuthBy DBFILE>
Filename %D/users
</AuthBy>
# Log accounting to the detail file in LogDir
AcctLogFileName %L/detail
</Realm>
<Realm realm2.com>
# keep going through all AuthBy clauses
AuthByPolicy ContinueAlways
# strip realm, etc in here (missing for brevity)
<AuthBy SQL>
DefaultSimultaneousUse 1
# Adjust DBSource, DBUsername, DBAuth to suit your DB
DBSource dbi:mysql:radiator_db
DBUsername mydbuser
DBAuth BiteMe
Timeout 60
FailureBackoffTime 600
AuthSelect
AccountingTable ACCOUNTING
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 ACCTTERMINATECAUSE,Acct-Terminate-Cause
AcctColumnDef PORTTYPE,NAS-Port-Type
AcctColumnDef NASPORT,NAS-Port,integer
AcctColumnDef NASIP,NAS-IP-Address
AcctColumnDef FRAMEDIPADDRESS,Framed-IP-Address
AcctColumnDef CONNECTINFO,Connect-Info
AcctColumnDef CALLINGSTATION,Calling-Station-Id
AcctColumnDef CALLEDSTATION,Called-Station-Id
AcctColumnDef ASCENDDATARATE,Ascend-Data-Rate,integer
AcctColumnDef ASCENDXMITRATE,Ascend-Xmit-Rate,integer
AcctColumnDef ASCENDDISCONNECT,Ascend-Disconnect-Cause
AcctColumnDef USERREALM,User-Realm
AcctColumnDef LIVINGSTON,Livingston
AcctColumnDef NASIDENTIFIER,NAS-Identifier
</AuthBy>
<AuthBy DBFILE>
Filename %D/users
</AuthBy>
# Log accounting to the detail file in LogDir
AcctLogFileName %L/detail
</Realm>
===
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.
