GreatSQL茶话会——分享一下你的五一假期

GreatSQL社区

搜索

[已解决] GreatSQL-8.0.32-24 二进制包安装

614 5 2023-6-16 17:01
本帖最后由 mlovewt 于 2023-7-28 14:12 编辑

按照文档 3-quick-start/3-2-quick-start-with-tarball.md · 万里数据库/GreatSQL-Manual - Gitee.com ，下载GreatSQL-8.0.32-24-Linux-glibc2.17-x86_64.tar.xz 安装到Centos 7 中，由于习惯使用mysql.server 启动，安装完成后发现support-files 中该文件已经不存在，复制8.0.25 的mysql.server 到bin 中，执行mysql.server start

如下错误
  1. 20230616_16:02:37[manager@server57 mysql]$ cp ../mysql20230616/bin/mysql.server bin/
  2. 20230616_16:03:07[manager@server57 mysql]$ mysql.server start
  3. 20230616_16:03:07/usr/local/mysql/bin/my_print_defaults: /usr/local/ssl/lib/libcrypto.so: version `libcrypto.so.10' not found (required by /usr/local/mysql/bin/my_print_defaults)
  4. 20230616_16:03:07/usr/local/mysql/bin/mysql.server: line 259: cd: /usr/local/GreatSQL-8.0.25-16-Linux-glibc2.17-x86_64: No such file or directory
  5. 20230616_16:03:07Starting MySQL (Percona Server) ERROR! Couldn't find MySQL server (/usr/local/GreatSQL-8.0.25-16-Linux-glibc2.17-x86_64/bin/mysqld_safe)
复制代码
修改mysql.server
  1. basedir=/usr/local/mysql
  2. datadir=/home/manager/mysql_data
复制代码
继续
  1. [manager@server57 bin]$ mysql.server start
  2. /usr/local/mysql/bin/my_print_defaults: /usr/local/ssl/lib/libcrypto.so: version `libcrypto.so.10' not found (required by /usr/local/mysql/bin/my_print_defaults)
  3. Starting MySQL (Percona Server)./usr/local/mysql/bin/my_print_defaults: /usr/local/ssl/lib/libcrypto.so: version `libcrypto.so.10' not found (required by /usr/local/mysql/bin/my_print_defaults)
  4. /usr/local/mysql/bin/my_print_defaults: /usr/local/ssl/lib/libcrypto.so: version `libcrypto.so.10' not found (required by /usr/local/mysql/bin/my_print_defaults)
  5. . ERROR! The server quit without updating PID file (/home/manager/mysql_data/server57.pid).
复制代码
使用systemd 方式启动
  1. sed -i 's/GreatSQL-8.0.32-24-Linux-glibc2.17-x86_64/mysql/' mysqld_pre_systemd
复制代码

  2. [Unit]
  3. Description=GreatSQL Server
  4. Documentation=man:mysqld(8)
  5. Documentation=http://dev.mysql.com/doc/refman/en/using-systemd.html
  6. After=network.target
  7. After=syslog.target
  8. [Install]
  9. WantedBy=multi-user.target
  10. [Service]

  12. # some limits
  13. # file size
  14. LimitFSIZE=infinity
  15. # cpu time
  16. LimitCPU=infinity
  17. # virtual memory size
  18. LimitAS=infinity
  19. # open files
  20. LimitNOFILE=65535
  21. # processes/threads
  22. LimitNPROC=65535
  23. # locked memory
  24. LimitMEMLOCK=infinity
  25. # total threads (user+kernel)
  26. TasksMax=infinity
  27. TasksAccounting=false

  29. User=manager
  30. Group=manager
  31. #如果是GreatSQL 5.7版本，此处需要改成simple模式，否则可能服务启用异常
  32. #如果是GreatSQL 8.0版本则可以使用notify模式
  33. #Type=simple
  34. Type=notify
  35. TimeoutSec=0
  36. PermissionsStartOnly=true
  37. ExecStartPre=/usr/local/mysql/bin/mysqld_pre_systemd
  38. ExecStart=/usr/local/mysql/bin/mysqld $MYSQLD_OPTS
  39. EnvironmentFile=-/etc/sysconfig/mysql
  40. LimitNOFILE = 10000
  41. Restart=on-failure
  42. RestartPreventExitStatus=1
  43. Environment=MYSQLD_PARENT_PID=1
  44. PrivateTmp=false
复制代码
错误如下
  1. Jun 16 16:33:56 server57 mysqld_pre_systemd[30555]: /usr/local/mysql/bin/my_print_defaults: /usr/local/ssl/lib/libcrypto.so: version `libcrypto.so.10' not found (required by /usr/local/mysql/bin/my_print_defaults)
  2. Jun 16 16:33:56 server57 polkitd[1925]: Unregistered Authentication Agent for unix-process:30427:2974284038 (system bus name :1.117215, object path /org/freedesktop/PolicyKit1/AuthenticationAgent, locale en_US.UTF-8) (disconnected from bus)
  3. Jun 16 16:33:56 server57 mysqld_pre_systemd[30555]: /usr/local/mysql/bin/my_print_defaults: /usr/local/ssl/lib/libcrypto.so: version `libcrypto.so.10' not found (required by /usr/local/mysql/bin/my_print_defaults)
  4. Jun 16 16:33:56 server57 mysqld_pre_systemd[30555]: /usr/local/mysql/bin/my_print_defaults: /usr/local/ssl/lib/libcrypto.so: version `libcrypto.so.10' not found (required by /usr/local/mysql/bin/my_print_defaults)
  5. Jun 16 16:33:56 server57 mysqld_pre_systemd[30555]: /usr/local/mysql/bin/my_print_defaults: /usr/local/ssl/lib/libcrypto.so: version `libcrypto.so.10' not found (required by /usr/local/mysql/bin/my_print_defaults)
  6. Jun 16 16:33:56 server57 mysqld_pre_systemd[30555]: install: invalid user ‘mysql’
  7. Jun 16 16:33:56 server57 systemd[1]: greatsql.service: control process exited, code=exited status=1
  8. Jun 16 16:33:56 server57 systemd[1]: Failed to start GreatSQL Server.
  9. -- Subject: Unit greatsql.service has failed
复制代码
建立软连接后启动成功
  1. [root@server57 lib]# find / -name libcrypto.so.10
  2. /usr/lib64/libcrypto.so.10
  3. /usr/local/mysql/lib/libcrypto.so.10
  4. /usr/local/mysql/lib/private/libcrypto.so.10
  5. [root@server57 lib]# ll
  6. total 22456
  7. drwxr-xr-x 2 root root       39 Jul  8  2022 engines-1.1
  8. -rw-r--r-- 1 root root 11605090 Jul  8  2022 libcrypto.a
  9. lrwxrwxrwx 1 root root       16 Jul  8  2022 libcrypto.so -> libcrypto.so.1.1
  10. lrwxrwxrwx 1 root root       16 Jun 16 17:31 libcrypto.so.10 -> libcrypto.so.1.1
  11. -rwxr-xr-x 1 root root  6213512 Jul  8  2022 libcrypto.so.1.1
  12. -rw-r--r-- 1 root root  3484474 Jul  8  2022 libssl.a
  13. lrwxrwxrwx 1 root root       13 Jul  8  2022 libssl.so -> libssl.so.1.1
  14. -rwxr-xr-x 1 root root  1685408 Jul  8  2022 libssl.so.1.1
  15. drwxr-xr-x 2 root root       61 Jul  8  2022 pkgconfig
  16. [root@server57 lib]# rm -rf libcrypto.so
  17. [root@server57 lib]# ln -s /usr/local/mysql/lib/libcrypto.so.10 libcrypto.so
复制代码
我这环境是在8.0.25 上做原地升级，不知道统一个机器25 和32 为啥表现不一样？32 对openssl 版本有要求？


全部回复(5)
只看楼主
yejr 2023-6-17 21:34:05
几个建议：
1. 建议用systemd来管理GreatSQL服务，详情参考
https://greatsql.cn/docs/8032/us ... l-with-tarball.html

2. GreatSQL 8.0.32的编译参数和8.0.25确实不同，对操作系统的openssl依赖方式也不同
这时候需要手动加软链接，或者把GreatSQL的lib目录加到ldconfig可识别的路径里，例如修改 /etc/ld.so.conf ，加入一行：
/usr/local/GreatSQL-8.0.32-24-Linux-glibc2.17-x86_64/lib
回复 采纳

举报

mlovewt 2023-7-28 14:17:37
yejr 发表于 2023-6-17 21:34
几个建议：
1. 建议用systemd来管理GreatSQL服务，详情参考
https://greatsql.cn/docs/8032/user-manual/4- ...

本机升级openssl3 后如果 把greatsql里的lib 放到 /etc/ld.so.conf 中，上面的问题依然会存在，需要再启动greatsql时只加载greatsql二进制包中的lib,或者是能直接兼容。
回复 采纳

举报

mlovewt 2023-7-28 14:19:26
mlovewt 发表于 2023-7-28 14:17
本机升级openssl3 后如果 把greatsql里的lib 放到 /etc/ld.so.conf 中，上面的问题依然会存在，需要再启 ...

/etc/ld.so.conf 中内容
  1. include ld.so.conf.d/*.conf
  2. /usr/local/mysql/lib
  3. /usr/local/openssl/lib
复制代码

把 /usr/local/openssl/lib 去掉是可以启动的
回复 采纳

举报

mlovewt 2023-7-28 14:27:07
本帖最后由 mlovewt 于 2023-7-28 14:33 编辑
mlovewt 发表于 2023-7-28 14:19
/etc/ld.so.conf 中内容

把 /usr/local/openssl/lib 去掉是可以启动的

解决了
  1. cat >> /etc/sysconfig/mysql << EOF
  2. LD_PRELOAD=/usr/lib64/libjemalloc.so:/usr/local/mysql/lib/libcrypto.so.10:/usr/local/mysql/lib/libssl.so.10:/usr/local/mysql/lib/libcrypto.so
  3. THP_SETTING=never
  4. EOF
复制代码

初始化后启动时libjemalloc.so 后面追加上这三个就可以启动，初始化仍然出错

  2. Jul 28 14:30:57 docker-base mysqld_pre_systemd[12507]: /usr/local/mysql/bin/my_print_defaults: /usr/local/openssl/lib/libcrypto.so: version `libcrypto.so.10' not found (required by /usr/local/mysql/bin/my_print_defaults)
  3. Jul 28 14:30:57 docker-base mysqld_pre_systemd[12507]: /usr/local/mysql/bin/my_print_defaults: /usr/local/openssl/lib/libcrypto.so: version `OPENSSL_1.0.1_EC' not found (required by /usr/local/mysql/lib/libssl.so.10)
  4. Jul 28 14:30:57 docker-base mysqld_pre_systemd[12507]: /usr/local/mysql/bin/my_print_defaults: /usr/local/openssl/lib/libcrypto.so: version `libcrypto.so.10' not found (required by /usr/local/mysql/lib/libssl.so.10)
  5. Jul 28 14:30:57 docker-base mysqld_pre_systemd[12507]: /usr/local/mysql/bin/my_print_defaults: /usr/local/openssl/lib/libcrypto.so: version `libcrypto.so.10' not found (required by /usr/local/mysql/bin/my_print_defaults)
  6. Jul 28 14:30:57 docker-base mysqld_pre_systemd[12507]: /usr/local/mysql/bin/my_print_defaults: /usr/local/openssl/lib/libcrypto.so: version `OPENSSL_1.0.1_EC' not found (required by /usr/local/mysql/lib/libssl.so.10)
  7. Jul 28 14:30:57 docker-base mysqld_pre_systemd[12507]: /usr/local/mysql/bin/my_print_defaults: /usr/local/openssl/lib/libcrypto.so: version `libcrypto.so.10' not found (required by /usr/local/mysql/lib/libssl.so.10)
  8. Jul 28 14:30:57 docker-base mysqld_pre_systemd[12507]: /usr/local/mysql/bin/my_print_defaults: /usr/local/openssl/lib/libcrypto.so: version `libcrypto.so.10' not found (required by /usr/local/mysql/bin/my_print_defaults)
  9. Jul 28 14:30:57 docker-base mysqld_pre_systemd[12507]: /usr/local/mysql/bin/my_print_defaults: /usr/local/openssl/lib/libcrypto.so: version `OPENSSL_1.0.1_EC' not found (required by /usr/local/mysql/lib/libssl.so.10)
  10. Jul 28 14:30:57 docker-base mysqld_pre_systemd[12507]: /usr/local/mysql/bin/my_print_defaults: /usr/local/openssl/lib/libcrypto.so: version `libcrypto.so.10' not found (required by /usr/local/mysql/lib/libssl.so.10)
  11. Jul 28 14:30:57 docker-base mysqld_pre_systemd[12507]: /usr/local/mysql/bin/my_print_defaults: /usr/local/openssl/lib/libcrypto.so: version `libcrypto.so.10' not found (required by /usr/local/mysql/bin/my_print_defaults)
  12. Jul 28 14:30:57 docker-base mysqld_pre_systemd[12507]: /usr/local/mysql/bin/my_print_defaults: /usr/local/openssl/lib/libcrypto.so: version `OPENSSL_1.0.1_EC' not found (required by /usr/local/mysql/lib/libssl.so.10)
  13. Jul 28 14:30:57 docker-base mysqld_pre_systemd[12507]: /usr/local/mysql/bin/my_print_defaults: /usr/local/openssl/lib/libcrypto.so: version `libcrypto.so.10' not found (required by /usr/local/mysql/lib/libssl.so.10)
  14. Jul 28 14:30:57 docker-base systemd[1]: greatsql.service: main process exited, code=exited, status=1/FAILURE
  15. Jul 28 14:30:57 docker-base systemd[1]: Failed to start GreatSQL Server.
  16. -- Subject: Unit greatsql.service has failed
复制代码


回复 采纳

举报

yejr 2023-7-28 14:32:59
mlovewt 发表于 2023-7-28 14:19
/etc/ld.so.conf 中内容

把 /usr/local/openssl/lib 去掉是可以启动的

那就在ld.so.conf 里把 /usr/local/openssl/lib 去掉呗，为啥一定要加载呢
回复 采纳

举报

mlovewt

5

主题

0

博客

25

贡献

新手上路

Rank: 1

积分
41

助人为乐（铜）

发消息
互动与交流
社区活动
论坛问答
加入社区
贡献者指南
学习与应用
文章博客
文档资料
视频资料
常见问题
发现社区
社区准则
建议反馈
社区之星

合作电话：010-64087828

社区邮箱：greatsql@greatdb.com

社区公众号
社区小助手
QQ群
友情链接
万里数据库开源中国墨天轮开放原子开源基金会OpenEuler
©2022 GreatSQL All Rights Reserved. ( 京ICP备06057874号 )
GMT+8, 2024-5-19 05:19 , Processed in 0.018886 second(s), 16 queries , Redis On.
快速回复 返回顶部 返回列表