greatsql部署二进制启动报错
部署环境：centos7.9部署版本：8.0.32-25
解压到路径后，查看版本报错
报错：
# 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)
配置了服务，启动报错：
# 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: /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: /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: /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: /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: /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: /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: greatsql.service: main process exited, code=exited, status=1/FAILURE
Feb 07 15:07:30 localhost.localdomain systemd: Failed to start GreatSQL Server.
Feb 07 15:07:30 localhost.localdomain systemd: Unit greatsql.service entered failed state.
Feb 07 15:07:30 localhost.localdomain systemd: greatsql.service failed.
Hint: Some lines were ellipsized, use -l to show in full.
发了五六次都说敏感词，到底有啥敏感词？？？？？？
是不能发图片嘛？试了5、6次有图片都提示敏感词:dizzy: 查看配置好像是有的：
# 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
# 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
驭无殇1998 发表于 2024-2-7 16:59
查看配置好像是有的：
# 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 。
页:
[1]