Enabling SSL ON in Django & PostgreSQL with dbshell command?
0
I'm trying to run the python manage.py dbshell command as described in this other SO question. but I'm getting:
FATAL: pg_hba.conf rejects connection for host "my_ip", user "django", database "my_db", SSL off
Traceback (most recent call last):
File "manage.py", line 10, in <module>
execute_from_command_line(sys.argv)
File "/home/django/projects/DJANGO_DB/lib/python3.5/site-packages/django/core/management/__init__.py", line 381, in execute_from_command_line
utility.execute()
File "/home/django/projects/DJANGO_DB/lib/python3.5/site-packages/django/core/management/__init__.py", line 375, in execute
self.fetch_command(subcommand).run_from_argv(self.argv)
File "/home/django/projects/DJANGO_DB/lib/python3.5/site-packages/django/core/management/base.py", line 316, in run_from_argv
self.execute(*args, **cmd_options)
File "/home/django/projects/DJANGO_DB/lib/python3.5/site-packages/django/core/management/base.py", line 353, in execute
output = self.handle(*args, **options)
File "/home/django/projects/DJANGO_DB/lib/python3.5/site-packages/django/core/management/commands/dbshell.py", line 22, in handle
connection.client.runshell()
File "/home/django/projects/DJANGO_DB/lib/python3.5/site-packages/django/db/backends/postgresql/client.py", line 71, in runshell
DatabaseClient.runshell_db(self.connection.get_connection_params())
File "/home/user/Projects/DJANGO_DB/lib/python3.5/site-packages/django/db/backends/postgresql/client.py", line 61, in runshell_db
subprocess.check_call(args)
File "/usr/lib/python3.5/subprocess.py", line 581, in check_call
raise CalledProcessError(retcode, cmd)
subprocess.CalledProcessError: Command '['psql', '-U', 'django', '-h', 'mydomain.com', '-p', '5432', 'my_db']' returned non-zero exit status 2
Connecting to the database via gunicorn and the usual python manage.py runserver command works great.
However, I'm trying to verify that SSL is working between the dev server and a GC instance (which it should be as I enabled and whitelist my ip address and copied keys) but not being able to use the shell is very annoying. Any help would be stupendous!
python ssl postgresql-9.6 django-2.1
asked Nov 20 at 17:28
Dan2theR
3417
add a comment |
0
I'm trying to run the python manage.py dbshell command as described in this other SO question. but I'm getting:
FATAL: pg_hba.conf rejects connection for host "my_ip", user "django", database "my_db", SSL off
Traceback (most recent call last):
File "manage.py", line 10, in <module>
execute_from_command_line(sys.argv)
File "/home/django/projects/DJANGO_DB/lib/python3.5/site-packages/django/core/management/__init__.py", line 381, in execute_from_command_line
utility.execute()
File "/home/django/projects/DJANGO_DB/lib/python3.5/site-packages/django/core/management/__init__.py", line 375, in execute
self.fetch_command(subcommand).run_from_argv(self.argv)
File "/home/django/projects/DJANGO_DB/lib/python3.5/site-packages/django/core/management/base.py", line 316, in run_from_argv
self.execute(*args, **cmd_options)
File "/home/django/projects/DJANGO_DB/lib/python3.5/site-packages/django/core/management/base.py", line 353, in execute
output = self.handle(*args, **options)
File "/home/django/projects/DJANGO_DB/lib/python3.5/site-packages/django/core/management/commands/dbshell.py", line 22, in handle
connection.client.runshell()
File "/home/django/projects/DJANGO_DB/lib/python3.5/site-packages/django/db/backends/postgresql/client.py", line 71, in runshell
DatabaseClient.runshell_db(self.connection.get_connection_params())
File "/home/user/Projects/DJANGO_DB/lib/python3.5/site-packages/django/db/backends/postgresql/client.py", line 61, in runshell_db
subprocess.check_call(args)
File "/usr/lib/python3.5/subprocess.py", line 581, in check_call
raise CalledProcessError(retcode, cmd)
subprocess.CalledProcessError: Command '['psql', '-U', 'django', '-h', 'mydomain.com', '-p', '5432', 'my_db']' returned non-zero exit status 2
Connecting to the database via gunicorn and the usual python manage.py runserver command works great.
However, I'm trying to verify that SSL is working between the dev server and a GC instance (which it should be as I enabled and whitelist my ip address and copied keys) but not being able to use the shell is very annoying. Any help would be stupendous!
python ssl postgresql-9.6 django-2.1
asked Nov 20 at 17:28
Dan2theR
3417
add a comment |
0
0
0
I'm trying to run the python manage.py dbshell command as described in this other SO question. but I'm getting:
FATAL: pg_hba.conf rejects connection for host "my_ip", user "django", database "my_db", SSL off
Traceback (most recent call last):
File "manage.py", line 10, in <module>
execute_from_command_line(sys.argv)
File "/home/django/projects/DJANGO_DB/lib/python3.5/site-packages/django/core/management/__init__.py", line 381, in execute_from_command_line
utility.execute()
File "/home/django/projects/DJANGO_DB/lib/python3.5/site-packages/django/core/management/__init__.py", line 375, in execute
self.fetch_command(subcommand).run_from_argv(self.argv)
File "/home/django/projects/DJANGO_DB/lib/python3.5/site-packages/django/core/management/base.py", line 316, in run_from_argv
self.execute(*args, **cmd_options)
File "/home/django/projects/DJANGO_DB/lib/python3.5/site-packages/django/core/management/base.py", line 353, in execute
output = self.handle(*args, **options)
File "/home/django/projects/DJANGO_DB/lib/python3.5/site-packages/django/core/management/commands/dbshell.py", line 22, in handle
connection.client.runshell()
File "/home/django/projects/DJANGO_DB/lib/python3.5/site-packages/django/db/backends/postgresql/client.py", line 71, in runshell
DatabaseClient.runshell_db(self.connection.get_connection_params())
File "/home/user/Projects/DJANGO_DB/lib/python3.5/site-packages/django/db/backends/postgresql/client.py", line 61, in runshell_db
subprocess.check_call(args)
File "/usr/lib/python3.5/subprocess.py", line 581, in check_call
raise CalledProcessError(retcode, cmd)
subprocess.CalledProcessError: Command '['psql', '-U', 'django', '-h', 'mydomain.com', '-p', '5432', 'my_db']' returned non-zero exit status 2
Connecting to the database via gunicorn and the usual python manage.py runserver command works great.
However, I'm trying to verify that SSL is working between the dev server and a GC instance (which it should be as I enabled and whitelist my ip address and copied keys) but not being able to use the shell is very annoying. Any help would be stupendous!
python ssl postgresql-9.6 django-2.1
asked Nov 20 at 17:28
Dan2theR
3417
I'm trying to run the python manage.py dbshell command as described in this other SO question. but I'm getting:
FATAL: pg_hba.conf rejects connection for host "my_ip", user "django", database "my_db", SSL off
Traceback (most recent call last):
File "manage.py", line 10, in <module>
execute_from_command_line(sys.argv)
File "/home/django/projects/DJANGO_DB/lib/python3.5/site-packages/django/core/management/__init__.py", line 381, in execute_from_command_line
utility.execute()
File "/home/django/projects/DJANGO_DB/lib/python3.5/site-packages/django/core/management/__init__.py", line 375, in execute
self.fetch_command(subcommand).run_from_argv(self.argv)
File "/home/django/projects/DJANGO_DB/lib/python3.5/site-packages/django/core/management/base.py", line 316, in run_from_argv
self.execute(*args, **cmd_options)
File "/home/django/projects/DJANGO_DB/lib/python3.5/site-packages/django/core/management/base.py", line 353, in execute
output = self.handle(*args, **options)
File "/home/django/projects/DJANGO_DB/lib/python3.5/site-packages/django/core/management/commands/dbshell.py", line 22, in handle
connection.client.runshell()
File "/home/django/projects/DJANGO_DB/lib/python3.5/site-packages/django/db/backends/postgresql/client.py", line 71, in runshell
DatabaseClient.runshell_db(self.connection.get_connection_params())
File "/home/user/Projects/DJANGO_DB/lib/python3.5/site-packages/django/db/backends/postgresql/client.py", line 61, in runshell_db
subprocess.check_call(args)
File "/usr/lib/python3.5/subprocess.py", line 581, in check_call
raise CalledProcessError(retcode, cmd)
subprocess.CalledProcessError: Command '['psql', '-U', 'django', '-h', 'mydomain.com', '-p', '5432', 'my_db']' returned non-zero exit status 2
Connecting to the database via gunicorn and the usual python manage.py runserver command works great.
However, I'm trying to verify that SSL is working between the dev server and a GC instance (which it should be as I enabled and whitelist my ip address and copied keys) but not being able to use the shell is very annoying. Any help would be stupendous!
python ssl postgresql-9.6 django-2.1
python ssl postgresql-9.6 django-2.1
asked Nov 20 at 17:28
Dan2theR
3417
asked Nov 20 at 17:28
Dan2theR
3417
asked Nov 20 at 17:28
Dan2theR
3417
asked Nov 20 at 17:28
Dan2theR
3417
asked Nov 20 at 17:28
Dan2theR
3417
3417
add a comment |
add a comment |
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
});
}
});
draft saved
draft discarded
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%2f53398396%2fenabling-ssl-on-in-django-postgresql-with-dbshell-command%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
active
oldest
votes
active
oldest
votes
active
oldest
votes
active
oldest
votes
draft saved
draft discarded
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.
Some of your past answers have not been well-received, and you're in danger of being blocked from answering.
Please pay close attention to the following guidance:
- 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.
draft saved
draft discarded
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%2f53398396%2fenabling-ssl-on-in-django-postgresql-with-dbshell-command%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
