Problems with using non-embedded MySQL server
Posted: 21 Jun 2011 17:43
Hello OpenLCA team,
We are trying to configure OpenLCA to work with a MySQL server that is installed independently on a PC (Windows 7). We see multiple advantanges to this including being able to point the MySQL data directory to the place of our choice, being able to access the data outside of OpenLCA, potentially working with the DB with outside applications, etc.
We are able to point OpenLCA to this new server and successful connect to it and create a new database. But we are having two problems with this:
1. Creating a new DB from a script (exported from an OpenLCA database on the embedded MySQL server) is not working (we don't get an error message but it is just creating a blank DB)
2. Trying to import a group of processes in Ecospold format is failing where it worked successfully on the embedded server version.
One potential difference between the databases we noted is that the independent MySQL server has a password for the root user; the embedded server does not have a password for the root user. But we don't know if this is related to the error. I can send the log file separately is this would be useful.
More details:
OpenLCA 1.2.1 32bit
Independent MySQL server: MySQL Community Server v5.55, 32-bit version
Windows 7 OS.
Any suggestions are appreciated. Thanks. Wes Ingwersen, EPA ORD
We are trying to configure OpenLCA to work with a MySQL server that is installed independently on a PC (Windows 7). We see multiple advantanges to this including being able to point the MySQL data directory to the place of our choice, being able to access the data outside of OpenLCA, potentially working with the DB with outside applications, etc.
We are able to point OpenLCA to this new server and successful connect to it and create a new database. But we are having two problems with this:
1. Creating a new DB from a script (exported from an OpenLCA database on the embedded MySQL server) is not working (we don't get an error message but it is just creating a blank DB)
2. Trying to import a group of processes in Ecospold format is failing where it worked successfully on the embedded server version.
One potential difference between the databases we noted is that the independent MySQL server has a password for the root user; the embedded server does not have a password for the root user. But we don't know if this is related to the error. I can send the log file separately is this would be useful.
More details:
OpenLCA 1.2.1 32bit
Independent MySQL server: MySQL Community Server v5.55, 32-bit version
Windows 7 OS.
Any suggestions are appreciated. Thanks. Wes Ingwersen, EPA ORD