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: 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 availableVersão
web2py™ Version 2.20.4-stable+timestamp.2020.05.03.05.18.50Traceback
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"
<https://cires.opalstacked.com/admin/default/edit/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
--
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].
To view this discussion on the web visit
https://groups.google.com/d/msgid/web2py/CAEM0BxNNZmWyDf2aKcHQJHs4TNsF7puXnV0VJ%2BWdCjjt0AewFA%40mail.gmail.com.
