Hello Antonio -


A simple approach would be to do something like this (which may not be what you want):

<Realm DEFAULT>
        AuthByPolicy ContinueWhileAccept
        <AuthBy GROUP>
                AuthByPolicy ContinueWhileIgnore
                <AuthBy SQL>
                        .....
                </AuthBy>
                <AuthBy INTERNAL>
                        DefaultResult ACCEPT
                        .....
                </AuthBy>
        </AuthBy>
        <AuthBy DYNADDRESS>
                .....
        </AuthBy>
        .....
</Realm>

regards

Hugh


On Friday, Mar 14, 2003, at 03:29 Australia/Melbourne, Antonio Navarro Navarro wrote:


Hi all,

I have a radiator configured with a PostgreSQL user database. Last
night the database failed, and the users where unabled to connect. The
configuraion section related to the Realm follows :

<Realm DEFAULT>
AuthByPolicy ContinueWhileAccept
RewriteUsername tr/A-Z/a-z/
<AuthBy SQL>
DBSource dbi:Pg:dbname=radiator
DBUsername xxxxxxxxxxx
DBAuth xxxxxxxxxxx
DefaultSimultaneousUse 1
AuthSelect select PASSWORD, CHECKATTR, REPLYATTR from SUBSCRIBERS where USERNAME='%n'
AccountingStopsOnly
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 NASPORT,NAS-Port,integer
AcctColumnDef NASPORTTYPE,NAS-Port-Type
AcctColumnDef FRAMEDIPADDRESS,Framed-IP-Address
AcctColumnDef CALLINGID, Calling-Station-Id
AcctColumnDef CALLEDID, Called-Station-Id
</AuthBy>
<AuthBy DYNADDRESS>
AddressAllocator MainClass
PoolHint Dynamic
StripFromReply PoolHint
</AuthBy>
AddToReply Service-Type=Framed-User, Framed-Protocol=PPP
</Realm>


� What can I do in order to allow users to connect if the database
server fails ?

Best regards,

Antonio Navarro Navarro
[EMAIL PROTECTED]
BemarNet Management
http://www.bemarnet.es


=== Archive at http://www.open.com.au/archives/radiator/ Announcements on [EMAIL PROTECTED] To unsubscribe, email '[EMAIL PROTECTED]' with 'unsubscribe radiator' in the body of the message.



NB: have you included a copy of your configuration file (no secrets), together with a trace 4 debug showing what is happening?

--
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.open.com.au/archives/radiator/
Announcements on [EMAIL PROTECTED]
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.

Reply via email to