Hi Dipti, [Sure, I ll take note of it to use googlegroups email ID for maxscale questions]. That's true. I tried to use 5308 port as mentioned in maxscale configuration sample for binlogrouter. When I configured and try to start maxscale, its failed due to unable to connect to master. I enabled 5308 in master db using firewalld. I am not sure how come maxscale binlog router's listner connecting to mariadb using 5308 (because 3306 is default port for mysql). I just port forward the 5308 requests to 3306 and its started working, but I am not sure what I did is the way we have to do. Then why maxscale binlogrouter is not using directly 3306. Why do we need to configure a different port (5308) to connect to mariadb. I am just asking myself these questions to understand, looking for other expert's enlightenment as well. Thank you for helping out. Regards, Karthick On Mon, Aug 29, 2016 at 5:52 PM, Dipti Joshi <dipti.joshi@mariadb.com> wrote:

Karthick:

Please ask MaxScale question on maxscale@googlegroups.com - I have cced here.

The port 5308 in documentation is for listener for a mysql client that you would use as following to register MaxScale with Master as slave

srvr:/home/my-usr$ mysql -u root -p 5308 -h <maxscale-host-ip>

...

CHANGE MASTER TO MASTER_HOST=‘$master_server’, MASTER_PORT=$master_port, MASTER_USER='repl', MASTER_PASSWORD=‘somepasswd’, MASTER_LOG_FILE=‘repl-bin.000159', MASTER_LOG_POS=4 START SLAVE

Is that what your are doing ?

Thanks, Dipti

On Mon, Aug 29, 2016 at 7:11 AM, Karthick Subramanian < ksubramanian@paycommerce.com> wrote:

...

Hi all,

When I try to configure maxscale for binlogrouter, I noticed that documentation examples using port as 5308. When I try to configure similarly, it says, 111 connection refused or unable to connect master from maxscale.

I have enabled the port in centOs7 using firewalld on both master server as well maxscale server:

firewall-cmd --add-port=5308/tcp

But still,I couldn't able to establish connection from maxscale server to mariadb server(master):

mysql -u maxscaleoper -h ip:ip:ip:ip --port 5308 -p

ERROR 2003 (HY000): Can't connect to MySQL server on 'ip:ip:ip:ip' (111 "Connection refused")

Can anyone please help me on how to resolve this error. Because of this error, I couldn't make maxscale up and running.

Regards, Karthick S

_______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp