On a completely separate tack from different logfiles for different groups... Does anyone have recommendations for database software to handle SQL accounting/sessionDB? We currently have around 105K dialup userids and that number continues growing rapidly. We get a lot of accounting info each day. :-) We've been using MySQL for other purposes, but our installations haven't come under any real load. Has it proven reliable for others when heavily used with Radiator? We're fond of the price, but may be able to scrounge a spare Oracle license from another department if that has a better track record. Unfortunately, we probably can't find more than one. We'd be looking to roll out the SQL accounting and session databases in three of our main server locations, which each have two Radiator servers. It would be easier for us to have the six radius boxes send their accounting to a centralized database server with one fallback, but we're concerned about the failover with that design. What are the options if an accounting SQL server is unreachable? I know the reference manual says that if radius can't connect to any SQL database it will ignore the request and cause the NAS to failover to a secondary radius server. What if the secondary radius server uses the same SQL server (admitted deployment flaw, but...)? Can failover be to flat file accounting? While the accounting is waiting "Timeout" seconds to connect to a SQL server, is that backlogging the radiusd process and affecting authentication, as well? What we want to avoid at all costs is authentication going out because the database server receiving the accounting data is inaccessible. Can problems with SQL accounting hang auth, as well? Would multiple, smaller database servers (e.g., one in each of the three locations) be a better approach, where each could failover to a server in one of the other locations? Something like FreeBSD/MySQL on a PII? Thanks for any information! We'll be testing these questions ourselves, but wanted to get any available info from those who've been there before. Dawn Lovell [EMAIL PROTECTED] === Archive at http://www.thesite.com.au/~radiator/ To unsubscribe, email '[EMAIL PROTECTED]' with 'unsubscribe radiator' in the body of the message.
