search

LLNL / lmt

Lustre Monitoring Tools
GNU General Public License v2.0
69 stars 23 forks source link

/usr/lib64/mysql/plugin/caching_sha2_password.so: cannot open shared object file: No such file or directory #69

Closed ofaaland closed 6 days ago

ofaaland commented 6 days ago

User Alvaro reported that after building and installing LMT, and trying to initialize the database, he got this error:

sudo /usr/sbin/lmtsh -f temp
DBI connect('host=;port=0','lwatchadmin',...) failed: Authentication plugin 'caching_sha2_password' cannot be loaded: /usr/lib64/mysql/plugin/caching_sha2_password.so: cannot open shared object file: No such file or directory at /usr/share/lmt/LMT.pm line 292.

and

sudo service cerebrod status -l
● cerebrod.service - LSB: cerebrod startup script
   Loaded: loaded (/etc/rc.d/init.d/cerebrod; bad; vendor preset: disabled)
   Active: active (running) since Wed 2024-10-30 22:02:41 UTC; 2min 1s ago
     Docs: man:systemd-sysv-generator(8)
  Process: 181861 ExecStop=/etc/rc.d/init.d/cerebrod stop (code=exited, status=0/SUCCESS)
  Process: 181878 ExecStart=/etc/rc.d/init.d/cerebrod start (code=exited, status=0/SUCCESS)
    Tasks: 6
   CGroup: /system.slice/cerebrod.service
           └─181887 /usr/sbin/cerebrod

Oct 30 22:02:41 lustre-mount-client-dev-renewed.novalocal systemd[1]: Started LSB: cerebrod startup script.
Oct 30 22:02:42 lustre-mount-client-dev-renewed.novalocal /usr/sbin/cerebrod[181887]: lmt_mysql: failed to connect to database
ofaaland commented 6 days ago

Alvaro also reported this while troubleshooting an earlier issue, https://github.com/LLNL/lmt/issues/67:

strings /usr/sbin/lmtinit | grep ERROR
ERROR: unexpected arguments, have %d expected %d
ERROR: one of these must be enabled: -a -d -l -x -o (%d,%d,%d,%d,%d)
ofaaland commented 6 days ago

When I use the strings utility on lmtinit, I have mariadb related strings found, like this:

$strings utils/lmtinit | grep ERROR
ERROR: unexpected arguments, have %d expected %d
ERROR: one of these must be enabled: -a -d -l -x -o (%d,%d,%d,%d,%d)
MARIADB_CONNECTION_ERROR_ID
MARIADB_CONNECTION_ERROR
MARIADB_CLIENT_ERRORS

I suspect that Alvaro's build may not have had mariadb enabled in ./configure

ofaaland commented 6 days ago

@alvaromartin990 I believe that mysql/mariadb may not have been enabled (or were not detected) when you ran ./configure.

What OS and version are you building LMT on? What arguments, if any, did you give when running ./configure ? What output do you get from these commands?

# from within your build directory
grep -e MYSQL -e MARIA config.log
# on the system you build on, and also the system you have installed lmt on
rpm -qa | grep -i -e mariadb -e mysql | grep connect | sort

thanks!

ofaaland commented 6 days ago

Closing as dupe of #70