Bitbucket - upgrade Ubuntu 14.04 ->16.04 mysql connector

[Bruce Justin Chippindale]

When I started this was a question.  Now it has an answer. 

Using Bitbucket 4.14.04 

An Ubuntu 14.04 LTS Server with mysql 5.5 gets the server shut down and mysql shut down, and upgraded to Ubuntu 16.04 LTS.   

Which brings in the 5.7.24 version of mysql.  

On restart bitbucket server and mysql report good status (service atlbitbucket status) but the logs show differently and attempting to access the site leads to the message 

"A fatal error has occurred
The following problem occurred, which prevents Atlassian Bitbucket from starting:

The database, as currently configured, is not accessible. 
Could not create connection to database server. Attempted reconnect 3 times. Giving up."

Checked permissions, all good.   

Rather than the line required to connect to mysql 5.5  

jdbc:mysql://localhost:3306/stash?autoReconnect=true&characterEncoding=utf8&useUnicode=true&sessionVariables=storage_engine%3DInnoDB

one must use the line without the InnoDB specification

jdbc.url=jdbc:mysql://localhost:3306/stash?autoReconnect=true&characterEncoding=utf8&useUnicode=true

I provide this clue so that others may not spend so many hours.  The conversion to the use of bitbucket.properties should also be completed. 

Be careful out there.  :-) 

[Ana Retamal]

Hi Bruce! You might want to post your solution as a separate answer rather than as part of your message, so other Community members that come across the same issue can easily identify it, upvote it and accept it :) 

Thanks for sharing it with us!

Have a nice day,

Ana