How to change the database url of confluence?

Hi,expects,I have encountered some mistakes when i tired to change the mysql url of confluence.The mistakes are presented in the screenshot.And i have tired some of the solutions given here.Like clear the caches under 

<confluence-home>/bundled-plugins 

 <confluence-home>/plugins-cache

 <confluence-home>/plugins-osgi-cache

 <confluence-home>/plugins-temp

 <confluence-home>/bundled-plugins_language

and checked up  the substitute url. But all of these didn't work.I need your help. Please answer me soon!!!256463064261297210.jpg

1 answer

Database details could be in <CONFLUENCE_HOME>/confluence.cfg.xml or <CONFLUENCE_INSTALLATION>/conf/server.xml 

Depending upon how your database is configured. You can refer below doc for more info on how to configure database in confluence

https://confluence.atlassian.com/doc/configuring-a-mysql-datasource-in-apache-tomcat-1867.html

 

 

 

Thank for your quick reaction,Taha Khanzada. Maybe i didn't make myself so clear .My database configuration is in the <CONFLUENCE_HOME>/confluence.cfg.xml ,and i have changed the url of mysql,and then it reported errors as above.And i have use the "ping" to test my url,it works well.Is there any more possible solutions to my problems ?

Above error is generic error and there are many possibilities - Check database username and password are correct, try login to database through some database client and check if it is working. - Also make sure your connection string is correct. Sometime if some quotes or something is missed in database connection string it may cause issue and you will get below errors. ( try to run diff between old and new file) - lastly if you have taken backup of confluence.cfg.xml file then try to restore this or revert changes and start confluence just to make sure if it is working with old configuration.

Suggest an answer

Log in or Sign up to answer
Community showcase
Posted Oct 24, 2018 in Confluence

Atlassian Research opportunity with Confluence templates

Do you use templates with Confluence? Take part in a remote 1-hr workshop. You'll receive USD $100 for your time!   We're looking for people to participate in a   remote 1-hr workshop...

1,098 views 17 14
Join discussion

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you