Mysql

hi
im on ubuntu 8.0r lts, installed rails 2.3.4 ruby gem 1.3.5 mysql
5.0

when i rails myapp =>creates an sqllite3 environment and works good
when i rails myapp -d mysql have an error when run db:create

Couldn’t create database for {“socket”=>"/var/run/mysqld/mysqld.sock",
“reconnect”=>false, “encoding”=>“utf8”, “username”=>“root”,
“adapter”=>“mysql”, “password”=>“difahu”, “database”=>“a4_development”,
“pool”=>5}, charset: utf8, collation: utf8_unicode_ci (if you set the
charset manually, make sure you have a matching collation)

i can access mysql , irb, individually without problem

somebody knows what happens???

I have seen the fix for this be one of the following:

if you have charset: utf8 change that to encoding
or use 127.0.0.1 and not localhost
or permissions for the user in the database (create table is a good
one to have… )

On Sep 22, 4:52 pm, Daniel Hutchinson <rails-mailing-l…@andreas-

heimdull wrote:

I have seen the fix for this be one of the following:

if you have charset: utf8 change that to encoding
or use 127.0.0.1 and not localhost
or permissions for the user in the database (create table is a good
one to have… )

On Sep 22, 4:52�pm, Daniel Hutchinson <rails-mailing-l…@andreas-

Thanks a lot! heimdull for the answer . Im a beginner i RoR and I come
from Visual Fox->SQL platform .

I tried as you said. And I get the next line messages (above)

if you see ( and I did not) the service start at 0.0.0.0:3000
and another line I didnt see either is

“Client does not support authentication protocol requested by server;
consider upgrading MySQL client”

So if you or another can make me easy the way thanks, I will looking
for now with this data something more

Thanks Again for your help

-----------------------LINE MESSAGES

[email protected]:~/a4$ script/server
=> Booting Mongrel
=> Rails 2.3.4 application starting on http://0.0.0.0:3000
=> Call with -d to detach
=> Ctrl-C to shutdown server
/!\ FAILSAFE /!\ Wed Sep 23 09:33:50 -0500 2009
Status: 500 Internal Server Error
Client does not support authentication protocol requested by server;
consider upgrading MySQL client
/usr/lib/ruby/1.8/mysql.rb:453:in read' /usr/lib/ruby/1.8/mysql.rb:130:inreal_connect’
/usr/lib/ruby/gems/1.8/gems/activerecord-2.3.4/lib/active_record/connection_adapters/mysql_adapter.rb:585:in
connect' /usr/lib/ruby/gems/1.8/gems/activerecord-2.3.4/lib/active_record/connection_adapters/mysql_adapter.rb:199:ininitialize’
/usr/lib/ruby/gems/1.8/gems/activerecord-2.3.4/lib/active_record/connection_adapters/mysql_adapter.rb:71:in
new' /usr/lib/ruby/gems/1.8/gems/activerecord-2.3.4/lib/active_record/connection_adapters/mysql_adapter.rb:71:inmysql_connection’
/usr/lib/ruby/gems/1.8/gems/activerecord-2.3.4/lib/active_record/connection_adapters/abstract/connection_pool.rb:223:in
send' /usr/lib/ruby/gems/1.8/gems/activerecord-2.3.4/lib/active_record/connection_adapters/abstract/connection_pool.rb:223:innew_connection’
/usr/lib/ruby/gems/1.8/gems/activerecord-2.3.4/lib/active_record/connection_adapters/abstract/connection_pool.rb:245:in
checkout_new_connection' /usr/lib/ruby/gems/1.8/gems/activerecord-2.3.4/lib/active_record/connection_adapters/abstract/connection_pool.rb:188:incheckout’
/usr/lib/ruby/gems/1.8/gems/activerecord-2.3.4/lib/active_record/connection_adapters/abstract/connection_pool.rb:184:in
loop' /usr/lib/ruby/gems/1.8/gems/activerecord-2.3.4/lib/active_record/connection_adapters/abstract/connection_pool.rb:184:incheckout’
/usr/lib/ruby/1.8/monitor.rb:242:in synchronize' /usr/lib/ruby/gems/1.8/gems/activerecord-2.3.4/lib/active_record/connection_adapters/abstract/connection_pool.rb:183:incheckout’
/usr/lib/ruby/gems/1.8/gems/activerecord-2.3.4/lib/active_record/connection_adapters/abstract/connection_pool.rb:98:in
connection' /usr/lib/ruby/gems/1.8/gems/activerecord-2.3.4/lib/active_record/connection_adapters/abstract/connection_pool.rb:326:inretrieve_connection’
/usr/lib/ruby/gems/1.8/gems/activerecord-2.3.4/lib/active_record/connection_adapters/abstract/connection_specification.rb:123:in
retrieve_connection' /usr/lib/ruby/gems/1.8/gems/activerecord-2.3.4/lib/active_record/connection_adapters/abstract/connection_specification.rb:115:inconnection’
/usr/lib/ruby/gems/1.8/gems/activerecord-2.3.4/lib/active_record/query_cache.rb:9:in
cache' /usr/lib/ruby/gems/1.8/gems/activerecord-2.3.4/lib/active_record/query_cache.rb:28:incall’
/usr/lib/ruby/gems/1.8/gems/activerecord-2.3.4/lib/active_record/connection_adapters/abstract/connection_pool.rb:361:in
call' /usr/lib/ruby/gems/1.8/gems/rack-1.0.0/lib/rack/head.rb:9:incall’
/usr/lib/ruby/gems/1.8/gems/rack-1.0.0/lib/rack/methodoverride.rb:24:in
call' /usr/lib/ruby/gems/1.8/gems/actionpack-2.3.4/lib/action_controller/params_parser.rb:15:incall’
/usr/lib/ruby/gems/1.8/gems/actionpack-2.3.4/lib/action_controller/session/cookie_store.rb:93:in
call' /usr/lib/ruby/gems/1.8/gems/actionpack-2.3.4/lib/action_controller/failsafe.rb:26:incall’
/usr/lib/ruby/gems/1.8/gems/rack-1.0.0/lib/rack/lock.rb:11:in call' /usr/lib/ruby/gems/1.8/gems/rack-1.0.0/lib/rack/lock.rb:11:insynchronize’
/usr/lib/ruby/gems/1.8/gems/rack-1.0.0/lib/rack/lock.rb:11:in call' /usr/lib/ruby/gems/1.8/gems/actionpack-2.3.4/lib/action_controller/dispatcher.rb:114:incall’
/usr/lib/ruby/gems/1.8/gems/actionpack-2.3.4/lib/action_controller/reloader.rb:34:in
run' /usr/lib/ruby/gems/1.8/gems/actionpack-2.3.4/lib/action_controller/dispatcher.rb:108:incall’
/usr/lib/ruby/gems/1.8/gems/rails-2.3.4/lib/rails/rack/static.rb:31:in
call' /usr/lib/ruby/gems/1.8/gems/rack-1.0.0/lib/rack/urlmap.rb:46:incall’
/usr/lib/ruby/gems/1.8/gems/rack-1.0.0/lib/rack/urlmap.rb:40:in
each' /usr/lib/ruby/gems/1.8/gems/rack-1.0.0/lib/rack/urlmap.rb:40:incall’
/usr/lib/ruby/gems/1.8/gems/rails-2.3.4/lib/rails/rack/log_tailer.rb:17:in
call' /usr/lib/ruby/gems/1.8/gems/rack-1.0.0/lib/rack/content_length.rb:13:incall’
/usr/lib/ruby/gems/1.8/gems/rack-1.0.0/lib/rack/chunked.rb:15:in
call' /usr/lib/ruby/gems/1.8/gems/rack-1.0.0/lib/rack/handler/mongrel.rb:61:inprocess’
/usr/lib/ruby/1.8/mongrel.rb:159:in process_client' /usr/lib/ruby/1.8/mongrel.rb:158:ineach’
/usr/lib/ruby/1.8/mongrel.rb:158:in process_client' /usr/lib/ruby/1.8/mongrel.rb:285:inrun’
/usr/lib/ruby/1.8/mongrel.rb:285:in initialize' /usr/lib/ruby/1.8/mongrel.rb:285:innew’
/usr/lib/ruby/1.8/mongrel.rb:285:in run' /usr/lib/ruby/1.8/mongrel.rb:268:ininitialize’
/usr/lib/ruby/1.8/mongrel.rb:268:in new' /usr/lib/ruby/1.8/mongrel.rb:268:inrun’
/usr/lib/ruby/gems/1.8/gems/rack-1.0.0/lib/rack/handler/mongrel.rb:34:in
run' /usr/lib/ruby/gems/1.8/gems/rails-2.3.4/lib/commands/server.rb:111 /usr/local/lib/site_ruby/1.8/rubygems/custom_require.rb:31:ingem_original_require’
/usr/local/lib/site_ruby/1.8/rubygems/custom_require.rb:31:in
`require’
script/server:3

Daniel Hutchinson wrote:

Solved!

I decide to new post because I posted with MySQL title which dont say
nothing about the real problem

So when i get the message

"Client does not support authentication protocol requested by server;

consider upgrading MySQL client"

or after run rake db:create

get error message “could create table…”


after spend time I and look carefully the messages

google the message “Client does not support…” and found the next link

http://www.buayacorp.com/archivos/client-does-not-support-authentication-protocol-requested-by-server/#commentform

where Braulio teach why is the problem and how to solve it

is something about authentication protocol issue with mysql 4.1. -> 5.0
and rails 2.3.4

and solve as this

get into mysql

$mysql -u root -p
enter your pwd
and then enter the line

SET PASSWORD FOR ‘root’@‘localhost’ = OLD_PASSWORD(‘pwd’);

and thats it!

quit the mysql session

run rake db:migrate
then script/server
get into localhost:3000
and is working now

slds

This forum is not affiliated to the Ruby language, Ruby on Rails framework, nor any Ruby applications discussed here.

| Privacy Policy | Terms of Service | Remote Ruby Jobs