William R. Mussatto said: > Mark Matthews said: >> -----BEGIN PGP SIGNED MESSAGE----- >> Hash: SHA1 >> >> William R. Mussatto wrote: >>> Keith Ivey said: >>> >>>>William R. Mussatto wrote: >>>> >>>> >>>>>I've been googling for 1/2 hr w/o any answers. sorry if I've missed >>>>> the obvious. >>>>>Problem. Fresh install of mysql 4.7.1, AS perl 5.8 >>>>>DBI and DBD-Mysql via ppm. > Also new connector/J version > >>>>>Client does not support authnticaiton protocol >>>>> >>>> >>>>What version of MySQL were you using previously? If it was 4.1.0 or >>>> earlier, then this >>>>might be useful reading: >>>> >>>>http://dev.mysql.com/doc/mysql/en/Password_hashing.html >>>> >>>>-- >>>>Keith Ivey <[EMAIL PROTECTED]> >>>>Washington, DC >>> >>> Thanks, I'll check it out. I did the development under linux using >>> 3.23.xx and perl 5.6 Basically debian stable. >>> >>> From the article it looks like I'll have to fall back to a 4.0 >>> version. >>> >>> I was hoping, but using a clean install on the windows box to avoid >>> these issues. >>> I'll try SET PASSWORD FOR 'some_user'@'some_host' = >>> OLD_PASSWORD('mypass'); >> >> William, >> >> You'll need a copy of DBD::MySQL that's linked with libmysql from 4.1 >> to get around this issue (and use the new server-side prepared >> statements as well). Patrick Galbraith (a MySQL engineer) has pushed >> the required changes into the CVS repo of DBD::MySQL, however that >> hasn't been released yet as a binary by the DBD::MySQL maintainer >> (DBD::MySQL version 2.9015) >> >>> Thanks that worked, now to see what happends when I try w/connector/J >> >> As long as you're using a recent version of Connector/J (3.0.15 or >> 3.1.4), it'll work fine. >> >> Regards, >> >> -Mark > Tried it and now I get connection timed out after three tries. I'm > running the testbed using the tomcat buried in netbeans. Cut and pasted > the example from the on line docs. Put the jar in the WEB-INF/lib > dirctory. Compiles fine.. I'm using the in line driver registration > rather than modifying the > web.xml file. > > Tested user on the same box with command line client using the > --host=localhost and it connected fine (had run grant all for the > 'username'@'localhost' earlier. Any thoughts? > > Of course I've been using your old mm version with 3.23.x (to match our > debian install). > > With 4.7.1 both the old mm connector and the current connector/J both > time out. Anythink I should check. And no. there is no local firewll > installed on the box. Follow up w/specific error reports: SQLException: Server connection failure during transaction. Attempted reconnect 3 times. Giving up. SQLState: 08001 VendorError: 0
> -- > William R. Mussatto, Senior Systems Engineer > Ph. 909-920-9154 ext. 27 > FAX. 909-608-7061 > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
