(RADIATOR) Problem with remote mySql logging accounting

[terry at ccis.net]

I'm having trouble getting the second of two radiator servers logging
accounting records to a mySql database.

Machine "marvin" runs radiator and mySql. Radiator can log fine to the
database, config is: (all user/pw XXX'd out)

<Handler>
        # remove the "@domain" part (if it exists)
        RewriteUsername s/^([^@]+).*/$1/
        # remove spaces
        RewriteUsername s/\s//g
        AuthByPolicy ContinueAlways
        AcctLogFileName %L/detail
        AuthLog logger1
        <AuthBy SQL>
                # AuthSelect with empty string means dont do auth
                AuthSelect
                DBSource        dbi:mysql:radius
                DBUsername      XXX
                DBAuth          XXX
                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
ASCENDDISCONNECTCAUSE,Ascend-Disconnect-Cause
                AcctColumnDef   ASCENDDATARATE,Ascend-Data-Rate
                AcctColumnDef   ASCENDXMITRATE,Ascend-Xmit-Rate
                AcctColumnDef
ASCENDCONNECTPROGRESS,Ascend-Connect-Progress
                AcctColumnDef   NASIDENTIFIER,NAS-Identifier
                AcctColumnDef   NASPORT,NAS-Port,integer
                AcctColumnDef   FRAMEDIPADDRESS,Framed-IP-Address
                AcctColumnDef   NASIPADDRESS,NAS-IP-Address
                AcctColumnDef   CALLEDSTATIONID,Called-Station-Id
                AcctColumnDef   CALLINGSTATIONID,Calling-Station-Id
                AcctColumnDef   CONNECTINFO,Connect-Info
        </AuthBy>
        # Make sure they appear in the users2 file
        # Anyone with Auth-Type=UNIX in the users2 file will be
        # authenticated with the AuthBy UNIX above
        <AuthBy FILE>
                Filename        %D/users2
        </AuthBy>

</Handler>



Machine "mrtg"'s radiator gets an error logging into marvin's mySql (I can
run mysql manually from that machine and access the database with no
problems). It's config is

<Handler>
        # remove the "@domain" part (if it exists)
        RewriteUsername s/^([^@]+).*/$1/
        # remove spaces
        RewriteUsername s/\s//g
        AuthByPolicy ContinueAlways
        AcctLogFileName %L/detail
        AuthLog logger1
        <AuthBy SQL>
                # AuthSelect with empty string means dont do auth
                AuthSelect
                DBSource        dbi:mysql:radius:marvin.ccis.net:3306
                DBUsername      XXX
                DBAuth          XXX
                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
ASCENDDISCONNECTCAUSE,Ascend-Disconnect-Cause
                AcctColumnDef   ASCENDDATARATE,Ascend-Data-Rate
                AcctColumnDef   ASCENDXMITRATE,Ascend-Xmit-Rate
                AcctColumnDef
ASCENDCONNECTPROGRESS,Ascend-Connect-Progress
                AcctColumnDef   NASIDENTIFIER,NAS-Identifier
                AcctColumnDef   NASPORT,NAS-Port,integer
                AcctColumnDef   FRAMEDIPADDRESS,Framed-IP-Address
                AcctColumnDef   NASIPADDRESS,NAS-IP-Address
                AcctColumnDef   CALLEDSTATIONID,Called-Station-Id
                AcctColumnDef   CALLINGSTATIONID,Calling-Station-Id
                AcctColumnDef   CONNECTINFO,Connect-Info
        </AuthBy>
        # Make sure they appear in the users2 file
        # Anyone with Auth-Type=UNIX in the users2 file will be
        # authenticated with the AuthBy UNIX above
       <AuthBy FILE>
                Filename        %D/users2
        </AuthBy>

</Handler>


I've tried specifying the machine name in the DBSource with name and IP, no
diff. Error is

Thu Oct 24 00:02:35 2002: ERR: Could not connect to any SQL database.
Request is ignored. Backing off for 600 seconds
Can't read $DBI::errstr, last handle unknown or destroyed at
/usr/libdata/perl5/site_perl/Radius/SqlDb.pm line 136.
Thu Oct 24 00:03:53 2002: ERR: Could not connect to SQL database with
DBI->connect dbi:mysql:radius:marvin.ccis.net:3306, XXX, XXX:

"marvin" (good) is running radiator 1.93 ; mrtg (bad) is running 1.86.
Anyone have suggestions?

===
Archive at http://www.open.com.au/archives/radiator/
Announcements on radiator-announce at open.com.au
To unsubscribe, email 'majordomo at open.com.au' with
'unsubscribe radiator' in the body of the message.