Community
Q&A
Confluence
Questions
Confluence change database port

Confluence change database port

I need a secondary mysql database with an older version to run with the standard port (3306).

This means that I need to move the main mysql server from port 3306 to a different one (3307).

Confluence runs on this server. Thus I need to tell confluence to connect to the mysql server on 3307.

Nothing changes, databases don't even move. Only the port of the server changes.

How can i configure this in confluence?

Beste regards,

Sven

3 answers

1 accepted

Comments for this post are closed

Community moderators have prevented the ability to post new answers.

1 vote

Answer accepted

Hi Sven,

To change the Confluence database listening ports, you can simply edit the Confluence.cfg.xml file located in confluence_home directory and add the port right after the database connection URL.

This should do the trick.

Cheers,

Rodrigo

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Perfect! Worked like a charm! For furture reference, this has to be changed: <property name="hibernate.connection.url">jdbc:mysql://localhost/confluence?sessionVariables=storage_engine%3DInnoDB</property> Simply put ":yourPortNumber" behind the "localhost": <property name="hibernate.connection.url">jdbc:mysql://localhost:<yourPortNumber>/confluence?sessionVariables=storage_engine%3DInnoDB</property> Thank you very much sir!

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Like

You are welcome Sven :) Glad I could help

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Like

Reply

0 votes

Yes, I was assuming that the poster knew how to work out a connection string. Anyway, Rodrigo beat me to the answer (and you usually find the string in the .cfg file will contain :3306 in it, which you just change to 3307)

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Reply

0 votes

Forgot to mention that I have already found this article: https://answers.atlassian.com/questions/102583 But @Nic Brough [Adaptavist] did not mention the details of "Work[ing] out the new connection settings".

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Reply

Was this helpful?

Thanks!

TAGS