Opened 8 years ago

Closed 8 years ago

#9972 closed (fixed)

dbshell can't connect to Oracle database

Reported by: lijinguo@… Owned by: nobody
Component: Database layer (models, ORM) Version: master
Severity: Keywords: oracle, dbshell
Cc: Triage Stage: Accepted
Has patch: yes Needs documentation: no
Needs tests: no Patch needs improvement: no
Easy pickings: UI/UX:

Description

When we connect to the database using dbshell, No response is received.

Attachments (2)

client.py.diff (695 bytes) - added by lijinguo@… 8 years ago.
9972.diff (2.9 KB) - added by Ian Kelly 8 years ago.

Download all attachments as: .zip

Change History (7)

Changed 8 years ago by lijinguo@…

Attachment: client.py.diff added

comment:1 Changed 8 years ago by Ian Kelly

Needs documentation: unset
Needs tests: unset
Patch needs improvement: unset

On my install, SQL*Plus rejects the connect string produced by this patch. What version of SQL*Plus are you using? What settings.py database settings are you using?

comment:2 Changed 8 years ago by lijinguo@…

Oracle version:Oracle Database 10g Express Edition Release 10.2.0.1.0 - Production

SQL*Plus version: SQL*Plus: Release 10.2.0.4.0 - Production

cx_Oracle version: 4.4.1

about database settings:

DATABASE_ENGINE = 'oracle'
DATABASE_NAME = 'xe'
DATABASE_USER = 'dba'
DATABASE_PASSWORD = 'password'
DATABASE_HOST = '192.168.1.111'
DATABASE_PORT = '1521'

Changed 8 years ago by Ian Kelly

Attachment: 9972.diff added

comment:3 Changed 8 years ago by Ian Kelly

Triage Stage: UnreviewedAccepted

Does this patch work for you?

comment:4 Changed 8 years ago by lijinguo@…

Great, it's work for me. Who will close this ticket?

comment:5 Changed 8 years ago by Ian Kelly

Resolution: fixed
Status: newclosed

(In [9713]) Fixed #9972: The dbshell command was ignoring the DATABASE_HOST and DATABASE_PORT settings in Oracle.

Note: See TracTickets for help on using tickets.
Back to Top