Ive made the changes per your suggestion-
with this
sudo docker-compose exec -it manticore gosu manticore indexer --all --rotate
Manticore 6.2.12 dc5144d35@230822 (columnar 2.2.4 5aec342@230822) (secondary 2.2.4 5aec342@230822)
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 'product'...
FATAL: failed to open /var/lib/manticore.tmp.spl: Permission denied, will not index. Try --rotate option.
& this
sudo docker-compose exec -it manticore indexer --all --rotate
Manticore 6.2.12 dc5144d35@230822 (columnar 2.2.4 5aec342@230822) (secondary 2.2.4 5aec342@230822)
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 'product'...
ERROR: table 'product': sql_connect: Can't connect to MySQL server on '127.0.0.1:9306' (111) (DSN=mysql://root:***@127.0.0.1:9306/testdb).
total 0 docs, 0 bytes
total 0.002 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
using docker/docker-compose yields same result. Sorry for constantly asking for help but im stuck on this for like forever now, & I need some help.
Much appreciated 