Enabling SSL ON in Django & PostgreSQL with dbshell command?
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
add a comment |
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
add a comment |
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
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 '18 at 17:28
Dan2theRDan2theR
3428
3428
add a comment |
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%2f53398396%2fenabling-ssl-on-in-django-postgresql-with-dbshell-command%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%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