Confluence - Configure Database

[Piotr Kryska]

Hi,

I have a problem. I try configure Confluence, but I don't know what do in step "Configure Database".

I check options "java:comp/env/jdbc/DataSourceName" and "jdbc/DataSourceName". Still I can see this same error:


Setup Datasource Database Failed

The following error(s) occurred:

 

• Could not lookup datasource successfully: com.atlassian.config.bootstrap.BootstrapException: Couldn't locate Datasource (java:comp/env/jdbc/) in the initial context. An object was bound to this name but whatever we found, it wasn't a Datasource:

Anyone can help me?

[Adrien Ragot 2]

• Did you restart after changing the server.xml file?
• Can you show us the section of your server.xml file which describes the datasource, after hiding the passwords?

[Piotr Kryska]

                      Yes, I did  restart server. I use postgresql. database.

                       server.xml :

                       <Resource name="jdbc/confluence" auth="Container" type="javax.sql.DataSource"
                        username="username"
                        password="password"
                        driverClassName="org.postgresql.Driver"
                        url="jdbc:postgresql://localhost:5432/database"
                        maxActive="20"
                        maxIdle="10"
                        validationQuery="select 1" />

                       I have file /atlassian/confluence/lib/postgresql-9.2-1004.jdbc4.jar on serer.

                       I add some text on end file /atlassian/confluence/confluence/WEB-INF/web.xml:

        <description>Connection Pool</description>

        <res-ref-name>jdbc/confluence</res-ref-name>

        <res-type>javax.sql.DataSource</res-type>

        <res-auth>Container</res-auth>

    </resource-ref>

[Nic Brough -Adaptavist-]

What database are you trying to connect to, and what connection settings are you giving to Confluence?