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

Still need help?

The Atlassian Community is here for you.

Ask the community

Always backup your data before performing any modifications to 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>

Last modified on Oct 7, 2015

Was this helpful?

Yes
No
Provide feedback about this article
Powered by Confluence and Scroll Viewport.