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
[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
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..
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.
It leads to this page..
http://drizzle.org/wiki/User_Documentation ## an outline of what
documentation might look like in the future.
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
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.
Thanks for your help.
--
Tom
So in exchange for friendly help on this list, as I learn Drizzle I
can help submit some docs to your "outline only" collection of docs.
That would be most awesome! Thanks!
-jay
Regards,
Tom Hanlon
_______________________________________________
Mailing list: https://launchpad.net/~drizzle-discuss
Post to : [email protected]
Unsubscribe : https://launchpad.net/~drizzle-discuss
More help : https://help.launchpad.net/ListHelp
_______________________________________________
Mailing list: https://launchpad.net/~drizzle-discuss
Post to : [email protected]
Unsubscribe : https://launchpad.net/~drizzle-discuss
More help : https://help.launchpad.net/ListHelp
