errors after upgrading from 6.5 to 6.15

Question

had performed an upgrade from 6.5 to 6.15 yesterday.

1) how do i go about changing the database collation? do i need to export the db and recreate it? if so, please let me know how to

2) also, where is the config file that defines the db connection values. like server IP, userid, password

3) do not know where to update the MaxTotal as i can't find it in the server.xml

thanks!

Craig Castle-Mead_20fp9z · Answer

Hi Paul,

have a look at https://github.com/jenkins-infra/confluence/blob/master/confluence/site/conf/server.xml

it will show you where the maxThreads setting goes (in the connector node).

also, stick with postgres. While mysql is supported by Atlassian, development happens against postgres, so it’s tested more, and just seems to be less problematic. We’re in the process of migrating from mysql to Postgres and after years of mysql and a large environment, it’s painful.

Check out the below on fixing psql collation issues

https://confluence.atlassian.com/confkb/how-to-fix-the-collation-of-a-postgres-confluence-database-966676071.html

CCM

Paul Tan · Answer

i know where the server.xml is, i just can't find the line inside it that allows me to update the MaxTotal values.

Paul Tan · Answer

Hi, am using postgresql . is it possible to migrate to mysql?