MySQL 4.1.7 req"d DBD Version

--Boundary_(ID_xR6mxrc4hfPF21rixuvJVA)
Content-type: text/plain; charset=us-ascii
Content-transfer-encoding: 7BIT

Hello all-

No doubt this question has been asked but I'm mailing to this last as a last
resort after nearly a full day of google searching for the results as I hate
asking questions that seem so clear on FAQ, list archives, etc. Alas, I
couldn't find a clear answer.

I've got a MySQL server running ver 4.1.7 with the new password hashing
protocol and I'd like to connect with PERL. I'm running on Windows (I know,
I know), ActiveState 5.8.4.810 with DBI version 1.46 and DBD-MySQL 2.9004
(thanks to Randy Kobes http://theoryx5.uwinnipeg.ca/ppms/DBD-mysql.ppd )

But I'm still getting the error about the Client not supporting the
authentication method required by the server when I connect. If I reset the
MySQL user account's password with old_password it'll connect fine. So my
questions are:



1) Assuming the new password hashing in MySQL 4.1.7, what's the minimum DBI
and DBD-MySQL version to connect?



2) I see 2.9005_3 on cpan.org but with Activestate and Windows I really need
a .ppd I can install with ppm. Do you know of a place with the necessary ppm
ready module I can install?



3) If DBI 1.46 and DBD-MySQL 2.9004 are the required versions, what should I
check to see why I'm still having the behavior described above?



4) Or is the only way to accomplish this is using old_password on the MySQL
side until the DBD/DBI gets caught up?



Thanks for you time.

~Mike

-------------------------

Mike Garner

Computer Services, WSC

mgarner@western.edu

voice: 970.943.3123

fax: 970.943.7069




--Boundary_(ID_xR6mxrc4hfPF21rixuvJVA)--

Re: MySQL 4.1.7 req"d DBD Version

Mike Garner said:
> Hello all-
>
> No doubt this question has been asked but I'm mailing to this last as a
> last resort after nearly a full day of google searching for the results
> as I hate asking questions that seem so clear on FAQ, list archives,
> etc. Alas, I couldn't find a clear answer.
Ran into this same problem about two weeks ago. At that time the list
decided that the DBD updates had been given to Active state but they
hadn't pushed them out. I ran into a similar problem with Connector/J so
I dropped back to 4.0x. I get the feeling that while the server may be
ready the support software is not quite there. I'd love to be wrong
but...
> I've got a MySQL server running ver 4.1.7 with the new password hashing
> protocol and I'd like to connect with PERL. I'm running on Windows (I
> know, I know), ActiveState 5.8.4.810 with DBI version 1.46 and DBD-MySQL
> 2.9004 (thanks to Randy Kobes
> http://theoryx5.uwinnipeg.ca/ppms/DBD-mysql.ppd )
>
> But I'm still getting the error about the Client not supporting the
> authentication method required by the server when I connect. If I reset
> the MySQL user account's password with old_password it'll connect fine.
> So my questions are:
>
>
>
> 1) Assuming the new password hashing in MySQL 4.1.7, what's the minimum
> DBI and DBD-MySQL version to connect?
>
>
>
> 2) I see 2.9005_3 on cpan.org but with Activestate and Windows I really
> need a .ppd I can install with ppm. Do you know of a place with the
> necessary ppm ready module I can install?
>
>
>
> 3) If DBI 1.46 and DBD-MySQL 2.9004 are the required versions, what
> should I check to see why I'm still having the behavior described above?
>
>
>
> 4) Or is the only way to accomplish this is using old_password on the
> MySQL side until the DBD/DBI gets caught up?
>
>
>
> Thanks for you time.
>
> ~Mike
>
> -------------------------
>
> Mike Garner
>
> Computer Services, WSC
>
> mgarner@western.edu
>
> voice: 970.943.3123
>
> fax: 970.943.7069
>
>


--
William R. Mussatto, Senior Systems Engineer
Ph. 909-920-9154 ext. 27
FAX. 909-608-7061

RE: MySQL 4.1.7 req"d DBD Version

William-
I saw your posts in some of the archives but didn't understand which version
was required. I guess that's not known yet or its not out there. ActiveState
still only shows DBD-MySQL ver 2.9003 in their PPM repository but I was
surprised when the 2.9004 I got from Randy's site didn't work either. So
then I was confused if my problem was that I had the wrong version or if I
had the right version and something else was broken.

My problem is that the PHP extension (ext/mysqli) seems ready but the Perl
is not. The PHP folks want to start using and converting to the
object-oriented method of mysqli but I need to maintain support for Perl.
....old-passwords here I come

~Mike

-------------------------
Mike Garner
Computer Services, WSC
mgarner@western.edu
voice: 970.943.3123
fax: 970.943.7069

-----Original Message-----
From: William R. Mussatto [mailto:mussatto@csz.com]
Sent: Wednesday, December 08, 2004 10:11 AM
To: dbi-users@perl.org
Subject: Re: MySQL 4.1.7 req'd DBD Version

Mike Garner said:
> Hello all-
>
> No doubt this question has been asked but I'm mailing to this last as a
> last resort after nearly a full day of google searching for the results
> as I hate asking questions that seem so clear on FAQ, list archives,
> etc. Alas, I couldn't find a clear answer.
Ran into this same problem about two weeks ago. At that time the list
decided that the DBD updates had been given to Active state but they
hadn't pushed them out. I ran into a similar problem with Connector/J so
I dropped back to 4.0x. I get the feeling that while the server may be
ready the support software is not quite there. I'd love to be wrong
but...
> I've got a MySQL server running ver 4.1.7 with the new password hashing
> protocol and I'd like to connect with PERL. I'm running on Windows (I
> know, I know), ActiveState 5.8.4.810 with DBI version 1.46 and DBD-MySQL
> 2.9004 (thanks to Randy Kobes
> http://theoryx5.uwinnipeg.ca/ppms/DBD-mysql.ppd )
>
> But I'm still getting the error about the Client not supporting the
> authentication method required by the server when I connect. If I reset
> the MySQL user account's password with old_password it'll connect fine.
> So my questions are:
>
>
>
> 1) Assuming the new password hashing in MySQL 4.1.7, what's the minimum
> DBI and DBD-MySQL version to connect?
>
>
>
> 2) I see 2.9005_3 on cpan.org but with Activestate and Windows I really
> need a .ppd I can install with ppm. Do you know of a place with the
> necessary ppm ready module I can install?
>
>
>
> 3) If DBI 1.46 and DBD-MySQL 2.9004 are the required versions, what
> should I check to see why I'm still having the behavior described above?
>
>
>
> 4) Or is the only way to accomplish this is using old_password on the
> MySQL side until the DBD/DBI gets caught up?
>
>
>
> Thanks for you time.
>
> ~Mike
>
> -------------------------
>
> Mike Garner
>
> Computer Services, WSC
>
> mgarner@western.edu
>
> voice: 970.943.3123
>
> fax: 970.943.7069
>
>


--
William R. Mussatto, Senior Systems Engineer
Ph. 909-920-9154 ext. 27
FAX. 909-608-7061

Re: MySQL 4.1.7 req"d DBD Version

On Wed, 8 Dec 2004, Mike Garner wrote:

> Hello all-
>
> No doubt this question has been asked but I'm mailing to this last as a last
> resort after nearly a full day of google searching for the results as I hate
> asking questions that seem so clear on FAQ, list archives, etc. Alas, I
> couldn't find a clear answer.
>
> I've got a MySQL server running ver 4.1.7 with the new password hashing
> protocol and I'd like to connect with PERL. I'm running on Windows (I know,
> I know), ActiveState 5.8.4.810 with DBI version 1.46 and DBD-MySQL 2.9004
> (thanks to Randy Kobes http://theoryx5.uwinnipeg.ca/ppms/DBD-mysql.ppd )
>
> But I'm still getting the error about the Client not supporting the
> authentication method required by the server when I connect. If I reset the
> MySQL user account's password with old_password it'll connect fine. So my
> questions are:
>
>
>
> 1) Assuming the new password hashing in MySQL 4.1.7, what's the minimum DBI
> and DBD-MySQL version to connect?

You need at least DBD::mysql 2.9004 to compile against the 4.1.7 mysql client
libararies. As for the password hashing, that is handled by the mysql client
libraries and not DBD::mysql. I don't know about windows, but under most unixes
this is just a simple matter of recompiling against the 4.1.7.

> 4) Or is the only way to accomplish this is using old_password on the MySQL
> side until the DBD/DBI gets caught up?
>

It is until you get a version compiled against the new libraries.

Rudy.

RE: MySQL 4.1.7 req"d DBD Version

-----Original Message-----
From: Rudy Lippan [mailto:rlippan@remotelinux.com]
Sent: Wednesday, December 08, 2004 6:05 PM
To: Mike Garner
Cc: dbi-users@perl.org
Subject: Re: MySQL 4.1.7 req'd DBD Version

On Wed, 8 Dec 2004, Mike Garner wrote:

> Hello all-
>
> No doubt this question has been asked but I'm mailing to this last as a
last
> resort after nearly a full day of google searching for the results as I
hate
> asking questions that seem so clear on FAQ, list archives, etc. Alas, I
> couldn't find a clear answer.
>
> I've got a MySQL server running ver 4.1.7 with the new password hashing
> protocol and I'd like to connect with PERL. I'm running on Windows (I
know,
> I know), ActiveState 5.8.4.810 with DBI version 1.46 and DBD-MySQL 2.9004
> (thanks to Randy Kobes http://theoryx5.uwinnipeg.ca/ppms/DBD-mysql.ppd )
>
> But I'm still getting the error about the Client not supporting the
> authentication method required by the server when I connect. If I reset
the
> MySQL user account's password with old_password it'll connect fine. So my
> questions are:
>
>
>
> 1) Assuming the new password hashing in MySQL 4.1.7, what's the minimum
DBI
> and DBD-MySQL version to connect?

You need at least DBD::mysql 2.9004 to compile against the 4.1.7 mysql
client
libararies. As for the password hashing, that is handled by the mysql
client
libraries and not DBD::mysql. I don't know about windows, but under most
unixes
this is just a simple matter of recompiling against the 4.1.7.

If I have DBD::mysql 2.9004 from Randy's site, as I mentioned above, when
then am I still receiving the client authentication protocol error? Being
on Windoze, I'm not compiling the module myself. Is it possible that this
module is the current version but wasn't compiled against 4.1.7 libraries?
Does anyone know for sure about Randy's module or any other PPM module
available for an ActiveState PERL port that IS compiled against 4.1.7?




> 4) Or is the only way to accomplish this is using old_password on the
MySQL
> side until the DBD/DBI gets caught up?
>

It is until you get a version compiled against the new libraries.

Rudy.