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

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

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

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

2019-06-15 Thread Vlad
I am getting the following error: RuntimeError: No driver of supported ones ('psycopg2',) is available I used "pip3 install psycopg2" and pip now reports that psycopg2 is installed. What am I still missing? What's the best (quickest, easiest, and hassle-free) way to use postgres from web2py?