Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
Deleted user
0 / 0 points
Next:
badges earned

Your Points Tracker
Challenges
Leaderboard
  • Global
  • Feed

Badge for your thoughts?

You're enrolled in our new beta rewards program. Join our group to get the inside scoop and share your feedback.

Join group
Recognition
Give the gift of kudos
You have 0 kudos available to give
Who do you want to recognize?
Why do you want to recognize them?
Kudos
Great job appreciating your peers!
Check back soon to give more kudos.

Past Kudos Given
No kudos given
You haven't given any kudos yet. Share the love above and you'll see it here.

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Cannot configuring Bamboo for external DB, Microsoft SQL Edited

Hi,

After evaluation period, I decide to move all the data stored embedded  DB to external DB, MsSql provided by Azure cloud.

I have set up and configured for MsSql on Azure side, (i.e. firewall settings..) and follow the instruction in below site

https://confluence.atlassian.com/bamboo/microsoft-sql-server-289276827.html

I tried to connect bamboo with MsSql via JDBC connection but each time I try it, I got following error in bamboo's catalina.out file

 

2017-09-25 10:10:17,983 WARN [http-nio-8085-exec-10] [TokenHelper] Could not find token mapped to token name: token

2017-09-25 10:10:20,134 INFO [http-nio-8085-exec-11] [AccessLogFilter] 0:0:0:0:0:0:0:1 POST http://localhost:8085/setup/performSetupDatabaseConnection.action 365488kb

2017-09-25 10:10:22,179 INFO [http-nio-8085-exec-12] [AccessLogFilter] 0:0:0:0:0:0:0:1 POST http://localhost:8085/setup/performSetupDatabaseConnection.action 359793kb

2017-09-25 10:10:24,209 INFO [http-nio-8085-exec-13] [AccessLogFilter] 0:0:0:0:0:0:0:1 POST http://localhost:8085/setup/performSetupDatabaseConnection.action 357837kb

2017-09-25 10:10:26,218 INFO [http-nio-8085-exec-14] [AccessLogFilter] 0:0:0:0:0:0:0:1 POST http://localhost:8085/setup/performSetupDatabaseConnection.action 356859kb

2017-09-25 10:10:28,228 INFO [http-nio-8085-exec-15] [AccessLogFilter] 0:0:0:0:0:0:0:1 POST http://localhost:8085/setup/performSetupDatabaseConnection.action 355881kb

2017-09-25 10:10:30,236 INFO [http-nio-8085-exec-16] [AccessLogFilter] 0:0:0:0:0:0:0:1 POST http://localhost:8085/setup/performSetupDatabaseConnection.action 354903kb

2017-09-25 10:10:32,267 INFO [http-nio-8085-exec-17] [AccessLogFilter] 0:0:0:0:0:0:0:1 POST http://localhost:8085/setup/performSetupDatabaseConnection.action 353925kb

2017-09-25 10:10:32,994 ERROR [performSetupDatabaseConnectionBackgroundThread] [DefaultAtlassianBootstrapManager] Could not successfully test your database: 

com.microsoft.sqlserver.jdbc.SQLServerException: SQL Server did not return a response. The connection has been closed. ClientConnectionId:5ca04e90-ebf5-4c6f-8440-1867e31a521f

at com.microsoft.sqlserver.jdbc.SQLServerConnection.terminate(SQLServerConnection.java:2392)

at com.microsoft.sqlserver.jdbc.SQLServerConnection.terminate(SQLServerConnection.java:2376)

at com.microsoft.sqlserver.jdbc.TDSReader.readPacket(IOBuffer.java:6680)

at com.microsoft.sqlserver.jdbc.TDSCommand.startResponse(IOBuffer.java:7993)

at com.microsoft.sqlserver.jdbc.TDSCommand.startResponse(IOBuffer.java:7945)

at com.microsoft.sqlserver.jdbc.SQLServerConnection.sendLogon(SQLServerConnection.java:4375)

at com.microsoft.sqlserver.jdbc.SQLServerConnection.logon(SQLServerConnection.java:3188)

at com.microsoft.sqlserver.jdbc.SQLServerConnection.access$100(SQLServerConnection.java:61)

at com.microsoft.sqlserver.jdbc.SQLServerConnection$LogonCommand.doExecute(SQLServerConnection.java:3151)

at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:7535)

at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:2438)

at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectHelper(SQLServerConnection.java:1973)

at com.microsoft.sqlserver.jdbc.SQLServerConnection.login(SQLServerConnection.java:1616)

at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectInternal(SQLServerConnection.java:1447)

at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(SQLServerConnection.java:788)

at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(SQLServerDriver.java:1187)

at java.sql.DriverManager.getConnection(DriverManager.java:664)

at java.sql.DriverManager.getConnection(DriverManager.java:247)

at com.atlassian.config.bootstrap.DefaultAtlassianBootstrapManager.getTestDatabaseConnection(DefaultAtlassianBootstrapManager.java:343)

at com.atlassian.bamboo.ww2.actions.setup.SetupDatabaseConnectionAction.createConnection(SetupDatabaseConnectionAction.java:143)

at com.atlassian.bamboo.ww2.actions.setup.SetupDatabaseConnectionAction.validateDatabase(SetupDatabaseConnectionAction.java:122)

at com.atlassian.bamboo.ww2.actions.setup.SetupDatabaseConnectionAction.validateFields(SetupDatabaseConnectionAction.java:71)

at com.atlassian.bamboo.ww2.actions.setup.SetupDatabaseConnectionAction.execute(SetupDatabaseConnectionAction.java:82)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

at java.lang.reflect.Method.invoke(Method.java:498)

at ognl.OgnlRuntime.invokeMethod(OgnlRuntime.java:873)

at ognl.OgnlRuntime.callAppropriateMethod(OgnlRuntime.java:1539)

at ognl.ObjectMethodAccessor.callMethod(ObjectMethodAccessor.java:68)

at com.opensymphony.xwork2.ognl.accessor.XWorkMethodAccessor.callMethodWithDebugInfo(XWorkMethodAccessor.java:96)

at com.opensymphony.xwork2.ognl.accessor.XWorkMethodAccessor.callMethod(XWorkMethodAccessor.java:88)

at ognl.OgnlRuntime.callMethod(OgnlRuntime.java:1615)

at ognl.ASTMethod.getValueBody(ASTMethod.java:91)

at ognl.SimpleNode.evaluateGetValueBody(SimpleNode.java:212)

at ognl.SimpleNode.getValue(SimpleNode.java:258)

at ognl.Ognl.getValue(Ognl.java:467)

at ognl.Ognl.getValue(Ognl.java:431)

at com.opensymphony.xwork2.ognl.OgnlUtil$3.execute(OgnlUtil.java:351)

at com.opensymphony.xwork2.ognl.OgnlUtil.compileAndExecuteMethod(OgnlUtil.java:403)

at com.opensymphony.xwork2.ognl.OgnlUtil.callMethod(OgnlUtil.java:349)

at com.opensymphony.xwork2.DefaultActionInvocation.invokeAction(DefaultActionInvocation.java:436)

at com.opensymphony.xwork2.DefaultActionInvocation.invokeActionOnly(DefaultActionInvocation.java:291)

at org.apache.struts2.interceptor.BackgroundProcess$1.run(BackgroundProcess.java:58)

at java.lang.Thread.run(Thread.java:748)

2017-09-25 10:10:32,997 ERROR [performSetupDatabaseConnectionBackgroundThread] [SetupDatabaseConnectionAction] Unable to connect to database: com.microsoft.sqlserver.jdbc.SQLServerException: SQL Server did not return a response. The connection has been closed. ClientConnectionId:5ca04e90-ebf5-4c6f-8440-1867e31a521f

com.atlassian.config.bootstrap.BootstrapException: com.microsoft.sqlserver.jdbc.SQLServerException: SQL Server did not return a response. The connection has been closed. ClientConnectionId:5ca04e90-ebf5-4c6f-8440-1867e31a521f

at com.atlassian.config.bootstrap.DefaultAtlassianBootstrapManager.getTestDatabaseConnection(DefaultAtlassianBootstrapManager.java:355)

at com.atlassian.bamboo.ww2.actions.setup.SetupDatabaseConnectionAction.createConnection(SetupDatabaseConnectionAction.java:143)

at com.atlassian.bamboo.ww2.actions.setup.SetupDatabaseConnectionAction.validateDatabase(SetupDatabaseConnectionAction.java:122)

at com.atlassian.bamboo.ww2.actions.setup.SetupDatabaseConnectionAction.validateFields(SetupDatabaseConnectionAction.java:71)

at com.atlassian.bamboo.ww2.actions.setup.SetupDatabaseConnectionAction.execute(SetupDatabaseConnectionAction.java:82)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

at java.lang.reflect.Method.invoke(Method.java:498)

at ognl.OgnlRuntime.invokeMethod(OgnlRuntime.java:873)

at ognl.OgnlRuntime.callAppropriateMethod(OgnlRuntime.java:1539)

at ognl.ObjectMethodAccessor.callMethod(ObjectMethodAccessor.java:68)

at com.opensymphony.xwork2.ognl.accessor.XWorkMethodAccessor.callMethodWithDebugInfo(XWorkMethodAccessor.java:96)

at com.opensymphony.xwork2.ognl.accessor.XWorkMethodAccessor.callMethod(XWorkMethodAccessor.java:88)

at ognl.OgnlRuntime.callMethod(OgnlRuntime.java:1615)

at ognl.ASTMethod.getValueBody(ASTMethod.java:91)

at ognl.SimpleNode.evaluateGetValueBody(SimpleNode.java:212)

at ognl.SimpleNode.getValue(SimpleNode.java:258)

at ognl.Ognl.getValue(Ognl.java:467)

at ognl.Ognl.getValue(Ognl.java:431)

at com.opensymphony.xwork2.ognl.OgnlUtil$3.execute(OgnlUtil.java:351)

at com.opensymphony.xwork2.ognl.OgnlUtil.compileAndExecuteMethod(OgnlUtil.java:403)

at com.opensymphony.xwork2.ognl.OgnlUtil.callMethod(OgnlUtil.java:349)

at com.opensymphony.xwork2.DefaultActionInvocation.invokeAction(DefaultActionInvocation.java:436)

at com.opensymphony.xwork2.DefaultActionInvocation.invokeActionOnly(DefaultActionInvocation.java:291)

at org.apache.struts2.interceptor.BackgroundProcess$1.run(BackgroundProcess.java:58)

at java.lang.Thread.run(Thread.java:748)

Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: SQL Server did not return a response. The connection has been closed. ClientConnectionId:5ca04e90-ebf5-4c6f-8440-1867e31a521f

at com.microsoft.sqlserver.jdbc.SQLServerConnection.terminate(SQLServerConnection.java:2392)

at com.microsoft.sqlserver.jdbc.SQLServerConnection.terminate(SQLServerConnection.java:2376)

at com.microsoft.sqlserver.jdbc.TDSReader.readPacket(IOBuffer.java:6680)

at com.microsoft.sqlserver.jdbc.TDSCommand.startResponse(IOBuffer.java:7993)

at com.microsoft.sqlserver.jdbc.TDSCommand.startResponse(IOBuffer.java:7945)

at com.microsoft.sqlserver.jdbc.SQLServerConnection.sendLogon(SQLServerConnection.java:4375)

at com.microsoft.sqlserver.jdbc.SQLServerConnection.logon(SQLServerConnection.java:3188)

at com.microsoft.sqlserver.jdbc.SQLServerConnection.access$100(SQLServerConnection.java:61)

at com.microsoft.sqlserver.jdbc.SQLServerConnection$LogonCommand.doExecute(SQLServerConnection.java:3151)

at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:7535)

at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:2438)

at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectHelper(SQLServerConnection.java:1973)

at com.microsoft.sqlserver.jdbc.SQLServerConnection.login(SQLServerConnection.java:1616)

at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectInternal(SQLServerConnection.java:1447)

at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(SQLServerConnection.java:788)

at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(SQLServerDriver.java:1187)

at java.sql.DriverManager.getConnection(DriverManager.java:664)

at java.sql.DriverManager.getConnection(DriverManager.java:247)

at com.atlassian.config.bootstrap.DefaultAtlassianBootstrapManager.getTestDatabaseConnection(DefaultAtlassianBootstrapManager.java:343)

... 26 more

2017-09-25 10:10:32,998 INFO [performSetupDatabaseConnectionBackgroundThread] [SetupDatabaseConnectionAction] Database configuration is invalid: {}

 

 

 

I've tried to connect to the MsSql server via Sql manager studio and also other tools on the same machine and all are connected successfully. 

 

Does anybody has idea what I've missed? or is there an good reference connecting MySql provided Azure cloud to Bamboo?

 

Thank you

 

1 answer

0 votes

Hi Brent,

For the error message, looks like there is something wrong with the connection string, would you mind to share here with us how you're putting the database address at the setup database screen?

Thank you.

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Published in Bamboo

Bamboo 101 Video

G’day Community! As we gear up to introduce Bamboo Data Center to the world, we wanted to make sure that we shared a bit more about Bamboo, the product. Our team has put together an overview video ...

219 views 4 6
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you