Hi Dave, I found "pg8000" inside "gluon/contrib".
In "gluon\packages\dal\pydal\adapters" I found the "postgres.py". So is it wrong? Do I need to move pg8000 to "gluon\packages\dal\pydal\adapters"? You said about socket. I have no idea how to do it. Thanks a lot your support! Best regards Andre Em quinta-feira, 22 de fevereiro de 2018 18:30:17 UTC-3, Dave S escreveu: > > > > On Thursday, February 22, 2018 at 8:29:43 AM UTC-8, Morganti wrote: >> >> Hi, thanks your time. >> >> How can I check it? If I try to open web2py shell (web2py -S app -M), I >> had no errors and all tables could be used. >> >> Thanks >> BR >> André >> >> > That's one way to check. The actual files should show up in the > web2py/gluon/packages/dal/pydal/adapters, I think, and not just in > gluon/contrib. > > > But the error looks, to my inexpert eye, like a socket error. So I would > start by verifying the socket exists and has the proper permissions. > > /dps > > Em quinta-feira, 22 de fevereiro de 2018 13:08:23 UTC-3, Ovidio Marinho >> escreveu: >>> >>> make sure the pg8000 and psycopg2 libraries are installed at the start >>> of web2py >>> >>> >>> >>> >>> >>> >>> [image: http://itjp.net.br] <http://itjp.net.br> >>> http://itjp.net.b <http://itjp.net.br>r >>> *Ovidio Marinho Falcao Neto* >>> ovid...@gmail.com >>> Brasil >>> >>> >>> 2018-02-22 12:40 GMT-03:00 Morganti <acmor...@gmail.com>: >>> >>>> Hello, >>>> >>>> I have a VPS using ubuntu 16.04, nginx, Postgres and web2py 2.16.1. >>>> >>>> I tried to execute one controller that populate some tables and got the >>>> error below. >>>> >>>> Then, I used that command to create a csv file with all tables and >>>> uploaded it in my desktop using SQLITE and no error were found. >>>> >>>> The controller coud create some rows before the error. >>>> >>>> Traceback (most recent call last): >>>> File "/home/www-data/py27env/web2py/gluon/restricted.py", line 219, in >>>> restricted >>>> exec(ccode, environment) >>>> File >>>> "/home/www-data/py27env/web2py/applications/nwproducao/controllers/carreira.py", >>>> line 633, in <module> >>>> File "/home/www-data/py27env/web2py/gluon/globals.py", line 419, in >>>> <lambda> >>>> self._caller = lambda f: f() >>>> File >>>> "/home/www-data/py27env/web2py/applications/nwproducao/controllers/carreira.py", >>>> line 21, in gera_plano_carreira >>>> vgraduacao = gera_graduacao() >>>> File >>>> "/home/www-data/py27env/web2py/applications/nwproducao/controllers/carreira.py", >>>> line 56, in gera_graduacao >>>> for r in rows: >>>> File >>>> "/home/www-data/py27env/web2py/gluon/packages/dal/pydal/objects.py", line >>>> 3039, in __iter__ >>>> row = next(self) >>>> File >>>> "/home/www-data/py27env/web2py/gluon/packages/dal/pydal/objects.py", line >>>> 3014, in __next__ >>>> db_row = self.cursor.fetchone() >>>> File "/home/www-data/py27env/web2py/gluon/contrib/pg8000/core.py", line >>>> 947, in fetchone >>>> return next(self) >>>> File "/home/www-data/py27env/web2py/gluon/contrib/pg8000/core.py", line >>>> 1032, in __next__ >>>> self._c.handle_messages(self) >>>> File "/home/www-data/py27env/web2py/gluon/contrib/pg8000/core.py", line >>>> 2088, in handle_messages >>>> raise self.error >>>> ProgrammingError: (u'ERROR', u'34000', u'portal "pg8000_portal_13259" does >>>> not exist', u'postgres.c', u'1861', u'exec_execute_message', u'', u'') >>>> >>>> *Thanks your helping.* >>>> >>>> *Best regards* >>>> >>>> *Andre* >>>> >>>> -- >>>> 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. >>>> For more options, visit https://groups.google.com/d/optout. >>>> >>> >>> -- 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+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.