Ok That was wrong. mod_wsgi was 3.4
On Thursday, October 22, 2015 at 3:46:42 PM UTC-7, Michael M wrote: > > 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.