Fwd: RE: (RADIATOR) Perl error connecting mysql
Lanny Jason Godsey
lannygodsey at yahoo.com
Mon Jan 3 18:38:20 CST 2005
http://dev.mysql.com/doc/mysql/en/Old_client.html
This may be your problem, I remember having this problem running MySQL
Server 4.1 and trying to talk to it from ColdFusion which only worked
w/ 4.0.
mysql> SET PASSWORD FOR
-> 'some_user'@'some_host' = OLD_PASSWORD('newpwd');
This solved my problem. Hope this helps.
Lanny J. Godsey
--- Adrian Tan <adrian at bbsnetworks.com> wrote:
> Subject: RE: (RADIATOR) Perl error connecting mysql
> Date: Mon, 3 Jan 2005 15:34:25 +0800
> From: "Adrian Tan" <adrian at bbsnetworks.com>
> To: <radiator at open.com.au>
>
> 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.
>
--
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