Ruby On Rails

[Duong vong veasna]

Dear all Rails Developers, i can not use the command "rails new app -d mysql" when i try to use this i got error.

please help me, thanks you.

[Germano Teixeira]

Did you try install the mysql gem before run rails new command?

Try run "gem install mysql2" as suggested by the log. 

This will show you what is the real problem.

--
You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group.
To unsubscribe from this group and stop receiving emails from it, send an email to rubyonrails-ta...@googlegroups.com.
To post to this group, send email to rubyonra...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/rubyonrails-talk/69db2927-9daf-45f8-830e-d95e9b2f04a4%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[Duong vong veasna]

when i use gem install mysql2. I got this error.

Result logged to C:/RailsInstaller/Ruby1.9.3/lib/ruby/gems/1.9.1/extensions/x86-mingw32/1.9.1/mysql-2.9.1/gem_make.out

thanks you,

[Duong vong veasna]

when i use gem install mysql2. I got this error.

Result logged to C:/RailsInstaller/Ruby1.9.3/lib/ruby/gems/1.9.1/extensions/x86-mingw32/1.9.1/mysql-2.9.1/gem_make.out

thanks you,

[Karthikeyan A K]

Sorry to say that long long ago tried to install MySQL gem in Windows 7 and 8 and was not able to do it. If possible shift to linux.

[Loganathan Sellapa]

You need to place mysql client ddl file. Refer here http://stackoverflow.com/questions/8162322/set-up-rails-to-find-the-default-location-of-libmysql-dll . I installed ROR on windows sometime backa nd resolved the issue by placing the dll file.

regards,
Loganathan
Mob: +91 7760780741 | +91 9944414388
Skype: loganathan.sellappa
ViewMe

To view this discussion on the web visit https://groups.google.com/d/msgid/rubyonrails-talk/9e9c5ed1-71d8-4efb-937b-8f6636e49438%40googlegroups.com.

[Duong vong veasna]

Dear Mr. Loganathan, After i copy dll file into ruby/bin then i start run "rails server", localhost:3000 not working, it said <mysql2::Error>
Access denied for user 'root'@'localhost' (using password: NO)

please help me, thanks you.

[Loganathan Sellapa]

Did you set the Mysql username & password in database.yml and can you able to login via mysql client directly?

regards,
Loganathan
Mob: +91 7760780741 | +91 9944414388
Skype: loganathan.sellappa
ViewMe

To view this discussion on the web visit https://groups.google.com/d/msgid/rubyonrails-talk/15d55975-9772-4d82-ae5b-2b6e59a7c0b0%40googlegroups.com.

[Duong vong veasna]

Dear Mr. Loganathan

Could you tell me how to set username and password.
Do i have to put it in Railsinstaller folder? if that how to do?

thanks for your help.
veasna

[Loganathan Sellapa]

You need to place the user name and password in database.yml.

  database: dbname

  adapter: mysql2

  encoding: utf8

  pool: 5

  username: mysql-username

  password:  mysql-password

  socket: /var/run/mysqld/mysqld.sock

regards,
Loganathan
Mob: +91 7760780741 | +91 9944414388
Skype: loganathan.sellappa
ViewMe

To view this discussion on the web visit https://groups.google.com/d/msgid/rubyonrails-talk/c73083fa-4c48-4950-ab5f-1ff767a0d279%40googlegroups.com.

[Duong vong veasna]

Thanks again Mr. Loganathan
but i am using window 8.

[Loganathan Sellapa]

Whatever may be the OS, you need to configure the mysql credential in database.yml

regards,
Loganathan
Mob: +91 7760780741 | +91 9944414388
Skype: loganathan.sellappa
ViewMe

To view this discussion on the web visit https://groups.google.com/d/msgid/rubyonrails-talk/b52e7c07-1674-4bc6-b83d-8a35977c1109%40googlegroups.com.

[Duong vong veasna]

One more thing, I have create application with this command "rails new app -d mysql".
when i start server i got error :

Mysql2::Error

Access denied for user 'root'@'localhost' (using password: NO)

how to solve this error,

veasna

[Carlos Mathiasen]

Maybe you should look the rails guides to resolve your problem[0]

TL:DR: You just need to update config/database.yml file with the correct authentication params for your MySQL server.

[0] http://guides.rubyonrails.org/v3.2.13/getting_started.html#configuring-a-mysql-database

Matt's

[Duong vong veasna]

Thanks Loganathan and Matt's Now it work.

veasna