Hmm, ok so I guess having a different user name isn't causing the problem.
I was able to connect to the database from the webserver using SQL
Developer, and I am sure the credentials are correct. Are there any
configuration steps that I need to perform for Instant Client or cx_Oracle?
So far, I have just added the shared library path to the loader so that
Instant Client can run (i.e. change LD_LIBRARY_PATH environment variable).
Is there anything else I need to do to configure Instant Client to work
with Django?
On Friday, January 25, 2013 8:27:38 AM UTC-5, Dan Gentry wrote:
>
> You've probably already tried the simple things:
>
>
> - Confirm that the server name and port are correct.
> - Ensure that firewall/routing rules will allow the connection.
> - Try a simple connection on the same box with sqlplus.
>
>
> Walking through this list has helped me a number of times.
>
>
> On Thursday, January 24, 2013 5:27:22 PM UTC-5, Dylan Klomparens wrote:
>>
>> I have a Django program that is connecting to an Oracle database. In my
>> settings.py file I have this configuration:
>>
>> DATABASES = {
>> 'default': {
>> 'ENGINE': 'django.db.backends.oracle',
>> 'NAME': 'xe',
>> 'USER': 'MY_USER_NAME',
>> 'PASSWORD': 'abcdefghijklmnopqrstuvwxyz',
>> 'HOST': 'db_server.example.com',
>> 'PORT': '1234',
>> }}
>>
>> I received a strange error when attempting to load the website:
>>
>> ORA-28547: connection to server failed, probable Oracle Net admin error
>>
>> After further investigation, I sniffed the TCP traffic between the
>> webserver and the database server. I discovered this text in the network
>> communication, which I reformatted for this post:
>>
>> (DESCRIPTION=
>> (ADDRESS=
>> (PROTOCOL=TCP)
>> (HOST=1.2.3.4)
>> (PORT=1234)
>> )
>> (CONNECT_DATA=
>> (SID=xe)
>> (CID=
>> (PROGRAM=httpd@webserver_hostname)
>> (HOST=webserver_hostname)
>> (USER=apache)
>> )
>> ))
>>
>> So my question is: why is Django attempting to connect to the Oracle
>> database with different credentials than the ones I specified? Notably, it
>> is attempting to use user 'apache' instead of 'MY_USER_NAME'. The database
>> host IP, port, and SID are correct and what I specified. It just appears to
>> be the user name that is different.
>>
>> (As a side note, I suppose the password is transmitted separately in a
>> later portion of the log in process?)
>>
>
--
You received this message because you are subscribed to the Google Groups
"Django users" group.
To post to this group, send email to django-users@googlegroups.com.
To unsubscribe from this group, send email to
django-users+unsubscr...@googlegroups.com.
Visit this group at http://groups.google.com/group/django-users?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.
