2867021781 commented on issue #1935: URL: https://github.com/apache/incubator-hugegraph/issues/1935#issuecomment-1191389040
> 请参考文档：https://hugegraph.apache.org/docs/config/config-option/#postgresql-%E5%90%8E%E7%AB%AF%E9%85%8D%E7%BD%AE%E9%A1%B9 用的cockroachdb后端存储，hugegraph.properties配置文件如下： backend=postgresql serializer=postgresql ... postgresql & cockroachdb backend config jdbc.driver=org.postgresql.Driver jdbc.url=jdbc:postgresql://172.30.15.151:26257/ jdbc.username=postgres jdbc.password= #jdbc.postgresql.connect_database= 报错： 2022-07-21 19:43:47 [main] [INFO] c.b.h.u.ConfigUtil - Scaning option 'graphs' directory './conf/graphs' 2022-07-21 19:43:47 [main] [INFO] c.b.h.c.InitStore - Init graph with config file: ./conf/graphs/hugegraph.properties 2022-07-21 19:43:47 [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=false' 2022-07-21 19:43:47 [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.(AbstractTransaction.java:82) ~[hugegraph-core-0.12.0.jar:0.12.0.0] at com.baidu.hugegraph.backend.tx.IndexableTransaction.(IndexableTransaction.java:30) ~[hugegraph-core-0.12.0.jar:0.12.0.0] at com.baidu.hugegraph.backend.tx.SchemaTransaction.(SchemaTransaction.java:75) ~[hugegraph-core-0.12.0.jar:0.12.0.0] at com.baidu.hugegraph.backend.cache.CachedSchemaTransaction.(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=false 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.(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] at com.baidu.hugegraph.backend.store.mysql.MysqlSessions.connect(MysqlSessions.java:291) ~[hugegraph-mysql-0.12.0.jar:?] at com.baidu.hugegraph.backend.store.mysql.MysqlSessions.openWithoutDB(MysqlSessions.java:194) ~[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 2022-07-21 19:46:57 [hugegraph-shutdown] [INFO] c.b.h.HugeGraph - HugeGraph is shutting down -- 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]
