ABI启动报错SELECT command denied to user 'hc_report'@'IP'' for table 'abi54_edso_jdbc'

本帖最后由 pandabuxizao 于 2025-1-10 15:27 编辑

前提描述：ABI526平滑升级为ABI543，数据库可以测通，导入许可文件后启动报错SELECT command denied to user 'hc_report'@'IP'' for table 'abi54_edso_jdbc'提示用户hc_report没有表abi54_edso_jdbc'的select权限，但是通过语句查看，发现已经赋予了所有权限。

排查思路：由于是导入许可文件后开始报错，查看工作目录jdbc.conf文件，发现URL链接写法有问题
解决方法：由于升级之前是ABI526，数据库驱动为mysql5，升级后war包自带驱动为mysql8，驱动不一致，URL链接写法不一样
mysql5和mysql8的默认参数中，catalog和schema含义不一样，会有影响，故升级后数据库配置界面需要修改URL链接。

不同数据库参考URL写法如下：

数据库	版本	URL
ADS/ADB（AnalyticDB）		jdbc:mysql://pit-test-ca14d607.cn-hangzhou-1.ads.aliyuncs.com:10016/pit_test
ArteryBase		jdbc:ArteryBase://172.21.1.199:5432/test?Charset=utf8
Clickhouse		jdbc:clickhouse://127.0.0.1:8123/test
		jdbc:clickhouse://127.0.0.1:8123/test jdbc:clickhouse://127.0.0.1:8123/test?databaseTerm=SCHEMA
DB2		jdbc:db2://192.168.1.224:50000/testdb
DM 达梦	7	jdbc:dm://192.168.1.224:12345
Druid		jdbc:avatica:remote:url=http://127.0.0.1:8082/druid/v2/sql/avatica/
EsgynDB 易鲸捷		jdbc:t4jdbc://172.17.3.191:23400/:schema=TACS
Essbase		jdbclap2j:essbase:server=http://192.168.1.243:13080/aps/JAPI
GBase 南大通用	8a	jdbc:gbase://127.0.01:5258/test
	8T	jdbc:informix-sqli://172.21.150.59:9088/bi47_test:INFORMIXSERVER=ifxserver; NEWCODESET=utf8,8859-1,819;CLIENT_LOCALE=en_US.utf8;DB_LOCALE=en_US.8859-1
	8s	jdbc:gbasedbt-sqli://192.168.17.167:7305/sysmaster:GBASEDBTSERVER=ol_gbasedbt1210; NEWCODESET=utf8,8859-1,819;CLIENT_LOCALE=en_US.utf8;DB_LOCALE=en_US.8859-1
Greenplum		jdbc:pivotal:greenplum://172.21.150.69:5432; DatabaseName=gsgs
h2		jdbc:h2:/testh2/tseth2
Hana		jdbc:sap://9.1.80.3:30041/?databaseName=HDQ
HBase		jdbc:phoenix:172.17.3.195,172.17.3.196,172.17.3.197:2181;schema=LIUJIN
Hive		jdbc:hive2://127.0.0.1:10000/testdb
Highgo 瀚高		jdbc:postgresql://172.21.150.36:5432/liujintest
HuaweiELK		jdbc:postgresql://localhost:5432/dbname
Huawei Hetu	Hetu	jdbc:presto://10.146.11.204:24002,10.146.11.205:24002,10.146.11.206:24002/hive/rz?serviceDiscoveryMode=zooKeeper&zooKeeperNamespace=hsbroker 扩展参数示例： jdbc.KerberosKeytabPath=D:\test\huawei\user.keytab jdbc.SSL=true jdbc.KerberosConfigPath=D:\test\huawei\krb5.conf jdbc.KerberosPrincipal=lkjt_hycj jdbc.KerberosRemoteServiceName=HTTP jdbc.tenant=default jdbc.deploymentMode=on_yarn jdbc.KerberosServicePrincipalPattern=${SERVICE}@${HOST} jdbc.SSLTrustStorePath=d:\test\huawei\hetuserver.jks
HuaweiGauss 高斯	Gauss100	jdbc:zenith172.30.96.40:40000
	Gauss200	jdbc:gaussdb://127.0.0.1:25308/dbname?blobMode=off&prepareThreshold=0
HuaweiSparkSQL		jdbc:hive2://127.0.0.1:10000/testdb
Impala		jdbc:hive2://127.0.0.1:21050/testdb;auth=noSASL
Informix		jdbc:informix-sqli://172.21.150.59:9088/bi47_test:INFORMIXSERVER=ifxserver; NEWCODESET=utf8,8859-1,819;CLIENT_LOCALE=en_US.utf8;DB_LOCALE=en_US.8859-1
KDB 浪潮		jdbc:inspur:thin172.21.150.17:8629:kdb
Kingbase 人大金仓	7	jdbc:kingbase://192.168.1.247/testdb
	8	jdbc:kingbase8://192.168.1.247/testdb
	KADB	jdbc:kingbaseanalyticsdb://localhost:5432/testdb
Kylin		jdbc:kylin://172.21.150.14:7070/BI47_TEST
LinkoopDB 、ZettaBase		jdbc:linkoopdb:tcp://172.21.160.99:9105/ldb
MaxComputer(ODPS)		jdbc:postgresql://lightning.cn-beijing.maxcompute.aliyun.com:443/ODM?ssl=true
		jdbcdps:http://service.cn-beijing.maxcompute.aliyun.com/api?project=ODM 连接地址写法具体说明参见 ODPS 文档中 endpoint 的详细说明： https://help.aliyun.com/document_detail/34951.html?spm=a2c4g.11186623.2.16.6b2164e4IXcYtP#concept-m2j-h1y-5db
MongoDB		jdbc:mongo://localhost:27017/liujin
MSSQL(SQLServer)		jdbc:sqlserver://192.168.1.223:1433;databaseName=testdb;
MySQL	5.x	jdbc:mysql://192.168.1.223:3306/testdb?useUnicode=true&characterEncoding=utf8 使用Mysql8的驱动连接mysql5时，遵循Mysql8的url的格式
	8	jdbc:mysql://localhost:3306/test?serverTimezone=Asia/Shanghai&useUnicode=true& characterEncoding=utf8&useSSL=false&databaseTerm=SCHEMA&nullDatabaseMeansCurrent=true
Netezza		jdbc:netezza://127.0.0.1:5480/dbname
Oracle	10g,11g....	jdbcracle:thin192.168.1.102:1521:sid
	12c,18c,...	jdbcracle:thin192.168.1.102:1521/serviceName
Oscar 神舟通用		jdbcscar://172.21.150.23:2003/osrdb
		jdbcscarcluster://172.21.150.28:2010/dbname
PetaBase	2.1,	jdbc:petabase://127.0.0.1:10000/testdb
	Petabase-G	jdbc:petabase3://172.21.150.69:5432;DatabaseName=gsgs
PostgreSQL		jdbc:postgresql://localhost:5432/dbname
SparkSQL		jdbc:hive2://172.0.0.1:10000/testdb
Sybase		jdbc:sybase:Tds:192.168.1.222:5000/testdb?charset=cp936
Teradata		jdbc:teradata://192.168.226.128/CLIENT_CHARSET=GBK
Timesten		jdbc:timesten:clientSN=test_db
TiDB		jdbc:mysql://192.168.1.223/testdb?useUnicode=true&characterEncoding=utf8
TiSpark		jdbc:hive2://127.0.0.1:10000/testdb
Transwarp 星环	Inceptor	jdbc:hive2://172.17.3.206:10000/testdb jdbc:inceptor://172.17.3.206:10000/testdb
UXDB 优炫		jdbc:uxdb://127.0.0.1:5432/hyjrx?currentSchema=public
Vertica		jdbc:vertica://172.21.10.220/VMart
XCloud		jdbc:xcloud172.16.3.46:1803/bonc_liyuji
CDH 6.3.2 + Hive 2.1.1-cdh6.3.2		jdbc:hive2://172.21.180.14:10000/default
HDP 3.1.4.0 + Hive 3.1.0		jdbc:hive2://172.21.185.21:10000/default
开源 Hive 2.3.7		jdbc:hive2://172.21.160.56:10000/default
clickhouse		jdbc:clickhouse://172.21.180.19:8123/dy
Oceanbase		jdbcceanbase://172.21.160.113:2881/test

截图202501101454073306.png (349.26 KB, 下载次数: )

下载附件

2025-1-10 14:54 上传