Is it Possible that the DAL is talking Python 3.4 when my driver is Python 2.7. So when I call it in Web2py from CLI it works but when the framework is running its trying to call 3.4 to talk to cx_Oracle?
See below: 2.12.3-stable+timestamp.2015.08.19.00.18.03 (Running on Apache/2.4.6 (Red Hat Enterprise Linux) OpenSSL/1.0.1e-fips mod_wsgi/3.4 Python/2.7.5, Python 2.7.5) The Running Shows 3.4 Python/2.7.5, Python 2.7.5. could that contribute to the issue? Or am i reading it wrong? Thanks! On Thursday, October 22, 2015 at 3:28:31 PM UTC-7, Michael M wrote: > > Tried it again. > > This time I tried on another RHEL 7 server. > > Downloaded Oracle's Instant Client Zips and extracted all of them instead > of installing RPMs > Same with the cx_Oracle Module. didnt install the RPM got the source and > complied. > > I set the envoirment variables > > export ORACLE_HOME=/usr/include/oracle/11.1 > export LD_LIBRARY_PATH=$ORACLE_HOME/ > export PATH=$ORACLE_HOME/bin:$PATH > > Created a symlink: ln -s libclntsh.so.11.1 libclntsh.so > > I compiled this time 'cx_Oracle-5.1.2.tar.gz' with python setup.py build > && python setup.py install > > Still able to launch python from CLI and import cx_Oracle without problems > Still able to launch Web2py from CLI to see "cx_Oracle" in the Available > drivers line. > > Still unable to load an application that has the DB pointing to a > oracle:// URI without a ticket being auto-generating. > > Would finding an older version of Web2py maybe help? > > On Wednesday, October 14, 2015 at 8:37:54 AM UTC-7, Michael M wrote: >> >> Has anyone been able to reproduce this? And I don't think you actually >> need an Oracle system. Just pointing to a Oracle URI will cause the error >> on my side. >> >> On Thursday, October 8, 2015 at 12:09:45 PM UTC-7, Michael M wrote: >>> >>> Thank-you Niphlod! >>> >>> On Thursday, October 8, 2015 at 12:08:40 PM UTC-7, Niphlod wrote: >>>> >>>> the repo for pydal is the other one.... no worries though, I linked >>>> your one in https://github.com/web2py/pydal/issues/299 >>>> >>>> On Thursday, October 8, 2015 at 3:13:11 AM UTC+2, Michael M wrote: >>>>> >>>>> Submitted: >>>>> https://github.com/web2py/web2py/issues/1082 >>>>> >>>>> On Wednesday, October 7, 2015 at 5:29:43 PM UTC-7, Massimo Di Pierro >>>>> wrote: >>>>>> >>>>>> This may be a bug. Can you please open a pydal ticket and we will >>>>>> check it asap? >>>>>> >>>>>> On Wednesday, 7 October 2015 14:50:13 UTC-5, Michael M wrote: >>>>>>> >>>>>>> Never checked there. But it is. >>>>>>> >>>>>>> $ python web2py.py >>>>>>> web2py Web Framework >>>>>>> Created by Massimo Di Pierro, Copyright 2007-2015 >>>>>>> Version 2.12.3-stable+timestamp.2015.08.19.00.18.03 >>>>>>> Database drivers available: cx_Oracle, pymysql, imaplib, sqlite3, >>>>>>> pg8000, pyodbc >>>>>>> >>>>>>> Weird. just rebooted the Virt. and still getting: >>>>>>> >>>>>>> Traceback (most recent call last): >>>>>>> File "/opt/www-data/web2py/gluon/restricted.py", line 227, in >>>>>>> restricted >>>>>>> exec ccode in environment >>>>>>> File "/opt/www-data/web2py/applications/test/models/db.py" >>>>>>> <https://172.21.165.93/admin/default/edit/test/models/db.py>, line 20, >>>>>>> in <module> >>>>>>> db = DAL(myconf.take('db.uri'), >>>>>>> pool_size=myconf.take('db.pool_size', cast=int), check_reserved=['all']) >>>>>>> File "/opt/www-data/web2py/gluon/packages/dal/pydal/base.py", line >>>>>>> 174, in __call__ >>>>>>> obj = super(MetaDAL, cls).__call__(*args, **kwargs) >>>>>>> File "/opt/www-data/web2py/gluon/packages/dal/pydal/base.py", line >>>>>>> 459, in __init__ >>>>>>> raise RuntimeError("Failure to connect, tried %d times:\n%s" % >>>>>>> (attempts, tb)) >>>>>>> RuntimeError: Failure to connect, tried 5 times: >>>>>>> Traceback (most recent call last): >>>>>>> File "/opt/www-data/web2py/gluon/packages/dal/pydal/base.py", line >>>>>>> 437, in __init__ >>>>>>> self._adapter = ADAPTERS[self._dbname](**kwargs) >>>>>>> File >>>>>>> "/opt/www-data/web2py/gluon/packages/dal/pydal/adapters/base.py", line >>>>>>> 57, in __call__ >>>>>>> obj = super(AdapterMeta, cls).__call__(*args, **kwargs) >>>>>>> File >>>>>>> "/opt/www-data/web2py/gluon/packages/dal/pydal/adapters/oracle.py", >>>>>>> line 105, in __init__ >>>>>>> if do_connect: self.find_driver(adapter_args,uri) >>>>>>> File >>>>>>> "/opt/www-data/web2py/gluon/packages/dal/pydal/adapters/base.py", line >>>>>>> 188, in find_driver >>>>>>> raise RuntimeError("no driver available %s" % str(self.drivers)) >>>>>>> RuntimeError: no driver available ('cx_Oracle',) >>>>>>> >>>>>>> >>>>>>> On Wednesday, October 7, 2015 at 12:45:19 PM UTC-7, Willoughby wrote: >>>>>>>> >>>>>>>> When you start web2py from a command line it should list 'Database >>>>>>>> drivers available' - is it on that list? >>>>>>>> >>>>>>>> On Wednesday, October 7, 2015 at 3:12:01 PM UTC-4, Michael M wrote: >>>>>>>>> >>>>>>>>> Just to cover more basis I installed the following: >>>>>>>>> >>>>>>>>> sudo rpm -Uvh >>>>>>>>> >>>>>>>>> oracle-instantclient11.2-basic-11.2.0.4.0-1.x86_64.rpm >>>>>>>>> oracle-instantclient11.2-devel-11.2.0.4.0-1.x86_64.rpm >>>>>>>>> oracle-instantclient11.2-jdbc-11.2.0.4.0-1.x86_64.rpm >>>>>>>>> oracle-instantclient11.2-odbc-11.2.0.4.0-1.x86_64.rpm >>>>>>>>> oracle-instantclient11.2-sqlplus-11.2.0.4.0-1.x86_64.rpm >>>>>>>>> oracle-instantclient11.2-tools-11.2.0.4.0-1.x86_64.rpm >>>>>>>>> >>>>>>>>> then >>>>>>>>> >>>>>>>>> cx_Oracle-5.1.2-11g-py27-1.x86_64.rpm >>>>>>>>> >>>>>>>>> Still no dice in Web2py >>>>>>>>> >>>>>>>>> >>>>>>>>> On Tuesday, October 6, 2015 at 5:09:18 PM UTC-7, Michael M wrote: >>>>>>>>>> >>>>>>>>>> I was testing in non-prod (RHEL) to see if it was built in. it >>>>>>>>>> wasnt. on my Fedora 22 at my desk I installed cx_Oracle because it >>>>>>>>>> works >>>>>>>>>> when i am in CLI python and I can call it no errors. I have yet to >>>>>>>>>> dabble >>>>>>>>>> in virtualenv. >>>>>>>>>> >>>>>>>>>> I have systemctl restart httpd after every change. even reboots >>>>>>>>>> to make sure. >>>>>>>>>> >>>>>>>>>> On Tuesday, October 6, 2015 at 5:02:12 PM UTC-7, Leonel Câmara >>>>>>>>>> wrote: >>>>>>>>>>> >>>>>>>>>>> Is it possible web2py is running in a virtualenv where you have >>>>>>>>>>> not installed cx_Oracle? >>>>>>>>>>> >>>>>>>>>>> Also don't forget to restart Apache. >>>>>>>>>>> >>>>>>>>>> -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
