[web2py] Re: Oracle drivers.

Submitted. https://github.com/web2py/pydal/issues/322 On Tuesday, December 29, 2015 at 3:18:49 AM UTC-8, Niphlod wrote: > > if it fixes all issues, open a bug on pydal and it'll get merged. > > On Monday, December 28, 2015 at 9:57:52 PM UTC+1, Michael Messmer wrote: >> >> @Niphlod @Massimo >> >>

[web2py] Re: Oracle drivers.

if it fixes all issues, open a bug on pydal and it'll get merged. On Monday, December 28, 2015 at 9:57:52 PM UTC+1, Michael Messmer wrote: > > @Niphlod @Massimo > > Is what i did a correct fix and is this something that needs to be > corrected here >

[web2py] Re: Oracle drivers.

@Niphlod @Massimo Is what i did a correct fix and is this something that needs to be corrected here https://github.com/web2py/pydal/blob/master/pydal/adapters/oracle.py ? On Monday, December 28, 2015 at 12:38:13 PM UTC-8, Michael Messmer wrote: > > I looked at the other Adapter Modules for

[web2py] Re: Oracle drivers.

Alright it worked for blah: cursor.execute("DROP SEQUENCE BLAH_SEQUENCE") Going for the rest now. On Monday, December 28, 2015 at 10:09:31 AM UTC-8, Michael Messmer wrote: > > Ahh, I am ULTRA-Newb to db's: > > here is what it returned: > > >>> for row in cursor: > ... print row > ... >

[web2py] Re: Oracle drivers.

So I have run the following to try and purge my current account: #sign in: import cx_Oracle db = cx_Oracle.connect('WEB2PY', 'pw', 'server:1521/sid') cursor = db.cursor() #List all tables: cursor.execute('SELECT table_name FROM all_tables') for row in cursor: print row #delete Table:

[web2py] Re: Oracle drivers.

Ahh, I am ULTRA-Newb to db's: here is what it returned: >>> for row in cursor: ... print row ... ('SYS_C0012098', 'INDEX') ('SYS_LOB092306C3$$', 'LOB') ('AUTH_CAS_SEQUENCE', 'SEQUENCE') ('AUTH_EVENT_SEQUENCE', 'SEQUENCE') ('AUTH_GROUP_SEQUENCE', 'SEQUENCE')

[web2py] Re: Oracle drivers.

Looks like it was permission issues and the RPM's were installing to a directory under /usr/ Now I am getting Traceback (most recent call last): File "/opt/www-data/web2py/gluon/restricted.py", line 227, in restricted exec ccode in environment File

[web2py] Re: Oracle drivers.

You can view tables owned by the current user with: SELECT TABLE_NAME FROM USER_TABLES ORDER BY TABLE_NAME; You can view all objects owned by the current user with: SELECT OBJECT_NAME, OBJECT_TYPE FROM USER_OBJECTS ORDER BY 2, 1; HTH, -Dan -- Resources: - http://web2py.com -

[web2py] Re: Oracle drivers.

MAGIC: cursor.execute("DROP SEQUENCE AUTH_USER_SEQUENCE") cursor.execute("DROP SEQUENCE AUTH_GROUP_SEQUENCE") cursor.execute("DROP SEQUENCE AUTH_MEMBERSHIP_SEQUENCE") cursor.execute("DROP SEQUENCE AUTH_PERMISSION_SEQUENCE") cursor.execute("DROP SEQUENCE AUTH_EVENT_SEQUENCE") cursor.execute("DROP

[web2py] Re: Oracle drivers.

ok, so. I tried adding a user record and now im getting this: 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/controllers/appadmin.py"

[web2py] Re: Oracle drivers.

I looked at the other Adapter Modules for that "Reference()" "web2py/gluon/packages/dal/pydal/adapters/mongo.py" had it and it also had: from "..helpers.classes import SQLCustomType, SQLALL, Reference" So I added this to the following to "web2py/gluon/packages/dal/pydal/adapters/oracle.py"

[web2py] Re: Oracle drivers.

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 Failure to connect, tried 5 times: Traceback (most recent call last): File

[web2py] Re: Oracle drivers.

I have been trying to find good a install script for nginx on rhel/cent 7. It has been slow going on my part due to my new job. I just joined the ranks of Unix OS admins. Coming from a Windows world my job of getting up to speed has been a monumental task. ;-) If there is an updated nginx and

[web2py] Re: Oracle drivers.

Any news on Oracle and Nginx? Is it an Apache issue? On Monday, 23 November 2015 13:13:56 UTC-6, Michael M wrote: > > I did. And still no luck.It Jams me because run web2py from CLI and > Rocket serves it. It Oracle works flawlessly with Web2py. > > So it maybe just an Apache/Mod_WSGI

[web2py] Re: Oracle drivers.

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,

[web2py] Re: Oracle drivers.

I did. And still no luck.It Jams me because run web2py from CLI and Rocket serves it. It Oracle works flawlessly with Web2py. So it maybe just an Apache/Mod_WSGI thing. I am trying to get NginX and ( UWSGI or Gunicorn ) to work on my environment ( Fedora 22 / RHEL 7 ) On Monday,

[web2py] Re: Oracle drivers.

Do you already tried sudo dnf install python-pip sudo pip install cx_Oracle ? -- 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

[web2py] Re: Oracle drivers.

Ok more info. added this to a def and its a copy of code from 'line 1101' of web2py /gluon /*widget.py* : def about():

[web2py] Re: Oracle drivers.

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

[web2py] Re: Oracle drivers.

So i noticed something. I was in root when when I was seeing cx_Oracle: # 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: sqlite3, imaplib, cx_Oracle, pymysql, pg8000 When I

[web2py] Re: Oracle drivers.

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

[web2py] Re: Oracle drivers.

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

[web2py] Re: Oracle drivers.

Has anyone been able to reproduce this? 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

[web2py] Re: Oracle drivers.

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

[web2py] Re: Oracle drivers.

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: >> >>

[web2py] Re: Oracle drivers.

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

[web2py] Re: Oracle drivers.

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

[web2py] Re: Oracle drivers.

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 > >

[web2py] Re: Oracle drivers.

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

[web2py] Re: Oracle drivers.

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

[web2py] Re: Oracle drivers.

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) -

[web2py] Re: Oracle drivers.

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

[web2py] Re: Oracle drivers.

Well the dal tries to "import cx_Oracle" and it should work since it's installed - Weird. Did you already have web2py running before installing cx_Oracle and you didn't restart it (say by touching it's uwsgi config file)? -- Resources: - http://web2py.com - http://web2py.com/book

[web2py] Re: Oracle drivers.

yeah I tried spinning up another application in my Non-prod env. 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) and just changed the URI from: uri = sqlite://storage.sqlite to:

[web2py] Re: Oracle drivers.

You don't need to import it in your application the DAL does it for you. -- 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

[web2py] Re: Oracle drivers.

i was just trying to find some way to expose more of what going on. When I call Oracle in my DB configs uri = oracle://... I get this 1. 2. 3. 4. 5. 6. 7. 8. 9. 10. 11. 12. 13. 14. 15. 16. 17. 18. 19. 20. 21. 22. Traceback (most recent call last): File

[web2py] Re: Oracle drivers.

Forgot to paste the Error on my Non-Prod Virt. Versionweb2py™Version 2.12.3-stable+timestamp.2015.08.19.00.18.03Traceback 1. 2. 3. 4. 5. 6. 7. 8. 9. 10. 11. 12. 13. 14. 15. 16. 17. 18. 19. 20. 21. 22. Traceback (most recent call last): File "/opt/www-data/web2py/gluon/restricted.py", line