Erlang/OTP Forums

Author Message

<  Erlyweb mailing list  ~  erlyweb mysql driver issue

Guest
Posted: Sat Mar 08, 2008 7:54 am Reply with quote
Guest
Any suggestions as to how I can get mysql driver to work?

My erlyweb version:

URL: http://erlyweb.googlecode.com/svn/trunk
Repository Root: http://erlyweb.googlecode.com/svn
Repository UUID: 2a2c65bc-d020-0410-b564-ff2a5d75179a
Revision: 244
Node Kind: directory
Schedule: normal
Last Changed Author: yarivvv
Last Changed Rev: 244
Last Changed Date: 2008-02-25 02:49:41 -0500 (Mon, 25 Feb 2008)

MySQL version:
mysql --version
mysql Ver 14.14 Distrib 6.0.3-alpha


1> erlydb:start(mysql,[{hostname,"localhost"},{username, "test"},
{password, "test"},{database, "test"},{pool_size, 10}]).
mysql_conn:620: greeting version "6.0.3-alpha" (protocol 10) salt "\\W!
>Q_hn" caps 41516 serverchar <<192,2,0,

0,0,0,0,

0,0,0,0,

0,0,0,0,

0>>salt2 "n^l%q*zI?@aH"
mysql_conn:832: MySQL version not supported: MySQL Erlang module might
not work correctly.
mysql_auth:187: mysql_auth send packet 1:
<<5,162,0,0,64,66,15,0,8,0,0,0,0,0,0,

0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,

116,101,115,116,0,20,182,255,6,110,

87,162,167,46,72,32,140,31,205,105,
144,160,20,191,125,32>>
mysql_auth:187: mysql_auth send packet 3:
<<74,90,71,77,77,88,93,68,0>>
mysql_conn:426: fetch <<"use test">> (id <0.40.0>)
mysql_conn:322: mysql_conn: Failed changing to database "test" :
<<"#42000Access denied for user 'test'@'%' to database 'test'">>
mysql:502: failed starting first MySQL connection handler, exiting
ok

thanks.
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "erlyweb" group.
To post to this group, send email to erlyweb@googlegroups.com
To unsubscribe from this group, send email to erlyweb-unsubscribe@googlegroups.com
For more options, visit this group at http://groups.google.com/group/erlyweb?hl=en
-~----------~----~----~----~------~----~------~--~---

Post recived from mailinglist
Guest
Posted: Tue Mar 11, 2008 8:15 am Reply with quote
Guest
This looks weird. Assuming the database "test" exists and it's
accessible to "test"/"test", it's possible this problem is due to the
fact that you're using MySQL 6 alpha, which is apparently not
supported by the driver.

On Sat, Mar 8, 2008 at 12:54 AM, db <masterofquestions@gmail.com> wrote:
>
> Any suggestions as to how I can get mysql driver to work?
>
> My erlyweb version:
>
> URL: http://erlyweb.googlecode.com/svn/trunk
> Repository Root: http://erlyweb.googlecode.com/svn
> Repository UUID: 2a2c65bc-d020-0410-b564-ff2a5d75179a
> Revision: 244
> Node Kind: directory
> Schedule: normal
> Last Changed Author: yarivvv
> Last Changed Rev: 244
> Last Changed Date: 2008-02-25 02:49:41 -0500 (Mon, 25 Feb 2008)
>
> MySQL version:
> mysql --version
> mysql Ver 14.14 Distrib 6.0.3-alpha
>
>
> 1> erlydb:start(mysql,[{hostname,"localhost"},{username, "test"},
> {password, "test"},{database, "test"},{pool_size, 10}]).
> mysql_conn:620: greeting version "6.0.3-alpha" (protocol 10) salt "\\W!
> >Q_hn" caps 41516 serverchar <<192,2,0,
>
> 0,0,0,0,
>
> 0,0,0,0,
>
> 0,0,0,0,
>
> 0>>salt2 "n^l%q*zI?@aH"
> mysql_conn:832: MySQL version not supported: MySQL Erlang module might
> not work correctly.
> mysql_auth:187: mysql_auth send packet 1:
> <<5,162,0,0,64,66,15,0,8,0,0,0,0,0,0,
>
> 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,
>
> 116,101,115,116,0,20,182,255,6,110,
>
> 87,162,167,46,72,32,140,31,205,105,
> 144,160,20,191,125,32>>
> mysql_auth:187: mysql_auth send packet 3:
> <<74,90,71,77,77,88,93,68,0>>
> mysql_conn:426: fetch <<"use test">> (id <0.40.0>)
> mysql_conn:322: mysql_conn: Failed changing to database "test" :
> <<"#42000Access denied for user 'test'@'%' to database 'test'">>
> mysql:502: failed starting first MySQL connection handler, exiting
> ok
>
> thanks.
> >
>

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "erlyweb" group.
To post to this group, send email to erlyweb@googlegroups.com
To unsubscribe from this group, send email to erlyweb-unsubscribe@googlegroups.com
For more options, visit this group at http://groups.google.com/group/erlyweb?hl=en
-~----------~----~----~----~------~----~------~--~---

Post recived from mailinglist
Guest
Posted: Sat Mar 15, 2008 9:12 pm Reply with quote
Guest
I receive a similar error message:
1> erlydb:start(mysql,[{hostname,"localhost"}, {user, "orbitz"},
{password, "test"}, {database, "music"}]).
mysql_conn:620: greeting version "5.0.51a" (protocol 10) salt "olM|
MG[u" caps 41516 serverchar <<8,2,0,0,

0,0,0,0,

0,0,0,0,

0,0,0,0>>salt2 "ZE)<2'liM#dP"

=ERROR REPORT==== 15-Mar-2008::17:10:08 ===
Error in process <0.58.0> with exit value: {badarg,
[{erlang,list_to_binary,[undefined]},{mysql_auth,make_new_auth,3},
{mysql_auth,do_new_auth,8},{mysql_conn,mysql_init,5},{mysql_conn,init,
9}]}

mysql:502: failed starting first MySQL connection handler, exiting

My version isn't 6 though, any ideas?


On Mar 11, 4:14
Guest
Posted: Sat Mar 15, 2008 9:23 pm Reply with quote
Guest
Ok, duh error, ignore!


On Mar 15, 5:11

Display posts from previous:  

All times are GMT
Page 1 of 1
This forum is locked: you cannot post, reply to, or edit topics.

Jump to:  

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You cannot attach files in this forum
You cannot download files in this forum