WannaCry is just the start. Read how Liquid Web is protecting itself and its customers against new threats.
Course Of The Month
3 days, 10 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
unable to connect to mysql in atlassian confluance
Posted on 2009-04-09
i am trying to install atlassian confluance on a centos5 virtual mach.; i am facing probelm in connecting to the mysql server using jdbc.mysql connection.
drive class
i get an error
" The following error(s) occurred:
* Configuring the database failed. Couldn't create the database schema.
* java.sql.SQLException: Server connection failure during transaction. Attemtped reconnect 3 times. Giving up."
let me give you teh settings i have done till now
installed jdk in /urs/jdk1.5.0_18
in /etc/profile i have typed the following settings
export JAVA_HOME=/urs/jdk1.5.0_18
export JRE_HOME=/usr/jdk1.5.0_18/
export PATH=$PATH:$JAVA_HOME/bin:
and rebooted the system
after that i placed the confluance folder in the /var/confluence-2.10.1-std
and set the CATALINA_HOME & CATALINA_BASE with command export to CATALINA_HOME=/var/conflue
i tested all the variables on shell if the return valid paths and the did.
the i started the confluence from /var/confluence-2.10.1-std
chmod +x *.sh
./catalina.sh run
and when i type http://101.168.1.39:8080 or http://localhost:8080 i see the conflunce setup page
after entring the key and selecting the custom install i land on the database page where i select "Direct JDBC Connection" and select mysql fomr the dropdown list.
on the next page i get the configuration for the jdbc as following
Driver Class Name: com.mysql.jdbc.Driver
Database URL: jdbc:mysql://localhost/con
User Name: confluance
Password: 12345
and i click next
first time i got error that i dont have jdbc.mysql driver installed on my server so i downloded the
mysql-connector-java-3.0.6
as i found this step from the tutorial.
after that i restarted my server and again started the mysql database configuration process in confluence and this time i provided the same details again and this time i got a new error:
"" The following error(s) occurred:
* Configuring the database failed. Couldn't create the database schema.
* java.sql.SQLException: Server connection failure during transaction. Attemtped reconnect 3 times. Giving up.""
i have not done any thing rather then the steps i mentioned.how can get through the error and install the conflence on linux machine with mysql as database. is there some thing i am missing in this process. i just typed what i typed while confg. my mach nothing extra or less was typed.
drive class
i get an error
" The following error(s) occurred:
* Configuring the database failed. Couldn't create the database schema.
* java.sql.SQLException: Server connection failure during transaction. Attemtped reconnect 3 times. Giving up."
let me give you teh settings i have done till now
installed jdk in /urs/jdk1.5.0_18
in /etc/profile i have typed the following settings
export JAVA_HOME=/urs/jdk1.5.0_18
export JRE_HOME=/usr/jdk1.5.0_18/
export PATH=$PATH:$JAVA_HOME/bin:
and rebooted the system
after that i placed the confluance folder in the /var/confluence-2.10.1-std
and set the CATALINA_HOME & CATALINA_BASE with command export to CATALINA_HOME=/var/conflue
i tested all the variables on shell if the return valid paths and the did.
the i started the confluence from /var/confluence-2.10.1-std
chmod +x *.sh
./catalina.sh run
and when i type http://101.168.1.39:8080 or http://localhost:8080 i see the conflunce setup page
after entring the key and selecting the custom install i land on the database page where i select "Direct JDBC Connection" and select mysql fomr the dropdown list.
on the next page i get the configuration for the jdbc as following
Driver Class Name: com.mysql.jdbc.Driver
Database URL: jdbc:mysql://localhost/con
User Name: confluance
Password: 12345
and i click next
first time i got error that i dont have jdbc.mysql driver installed on my server so i downloded the
mysql-connector-java-3.0.6
as i found this step from the tutorial.
after that i restarted my server and again started the mysql database configuration process in confluence and this time i provided the same details again and this time i got a new error:
"" The following error(s) occurred:
* Configuring the database failed. Couldn't create the database schema.
* java.sql.SQLException: Server connection failure during transaction. Attemtped reconnect 3 times. Giving up.""
i have not done any thing rather then the steps i mentioned.how can get through the error and install the conflence on linux machine with mysql as database. is there some thing i am missing in this process. i just typed what i typed while confg. my mach nothing extra or less was typed.
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
2
3 Comments
Have you created the user & shema "confluence"?
And are you correct ... you are sometimes writing "confluance" (with an a) and sometimes "confluence", so don't get them mixed up.
And are you correct ... you are sometimes writing "confluance" (with an a) and sometimes "confluence", so don't get them mixed up.
What i meant is ... have you created the user and the schema in your Database?
The Confluence setup doesn't create the schema and the user. In order to connect (and then create all the tables in the schema) the JDBC Driver needs a valid schema and a user with permission to access the schema.
The Confluence setup doesn't create the schema and the user. In order to connect (and then create all the tables in the schema) the JDBC Driver needs a valid schema and a user with permission to access the schema.
previously i created the user name confluence but didnt create database named confluence. now i have created the database named confluence and given the grant all privileges on *.* to confluence@localhost with grant option;
mysql -u confluence confluence -p
and i am able to login into mysql as user confluence and connect to database confluence. but still i am reciving the same error.
mysql -u confluence confluence -p
and i am able to login into mysql as user confluence and connect to database confluence. but still i am reciving the same error.
Featured Post
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
Password hashing is better than message digests or encryption, and you should be using it instead of message digests or encryption. Find out why and how in this article, which supplements the original article on PHP Client Registration, Login, Logo…
In this series, we will discuss common questions received as a database Solutions Engineer at Percona. In this role, we speak with a wide array of MySQL and MongoDB users responsible for both extremely large and complex environments to smaller singl…
- Databases
- AWS
- MySQL Server
- MongoDB
- NoSQL Databases
- Percona
Viewers will learn about arithmetic and Boolean expressions in Java and the logical operators used to create Boolean expressions. We will cover the symbols used for arithmetic expressions and define each logical operator and how to use them in Boole…
Viewers will learn how to properly install Eclipse with the necessary JDK, and will take a look at an introductory Java program.
Download Eclipse installation zip file:
Extract files from zip file:
Download and install JDK 8:
Open Eclipse and …
Suggested Courses
Course of the Month3 days, 10 hours left to enroll
691 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.