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>http://mysql.darksidemagick.jelastic.servint.net</ > > > server> > > > <databasename>mysqldb</databasename> > > > <description></description> > > > <connectstring></connectstring> > > > <logintimeout>120</logintimeout> > > > <initstring></initstring> > > > <hoststring>jdbc:mysql://http:// > > > mysql.darksidemagick.jelastic.servint.net:3306/mysqldb? > > > cacheResultSetMetadata=false&autoReconnect=true</hoststring> > > > <maxconnections>24</maxconnections> > > > <name>mysqldb</name> > > > </datasource> > > > > /Marcus > > > > On Dec 21, 6:35 pm, Matthew Woodward <[email protected]> wrote: > > > > On Wed, Dec 21, 2011 at 4:16 PM, Trenatos <[email protected]> wrote: > > > > > I'm new to CFML > > > > > Welcome! Very glad to have you join the ranks. > > > > > > Now I'm looking at deploying a WAR file to Jelastic, everything works > > > > > fine except for the embedded database. (WAR exported through OpenBD > > > > > Desktop Server). > > > > > Sounds like this may be a separate issue from your real end goal but > > > you're > > > > saying the WAR with H2 that works locally *doesn't* work when deployed > > > > to > > > > Jelastic? If you're interested in investigating that follow up with some > > > > details and we'll see what we can figure out. > > > > > > So I'm looking at connecting to a MySQL db on Jelastic, it's set up, > > > > > but when I try to create a datasource from my dev box, I get this > > > > > error when I click "Submit", after putting in the details in admin > > > > > interface: "Could not verify datasource: Must specify port after ':' > > > > > in connection string" > > > > > Can you provide details (dummying out any sensitive information of > > > course) > > > > with what you're putting in the admin and/or copy the relevant chunk > > > > from > > > > the /WEB-INF/bluedragon/bluedragon.xml file? > > > > > I've set things up on CloudBees and MySQL without any issues so I have a > > > > feeling it'll just be a matter of getting the connection string right > > > > for > > > > Jelastic. > > > > > > Hopefully one of you gurus take pity on a lowly CFML beginner? > > > > > As much as we possibly can. > > > > > Again, welcome to CFML! > > > > -- > > > > Matthew Woodward > > > > [email protected]http://blog.mattwoodward.com > > > > identi.ca / Twitter: @mpwoodward > > > > > Please do not send me proprietary file formats such as Word, PowerPoint, > > > > etc. as attachments. > > >http://www.gnu.org/philosophy/no-word-attachments.html > > > > -- > > > online documentation:http://openbd.org/manual/ > > > google+ hints/tips:https://plus.google.com/115990347459711259462 > > > http://groups.google.com/group/openbd?hl=en > > > -- > > Alex Skinner > > Managing Director > > Pixl8 Interactive > > > Tel: +448452600726 > > Email: [email protected] > > Web: pixl8.co.uk -- online documentation: http://openbd.org/manual/ google+ hints/tips: https://plus.google.com/115990347459711259462 http://groups.google.com/group/openbd?hl=en
