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 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:
Select "MySQL External Database"
Select "Connect via a Datasource"
Enter datasource name (java:comp/env/jdbc/confluence or jdbc/confluence) and click "Next"
Receive the following error: "Could not lookup datasource successfully: com.atlassian.config.bootstrap.BootstrapException: Could not locate datasource: jdbc/confluence"
[enter image description here][1] 2 way:
Select "MySQL External Database"
Select "Direct JDBC Connection"
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"
- Receive the following error:
"The following error(s) occurred: •configuring.db.failed •java.sql.SQLException: Access denied for user 'confluence'@'localhost' (using password: NO)"
[enter image description here][2]
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!