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
