How to Find Where the General Configuration is Stored in the Database

お困りですか?

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

コミュニティに質問

データベースを変更する前には必ずデータをバックアップするようにします。

Under some circumstances, you may have the need to alter a field in the General Configuration, and cannot do so via the Admin interface. 

(info) The General Configuration is stored in the database in the bandana table.

Run the following query to see the settings:

SELECT * FROM bandana WHERE bandanakey = 'atlassian.confluence.settings';

A sample settings looks like:

BANDANAID

BANDANACONTEXT

BANDANAKEY

BANDANAVALUE

1

_GLOBAL

atlassian.confluence.settings

<settings>
<allowCamelCase>true</allowCamelCase>
<allowTrackbacks>false</allowTrackbacks>
<allowThreadedComments>true</allowThreadedComments>
<viewSpaceGoesToSpaceSummary>false</viewSpaceGoesToSpaceSummary>
<externalUserManagement>false</externalUserManagement>
<denyPublicSignup>true</denyPublicSignup>
<emailAdminMessageOff>false</emailAdminMessageOff>
<almostSupportPeriodEndMessageOff>false</almostSupportPeriodEndMessageOff>
<supportPeriodEndMessageOff>false</supportPeriodEndMessageOff>
<baseUrlAdminMessageOff>false</baseUrlAdminMessageOff>
<allowRemoteApi>true</allowRemoteApi>
<allowRemoteApiAnonymous>false</allowRemoteApiAnonymous>
<antiXssMode>false</antiXssMode>
<gzippingResponse>false</gzippingResponse>
<disableLogo>false</disableLogo>
<sharedMode>false</sharedMode>
<enableDidYouMean>false</enableDidYouMean>
<enableQuickNav>true</enableQuickNav>
<enableSpaceStyles>false</enableSpaceStyles>
<enableOpenSearch>true</enableOpenSearch>
<referrerSettings>
<collectReferrerData>true</collectReferrerData>
<excludedReferrers/>
<hideExternalReferrers>false</hideExternalReferrers>
</referrerSettings>
<captchaSettings>
<enableCaptcha>false</enableCaptcha>
<captchaGroups class="list"/>
<exclude>registered</exclude>
</captchaSettings>
<customHtmlSettings>
<beforeHeadEnd><style type="text/css">
.wiki-content .task-list .progress { background: red; }
.wiki-content .task-list .progress div { background: green; }
</style></beforeHeadEnd>
<afterBodyStart></afterBodyStart>
<beforeBodyEnd></beforeBodyEnd>
</customHtmlSettings>
<colourSchemesSettings>
<colourSchemeType>custom</colourSchemeType>
</colourSchemesSettings>
<attachmentMaxSize>17000000</attachmentMaxSize>
<draftSaveInterval>30000</draftSaveInterval>
<maxAttachmentsInUI>5</maxAttachmentsInUI>
<siteTitle>NaviWiki</siteTitle>
<siteWelcomeMessage></siteWelcomeMessage>
<emailAddressVisibility>email.address.public</emailAddressVisibility>
<defaultEncoding>UTF-8</defaultEncoding>
<maxThumbHeight>150</maxThumbHeight>
<maxThumbWidth>150</maxThumbWidth>
<backupAttachmentsDaily>true</backupAttachmentsDaily>
<nofollowExternalLinks>true</nofollowExternalLinks>
<indexingLanguage>english</indexingLanguage>
<globalDefaultLocale>en_GB</globalDefaultLocale>
<dailyBackupFilePrefix>daily-backup-</dailyBackupFilePrefix>
<dailyBackupDateFormatPattern>yyyy_MM_dd</dailyBackupDateFormatPattern>
<supportRequestEmail>confluence-autosupportrequests@atlassian.com</supportRequestEmail>
<enableWysiwyg>true</enableWysiwyg>
<useWysiwygByDefault>false</useWysiwygByDefault>
<numberOfBreadcrumbAncestors>1</numberOfBreadcrumbAncestors>
<defaultSpaceHomepageTitle>Home</defaultSpaceHomepageTitle>
<defaultSpaceHomepageContent>This is the home of the {0} space.</defaultPersonalSpaceHomepageContent>
<baseUrl>wiki</baseUrl>
<attachmentDataStore>database.based.attachments.storage</attachmentDataStore>
<webdavServerUrl></webdavServerUrl>
<webdavUsername></webdavUsername>
<webdavPassword></webdavPassword>
<displayLinkIcons>false</displayLinkIcons>
<maxSimultaneousQuickNavRequests>40</maxSimultaneousQuickNavRequests>
<confluenceHttpParameters>
<connectionTimeout>10000</connectionTimeout>
<socketTimeout>10000</socketTimeout>
<enabled>true</enabled>
</confluenceHttpParameters>
</settings>

最終更新日: 2015 年 10 月 7 日

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

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