I have the following setup:
- 1 dedicated server for Manticore Search
- 1 server for MySQL and Apache
I have successfully installed Manticore and run the indexer. I can access the index when using :
mysql -h0 -P9306
On the MySQL/Apached server I always get an error “ERROR 2003 (HY000) : Can’t connect to MySQL server on ‘x.x.x.x’ (111)”. I tried using the local IP and public IP to no avail. Both servers can also ping each other. Indexer also has no problems connecting to the MySQL database. I also installed the libmysqlclient20.
Really appreciate the help big time!