serveradmin
asked on
unable to connect to mysql in atlassian confluance
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/conflue nce-2.10.1 -std CATALINA_BASE=/var/conflue nce-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/con fluence?au toReconnec t=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-bi n.jar form internet and placed in /usr/jdk1.5.0_18/jre/lib/e xt/
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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.
And are you correct ... you are sometimes writing "confluance" (with an a) and sometimes "confluence", so don't get them mixed up.