http_auth_backend.so: cannot open

yejr 发表于 2023-5-20 19:28
router的版本是什么，先执行ldd看看动态依赖关系
我看了下GreatSQL二进制包，是包含这个动态库文件的

还是不行， router版本是 8.0.25 我把http_auth_backend 库放到了/usr/lib64都不行，还是提示一样的错误

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
加了这个，不行，

yejr 发表于 2023-5-20 21:28
你的mysqlrouter是哪里下载的？先执行ldd看依赖关系。在我的环境下，无论是GreatSQL自带的mysqlrouter还 ...

mysqlrouter我是官方下载的，

yejr 发表于 2023-5-20 21:28
你的mysqlrouter是哪里下载的？先执行ldd看依赖关系。在我的环境下，无论是GreatSQL自带的mysqlrouter还 ...

Mysqlrouter是官方下载，查看依赖关系

[root@mglinux01 plugin]# 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

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

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

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

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

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

[root@mglinux03 ~]# which mysqlrouter
/usr/local/GreatSQL-8.0.25-17-Linux-glibc2.17-x86_64/bin/mysqlrouter

[root@mglinux03 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)
[root@mglinux03 mysqlrouter]#