PG::ConnectionBad: FATAL: password authentication failed for user "deploy" capistrano rails
This might be late but I had the same error. First place to look at was in the environment variables. nano /home/deploy/myapp/.rbenv-varsThuba Mamba replied
Mysql2::Error::ConnectionError: Access denied for user 'root'@'localhost' (using password: NO)
Try this on your database.yml: default: &default adapter: mysql2 username: root password: socket: /tmp/mysql.sock Mysql usually come with auth_socket as default authentication plugin,...Elvis Serrão replied • Solved
I now have Postgres running on my local machine nicely. My issue now is i can't run a migration due to the following error: `ActiveRecord::StatementInvalid: PG::UndefinedTable: ERROR: relation "d...Tom Dringer replied
Trouble with a lending library query
No problem! Yea the states I had were much more and I ended up using the gem but your stuff works so glad I could help!Tabish Iqbal replied
How do I transfer content of production databse to my development database
Dear experts, I have a rails application that I was running on production environment. The data upon interacting with application on browser was therefore added to the production database. I wou...Shivam Barthwal posted
How to change de database of Sqlite3 to MongoDB on rails 5?
Hello guys i have a project Rails 5 with database sqlite3 and a lot scaffolds, but now i need change the databse for MongoDB, but the MongoDB dont use the active record. How i change this or remove...Thomaz Wanderbruck Schmidt posted
PG::InsufficientPrivilege: ERROR: permission denied to create extension "pgcrypto" HINT: Must be superuser to create this extension. : CREATE EXTENSION IF NOT EXISTS "pgcrypto"
For anyone having this issue in 2020, the problem is that the user `deploy` was not created with SUPERUSER privileges which are required to create/enable extensions in Postgres. In order to sol...Julio Cesar Fausto replied • Solved
Default Order of Associated Model Collection?
I know right?! Seriously amazing people here. Welcome to the group! 🤓Chris Oliver replied • Solved
I have a basic model structure like this: ``` class History < ActiveRecord::Base belongs_to :historical, polymorphic: true, touch: true end ``` with several related models: `has_m...Dan Tappin posted
How do I structure a Bookings table for two models?
I've primarly built out support to book a flight, and now I'm looking to offer the ability to book a hotel as well. I'm looking for some insight on the best way to model this: Currently there is...Taylor Cooney posted
If I am working on a db with millions of users and i have a job that requires updating multiple tables, what is the best way to approach this? I was thinking to wrap it in a transaction but the iss...Jacob Abraham posted
How do I manage business hours for a store?
Thanks @ChrisOliver. I got it working with your help! I really appreciate it, it seems rather trivial but a core function of my app - also, it seems like between the two of us we've provided the mo...Taylor Cooney replied • Solved
403 errors on Nginx server
Hello, I have installed ruby on rails on digital ocean with NGINX and Passanger. the site was working find but after trying to install free ssl, it goes full wrong. i was following this article...SMEHSAN posted
find_by not returning array but class insance
What am I missing please? class Choice < ApplicationRecord belongs_to :choiceable, polymorphic: true belongs_to :room_item, optional: false end create_table "choices", force: :cas...jason Mardell posted
How can I improve query time in SQL ? (PostgreSQL)
Any ?Boris Bresciani replied • Solved
TinyTds::Error (closed connection): when using Apache/Passenger
Hello Chris, I am only using Puma or Passenger, definitely not both at the same time. When using Puma I start the rails server (i.e rails s -e production) from the application directory and the pa...William Jones replied • Solved
Gem for Master-slave Replication
Hi, I'm trying to make master-slave replication(One master(write/read) and one slave(read only)) for my database(mysql 8 / rails 4.2). I researched whole day but I'm still considering which gem is ...Sean posted