Hello Doug -
On Wednesday 07 February 2001 14:34, Doug Currey wrote:
> > I have converted to using Mysql from a flat file everything seems to be
> working except some of my accounting packets get bumped to a backup server.
>
> They client seem to think the server is down when this happens. The server
> is up and running just doesn't seem to get the all of the accounting
> packets in time. This never seemed to happen when I used authby and
> stored the accounting packets in a flat file so I think its MySQL related.
>
> I have modified my online database to use the INSERT DELAYED but think I
> mainly need this in the Authby SQL section is there some equal to insert
> delayed that can be placed in with AuthSelect? Here is my AuthbySQL
>
> Any body have any ideas what I am doing wrong or is there a better way of
> correcting this problem.
>
>
>
> <AuthBy SQL>
> # Adjust DBSource, DBUsername, DBAuth to suit your DB
> DBSource dbi:mysql:radius
> DBUsername XXXXX
> DBAuth XXXXX
> #
> Timeout 60
> FailureBackoffTime 600
> AuthSelect select PASSWORD, CHECKATTR, REPLYATTR from USERS where
> USERNAME='%n'
>
> # You may want to tailor these for your ACCOUNTING table
> AccountingTable %Y_%m_ACCOUNTING
> AccountingStopsOnly
> AuthColumnDef 0, User-Password, check
> AuthColumnDef 1, GENERIC, check
> AuthColumnDef 2, GENERIC, reply
> AcctColumnDef USERNAME,User-Name
> AcctColumnDef TIME_STAMP,Timestamp,integer
> AcctColumnDef TRUE_TIME,Timestamp,formatted-date,'%Y-%m-%d
> %H:%M:%S' AcctColumnDef ACCTSTATUSTYPE,Acct-Status-Type
> AcctColumnDef ACCTINPUTOCTETS,Acct-Input-Octets,integer
> AcctColumnDef ACCTOUTPUTOCTETS,Acct-Output-Octets,integer
> AcctColumnDef ACCTSESSIONID,Acct-Session-Id
> AcctColumnDef CONNECTSPEED,Connect-Speed
> AcctColumnDef CALLEDSTID,Called-Station-Id
> AcctColumnDef CALLINGSTID,Calling-Station-Id
> AcctColumnDef ACCTSESSIONTIME,Acct-Session-Time,integer
> AcctColumnDef ACCTTERMINATECAUSE,Ascend-Disconnect-Cause
> AcctColumnDef NASIDENTIFIER,NAS-IP-Address
> AcctColumnDef FRAMEDIPADDRESS,Framed-IP-Address
> </AuthBy>
I will need to see the complete configuration file (no secrets) together with
a trace 4 debug from Radiator showing what is happening.
thanks
Hugh
--
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.starport.net/~radiator/
Announcements on [EMAIL PROTECTED]
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.
