bitbucket DB's IP changed

[Joe Tsang]

Hello Team,

Recently my bitbucket DB's connection (I.P.) has been updated and I had not update the new IP until recently I tried to access bitbucket again and I got this error message (see below). Is there any way I can go back and update the new DB IP?

Error message.....:

A fatal error has occurred

The following problem occurred, which prevents Atlassian Bitbucket from starting:

• The database, as currently configured, is not accessible.
  The TCP/IP connection to the host 10.123.99.15, port 1433 has failed. Error: "Connection timed out: no further information. Verify the connection properties. Make sure that an instance of SQL Server is running on the host and accepting TCP/IP connections at the port. Make sure that TCP connections to the port are not blocked by a firewall.".

[Christian Glockner · Accepted solution]

Hi Joe,

If the address of the database server needs to be changed, you can update the jdbc.url in bitbucket.properties (see https://confluence.atlassian.com/bitbucketserver/bitbucket-server-config-properties-776640155.html) and restart Bitbucket Server.

Cheers,

Christian

Premier Support Engineer

Atlassian

[Joe Tsang]

do you have any examples on bitbucket.properties file I can follow? I don't have bitbucket.properties or maybe I can't find it.  when I look at the example from the URL you provided I found jdbc.url but unsure what is the proper format I should code it in. Thank you~

[Christian Glockner]

Hi Joe,

bitbucket.properties should be located in <BitbucketHome>/shared - unless you're using the internal database instead of an external database (which it doesn't sound like you do) you will have the file there.

Cheers,
Christian

Premier Support Engineer

Atlassian

[Joe Tsang]

Hi Christian,

Thanks. I just tried to create the bitbucket.properties file and included a link like "jdbc.url=jdbc:sqlserver://210.184.xx.xxx;instanceName=MSSQLSERVER;databaseName=bitbucket;"

and I got this message:

Atlassian Bitbucket - Fatal Error

A fatal error has occurred

The following problem occurred, which prevents Atlassian Bitbucket from starting:

• The database, as currently configured, is not accessible.

[Nic Brough -Adaptavist-]

Did you put in the credentials and driver type as well?

[Joe Tsang]

Nic,

It resolved my issue by adding the credentials and drive type. Thank you both Christian and Nic.

Just to conclude what I've done to make it work:

I did some further research online and found this examples:

https://confluence.atlassian.com/bitbucketserverkb/connecting-to-named-instances-in-sql-server-from-bitbucket-server-779171681.html (This is useful as well)

https://confluence.atlassian.com/bitbucketserver/bitbucket-server-config-properties-776640155.html?_ga=2.99877975.894723510.1521771847-964212039.1448591858 (I followed this link provided by Christian)

1) I created a file (bitbucket.properties (without extension) ) under the home path of bitbucket: C:\Atlassian\ApplicationData\Bitbucket\shared

2) Then added the following 4 lines

jdbc.driver=com.microsoft.sqlserver.jdbc.SQLServerDriver
jdbc.url=jdbc:sqlserver://xxx.xxx.xxx.xx;instanceName=MSSQLSERVER;databaseName=bitbucket;
jdbc.user=bitbucketuser
jdbc.password=bitbucketuser

3) stopped bitbucket server

4) started bitbucket server

Hope this help whoever I can...