Skip to main content

Hey All. I am running into an issue getting the new version of TabJolt working properly. I have been using the 2020 version successfully, but wanted to update due to the log4j issues recently. However when I try to run a load test with v2022.1, it is throwing a postgres authentication error.

 

I am baffled because I am using the exact same credentials that work with v2020 of tabjolt and they work fine for connecting via pgadmin as well

 

Here is what I am seeing in the output in the command prompt:

 

Attempting to connect to PostgreSQL using jdbc:postgresql://localhost:48123/PerfResults?user=postgres&password=REDACTED

10:51:42.430 [main] ERROR com.tableausoftware.test.tools.ResultProcessor.PostgresDBHelper - unable to create connection with DB

org.postgresql.util.PSQLException: FATAL: password authentication failed for user "postgres"

    at org.postgresql.core.v3.ConnectionFactoryImpl.doAuthentication(ConnectionFactoryImpl.java:613) ~[postgresql-42.2.22.jar:42.2.22]

    at org.postgresql.core.v3.ConnectionFactoryImpl.tryConnect(ConnectionFactoryImpl.java:161) ~[postgresql-42.2.22.jar:42.2.22]

    at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:213) ~[postgresql-42.2.22.jar:42.2.22]

    at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:51) ~[postgresql-42.2.22.jar:42.2.22]

    at org.postgresql.jdbc.PgConnection.<init>(PgConnection.java:223) ~[postgresql-42.2.22.jar:42.2.22]

    at org.postgresql.Driver.makeConnection(Driver.java:465) ~[postgresql-42.2.22.jar:42.2.22]

    at org.postgresql.Driver.connect(Driver.java:264) ~[postgresql-42.2.22.jar:42.2.22]

    at java.sql.DriverManager.getConnection(DriverManager.java:677) ~[java.sql:?]

    at java.sql.DriverManager.getConnection(DriverManager.java:251) ~[java.sql:?]

    at com.tableausoftware.test.tools.ResultProcessor.PostgresDBHelper.getInstance(PostgresDBHelper.java:75) [PerfRunHarness-latest.jar:?]

    at com.tableausoftware.test.tools.ResultProcessor.DBHelperFactory.getDBHelperInstance(DBHelperFactory.java:29) [PerfRunHarness-latest.jar:?]

    at com.tableausoftware.test.tools.ResultProcessor.ResultProcessor.<init>(ResultProcessor.java:138) [PerfRunHarness-latest.jar:?]

    at com.tableausoftware.test.tools.perfRunHarness.Main.startPerfResultsSaver(Main.java:319) [PerfRunHarness-latest.jar:?]

    at com.tableausoftware.test.tools.perfRunHarness.Main.runOneTest(Main.java:269) [PerfRunHarness-latest.jar:?]

    at com.tableausoftware.test.tools.perfRunHarness.Main.main(Main.java:158) [PerfRunHarness-latest.jar:?]

10:51:42.450 [main] ERROR com.tableausoftware.test.tools.ResultProcessor.ResultProcessor - Unable to get DB Helper instance

org.postgresql.util.PSQLException: FATAL: password authentication failed for user "postgres"

    at org.postgresql.core.v3.ConnectionFactoryImpl.doAuthentication(ConnectionFactoryImpl.java:613) ~[postgresql-42.2.22.jar:42.2.22]

    at org.postgresql.core.v3.ConnectionFactoryImpl.tryConnect(ConnectionFactoryImpl.java:161) ~[postgresql-42.2.22.jar:42.2.22]

    at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:213) ~[postgresql-42.2.22.jar:42.2.22]

    at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:51) ~[postgresql-42.2.22.jar:42.2.22]

    at org.postgresql.jdbc.PgConnection.<init>(PgConnection.java:223) ~[postgresql-42.2.22.jar:42.2.22]

    at org.postgresql.Driver.makeConnection(Driver.java:465) ~[postgresql-42.2.22.jar:42.2.22]

    at org.postgresql.Driver.connect(Driver.java:264) ~[postgresql-42.2.22.jar:42.2.22]

    at java.sql.DriverManager.getConnection(DriverManager.java:677) ~[java.sql:?]

    at java.sql.DriverManager.getConnection(DriverManager.java:251) ~[java.sql:?]

    at com.tableausoftware.test.tools.ResultProcessor.PostgresDBHelper.getInstance(PostgresDBHelper.java:75) ~[PerfRunHarness-latest.jar:?]

    at com.tableausoftware.test.tools.ResultProcessor.DBHelperFactory.getDBHelperInstance(DBHelperFactory.java:29) ~[PerfRunHarness-latest.jar:?]

    at com.tableausoftware.test.tools.ResultProcessor.ResultProcessor.<init>(ResultProcessor.java:138) [PerfRunHarness-latest.jar:?]

    at com.tableausoftware.test.tools.perfRunHarness.Main.startPerfResultsSaver(Main.java:319) [PerfRunHarness-latest.jar:?]

    at com.tableausoftware.test.tools.perfRunHarness.Main.runOneTest(Main.java:269) [PerfRunHarness-latest.jar:?]

    at com.tableausoftware.test.tools.perfRunHarness.Main.main(Main.java:158) [PerfRunHarness-latest.jar:?]

10:51:42.453 [main] ERROR com.tableausoftware.test.tools.perfRunHarness.Main - Failed to process perf counters and run result.

org.postgresql.util.PSQLException: FATAL: password authentication failed for user "postgres"

    at org.postgresql.core.v3.ConnectionFactoryImpl.doAuthentication(ConnectionFactoryImpl.java:613) ~[postgresql-42.2.22.jar:42.2.22]

    at org.postgresql.core.v3.ConnectionFactoryImpl.tryConnect(ConnectionFactoryImpl.java:161) ~[postgresql-42.2.22.jar:42.2.22]

    at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:213) ~[postgresql-42.2.22.jar:42.2.22]

    at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:51) ~[postgresql-42.2.22.jar:42.2.22]

    at org.postgresql.jdbc.PgConnection.<init>(PgConnection.java:223) ~[postgresql-42.2.22.jar:42.2.22]

    at org.postgresql.Driver.makeConnection(Driver.java:465) ~[postgresql-42.2.22.jar:42.2.22]

    at org.postgresql.Driver.connect(Driver.java:264) ~[postgresql-42.2.22.jar:42.2.22]

    at java.sql.DriverManager.getConnection(DriverManager.java:677) ~[java.sql:?]

    at java.sql.DriverManager.getConnection(DriverManager.java:251) ~[java.sql:?]

    at com.tableausoftware.test.tools.ResultProcessor.PostgresDBHelper.getInstance(PostgresDBHelper.java:75) ~[PerfRunHarness-latest.jar:?]

    at com.tableausoftware.test.tools.ResultProcessor.DBHelperFactory.getDBHelperInstance(DBHelperFactory.java:29) ~[PerfRunHarness-latest.jar:?]

    at com.tableausoftware.test.tools.ResultProcessor.ResultProcessor.<init>(ResultProcessor.java:138) ~[PerfRunHarness-latest.jar:?]

    at com.tableausoftware.test.tools.perfRunHarness.Main.startPerfResultsSaver(Main.java:319) [PerfRunHarness-latest.jar:?]

    at com.tableausoftware.test.tools.perfRunHarness.Main.runOneTest(Main.java:269) [PerfRunHarness-latest.jar:?]

    at com.tableausoftware.test.tools.perfRunHarness.Main.main(Main.java:158) [PerfRunHarness-latest.jar:?]

2 Antworten
  1. 2. Mai 2022, 14:43

    Hi ,

    I had same postgres authentication error using Tabjolt v2022.1 .

    Changing "perftestconfig.yaml" line 5 to below solved this issue.

    before change:

    DBPassword: AES: . . .

    after change:

    DBPassword: tabjoltresults

0/9000