Remote Database Functionality

mptsang
Posts: 27
Joined: 07 May 2014 09:49

Remote Database Functionality

Post by mptsang » 27 May 2014 10:21

Hello,

We are attempting to connect to a database on a central server here in our computer lab at the University, however we are having trouble remotely accessing the databses from our individual computers (which are linked remotely back to the central server). Do you have any advice for properly accessing remote databases? Perhaps we have to install openLCA on the server itself, or is it possible to just have the database on the server?

Best

Michael

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

Re: Remote Database Functionality

Post by aciroth » 27 May 2014 23:03

Hi Michael,
this is possible with only mysql installed on the server but it might be easier when you install openLCA there, too. There are not many possible bottlenecks, for the mySQL server, you need to have the typical openLCA user, password and port (see the many other posts on this issue), and firewalls need to accept the connection, and from the clients, you need to create a non-embedded mySQL connection which "points" to the server IP, with the same user and password, and then connect to it. Maybe the screenshot helps, my openLCA 1.3.4 installation with three different mySQL locations. This works also for openLCA 1.4 btw.
2014-05-27 23_01_35-openLCA framework 1.3.4.png
2014-05-27 23_01_35-openLCA framework 1.3.4.png (7.6 KiB) Viewed 8286 times

mptsang
Posts: 27
Joined: 07 May 2014 09:49

Re: Remote Database Functionality

Post by mptsang » 18 Jul 2014 13:18

Hi Andreas,

Thanks for the advice. We were able to set up a successful use, pass and port, however when we create this new remote database (using 1.4 by the way) we receive a few errors during the setup. I am attaching the image so you can see.

Do you have any insight why we can't produce a successful remote database given that error log?
OpenLCA Remote Database Errors.png
OpenLCA Remote Database Errors.png (107.39 KiB) Viewed 8186 times
Best

Michael

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

Re: Remote Database Functionality

Post by aciroth » 18 Jul 2014 14:07

Hi Michael,
good to see that you are one step further (at least) - do you create the database from remote or directly on the server, locally?
Best
Andreas

mptsang
Posts: 27
Joined: 07 May 2014 09:49

Re: Remote Database Functionality

Post by mptsang » 19 Jul 2014 20:12

Hi Andreas,

We are creating the database from the remote computer (ie. not on the server). Does that create a problem?

Best,

Michael

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

Re: Remote Database Functionality

Post by aciroth » 20 Jul 2014 13:02

Hi Michael,
please try to create the DB on the server directly.
Best
Andreas

mptsang
Posts: 27
Joined: 07 May 2014 09:49

Re: Remote Database Functionality

Post by mptsang » 02 Sep 2014 12:50

Hi Andreas,

We were working with our computer technician regarding this issue and he installed wampserver on the PC that contains the mysql server. But we had some problems:

1- if we try to create a new database directly from openlca on the server (localhost / port 3306 / login root. The root user has all privileges), it is not possible (openlca just sits indefinitely trying to make a connection)

2 - if we create a (mysql) table on the server and try to connect to this using openlca (same parameters as listed above), the connection is made but there are many errors created in the log file. Long story short, it does not produce a properly working database. For instance, one error message received was "org.openlca.core.database.DatabaseException: failed to execute query: select id,ref_id,name,description from tbl_actors where f_category is nul"

Any ideas what may be the problem, or are we not installing the DB properly on the remote server?

Best,

Michael

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

Re: Remote Database Functionality

Post by aciroth » 02 Sep 2014 13:18

Hi Michael,
can you please contact me directly - thanks. These remote connection are (a bit) special and depend on the specific IT environment.
Best
Andreas

mptsang
Posts: 27
Joined: 07 May 2014 09:49

Re: Remote Database Functionality

Post by mptsang » 15 Sep 2014 11:57

Hi Andreas,

I sent you a personal email the other week. Maybe it wasn't received? I can be reached at mptsang@gmail.com

Best,

Michael

mptsang
Posts: 27
Joined: 07 May 2014 09:49

Re: Remote Database Functionality

Post by mptsang » 03 Oct 2014 13:27

Hi Andreas,

Are you able to follow up with us on this issue? Still not able to produce a working non-embedded connection.

Best,

Michael

Post Reply

Who is online

Users browsing this forum: No registered users and 1 guest