OGG-MYSQL 使用SSL报错OGG-00769 MySQL Login failed: . SQL error (2026). SSL connecti

原创

大大刺猬

发布于 2022-06-23 10:44:44

9790

发布于 2022-06-23 10:44:44

文章被收录于专栏：大大刺猬大大刺猬

环境

操作系统 centos6.5

openssl版本: 1.0.1e

ogg版本 19.1

MYSQL版本: 5.7.35

报错

配置抽取进程的时候,启动报错如下

2022-06-23 05:54:53  WARNING OGG-00769  MySQL Login failed: . SQL error (2026). SSL connection error: error:100AE081:elliptic curve routines:EC_GROUP_new_by_curve_name:unknown group.

Source Context :
  SourceModule            : [ggdb.mysql.dbx]
  SourceID                : [../gglib/ggdbmysql/dbxmysql.c]
  SourceMethod            : [open_data_source]
  SourceLine              : [1130]
  ThreadBacktrace         : [13] elements
                          : [/root/ogg/libgglog.so(CMessageContext::AddThreadContext())]
                          : [/root/ogg/libgglog.so(CMessageFactory::CreateMessage(CSourceContext*, unsigned int, ...))]
                          : [/root/ogg/libgglog.so(_MSG_String_CatalogName_LoginName_Int32(CSourceContext*, int, char const*, ggs::gglib::ggapp::CDBObjName<(DBObjType)8> const&, ggs::gglib::ggapp::CDBObjName<(DBObjType)11> const&, int, CMessageFactory::MessageDisposition))]
                          : [/root/ogg/extract()]
                          : [/root/ogg/extract(gl_odbc_param(char const*, char const*, char (&) [2048]))]
                          : [/root/ogg/extract(get_infile_params(ggs::gglib::ggapp::ReplicationContextParams&, ggs::gglib::ggdatasource::DataSourceParams&, ggs::gglib::ggdatatarget::DataTargetParams&, ggs::gglib::ggmetadata::MetadataContext&))]
                          : [/root/ogg/extract()]
                          : [/root/ogg/extract(ggs::gglib::MultiThreading::MainThread::ExecMain())]
                          : [/root/ogg/extract(ggs::gglib::MultiThreading::Thread::RunThread(ggs::gglib::MultiThreading::Thread::ThreadArgs*))]
                          : [/root/ogg/extract(ggs::gglib::MultiThreading::MainThread::Run(int, char**))]
                          : [/root/ogg/extract(main)]
                          : [/lib64/libc.so.6(__libc_start_main)]
                          : [/root/ogg/extract()]

2022-06-23 05:54:53  ERROR   OGG-00770  Failed to connect to MySQL database engine for HOST 127.0.0.1, DATABASE db1, USER root, PORT 3306.

2022-06-23 05:54:53  ERROR   OGG-01668  PROCESS ABENDING.

原因和解决办法

openssl版本低了, 升级即可, 当然也可以关闭ssl

升级openssl可以参考如下

yum install zlib-devel gcc 
wget wget https://www.openssl.org/source/old/1.0.2/openssl-1.0.2u.tar.gz" && wget https://www.openssl.org/source/old/1.0.2/openssl-1.0.2u.tar.gz
tar -xvf openssl-1.0.2u.tar.gz
cd openssl-1.0.2u
./config shared zlib  --prefix=/usr/local/openssl
make -j 8
make install 
ln -s /usr/local/openssl/lib/libssl.so.1.0.0 /usr/lib64/libssl.so.10
ln -s /usr/local/openssl/lib/libcrypto.so.1.0.0 /usr/lib64/libcrypto.so.10

参考文档

https://forums.centos.org/viewtopic.php?f=14&t=43803 https://docs.oracle.com/en/middleware/goldengate/core/21.1/error-messages/ogg-00001-ogg-30075.html https://github.com/ddcw/ddcw/blob/master/install_shells/OpensslInstall.sh https://docs.oracle.com/en/middleware/goldengate/core/19.1/gghdb/preparing-and-configuring-system-oracle-goldengate.html

原创声明：本文系作者授权腾讯云开发者社区发表，未经许可，不得转载。

如有侵权，请联系 cloudcommunity@tencent.com 删除。

云数据库 SQL Server

原创声明：本文系作者授权腾讯云开发者社区发表，未经许可，不得转载。

如有侵权，请联系 cloudcommunity@tencent.com 删除。

登录后参与评论

0 条评论

热度