Stack Overflow
Stack Overflow

Questions tagged [rds]

This tag might refer to Microsoft Remote Desktop Services, Microsoft Robotics Developer Studio, or Microsoft Remote Data Service. For Amazon RDS, please use the [tag:amazon-rds] tag instead.

This tag might refer to Microsoft Remote Desktop Services, Microsoft Robotics Developer Studio, or Microsoft Remote Data Service. For Amazon RDS, please use the tag instead.

For more info, please visit:

821 questions
5
votes
0 answers

Parameter group for SET GLOBAL foreign_key_checks in RDS

I am using RDS AWS for my mysql instance. Currently, i need to set global foreign_key_checks in RDS. but it says that I need a super priviledge access to do so. I realise I might miss to set the parameter group for this command. Could I know how to…
Robert Limanto
  • 1,648
  • 3
  • 14
  • 27
5
votes
2 answers

RDS PostgreSQL: General error: 7 SSL error: invalid key length

Sometimes I catch an error from RDS PostgreSQL. SQLSTATE[HY000]: General error: 7 SSL error: invalid key length Usually it works fine, but sometimes the error. What could it be? Any ideas? Engine: PostgreSQL 9.4.1 Certificate Authority: rds-ca-2015…
Tigrov
  • 51
  • 5
5
votes
2 answers

Using amazon RDS with WordPress over SSL

I'm migrating our WordPress database to RDS which is also being used by other services in our infrastructure. But I couldn't find any configuration option for wp-config.php where I could specify that SSL to be used while connecting to the server.…
Jai Pandya
  • 1,509
  • 13
  • 25
5
votes
2 answers

Amazon RDS w/ SQL Server wont allow bulk insert from CSV source

I've tried two methods and both fall flat... BULK INSERT TEMPUSERIMPORT1357081926 FROM 'C:\uploads\19E0E1.csv' WITH (FIELDTERMINATOR = ',',ROWTERMINATOR = '\n') You do not have permission to use the bulk load statement. but you cannot enable…
chris
  • 585
  • 1
  • 7
  • 25
5
votes
2 answers

Accessing RDS With SSL - Unsupported record version Unknown-0.0

I am using Amazon RDS MySQL and connecting with SSL certificate(the default certificate available at http://s3.amazonaws.com/rds-downloads/mysql-ssl-ca-cert.pem), I am doing the following steps: Downloaded the mysql-ssl-ca-cert.pem Modified the…
R.G.Karthic Balaji
  • 69
  • 1
  • 4
5
votes
2 answers

Create local copy of Amazon RDS Database

How do I mysqldump the database on my AWS RDS instance to a .sql file for local use?
CaptainStiggz
  • 1,472
  • 3
  • 21
  • 42
4
votes
3 answers

Is there a way to have AWS RDS Public Accessibility = No but still accessible outside of EC2 instance?

For management-related reasons, I need the Public Accessibility option set to "No" for the RDS. However, we're also looking into being able to access the RDS from our local devices. The only way we're able to do so is by selecting "Yes" in Public…
ZekiraDrake
  • 85
  • 1
  • 8
4
votes
1 answer

RDS - 1205 lock wait timeout exceeded try restarting transaction

In Amazon-RDS I have table where insertion occurs automatically by python code, it works but sometimes the insertion stops and when i see the log it shows "lock wait timeout exceeded try restarting transaction" its happening randomly. the size of my…
SaiSivaSubramanian L
  • 129
  • 8
4
votes
0 answers

.NET/MYSQL RDS: Intermittent Issue A call to SSPI failed, see inner exception, he message or signature supplied for verification has been altered

Seeing this error seemingly randomly (never been able to recreate): Intermittent A call to SSPI failed, see inner exception, he message or signature supplied for verification has been altered .net 4.5 connecting to MYSQL 5.7.21 on RDS. Is this an…
YouCantGetThereFromHere
  • 41
  • 4
4
votes
1 answer

pricing encrypting RDS with KMS

i want to encrypt my RDS instance from Amazon Web Service but i dont know the explanation of the pricing. It says that each API request of AWS Key Management Service costs $0.03 per 10,000 requests. Every query means an API request or every…
mgg
  • 151
  • 1
  • 6
4
votes
1 answer

How everyone monitor RDS PostgreSQL error log?

I'm new to RDS and previously have been administrated non-cloud database. It's common monitor database error log and monitors the texts. But when it comes to RDS Postgres, there is no native service that monitors log file. (I know now RDS…
user6151327
4
votes
1 answer

PostgreSQL RDS avoid hard coding the connection password when using dblink_connect()

I have an AWS RDS instance of PostgreSQL in which I need to execute an SQL statement within a function using dblink_connect(text) and dblink_exec(text) while logged in with the postgres role (that I created). CREATE OR REPLACE FUNCTION…
Neoheurist
  • 2,236
  • 3
  • 25
  • 47
4
votes
0 answers

How to create a proxy connection on mysql workbench

My company is using http proxy connection to connect through the internet. I am trying to connect to my RDS MySQL instance on AWS by using MySQL Workbench. However, I get failed error. I need to configure my workbench to connect through my company…
Fady Berty
  • 41
  • 1
  • 5
4
votes
1 answer

I have to use replica of AWS RDS, How should I set the django setting?

My Django application has to read RDS (maridadb) a lot. So I thought, how I solve this performance problem? RDS has a replica. I want to set Django to use multi DB. How can I do this?
hahaha
  • 1,151
  • 2
  • 10
  • 20
4
votes
1 answer

RDS Security Permissions to Allow Public Read/Write and Private Admin

I am trying to configure my RDS Security Group configurations to be able to allow my EC2 instance to read and write to the database, but only admin access the DB via login credentials. Will my setup below achieve this? Should the admin access only…
cphill
  • 4,286
  • 10
  • 62
  • 137
1 2 3
…
54 55