Opened 7 years ago
Closed 7 years ago
#29199 closed Bug (fixed)
Oracle backend won't connect if password contains '@'
Reported by: | Shane Allgeier | Owned by: | Mariusz Felisiak |
---|---|---|---|
Component: | Database layer (models, ORM) | Version: | dev |
Severity: | Normal | Keywords: | oracle |
Cc: | Triage Stage: | Ready for checkin | |
Has patch: | yes | Needs documentation: | no |
Needs tests: | no | Patch needs improvement: | no |
Easy pickings: | no | UI/UX: | no |
Description (last modified by )
The Oracle backend won't connect if password contains '@'.
For example, using this DATABASES config in settings.py:
DATABASES = { 'default': { 'ENGINE': 'django.db.backends.oracle', 'NAME': 'mydsn', 'USER': 'valid_username', 'PASSWORD': 'p@ssword', 'HOST': '', 'PORT': '', } }
I get this traceback:
Unhandled exception in thread started by <function check_errors.<locals>.wrapper at 0x7fab58f99ae8> Traceback (most recent call last): File "/home/shane/.virtualenvs/django-rms/lib/python3.6/site-packages/django/db/backends/base/base.py", line 216, in ensure_connection self.connect() File "/home/shane/.virtualenvs/django-rms/lib/python3.6/site-packages/django/db/backends/base/base.py", line 194, in connect self.connection = self.get_new_connection(conn_params) File "/home/shane/.virtualenvs/django-rms/lib/python3.6/site-packages/django/db/backends/oracle/base.py", line 208, in get_new_connection return Database.connect(self._connect_string(), **conn_params) cx_Oracle.DatabaseError: ORA-12154: TNS:could not resolve the connect identifier specified The above exception was the direct cause of the following exception: Traceback (most recent call last): File "/home/shane/.virtualenvs/django-rms/lib/python3.6/site-packages/django/utils/autoreload.py", line 225, in wrapper fn(*args, **kwargs) File "/home/shane/.virtualenvs/django-rms/lib/python3.6/site-packages/django/core/management/commands/runserver.py", line 123, in inner_run self.check_migrations() File "/home/shane/.virtualenvs/django-rms/lib/python3.6/site-packages/django/core/management/base.py", line 427, in check_migrations executor = MigrationExecutor(connections[DEFAULT_DB_ALIAS]) File "/home/shane/.virtualenvs/django-rms/lib/python3.6/site-packages/django/db/migrations/executor.py", line 18, in __init__ self.loader = MigrationLoader(self.connection) File "/home/shane/.virtualenvs/django-rms/lib/python3.6/site-packages/django/db/migrations/loader.py", line 49, in __init__ self.build_graph() File "/home/shane/.virtualenvs/django-rms/lib/python3.6/site-packages/django/db/migrations/loader.py", line 206, in build_graph self.applied_migrations = recorder.applied_migrations() File "/home/shane/.virtualenvs/django-rms/lib/python3.6/site-packages/django/db/migrations/recorder.py", line 61, in applied_migrations if self.has_table(): File "/home/shane/.virtualenvs/django-rms/lib/python3.6/site-packages/django/db/migrations/recorder.py", line 44, in has_table return self.Migration._meta.db_table in self.connection.introspection.table_names(self.connection.cursor()) File "/home/shane/.virtualenvs/django-rms/lib/python3.6/site-packages/django/db/backends/base/base.py", line 255, in cursor return self._cursor() File "/home/shane/.virtualenvs/django-rms/lib/python3.6/site-packages/django/db/backends/base/base.py", line 232, in _cursor self.ensure_connection() File "/home/shane/.virtualenvs/django-rms/lib/python3.6/site-packages/django/db/backends/base/base.py", line 216, in ensure_connection self.connect() File "/home/shane/.virtualenvs/django-rms/lib/python3.6/site-packages/django/db/utils.py", line 89, in __exit__ raise dj_exc_value.with_traceback(traceback) from exc_value File "/home/shane/.virtualenvs/django-rms/lib/python3.6/site-packages/django/db/backends/base/base.py", line 216, in ensure_connection self.connect() File "/home/shane/.virtualenvs/django-rms/lib/python3.6/site-packages/django/db/backends/base/base.py", line 194, in connect self.connection = self.get_new_connection(conn_params) File "/home/shane/.virtualenvs/django-rms/lib/python3.6/site-packages/django/db/backends/oracle/base.py", line 208, in get_new_connection return Database.connect(self._connect_string(), **conn_params) django.db.utils.DatabaseError: ORA-12154: TNS:could not resolve the connect identifier specified
After delving into the Oracle backend, I realized that Django is calling the cx_Oracle.connect() function like so: (django/db/backends/oracle/base.py line 208)
Database.connect('valid_username/p@ssword@mydsn')
You can probably guess why cx_Oracle doesn't like this. As far as I can tell, there's no possible way to work around this bug without directly editing Django's (or cx_Oracle's) code.
The following connection method works just fine:
Database.connect('valid_username', 'p@ssword', 'mydsn')
I should also mention that there have been others that have this issue. In my case, the bureaucracy at my company won't allow me to choose my own password, so fixing Django is my only option.
Change History (6)
comment:1 by , 7 years ago
Description: | modified (diff) |
---|---|
Type: | Uncategorized → Bug |
comment:2 by , 7 years ago
Owner: | changed from | to
---|---|
Status: | new → assigned |
Triage Stage: | Unreviewed → Accepted |
Version: | 2.0 → master |
comment:3 by , 7 years ago
Has patch: | set |
---|
comment:4 by , 7 years ago
Patch looks good to me. Any chance we can get this backported to the older versions? At least Django 1.11 since that's the last version that supports Oracle 11.2.
Thanks for the patch, felixxm!
comment:5 by , 7 years ago
Triage Stage: | Accepted → Ready for checkin |
---|
This doesn't qualify for a backport based on our supported versions policy.
PR