2867021781 commented on issue #1935:
URL:
https://github.com/apache/incubator-hugegraph/issues/1935#issuecomment-1191457469
> 从错误信息来看`PSQLException: ERROR: cleartext connections are not
permitted`，可能需要启用加密传输，请尝试启用`jdbc.ssl_mode`（默认为false）：
>
> ```ini
> jdbc.ssl_mode=true
> ```
useSSL=true变成true了，还是一样的错误
2022-07-21 21:00:04 [main] [INFO] c.b.h.b.s.m.MysqlStore - Connect to the
jdbc url:
'jdbc:postgresql://172.30.15.151:26257/template1?loggerLevel=OFF&socketTimeout=0&useSSL=true'
Exception in thread "main" com.baidu.hugegraph.HugeException: Failed to open
schema transaction
at
com.baidu.hugegraph.StandardHugeGraph.openSchemaTransaction(StandardHugeGraph.java:417)
at
com.baidu.hugegraph.StandardHugeGraph.access$2600(StandardHugeGraph.java:112)
at
com.baidu.hugegraph.StandardHugeGraph$TinkerPopTransaction.getOrNewTransaction(StandardHugeGraph.java:1387)
at
com.baidu.hugegraph.StandardHugeGraph$TinkerPopTransaction.schemaTransaction(StandardHugeGraph.java:1363)
at
com.baidu.hugegraph.StandardHugeGraph$TinkerPopTransaction.access$100(StandardHugeGraph.java:1233)
at
com.baidu.hugegraph.StandardHugeGraph.schemaTransaction(StandardHugeGraph.java:470)
at
com.baidu.hugegraph.StandardHugeGraph.backendStoreSystemInfo(StandardHugeGraph.java:249)
at com.baidu.hugegraph.cmd.InitStore.initGraph(InitStore.java:94)
at com.baidu.hugegraph.cmd.InitStore.main(InitStore.java:79)
2022-07-21 21:00:04 [main] [ERROR] c.b.h.HugeGraph - Failed to open schema
transaction
com.baidu.hugegraph.backend.BackendException: Failed to obtain database info
at
com.baidu.hugegraph.backend.store.postgresql.PostgresqlSessions.existsDatabase(PostgresqlSessions.java:61)
~[hugegraph-postgresql-0.12.0.jar:?]
at
com.baidu.hugegraph.backend.store.mysql.MysqlStore.open(MysqlStore.java:122)
~[hugegraph-mysql-0.12.0.jar:?]
at
com.baidu.hugegraph.backend.tx.AbstractTransaction.<init>(AbstractTransaction.java:82)
~[hugegraph-core-0.12.0.jar:0.12.0.0]
at
com.baidu.hugegraph.backend.tx.IndexableTransaction.<init>(IndexableTransaction.java:30)
~[hugegraph-core-0.12.0.jar:0.12.0.0]
at
com.baidu.hugegraph.backend.tx.SchemaTransaction.<init>(SchemaTransaction.java:75)
~[hugegraph-core-0.12.0.jar:0.12.0.0]
at
com.baidu.hugegraph.backend.cache.CachedSchemaTransaction.<init>(CachedSchemaTransaction.java:54)
~[hugegraph-core-0.12.0.jar:0.12.0.0]
at
com.baidu.hugegraph.StandardHugeGraph.openSchemaTransaction(StandardHugeGraph.java:413)
~[hugegraph-core-0.12.0.jar:0.12.0.0]
at
com.baidu.hugegraph.StandardHugeGraph.access$2600(StandardHugeGraph.java:112)
~[hugegraph-core-0.12.0.jar:0.12.0.0]
at
com.baidu.hugegraph.StandardHugeGraph$TinkerPopTransaction.getOrNewTransaction(StandardHugeGraph.java:1387)
~[hugegraph-core-0.12.0.jar:0.12.0.0]
at
com.baidu.hugegraph.StandardHugeGraph$TinkerPopTransaction.schemaTransaction(StandardHugeGraph.java:1363)
~[hugegraph-core-0.12.0.jar:0.12.0.0]
at
com.baidu.hugegraph.StandardHugeGraph$TinkerPopTransaction.access$100(StandardHugeGraph.java:1233)
~[hugegraph-core-0.12.0.jar:0.12.0.0]
at
com.baidu.hugegraph.StandardHugeGraph.schemaTransaction(StandardHugeGraph.java:470)
~[hugegraph-core-0.12.0.jar:0.12.0.0]
at
com.baidu.hugegraph.StandardHugeGraph.backendStoreSystemInfo(StandardHugeGraph.java:249)
~[hugegraph-core-0.12.0.jar:0.12.0.0]
at com.baidu.hugegraph.cmd.InitStore.initGraph(InitStore.java:94)
~[hugegraph-dist-0.12.0.jar:?]
at com.baidu.hugegraph.cmd.InitStore.main(InitStore.java:79)
~[hugegraph-dist-0.12.0.jar:?]
Caused by: com.baidu.hugegraph.backend.BackendException: Failed to access
jdbc:postgresql://172.30.15.151:26257/template1?loggerLevel=OFF&socketTimeout=0&useSSL=true
at
com.baidu.hugegraph.backend.store.mysql.MysqlSessions.openWithoutDB(MysqlSessions.java:196)
~[hugegraph-mysql-0.12.0.jar:?]
at
com.baidu.hugegraph.backend.store.postgresql.PostgresqlSessions.existsDatabase(PostgresqlSessions.java:57)
~[hugegraph-postgresql-0.12.0.jar:?]
... 14 more
Caused by: org.postgresql.util.PSQLException: ERROR: cleartext connections
are not permitted
at
org.postgresql.core.v3.ConnectionFactoryImpl.doAuthentication(ConnectionFactoryImpl.java:438)
~[postgresql-42.1.4.jar:42.1.4]
at
org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:222)
~[postgresql-42.1.4.jar:42.1.4]
at
org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:49)
~[postgresql-42.1.4.jar:42.1.4]
at org.postgresql.jdbc.PgConnection.<init>(PgConnection.java:194)
~[postgresql-42.1.4.jar:42.1.4]
at org.postgresql.Driver.makeConnection(Driver.java:450)
~[postgresql-42.1.4.jar:42.1.4]
at org.postgresql.Driver.connect(Driver.java:252)
~[postgresql-42.1.4.jar:42.1.4]
at java.sql.DriverManager.getConnection(DriverManager.java:664)
~[?:1.8.0_181]
at java.sql.DriverManager.getConnection(DriverManager.java:247)
~[?:1.8.0_181]
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
