We have currently setup radiator on a separate machine to the mysql
database.
We receive the following message popping up on the radiator machine
when attempting to login:
Can't
read $DBI::errstr, last handle unknown or destroyed at /usr/lib/perl5/site_perl/5.005/Radius/SqlDb.pm
line 137.
Can't
read $DBI::errstr, last handle unknown or destroyed at /usr/lib/perl5/site_perl/5.005/Radius/SqlDb.pm
line 137.
Can't
read $DBI::errstr, last handle unknown or destroyed at /usr/lib/perl5/site_perl/5.005/Radius/SqlDb.pm
line 137.
Can someone explain to me what this error means?
Checking the radius log, it seems as though it cannot connect to the SQL database on the mysql machine
Could not connect to SQL database with DBI->connect dbi:mysql:freeside:202.9.231.xxx, xxxxx, xxxxxxxxx
An excerpt of the radius.cfg is below:
<AuthBy SQL>
Identifier CheckClearTextPassword
# Adjust DBSource, DBUsername, DBAuth to suit your DB
DBSource dbi:mysql:freeside:202.9.231.xxx
DBUsername xxxxxx
DBAuth xxxxxxxx
AuthSelect select _password from svc_acct
where username='%n'
# You may want to tailor these for your ACCOUNTING table
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 NASIDENTIFIER,NAS-Identifier
AcctColumnDef NASPORT,NAS-Port,integer
AcctColumnDef FRAMEDIPADDRESS,Framed-IP-Address
AcctColumnDef CALLEDSTATIONID,Called-Station-Id
AcctColumnDef CALLINGSTATIONID,Calling-Station-Id
DefaultReply Service-Type = Framed-User, Framed-Protocol = PPP, Framed-M
</AuthBy>
Thanks.
Col.
