verdict-project/verdict

[Amazon](600000) Error setting/closing connection: General SSLEngine problem.

Closed this issue · 5 comments

solangepaz commented

When I'm trying to use pyverdict with PostgreSQL I get this error:

py4j.protocol.Py4JJavaError: An error occurred while calling z:org.verdictdb.VerdictContext.fromConnectionString.
: org.verdictdb.exception.VerdictDBDbmsException: [Amazon](600000) Error setting/closing connection: General SSLEngine problem.
        at org.verdictdb.connection.ConcurrentJdbcConnection.<init>(ConcurrentJdbcConnection.java:72)
        at org.verdictdb.connection.ConcurrentJdbcConnection.create(ConcurrentJdbcConnection.java:86)
        at org.verdictdb.VerdictContext.fromConnectionString(VerdictContext.java:229)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:498)
        at py4j.reflection.MethodInvoker.invoke(MethodInvoker.java:244)
        at py4j.reflection.ReflectionEngine.invoke(ReflectionEngine.java:357)
        at py4j.Gateway.invoke(Gateway.java:282)
        at py4j.commands.AbstractCommand.invokeMethod(AbstractCommand.java:132)
        at py4j.commands.CallCommand.execute(CallCommand.java:79)
        at py4j.GatewayConnection.run(GatewayConnection.java:238)
        at java.lang.Thread.run(Thread.java:748)
pyongjoo commented

For some reasons, Redshift's JDBC driver seems to be used instead (of postgres driver). I'll post further updates shortly.

pyongjoo commented

It should work now. Please update by pip install pyverdict --upgrade

>>> import pyverdict
>>> pyverdict.__version__
'0.1.3.2'
>>> verdict = pyverdict.postgres(host='127.0.0.1', port=5432, dbname='postgres', user='postgres')
>>> verdict.sql('show schemas')
9 row(s) in the result (0.404 seconds)
                                       schema
0                               verdictdbmeta
1                               verdictdbtemp
2  pyverdict_postgres_datatype_test_schema464
3                          information_schema
4                                      public
5                                  pg_catalog
6                             pg_toast_temp_1
7                                   pg_temp_1
8                                    pg_toast
>>>
pyongjoo commented

Let me close this issue, but please feel free to reopen this if you still experience the same (or closely related) problems.

santfirax commented

Hello, I am having this issue, I can not connect to my instance. [HY000][600000] Amazon Error setting/closing connection: General SSLEngine problem.

pyongjoo commented