GreatSQL社区

搜索

[已解决] greatsql部署二进制启动报错

298 3 2024-2-7 16:57
部署环境:centos7.9
部署版本:8.0.32-25
解压到路径后,查看版本报错
报错:

[root@localhost lib]# mysql -v
mysql: /usr/local/openssl/lib/libcrypto.so: version `libcrypto.so.10' not found (required by mysql)
mysql: /usr/local/openssl/lib/libssl.so: version `libssl.so.10' not found (required by mysql)


配置了服务,启动报错:


[root@localhost tmp]# systemctl status greatsql.service
● greatsql.service - GreatSQL Server
   Loaded: loaded (/etc/systemd/system/greatsql.service; disabled; vendor preset: disabled)
   Active: failed (Result: exit-code) since Wed 2024-02-07 15:07:30 CST; 16min ago
     Docs: man:mysqld(8)
           http://dev.mysql.com/doc/refman/en/using-systemd.html
  Process: 28120 ExecStart=/usr/local/greatsql/bin/mysqld $MYSQLD_OPTS (code=exited, status=1/FAILURE)
  Process: 28080 ExecStartPre=/usr/local/greatsql/bin/mysqld_pre_systemd (code=exited, status=0/SUCCESS)
Main PID: 28120 (code=exited, status=1/FAILURE)

Feb 07 15:07:30 localhost.localdomain mysqld_pre_systemd[28080]: /usr/local/GreatSQL-8.0.32-25-Linux-glibc2.17-x86_64/bin/my_print_defaults: /usr/local/openssl/lib/libcrypto.so: version `libcrypto.so.10' not found ...rint_defaults)
Feb 07 15:07:30 localhost.localdomain mysqld_pre_systemd[28080]: /usr/local/GreatSQL-8.0.32-25-Linux-glibc2.17-x86_64/bin/my_print_defaults: /usr/local/openssl/lib/libcrypto.so: version `libcrypto.so.10' not found ...rint_defaults)
Feb 07 15:07:30 localhost.localdomain mysqld_pre_systemd[28080]: /usr/local/GreatSQL-8.0.32-25-Linux-glibc2.17-x86_64/bin/my_print_defaults: /usr/local/openssl/lib/libcrypto.so: version `libcrypto.so.10' not found ...rint_defaults)
Feb 07 15:07:30 localhost.localdomain mysqld_pre_systemd[28080]: /usr/local/GreatSQL-8.0.32-25-Linux-glibc2.17-x86_64/bin/mysqld: /usr/local/openssl/lib/libcrypto.so: version `OPENSSL_1.0.1_EC' not found (required .../libssl.so.10)
Feb 07 15:07:30 localhost.localdomain mysqld_pre_systemd[28080]: /usr/local/GreatSQL-8.0.32-25-Linux-glibc2.17-x86_64/bin/mysqld: /usr/local/openssl/lib/libcrypto.so: version `libcrypto.so.10' not found (required b.../libssl.so.10)
Feb 07 15:07:30 localhost.localdomain mysqld[28120]: /usr/local/greatsql/bin/mysqld: /usr/local/openssl/lib/libcrypto.so: version `OPENSSL_1.0.1_EC' not found (required by /usr/local/GreatSQL-8.0.32-25-Linux-glibc...e/libssl.so.10)
Feb 07 15:07:30 localhost.localdomain systemd[1]: greatsql.service: main process exited, code=exited, status=1/FAILURE
Feb 07 15:07:30 localhost.localdomain systemd[1]: Failed to start GreatSQL Server.
Feb 07 15:07:30 localhost.localdomain systemd[1]: Unit greatsql.service entered failed state.
Feb 07 15:07:30 localhost.localdomain systemd[1]: greatsql.service failed.
Hint: Some lines were ellipsized, use -l to show in full.



发了五六次都说敏感词,到底有啥敏感词??????
全部回复(3)
驭无殇1998 2024-2-7 16:58:22
是不能发图片嘛?试了5、6次有图片都提示敏感词
驭无殇1998 2024-2-7 16:59:10
查看配置好像是有的:
[root@localhost lib]# ldconfig -p | grep libcrypto
        libcrypto.so.10 (libc6,x86-64) => /lib64/libcrypto.so.10
        libcrypto.so.1.1 (libc6,x86-64) => /usr/local/openssl/lib/libcrypto.so.1.1
        libcrypto.so (libc6,x86-64) => /usr/local/openssl/lib/libcrypto.so
        libcrypto.so (libc6,x86-64) => /lib64/libcrypto.so

已安装openssl
[root@localhost lib]# rpm -qa|grep openssl
openssl-libs-1.0.2k-19.el7.x86_64
openssl-1.0.2k-19.el7.x86_64
openssl-devel-1.0.2k-19.el7.x86_64
yejr 2024-2-10 22:29:15
驭无殇1998 发表于 2024-2-7 16:59
查看配置好像是有的:
[root@localhost lib]# ldconfig -p | grep libcrypto
        libcrypto.so.10 (libc6,x86- ...

正常的话,GreatSQL依赖的libcrypto.so库文件已经静态编译包含了,类似下面这样
```
$ pwd
/usr/local/GreatSQL-8.0.32-25-Linux-glibc2.28-x86_64

$ ldd bin/mysqld | grep -i libcr
        libcrypto.so => /usr/local/GreatSQL-8.0.32-25-Linux-glibc2.28-x86_64/bin/../lib/private/libcrypto.so (0x00007fe697d2c000)
```

怀疑是您的环境中设置了 LD_LIBRARY / LD_LIBRARY_PATH ,其中包含了 /usr/local/openssl/lib,因此优先加载了 /usr/local/openssl/lib/libcrypto.so.1.1,导致依赖失败。

这种情况下,需要在GreatSQL启动前调整 LD_LIBRARY 设置,使其不会优先加载 /usr/local/openssl/lib 。
驭无殇1998

14

主题

0

博客

90

贡献

注册会员

Rank: 2

积分
151

助人为乐(铜)勤学好问(铜)

合作电话:010-64087828

社区邮箱:greatsql@greatdb.com

社区公众号
社区小助手
QQ群
GMT+8, 2024-5-17 13:02 , Processed in 0.017165 second(s), 14 queries , Redis On.
快速回复 返回顶部 返回列表