This is a read-only copy of the MariaDB Knowledgebase generated on 2024-12-24. For the latest, interactive version please visit https://mariadb.com/kb/.

maxscale fee filter error

I am trying to setup maxscale tee filter in order to duplicate every requests from clients to 2 other mariadb servers.

[/etc/maxscale.cnf ]
[DataMartFilter]
type=filter
module=tee
match=*
service=Data Service

[server1]
type=server
address=192.168.27.137
port=3306
protocol=MySQLBackend

[server2]
type=server
address=192.168.27.142
port=3306
protocol=MySQLBackend


[Data Service]
type=service
router=readwritesplit
servers=server1,server2
user=root
passwd=pwd
filters=DataMartFilter

[DataMart Listener]
type=listener
service=Data Service
protocol=MySQLClient
port=4012


[error log]
MariaDB Corporation MaxScale	/var/log/maxscale/error1.log Tue Jan 26 00:50:07 2016
-----------------------------------------------------------------------
---	Logging is enabled.
2016-01-26 00:50:07   Error : Unable to find library for module: readconnrouter. Module dir: /usr/lib64/maxscale
2016-01-26 00:50:07   Error : Unable to load Router module "readconnrouter".
			      Ensure that libreadconnrouter.so exists in one of the following directories :
			      - /usr/lib64/maxscale
			      - :/usr/lib64/maxscale/maxscale
2016-01-26 00:50:07   Error : Reading configuration for router service 'Data Service' failed. Router Data Service is not loaded.
2016-01-26 00:50:07   Error : Failed to start any MaxScale services. Exiting.    
2016-01-26 00:50:07   MaxScale is shut down.	
-----------------------------------------------------------------------

Did I miss something in cnf file?

Answer Answered by Markus Mäkelä in this comment.

That is probably caused by the default behavior of not allowing root user to be used. If you want to enable it, please read the enable_root_user description in the Service section of the configuration guide: https://mariadb.com/kb/en/mariadb-enterprise/mariadb-maxscale/maxscale-configuration-usage-scenarios/

Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.