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 [EMAIL PROTECTED] To unsubscribe, email '[EMAIL PROTECTED]' with 'unsubscribe radiator' in the body of the message.