I think it is too. Just made some progress. And a bunch of VM's later:
Error ticket for "test"
Ticket ID
172.21.140.228.2015-12-24.14-29-42.af6f82d8-d7b2-4a69-8409-1cf04d67c994
<type 'exceptions.RuntimeError'> Failure to connect, tried 5 times:
Traceback (most recent call last): File
"/opt/www-data/web2py/gluon/packages/dal/pydal/base.py", line 446, in
__init__ self._adapter = ADAPTERS[self._dbname](**kwargs) File
"/opt/www-data/web2py/gluon/packages/dal/pydal/adapters/base.py", line 60,
in __call__ obj = super(AdapterMeta, cls).__call__(*args, **kwargs) File
"/opt/www-data/web2py/gluon/packages/dal/pydal/adapters/oracle.py", line
118, in __init__ if do_connect: self.reconnect() File
"/opt/www-data/web2py/gluon/packages/dal/pydal/connection.py", line 125, in
reconnect self.connection = f() File
"/opt/www-data/web2py/gluon/packages/dal/pydal/adapters/oracle.py", line
116, in connector return self.driver.connect(uri,**driver_args)
DatabaseError: ORA-12514: TNS:listener does not currently know of service
requested in connect descriptor
Version
web2py™ Version 2.13.2-stable+timestamp.2015.12.18.11.00.46
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", 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 473,
in __init__
"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 446,
in __init__
self._adapter = ADAPTERS[self._dbname](**kwargs)
File "/opt/www-data/web2py/gluon/packages/dal/pydal/adapters/base.py",
line 60, in __call__
obj = super(AdapterMeta, cls).__call__(*args, **kwargs)
File "/opt/www-data/web2py/gluon/packages/dal/pydal/adapters/oracle.py",
line 118, in __init__
if do_connect: self.reconnect()
File "/opt/www-data/web2py/gluon/packages/dal/pydal/connection.py", line
125, in reconnect
self.connection = f()
File "/opt/www-data/web2py/gluon/packages/dal/pydal/adapters/oracle.py",
line 116, in connector
return self.driver.connect(uri,**driver_args)
DatabaseError: ORA-12514: TNS:listener does not currently know of service
requested in connect descriptor
On Friday, December 4, 2015 at 11:03:12 PM UTC-8, Rakesh Singh wrote:
>
> My guess is that this is a permission issue.
> cx_Oracle may be accessible to Web2Py, but the Oracle libraries may be
> readable by your nginx user
>
> What are the permissions your ORACLE_HOME directory and files within it?
>
> /usr/include/oracle/11.1
>
>
> On Wednesday, 7 October 2015 00:37:10 UTC+2, Michael M wrote:
>>
>> 2.12.3-stable+timestamp.2015.08.19.00.18.03
>> (Running on Apache/2.4.16 (Fedora) OpenSSL/1.0.1k-fips mod_wsgi/4.4.8
>> Python/2.7.10, Python 2.7.10)
>>
>> So "import cx_Oracle" works in python console but when I tried using it
>> in web2py it errors out. <type 'exceptions.ImportError'>(Cannot import
>> module 'applications.test2.modules.cx_Oracle')
>>
>> the only thing i have found is that the file structure looks different
>> from cx_Oracle to another import i use.
>>
>> pysnmp works in web2py and straight python:
>> >>> import pysnmp
>> >>> pysnmp.__file__
>> '/usr/lib/python2.7/site-packages/pysnmp/__init__.pyc'
>>
>> cx_Oracle doesnt work in web2py but works in py files.
>> >>> import cx_Oracle
>> >>> cx_Oracle.__file__
>> '/usr/lib/python2.7/site-packages/cx_Oracle.so'
>>
>>
>> the only difference I saw was that its a .so file instead of __init__.pyc
>>
>> Any thoughts. Trying to get this to work in Fedora 22. Thanks!
>>
>>
--
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.
