search

polardb / polardbx-sql

PolarDB-X is a cloud native distributed SQL Database designed for high concurrency, massive storage, complex querying scenarios.
Apache License 2.0
1.54k stars 325 forks source link

Extra space char at end of metaDbUser=my_polarx in server.properties #21

Closed luyaning closed 2 years ago

luyaning commented 2 years ago

Extra space char at end of metaDbUser=my_polarx in server.properties, leads to connect to metadb failed:

Caused by: java.sql.SQLException: Access denied for user 'my_polarx '@'192.168.1.131' (using password: YES)

Following quickstart-development.md

At Final Step, Run PolarDB-X: bin/startup.sh -P asdf1234ghjk5678

Error at meta-db.log 2021-10-27 17:44:12.376 ERROR ERR-CODE: [PXC-9001][ERR_GMS_GENERIC] Failed to create connection to [jdbc:mysql://192.168.1.131:8811/polardbx_meta_db_polardbx?allowMultiQueries=true&allowPublicKeyRetrieval=true&autoReconnect=false&characterEncoding=utf8&connectTimeout=10000&failOverReadOnly=false&rewriteBatchedStatements=true&socketTimeout=900000&useServerPrepStmts=false&useSSL=false&useUnicode=true]. com.alibaba.polardbx.common.exception.TddlRuntimeException: ERR-CODE: [PXC-9001][ERR_GMS_GENERIC] Failed to create connection to [jdbc:mysql://192.168.1.131:8811/polardbx_meta_db_polardbx?allowMultiQueries=true&allowPublicKeyRetrieval=true&autoReconnect=false&characterEncoding=utf8&connectTimeout=10000&failOverReadOnly=false&rewriteBatchedStatements=true&socketTimeout=900000&useServerPrepStmts=false&useSSL=false&useUnicode=true]. at com.alibaba.polardbx.gms.util.GmsJdbcUtil.createConnection(GmsJdbcUtil.java:109) at com.alibaba.polardbx.gms.util.GmsJdbcUtil.buildJdbcConnection(GmsJdbcUtil.java:94) at com.alibaba.polardbx.gms.metadb.MetaDbDataSource.initMetaDbAvaliableAddr(MetaDbDataSource.java:256) at com.alibaba.polardbx.gms.metadb.MetaDbDataSource.doInit(MetaDbDataSource.java:119) at com.alibaba.polardbx.common.model.lifecycle.AbstractLifecycle.init(AbstractLifecycle.java:43) at com.alibaba.polardbx.gms.metadb.MetaDbDataSource.getInstance(MetaDbDataSource.java:462) at com.alibaba.polardbx.gms.metadb.MetaDbDataSource.initMetaDbDataSource(MetaDbDataSource.java:488) at com.alibaba.polardbx.config.loader.ServerLoader.initPolarDbXComponents(ServerLoader.java:207) at com.alibaba.polardbx.config.loader.ServerLoader.load(ServerLoader.java:181) at com.alibaba.polardbx.config.loader.ServerLoader.doInit(ServerLoader.java:91) at com.alibaba.polardbx.common.model.lifecycle.AbstractLifecycle.init(AbstractLifecycle.java:43) at com.alibaba.polardbx.CobarConfig.initCobarConfig(CobarConfig.java:68) at com.alibaba.polardbx.CobarConfig.(CobarConfig.java:61) at com.alibaba.polardbx.CobarServer.(CobarServer.java:141) at com.alibaba.polardbx.CobarServer.(CobarServer.java:95) at com.alibaba.polardbx.server.TddlLauncher.main(TddlLauncher.java:82) _Caused by: java.sql.SQLException: Access denied for user 'mypolarx '@'192.168.1.131' (using password: YES) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:965) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3933) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3869) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:864) at com.mysql.jdbc.MysqlIO.proceedHandshakeWithPluggableAuthentication(MysqlIO.java:1707) at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1217) at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2189) at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2220) at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2015) at com.mysql.jdbc.ConnectionImpl.(ConnectionImpl.java:768) at com.mysql.jdbc.JDBC4Connection.(JDBC4Connection.java:47) at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) at java.lang.reflect.Constructor.newInstance(Constructor.java:423) at com.mysql.jdbc.Util.handleNewInstance(Util.java:403) at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:385) at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:323) at com.alibaba.polardbx.gms.util.GmsJdbcUtil.getConnectionByDriver(GmsJdbcUtil.java:135) at com.alibaba.polardbx.gms.util.GmsJdbcUtil.createConnection(GmsJdbcUtil.java:105) ... 15 common frames omitted 2021-10-27 17:44:12.379 WARN [TDDL] Fail to fetch xport from node[null] type -1, and set xport=-1, tddl version: 5.4.12-20211027

conf/server.properties serverPort=3306 managerPort=3406 rpcPort=9090 charset=utf-8 processors=4 processorHandler=16 processorKillExecutor=128 timerExecutor=8 managerExecutor=256 serverExecutor=1024 idleTimeout= trustedIps=192.168.1.131 slowSqlTime=1000 maxConnection=20000 allowManagerLogin=1 allowCrossDbQuery=true galaxyXProtocol=1 metaDbAddr=192.168.1.131:8811 metaDbXprotoPort=28811 metaDbUser=my_polarx metaDbName=polardbx_meta_db_polardbx instanceId=polardbx-polardbx metaDbPasswd=n8zArSMVJvlFXBDZ=

Zeratulllll commented 2 years ago

fixed, thank u