Setup Windows 10 Discussion
Can you paste exactly what you added in the config/database.yml?
it should be exactly like this:
default: &default
host: localhost
adapter: postgresql
encoding: unicode
username: postgres
password: Password123
instead of Password123 put your password
this is everything from my database
PostgreSQL. Versions 9.3 and up are supported.
Install the pg driver:
gem install pg
On macOS with Homebrew:
gem install pg -- --with-pg-config=/usr/local/bin/pg_config
On macOS with MacPorts:
gem install pg -- --with-pg-config=/opt/local/lib/postgresql84/bin/pg_config
On Windows:
gem install pg
Choose the win32 build.
Install PostgreSQL and put its /bin directory on your path.
Configure Using Gemfile
gem "pg"
c
default: &default
host: localhost
adapter: postgresql
encoding: unicode
username: postgres
password: password
# For details on connection pooling, see Rails configuration guide
# https://guides.rubyonrails.org/configuring.html#database-pooling
pool: <%= ENV.fetch("RAILS_MAX_THREADS") { 5 } %>
development:
<<: *default
database: myapp_development
# The specified database role being used to connect to postgres.
# To create additional roles in postgres see $ createuser --help.
# When left blank, postgres will use the default role. This is
# the same name as the operating system user running Rails.
#username: myapp
# The password associated with the postgres role (username).
#password:
# Connect on a TCP socket. Omitted by default since the client uses a
# domain socket that doesn't need configuration. Windows does not have
# domain sockets, so uncomment these lines.
#host: localhost
# The TCP port the server listens on. Defaults to 5432.
# If your server runs on a different port number, change accordingly.
#port: 5432
# Schema search path. The server defaults to $user,public
#schema_search_path: myapp,sharedapp,public
# Minimum log levels, in increasing order:
# debug5, debug4, debug3, debug2, debug1,
# log, notice, warning, error, fatal, and panic
# Defaults to warning.
#min_messages: notice
Warning: The database defined as "test" will be erased and
re-generated from your development database when you run "rake".
Do not set this db to the same as development or production.
test:
<<: *default
database: myapp_test
As with config/credentials.yml, you never want to store sensitive information,
like your database password, in your source code. If your source code is
ever seen by anyone, they now have access to your database.
Instead, provide the password or a full connection URL as an environment
variable when you boot the app. For example:
DATABASE_URL="postgres://myuser:mypass@localhost/somedatabase"
If the connection URL is provided in the special DATABASE_URL environment
variable, Rails will automatically merge its configuration values on top of
the values provided in this file. Alternatively, you can specify a connection
URL environment variable explicitly:
production:
url: <%= ENV["MY_APP_DATABASE_URL"] %>
Read https://guides.rubyonrails.org/configuring.html#configuring-a-database
for a full overview on how database connection configuration can be specified.
production:
<<: *default
database: myapp_production
username: myapp
password: <%= ENV["MYAPP_DATABASE_PASSWORD"] %>
please help i have tried everything this is what i have
rake db:create
rake aborted!
ActiveRecord::DatabaseConfigurations::InvalidConfigurationError: '{ default => }' is not a valid configuration. Expected '' to be a URL string or a Hash.
/mnt/c/myapp/rakefile:6:in `'
(See full trace by running task with --trace)
edit please if someone reply my comment how do i know
PostgreSQL. Versions 9.1 and up are supported.
Install the pg driver:
gem install pg
On OS X with Homebrew:
gem install pg -- --with-pg-config=/usr/local/bin/pg_config
On OS X with MacPorts:
gem install pg -- --with-pg-config=/opt/local/lib/postgresql84/bin/pg_config
On Windows:
gem install pg
Choose the win32 build.
Install PostgreSQL and put its /bin directory on your path.
Configure Using Gemfile
gem 'pg'
default: &default
host: localhost
adapter: postgresql
encoding: unicode
username: postgres
password:
# For details on connection pooling, see Rails configuration guide
# http://guides.rubyonrails.org/configuring.html#database-pooling
pool: <%= ENV.fetch("RAILS_MAX_THREADS") { 5 } %>
development:
<<: *default
database: myapp_development
# The specified database role being used to connect to postgres.
# To create additional roles in postgres see $ createuser --help.
# When left blank, postgres will use the default role. This is
# the same name as the operating system user that initialized the database.
#username: myapp
# The password associated with the postgres role (username).
#password:
# Connect on a TCP socket. Omitted by default since the client uses a
# domain socket that doesn't need configuration. Windows does not have
# domain sockets, so uncomment these lines.
#host: localhost
# The TCP port the server listens on. Defaults to 5432.
# If your server runs on a different port number, change accordingly.
#port: 5432
# Schema search path. The server defaults to $user,public
#schema_search_path: myapp,sharedapp,public
# Minimum log levels, in increasing order:
# debug5, debug4, debug3, debug2, debug1,
# log, notice, warning, error, fatal, and panic
# Defaults to warning.
#min_messages: notice
Warning: The database defined as "test" will be erased and
re-generated from your development database when you run "rake".
Do not set this db to the same as development or production.
test:
<<: *default
database: myapp_test
As with config/secrets.yml, you never want to store sensitive information,
like your database password, in your source code. If your source code is
ever seen by anyone, they now have access to your database.
Instead, provide the password as a unix environment variable when you boot
the app. Read http://guides.rubyonrails.org/configuring.html#configuring-a-database
for a full rundown on how to provide these environment variables in a
production deployment.
On Heroku and other platform providers, you may have a full connection URL
available as an environment variable. For example:
DATABASE_URL="postgres://myuser:mypass@localhost/somedatabase"
You can use this database configuration with:
production:
url: <%= ENV['DATABASE_URL'] %>
production:
<<: *default
database: myapp_production
username: myapp
password: <%= ENV['APMANAGER_DATABASE_PASSWORD'] %>
just add your password
i have added my password unfortunately this is what i keep having
rake db:create
rake aborted!
ActiveRecord::DatabaseConfigurations::InvalidConfigurationError: '{ default => }' is not a valid configuration. Expected '' to be a URL string or a Hash.
/mnt/c/myapp/rakefile:6:in `'
(See full trace by running task with --trace)
Delete the my app folder and redo
rails new myapp -d postgresql
After just add the lines in config/database.yml
But don't modify anything else and respect the indentation
Last do
rails db:create
this is what i am having now thanks for your help so far
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
hi codrin thank you very much for your extensive help the other day it has finally work
hello who can help me
rake db:create
rake aborted!
ActiveRecord::DatabaseConfigurations::InvalidConfigurationError: '{ default => }' is not a valid configuration. Expected '' to be a URL string or a Hash.
/mnt/c/myapp/rakefile:6:in `'
(See full trace by running task with --trace)
It sounds like a common issue. Make sure nothing else is using port 3000, like another Rails server. Also, check your firewall settings; sometimes that can block local connections. Good luck! 😊