Error getting to RY configuration after installation on fresh Confluence

Description

Hello,

After installing RY addon to Confluence 6.0.4 I get this error when getting to the configuration section:

Environment

Confluence 6.0.4 + Postgres

Observations

None

Activity

Show:
Adrien Ragot (Old account)
July 26, 2017, 9:55 AM

This seems resolved in Confluence 6.3 as they upgraded the Postgresql driver. On Confluence 6.2.3, this this works for me:

I'll consider the issue solved, since there is both a solution for 6.2.3 and 6.3. Feel free to comment if you think this is not resolved.

Adrien Ragot (Old account)
June 28, 2017, 3:44 PM

Hi Peter,

You're right, Confluence 6.1.1 already uses the driver 1212. I've tried a few different configurations to no avail, have you solved your issue in the meantime? I have to admit that I'm out of ideas for the resolution of this one.

Regards,
Adrien

Peter Dulimov
May 8, 2017, 12:24 AM

Hi Adrien,

You asked me to upgrade the postgreSQL driver, but I haven't done so because Confluence 6.1.1 already comes with the driver version 1212 (the version that you suggested that I upgrade to, although I suspect the driver packaged with Confluence 6.1.1 is the JDBC 4.2 version.)

Do you still want me to try to upgrade to another version of the driver? If so, which one? I think that you mean the JDBC 4.1 version of 1212, but I'm not sure so I want to certain before I go and do something so radical.

Regards,

Peter.

Peter Dulimov
May 3, 2017, 1:19 PM

Hi Adrien,

Thank you for investigating this. I just looked, and it appears that my installation of Confluence already has postgresql-9.4.1212.jar — it was in the path confluence/WEB-INF/lib.

The atlassian page that you linked to has a download of the older driver ... 1202 rather than 1212. Did you want me to downgrade to that version? It wasn't clear, but I assumed from the file name that this was the JDBC4.1 version for Java 7.

I note that the Postgres page suggests that with Java 8 a person should use their version 4.2. But the atlassian page specifically states that version 4.1 works. The version bundled with Confluence 6.1.1 appears to be the JDBC 4.2 version (contrary to the advice on the atlassian website.)

There is another version of the driver on the Postgres site - it uses the 42.0.0 naming convention.

It's all a bit confusing for me so can you please advise which version of the driver you think that I should use? (JDBC 4.1 or 4.2, version 1202, 1212 or 42.0.0?) Could you please point me at instructions for making the change, if there is more to it than just replacing the jar file in the confluence/WEB-INF/lib directory?

Regards,

Peter.

Adrien Ragot (Old account)
May 3, 2017, 8:28 AM

Hi Peter,

Very interesting! I was able to reproduce this issue, once, yesterday. According to AO-697, other people meet this issue with other plugins too.

I was able to fix the problem on my machine by upgrading the PostgreSQL driver. Atlassian provides the link on their "drivers" page: Download the JDBC 4.1, version 1212, and replace the file in your Confluence installation directory.

I know this is cumbersome, but we otherwise need to wait for Atlassian to upgrade their PostgreSQL driver.

Are you able to implement this temporary fix?

Thank you,
Adrien

Answered / Support Question

Assignee

Unassigned

Reporter

Krystian Szczęsny

Labels

None

Participants

None

Components

Fix versions

Affects versions

Priority