Failed to get database descriptors

Post Reply
Torkan
Posts: 1
Joined: 26 May 2013 14:48

Failed to get database descriptors

Post by Torkan » 26 May 2013 14:59

Dear all,

I had been try run the openLCA 1.3.0 in windows 8 but there is a something wrong that I cannot solve it.
I would be so grateful if you help me.
thanks,

Here is the part of error log:

Log session start time Sat May 25 22:36:07 EEST 2013

Time Thread Level Category Message
0 main INFO org.openlca Log-level=INFO
6069 main INFO org.openlca.core.application.navigation.NavigationRoot Initialize navigation
6162 main INFO org.openlca.core.application.navigation.NavigationRoot Initialize navigation
249325 main INFO org.openlca.core.application.navigation.NavigationRoot Initialize navigation
281188 main INFO org.openlca.core.database.ServerApp Start MySQL Server C:\Users\Torkan Fazli\AppData\Local\openLCA\bin\mysqld-nt.exe.
281189 main INFO org.openlca.core.database.ServerApp Using data directory C:\Users\Torkan Fazli\openLCA-data\data
281248 main INFO org.openlca.core.database.ServerApp Server response:
296150 main ERROR org.openlca.core.database.DescriptorFetch Failed to get database descriptors
com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1117)
at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:355)
at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2461)
at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2498)
at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2283)
at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:822)
at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:404)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:317)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at org.openlca.core.database.ConnectionData.createServerConnection(Unknown Source)
at org.openlca.core.database.DescriptorFetch.doFetch(Unknown Source)
at org.openlca.core.database.MySQLServer.getDatabaseDescriptors(Unknown Source)
at org.openlca.core.application.db.ConnectionJob.run(Unknown Source)
at org.openlca.core.application.WrappedUIJob$1.run(Unknown Source)
at org.eclipse.swt.custom.BusyIndicator.showWhile(BusyIndicator.java:70)
at org.openlca.core.application.WrappedUIJob.runInUIThread(Unknown Source)
at org.eclipse.ui.progress.UIJob$1.run(UIJob.java:95)
at org.eclipse.swt.widgets.RunnableLock.run(RunnableLock.java:35)
at org.eclipse.swt.widgets.Synchronizer.runAsyncMessages(Synchronizer.java:135)
at org.eclipse.swt.widgets.Display.runAsyncMessages(Display.java:4144)
at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3761)
at org.eclipse.ui.internal.Workbench.runEventLoop(Workbench.java:2701)
at org.eclipse.ui.internal.Workbench.runUI(Workbench.java:2665)
at org.eclipse.ui.internal.Workbench.access$4(Workbench.java:2499)
at org.eclipse.ui.internal.Workbench$7.run(Workbench.java:679)
at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:332)
at org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Workbench.java:668)
at org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.java:149)
at org.openlca.core.application.plugin.Application.start(Unknown Source)
at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:196)
at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(EclipseAppLauncher.java:110)
at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(EclipseAppLauncher.java:79)
at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:353)
at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:180)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.eclipse.equinox.launcher.Main.invokeFramework(Main.java:629)
at org.eclipse.equinox.launcher.Main.basicRun(Main.java:584)
at org.eclipse.equinox.launcher.Main.run(Main.java:1438)
Caused by: java.net.ConnectException: Connection refused: connect
at java.net.DualStackPlainSocketImpl.connect0(Native Method)
at java.net.DualStackPlainSocketImpl.socketConnect(Unknown Source)
at java.net.AbstractPlainSocketImpl.doConnect(Unknown Source)
at java.net.AbstractPlainSocketImpl.connectToAddress(Unknown Source)
at java.net.AbstractPlainSocketImpl.connect(Unknown Source)
at java.net.PlainSocketImpl.connect(Unknown Source)
at java.net.SocksSocketImpl.connect(Unknown Source)
at java.net.Socket.connect(Unknown Source)
at java.net.Socket.connect(Unknown Source)
at java.net.Socket.<init>(Unknown Source)
at java.net.Socket.<init>(Unknown Source)
at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:259)
at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:305)
... 46 more

aciroth
Posts: 750
Joined: 09 May 2010 23:28

Re: Failed to get database descriptors

Post by aciroth » 26 May 2013 22:43

Hi Torkan,
thanks for posting this in the forum (also) -
Communications link failure
indicates that the connection between database and openLCA application cannot be established; for example it might be blocked by a firewall. Can you maybe check (and reply here?) - thank you!
Andreas

pierreC
Posts: 3
Joined: 03 Jun 2013 16:37

Re: Failed to get database descriptors

Post by pierreC » 03 Jun 2013 16:50

Dear all,

I have exactly the same problem than Torkan. I have tried to temporarily uninstall the firewall, but the problem remains the same.

Thank you for your answer.

Here is the beginning of the error log:

66601 main ERROR org.openlca.core.database.DescriptorFetch Failed to get database descriptors
java.sql.SQLException: Access denied for user 'root'@'localhost' (using password: YES)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1074)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4120)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4052)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:925)
at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:4615)
at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1302)
at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2465)
at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2498)
at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2283)
at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:822)
at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:404)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:317)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
etc....

aciroth
Posts: 750
Joined: 09 May 2010 23:28

Re: Failed to get database descriptors

Post by aciroth » 03 Jun 2013 21:15

Hi Pierre,
there can be several reasons, the error message shows only that no connection can be established, using user root and no password (which is the required setting for an embedded MySQL server, and default for using an external server). Did you use the embedded server, or an external, maybe with a different password for the root user? If yes you need to enter this password in the connection settings (see also in the wiki, here: http://openlca.org/documentation/index. ... connection and here http://openlca.org/documentation/index. ... stallation.
Hope this helps!
Andreas

MartinVos
Posts: 1
Joined: 06 Nov 2013 11:57

Re: Failed to get database descriptors

Post by MartinVos » 08 Nov 2013 09:49

Hi,

I have the same problem. I installed OpenLCA in windows 8. I tried everything you described in the wiki. Turned of firewall on computer and in the modem, in the map bin the two files are present.

I don't know what to do, please help...

Martin

aciroth
Posts: 750
Joined: 09 May 2010 23:28

Re: Failed to get database descriptors

Post by aciroth » 10 Nov 2013 12:12

Hi, as said there can be several reasons. Are you admin? Or, did another user install openLCA? Some users report that Microsoft Security Essentials block the connection.
If you want we can organise a webmeeting, please send me a note if you are interested.
- as said above, the new openLCA version will also be available in a non-client server structure and therefore much easier to install.
Best wishes,
Andreas

Post Reply

Who is online

Users browsing this forum: No registered users and 4 guests