Hello Colin -
You should start by running a couple of queries by hand with "myslqshow" and
"mysql" both from the database machine and from the Radiator machine to ensure
that you can talk to the database server first of all. Once you are sure that
it works, then you can test DBI/DBD on the database host and then finally you
can test from the Radiator host. It sounds like you have not granted the
correct access privileges to the database.
hth
Hugh
On Tue, 12 Sep 2000, Colin wrote:
>
> We have just installed MYSQL on a remote linux machine separte from the
> radiator machine, but we cannot seem to be able to get radiator to
> authenticate users through the Mysql machine.
> 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.
>
----------------------------------------
Content-Type: text/html; name="unnamed"
Content-Transfer-Encoding: 7bit
Content-Description:
----------------------------------------
--
Radiator: the most portable, flexible and configurable RADIUS server
anywhere. SQL, proxy, DBM, files, LDAP, NIS+, password, NT, Emerald,
Platypus, Freeside, Interbiller, TACACS+, PAM, external, etc, etc.
Available on Unix, Linux, FreeBSD, Windows 95/98/2000, NT, MacOS X.
===
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.
