[MARMOTTA-490] LDCache KiWi Backend test fails with Postgres

• Type: Bug
• Status: Closed
• Priority: Minor
• Resolution: Cannot Reproduce
• Affects Version/s: 3.2.0
• Fix Version/s: 3.3.0
• Component/s: LDCache

Environment

OSX 10.9.2 on MacBook Pro Retina, Mid 2012

java version "1.7.0_45"
Java(TM) SE Runtime Environment (build 1.7.0_45-b18)
Java HotSpot(TM) 64-Bit Server VM (build 24.45-b08, mixed mode)

PostgreSQL 9.3.2 on x86_64-apple-darwin, compiled by i686-apple-darwin11-llvm-gcc-4.2 (GCC) 4.2.1 (Based on Apple Inc. build 5658) (LLVM build 2336.9.00), 64-bit

• Assignee: Sebastian Schaffert
• Reporter: Rupert Westenthaler
• Created: 15/Apr/14 07:52
• Updated: 16/Dec/14 09:59
• Resolved: 11/Nov/14 13:12

Description

both calling

mvn clean install -Dpostgresql.url="jdbc:postgresql://localhost:5432/kiwitest?prepareThreshold=3&socketTimeout=2"

with a DB user "lmf" and the pass "lmf" as well as explicitly setting the user and the pwd by using

mvn clean install -Dpostgresql.url="jdbc:postgresql://localhost:5432/kiwitest?prepareThreshold=3&socketTimeout=2" -Dpostgresql.user=postgres -Dpostgresql.pass=

{pass}

failed with password authentication failing.

The same system properties worked however fine with for the postgresql tests of the kiwi triplestore modules (e.g. the concurrency tests). So a configuration issue of my local postgres instance seams very unlikely

Here is the trace of the call with an explicit user and pwd:

09:37:40.767 INFO o.a.m.l.b.k.t.LDCachePersistenceTest - testTablesCreateDrop[Database Test 1: PostgreSQL at jdbc:postgresql://localhost:5432/kiwitest?prepareThreshold=3&socketTimeout=2] being run...
09:37:40.767 INFO o.a.m.k.c.GuavaCacheManager - initialising Guava in-memory caching backend ...
Apr 15, 2014 9:37:40 AM org.apache.tomcat.jdbc.pool.ConnectionPool init
SEVERE: Unable to create initial connections of pool.
org.postgresql.util.PSQLException: FATAL: password authentication failed for user "postgres"
at org.postgresql.core.v3.ConnectionFactoryImpl.doAuthentication(ConnectionFactoryImpl.java:398)
[..]
at org.apache.tomcat.jdbc.pool.DataSourceProxy.getNumActive(DataSourceProxy.java:680)
at org.apache.marmotta.kiwi.persistence.KiWiPersistence.logPoolInfo(KiWiPersistence.java:201)
at org.apache.marmotta.kiwi.persistence.KiWiPersistence.initialise(KiWiPersistence.java:107)
at org.apache.marmotta.ldcache.backend.kiwi.test.LDCachePersistenceTest.initDatabase(LDCachePersistenceTest.java:135)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
[..]