opalstack dal connection time out ?

50 views
Skip to first unread message

António Ramos

unread,
Oct 19, 2020, 11:56:05 AM10/19/20
to web...@googlegroups.com
hello i´m starting my journey on Opalstack and my app cant connect to the postgresql db

 db = DAL('postgres://user:pwdXru@localhost:5432/database',

the previous line does not work. I checked that psycopg2 is available in python command line
image.png

<class 'RuntimeError'> Failure to connect, tried 5 times: Traceback (most recent call last): File "/home/ramos/apps/fileit/web2py/gluon/packages/dal/pydal/base.py", line 507, in __init__ self._adapter = adapter(**kwargs) File "/home/ramos/apps/fileit/web2py/gluon/packages/dal/pydal/adapters/postgres.py", line 28, in __call__ return AdapterMeta.__call__(cls, *args, **kwargs) File "/home/ramos/apps/fileit/web2py/gluon/packages/dal/pydal/adapters/__init__.py", line 41, in __call__ obj = super(AdapterMeta, cls).__call__(*args, **kwargs) File "/home/ramos/apps/fileit/web2py/gluon/packages/dal/pydal/adapters/postgres.py", line 67, in __init__ after_connection, File "/home/ramos/apps/fileit/web2py/gluon/packages/dal/pydal/adapters/base.py", line 417, in __init__ super(SQLAdapter, self).__init__(*args, **kwargs) File "/home/ramos/apps/fileit/web2py/gluon/packages/dal/pydal/adapters/base.py", line 85, in __init__ self.find_driver() File "/home/ramos/apps/fileit/web2py/gluon/packages/dal/pydal/adapters/base.py", line 134, in find_driver "No driver of supported ones %s is available" % str(self.drivers) RuntimeError: No driver of supported ones ('psycopg2',) is available

Versão

web2py™Version 2.20.4-stable+timestamp.2020.05.03.05.18.50

Traceback

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.
Traceback (most recent call last):
  File "/home/ramos/apps/fileit/web2py/gluon/restricted.py", line 219, in restricted
    exec(ccode, environment)
  File "/home/ramos/apps/fileit/web2py/applications/fileit/models/db1.py", line 34, in <module>
    check_reserved=['mysql', 'postgres'])  # ['all'])
  File "/home/ramos/apps/fileit/web2py/gluon/packages/dal/pydal/base.py", line 209, in __call__
    obj = super(MetaDAL, cls).__call__(*args, **kwargs)
  File "/home/ramos/apps/fileit/web2py/gluon/packages/dal/pydal/base.py", line 526, 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 "/home/ramos/apps/fileit/web2py/gluon/packages/dal/pydal/base.py", line 507, in __init__
    self._adapter = adapter(**kwargs)
  File "/home/ramos/apps/fileit/web2py/gluon/packages/dal/pydal/adapters/postgres.py", line 28, in __call__
    return AdapterMeta.__call__(cls, *args, **kwargs)
  File "/home/ramos/apps/fileit/web2py/gluon/packages/dal/pydal/adapters/__init__.py", line 41, in __call__
    obj = super(AdapterMeta, cls).__call__(*args, **kwargs)
  File "/home/ramos/apps/fileit/web2py/gluon/packages/dal/pydal/adapters/postgres.py", line 67, in __init__
    after_connection,
  File "/home/ramos/apps/fileit/web2py/gluon/packages/dal/pydal/adapters/base.py", line 417, in __init__
    super(SQLAdapter, self).__init__(*args, **kwargs)
  File "/home/ramos/apps/fileit/web2py/gluon/packages/dal/pydal/adapters/base.py", line 85, in __init__
    self.find_driver()
  File "/home/ramos/apps/fileit/web2py/gluon/packages/dal/pydal/adapters/base.py", line 134, in find_driver
    "No driver of supported ones %s is available" % str(self.drivers)
RuntimeError: No driver of supported ones ('psycopg2',) is available

Jose C

unread,
Oct 19, 2020, 3:03:48 PM10/19/20
to web2py-users
I'm also on opal5 using postgres but still on web2py 2.18.5 (can't upgrade due to unresolved redis session issue).

I suspect you have a library version problem.

You're using the default system-wide python3 install, which is using psycopg2 version 2.7.7.  (Run psycopg2.__version__ at the command line after importing).

The highly recommended way to do this (to avoid conflicts and maintain your sanity) is to create yourself a virtual environment for your web2py app.  Then pip install psycopg2-binary (plus whatever other packages you need for that app) which installs version 2.8.4 of the psycopg2 library.

Using this combo you should have no issues.

HTH,

António Ramos

unread,
Oct 19, 2020, 4:51:00 PM10/19/20
to web...@googlegroups.com
got the answer from support

Hi António, if you need psycopg2 then please install it like this:

export PATH=/usr/pgsql-11/bin/:$PATH
cd ~/apps/fileit
source env/bin/activate
pip install psycopg2

--
Sean from (((Opalstack


It worked for me ....

thank 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 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 web2py+un...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/web2py/8ef9403c-b1e5-4d15-b638-360cfcf3095eo%40googlegroups.com.

Jose C

unread,
Oct 19, 2020, 5:10:32 PM10/19/20
to web2py-users


On Monday, 19 October 2020 21:51:00 UTC+1, Ramos wrote:
got the answer from support

Hi António, if you need psycopg2 then please install it like this:

export PATH=/usr/pgsql-11/bin/:$PATH
cd ~/apps/fileit
source env/bin/activate
pip install psycopg2


Glad to hear it's working.  The above is installing the latest psycopg2 version into your virtual environment. 

Gaël Princivalle

unread,
Oct 22, 2020, 6:26:28 AM10/22/20
to web2py-users
I've got the same problem and I've tried to fix it installing it as described.
It works but you must stop and restart your virtual environment.
Reply all
Reply to author
Forward
0 new messages