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
