ERROR 2013 (HY000): "Lost connection to MySQL server at 'reading initial communication packet'", sys

[James Wang]

Hi All,

MaxSacle 1.4.3 and I got the error as subject when tried to connect to it:

mysql -uuser -ppass -h127.0.0.1 -P6603

user/pass tested and worked when connecting dorectly to MySQL:

mysql -uuser -ppass -h127.0.0.1 

Thanks a lot in advance

[James Wang]

Please ignore. 

On Monday, 20 June 2016 13:56:50 UTC+1, James Wang wrote:

Hi All,

[Massimiliano Pinto]

Hi James,

I see port 6603.

That reminds me the port for another MaxScale service that has listener for “maxscaled” protocol (Not the MySQL protocol port)

[CLI Listener]

type=listener

service=CLI

protocol=maxscaled

address=localhost

port=6603

I’ve just done this:

[root@maxscale-02 ~]# mysql -h 127.0.0.1 -P 6603

ERROR 2013 (HY000): Lost connection to MySQL server at 'reading initial communication packet', system error: 0

Would you mind sharing your maxscale configuration?

It would be very useful checking your configuration, maybe there could be something else to check.

Thanks.

Massimiliano

--
You received this message because you are subscribed to the Google Groups "MaxScale" group.
To unsubscribe from this group and stop receiving emails from it, send an email to maxscale+u...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[James Wang]

Should use port 4006 or 4008 port 6603 is for maxscale admin purpose

Cheers

On Monday, 20 June 2016 14:42:22 UTC+1, Massimiliano Pinto wrote:

Hi James,

I see port 6603.

That reminds me the port for another MaxScale service that has listener for “maxscaled” protocol (Not the MySQL protocol port)

I’ve just done this:

out.