I recently upgraded a server to MariaDB 10.2 and Manticore 3.4.2 but my indexer cannot connect any more, this is what I tried:
mysql -P 9306 -u my_user -p
I type the password and connect happily to the database
mysql -P 9306 -h 0
connects happily to manticore
indexer myHB_index2 --rotate
Manticore 3.4.2 6903305@200410 release
Copyright © 2001-2016, Andrew Aksyonoff
Copyright © 2008-2016, Sphinx Technologies Inc (http://sphinxsearch.com)
Copyright © 2017-2020, Manticore Software LTD (http://manticoresearch.com)
using config file ‘/etc/manticoresearch/manticore.conf’…
indexing index ‘myHB_index2’…
ERROR: index ‘myHB_index2’: sql_connect: Access denied for user '’@‘localhost’ (using password: YES) (DSN=mysql://:@localhost:3306/*******)
indexer is using -DMYSQL_LIB=libmysqlclient.so.18
And I found the following in my lib64:
So I guess the mysql library is ok.
I tried creating a new user, changing the password to all alpha chars and adding permissions on localhost and 127.0.0.1 but the error stays.
PHP scripts connect fine to the DB using the same user.
Testing some more … this is the DB error log:
2020-04-26 13:18:53 139635568551680 [Warning] Access denied for user ‘myheal21_manticore’@‘localhost’ (using password: YES)
2020-04-26 13:19:52 139635568244480 [Warning] Access denied for user ‘**********’@‘localhost’ (using password: YES)
the first line is the connection from a terminal (I put the wrong password on purpose)
the second is the failed connection from manticore/indexer
why is the user name showed as ***** and not plain ? can this be related to the connection problem ?
I check the connection used by php (which works for the same user), here are the details:
Server information: 5.5.5-10.2.31-MariaDB
Host information: Localhost via UNIX socket
Protocol information: 10
Client information: mysqlnd 5.0.12-dev - 20150407 - $Id: 7cc7cc96e675f6d72e5cf0f267f48e167c2abb23 $
---------- update ---------
Installed Manticore 3.3.0 and 3.1.2 they use the same mysqllib so not sure what difference they would make but I get the same connection problem.
Help very much appreciated.