(RADIATOR) Perl error connecting mysql
Hugh Irvine
hugh at open.com.au
Thu Dec 30 03:34:43 CST 2004
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.
More information about the radiator
mailing list