I am setting up ManticoreSearch and encountered this problem.
$ sudo -u manticore indexer locations
Manticore 6.0.4 1a3a4ea82@230314 (columnar 2.0.4 5a49bd7@230306) (secondary 2.0.4 5a49bd7@230306)
Copyright (c) 2001-2016, Andrew Aksyonoff
Copyright (c) 2008-2016, Sphinx Technologies Inc (http://sphinxsearch.com)
Copyright (c) 2017-2023, Manticore Software LTD (https://manticoresearch.com)
using config file '/etc/manticoresearch/manticore.conf'...
indexing table 'locations'...
ERROR: table 'locations': sql_connect: MySQL source wasn't initialized. Wrong name in dlopen? (DSN=mysql://root:***@127.0.0.1:3306/location).
total 0 docs, 0 bytes
total 0.000 sec, 0 bytes/sec, 0.00 docs/sec
total 0 reads, 0.000 sec, 0.0 kb/call avg, 0.0 msec/call avg
total 0 writes, 0.000 sec, 0.0 kb/call avg, 0.0 msec/call avg
I am currently using Mysql 8.0.32 on Rocky Linux 9.2. I have checked the previous documentation and found that similar issues were raised back in 2019, but those solutions couldn’t resolve my current problem. How can I resolve this issue and identify its root cause?