Change the Confluence color scheme via SQL or some other automation

Jason Friedman
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
January 16, 2014

From time-to-time we copy our PRD data down to a non-PRD instance. We then manually update the non-PRD color scheme so that we don't mistakenly work in the wrong environment.
We would like to be able to make this change via SQL or some other automation. We recognize this might be risky in a PRD environment, but we would be applying this change to non-PRD only.

3 answers

1 vote
Jozef Kotlár
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
February 13, 2014

Look to bandana table:

select * from bandana where bandanakey = 'atlassian.confluence.colour.scheme' and bandanacontext = '_GLOBAL';

0 votes
Jason Friedman
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
February 13, 2014

Yep, thanks, that is what we ended up doing.

echo "update bandana set bandanavalue = '<colourScheme> <colours> <entry> <string>property.style.topbarmenuselectedbgcolour</string> <string>#999999</string> </entry> <entry> <string>property.style.menuitemselectedbgcolour</string> <string>$COLOR</string> </entry> <entry> <string>property.style.spacenamecolour</string> <string>#999999</string> </entry> <entry> <string>property.style.navtextcolour</string> <string>#ffffff</string> </entry> <entry> <string>property.style.linkcolour</string> <string>#330066</string> </entry> <entry> <string>property.style.navselectedtextcolour</string> <string>#ffffff</string> </entry> <entry> <string>property.style.breadcrumbstextcolour</string> <string>#111111</string> </entry> <entry> <string>property.style.menuitemtextcolour</string> <string>#535353</string> </entry> <entry> <string>property.style.headingtextcolour</string> <string>#000000</string> </entry> <entry> <string>property.style.topbarcolour</string> <string>$COLOR</string> </entry> <entry> <string>property.style.navselectedbgcolour</string> <string>$COLOR</string> </entry> <entry> <string>property.style.navbgcolour</string> <string>$COLOR</string> </entry> <entry> <string>property.style.bordercolour</string> <string>#999999</string> </entry> <entry> <string>property.style.menuselectedbgcolour</string> <string>#999999</string> </entry> <entry> <string>property.style.topbarmenuitemtextcolour</string> <string>#999999</string> </entry> <entry> <string>property.style.menuitemselectedtextcolour</string> <string>#ffffff</string> </entry> <entry> <string>property.style.topbarmenuselectedtextcolour</string> <string>#111111</string> </entry> </colours> </colourScheme>'where bandanacontext = '_GLOBAL' and bandanakey = 'atlassian.confluence.colour.scheme';" | psql confluence

0 votes
Jason Friedman
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
January 16, 2014

Suggest an answer

Log in or Sign up to answer