-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hi, I have a working database in mysql which I use through "rekall". I'm trying to use it through OOo (2.0.0-1.1); with the previous patch I got access, but now I can't. I use the jdbc driver - I think, it is not clear how all this is supposed to work. Now I get this error: 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 ** What does it mean? It worked previously. Is it a bug? - -- Cheers, Carlos Robinson -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.0 (GNU/Linux) Comment: Made with pgp4pine 1.76 iD8DBQFDenHOtTMYHG2NR9URAv7qAJ9v9SWTuxMPEsDwlAwsN3VWCviyGgCfeS+z zvA+QIjqMwVRbvvKiF6KUIk= =mc4a -----END PGP SIGNATURE-----
The embedded java.net.ConnectException: Connection refused
means pretty much what it says. The connection could not be
established. Likely causes, would be: database not running, database
running on a different port from the one you specified, jdbc connection
URL mistyped, or a firewall between you and the service.
HTH
Cheers,
Simon
--- "Carlos E. R."
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1
Hi,
I have a working database in mysql which I use through "rekall". I'm trying to use it through OOo (2.0.0-1.1); with the previous patch I got access, but now I can't. I use the jdbc driver - I think, it is not clear how all this is supposed to work.
Now I get this error:
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 **
What does it mean? It worked previously. Is it a bug?
- -- Cheers, Carlos Robinson
-----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.0 (GNU/Linux) Comment: Made with pgp4pine 1.76
iD8DBQFDenHOtTMYHG2NR9URAv7qAJ9v9SWTuxMPEsDwlAwsN3VWCviyGgCfeS+z zvA+QIjqMwVRbvvKiF6KUIk= =mc4a -----END PGP SIGNATURE-----
-- Check the headers for your unsubscription address For additional commands send e-mail to suse-linux-e-help@suse.com Also check the archives at http://lists.suse.com Please read the FAQs: suse-linux-e-faq@suse.com
"You can tell whether a man is clever by his answers. You can tell whether a man is wise by his questions." Naguib Mahfouz __________________________________ Yahoo! Mail - PC Magazine Editors' Choice 2005 http://mail.yahoo.com
-----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-----
On Tuesday 15 November 2005 6:27 pm, Carlos E. R. wrote:
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"
Try using the ip number of your local machine instead of localhost. I couldn't connect here with localhost, but could by using the machine's ip 192.168.1.2 ( I have a suspicion that my mysql install doesn't listen on localhost, but uses sockets instead, maybe that's why). Scott -- POPFile, the OpenSource EMail Classifier http://popfile.sourceforge.net/ Linux 2.6.11.4-21.9-default x86_64 SuSE Linux 9.3 (x86-64)
Carlos, Scott, On Tuesday 15 November 2005 20:54, Scott Leighton wrote:
On Tuesday 15 November 2005 6:27 pm, Carlos E. R. wrote:
No. It is local.
...
Try using the ip number of your local machine instead of localhost. I couldn't connect here with localhost, but could by using the machine's ip 192.168.1.2 ( I have a suspicion that my mysql install doesn't listen on localhost, but uses sockets instead, maybe that's why).
To see on which address or addresses MySQL (or any process) is listening, use netstat: % netstat -A inet -l |egrep mysql tcp 0 0 *:mysql *:* LISTEN % netstat -A inet -n -l |egrep 3306 tcp 0 0 0.0.0.0:3306 0.0.0.0:* LISTEN This indicates both localhost and my routable address should work, and in fact they do.
Scott
Randall Schulz
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 The Tuesday 2005-11-15 at 20:54 -0800, Scott Leighton wrote:
Try using the ip number of your local machine instead of localhost. I couldn't connect here with localhost, but could by using the machine's ip 192.168.1.2 ( I have a suspicion that my mysql install doesn't listen on localhost, but uses sockets instead, maybe that's why).
Ah! Yes, I get something different now: SQL Status: 28000 Error code: 1045 Access denied for user 'cer'@'nimrodel.valinor' (using password: YES) which is weird. Very weird, that same password works with phpmyadmin. nimrodel:~ # netstat -A inet -l |egrep mysql tcp 0 0 nimrodel.valinor:mysql *:* LISTEN nimrodel:~ # netstat -A inet -n -l |egrep 3306 tcp 0 0 192.168.100.2:3306 0.0.0.0:* LISTEN Ah! User "cer" in mysql is defined for "localhost", not the full name... lets change it. [...] Yes, I can access it using OOo now. Bingo! Rekall doesn't seem to complain with the change, nor phpmyadmin. Weird! Why did it work previously? What changed? Now I have a different problem... I try to create a Table_view (with a single field, for just testing), and it will not save (although it displays correctly): SQL Status: 42000 Error code: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'VIEW `View1` AS SELECT `Titulo` FROM `Libros` `Libros`' at line 1 I use rekall or OOo because I have no idea at all of sql; now it seems that OOo creates broken SQL! Then I got instead a Query/view - but it seems I can not add data to the database through a query-view; my tables are linked, so I need to indicate the relationships, but if I do then I can not add data... too bad, it is unworkable, I wanted a functionality like "access". I can do it with rekall, though. Arghh! I wonder if there is a manual on using OOo with mysql... - -- Cheers, Carlos Robinson -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.0 (GNU/Linux) Comment: Made with pgp4pine 1.76 iD8DBQFDe+DdtTMYHG2NR9URAg8IAJ9PIDhpV89SrVUUudFpYPN41/mPuACeL1TG gZGjRWfegM1PgV8LGJ2pDf4= =Q5nC -----END PGP SIGNATURE-----
participants (4)
-
Carlos E. R.
-
Randall R Schulz
-
Scott Leighton
-
Simon Roberts