yejr 发表于 2023-5-20 22:07:04

qinxm 发表于 2023-5-20 22:02
Mysqlrouter是官方下载,查看依赖关系

# ldd /usr/local/GreatSQL-8.0.25-17-Li ...

你这里所指的官方不是MySQL官方吗,为啥ldd查看的是GreatSQL目录下的mysqlrouter?
只看这个ldd结果的话,并不需要用到 http_auth_backend.so 动态库。
本贴最开始执行的 mysqlrouter 是什么路径下的,执行 which mysqlrouter 查看,然后对这个路径下的mysqlrouter 执行 ldd 查看动态库依赖关系。

qinxm 发表于 2023-5-21 07:47:00

yejr 发表于 2023-5-20 22:07
你这里所指的官方不是MySQL官方吗,为啥ldd查看的是GreatSQL目录下的mysqlrouter?
只看这个ldd结果的话 ...

我在greatsql服务器上安装myrouter就有这个情况,在新的linux服务器上正常

qinxm 发表于 2023-5-21 07:52:28

yejr 发表于 2023-5-20 22:07
你这里所指的官方不是MySQL官方吗,为啥ldd查看的是GreatSQL目录下的mysqlrouter?
只看这个ldd结果的话 ...

我不带路径参数,myrouter自动安装到 /usr/local/greatsql,真奇怪

yejr 发表于 2023-5-21 09:46:22

qinxm 发表于 2023-5-21 07:52
我不带路径参数,myrouter自动安装到 /usr/local/greatsql,真奇怪

请认真逐个回复以下两个问题
问题1:你这里所指的官方不是MySQL官方吗,为啥ldd查看的是GreatSQL目录下的mysqlrouter?

问题2:本贴最开始执行的 mysqlrouter 是什么路径下的,执行 which mysqlrouter 查看,然后对这个路径下的mysqlrouter 执行 ldd 查看动态库依赖关系。

qinxm 发表于 2023-5-21 09:47:26

yejr 发表于 2023-5-20 22:07
你这里所指的官方不是MySQL官方吗,为啥ldd查看的是GreatSQL目录下的mysqlrouter?
只看这个ldd结果的话 ...

# which mysqlrouter
/usr/local/GreatSQL-8.0.25-17-Linux-glibc2.17-x86_64/bin/mysqlrouter

# ldd/usr/local/GreatSQL-8.0.25-17-Linux-glibc2.17-x86_64/bin/mysqlrouter
      linux-vdso.so.1 =>(0x00007fff4103d000)
      libpthread.so.0 => /lib64/libpthread.so.0 (0x00007fc470c2a000)
      libmysqlrouter.so.1 => /usr/local/GreatSQL-8.0.25-17-Linux-glibc2.17-x86_64/bin/../lib/mysqlrouter/private/libmysqlrouter.so.1 (0x00007fc47042f000)
      libdl.so.2 => /lib64/libdl.so.2 (0x00007fc47022b000)
      libresolv.so.2 => /lib64/libresolv.so.2 (0x00007fc470011000)
      libmysqlrouter_io_component.so.1 => /usr/local/GreatSQL-8.0.25-17-Linux-glibc2.17-x86_64/bin/../lib/mysqlrouter/private/libmysqlrouter_io_component.so.1 (0x00007fc471049000)
      libmysqlharness.so.1 => /usr/local/GreatSQL-8.0.25-17-Linux-glibc2.17-x86_64/bin/../lib/mysqlrouter/private/libmysqlharness.so.1 (0x00007fc46f8a5000)
      librt.so.1 => /lib64/librt.so.1 (0x00007fc46f69d000)
      libcrypto.so.10 => /usr/local/GreatSQL-8.0.25-17-Linux-glibc2.17-x86_64/bin/../lib/private/libcrypto.so.10 (0x00007fc46f21c000)
      libssl.so.10 => /usr/local/GreatSQL-8.0.25-17-Linux-glibc2.17-x86_64/bin/../lib/private/libssl.so.10 (0x00007fc46ef94000)
      libmysqlharness_stdx.so.1 => /usr/local/GreatSQL-8.0.25-17-Linux-glibc2.17-x86_64/bin/../lib/mysqlrouter/private/libmysqlharness_stdx.so.1 (0x00007fc47102e000)
      libstdc++.so.6 => /lib64/libstdc++.so.6 (0x00007fc46ec8c000)
      libm.so.6 => /lib64/libm.so.6 (0x00007fc46e98a000)
      libgcc_s.so.1 => /lib64/libgcc_s.so.1 (0x00007fc46e774000)
      libc.so.6 => /lib64/libc.so.6 (0x00007fc46e3a6000)
      /lib64/ld-linux-x86-64.so.2 (0x00007fc470e46000)
      libz.so.1 => /lib64/libz.so.1 (0x00007fc46e190000)
      libgssapi_krb5.so => /usr/local/GreatSQL-8.0.25-17-Linux-glibc2.17-x86_64/bin/../lib/private/libgssapi_krb5.so (0x00007fc46df34000)
      libkrb5.so => /usr/local/GreatSQL-8.0.25-17-Linux-glibc2.17-x86_64/bin/../lib/private/libkrb5.so (0x00007fc46dc35000)
      libcom_err.so.2 => /lib64/libcom_err.so.2 (0x00007fc46da31000)
      libk5crypto.so => /usr/local/GreatSQL-8.0.25-17-Linux-glibc2.17-x86_64/bin/../lib/private/libk5crypto.so (0x00007fc46d7fb000)
      libkrb5support.so => /usr/local/GreatSQL-8.0.25-17-Linux-glibc2.17-x86_64/bin/../lib/private/libkrb5support.so (0x00007fc46d5e9000)
      libkeyutils.so.1 => /lib64/libkeyutils.so.1 (0x00007fc46d3e5000)
      libselinux.so.1 => /lib64/libselinux.so.1 (0x00007fc46d1be000)
      libpcre.so.1 => /lib64/libpcre.so.1 (0x00007fc46cf5c000)
#

qinxm 发表于 2023-5-21 09:50:49

yejr 发表于 2023-5-21 09:46
请认真逐个回复以下两个问题
问题1:你这里所指的官方不是MySQL官方吗,为啥ldd查看的是GreatSQL目录下的 ...

# which mysqlrouter
/usr/local/GreatSQL-8.0.25-17-Linux-glibc2.17-x86_64/bin/mysqlrouter


# ldd/usr/local/GreatSQL-8.0.25-17-Linux-glibc2.17-x86_64/bin/mysqlrouter
      linux-vdso.so.1 =>(0x00007ffe99de9000)
      libpthread.so.0 => /lib64/libpthread.so.0 (0x00007fc8c5ead000)
      libmysqlrouter.so.1 => /usr/local/GreatSQL-8.0.25-17-Linux-glibc2.17-x86_64/bin/../lib/mysqlrouter/private/libmysqlrouter.so.1 (0x00007fc8c56b2000)
      libdl.so.2 => /lib64/libdl.so.2 (0x00007fc8c54ae000)
      libresolv.so.2 => /lib64/libresolv.so.2 (0x00007fc8c5294000)
      libmysqlrouter_io_component.so.1 => /usr/local/GreatSQL-8.0.25-17-Linux-glibc2.17-x86_64/bin/../lib/mysqlrouter/private/libmysqlrouter_io_component.so.1 (0x00007fc8c62cc000)
      libmysqlharness.so.1 => /usr/local/GreatSQL-8.0.25-17-Linux-glibc2.17-x86_64/bin/../lib/mysqlrouter/private/libmysqlharness.so.1 (0x00007fc8c4b28000)
      librt.so.1 => /lib64/librt.so.1 (0x00007fc8c4920000)
      libcrypto.so.10 => /usr/local/GreatSQL-8.0.25-17-Linux-glibc2.17-x86_64/bin/../lib/private/libcrypto.so.10 (0x00007fc8c449f000)
      libssl.so.10 => /usr/local/GreatSQL-8.0.25-17-Linux-glibc2.17-x86_64/bin/../lib/private/libssl.so.10 (0x00007fc8c4217000)
      libmysqlharness_stdx.so.1 => /usr/local/GreatSQL-8.0.25-17-Linux-glibc2.17-x86_64/bin/../lib/mysqlrouter/private/libmysqlharness_stdx.so.1 (0x00007fc8c62b1000)
      libstdc++.so.6 => /lib64/libstdc++.so.6 (0x00007fc8c3f0f000)
      libm.so.6 => /lib64/libm.so.6 (0x00007fc8c3c0d000)
      libgcc_s.so.1 => /lib64/libgcc_s.so.1 (0x00007fc8c39f7000)
      libc.so.6 => /lib64/libc.so.6 (0x00007fc8c3629000)
      /lib64/ld-linux-x86-64.so.2 (0x00007fc8c60c9000)
      libz.so.1 => /lib64/libz.so.1 (0x00007fc8c3413000)
      libgssapi_krb5.so => /usr/local/GreatSQL-8.0.25-17-Linux-glibc2.17-x86_64/bin/../lib/private/libgssapi_krb5.so (0x00007fc8c31b7000)
      libkrb5.so => /usr/local/GreatSQL-8.0.25-17-Linux-glibc2.17-x86_64/bin/../lib/private/libkrb5.so (0x00007fc8c2eb8000)
      libcom_err.so.2 => /lib64/libcom_err.so.2 (0x00007fc8c2cb4000)
      libk5crypto.so => /usr/local/GreatSQL-8.0.25-17-Linux-glibc2.17-x86_64/bin/../lib/private/libk5crypto.so (0x00007fc8c2a7e000)
      libkrb5support.so => /usr/local/GreatSQL-8.0.25-17-Linux-glibc2.17-x86_64/bin/../lib/private/libkrb5support.so (0x00007fc8c286c000)
      libkeyutils.so.1 => /lib64/libkeyutils.so.1 (0x00007fc8c2668000)
      libselinux.so.1 => /lib64/libselinux.so.1 (0x00007fc8c2441000)
      libpcre.so.1 => /lib64/libpcre.so.1 (0x00007fc8c21df000)

yejr 发表于 2023-5-21 09:51:00

qinxm 发表于 2023-5-21 09:47
# which mysqlrouter
/usr/local/GreatSQL-8.0.25-17-Linux-glibc2.17-x86_64/bin/mys ...

从这个结果你也能看到了,GreatSQL目录下的mysqlrouter用ldd查看的话,并不需要用到 http_auth_backend.so 动态库。
你在运行mysqlrouter时却会报告这个错误,的确不好理解,请用strace之类的工具再跟踪看看。

qinxm 发表于 2023-5-21 10:40:19

yejr 发表于 2023-5-21 09:51
从这个结果你也能看到了,GreatSQL目录下的mysqlrouter用ldd查看的话,并不需要用到 http_auth_backend.s ...

mysqlroutergreatsql官方带了

qinxm 发表于 2023-5-21 11:00:13

yejr 发表于 2023-5-21 09:51
从这个结果你也能看到了,GreatSQL目录下的mysqlrouter用ldd查看的话,并不需要用到 http_auth_backend.s ...

找到解决办法了:请删除GreatSQL中的mysqlrouter,否则会受到干扰
rm -fr /usr/local/GreatSQL-8.0.25-17-Linux-glibc2.17-x86_64/bin/mysqlrouter
页: 1 [2]
查看完整版本: http_auth_backend.so: cannot open