amazon web services – Can’t Connect to an RDS from my home computer in AWS

I need to connect to an RDS from my home computer.

This is an established database, I’m migrating it to a new system.

I can not connect to it from my home computer.

I have set the security to Public Accessibility.

I’ve set VPC the Security rules to allows in bound connections.

What do I do next to debug it

RDS Screen
enter image description here
Security Groups
enter image description here
VPC
enter image description here


I’ve included information on the Subnet is that relevant?

enter image description here
enter image description here

mariadb – Ruby on Rails cannot access production RDS on AWS. Part 2

I can connect with Squirrel to my DB, which is created with rake db:create.
When I run rake db:migrate I get the error:

Caused by:
Mysql2::Error: Can't create table `gmrdb`.`comments` (errno: 150 "Foreign key constraint is incorrectly formed")

A GRANT ALL ON pfhp.gmrdb TO 'leder'@'%'; runs fine on squirrel, but does not change the error message in rails! Same for SET FOREIGN_KEY_CHECKS=0.

What to do to let rails create the tables? In development environment with sqlite3 it works!

This is my 20210525180118_create_comments.rb

class CreateComments < ActiveRecord::Migration(6.1)
  def change
    create_table :comments do |t|
      t.string :commenter
      t.text :body
      t.references :article, foreign_key: true

      t.timestamps
    end
  end
end

mysql – Ruby on Rails cannot access production RDS on AWS

The @'localhost' bit is certainly an issue as you’re connecting to a remote RDS instance, not one located in the same instance as your Rails code.

Instead you can do something like this:

GRANT PROCESS ON llpdn9i88kz3y837.* TO 'n8p1kzg1v9chfcny'@'%';

However, depending on what the Rails code may be doing during the setup phase, you may want to consider granting all privileges:

GRANT ALL ON llpdn9i88kz3y837.* TO 'n8p1kzg1v9chfcny'@'%';

After the system is installed and running, then you can reduce the privileges to just what is needed.

views – How do I manually set up RDS?

views – How do I manually set up RDS? – Drupal Answers

Drupal RDS set up

I am trying to set up Drupal RDS manually as well as through user data but facing the same error again and again. I am using the PHP 7.3 version for the drupal latest version. I tried increasing the size of the EC2 instance but still faced the same error. Can someone please help?Drupal RDS I have attached an image of the error as well.

amazon rds – Why ephemeral port been used when connect to AWS RDS?

Among multiple accounts in AWS, from one EC2 in account 1 connect RDS in account 2, from the VPC flow logs, got this message

2 023910321035 eni-12309fdsaj0jf012 ACCOUNT_1_EC2_IP ACCOUNT_2_RDS_IP 45052 31337 6 3 180 1619490209 1619490213 REJECT OK

The port 31337 hasn’t been opened but only the allowed db port 3306. Why it connected this unknown port first? How to diagnose it?

mysql 5.7 – Performance issues from RDS Aurora 5.6 to Aurora 5.7

Recently upgraded one of my RDS instances to aurora mysql 5.7 from 5.6 and I’ve had to triple the instance class while I try to resolve this (cpu eventually pegs and never declines).

Most reads are slow now (some about 30% slower, others are up to 400% slower). Looking at explain output, the queries are still using proper indexes. innodb_buffer_pool_size us set to default RDS value (instance class*3/24 I think) and most other innodb_* settings are not modifiable.

Here’s an example Mysql5.6:

| count(*) |
+----------+
| 20646739 |
+----------+
1 row in set (0.06 sec)

Mysql5.7:

mysql> select count(*) from nope;                                                                                                                                                                    +----------+
| count(*) |
+----------+
| 20646739 |
+----------+
1 row in set (3.77 sec)

Anyone else encounter this that can provide some insight into some setting I can tweak?

Multiple logon failure on RDS Windows 2012 R2 Server

We have RDS server setup on the Azure cloud and published few apps through RDWeb, all the remote user are being authenticated through AD it is on the same RDS server. I have been noticing the multiple logon attempt on my RDS server and following the are events logged on the Trend Micro Deep Security IPS. Strange thing is it is using RDS server loopback IPv6 address and hostname as the username to connect and I have observed events being logged every 9 minutes during working hours and non working hours it is hourly once.

Description:    Multiple Windows Logon Failures
Rank:   50 = Asset Value x Severity Value = 1 x 50
Severity:   High (10)
Groups: windows,authentication_failures,
Program Name:   
Event:  WinEvtLog: Security: AUDIT_FAILURE(4625): Microsoft-Windows-Security-Auditing: (no user): no domain: *******: An account failed to log on. 
Subject: Security ID: S-1-0-0 Account Name: - Account Domain: - Logon ID: 0x0 Logon Type: 3 Account For Which Logon Failed: Security ID: S-1-0-0 Account Name: ******* Account Domain: SAAS 
Failure Information: Failure Reason: %%2313 Status: 0xc000006d Sub Status: 0xc0000064 Process Information: Caller Process ID: 0x0 Caller 
Process Name: - Network Information: Workstation Name: ******* Source Network Address: LOOPBACK IPV6 address Source Port: 56396 
Detailed Authentication Information: Logon Process: NtLmSsp 
Authentication Package: NTLM Transited Services: - Package Name (NTLM only): - Key Length: 0 This event is generated when a logon request fails. 
It is generated on the computer where access was attempted.

If anyone come across such situation please share your fix. Thanks in advance.

postgresql – Same query taking different execution times on equivalent RDS instances

The train table has around 60million records all of which have their updated_at timestamp in the year 2021. The schema of the table is as below.

                         Table "public.train"
     Column     |            Type             | Collation | Nullable | Default 
----------------+-----------------------------+-----------+----------+---------
 id             | uuid                        |           | not null | 
 updated_at     | timestamp without time zone |           | not null | 
 status         | task_status                 |           | not null | 
 status_details | json                        |           |          | 
Indexes:
    "train_id_updated_at_key" UNIQUE CONSTRAINT, btree (id, updated_at)

I have created a temp table train_temp with the same schema but partitioned on updated_at with Partition key: RANGE (date(updated_at))

I ran the below query to add the train table as a partition to train_temp in an RDS instance that is connected to the application server.

  ALTER TABLE train_temp ATTACH partition train FOR VALUES FROM ('2021-01-01') to ('2022-01-01');

The query takes around 5 minute.

Before running the query I had taken a snapshot of the RDS instance. I restored the snapshot on a couple of instances with the same configurations as the original RDS instance.

But when I run the query in the new instances the query takes around 1hr which is very bizarre since it is the same data in an equivalent instance.

Because of the uncertainty in the execution time, I am not able to come up with a concrete plan on how I could take this to production.

Any help would be much appreciated.

postgresql – Can we check server specification using postgres query in aws RDS?

I deployed an app from dev to production server. The dev and prod has same RAM, but we use RDS as database server on production server. But I feel slower performance in production database. I don’t have any cred to AWS Console, but I need to know what is the server specification like RAM and CPU of the Postgres RDS. Can I know it using SQL query?

DreamProxies - Cheapest USA Elite Private Proxies 100 Private Proxies 200 Private Proxies 400 Private Proxies 1000 Private Proxies 2000 Private Proxies ExtraProxies.com - Buy Cheap Private Proxies Buy 50 Private Proxies Buy 100 Private Proxies Buy 200 Private Proxies Buy 500 Private Proxies Buy 1000 Private Proxies Buy 2000 Private Proxies ProxiesLive Proxies-free.com New Proxy Lists Every Day Proxies123