maria-discuss team mailing list archive

[Karthick Subramanian <ksubramanian@xxxxxxxxxxxxxxx>]

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@xxxxxxxxxxx>
wrote:

> Karthick:
>
> Please ask MaxScale question on maxscale@xxxxxxxxxxxxxxxx - 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@xxxxxxxxxxxxxxx> 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@xxxxxxxxxxxxxxxxxxx
>> Unsubscribe : https://launchpad.net/~maria-discuss
>> More help   : https://help.launchpad.net/ListHelp
>>
>>
>