| Author |
Message |
< Erlyweb mailing list ~ Getting Application to run on mysql without password |
| Guest |
 Posted: Mon Oct 15, 2007 6:15 am |
 |
|
|
Guest
|
Hey, I'm trying to get my application run with the root user and no
password as that is out how it is setup on my development environment.
Is there a way to do that using
erlydb:start(mysql, [{hostname, "localhost"}, {username, "username"},
{password, "password"}, {database, "music"}]).
?
I tried running
erlydb:start(mysql, [{hostname, "localhost"}, {username, "root"},
{password, ""}, {database, "music"}]).
and it gave me:
mysql_conn:612: greeting version "5.0.38-Ubuntu_0ubuntu1.1-log"
(protocol 10) salt "wU\"I+7r]" caps 41516 serverchar <<8,2,0,0,
0,0,0,0,
0,0,0,0,
0,0,0,0>>salt2
"W}2|?cTZH;-n"
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,
114,111,111,116,0,20,137,40,16,246,
36,139,206,239,84,34,167,219,217,
189,62,228,29,173,55,197>>
mysql_conn:586: init error 1045: "#28000Access denied for user
'root'@'localhost' (using password: YES)"
mysql:465: failed starting first MySQL connection handler, exiting
{error,{error,login_failed}}
mysql_recv:143: mysql_recv: Socket #Port<0.116> closed
any thoughts?
-Lance
--~--~---------~--~----~------------~-------~--~----~
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 |
|
|
| Back to top |
|
| Guest |
| Posted: Mon Oct 15, 2007 2:28 pm |
|
|
|
Guest
|
Yeah, good question, Lance. I started reading the Pragmatic Erlang
book for the second time this weekend, but the whole learning
experience is pretty daunting. Is there a recommended course to follow
-- much like the famous Rails blog-in-15-minutes video?
I think we need some screencasts...
Mike Pence
http://mikepence.wordpress.com
On 10/15/07, Lance Carlson <lancecarlson@gmail.com> wrote:
>
> Hey, I'm trying to get my application run with the root user and no
> password as that is out how it is setup on my development environment.
> Is there a way to do that using
>
> erlydb:start(mysql, [{hostname, "localhost"}, {username, "username"},
> {password, "password"}, {database, "music"}]).
>
> ?
>
> I tried running
>
> erlydb:start(mysql, [{hostname, "localhost"}, {username, "root"},
> {password, ""}, {database, "music"}]).
>
> and it gave me:
>
> mysql_conn:612: greeting version "5.0.38-Ubuntu_0ubuntu1.1-log"
> (protocol 10) salt "wU\"I+7r]" caps 41516 serverchar <<8,2,0,0,
>
> 0,0,0,0,
>
> 0,0,0,0,
>
> 0,0,0,0>>salt2
> "W}2|?cTZH;-n"
> 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,
> 114,111,111,116,0,20,137,40,16,246,
> 36,139,206,239,84,34,167,219,217,
> 189,62,228,29,173,55,197>>
> mysql_conn:586: init error 1045: "#28000Access denied for user
> 'root'@'localhost' (using password: YES)"
> mysql:465: failed starting first MySQL connection handler, exiting
> {error,{error,login_failed}}
> mysql_recv:143: mysql_recv: Socket #Port<0.116> closed
>
> any thoughts?
>
> -Lance
>
> >
>
--~--~---------~--~----~------------~-------~--~----~
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 |
|
|
| Back to top |
|
| Guest |
| Posted: Mon Oct 15, 2007 3:47 pm |
|
|
|
Guest
|
Hey Mike! Good to see you jumping on the erlang wagon. I am in the
same boat with this stuff and we have created a local user group to
try to get more minds around the problems at hand. The goal is to
create aids (probably in the form of screencasts or blog posts) to
help everyone get started with the language, CEAN, and erlyweb. I also
registered erlangforge.org and hope that it will become a community
hub for erlangers like rubyforge is for ruby (it's still in progress-
help is appreciated  ). Anyway, join our user group and help us
out if you have time away from Amazon EC2 instances!!
http://groups.google.com/group/midwesterl
http://www.erlangforge.org
Also if anyone has a solution.. this question is still open 
On 10/15/07, Mike Pence <mike.pence@gmail.com> wrote:
>
> Yeah, good question, Lance. I started reading the Pragmatic Erlang
> book for the second time this weekend, but the whole learning
> experience is pretty daunting. Is there a recommended course to follow
> -- much like the famous Rails blog-in-15-minutes video?
>
> I think we need some screencasts...
>
> Mike Pence
> http://mikepence.wordpress.com
>
> On 10/15/07, Lance Carlson <lancecarlson@gmail.com> wrote:
> >
> > Hey, I'm trying to get my application run with the root user and no
> > password as that is out how it is setup on my development environment.
> > Is there a way to do that using
> >
> > erlydb:start(mysql, [{hostname, "localhost"}, {username, "username"},
> > {password, "password"}, {database, "music"}]).
> >
> > ?
> >
> > I tried running
> >
> > erlydb:start(mysql, [{hostname, "localhost"}, {username, "root"},
> > {password, ""}, {database, "music"}]).
> >
> > and it gave me:
> >
> > mysql_conn:612: greeting version "5.0.38-Ubuntu_0ubuntu1.1-log"
> > (protocol 10) salt "wU\"I+7r]" caps 41516 serverchar <<8,2,0,0,
> >
> > 0,0,0,0,
> >
> > 0,0,0,0,
> >
> > 0,0,0,0>>salt2
> > "W}2|?cTZH;-n"
> > 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,
> > 114,111,111,116,0,20,137,40,16,246,
> > 36,139,206,239,84,34,167,219,217,
> > 189,62,228,29,173,55,197>>
> > mysql_conn:586: init error 1045: "#28000Access denied for user
> > 'root'@'localhost' (using password: YES)"
> > mysql:465: failed starting first MySQL connection handler, exiting
> > {error,{error,login_failed}}
> > mysql_recv:143: mysql_recv: Socket #Port<0.116> closed
> >
> > any thoughts?
> >
> > -Lance
> >
> > >
> >
>
> >
>
--~--~---------~--~----~------------~-------~--~----~
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 |
|
|
| Back to top |
|
| Guest |
| Posted: Tue Oct 16, 2007 12:21 am |
|
|
|
Guest
|
I have same problem,
and here is output from erlang console in windows:
7> erlydb:start(mysql, [{hostname, "localhost"}, {username, "root"},
{password,
""}, {database, "music"}]).
** exited: {undef,[{mysql,start,
[erlydb_mysql,
"localhost",
undefined,
"root",
[],
"music"]},
{erl_eval,do_apply,5},
{shell,exprs,6},
{shell,eval_loop,3}]} **
8>
=ERROR REPORT==== 16-Oct-2007::01:54:20 ===
Error in process <0.103.0> with exit value: {undef,[{mysql,start,
[erlydb_mysql,"
localhost",undefined,"root",[],"music"]},{erl_eval,do_apply,5},
{shell,exprs,6},{
shell,eval_loop,3}]}
I have changed password ie put some password with same results.
erlyweb is version 0.6.2, mysql is version 5.0.27,
and of course, the beatles are in database
something is wrong also with compiling:
6> erlyweb:compile("d:/yawsApp/music", [{erlydb_driver, mysql}]).
debug:erlyweb_compile:340: Compiling Erlang file
"music_app_controller"
debug:erlyweb_compile:340: Compiling Erlang file "musician_view"
debug:erlyweb_compile:340: Compiling Erlang file "musician_controller"
debug:erlyweb_compile:340: Compiling Erlang file "musician"
debug:erlyweb_compile:340: Compiling Erlang file
"html_container_controller"
debug:erlyweb_compile:335: Compiling ErlTL file "html_container_view"
debug:erlyweb_compile:104: Generating ErlyDB code for models:
"musician.erl "
** exited: {function_clause,[{mysql,fetch,[erlydb_mysql,<<"show
tables">>]},
{erlydb_mysql,get_metadata,1},
{erlydb,code_gen,4},
{erlyweb_compile,compile,2},
{erl_eval,do_apply,5},
{shell,exprs,6},
{shell,eval_loop,3}]} **
7>
=ERROR REPORT==== 16-Oct-2007::01:47:40 ===
Error in process <0.81.0> with exit value: {function_clause,
[{mysql,fetch,[erlyd
b_mysql,<<11 bytes>>]},{erlydb_mysql,get_metadata,1},{erlydb,code_gen,
4},{erlywe
b_compile,compile,2},{erl_eval,do_apply,5},{shell,exprs,6},
{shell,eval_loop,3}]}
- I'm supposing that is same problem - erlyweb can't get connection
with mysql
emil
--~--~---------~--~----~------------~-------~--~----~
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 |
|
|
| Back to top |
|
| Guest |
| Posted: Tue Oct 16, 2007 4:09 am |
|
|
|
Guest
|
It looks like the MySQL driver doesn't support password-less
authentication. I'll see if I can fix it.
Yariv
On 10/15/07, emil <ebrusic@yahoo.com> wrote:
>
> I have same problem,
> and here is output from erlang console in windows:
>
> 7> erlydb:start(mysql, [{hostname, "localhost"}, {username, "root"},
> {password,
> ""}, {database, "music"}]).
> ** exited: {undef,[{mysql,start,
> [erlydb_mysql,
> "localhost",
> undefined,
> "root",
> [],
> "music"]},
> {erl_eval,do_apply,5},
> {shell,exprs,6},
> {shell,eval_loop,3}]} **
> 8>
> =ERROR REPORT==== 16-Oct-2007::01:54:20 ===
> Error in process <0.103.0> with exit value: {undef,[{mysql,start,
> [erlydb_mysql,"
> localhost",undefined,"root",[],"music"]},{erl_eval,do_apply,5},
> {shell,exprs,6},{
> shell,eval_loop,3}]}
>
> I have changed password ie put some password with same results.
> erlyweb is version 0.6.2, mysql is version 5.0.27,
> and of course, the beatles are in database
>
> something is wrong also with compiling:
>
>
> 6> erlyweb:compile("d:/yawsApp/music", [{erlydb_driver, mysql}]).
> debug:erlyweb_compile:340: Compiling Erlang file
> "music_app_controller"
> debug:erlyweb_compile:340: Compiling Erlang file "musician_view"
> debug:erlyweb_compile:340: Compiling Erlang file "musician_controller"
> debug:erlyweb_compile:340: Compiling Erlang file "musician"
> debug:erlyweb_compile:340: Compiling Erlang file
> "html_container_controller"
> debug:erlyweb_compile:335: Compiling ErlTL file "html_container_view"
> debug:erlyweb_compile:104: Generating ErlyDB code for models:
> "musician.erl "
> ** exited: {function_clause,[{mysql,fetch,[erlydb_mysql,<<"show
> tables">>]},
> {erlydb_mysql,get_metadata,1},
> {erlydb,code_gen,4},
> {erlyweb_compile,compile,2},
> {erl_eval,do_apply,5},
> {shell,exprs,6},
> {shell,eval_loop,3}]} **
> 7>
> =ERROR REPORT==== 16-Oct-2007::01:47:40 ===
> Error in process <0.81.0> with exit value: {function_clause,
> [{mysql,fetch,[erlyd
> b_mysql,<<11 bytes>>]},{erlydb_mysql,get_metadata,1},{erlydb,code_gen,
> 4},{erlywe
> b_compile,compile,2},{erl_eval,do_apply,5},{shell,exprs,6},
> {shell,eval_loop,3}]}
>
> - I'm supposing that is same problem - erlyweb can't get connection
> with mysql
>
> emil
>
>
> >
>
--~--~---------~--~----~------------~-------~--~----~
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 |
|
|
| Back to top |
|
| Guest |
| Posted: Tue Oct 16, 2007 12:26 pm |
|
|
|
Guest
|
> It looks like the MySQL driver doesn't support password-less
> authentication. I'll see if I can fix it.
I'm newbie in erlang (some experience in Rails) and made some
configuration mistakes.
Now, I could compile i.e.:
3> erlyweb:compile("c:/development/yawsapp/music", [{erlydb_driver,
mysql}]).
- it works
but there is still problem with "erlydb:start" function, even I put
password to "music" database
6> erlydb:start(mysql, [{hostname, "localhost"}, {username, "root"},
{password,
"pass"}, {database, "music"}]).
=ERROR REPORT==== 16-Oct-2007::14:07:57 ===
Error in process <0.84.0> with exit value: {undef,[{mysql,start,
[erlydb_mysql,"l
ocalhost",undefined,"root","pass","music"]},{erl_eval,do_apply,5},
{shell,exprs,6
},{shell,eval_loop,3}]}
thanks Yariv for the quick reply,
it looks like you did great job with erlyweb
emil
--~--~---------~--~----~------------~-------~--~----~
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 |
|
|
| Back to top |
|
|
|
All times are GMT
|
|
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
|
|
|
Digg It
Del.icio.us
Reddit
Facebook
Stumble Upon
Technorati
