I've read that at this stage mysql is not open for the outside world... Will be in the next release they wrote. I will try to create a simple DB on my Jelastic setup, since i now got the root password for mysql and can create a user and a small DB thr the phpmy...admin. Will try this in about an Hour as soon as get into the office.
/Mats/ On Thursday, December 22, 2011, Trenatos <[email protected]> wrote: > I haven't worked with Jelastic before, so I guess it's possible. > My brain is fried at the moment, but I'm going to play with it. > > I'll drop an update later on or tomorrow. > > /Marcus > > On Dec 21, 7:46 pm, Alex Skinner <[email protected]> wrote: >> Are you definitely sure its open to the outside world ? MySQL that is. >> >> Its possible you need to use phpmyadmin to get your data to and grow >> to jelastic and can only connect internally within the jelastic >> environment. >> >> A >> >> On Dec 22, 1:23 am, Trenatos <[email protected]> wrote: >> >> >> >> >> >> >> >> > Hi Alex, >> >> > That got rid of that error, but now it's dropping another error. >> > "Could not verify datasource: Could not create connection to database >> > server. Attempted reconnect 3 times. Giving up." >> > It responds to ping, but won't connect from OpenBD. >> > (I created another user and DB to make sure it wasn't locked to >> > localhost, too.) >> >> > On Dec 21, 7:00 pm, Alex Skinner <[email protected]> wrote: >> >> > > Your mysql host name should not have http:// in front >> >> > > e.g. see jdbc:mysql://http:// >> > > mysql.darksidemagick.jelastic.servint.net:3306< http://mysql.darksidemagick.jelastic.servint.net:3306/mysqldb> >> >> > > Thats probably it >> >> > > Cheers >> >> > > A >> >> > > On 22 December 2011 00:48, Trenatos <[email protected]> wrote: >> >> > > > Thanks for the welcome, Matthew! >> >> > > > I run OpenBD Desktop on my local machine. >> > > > This is where I wrote the sites and embedded the H2 DB, when I create >> > > > a WAR and deploy that in Jelastic, it breaks with the error that it >> > > > can't find the db (With a local path, not a relative one). >> > > > It worked fine locally, no issues. >> > > > This may be super simple, I've never used Java, or CFML so this is a >> > > > brand new world for me in most parts. >> >> > > > Ok, about the MySQL issue. >> > > > On my local box I went into the admin, Data & Services, Datasources, >> > > > fill in a name (mysqldb), database type MySQL, Add Datasource, fill in >> > > > the info on the next page (URL, username, password, database name, >> > > > server port is already set) >> > > > I hit Submit and it drops me back to the previous screen just like >> > > > when I created the H2's, except with the error at the top. >> > > > "Could not verify datasource: Must specify port after ':' in >> > > > connection string" >> >> > > > The datasource part of the XML (Which I've never opened before, btw.) >> > > > looks like this, with the specifics removed. >> >> > > > <datasource name="mysqldb"> >> > > > <displayname>mysqldb</displayname> >> > > > <connectionretries>0</connectionretries> >> > > > <password>PasswordHere</password> >> > > > <sqldelete>true</sqldelete> >> > > > <sqlupdate>true</sqlupdate> >> > > > <username>root</username> >> > > > <drivername>com.mysql.jdbc.Driver</drivername> >> > > > <sqlstoredprocedures>true</sqlstoredprocedures> >> > > > <perrequestconnections>false</perrequestconnections> >> > > > <sqlinsert>true</sqlinsert> >> > > > <sqlselect>true</sqlselect> >> > > > <connectiontimeout>120</connectiontimeout> >> > > > <port>3306</port> >> > > > <server> -- online documentation: http://openbd.org/manual/ google+ hints/tips: https://plus.google.com/115990347459711259462 http://groups.google.com/group/openbd?hl=en
