could the problem be related to a newer release of mysql? we are using 3.22.32 and
it seems as though the error we are getting an error log saying that mysql is
crashing because we're using an old style password.
Radiator does support 3.22.32 right?
Hugh Irvine wrote:
> 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.
