为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】:DM8
【操作系统】:CentOS7
【CPU】:AMD
【问题描述】*:DM8使用DMHS工具同步MYSQL8数据,源端copy操作导致报错:Can't open lib 'MySQL ODBC Driver'
我的ODBC可以正常驱动
[root@localhost1 bin]# isql -v mysql
+---------------------------------------+
| Connected! |
| |
| sql-statement |
| help [tablename] |
| quit |
| |
+---------------------------------------+
SQL>
配置如下:
[root@localhost1 etc]# cat odbc.ini
[mysql]
Driver=MySQL ODBC Driver
DATABASE=mysql
DESCRIPTION=MySQL ODBC Driver
SERVER=172.20.10.201
PORT=3306
UID=root
PASSWORD=abc123
[root@localhost1 etc]# cat odbcinst.ini
[MySQL ODBC Driver]
DRIVER=/usr/local/mysqlODBC/lib/libmyodbc8w.so
UsageCount=1
odbcinst -j如下:
[root@localhost1 bin]# odbcinst -j
unixODBC 2.3.1
DRIVERS............: /usr/local/unixODBC/etc/odbcinst.ini
SYSTEM DATA SOURCES: /usr/local/unixODBC/etc/odbc.ini
FILE DATA SOURCES..: /usr/local/unixODBC/etc/ODBCDataSources
USER DATA SOURCES..: /root/.odbc.ini
SQLULEN Size.......: 8
SQLLEN Size........: 8
SQLSETPOSIROW Size.: 8
之前遇到过同样的问题,重启解决了,这次重启依旧报错
环境变量如下:
[root@localhost1 bin]# echo $LD_LIBRARY_PATH
/opt/dmhs/bin:/opt/dmhs/odbc/lib:/home/dmdba/dmhs/bin:/opt/dmhs/bin:/opt/dmhs/bin:/opt/dmhs/bin:/opt/dmhs/odbc/lib:/usr/local/unixODBC/lib:/usr/local/mysqlODBC/lib:/usr/local/mysqlODBC/lib:/opt/dmhs/bin:/opt/dmhs/bin:/opt/dmhs/bin:/opt/dmhs/bin:/opt/dmhs/bin:/opt/dmhs/bin:/opt/dmhs/bin:/opt/dmhs/bin
重新设置一下环境变量,重启一次试试看还有么有这个问题,看是无法找到依赖无法连接Mysql库