Remote Database Functionality

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

Re: Remote Database Functionality

Post by aciroth » 03 Oct 2014 19:47

Sorry Michael I will write you. Cheers

msrocka
Posts: 18
Joined: 29 Jan 2013 10:07

Re: Remote Database Functionality

Post by msrocka » 06 Oct 2014 08:31

Hi Michael,

The remote database function does not create a new databases on the MySQL server but just stores the connection data to such databases. Thus, you first have to create the MySQL database outside of openLCA with the following database script: https://github.com/GreenDelta/olca-modu ... _mysql.sql. Just uncomment the ‘create database …’ statements and replace the database name 'openlca' with the name you want to use for your database and execute this script in a query browser.

Hope this helps,
Michael

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

Re: Remote Database Functionality

Post by mptsang » 09 Oct 2014 08:32

Hi Michael S,

Thanks for the help. To be sure, you are referring to Line 9 when you say change the database name? And what is meant by "uncomment the create database statement?" I don't see any quotation marks or special characters surrounding that information in Line 9, but maybe you meant something else?

Best,

Michael T

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

Re: Remote Database Functionality

Post by aciroth » 09 Oct 2014 17:11

Hi Michael T,
uncoment means: remove the comment character so that the line is used in the script and not considered as a comment any more. For more details can you please consider a service contract? Thank you very much.
Best wishes,
Andreas

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

Re: Remote Database Functionality

Post by mptsang » 09 Oct 2014 21:27

Hi Andreas,

No problem, we will be in contact about the service contract.

Best,

Michael

Post Reply

Who is online

Users browsing this forum: No registered users and 7 guests