Ask A Question

Notifications

You’re not receiving notifications from this thread.

Setup Windows 10 Discussion

Chris Oliver asked in General

is there anything i can do

Reply

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

Reply

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"] %>

Reply

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

Reply

Can you paste all the database.yml file here I will correct it for you

Reply

i have paste it

Reply

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

Reply

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)

Reply

is there anything i can do

Reply

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

Reply

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
Reply

hi codrin thank you very much for your extensive help the other day it has finally work

Reply

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)

Reply
Join the discussion
Create an account Log in

Want to stay up-to-date with Ruby on Rails?

Join 84,256+ developers who get early access to new tutorials, screencasts, articles, and more.

    We care about the protection of your data. Read our Privacy Policy.