Can't select MySQL on Setup Confluence

[志雄 朱]

1、install with  installer which download from url: https://product-downloads.atlassian.com/software/confluence/downloads/atlassian-confluence-6.12.0-x64.bin

1.1、install-directory is   /usr/local/atlassian/confluence

1.2、home-directoy is /data/atlassian/confluence

2、install mysql5.6.41

3、download mysql-connector-java-5.1.47-bin.jar and copy it to /usr/local/atlassian/confluence/confluence/WEB-INF/lib/

4、start confluence with command: /usr/local/atlassian/confluence/bin/start-confluence.sh

5、visit the home page of confluence:  http://ipaddress:8090

6、on Set up your database, I choose MySQL and fill all the information it needs, then I click the NEXT button, about 60s later, it lost the connection.  which url is "http://ipaddress:8090/setup/setupdbtype.action"

7、with command  "ps agux | grep confluence"  I found the process has been shutdown.

8、manual start confluence with command again: /usr/local/atlassian/confluence/bin/start-confluence.sh

9、refresh the page，and it shows me the information

"The following error(s) occurred:

• Configuring database failed
• java.sql.SQLException: No suitable driver found for jdbc:postgresql://null:null/null"

I am totally confused.

I need some help, thanks.

[AhmadDanial]

Hi there.

I am curious with the fact that the error is showing an issue with the postgreSQL driver instead of mySQL instead (jdbc:mysql:).

• Can you double confirm if you used JDBC or JNDI datasource?
• Did you test the database connection before you clicked next as mentioned in the documentation? If yes, was the connection test successful?
• Did you observe any errors in the atlassian-confluence.log besides the java.sql.SQLException: No suitable driver found on the page after restarting Confluence?
• Can you confirm the current database connection stored in Confluence by going through the steps in the How to find Confluence's database connection parameters page and provide the /data/atlassian/confluence/confluence.cfg.xml file.

<property name="hibernate.connection.driver_class">com.mysql.jdbc.Driver</property>
    <property name="hibernate.connection.password">password</property>
    <property name="hibernate.connection.url">jdbc:mysql://<servername>/<databasename>?autoReconnect=true</property>
    <property name="hibernate.connection.username">confluence</property>
    <property name="hibernate.database.lower_non_ascii_supported">true</property>
    <property name="hibernate.dialect">com.atlassian.hibernate.dialect.MySQLDialect</property>

Let me know how it goes for you. Tbanks.

[志雄 朱]

1、YES:JDBC
2、YES: The connection was successful.
3、found two.
3.1、detectProduct couldn't detect product, will use ProductFilter
3.2、lambda get$11$ failed to read entry from cache 'com.atlassian.bandana.BandanaPersister':Failed due to UNCLASSIFIED_FAILURE
4、YES: Same as I input in the setup page.

[AhmadDanial]

Hello there.

This looks like an issue with connecting to the database. It is likely that either the user doesn't have permission, we're not pointing to the right database, or there is a network issue.

In case that the connection is similar as to the one you included in the confluence.cfg.xml (meaning that the database is correct), can you please confirm how if the user that started Confluence has the right permission to Confluence Installation and Home Directory?

Additionally, can Confluence reach out to the database host and vice versa?

As a suggestion, can you try the following to reinstall Confluence and check if the issue still persists?

1. Stop Confluence
2. Make sure you have copy correct JDBC driver for MySQL in <confluence installation>/confluence/WEB-INF/lib (I believe this is done already)
3. Delete all the files in your Confluence home directory so we can restart the setup wizard again.
4. Run the following command to grant all the permission to the user. Please provide us a screenshot of the file permission by running the command (ls -al)

   chown -R confluence.confluence <confluence-install-folder>
   chown -R confluence.confluence <confluence-home-folder>
   chmod -R u=rwX,go-rwx <confluence-install-folder>
   chmod -R u=rwX,go-rwx <confluence-home-folder>

   The user confluence is only a suggestion. You can change it for another username. For details, you may refer to the resolution 1 in this documentation.

5. Create a new database according to this documentation.
6. Start Confluence and set up confluence again.

If we are still unable to proceed further, I will proceed to log a support ticket to the Confluence team for assistance.