Tom Hanlon wrote:
Team Drizzle,
On 7 Jan 2010, at 11:42, Jay Pipes wrote:
Tom Hanlon wrote:
Hello Team Drizzle,
My first post, so.. be kind. If this post belongs in another place,
then nicely remind me of where that place is.
We're always nice here, Tom :) And, yes, this is a perfectly fine
place for questions.
I downloaded drizzle-2009.12.1251 and libdrizzle-0.6 , on
CentOS.
I grabbed whatever dependencies where needed and compiled.
I want to know if it is possible to connect to my MySQLD using
/usr/local/bin/drizzle ?
I know that plugins to support the MySQL protocol are available for
the drizzled server, but what about the client ?
I tried..." /usr/local/bin/drizzle --socket=/tmp/mysql.sock" but
nothing, I grepped the help for the word mysql, but nothing.
By "nothing", do you mean nothing at all happened, or you got an error
message?
Here is more detail,
I can connect to MySQL with the MySQL client.
mysql -u tom -pmot --socket=/tmp/mysql.sock
Drizzle... not able to connect.
[r...@localhost drizzle]# /usr/local/bin/drizzle -S /tmp/mysql.sock -u
tom --password=mot
ERROR:
drizzle_state_connect:could not connect
Seeing that sometimes Drizzle client asked for a password, I assumed it
had at least started a handshake with mysqld, so I restarted mysql with
grants disabled.
And I get some success..
*works*
/usr/local/bin/drizzle --user=tom --password=mot -h 127.0.0.1 --port=3306
Welcome to the Drizzle client.. Commands end with ; or \g.
Your Drizzle connection id is 4
Server version: 5.1.35-ndb-7.0.7-cluster-gpl-lo MySQL Cluster Server (GPL)
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
drizzle> select "WOOO HOOO !!!";
+-------------+
| woo hoo !!! |
+-------------+
| woo hoo !!! |
+-------------+
Moving it to the socket.. does not work
OK, so it looks like the problem doesn't have to do with grants, but is
isolated to working with Unix domain sockets (as opposed to TCP port).
Drizzle itself does not support Unix domain sockets, but I'm not sure
whether libdrizzle has also dropped support for it. I've pinged Eric
Day for an answer. Regardless, though, there should be more of a
descriptive message than "could not connect" ;)
[r...@localhost drizzle]# ls /tmp/mysql*
/tmp/mysql.sock
[r...@localhost drizzle]# /usr/local/bin/drizzle --user=tom
--password=mot -h 127.0.0.1 --socket=/tmp/mysql.sock
ERROR:
drizzle_state_connect:could not connect
When I turn authentication on in MySQLD.. I get failure
[r...@localhost drizzle]# /usr/local/bin/drizzle --user=tom --password
--socket=/tmp/mysql.sock
Enter password: ***
ERROR:
drizzle_state_connect:could not connect
From your results above, it seems not related to the authentication but
instead to the use of Unix domain sockets instead of --port?
Also the drizzle documentation is not very useful in "i-am-a-dummy"
mode.
Could you elaborate on "not very useful"? What should we add to the
documentation?
Uh... we should add documentation to the documentation..
Yes, documentation is a very poor spot for Drizzle. Much agreed, and
we'd love your help.
On Launchpad I see developers doing developer stuff.
on http://drizzle.org/wiki/Main_Page I find a User Documentation link. I
would expect user documentation to be there. Perhaps others expect that
as well ? The webmaster should run the massive log files through hadoop
and see if other newbies expect documentation to be behind that link.
I don't think there's a need to run a Hadoop job ;) I think you're spot on.
It leads to this page..
http://drizzle.org/wiki/User_Documentation ## an outline of what
documentation might look like in the future.
Yeah, I think Sheeri and others had put together the outline hoping that
it would get filled in over time... it's in a very raw state.
Digging a little further, I do find some technical docs.
But the most useful page to me regarding installing and starting drizzle
was this..
http://devzone.zend.com/article/4793
Interesting. It would be good to link to that excellent tutorial in our
wiki.
So I guess I am saying we need more user tutorial stuff like that.
Trust me , once I get this drizzle to MySQL thing worked out, I will
share a doc, although the usefulness of that particular tutorial is
somewhat limited.
Sounds great! :)
-jay
_______________________________________________
Mailing list: https://launchpad.net/~drizzle-discuss
Post to : [email protected]
Unsubscribe : https://launchpad.net/~drizzle-discuss
More help : https://help.launchpad.net/ListHelp
