Hi Richard,
Thank you for your helpful reply. I am running the latest version of web2py
2_16_1. In order to query the version of psycpg2 which web2py is running
put the following code into a view:
{{import psycopg2}}
{{=psycopg2.__version__}}
This show web2py is running version 2.5.4 (dt dec pq3 ext)
I used PIP to install the latest version of psycpg2: 2.7.4 into my local
Python2.7 directory and I can talk to the database as expected. I am
wondering how to get the latest version of Psycpg into web2py.
Error message below:.. note changing "localhost" to a server running
postgres 9.3 everythings works fine.
Ticket ID
192.168.1.45.2018-03-01.15-25-12.2fa3bdd3-d668-4487-874a-3ca86557ad66
<type 'exceptions.RuntimeError'> Failure to connect, tried 5 times:
Traceback (most recent call last): File
"C:\web2py_2_16_1\gluon\packages\dal\pydal\base.py", line 454, in __init__
self._adapter = adapter(**kwargs) File
"C:\web2py_2_16_1\gluon\packages\dal\pydal\adapters\postgres.py", line 25,
in __call__ return AdapterMeta.__call__(cls, *args, **kwargs) File
"C:\web2py_2_16_1\gluon\packages\dal\pydal\adapters\__init__.py", line 40,
in __call__ obj = super(AdapterMeta, cls).__call__(*args, **kwargs) File
"C:\web2py_2_16_1\gluon\packages\dal\pydal\adapters\postgres.py", line 48,
in __init__ driver_args, adapter_args, do_connect, after_connection) File
"C:\web2py_2_16_1\gluon\packages\dal\pydal\adapters\base.py", line 368, in
__init__ super(SQLAdapter, self).__init__(*args, **kwargs) File
"C:\web2py_2_16_1\gluon\packages\dal\pydal\adapters\base.py", line 52, in
__init__ self.reconnect() File
"C:\web2py_2_16_1\gluon\packages\dal\pydal\helpers\classes.py", line 181,
in _reconnect_and_configure self._connection_reconnect() File
"C:\web2py_2_16_1\gluon\packages\dal\pydal\connection.py", line 172, in
reconnect self.connection = self.connector() File
"C:\web2py_2_16_1\gluon\packages\dal\pydal\adapters\postgres.py", line 105,
in connector return self.driver.connect(**self.driver_args) File
"psycopg2/__init__.py", line 164, in connect OperationalError: FATAL:
database "booster_i" does not existVersion
web2py™ Version 2.16.1-stable+timestamp.2017.11.14.05.54.25Traceback
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.
Traceback (most recent call last):
File "C:\web2py_2_16_1\gluon\restricted.py", line 219, in restricted
exec(ccode, environment)
File "C:/web2py_2_16_1/applications/Booster_I/models/db.py"
<https://192.168.1.45:8000/admin/default/edit/Booster_I/models/db.py>, line 20,
in <module>
db =
DAL('postgres://username:password@localhost/booster_i',pool_size=1,check_reserved=['all'],migrate_enabled=False)
File "C:\web2py_2_16_1\gluon\packages\dal\pydal\base.py", line 169, in
__call__
obj = super(MetaDAL, cls).__call__(*args, **kwargs)
File "C:\web2py_2_16_1\gluon\packages\dal\pydal\base.py", line 474, 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 "C:\web2py_2_16_1\gluon\packages\dal\pydal\base.py", line 454, in
__init__
self._adapter = adapter(**kwargs)
File "C:\web2py_2_16_1\gluon\packages\dal\pydal\adapters\postgres.py", line
25, in __call__
return AdapterMeta.__call__(cls, *args, **kwargs)
File "C:\web2py_2_16_1\gluon\packages\dal\pydal\adapters\__init__.py", line
40, in __call__
obj = super(AdapterMeta, cls).__call__(*args, **kwargs)
File "C:\web2py_2_16_1\gluon\packages\dal\pydal\adapters\postgres.py", line
48, in __init__
driver_args, adapter_args, do_connect, after_connection)
File "C:\web2py_2_16_1\gluon\packages\dal\pydal\adapters\base.py", line 368,
in __init__
super(SQLAdapter, self).__init__(*args, **kwargs)
File "C:\web2py_2_16_1\gluon\packages\dal\pydal\adapters\base.py", line 52,
in __init__
self.reconnect()
File "C:\web2py_2_16_1\gluon\packages\dal\pydal\helpers\classes.py", line
181, in _reconnect_and_configure
self._connection_reconnect()
File "C:\web2py_2_16_1\gluon\packages\dal\pydal\connection.py", line 172, in
reconnect
self.connection = self.connector()
File "C:\web2py_2_16_1\gluon\packages\dal\pydal\adapters\postgres.py", line
105, in connector
return self.driver.connect(**self.driver_args)
File "psycopg2/__init__.py", line 164, in connect
OperationalError: FATAL: database "booster_i" does not exist
In file: C:\web2py_2_16_1\applications\Booster_I\models\db.py
1.
<code object <module> at 0C8CBA40, file
"C:\web2py_2_16_1\applications\Booster_I\models\db.py", line 12>
On Thursday, March 1, 2018 at 2:39:18 PM UTC-5, Rob Paire wrote:
>
> Hello web2py community!
>
> I am in the process of moving a 4 year old web2py application to a new
> server and I am having trouble getting the application to connect to
> PostgreSQL 10.2. I am guessing because the version of psycopg2 driver in
> web2py is: 2.5.4 (dt dec pq3 ext)
>
> I installed the latest version of psycopg2 to my local Python installation
> and I can talk to the database, but how do I make web2py use the latest
> drivers? It is necessary to run from source to do this?
>
> Comments are appreciated.
>
> Thank you for your help!
> -Rob
>
--
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].
For more options, visit https://groups.google.com/d/optout.
