Hi Folks, hope everyone is fine.
I am trying to d...
# replication-ask-air
Ricardo Morais
10/04/2023, 8:02 PMHi Folks, hope everyone is fine.
I am trying to deploy Airbyte into Kubernetes with external Postgres but receiving an issue. I have openned this issue.
Has any faced this before ?
Copy code
Caused by: org.postgresql.util.PSQLException: Something unusual has occurred to cause the driver to fail. Please report this exception.
at org.postgresql.Driver.connect(Driver.java:314) ~[postgresql-42.5.4.jar:42.5.4]
at com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:138) ~[HikariCP-5.0.1.jar:?]
at com.zaxxer.hikari.pool.PoolBase.newConnection(PoolBase.java:359) ~[HikariCP-5.0.1.jar:?]
at com.zaxxer.hikari.pool.PoolBase.newPoolEntry(PoolBase.java:201) ~[HikariCP-5.0.1.jar:?]
at com.zaxxer.hikari.pool.HikariPool.createPoolEntry(HikariPool.java:470) ~[HikariCP-5.0.1.jar:?]
at com.zaxxer.hikari.pool.HikariPool$PoolEntryCreator.call(HikariPool.java:733) ~[HikariCP-5.0.1.jar:?]
at com.zaxxer.hikari.pool.HikariPool$PoolEntryCreator.call(HikariPool.java:712) ~[HikariCP-5.0.1.jar:?]
at java.util.concurrent.FutureTask.run(FutureTask.java:317) ~[?:?]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1144) ~[?:?]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:642) ~[?:?]
at java.lang.Thread.run(Thread.java:1589) ~[?:?]
Caused by: java.lang.IllegalArgumentException: Prohibited characterRicardo Morais
10/05/2023, 6:45 PMAnyone from product team could help me ?
r
Rajesh Koilpillai
10/09/2023, 11:15 AMIs your JDBC url for postgres in the correct syntax, check to see if there are any special characters or try it with a test database to see if there is an issue with an of the connection parameters
r
Ricardo Morais
11/21/2023, 4:23 PM Copy code
externalDatabase:
host: 10.1.123.123
user: test
password: "test"
existingSecret: airbyte-secrets
existingSecretPasswordKey: DATABASE_PASSWORD
database: test
port: 5432
jdbcUrl: "jdbc:<postgresql://10.1.123.123:5432/test>"Ricardo Morais
11/21/2023, 4:24 PMThis is my setup. I am able to connect to the database using DBeaver, for example, using the same jdbc URL.
Ricardo Morais
11/21/2023, 4:24 PMThanks for your time, @Rajesh Koilpillai
r
Rajesh Koilpillai
11/22/2023, 4:45 AMnot sure, similar issue over here https://github.com/dbeaver/dbeaver/issues/20577. change connection credentials to simple characters and retry
r
Ricardo Morais
11/22/2023, 3:04 PMIf I remove the database entry on global section, remove the entries existingSecret and existingSecretPasswordKey from externalDatabase section, and add user and password entries, in plain test, on externalDatabase section, I could make it work.
Does it ring your bell ?
r
Rajesh Koilpillai
11/23/2023, 2:09 PMnot sure about that