(RADIATOR) Perl error connecting mysql

Mike McCauley mikem at open.com.au
Mon Jan 3 05:30:51 CST 2005


Hello Adrian,

I presume you are using MySQL 4.1?

The problem you are seeing is due to the fact that MySQL 4.1 introduced a new 
mysql client authentication method, and the activeperl 2.9002 and 2.9003 
DBD-mysql clients do not support this new method.

Options and solutions are discussed here:
http://dev.mysql.com/doc/mysql/en/Old_client.html

Hopefully we will see new dbd-mysql versions from activetstate soon.

Hope that helps.

Cheers.

On Monday 03 January 2005 17:34, Adrian Tan wrote:
> Hello Hugh,
>
> I have checked with both ActiveState and MySQL.
> Both versions work on windows.
>
> I have also tried typing mysql on my command prompt and I could execute all
> the queries with no problems.
>
> Anyone using Mysql with Radiator on Windows and activeState Perl, if you
> can give me your versions, I would like to try them out.
>
> Regards,
> Adrian
>
> -----Original Message-----
> From: owner-radiator at open.com.au [mailto:owner-radiator at open.com.au] On
> Behalf Of Hugh Irvine Sent: Thursday, December 30, 2004 5:35 PM
> To: Adrian Tan
> Cc: radiator at open.com.au
> Subject: Re: (RADIATOR) Perl error connecting mysql
>
>
> Hello Adrian -
>
> I am using Radiator 3.11, Perl 5.8.1, MySQL 4.0.15 and DBD-mysql-2.9004 on
> MacOS X 10.3.6.
>
> You will need to check with ActiveState and MySQL to see what versions will
> work on Windows.
>
> regards
>
> Hugh
>
> On 30 Dec 2004, at 18:35, Adrian Tan wrote:
> > Hi Hugh,
> > I have checked.The version I am using for the DBD-MySQL is up to date.
> >
> > The perl version I am using is ActivePerl-5.6.1.638.
> > The DBD-MYSQL I am using is 2.9002
> >
> > Regards
> >
> > Adrian
> >
> > -----Original Message-----
> > From: Hugh Irvine [mailto:hugh at open.com.au]
> > Sent: Thursday, December 30, 2004 3:30 PM
> > To: Adrian Tan
> > Cc: radiator at open.com.au; Terry Simons
> > Subject: Re: (RADIATOR) Perl error connecting mysql
> >
> >
> > Hello Adrian -
> >
> > This looks like a problem with the version of DBD-MySQL you are using.
> >
> > regards
> >
> > Hugh
> >
> > On 30 Dec 2004, at 16:58, Adrian Tan wrote:
> >> Hi Terry,
> >>  I can manually connect to the database.
> >>  As for upgrading, I dun think it is an issue, this is because I have
> >> downloaded the latest stable version from the MYSQL website recently.
> >> So does the perl from ActiveState. Thats why I am very confused why
> >> it does not work.
> >>  
> >> Adrian
> >>
> >>
> >> From: Terry Simons [mailto:galimore at mac.com]
> >>  Sent: Thursday, December 30, 2004 1:06 PM
> >> To: Adrian Tan
> >> Cc: radiator at open.com.au
> >> Subject: Re: (RADIATOR) Perl error connecting mysql
> >>
> >> I probably don't know enough about MySQL to answer this, but it looks
> >> like the MySQL server you are trying to connect to is requesting some
> >> form of authentication that your client can not perform.
> >>
> >>
> >>  Try connecting manually to the database with the "mysql" command and
> >> see if that works. If you can't get that to work, then you won't be
> >> able to get Radiator working with things, most likely.
> >>
> >>
> >>  I have MySQL connections working for logging purposes, and I've
> >> never had this sort of issue, but the error message you get
> >> specifically states that your client doesn't appear to be supporting
> >> the required authentication mechanisms and recommends upgrading MySQL.
> >>
> >>
> >>  - Terry
> >>
> >>
> >>  On Dec 29, 2004, at 6:41 PM, Adrian Tan wrote:
> >>
> >>
> >>  Hi ,
> >> I am a newbie in installing the Radiator.
> >>
> >>
> >> Currently I am trying to get Radiator to work with mysql.
> >>
> >>
> >> Anyone can help me ?
> >>
> >>
> >> Regards,
> >>
> >>
> >> Adrian
> >>
> >>
> >> DBI connect('surf2fun','radius',...) failed: Client does not support
> >> authenticatio n protocol requested by server; consider upgrading
> >> MySQL client at C:/Perl/site/ lib/Radius/SqlDb.pm line 110 Thu Dec 30
> >> 09:33:11 2004: ERR: Could not connect to SQL database with
> >> DBI->conne
> >> ct dbi:mysql:surf2fun, radius, surffun:  Client does not support
> >> authentication p rotocol requested by server; consider upgrading
> >> MySQL client Thu Dec 30 09:33:11 2004: ERR: Could not connect to any
> >> SQL database.
> >> Request is
> >>  ignored. Backing off for 600 seconds
> >>
> >>
> >> My config file.
> >> # common-sql.cfg
> >>
> >>
> >> #
> >> # Example Radiator configuration file that allows you to #
> >> authenticate from an SQL database.
> >> # With Radiator you can interface with almost any databse schema, #
> >> and there are many more configurable parameters that allow you # to
> >> control database fallback, select statements, column names # and
> >> arrangements etc etc etc.
> >> # See the reference manual for more details.
> >> # This is a very simple exmaple to get you started. It will # work
> >> with the tables created by the goodies/*.sql scripts.
> >>
> >>
> >> #
> >> # You should consider this file to be a starting point only # $Id:
> >> sql.cfg,v 1.9 2004/10/04 10:35:03 mikem Exp $
> >>
> >>
> >> Foreground
> >>
> >>
> >> LogStdout
> >> LogDir          c:/Program Files/Radiator DbDir           c:/Program
> >> Files/Radiator Trace           4
> >>
> >>
> >> # You will probably want to change this to suit your site.
> >> <Client DEFAULT>
> >>         Secret  mysecret
> >>         DupInterval 0
> >>
> >>
> >> </Client>
> >>
> >>
> >> # You can put client details in a database table # and get their
> >> details from there with something like this:
> >>
> >>
> >> <ClientListSQL>
> >>                 DBSource    dbi:mysql:surf2fun
> >>                 DBUsername  radius
> >>                 DBAuth  surffun
> >>         # If RefreshPeriod is set to non-zero, it specifies the
> >> period in seconds that the client list will
> >>         # be refreshed by rereading the database. Each RefreshPeriod
> >> the previous client list
> >>         # is cleared and a new list of clients read from the database
> >>         # The same effect can be got by signalling the process with
> >> with SIGHUP
> >>         #RefreshPeriod 600
> >>
> >>
> >> </ClientListSQL>
> >>
> >>
> >> # This will authenticate users from SUBSCRIBERS <Realm DEFAULT>
> >>     <AuthBy SQL>
> >>         # Adjust DBSource, DBUsername, DBAuth to suit your DB
> >>
> >>
> >>         DBSource    dbi:mysql:surf2fun
> >>         DBUsername  radius
> >>         DBAuth  surffun
> >>
> >>
> >>         # You may want to tailor these for your ACCOUNTING table
> >>         # You can add your own columns to store whatever you like
> >>         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
> >>
> >>
> >>         # You can arrange to log accounting to a file if the
> >>         # SQL insert fails with AcctFailedLogFileName
> >>         # That way you could recover from a broken SQL
> >>         # server
> >>         #AcctFailedLogFileName %D/missedaccounting
> >>
> >>
> >>         # Alternatively, you can arrange to save failed SQL
> >> accounting insert queries to a text
> >>         # file with SQLRecoveryFile
> >>         SQLRecoveryFile %D/missedaccounting
> >>
> >>
> >>         # You can run a hook whenever Radiator (re)connects to the
> >> database. This
> >>         # can be useful for doing database-specific config or setup
> >>         # The hook is called like hook($object, $handle)
> >>         # $object is the SqlDb object that is doing the connecting,
> >>         # and $handle is the database handle if the newly connected
> >> database
> >>         # This example shows how to set some connection specific
> >> attributes
> >>         # for Interbase
> >>         #ConnectionHook sub {$_[1]->func(-access_mode =>
> >> 'read_write',\
> >>         #       -isolation_level => 'read_committed',\
> >>         #       -lock_resolution => 'wait',\
> >>         #       'ib_set_tx_param')}
> >>
> >>
> >>     </AuthBy>
> >>
> >>
> >> </Realm>
> >
> > NB:
> >
> > Have you read the reference manual ("doc/ref.html")?
> > Have you searched the mailing list archive
> > (www.open.com.au/archives/radiator)?
> > Have you had a quick look on Google (www.google.com)?
> > Have you included a copy of your configuration file (no secrets),
> > together with a trace 4 debug showing what is happening?
> >
> > --
> > Radiator: the most portable, flexible and configurable RADIUS server
> > anywhere. Available on *NIX, *BSD, Windows, MacOS X.
> > -
> > Nets: internetwork inventory and management - graphical, extensible,
> > flexible with hardware, software, platform and database independence.
> > -
> > CATool: Private Certificate Authority for Unix and Unix-like systems.
> >
> > --
> > Archive at http://www.open.com.au/archives/radiator/
> > Announcements on radiator-announce at open.com.au To unsubscribe, email
> > 'majordomo at open.com.au' with 'unsubscribe radiator' in the body of the
> > message.
>
> NB:
>
> Have you read the reference manual ("doc/ref.html")?
> Have you searched the mailing list archive
> (www.open.com.au/archives/radiator)? Have you had a quick look on Google
> (www.google.com)?
> Have you included a copy of your configuration file (no secrets), together
> with a trace 4 debug showing what is happening?
>
> --
> Radiator: the most portable, flexible and configurable RADIUS server
> anywhere. Available on *NIX, *BSD, Windows, MacOS X. -
> Nets: internetwork inventory and management - graphical, extensible,
> flexible with hardware, software, platform and database independence. -
> CATool: Private Certificate Authority for Unix and Unix-like systems.
>
> --
> Archive at http://www.open.com.au/archives/radiator/
> Announcements on radiator-announce at open.com.au To unsubscribe, email
> 'majordomo at open.com.au' with 'unsubscribe radiator' in the body of the
> message.
>
> --
> Archive at http://www.open.com.au/archives/radiator/
> Announcements on radiator-announce at open.com.au
> To unsubscribe, email 'majordomo at open.com.au' with
> 'unsubscribe radiator' in the body of the message.

-- 
Mike McCauley                               mikem at open.com.au
Open System Consultants Pty. Ltd            Unix, Perl, Motif, C++, WWW
9 Bulbul Place Currumbin Waters QLD 4223 Australia   http://www.open.com.au
Phone +61 7 5598-7474                       Fax   +61 7 5598-7070

Radiator: the most portable, flexible and configurable RADIUS server 
anywhere. SQL, proxy, DBM, files, LDAP, NIS+, password, NT, Emerald, 
Platypus, Freeside, TACACS+, PAM, external, Active Directory, EAP, TLS, 
TTLS, PEAP etc on Unix, Windows, MacOS etc.

--
Archive at http://www.open.com.au/archives/radiator/
Announcements on radiator-announce at open.com.au
To unsubscribe, email 'majordomo at open.com.au' with
'unsubscribe radiator' in the body of the message.


More information about the radiator mailing list