I know. It is there and we distribute it but we will remove it in the next version. I run into lots of problems with it, even with simple apps. psycopg2 works instead.
On Friday, 23 February 2018 04:57:41 UTC-6, Morganti wrote: > > 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* >>>> [email protected] >>>> Brasil >>>> >>>> >>>> 2018-02-22 12:40 GMT-03:00 Morganti <[email protected]>: >>>> >>>>> 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 [email protected]. >>>>> 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 [email protected]. For more options, visit https://groups.google.com/d/optout.
