drizzledump dont connects to mysqld 5.5.10 on archlinux

[Lukas Wingerberg]

drizzledump command refuses to connect to my local mysqld to dump a DB and import it into drizzled. strace log in attachment.
Got error: drizzle_state_connect:could not connect when trying to connect

Command: drizzledump --host=127.0.0.1 -p 3306 -P password -u root database

[Andrew Hutchings (linuxjedi)]

looks to me like your MySQL server isn't listening on 127.0.0.1:3306, or you have some kind of firewall?

[Lukas Wingerberg (y-admin-crystalnet-eu)]

i dont have any firewalling between applications that talk to each other via localhost / 127.0.0.1 and my mysqld IS listening there, i can connect fine using the mysql client binary

[Andrew Hutchings (linuxjedi)]

can you please run:

1. netstat -pan | grep mysqld
2. iptables-save

This should help us determine why the strace says 127.0.0.1:3306 isn't open in your case.

Also worth noting that by default with mysql clients socket connections are used for 'localhost' and '127.0.0.1' needs to be explicitly specified as the host to use TCP. This is not true of Drizzle clients.