Solved

unable to connect to mysql in atlassian confluance

Posted on 2009-04-09
3
1,444 Views
Last Modified: 2013-11-23
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/jre
export PATH=$PATH:$JAVA_HOME/bin:$JRE_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/confluence-2.10.1-std CATALINA_BASE=/var/confluence-2.10.1-std on shell prompt.

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/bin/ by typing following command on shell
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/confluence?autoReconnect=true
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-stable-bin.jar form internet and placed in /usr/jdk1.5.0_18/jre/lib/ext/
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.
0
Comment
Question by:serveradmin
  • 2
3 Comments
 
LVL 20

Expert Comment

by:ChristoferDutz
ID: 24106849
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.
0
 
LVL 20

Accepted Solution

by:
ChristoferDutz earned 500 total points
ID: 24106868
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.
0
 

Author Comment

by:serveradmin
ID: 24114137
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.
0

Featured Post

VMware Disaster Recovery and Data Protection

In this expert guide, you’ll learn about the components of a Modern Data Center. You will use cases for the value-added capabilities of Veeam®, including combining backup and replication for VMware disaster recovery and using replication for data center migration.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Guacamole cut and paste issue 3 47
Problem with SqlConnection 4 160
simple java question 3 44
fibonacci ten numbers 4 28
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
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…
Viewers learn about the scanner class in this video and are introduced to receiving user input for their programs. Additionally, objects, conditional statements, and loops are used to help reinforce the concepts. Introduce Scanner class: Importing…
Viewers will learn about the regular for loop in Java and how to use it. Definition: Break the for loop down into 3 parts: Syntax when using for loops: Example using a for loop:

920 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now