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.
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.