MariaDB setup for Confluence "Access denied for user"

[Maria Razumova]

Hi, I have a problem. I try configure Confluence, but I don't know what do in step "Configure Database". I use Instruction https://confluence.atlassian.com/doc/configuring-a-mysql-datasource-in-apache-tomcat-1867.html and https://confluence.atlassian.com/doc/database-setup-for-mysql-128747.html

Description of installation:

-CentOS Linux release 7.0.1406

-confluence 5.9.8

-Server version: 5.5.47-MariaDB MariaDB Server

-mysql-connector-java-5.1.38-bin.jar

1 way:

 ---Datasource setup steps and error:

1. Select "MySQL External Database"

2. Select "Connect via a Datasource"

3. Enter datasource name (java:comp/env/jdbc/confluence or jdbc/confluence) and click "Next"

4. Receive the following error: "Could not lookup datasource successfully: com.atlassian.config.bootstrap.BootstrapException: Could not locate datasource: jdbc/confluence"

1_1.png

2 way:

 1. Select "MySQL External Database"

2. Select "Direct JDBC Connection"

3. Enter

Driver Class Name = com.mysql.jdbc.Driver Database URL = jdbc:mysql://localhost:3306/confluence?useUnicode=true&characterEncoding=utf8 User Name = confluence

and click "Next"

4. Receive the following error:

"The following error(s) occurred:  •configuring.db.failed •java.sql.SQLException: Access denied for user 'confluence'@'localhost' (using password: NO)"

1_2.png

BUT:

MariaDB [(none)]> show grants for 'confluence'@'localhost'; +-----------------------------------------------------------------------------------------------------------------------+ | Grants for confluence@localhost                                                                                  | +-----------------------------------------------------------------------------------------------------------------------+ | GRANT USAGE ON *.* TO 'confluence'@'localhost' IDENTIFIED BY PASSWORD '*6498EC8B7A8C0138E99B1203CED08CF40ACF04B0' | | GRANT ALL PRIVILEGES ON `confluence`.* TO 'confluence'@'localhost'                                                | +-----------------------------------------------------------------------------------------------------------------------+ 2 rows in set (0.04 sec)

Help please!

[Steven F Behnke · Accepted solution]

MariaDB isn't supported. https://jira.atlassian.com/browse/CONF-29060

[Maria Razumova]

I use PostgreSQL datasource connection for Confluence. Problem solved.