Re: Ok now connector/J doesn't work.
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 William R. Mussatto wrote: [snip] 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. William, What happens if you do 'telnet localhost 3306'? Does it connect or timeout? If it times out, you either have a firewall in place (which you say you don't), or you have a my.cnf somewhere that says '--skip-networking' (check /etc/mysql/my.cnf or /etc/my.cnf, debian often ships their binaries with a my.cnf with --skip-networking in it). -Mark - -- Mark Matthews MySQL AB, Software Development Manager - Client Connectivity Office: +1 708 332 0507 www.mysql.com -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.6 (GNU/Linux) Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org iD8DBQFBoe/atvXNTca6JD8RAh9eAKCBE5oos0ZhBX7Kt0seRncU4JbbhQCeNg04 u7KflKPQ3KME1hQBEfHqtik= =Rjuf -END PGP SIGNATURE- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Ok now connector/J doesn't work.
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]
Re: Ok now connector/J doesn't work.
William R. Mussatto wrote: Tried it and now I get connection timed out after three tries. I'm running the testbed using the tomcat buried in netbeans. Frankly, the whole concept of running a server from within an IDE sounds so sketchy to me -- but I'm definitely not an IDE kinda guy :-) Have you thought of trying this from a standalone Tomcat? Wouldn't take long to install and test... FWIW! -- Hassan Schroeder - [EMAIL PROTECTED] Webtuitive Design === (+1) 408-938-0567 === http://webtuitive.com dream. code. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Ok now connector/J doesn't work.
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 William R. Mussatto wrote: 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 What is the error message with the _new_ version of Connector/J (it should have more information in it, as the code that throws the exception you give looks like this: throw new SQLException( Server connection failure during transaction. Due to underlying exception: ' + connectionException + '. + (this.paranoid ? : Util.stackTraceToString( connectionException)) + \nAttempted reconnect + this.maxReconnects + times. Giving up., SQLError.SQL_STATE_UNABLE_TO_CONNECT_TO_DATASOURCE); ) That 'underlying exception' bit will be important for anyone who is trying to figure out why you're having problems! -Mark - -- Mark Matthews MySQL AB, Software Development Manager - Client Connectivity Office: +1 708 332 0507 www.mysql.com -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.6 (GNU/Linux) Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org iD8DBQFBopQ5tvXNTca6JD8RAuYXAKCYUaqoE8kgFoIRjX1/bhnWV16rRwCgu0Yg YaG8VeNFXEYq/0eIF03mxQI= =HsNZ -END PGP SIGNATURE- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Ok now connector/J doesn't work.
Hassan Schroeder said: William R. Mussatto wrote: Tried it and now I get connection timed out after three tries. I'm running the testbed using the tomcat buried in netbeans. Frankly, the whole concept of running a server from within an IDE sounds so sketchy to me -- but I'm definitely not an IDE kinda guy :-) Have you thought of trying this from a standalone Tomcat? Wouldn't take long to install and test... FWIW! -- Hassan Schroeder - [EMAIL PROTECTED] Webtuitive Design === (+1) 408-938-0567 === http://webtuitive.com Dropped back to 4.0.22 server and it works. I guess I shouldn't have jumped into 4.1 so soon. Buried in netbeans is a tomcat 4.06 in my installation, has all the directories and so forth. The idea was that you could plub in someone else's JSP Container and test with that. I am now breathing a lot easier. Still some errors but I'm going to bring over a clean copy of the stuff and try to see what's going on. Thanks -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Ok now connector/J doesn't work.
Mark Matthews said: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 William R. Mussatto wrote: 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 What is the error message with the _new_ version of Connector/J (it should have more information in it, as the code that throws the exception you give looks like this: throw new SQLException( Server connection failure during transaction. Due to underlying exception: ' + connectionException + '. + (this.paranoid ? : Util.stackTraceToString( connectionException)) + \nAttempted reconnect + this.maxReconnects + times. Giving up., SQLError.SQL_STATE_UNABLE_TO_CONNECT_TO_DATASOURCE); ) That 'underlying exception' bit will be important for anyone who is trying to figure out why you're having problems! -Mark - -- Mark Matthews MySQL AB, Software Development Manager - Client Connectivity Office: +1 708 332 0507 www.mysql.com Dropped back to server version 4.0.22 and it works (at least to the extent of getting normal jsp errors rather than connection errors). I'll try to look at it later, but I've lost about a week w/4.1 connectivity issues so I have to get what works out. ? I thought I was using the latest current stable version of connector/J. ? Do you want me to try it with the development version? Bill -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Ok now connector/J doesn't work.
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 William R. Mussatto wrote: Mark Matthews said: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 William R. Mussatto wrote: 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 What is the error message with the _new_ version of Connector/J (it should have more information in it, as the code that throws the exception you give looks like this: throw new SQLException( Server connection failure during transaction. Due to underlying exception: ' + connectionException + '. + (this.paranoid ? : Util.stackTraceToString( connectionException)) + \nAttempted reconnect + this.maxReconnects + times. Giving up., SQLError.SQL_STATE_UNABLE_TO_CONNECT_TO_DATASOURCE); ) That 'underlying exception' bit will be important for anyone who is trying to figure out why you're having problems! -Mark - -- Mark Matthews MySQL AB, Software Development Manager - Client Connectivity Office: +1 708 332 0507 www.mysql.com Dropped back to server version 4.0.22 and it works (at least to the extent of getting normal jsp errors rather than connection errors). I'll try to look at it later, but I've lost about a week w/4.1 connectivity issues so I have to get what works out. ? I thought I was using the latest current stable version of connector/J. William, That exception message you print isn't coming from the current stable version of Connector/J (3.0.16), I can just about assure you of that ;) Please try with 3.0.16 if you can. -Mark - -- Mark Matthews MySQL AB, Software Development Manager - Client Connectivity Office: +1 708 332 0507 www.mysql.com -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.6 (GNU/Linux) Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org iD8DBQFBoqSCtvXNTca6JD8RAhCiAJ0R0ti3Q0ZX5p4X+8AjmLiU9fJ1TQCeMUg6 QYRfHRVQfwkZg3OcodcnC4A= =JrJV -END PGP SIGNATURE- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Ok now connector/J doesn't work.
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. -- 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]