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.
Look to bandana table:
select * from bandana where bandanakey = 'atlassian.confluence.colour.scheme' and bandanacontext = '_GLOBAL';
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.