The mysql database has been setup for a user from the radiator server to access the database, the username and password is same as the username and password in the radius.cfg file below.
Our Authby SQL statement is below
<AuthBy SQL>
Identifier CheckClearTextPassword
# Adjust DBSource, DBUsername, DBAuth to suit your DB
DBSource dbi:mysql:freeside:hinemoa
DBUsername xxxxx
DBAuth
xxxxx
#
AuthSelect select ENCRYPTEDPASSWORD from
SUBSCRIBERS where USERNAME
#
EncryptedPassword
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>
The radius log produces the following:
Tue Sep 12 14:52:53 2000:
ERR: Could not connect to SQL database with DBI->connect dbi:mysql:freeside:hinemoa,
xxxxx, xxxxx: Host 'monowai' is not allowed to connect to this MySQL server
Tue Sep 12 14:52:53 2000:
ERR: Could not connect to any SQL database. Request is ignored. Backing
off for 600 seconds
Tue Sep 12 14:52:53 2000:
DEBUG: Handling with Radius::AuthGROUP
Tue Sep 12 14:52:53 2000:
DEBUG: Handling with Radius::AuthSQL
Tue Sep 12 14:52:53 2000:
ERR: Could not connect to SQL database with DBI->connect dbi:mysql:freeside:hinemoa,
xxxxx, xxxxx: Host 'monowai' is not allowed to connect to this MySQL server
Tue Sep 12 14:52:53 2000:
ERR: Could not connect to any SQL database. Request is ignored. Backing
off for 600 seconds
Tue Sep 12 14:52:53 2000:
DEBUG: Handling with Radius::AuthSQL
Tue Sep 12 14:52:53 2000:
ERR: Could not connect to SQL database with DBI->connect dbi:mysql:freeside:hinemoa,
xxxxx, xxxxx: Host 'monowai' is not allowed to connect to this MySQL server
Tue Sep 12 14:52:53 2000:
ERR: Could not connect to any SQL database. Request is ignored. Backing
off for 600 seconds
Tue Sep 12 14:53:23 2000:
DEBUG: Packet dump:
Any help would be appreciated,
Thanks.
Col.
