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
Community showcase
Posted Monday in Confluence

Organizing your space just got easier - Page Tree Drag & Drop is here

Hi Community! I’m Elaine, Confluence Product Manager. You may have read my earlier post about page tree in space navigation sidebar. I'm excited to share another improvement that helps you organize ...

72 views 3 3
Join discussion

Atlassian User Groups

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

Find a group

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

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you