-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 The Tuesday 2005-11-15 at 15:58 -0800, Simon Roberts wrote:
The embedded java.net.ConnectException: Connection refused means pretty much what it says.
Not clear enough, and not true.
The connection could not be established. Likely causes, would be: database not running,
No. It is running, I tested with rekall.
database running on a different port from the one you specified,
No. It is the standard mysql setting, and it worked before YOU updated OOo. OOo uses port 3306.
jdbc connection URL mistyped,
No. That database configuration worked previous to the YOU update. I have tried to create it again, with default settings, and it doesn't work.
or a firewall between you and the service.
No. It is local. Look, I do this. Create new database --> database Wizard: 1) Connect to an existing database: MySQL [ Next >> ] 2) Connect using JDBC (Java Database Connectivity) [ Next >> ] 3) Name of the database: "Biblioteca" Server URL: "localhost" Port number: "3306" MySQL JDBC driver class: "com.mysql.jdbc.Driver" [ Test class ] --> tests ok. 4) User name: "cer" [x] password required [ Test connection ] type password (which is the the correct one, I tested it using phpMyAdmin) --> got exception as follows: SQL Status: 08S01 Communications link failure due to underlying exception: ** BEGIN NESTED EXCEPTION ** java.net.SocketException MESSAGE: java.net.ConnectException: Connection refused STACKTRACE: java.net.SocketException: java.net.ConnectException: Connection refused at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:151) at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:280) at com.mysql.jdbc.Connection.createNewIO(Connection.java:1699) at com.mysql.jdbc.Connection.<init>(Connection.java:405) at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:268) ** END NESTED EXCEPTION ** /var/lib/mysql/mysqld.log --> empty. Iptraf shows the connection is attempted: IPTraf TCP Connections (Source Host:Port) Packets Bytes Flags Iface localhost:mysql = 1 40 RESET lo localhost:suncluster = 0 0 ---- lo Ethereal shows the same info, I think. somebody sends a [SYN] to mysql, and it gets back a [RST, ACK]. I don't see why. Remember that I test that same database with phpMyAdmin and rekall, and I have no problem at all. It is something peculiar to OpenOffice. - -- Cheers, Carlos Robinson -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.0 (GNU/Linux) Comment: Made with pgp4pine 1.76 iD8DBQFDepkQtTMYHG2NR9URArFsAKCZU8Sn76hXsX7LOPPnswJzmr6wHQCeOozo W40TmbjE9UZ1dKkhniLnaAw= =TQbE -----END PGP SIGNATURE-----