Connecting website to AWS RDS HTTP Error 500?
I've moved my Drupal website over to AWS (using an EC2 instance and RDS instance). Everything moved over just fine. However, when I try and connect my drupal installation to my RDS database via the settings.php file, I get the following message when I navigate to my site IP:
This page isn’t working [public ip] is currently unable to handle this request. HTTP ERROR 500
Right now, I'm putting my RDS endpoint into the settings.php file's 'host' spot.
$databases = array (
'default' =>
array (
'default' =>
array (
'database' => 'mydbname',
'username' => 'mydbusername',
'password' => 'mypassword',
'host' => 'myrdsendpoint.us-east-2.rds.amazonaws.com',
'port' => '3306',
'driver' => 'mysql',
'prefix' => '',
),
),
);
When I leave the host blank, I do however get a Drupal error (as I should). That said, why am I unable to connect to the AWS RDS endpoint? I've even given my EC2 instance's private IP permission to access MySQL in the RDS' security group.
Something to note: When I do a fresh drupal install with the same above specs in the settings.php file, the new drupal site works perfectly (is visible). Could the 500 error be because my instance isn't large enough (e.g. do I need more space or memory?)
Help.
amazon-web-services amazon-rds
add a comment |
I've moved my Drupal website over to AWS (using an EC2 instance and RDS instance). Everything moved over just fine. However, when I try and connect my drupal installation to my RDS database via the settings.php file, I get the following message when I navigate to my site IP:
This page isn’t working [public ip] is currently unable to handle this request. HTTP ERROR 500
Right now, I'm putting my RDS endpoint into the settings.php file's 'host' spot.
$databases = array (
'default' =>
array (
'default' =>
array (
'database' => 'mydbname',
'username' => 'mydbusername',
'password' => 'mypassword',
'host' => 'myrdsendpoint.us-east-2.rds.amazonaws.com',
'port' => '3306',
'driver' => 'mysql',
'prefix' => '',
),
),
);
When I leave the host blank, I do however get a Drupal error (as I should). That said, why am I unable to connect to the AWS RDS endpoint? I've even given my EC2 instance's private IP permission to access MySQL in the RDS' security group.
Something to note: When I do a fresh drupal install with the same above specs in the settings.php file, the new drupal site works perfectly (is visible). Could the 500 error be because my instance isn't large enough (e.g. do I need more space or memory?)
Help.
amazon-web-services amazon-rds
Is your RDS instance in the same VPC as the EC2 instance ? The reason I ask because you have allowed EC2 private IP in RDS security group. What do your app logs show for the front end 500 error ?
– ben5556
Nov 15 '18 at 19:38
add a comment |
I've moved my Drupal website over to AWS (using an EC2 instance and RDS instance). Everything moved over just fine. However, when I try and connect my drupal installation to my RDS database via the settings.php file, I get the following message when I navigate to my site IP:
This page isn’t working [public ip] is currently unable to handle this request. HTTP ERROR 500
Right now, I'm putting my RDS endpoint into the settings.php file's 'host' spot.
$databases = array (
'default' =>
array (
'default' =>
array (
'database' => 'mydbname',
'username' => 'mydbusername',
'password' => 'mypassword',
'host' => 'myrdsendpoint.us-east-2.rds.amazonaws.com',
'port' => '3306',
'driver' => 'mysql',
'prefix' => '',
),
),
);
When I leave the host blank, I do however get a Drupal error (as I should). That said, why am I unable to connect to the AWS RDS endpoint? I've even given my EC2 instance's private IP permission to access MySQL in the RDS' security group.
Something to note: When I do a fresh drupal install with the same above specs in the settings.php file, the new drupal site works perfectly (is visible). Could the 500 error be because my instance isn't large enough (e.g. do I need more space or memory?)
Help.
amazon-web-services amazon-rds
I've moved my Drupal website over to AWS (using an EC2 instance and RDS instance). Everything moved over just fine. However, when I try and connect my drupal installation to my RDS database via the settings.php file, I get the following message when I navigate to my site IP:
This page isn’t working [public ip] is currently unable to handle this request. HTTP ERROR 500
Right now, I'm putting my RDS endpoint into the settings.php file's 'host' spot.
$databases = array (
'default' =>
array (
'default' =>
array (
'database' => 'mydbname',
'username' => 'mydbusername',
'password' => 'mypassword',
'host' => 'myrdsendpoint.us-east-2.rds.amazonaws.com',
'port' => '3306',
'driver' => 'mysql',
'prefix' => '',
),
),
);
When I leave the host blank, I do however get a Drupal error (as I should). That said, why am I unable to connect to the AWS RDS endpoint? I've even given my EC2 instance's private IP permission to access MySQL in the RDS' security group.
Something to note: When I do a fresh drupal install with the same above specs in the settings.php file, the new drupal site works perfectly (is visible). Could the 500 error be because my instance isn't large enough (e.g. do I need more space or memory?)
Help.
amazon-web-services amazon-rds
amazon-web-services amazon-rds
edited Nov 15 '18 at 9:07
Brittany
asked Nov 15 '18 at 8:02
BrittanyBrittany
2811736
2811736
Is your RDS instance in the same VPC as the EC2 instance ? The reason I ask because you have allowed EC2 private IP in RDS security group. What do your app logs show for the front end 500 error ?
– ben5556
Nov 15 '18 at 19:38
add a comment |
Is your RDS instance in the same VPC as the EC2 instance ? The reason I ask because you have allowed EC2 private IP in RDS security group. What do your app logs show for the front end 500 error ?
– ben5556
Nov 15 '18 at 19:38
Is your RDS instance in the same VPC as the EC2 instance ? The reason I ask because you have allowed EC2 private IP in RDS security group. What do your app logs show for the front end 500 error ?
– ben5556
Nov 15 '18 at 19:38
Is your RDS instance in the same VPC as the EC2 instance ? The reason I ask because you have allowed EC2 private IP in RDS security group. What do your app logs show for the front end 500 error ?
– ben5556
Nov 15 '18 at 19:38
add a comment |
0
active
oldest
votes
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53314816%2fconnecting-website-to-aws-rds-http-error-500%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53314816%2fconnecting-website-to-aws-rds-http-error-500%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Is your RDS instance in the same VPC as the EC2 instance ? The reason I ask because you have allowed EC2 private IP in RDS security group. What do your app logs show for the front end 500 error ?
– ben5556
Nov 15 '18 at 19:38