Accessing Bitbucket Server's H2 embedded database

お困りですか?

アトラシアン コミュニティをご利用ください。

コミュニティに質問

目的

While the H2 database is not supported for production environments, sometimes admins will need access for testing purposes.

ソリューション

  1. Bitbucket Server を停止します。
  2. Login to the server as the user that runs Bitbucket Server
  3. Run the following command which will open a console connection to the database:
    java -cp <BITBUCKET_INSTALLATION>/atlassian-bitbucket/WEB-INF/lib/h2-1.3.176.jar org.h2.tools.Shell
    1. Update the path above to reflect where Bitbucket Server is installed
  4. When prompted for the URL enter:
    jdbc:h2:file://<BITBUCKET_HOME>/shared/data/db;DB_CLOSE_ON_EXIT=TRUE
    1. Update the path above to reflect the location of the Bitbucket Home directory
  5. Press enter when asked which driver to use
  6. Enter sa for the user
  7. Press enter twice when prompted for the password (no password is required)

If successful, you'll be prompted with sql> and can enter any SQL commands required.


最終更新日 2016 年 7 月 26 日

この内容はお役に立ちましたか?

はい
いいえ
この記事についてのフィードバックを送信する
Powered by Confluence and Scroll Viewport.