At 11:13 AM 4/24/2002 +0300, Aleksandr Kuzminsky wrote:
>Hi.
>I have two RADIUS servers with detail and mysql accounting
>server #1
>---radiusd.conf---
>accounting {
> acct_unique
> detail
> triforksql
>}
>---radiusd.conf---
>
>server #2
>---radiusd.conf---
>accounting {
> acct_unique
> detail
> beastsql
>}
>---radiusd.conf---
>NAS(max6000) send start, stop and alive accounting packets for these
>servers. "triforksql" and "beastsql" is mysql modules describing different
>mysql databases. There are mutual replication for synchronization beetwen
>them.
>
>
>Then came stop packet to the sever #1:
>This one was successfully stored in detail file, but was not in mysql
>--radius.log--
>Tue Apr 23 21:37:21 2002 : Error: rlm_sql: All sockets are being used!
>Please increase
> the maximum number of sockets!
Well, that warning message should tell you something! Have you
done what it says in the error message?
>The "stop" packet was not resent, despite NAS is configured to send
>accounting packet 3 times if no response from accounting server, so RADIUS
>sent accounting response acknowledgment to the NAS. Why it happens?
>--rfc2866--
> If the RADIUS accounting server is unable to successfully record the
> accounting packet it MUST NOT send an Accounting-Response
> acknowledgment to the client.
>--rfc2866--
Hmmm, it *was* recorded in the 'detail' module, though, so it's not
fully incorrect.
What does the sql module return in that instance that there are not
enough sockets?
You may want to look at: 'doc/configureable-failover', as that allows
you to control some of the different options. If SQL is the most
important logging method, you may want to put that before 'detail' in
the accounting section, so that it returns before calling 'detail'.
-Chris
--
\\\|||/// \ StarNet Inc. \ Chris Parker
\ ~ ~ / \ WX *is* Wireless! \ Director, Engineering
| @ @ | \ http://www.starnetwx.net \ (847) 963-0116
oOo---(_)---oOo--\------------------------------------------------------
\ Wholesale Internet Services - http://www.megapop.net
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
