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 [EMAIL PROTECTED] voice: 970.943.3123 fax: 970.943.7069 -----Original Message----- From: William R. Mussatto [mailto:[EMAIL PROTECTED] Sent: Wednesday, December 08, 2004 10:11 AM To: [EMAIL PROTECTED] 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 > > [EMAIL PROTECTED] > > voice: 970.943.3123 > > fax: 970.943.7069 > > -- William R. Mussatto, Senior Systems Engineer Ph. 909-920-9154 ext. 27 FAX. 909-608-7061
