Re: [web2py] switching to postgres [RuntimeError: No driver of supported ones ('psycopg2',) is available]

2019-06-16 Thread Vlad
Yes, it was a typo. There were quite a few things that went wrong and I missed this one even after looking at it dozens of times, checking each character... It's perfect now. Thank you very much -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) -

[web2py] Re: how to restart we2py running as fastcgi process under Apache?

2019-06-16 Thread Jim Gregory
Turned out I had an old incompatible version of PIL on my production server. I removed it and now all seems to be OK. -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list

[web2py] web2py dynamic queries

2019-06-16 Thread Cristina Sig
Hello, I'm a newbie on python language so I'm struggling to do some queries. I have a table Student which I use to fill a table on view, above that table, I have a search box, where I would like to provide the option to search in multiple columns (phone, last name, first name, or nationality).

[web2py] how to restart we2py running as fastcgi process under Apache?

2019-06-16 Thread Jim Gregory
I just launched an app into production that uses the Python Imaging Library (PIL). PIL was installed on my local development environment, but not on my production server, and the app started throwing errors. I installed PIL on the server. If I launch the app in web2py's interactive command

Re: [web2py] switching to postgres [RuntimeError: No driver of supported ones ('psycopg2',) is available]

2019-06-16 Thread Val K
If you can connect from python It should work from web2py as well '?!' - is this typo? ( in postgres://test:x?!@...), I mean that password goes from : to @ On Sunday, June 16, 2019 at 10:49:27 PM UTC+3, Vlad wrote: > > I've got 50% of the answer. They require ssh tunnel to be used

[web2py] Re: please help: sycopg2.OperationalError: FATAL: password authentication failed for user "test"

2019-06-16 Thread Vlad
here is the full traceback, just in case: Version web2py™ Version 2.18.5-stable+timestamp.2019.04.08.04.22.03Traceback 1. 2. 3. 4. 5. 6. 7. 8. 9. 10. 11. 12. 13. 14. 15. 16. 17. 18. 19. 20. 21. 22. 23. 24. 25. 26. 27. 28. 29. 30. 31. 32. 33. 34. 35. 36. 37. 38. Traceback (most recent call

[web2py] please help: sycopg2.OperationalError: FATAL: password authentication failed for user "test"

2019-06-16 Thread Vlad
I'm bringing this from another post, because I've narrowed down the problem considerably, and it no longer corresponds neither to the headline nor to the content of that post. the following works fine, creating a valid connection: connection = psycopg2.connect(database="test_db", user="test",

Re: [web2py] switching to postgres [RuntimeError: No driver of supported ones ('psycopg2',) is available]

2019-06-16 Thread Vlad
I've got 50% of the answer. They require ssh tunnel to be used and don't allow any direct connection. I understand that there is security reason for that, yet I am at loss on how to handle this better. Keeping ssh tunnel alive is problematic (for development it's fine, but for production...)

Re: [web2py] Re: Web3py

2019-06-16 Thread Massimo DiPierro
Not with the usual syntax. Looking for a way to allow this in the new form api On Sun, Jun 16, 2019, 09:51 Fekete Zoltán wrote: > Hi Massimo, > > In web2py I highly rely on dynamically modifiable forms. Based on > calculations some fields are required or even hidden, others not. > > Will be

[web2py] Foreign key error after adding new table instance

2019-06-16 Thread Steve
Hi All, Busy with my platform, just added some tables. I have defined extra fields for the Auth table. In 1 of the aded fields i use a different table to get some info. 2 days ago i added 3 row's which are available for me to select. When i add a new user i am able te select one of those rows

Re: [web2py] switching to postgres [RuntimeError: No driver of supported ones ('psycopg2',) is available]

2019-06-16 Thread Vlad
Okay, I recreated it in a simplest form, to get rid of any extra parameters. Can't make it working neither on windows nor on linux. Here is exactly what's going on: *on linux: * the following code import psycopg2 connection = psycopg2.connect(database="test_db", user="test", password=

Re: [web2py] switching to postgres [RuntimeError: No driver of supported ones ('psycopg2',) is available]

2019-06-16 Thread Eliezer (Vlad) Tseytkin
On this one I run web2py on Windows. Using web2py from source. No idea what virtualenv is, so presumably not using it. Installed psycopg2 with pip3 specifically, to make sure it goes into the right Python. (I am not too familiar with this, but anything I install with pip goes to Python 2, and pip3

[web2py] switching to postgres [RuntimeError: No driver of supported ones ('psycopg2',) is available]

2019-06-16 Thread Val K
Did you restart web2py after installation? -- 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

[web2py] switching to postgres [RuntimeError: No driver of supported ones ('psycopg2',) is available]

2019-06-16 Thread Val K
What is your platform? How do you start web2py? Do you use virtualenv? This can happen when you have multiple pythons installed or if you use virtualenv.So you can install psycopg2 for one python, but web2py starts by another one. -- Resources: - http://web2py.com - http://web2py.com/book