(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