
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:?]
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