openLCA archived user forum

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

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.

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?
Best

Michael

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

Hi Andreas,

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

Best,

Michael

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

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

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

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

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