Have you checked permissions?
--
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.
For more
Yes you are correct, that the reason i have replaced the below line in
"app.wsgi", but that does not works.
#os.environ["LD_LIBRARY_PATH"] = "/opt/app/oracle/products/11.2.0/lib"
#os.environ["ORACLE_HOME"] = "/opt/app/oracle/products/11.2.0"
os.environ["LD_LIBRARY_PATH"] = "/opt/app/oracle/produc
Hi Again,
I have finished my implementation with the local db, but now stuck in major
issue.When i try to login to the local oracle database then it is working
perfectly fine.I am able to read the data from the db installed in the
same UNIX machine.
But when i tried to login a db installed in rem
Thanks to all for supporting this to fix the issue.
So issue is resolved by adding these 2 lines in "app.wsgi"
os.environ["LD_LIBRARY_PATH"] = "/opt/app/oracle/products/11.2.0/lib"
os.environ["ORACLE_HOME"] = "/opt/app/oracle/products/11.2.0"
Thanks again for helping to fix this issue. Its reall
On Apr 23, 12:29 pm, kamal sharma wrote:
> No it was .profile of mine. Now I have set the LD_LIBRARY_PATH in app.wsgi
> as mentioned below and when I print the os.environ in the beginning of
> views.py then it shows that newly added value.
It's clear that your LD_LIBRARY_PATH is fine at this poin
No it was .profile of mine. Now I have set the LD_LIBRARY_PATH in app.wsgi
as mentioned below and when I print the os.environ in the beginning of
views.py then it shows that newly added value.
os.environ["LD_LIBRARY_PATH"] = "/opt/app/oracle/products/11.2.0/lib"
Is there any problem in this state
Yes, i am getting this error when i used from the web application. Also all the
user have the permission to webserver to read all Oracle client files.
Not sure how it got set to LD_LIBRARY_PATH
/opt/apache-2.2.16/lib:/usr/local/lib:
I have defined the LD_LIBRARY_PATH and ORACLE_HOME as follows in
I think i have done a mistake in my last cx_Oracle installation. Is this a
problem? I used one python while build and another while install.
ex: [me] ~/install_cx_oracle/cx_Oracle-5.0.3> /usr/local/bin/python setup.py
build
[me] ~/install_cx_oracle/cx_Oracle-5.0.3> sudo python setup.py insta
Are you getting this error only when using the app through a web server?
Have you verified that the web server does have ORACLE_HOME and
LD_LIBRARY_PATH correctly defined? (e.g. by logging it using os.environ).
Are you sure that the user that is used to run your webserver has
permissions to read a
On Apr 21, 11:40 pm, kamal sharma wrote:
> When i try the same code from python Shell then it is working fine.
Okay, so it does sound to me like it's your web server blocking access
to the entire ORACLE_HOME directory.
Is it running under a chroot jail? If so, then you will need to copy
your en
Hi Jirka,
Thanks for the response.
I have installed cx_Oracle in Solaris again and followed this steps but
still the error is same:
Exception Type:DatabaseErrorException Value:
Error while trying to retrieve text for error ORA-01804
Download cx_oracle module:
http://sourceforge.net/projects/c
Hi Kamal,
checking my install history, this is what I had to do to use
cx_Oracle on Ubuntu Server:
$ /usr/local/oracle/instantclient_11_2$ ln -s libclntsh.so.11.1 libclntsh.so
$ WITH_UNICODE=1 ORACLE_HOME=/usr/local/oracle/instantclient_11_2
python setup.py build
$ sudo bash
# WITH_UNICODE=1 OR
When i try the same code from python Shell then it is working fine.
Here is the working output:
>>> import cx_Oracle
>>> from pprint import pprint
>>> connection = cx_Oracle.Connection("%s/%s@%s" % ('foo', 'bar', 'db'))
>>> cursor = cx_Oracle.Cursor(connection)
>>> sql = "SELECT xyz FROM table_nam
On Apr 21, 11:03 am, kamal sharma wrote:
> Error while trying to retrieve text for error ORA-01804
>
> Here is my code to fetch the data from database.
>
> def cases(request, dbname, prnum=None, message=''):
>
> connection = cx_Oracle.Connection("%s/%s@%s" % ('foo', 'bar', 'xyz'))
> cursor
Thanks a lot. Now that issue is resolved after i execute below command.
sudo ln -s /opt/app/oracle/products/11.2.0/lib/libclntsh.so.11.1
But now i am getting databse error. Any pointer please?
Exception Value:
Error while trying to retrieve text for error ORA-01804
Here is my code to fetch th
After creating soft link, still it is giving the same error. Do i need to
create soft link for any other files? My response are inline with KS:
On Thu, Apr 21, 2011 at 9:21 PM, Ian wrote:
> On Apr 21, 9:39 am, kamal sharma wrote:
> > Here is the error I am getting now:
> >
> > cd /usr/local/lib
On Apr 21, 9:39 am, kamal sharma wrote:
> Here is the error I am getting now:
>
> cd /usr/local/lib
>
> /usr/local/lib> sudo ln
> /opt/app/oracle/products/11.2.0/lib/libclntsh.so.10.1
> ln: ./libclntsh.so.10.1 is on a different file system
>
> /usr/local/lib> cd /usr/lib/
> /usr/lib> sudo ln /opt/
Here is the error I am getting now:
cd /usr/local/lib
/usr/local/lib> sudo ln
/opt/app/oracle/products/11.2.0/lib/libclntsh.so.10.1
ln: ./libclntsh.so.10.1 is on a different file system
/usr/local/lib> cd /usr/lib/
/usr/lib> sudo ln /opt/app/oracle/products/11.2.0/lib/libclntsh.so.10.1
ln: ./lib
This may be related to Oracle's shared libraries not being in the path
recognized by your web server. I created hard links to the Oracle shared
libraries in /user/local/lib to get cx_oracle working.
I have a blog post that outlines what I did, here:
http://bradmontgomery.net/blog/gahhh-django-vi
Thanks David for quick response. I have already tried that option, but it
does not work.
Here is the diff which i have added.
Index: app.wsgi
===
+os.environ["LD_LIBRARY_PATH"] = "/opt/app/oracle/products/11.2.0/lib"
# figure out
At the top of the WSGI script, set the LD_LIBRARY_PATH environment variable.
On 21 April 2011 11:07, kamalp.sha...@gmail.com wrote:
> Hi,
>
> I have installed cx_Oracle module in one of my Solaris box and then
> trying to create a django page to read data from oracle db. But I am
> getting follow
21 matches
Mail list logo
