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 [email protected]. For more options, visit https://groups.google.com/d/optout.
