Bad error handling with Drizzledump connect

[m00dawg]

When trying to issue a dump from a MySQL database (5.1.41-3ubuntu2.6 specifically), I get the following:

root@mcp:/var/lib/drizzle/local/test# drizzledump -p3306 -uroot -Ppasswordomitted moocowproductions
Got error: 15 when trying to connect
terminate called without an active exception
Aborted
root@mcp:/var/lib/drizzle/local/test# perror 15
OS error code 15: Block device required

This is on Ubuntu 10.04 using "2010.09.1802-1ubuntu1~lucid1":

root@mcp:/var/log# apt-cache policy drizzle-server
drizzle-server:
  Installed: 2010.09.1802-1ubuntu1~lucid1
  Candidate: 2010.09.1802-1ubuntu1~lucid1
  Version table:
 *** 2010.09.1802-1ubuntu1~lucid1 0
        500 http://ppa.launchpad.net/drizzle-developers/ppa/ubuntu/ lucid/main Packages
        100 /var/lib/dpkg/status

[Andrew Hutchings (linuxjedi)]

m00dawg: can you please try connecting with the 'drizzle' client app to the MySQL server?

[Andrew Hutchings (linuxjedi)]

ok, so I've done a bit of digging and in libdrizzle error 15 is auth failed. So:

1. I will fix the exception handling when connecting
2. I will make drizzledump give proper error messages instead of codes
3. I will do some more testing to make sure auth is working correctly and fix anything there if necessary.

[m00dawg (tim-moocowproductions)]

Aha so it was a permissions issue. Forgot to make a user for '127.0.0.1' which was ultimately the problem. Glad to hear you have already fixed the error reporting, thank you!

[Andrew Hutchings (linuxjedi)]

No problem, many thanks for reporting it :)

The fix now provides connection errors similar to those mysqldump does when it fails to connect.