obdumper可以直连observer 进行数据导出吗？

厚厚 · 2022 年6 月 2 日 14:57

一般使用 obdumper 时，通过 obproxy 连接 observer 集群进行导出；

obdumper 可以直连集群中的某台 observer 进行数据导出吗？测试时，出现如下问题：

bin/obdumper -h 192.168.111.1 -P 3881 -u tuser -p oracle_4U -c obce-3zones -t obmysql2 -D obtest --public-cloud --csv --table=t_range_hash2 -f /tmp/obdumper11

[admin@obproxy01 ob-loader-dumper-3.0.0]$ bin/obdumper -h 192.168.111.1 -P 3881 -u tuser -p oracle_4U -c obce-3zones -t obmysql2 -D obtest --public-cloud --csv --table=t_range_hash2 -f /tmp/obdumper11
2022-06-02 14:47:51 [INFO] Parsed args:
[--host] 192.168.111.1
[--port] 3881
[--user] tuser
[--tenant] obmysql2
[--cluster] obce-3zones
[--password] ******
[--database] obtest
[--sys-user] root
[--csv] true
[--file-path] /tmp/obdumper11
[--public-cloud] true
[--table] [t_range_hash2]

2022-06-02 14:47:51 [INFO] The security certificate file: "/home/admin/ob-loader-dumper-3.0.0/conf/secure.crt" is not exists
2022-06-02 14:47:51 [INFO] Load jdbc driver class: "org.mariadb.jdbc.Driver" finished
2022-06-02 14:47:51 [INFO] The manifest file: "/tmp/obdumper11/data/MANIFEST.bin" has been saved
2022-06-02 14:47:51 [ERROR] create connection SQLException, url: jdbc:mysql://192.168.111.1:3881/obtest?useUnicode=true&characterEncoding=utf8&socketTimeout=1800000&connectTimeout=180000&usePipelineAuth=false&verifyServerCertificate=false&useSSL=false&allowMultiQueries=true&rewriteBatchedStatements=true&useLocalSessionState=true&useCompression=true&cachePrepStmts=true&noDatetimeStringSync=true&zeroDateTimeBehavior=convertToNull&useServerPrepStmts=true, errorCode 1045, state 42000 java.sql.SQLSyntaxErrorException: Could not connect to address=(host=192.168.111.1)(port=3881)(type=master) : (conn=-1073457293) Access denied for user 'tuser'@'xxx.xxx.xxx.xxx' (using password: YES)
	at org.mariadb.jdbc.internal.util.exceptions.ExceptionFactory.createException(ExceptionFactory.java:62) ~[mariadb-java-client-2.7.4.jar:?]
	at org.mariadb.jdbc.internal.util.exceptions.ExceptionFactory.create(ExceptionFactory.java:197) ~[mariadb-java-client-2.7.4.jar:?]
	at org.mariadb.jdbc.internal.protocol.AbstractConnectProtocol.connectWithoutProxy(AbstractConnectProtocol.java:1394) ~[mariadb-java-client-2.7.4.jar:?]
	at org.mariadb.jdbc.internal.util.Utils.retrieveProxy(Utils.java:635) ~[mariadb-java-client-2.7.4.jar:?]
	at org.mariadb.jdbc.MariaDbConnection.newConnection(MariaDbConnection.java:150) ~[mariadb-java-client-2.7.4.jar:?]
	at org.mariadb.jdbc.Driver.connect(Driver.java:89) ~[mariadb-java-client-2.7.4.jar:?]
	at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1657) ~[druid-1.2.8.jar:1.2.8]
	at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1723) ~[druid-1.2.8.jar:1.2.8]
	at com.alibaba.druid.pool.DruidDataSource$CreateConnectionThread.run(DruidDataSource.java:2838) [druid-1.2.8.jar:1.2.8]
Caused by: java.sql.SQLSyntaxErrorException: (conn=-1073457293) Access denied for user 'tuser'@'xxx.xxx.xxx.xxx' (using password: YES)
	at org.mariadb.jdbc.internal.util.exceptions.ExceptionFactory.createException(ExceptionFactory.java:62) ~[mariadb-java-client-2.7.4.jar:?]
	at org.mariadb.jdbc.internal.util.exceptions.ExceptionFactory.create(ExceptionFactory.java:192) ~[mariadb-java-client-2.7.4.jar:?]
	at org.mariadb.jdbc.internal.protocol.AbstractConnectProtocol.authenticationHandler(AbstractConnectProtocol.java:778) ~[mariadb-java-client-2.7.4.jar:?]
	at org.mariadb.jdbc.internal.protocol.AbstractConnectProtocol.createConnection(AbstractConnectProtocol.java:555) ~[mariadb-java-client-2.7.4.jar:?]
	at org.mariadb.jdbc.internal.protocol.AbstractConnectProtocol.connectWithoutProxy(AbstractConnectProtocol.java:1389) ~[mariadb-java-client-2.7.4.jar:?]
	... 6 more

2022-06-02 14:47:51 [ERROR] create connection SQLException, url: jdbc:mysql://192.168.111.1:3881/obtest?useUnicode=true&characterEncoding=utf8&socketTimeout=1800000&connectTimeout=180000&usePipelineAuth=false&verifyServerCertificate=false&useSSL=false&allowMultiQueries=true&rewriteBatchedStatements=true&useLocalSessionState=true&useCompression=true&cachePrepStmts=true&noDatetimeStringSync=true&zeroDateTimeBehavior=convertToNull&useServerPrepStmts=true, errorCode 1045, state 42000 java.sql.SQLSyntaxErrorException: Could not connect to address=(host=192.168.111.1)(port=3881)(type=master) : (conn=-1073457292) Access denied for user 'tuser'@'xxx.xxx.xxx.xxx' (using password: YES)
	at org.mariadb.jdbc.internal.util.exceptions.ExceptionFactory.createException(ExceptionFactory.java:62) ~[mariadb-java-client-2.7.4.jar:?]
	at org.mariadb.jdbc.internal.util.exceptions.ExceptionFactory.create(ExceptionFactory.java:197) ~[mariadb-java-client-2.7.4.jar:?]
	at org.mariadb.jdbc.internal.protocol.AbstractConnectProtocol.connectWithoutProxy(AbstractConnectProtocol.java:1394) ~[mariadb-java-client-2.7.4.jar:?]
	at org.mariadb.jdbc.internal.util.Utils.retrieveProxy(Utils.java:635) ~[mariadb-java-client-2.7.4.jar:?]
	at org.mariadb.jdbc.MariaDbConnection.newConnection(MariaDbConnection.java:150) ~[mariadb-java-client-2.7.4.jar:?]
	at org.mariadb.jdbc.Driver.connect(Driver.java:89) ~[mariadb-java-client-2.7.4.jar:?]
	at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1657) ~[druid-1.2.8.jar:1.2.8]
	at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1723) ~[druid-1.2.8.jar:1.2.8]
	at com.alibaba.druid.pool.DruidDataSource$CreateConnectionThread.run(DruidDataSource.java:2838) [druid-1.2.8.jar:1.2.8]
Caused by: java.sql.SQLSyntaxErrorException: (conn=-1073457292) Access denied for user 'tuser'@'xxx.xxx.xxx.xxx' (using password: YES)
	at org.mariadb.jdbc.internal.util.exceptions.ExceptionFactory.createException(ExceptionFactory.java:62) ~[mariadb-java-client-2.7.4.jar:?]
	at org.mariadb.jdbc.internal.util.exceptions.ExceptionFactory.create(ExceptionFactory.java:192) ~[mariadb-java-client-2.7.4.jar:?]
	at org.mariadb.jdbc.internal.protocol.AbstractConnectProtocol.authenticationHandler(AbstractConnectProtocol.java:778) ~[mariadb-java-client-2.7.4.jar:?]
	at org.mariadb.jdbc.internal.protocol.AbstractConnectProtocol.createConnection(AbstractConnectProtocol.java:555) ~[mariadb-java-client-2.7.4.jar:?]
	at org.mariadb.jdbc.internal.protocol.AbstractConnectProtocol.connectWithoutProxy(AbstractConnectProtocol.java:1389) ~[mariadb-java-client-2.7.4.jar:?]
	... 6 more

2022-06-02 14:47:51 [ERROR] Dump failed! Error: Query schema: "obtest" metadata failed. Error: (conn=-1073457292) Access denied for user 'tuser'@'xxx.xxx.xxx.xxx' (using password: YES)
2022-06-02 14:47:51 [INFO] System exit 1
[admin@obproxy01 ob-loader-dumper-3.0.0]$

用户通过 obclient 是可以正常连接，查询表的；

[admin@obproxy01 ~]$ obclient -h192.168.111.1 -utuser@obmysql2 -P3881 -poracle_4U -c -A obtest
Welcome to the OceanBase.  Commands end with ; or \g.
Your MySQL connection id is 3221510535
Server version: 5.7.25 OceanBase 3.1.2 (r10000392021123010-d4ace121deae5b81d8f0b40afbc4c02705b7fc1d) (Built Dec 30 2021 02:47:29)

Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MySQL [obtest]> select count(*) from t_range_hash2;
+----------+
| count(*) |
+----------+
| 49020928 |
+----------+
1 row in set (8.008 sec)

MySQL [obtest]>

是 obdumper 命令哪里写错了吗？各位大神请指教一下，谢谢；

苏琅 · 2022 年6 月 2 日 15:49

2022-06-02 14:47:51 [ERROR] Dump failed! Error: Query schema: “obtest” metadata failed. Error: (conn=-1073457292) Access denied for user ‘tuser’@‘xxx.xxx.xxx.xxx’ (using password: YES)
看这里的报错，是用户名和密码这块有问题

厚厚 · 2022 年6 月 2 日 15:52

上面有描述，用 obclient 测试 tuser 的密码是可以正常登录了，不知道 obdumper 的参数写法有没有问题？

上旬 · 2022 年6 月 2 日 15:52

直连的话，应该不用加集群名

厚厚 · 2022 年6 月 2 日 16:00

嗯，对的，不带集群参数，+ --public-cloud 参数是可以直连导出的；

不过，如果不想用 -public-cloud 参数，而使用 --sys-user --sys-password 参数，还是不行；

如下：
bin/obdumper -h 192.168.111.1 -P 3881 -u tuser -p oracle_4U -c obce-3zones -t obmysql2 -D obtest --public-cloud --csv --table=t_range_hash2 -f /tmp/obdumper11
这种方法可以；

如下：

bin/obdumper -h 192.168.111.1 -P 3881 -u tuser -p oracle_4U -c obce-3zones -t obmysql2 -D obtest --sys-user=root --sys-password=rootpwd123 --csv --table=t_range_hash2 -f /tmp/obdumper11
这种方法还是报错：
[admin@obproxy01 ob-loader-dumper-3.0.0]$ bin/obdumper -h 192.168.111.1 -P 3881 -u tuser -p oracle_4U -c obce-3zones -t obmysql2 -D obtest --sys-user=root --sys-password=rootpwd123 --csv --table=t_range_hash2 -f /tmp/obdumper11
2022-06-02 15:55:55 [INFO] Parsed args:
[--host] 192.168.111.1
[--port] 3881
[--user] tuser
[--tenant] obmysql2
[--cluster] obce-3zones
[--password] ******
[--database] obtest
[--sys-user] root
[--sys-password] ******
[--csv] true
[--file-path] /tmp/obdumper11
[--table] [t_range_hash2]

2022-06-02 15:55:55 [INFO] Load jdbc driver class: "org.mariadb.jdbc.Driver" finished
2022-06-02 15:55:55 [INFO] The manifest file: "/tmp/obdumper11/data/MANIFEST.bin" has been saved
2022-06-02 15:55:55 [ERROR] create connection SQLException, url: jdbc:mysql://192.168.111.1:3881/oceanbase?useUnicode=true&characterEncoding=utf8&socketTimeout=1800000&connectTimeout=180000&usePipelineAuth=false&verifyServerCertificate=false&useSSL=false, errorCode 1045, state 42000 java.sql.SQLSyntaxErrorException: Could not connect to address=(host=192.168.111.1)(port=3881)(type=master) : (conn=-1073450448) Access denied for user 'root'@'xxx.xxx.xxx.xxx' (using password: YES)
	at org.mariadb.jdbc.internal.util.exceptions.ExceptionFactory.createException(ExceptionFactory.java:62) ~[mariadb-java-client-2.7.4.jar:?]
	at org.mariadb.jdbc.internal.util.exceptions.ExceptionFactory.create(ExceptionFactory.java:197) ~[mariadb-java-client-2.7.4.jar:?]
	at org.mariadb.jdbc.internal.protocol.AbstractConnectProtocol.connectWithoutProxy(AbstractConnectProtocol.java:1394) ~[mariadb-java-client-2.7.4.jar:?]
	at org.mariadb.jdbc.internal.util.Utils.retrieveProxy(Utils.java:635) ~[mariadb-java-client-2.7.4.jar:?]
	at org.mariadb.jdbc.MariaDbConnection.newConnection(MariaDbConnection.java:150) ~[mariadb-java-client-2.7.4.jar:?]
	at org.mariadb.jdbc.Driver.connect(Driver.java:89) ~[mariadb-java-client-2.7.4.jar:?]
	at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1657) ~[druid-1.2.8.jar:1.2.8]
	at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1723) ~[druid-1.2.8.jar:1.2.8]
	at com.alibaba.druid.pool.DruidDataSource$CreateConnectionThread.run(DruidDataSource.java:2838) [druid-1.2.8.jar:1.2.8]
Caused by: java.sql.SQLSyntaxErrorException: (conn=-1073450448) Access denied for user 'root'@'xxx.xxx.xxx.xxx' (using password: YES)
	at org.mariadb.jdbc.internal.util.exceptions.ExceptionFactory.createException(ExceptionFactory.java:62) ~[mariadb-java-client-2.7.4.jar:?]
	at org.mariadb.jdbc.internal.util.exceptions.ExceptionFactory.create(ExceptionFactory.java:192) ~[mariadb-java-client-2.7.4.jar:?]
	at org.mariadb.jdbc.internal.protocol.AbstractConnectProtocol.authenticationHandler(AbstractConnectProtocol.java:778) ~[mariadb-java-client-2.7.4.jar:?]
	at org.mariadb.jdbc.internal.protocol.AbstractConnectProtocol.createConnection(AbstractConnectProtocol.java:555) ~[mariadb-java-client-2.7.4.jar:?]
	at org.mariadb.jdbc.internal.protocol.AbstractConnectProtocol.connectWithoutProxy(AbstractConnectProtocol.java:1389) ~[mariadb-java-client-2.7.4.jar:?]
	... 6 more

2022-06-02 15:55:55 [ERROR] create connection SQLException, url: jdbc:mysql://192.168.111.1:3881/obtest?useUnicode=true&characterEncoding=utf8&socketTimeout=1800000&connectTimeout=180000&usePipelineAuth=false&verifyServerCertificate=false&useSSL=false&allowMultiQueries=true&rewriteBatchedStatements=true&useLocalSessionState=true&useCompression=true&cachePrepStmts=true&noDatetimeStringSync=true&zeroDateTimeBehavior=convertToNull&useServerPrepStmts=true, errorCode 1045, state 42000 java.sql.SQLSyntaxErrorException: Could not connect to address=(host=192.168.111.1)(port=3881)(type=master) : (conn=-1073450449) Access denied for user 'tuser'@'xxx.xxx.xxx.xxx' (using password: YES)
	at org.mariadb.jdbc.internal.util.exceptions.ExceptionFactory.createException(ExceptionFactory.java:62) ~[mariadb-java-client-2.7.4.jar:?]
	at org.mariadb.jdbc.internal.util.exceptions.ExceptionFactory.create(ExceptionFactory.java:197) ~[mariadb-java-client-2.7.4.jar:?]
	at org.mariadb.jdbc.internal.protocol.AbstractConnectProtocol.connectWithoutProxy(AbstractConnectProtocol.java:1394) ~[mariadb-java-client-2.7.4.jar:?]
	at org.mariadb.jdbc.internal.util.Utils.retrieveProxy(Utils.java:635) ~[mariadb-java-client-2.7.4.jar:?]
	at org.mariadb.jdbc.MariaDbConnection.newConnection(MariaDbConnection.java:150) ~[mariadb-java-client-2.7.4.jar:?]
	at org.mariadb.jdbc.Driver.connect(Driver.java:89) ~[mariadb-java-client-2.7.4.jar:?]
	at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1657) ~[druid-1.2.8.jar:1.2.8]
	at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1723) ~[druid-1.2.8.jar:1.2.8]
	at com.alibaba.druid.pool.DruidDataSource$CreateConnectionThread.run(DruidDataSource.java:2838) [druid-1.2.8.jar:1.2.8]
Caused by: java.sql.SQLSyntaxErrorException: (conn=-1073450449) Access denied for user 'tuser'@'xxx.xxx.xxx.xxx' (using password: YES)
	at org.mariadb.jdbc.internal.util.exceptions.ExceptionFactory.createException(ExceptionFactory.java:62) ~[mariadb-java-client-2.7.4.jar:?]
	at org.mariadb.jdbc.internal.util.exceptions.ExceptionFactory.create(ExceptionFactory.java:192) ~[mariadb-java-client-2.7.4.jar:?]
	at org.mariadb.jdbc.internal.protocol.AbstractConnectProtocol.authenticationHandler(AbstractConnectProtocol.java:778) ~[mariadb-java-client-2.7.4.jar:?]
	at org.mariadb.jdbc.internal.protocol.AbstractConnectProtocol.createConnection(AbstractConnectProtocol.java:555) ~[mariadb-java-client-2.7.4.jar:?]
	at org.mariadb.jdbc.internal.protocol.AbstractConnectProtocol.connectWithoutProxy(AbstractConnectProtocol.java:1389) ~[mariadb-java-client-2.7.4.jar:?]
	... 6 more

2022-06-02 15:55:55 [ERROR] create connection SQLException, url: jdbc:mysql://192.168.111.1:3881/oceanbase?useUnicode=true&characterEncoding=utf8&socketTimeout=1800000&connectTimeout=180000&usePipelineAuth=false&verifyServerCertificate=false&useSSL=false, errorCode 1045, state 42000 java.sql.SQLSyntaxErrorException: Could not connect to address=(host=192.168.111.1)(port=3881)(type=master) : (conn=-1073450447) Access denied for user 'root'@'xxx.xxx.xxx.xxx' (using password: YES)
	at org.mariadb.jdbc.internal.util.exceptions.ExceptionFactory.createException(ExceptionFactory.java:62) ~[mariadb-java-client-2.7.4.jar:?]
	at org.mariadb.jdbc.internal.util.exceptions.ExceptionFactory.create(ExceptionFactory.java:197) ~[mariadb-java-client-2.7.4.jar:?]
	at org.mariadb.jdbc.internal.protocol.AbstractConnectProtocol.connectWithoutProxy(AbstractConnectProtocol.java:1394) ~[mariadb-java-client-2.7.4.jar:?]
	at org.mariadb.jdbc.internal.util.Utils.retrieveProxy(Utils.java:635) ~[mariadb-java-client-2.7.4.jar:?]
	at org.mariadb.jdbc.MariaDbConnection.newConnection(MariaDbConnection.java:150) ~[mariadb-java-client-2.7.4.jar:?]
	at org.mariadb.jdbc.Driver.connect(Driver.java:89) ~[mariadb-java-client-2.7.4.jar:?]
	at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1657) ~[druid-1.2.8.jar:1.2.8]
	at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1723) ~[druid-1.2.8.jar:1.2.8]
	at com.alibaba.druid.pool.DruidDataSource$CreateConnectionThread.run(DruidDataSource.java:2838) [druid-1.2.8.jar:1.2.8]
Caused by: java.sql.SQLSyntaxErrorException: (conn=-1073450447) Access denied for user 'root'@'xxx.xxx.xxx.xxx' (using password: YES)
	at org.mariadb.jdbc.internal.util.exceptions.ExceptionFactory.createException(ExceptionFactory.java:62) ~[mariadb-java-client-2.7.4.jar:?]
	at org.mariadb.jdbc.internal.util.exceptions.ExceptionFactory.create(ExceptionFactory.java:192) ~[mariadb-java-client-2.7.4.jar:?]
	at org.mariadb.jdbc.internal.protocol.AbstractConnectProtocol.authenticationHandler(AbstractConnectProtocol.java:778) ~[mariadb-java-client-2.7.4.jar:?]
	at org.mariadb.jdbc.internal.protocol.AbstractConnectProtocol.createConnection(AbstractConnectProtocol.java:555) ~[mariadb-java-client-2.7.4.jar:?]
	at org.mariadb.jdbc.internal.protocol.AbstractConnectProtocol.connectWithoutProxy(AbstractConnectProtocol.java:1389) ~[mariadb-java-client-2.7.4.jar:?]
	... 6 more

2022-06-02 15:55:55 [ERROR] create connection SQLException, url: jdbc:mysql://192.168.111.1:3881/obtest?useUnicode=true&characterEncoding=utf8&socketTimeout=1800000&connectTimeout=180000&usePipelineAuth=false&verifyServerCertificate=false&useSSL=false&allowMultiQueries=true&rewriteBatchedStatements=true&useLocalSessionState=true&useCompression=true&cachePrepStmts=true&noDatetimeStringSync=true&zeroDateTimeBehavior=convertToNull&useServerPrepStmts=true, errorCode 1045, state 42000 java.sql.SQLSyntaxErrorException: Could not connect to address=(host=192.168.111.1)(port=3881)(type=master) : (conn=-1073450446) Access denied for user 'tuser'@'xxx.xxx.xxx.xxx' (using password: YES)
	at org.mariadb.jdbc.internal.util.exceptions.ExceptionFactory.createException(ExceptionFactory.java:62) ~[mariadb-java-client-2.7.4.jar:?]
	at org.mariadb.jdbc.internal.util.exceptions.ExceptionFactory.create(ExceptionFactory.java:197) ~[mariadb-java-client-2.7.4.jar:?]
	at org.mariadb.jdbc.internal.protocol.AbstractConnectProtocol.connectWithoutProxy(AbstractConnectProtocol.java:1394) ~[mariadb-java-client-2.7.4.jar:?]
	at org.mariadb.jdbc.internal.util.Utils.retrieveProxy(Utils.java:635) ~[mariadb-java-client-2.7.4.jar:?]
	at org.mariadb.jdbc.MariaDbConnection.newConnection(MariaDbConnection.java:150) ~[mariadb-java-client-2.7.4.jar:?]
	at org.mariadb.jdbc.Driver.connect(Driver.java:89) ~[mariadb-java-client-2.7.4.jar:?]
	at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1657) ~[druid-1.2.8.jar:1.2.8]
	at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1723) ~[druid-1.2.8.jar:1.2.8]
	at com.alibaba.druid.pool.DruidDataSource$CreateConnectionThread.run(DruidDataSource.java:2838) [druid-1.2.8.jar:1.2.8]
Caused by: java.sql.SQLSyntaxErrorException: (conn=-1073450446) Access denied for user 'tuser'@'xxx.xxx.xxx.xxx' (using password: YES)
	at org.mariadb.jdbc.internal.util.exceptions.ExceptionFactory.createException(ExceptionFactory.java:62) ~[mariadb-java-client-2.7.4.jar:?]
	at org.mariadb.jdbc.internal.util.exceptions.ExceptionFactory.create(ExceptionFactory.java:192) ~[mariadb-java-client-2.7.4.jar:?]
	at org.mariadb.jdbc.internal.protocol.AbstractConnectProtocol.authenticationHandler(AbstractConnectProtocol.java:778) ~[mariadb-java-client-2.7.4.jar:?]
	at org.mariadb.jdbc.internal.protocol.AbstractConnectProtocol.createConnection(AbstractConnectProtocol.java:555) ~[mariadb-java-client-2.7.4.jar:?]
	at org.mariadb.jdbc.internal.protocol.AbstractConnectProtocol.connectWithoutProxy(AbstractConnectProtocol.java:1389) ~[mariadb-java-client-2.7.4.jar:?]
	... 6 more

2022-06-02 15:55:55 [ERROR] Dump failed! Error: Query schema: "obtest" metadata failed. Error: (conn=-1073450446) Access denied for user 'tuser'@'xxx.xxx.xxx.xxx' (using password: YES)
2022-06-02 15:55:55 [INFO] System exit 1

厚厚 · 2022 年6 月 2 日 16:07

找到原因了，还是 -c 参数的原因，谢谢了

DXF · 2023 年7 月 8 日 20:19

您好，我也遇到这个问题，能否帮忙，告诉我是怎么解决的，

谢谢了！！！

请高人帮忙看看 obdumper 密码错误，但我用JAVA和工具都是对。 Access denied for user ‘root’@‘xxx.xxx.xxx.xxx’ - 社区问答- OceanBase社区-分布式数据库