drizzle client only works when using strace

[m00dawg]

This is on Ubuntu 10.04 with latest (as of this moment) development DEBs:

root@mcp:~# drizzle
ERROR:
drizzle_state_connect:could not connect
root@mcp:~# strace drizzle 2> WTF
Welcome to the Drizzle client.. Commands end with ; or \g.
Your Drizzle connection id is 1
Connection protocol: mysql
Server version: 2010.10.02 Debian

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

drizzle>
drizzle> Bye

root@mcp:~# mysql -P4427 -h127.0.0.1
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 2010.10.02 Debian

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql>

root@mcp:~# drizzle --port=4427
Error:multiple_occurrences

*scratches head*

[Lee Bieber (kalebral-deactivatedaccount)]

I'm not sure if Andrew or Monty should be assigned to this, but will start with Andrew, please reassign if necessary

[Andrew Hutchings (andrew-hutchings)]

I am not affiliated with the Drizzle project. I believe the other Andrew Hutchings was meant to be assigned.

[Andrew Hutchings (linuxjedi)]

ok, so. Done a clean install of 10.04, installed MySQL on it, then Drizzle PPA. So far haven't been able to reproduce this so I am missing something here...

[m00dawg (tim-moocowproductions)]

Using these PPAs? (just confirming):

tim@mcp:~$ cat /etc/apt/sources.list.d/drizzle.list
#deb http://ppa.launchpad.net/drizzle-developers/ppa/ubuntu lucid main
deb http://ppa.launchpad.net/drizzle-developers/trunk/ubuntu lucid main

[Andrew Hutchings (linuxjedi)]

ok, so it can't be a config file, in tests I found the config file settings do not have dominance.

m00dawg: can you please try the 'alias' command in bash? Something in your setup is doing some kind of command line aliasing somewhere I think.

[m00dawg (tim-moocowproductions)]

... man as soon as you said that I remembered I was doing this:

alias drizzle="drizzle -p3307"

Ooops :/ I forgot I had that there after the last update. Oh man sorry for wasting your time there! Removing the line fixes things.

*runs away meekly* :)

[Andrew Hutchings (linuxjedi)]

hehe, no problem. Glad we could come to a resolution and I found another small bug in config file handling whilst testing this :)