Setup Windows 10 Discussion
Small newbie error occurred for me. I got "git@github.com: Permission denied (publickey)." There were two problems. There was a prompt that had asked me for a name for the file for the generated key. I didn't know that this had to be a particular name, so I made up my own name. Also, the two files created were placed in the wrong folder. So I moved the files that I renamed to id_rsa.pub and id_rsa from my home directory to the folder /.ssh and then tried to connect again. This time I was successful.
Hello, I was following the instruction here. When I created a new app:
rails new myapp -d postgresql
It created the "myapp" application without the config directory. In addition, when I installed the dependencies for Ruby, these two commands:
libreadline-dev libyaml-dev libsqlite3-dev sqlite3 libxml2-dev libxslt1-dev
libcurl4-openssl-dev software-properties-common libffi-dev
are not found (according to the terminal. All I did was "copy and paste" these commands, so there wasn't any potential typos there)
Because I later installed PostgreSQL, so hopefully, the command above for sqlite3 is not that necessary but the one for openSSL remains a concern.
Also, when I ran: rake db:create
rake aborted!
LoadError: cannot load such file -- /mnt/c/myapp/config/application
/mnt/c/myapp/rakefile:4:in require_relative''
/mnt/c/myapp/rakefile:4:in
Someone on this board suggests that "application" be changed to "application.rb" in Rakefile, I tried that but it didn't help. Also, my application was created with the config directory missing :-)
Sorry for multiple problems. Any help will be much appreciated. Thanks!
Your issues probably stem from the fact you don't have those dependencies. What's your Ubuntu version? Have you tried sudo apt update and sudo apt install libreadline-dev libyaml-dev libsqlite3-dev sqlite3 libxml2-dev libxslt1-dev?
libcurl4-openssl-dev software-properties-common libffi-dev
Elijah, I appreciate your prompt assistance! I was able to run the above two commands ... However, when creating a new rails app:
rails new myapp -d postgresql
It seemed to have a file and directory permission issue that prevents the rest of the myapp directory from being created (please see below):
from ~/.rbenv/versions/3.0.2/lib/ruby/3.0.0/fileutils.rb:1346:in chmod': Operation not permitted @ apply2files - /mnt/c/code/myapp/bin (Errno::EPERM)chmod'
from ~/.rbenv/versions/3.0.2/lib/ruby/3.0.0/fileutils.rb:1346:in
from ~/.rbenv/versions/3.0.2/lib/ruby/3.0.0/fileutils.rb:1038:in block (2 levels) in chmod_R'preorder_traverse'
from ~/.rbenv/versions/3.0.2/lib/ruby/3.0.0/fileutils.rb:1493:in
from ~/.rbenv/versions/3.0.2/lib/ruby/3.0.0/fileutils.rb:1036:in block in chmod_R'each'
from ~/.rbenv/versions/3.0.2/lib/ruby/3.0.0/fileutils.rb:1035:in
from ~/.rbenv/versions/3.0.2/lib/ruby/3.0.0/fileutils.rb:1035:in chmod_R'chmod'
from ~/.rbenv/versions/3.0.2/lib/ruby/gems/3.0.0/gems/thor-1.1.0/lib/thor/actions/file_manipulation.rb:154:in
...
I did set: chmod 700 fileutils.rb
I even set: chmod 777 ruby (on the ruby directory) but neither helped.
Any idea ? Thanks!
I assume you're using WSL, which can cause a bug where files can be owned by root instead of your user. Try restarting your computer and see if WSL fixes itself, or check who actually owns the folder with ls -al. sudo chown -R your_wsl_user myapp should work.
Finally, check if the attributes of myapp aren't immutable. Change them if they are (chattr -R -ia myapp).
Elijah, you are the man! Indeed, restarting my computer made a big difference. I was able to create a new rails app with everything in it. The problem I'm facing right now is that when I ran
rake db:create
FATAL: password authentication failed for user "xyz"
Couldn't create 'myapp_development' database. Please check your configuration.
rake aborted!
I don't recall I was asked to set a password during the installation of PostgreSQL, so in the database.yml, I specified the same username and password as those I used for creating the Window sub-system for Linux. Long story short, I have spent a good amount of time searching on Google and have tried various methods but none have worked so far. I'm almost there. A few questions for you:
How do I set a new password for the existing username (assuming it recognizes the existing username) in PostgreSQL ?
How do I set a new username and a new password in PostgreSQL ?
Should I (not) store the password in plain text in the database.yml or encript it in someway ?
Many thanks for your kind assistance so far !
I got it. My Ruby on Rails app is up and running now. Thanks again!
Glad to know you got it working! I know you asked about how to secure your password in database.yml. Passwords must be provided as-is in that file, but you could use environment variables. You can define your password in .env as export POSTGRES_UPASSWORD='password' and then refer to it with <%= ENV['POSTGRES_UPASSWORD'] %>. The problem with this approach is that you're just passing off your password to .env and really it only works if you're working with other people. Malicious code could still steal your environment variables. If you're willing to set up a server, you could set up another server for PostgreSQL and secure it, only allowing your IP address to connect. That way, even if they had the password, it's no good. Of course, then you need to keep your SSH keys secure.
The truth is that there's no good way to protect against an attack other than practicing good security on your machine.
Hello again
I would like to be able to run rails commands from within the Visual Studio Code built-in terminal. They work fine on WSL terminals but I prefer to run them from within the VS code terminal. So when I ran something like "rails console" in VS Code, it said "The term 'rails' is not recognized as the name of a cmdlet, function, script file, or operable program ..." Upon some research on Google, someone suggests that the path to the rails/bin directory be added as an environmental variable. This is actually not hard. The hard part is to figure out where in the world rails was installed on WSL :-), can't find it. I know that my WSL was installed in C:\Users\tommy\AppData\Local\Packages but can't find the rails directory in Packages. Any idea ? Thanks again !
The reason why is because in VS Code it by default uses either PWSH/Command Prompt for commands (I don't know, but for me it's PWSH). You need to change it to WSL by clicking the plus icon to the right of the tabs in the terminal window and add "WSL". If it doesn't appear, you may need to get the Remote Development extension and use it that way. Your Rails installation is managed through WSL so adding it as an environment variable wouldn't work.
Elijah, you are the man (again) ! It worked, thanks a lot !
When running rake db:create
I get this error
could not connect to server: No such file or directory
Is the server running locally and accepting
connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"?
Couldn't create 'myapp_development' database. Please check your configuration.
rake aborted!
ActiveRecord::NoDatabaseError: could not connect to server: No such file or directory
Is the server running locally and accepting
connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"?
Caused by:
PG::ConnectionBad: could not connect to server: No such file or directory
Is the server running locally and accepting
connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"?
Tasks: TOP => db:create
(See full trace by running task with --trace)
How do i fix this?
Good article thanks... without it, I would be stuck for a week. I wasted 5 hours trying to get windows, ruby, rails and intellij IDEA to play together and gave up. I hit a few snags on this mostly at the end due to different ubunutu and ubuntu LTS (whatever that is) being installed and also there was some wierd issue with WSL not enabling systemctl by default, wtf? oh well, I have a working server so thanks. Wish they would make and keep up to date a good yum/rpm and windows installers, standup time is important for any software, but still re-learning ruby so...
PLEASE KEEP ARTICLE UP TO DATE AND REVERSE COMPATIBLE OR WE WILL ALL BE STUCK, LOL, THANKS!
anyone got it working? if yes, maybe post your conf, im on win 11, all good till rake db:create PG::ConnectionBad: could not connect to server: Connection refused
Is the server running on host "127.0.0.1" and accepting
TCP/IP connections on port 5432?
i modified the postgres conf to listen to wls ip, but im stuck here, reading a lot of copy paste articles, all sayin u need to start postgres service, but thats a nonsense if u use it in windows, anyway, im stuck here, any help is welcome.
Hi,
I'm new in this programming language, installed ruby on rails by completing every step shown up here. When I create a simple project it is working fine but when I create a project with tailwindcss it is throwing error like this:
- /home/mirkomilboy/.rbenv/versions/3.1.2/lib/ruby/gems/3.1.0/gems/tailwindcss-rails-2.0.12-x86_64-linux/exe/x86_64-linux/tailwindcss -i /mnt/c/rubyonrails/test-app/app/assets/stylesheets/application.tailwind.css -o /mnt/c/rubyonrails/test-app/app/assets/builds/tailwind.css -c /mnt/c/rubyonrails/test-app/config/tailwind.config.js --minify /home/mirkomilboy/.rbenv/versions/3.1.2/lib/ruby/gems/3.1.0/gems/tailwindcss-rails-2.0.12-x86_64-linux/exe/x86_64-linux/tailwindcss: 1: ELF: not found
/home/mirkomilboy/.rbenv/versions/3.1.2/lib/ruby/gems/3.1.0/gems/tailwindcss-rails-2.0.12-x86_64-linux/exe/x86_64-linux/tailwindcss: 4: Syntax error: word unexpected (expecting ")")
rails aborted!
Command failed with exit 2: /home/mirkomilboy/.rbenv/versions/3.1.2/bin/ruby /home/mirkomilboy/.rbenv/versions/3.1.2/lib/ruby/gems/3.1.0/gems/tailwindcss-rails-2.0.12-x86_64-linux/lib/tasks/../../exe/tailwindcss -i '/mnt/c/rubyonrails/test-app/app/assets/stylesheets/application.tailwind.css' -o '/mnt/c/rubyonrails/test-app/app/assets/builds/tailwind.css' -c '/mnt/c/rubyonrails/test-app/config/tailwind.config.js' --minify
I've done some research but could not solve the issue. Can anyone help me with this? Thanks in advance!
hello guys please i need your help
zainab@DESKTOP-6EV5CHP:/mnt/c/myapp$ rake db:create
rake aborted!
LoadError: cannot load such file -- /mnt/c/myapp/config/application
/mnt/c/myapp/rakefile:4:in require_relative''
/mnt/c/myapp/rakefile:4:in
(See full trace by running task with --trace)
zainab@DESKTOP-6EV5CHP:/mnt/c/myapp$
zainab@DESKTOP-6EV5CHP:/mnt/c/myapp$ rails server
bin/rails:3:in require_relative': cannot load such file -- /mnt/c/myapp/config/boot (LoadError)
from bin/rails:3:in
zainab@DESKTOP-6EV5CHP:/mnt/c/myapp$ rake db:create
rake aborted!
LoadError: cannot load such file -- /mnt/c/myapp/config/application
/mnt/c/myapp/rakefile:4:in
require_relative'
/mnt/c/myapp/rakefile:4:in'(See full trace by running task with --trace)
zainab@DESKTOP-6EV5CHP:/mnt/c/myapp$
this is the problem i am facing while trying to create a rake db
please can anyone help me
zainab@DESKTOP-6EV5CHP:/mnt/c$ rails new myapp -d postgresql
create
create README.md
create Rakefile
create .ruby-versionwill be installed:
create config.ru
create .gitignorealled, 0 to remove and 171 not upgraded.
create .gitattributeses.
create Gemfile 1001 kB of additional disk space will be used.
run git init from "."y
error: chmod on /mnt/c/myapp/.git/config.lock failed: Operation not permitted12.13-0ubuntu0.20.04.1 [118 kB]
fatal: could not set 'core.filemode' to 'false'dates/main amd64 libpq-dev amd64 12.13-0ubuntu0.20.04.1 [137 kB]
fatal: not a git repository (or any parent up to mount point /mnt)
Stopping at filesystem boundary (GIT_DISCOVERY_ACROSS_FILESYSTEM not set).
create app
create app/assets/config/manifest.js
create app/assets/stylesheets/application.css
create app/channels/application_cable/channel.rb
create app/channels/application_cable/connection.rb
create app/controllers/application_controller.rb
create app/helpers/application_helper.rb
create app/jobs/application_job.rb
create app/mailers/application_mailer.rb
create app/models/application_record.rb
create app/views/layouts/application.html.erb
create app/views/layouts/mailer.html.erb
create app/views/layouts/mailer.text.erb
create app/assets/images
create app/assets/images/.keep
create app/controllers/concerns/.keep
create app/models/concerns/.keep
create bin
create bin/rails
create bin/rake
create bin/setup
/home/zainab/.rbenv/versions/3.2.0/lib/ruby/3.2.0/fileutils.rb:2222:in chmod': Operation not permitted @ apply2files - /mnt/c/myapp/bin (Errno::EPERM)chmod'
from /home/zainab/.rbenv/versions/3.2.0/lib/ruby/3.2.0/fileutils.rb:2222:in
from /home/zainab/.rbenv/versions/3.2.0/lib/ruby/3.2.0/fileutils.rb:1836:in block (2 levels) in chmod_R'preorder_traverse'
from /home/zainab/.rbenv/versions/3.2.0/lib/ruby/3.2.0/fileutils.rb:2369:in
from /home/zainab/.rbenv/versions/3.2.0/lib/ruby/3.2.0/fileutils.rb:1834:in block in chmod_R'each'
from /home/zainab/.rbenv/versions/3.2.0/lib/ruby/3.2.0/fileutils.rb:1833:in
from /home/zainab/.rbenv/versions/3.2.0/lib/ruby/3.2.0/fileutils.rb:1833:in chmod_R'chmod'
from /home/zainab/.rbenv/versions/3.2.0/lib/ruby/gems/3.2.0/gems/thor-1.2.1/lib/thor/actions/file_manipulation.rb:154:in
from /home/zainab/.rbenv/versions/3.2.0/lib/ruby/gems/3.2.0/gems/railties-7.0.4/lib/rails/generators/rails/app/app_generator.rb:19:in chmod'bin'
from /home/zainab/.rbenv/versions/3.2.0/lib/ruby/gems/3.2.0/gems/railties-7.0.4/lib/rails/generators/rails/app/app_generator.rb:95:in
from /home/zainab/.rbenv/versions/3.2.0/lib/ruby/gems/3.2.0/gems/railties-7.0.4/lib/rails/generators/app_base.rb:134:in public_send'build'
from /home/zainab/.rbenv/versions/3.2.0/lib/ruby/gems/3.2.0/gems/railties-7.0.4/lib/rails/generators/app_base.rb:134:in
from /home/zainab/.rbenv/versions/3.2.0/lib/ruby/gems/3.2.0/gems/railties-7.0.4/lib/rails/generators/rails/app/app_generator.rb:336:in create_bin_files'run'
from /home/zainab/.rbenv/versions/3.2.0/lib/ruby/gems/3.2.0/gems/thor-1.2.1/lib/thor/command.rb:27:in
from /home/zainab/.rbenv/versions/3.2.0/lib/ruby/gems/3.2.0/gems/thor-1.2.1/lib/thor/invocation.rb:127:in invoke_command'block in invoke_all'
from /home/zainab/.rbenv/versions/3.2.0/lib/ruby/gems/3.2.0/gems/thor-1.2.1/lib/thor/invocation.rb:134:in
from /home/zainab/.rbenv/versions/3.2.0/lib/ruby/gems/3.2.0/gems/thor-1.2.1/lib/thor/invocation.rb:134:in each'map'
from /home/zainab/.rbenv/versions/3.2.0/lib/ruby/gems/3.2.0/gems/thor-1.2.1/lib/thor/invocation.rb:134:in
from /home/zainab/.rbenv/versions/3.2.0/lib/ruby/gems/3.2.0/gems/thor-1.2.1/lib/thor/invocation.rb:134:in invoke_all'dispatch'
from /home/zainab/.rbenv/versions/3.2.0/lib/ruby/gems/3.2.0/gems/thor-1.2.1/lib/thor/group.rb:232:in
from /home/zainab/.rbenv/versions/3.2.0/lib/ruby/gems/3.2.0/gems/thor-1.2.1/lib/thor/base.rb:485:in start'perform'
from /home/zainab/.rbenv/versions/3.2.0/lib/ruby/gems/3.2.0/gems/railties-7.0.4/lib/rails/commands/application/application_command.rb:26:in
from /home/zainab/.rbenv/versions/3.2.0/lib/ruby/gems/3.2.0/gems/thor-1.2.1/lib/thor/command.rb:27:in run'invoke_command'
from /home/zainab/.rbenv/versions/3.2.0/lib/ruby/gems/3.2.0/gems/thor-1.2.1/lib/thor/invocation.rb:127:in
from /home/zainab/.rbenv/versions/3.2.0/lib/ruby/gems/3.2.0/gems/thor-1.2.1/lib/thor.rb:392:in dispatch'perform'
from /home/zainab/.rbenv/versions/3.2.0/lib/ruby/gems/3.2.0/gems/railties-7.0.4/lib/rails/command/base.rb:87:in
from /home/zainab/.rbenv/versions/3.2.0/lib/ruby/gems/3.2.0/gems/railties-7.0.4/lib/rails/command.rb:48:in invoke''
from /home/zainab/.rbenv/versions/3.2.0/lib/ruby/gems/3.2.0/gems/railties-7.0.4/lib/rails/cli.rb:18:in
from internal:/home/zainab/.rbenv/versions/3.2.0/lib/ruby/3.2.0/rubygems/core_ext/kernel_require.rb:85:in require'require'
from <internal:/home/zainab/.rbenv/versions/3.2.0/lib/ruby/3.2.0/rubygems/core_ext/kernel_require.rb>:85:in
from /home/zainab/.rbenv/versions/3.2.0/lib/ruby/gems/3.2.0/gems/railties-7.0.4/exe/rails:10:in <top (required)>'load'
from /home/zainab/.rbenv/versions/3.2.0/bin/rails:25:in
from /home/zainab/.rbenv/versions/3.2.0/bin/rails:25:in <main>'require_relative'
zainab@DESKTOP-6EV5CHP:/mnt/c$ cd myapp
zainab@DESKTOP-6EV5CHP:/mnt/c/myapp$ rake db:create
rake aborted!
LoadError: cannot load such file -- /mnt/c/myapp/config/application
/mnt/c/myapp/rakefile:4:in
/mnt/c/myapp/rakefile:4:in <top (required)>'require_relative': cannot load such file -- /mnt/c/myapp/config/boot (LoadError)
(See full trace by running task with --trace)
zainab@DESKTOP-6EV5CHP:/mnt/c/myapp$
zainab@DESKTOP-6EV5CHP:/mnt/c/myapp$ rails server
bin/rails:3:in
from bin/rails:3:in <main>'require_relative'
zainab@DESKTOP-6EV5CHP:/mnt/c/myapp$ rake db:create
rake aborted!
LoadError: cannot load such file -- /mnt/c/myapp/config/application
/mnt/c/myapp/rakefile:4:in
/mnt/c/myapp/rakefile:4:in `'
(See full trace by running task with --trace)
zainab@DESKTOP-6EV5CHP:/mnt/c/myapp$ rails new myapp -d postgresql
I’ve got identical issue following from that guide on Win10 WSL.
And i found this issue may be solved with Chmod/Chown WSL Improvements
https://devblogs.microsoft.com/commandline/chmod-chown-wsl-improvements/ 32
Use
sudo umount /mnt/c sudo mount -t drvfs C: /mnt/c -o metadata
to change /mnt/c setting and it works for me
*You must delete files from incomplete rails new command first
hi codrin thanks for your reply but i don't seem to understand please can you elaborate it a bit
please i have done everything this is what i have againzainab@DESKTOP-6EV5CHP:/mnt/c/Windows/system32/myapp$ rake db:create
We could not find your database: postgres. Which can be found in the database configuration file located at config/database.yml.
To resolve this issue:
- Did you create the database for this app, or delete it? You may need to create your database.
- Has the database name changed? Check your database.yml config has the correct database name.
To create your database, run:
bin/rails db:create
Couldn't create 'myapp_development' database. Please check your configuration.
rake aborted!
ActiveRecord::NoDatabaseError: We could not find your database: postgres. Which can be found in the database configuration file located at config/database.yml.
To resolve this issue:
- Did you create the database for this app, or delete it? You may need to create your database.
- Has the database name changed? Check your database.yml config has the correct database name.
To create your database, run:
bin/rails db:create
Caused by:
PG::ConnectionBad: could not connect to server: No such file or directory
Is the server running locally and accepting
connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"?
Tasks: TOP => db:create
(See full trace by running task with --trace)
Hi Zainab, first in file explorer go to C:/ and delete myapp folder.
Then open terminal or cmd what whever you use for WSL and paste this command:
sudo umount /mnt/c sudo mount -t drvfs C: /mnt/c -o metadata
After try again:
rails new myapp -d postgresql
It should work
thank you very much for your reply but this is what i have
zainab@DESKTOP-6EV5CHP:/mnt/c/myapp$ rake db:create
We could not find your database: postgres. Which can be found in the database configuration file located at config/database.yml.
To resolve this issue:
- Did you create the database for this app, or delete it? You may need to create your database.
- Has the database name changed? Check your database.yml config has the correct database name.
To create your database, run:
bin/rails db:create
Couldn't create 'myapp_development' database. Please check your configuration.
rake aborted!
ActiveRecord::NoDatabaseError: We could not find your database: postgres. Which can be found in the database configuration file located at config/database.yml.
To resolve this issue:
- Did you create the database for this app, or delete it? You may need to create your database.
- Has the database name changed? Check your database.yml config has the correct database name.
To create your database, run:
bin/rails db:create
Caused by:
PG::ConnectionBad: could not connect to server: No such file or directory
Is the server running locally and accepting
connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"?
Tasks: TOP => db:create
(See full trace by running task with --trace)
zainab@DESKTOP-6EV5CHP:/mnt/c/myapp$
zainab@DESKTOP-6EV5CHP:/mnt/c/myapp$ rails server
=> Booting Puma
=> Rails 7.0.4.2 application starting in development
=> Run bin/rails server --help for more startup options
Puma starting in single mode...
- Puma version: 5.6.5 (ruby 3.2.0-p0) ("Birdie's Version")
- Min threads: 5
- Max threads: 5
- Environment: development
- PID: 138
- Listening on http://127.0.0.1:3000
- Listening on http://[::1]:3000 Use Ctrl-C to stop C- Gracefully stopping, waiting for requests to finish === puma shutdown: 2023-02-05 08:21:21 +0000 ===
- Goodbye! Exiting zainab@DESKTOP-6EV5CHP:/mnt/c/myapp$
You need to add the database credentials
open your editor (eg, Atom, Visual Code ... ) in the myapp app folder, go to config/database.yml find this lines
default: &default
host: localhost #add this line
adapter: postgresql
encoding: unicode
username: postgres #add this line
password: "put your password from the Postgresql install" #add this line
and then do:
rails db:create
in your terminal
default: &default
adapter: postgresql
encoding: unicode
# For details on connection pooling, see Rails configuration guide
# https://guides.rubyonrails.org/configuring.html#database-pooling
is this what you are talking about
pool: <%= ENV.fetch("RAILS_MAX_THREADS") { 5 } %>
yes add the lines
host: localhost
username: postgres
`password: your password #here put your password from the Postgresql install
hello codrin i am really sorry for disturbing you and thank you very much for your help this is what i have again
zainab@DESKTOP-6EV5CHP:/mnt/c/myapp$ rake db:create
Rails couldn't infer whether you are using multiple databases from your database.yml and can't generate the tasks for the non-primary databases. If you'd like to use this feature, please simplify your ERB.
rake aborted!
Cannot load database configuration:
YAML syntax error occurred while parsing /mnt/c/myapp/config/database.yml. Please note that YAML must be consistently indented using spaces. Tabs are not allowed. Error: (): mapping values are not allowed in this context at line 19 column 10
Caused by:
Psych::SyntaxError: (): mapping values are not allowed in this context at line 19 column 10
Tasks: TOP => db:create => db:load_config
(See full trace by running task with --trace)