http_auth_backend.so: cannot open
# mysqlrouter -c /usr/local/GreatSQL-8.0.25-17-Linux-glibc2.17-x86_64/mysqlrouter.confError: Loading plugin for config-section '' failed: /usr/local/GreatSQL-8.0.25-17-Linux-glibc2.17-x86_64/bin/..//usr/local/GreatSQL-8.0.25-17-Linux-glibc2.17-x86_64/lib/mysqlrouter/plugin/http_auth_backend.so: cannot open shared object file: No such file or directory
router的版本是什么，先执行ldd看看动态依赖关系
我看了下GreatSQL二进制包，是包含这个动态库文件的
$ tar vtf GreatSQL-8.0.25-17-Linux-glibc2.28-x86_64.tar.xz | grep http_auth_backend
-rwxr-xr-x root/root 962496 2023-03-11 21:26 GreatSQL-8.0.25-17-Linux-glibc2.28-x86_64/lib/mysqlrouter/plugin/http_auth_backend.so
-rwxr-xr-x root/root 1854720 2023-03-11 21:26 GreatSQL-8.0.25-17-Linux-glibc2.28-x86_64/lib/mysqlrouter/private/libmysqlrouter_http_auth_backend.so.1
可能需要你把这个路径加到 /etc/ld.so.conf 中，例如
$ cat /etc/ld.so.conf
include ld.so.conf.d/*.conf
/usr/local/GreatSQL-8.0.25-17-Linux-glibc2.28-x86_64/lib/
/usr/local/lib64 yejr 发表于 2023-5-20 19:28
router的版本是什么，先执行ldd看看动态依赖关系
我看了下GreatSQL二进制包，是包含这个动态库文件的
还是不行， router版本是 8.0.25 我把http_auth_backend 库放到了/usr/lib64都不行，还是提示一样的错误 qinxm 发表于 2023-5-20 20:45
还是不行， router版本是 8.0.25 我把http_auth_backend 库放到了/usr/lib64都不行，还是提示一样的错误 ...
再增加一个目录，例如：
$ cat /etc/ld.so.conf
include ld.so.conf.d/*.conf
/usr/local/GreatSQL-8.0.25-17-Linux-glibc2.28-x86_64/lib
/usr/local/GreatSQL-8.0.25-17-Linux-glibc2.28-x86_64/lib/mysqlrouter/private
/usr/local/lib64
之后执行
ldconfig && ldconfig -p | grep auth
ldconfig: /usr/local/lib64/libcgicc.so.3 is not a symbolic link
libvgauth.so.0 (libc6,x86-64) => /lib64/libvgauth.so.0
libpegauthentication.so.1 (libc6,x86-64) => /lib64/libpegauthentication.so.1
libmysqlrouter_http_auth_realm.so.1 (libc6,x86-64) => /usr/local/GreatSQL-8.0.25-17-Linux-glibc2.28-x86_64/lib/mysqlrouter/private/libmysqlrouter_http_auth_realm.so.1
libmysqlrouter_http_auth_backend.so.1 (libc6,x86-64) => /usr/local/GreatSQL-8.0.25-17-Linux-glibc2.28-x86_64/lib/mysqlrouter/private/libmysqlrouter_http_auth_backend.so.1
libauthselect.so.3 (libc6,x86-64) => /lib64/libauthselect.so.3
这样应该就OK了 本帖最后由 qinxm 于 2023-5-20 21:18 编辑
file:///C:/Users/qinxi/Desktop/333.png yejr 发表于 2023-5-20 20:55
再增加一个目录，例如：
明明示示缺少plugin目录的auth_back库文件，不是你给的priavate目录，priavate目录下的auth库能加载，但是plugin目录的auth库文件无法加载，说明库文件存在问题 qinxm 发表于 2023-5-20 21:19
明明示示缺少plugin目录的auth_back库文件，不是你给的priavate目录，priavate目录下的auth库能加载，但 ...
/usr/local/GreatSQL-8.0.25-17-Linux-glibc2.17-x86_64/lib/mysqlrouter/plugin
加了这个，不行， qinxm 发表于 2023-5-20 20:45
还是不行， router版本是 8.0.25 我把http_auth_backend 库放到了/usr/lib64都不行，还是提示一样的错误 ...
你的mysqlrouter是哪里下载的？先执行ldd看依赖关系。在我的环境下，无论是GreatSQL自带的mysqlrouter还是MySQL官网下载的，都可以正常运行 yejr 发表于 2023-5-20 21:28
你的mysqlrouter是哪里下载的？先执行ldd看依赖关系。在我的环境下，无论是GreatSQL自带的mysqlrouter还 ...
mysqlrouter我是官方下载的， yejr 发表于 2023-5-20 21:28
你的mysqlrouter是哪里下载的？先执行ldd看依赖关系。在我的环境下，无论是GreatSQL自带的mysqlrouter还 ...
Mysqlrouter是官方下载，查看依赖关系
# ldd /usr/local/GreatSQL-8.0.25-17-Linux-glibc2.17-x86_64/bin/mysqlrouter
linux-vdso.so.1 =>(0x00007ffc32d97000)
libpthread.so.0 => /lib64/libpthread.so.0 (0x00007f81f4a6b000)
libmysqlrouter.so.1 => /usr/local/GreatSQL-8.0.25-17-Linux-glibc2.17-x86_64/bin/../lib/mysqlrouter/private/libmysqlrouter.so.1 (0x00007f81f4270000)
libdl.so.2 => /lib64/libdl.so.2 (0x00007f81f406c000)
libresolv.so.2 => /lib64/libresolv.so.2 (0x00007f81f3e52000)
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 (0x00007f81f4e8a000)
libmysqlharness.so.1 => /usr/local/GreatSQL-8.0.25-17-Linux-glibc2.17-x86_64/bin/../lib/mysqlrouter/private/libmysqlharness.so.1 (0x00007f81f36e6000)
librt.so.1 => /lib64/librt.so.1 (0x00007f81f34de000)
libcrypto.so.10 => /usr/local/GreatSQL-8.0.25-17-Linux-glibc2.17-x86_64/bin/../lib/private/libcrypto.so.10 (0x00007f81f305d000)
libssl.so.10 => /usr/local/GreatSQL-8.0.25-17-Linux-glibc2.17-x86_64/bin/../lib/private/libssl.so.10 (0x00007f81f2dd5000)
libmysqlharness_stdx.so.1 => /usr/local/GreatSQL-8.0.25-17-Linux-glibc2.17-x86_64/bin/../lib/mysqlrouter/private/libmysqlharness_stdx.so.1 (0x00007f81f4e6f000)
libstdc++.so.6 => /lib64/libstdc++.so.6 (0x00007f81f2acd000)
libm.so.6 => /lib64/libm.so.6 (0x00007f81f27cb000)
libgcc_s.so.1 => /lib64/libgcc_s.so.1 (0x00007f81f25b5000)
libc.so.6 => /lib64/libc.so.6 (0x00007f81f21e7000)
/lib64/ld-linux-x86-64.so.2 (0x00007f81f4c87000)
libz.so.1 => /lib64/libz.so.1 (0x00007f81f1fd1000)
libgssapi_krb5.so => /usr/local/GreatSQL-8.0.25-17-Linux-glibc2.17-x86_64/bin/../lib/private/libgssapi_krb5.so (0x00007f81f1d75000)
libkrb5.so => /usr/local/GreatSQL-8.0.25-17-Linux-glibc2.17-x86_64/bin/../lib/private/libkrb5.so (0x00007f81f1a76000)
libcom_err.so.2 => /lib64/libcom_err.so.2 (0x
页:
[1]
2