Cannot configuring Bamboo for external DB, Microsoft SQL

September 25, 2017

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)