Is there something different with psycopg2 under web2py 2.3.2 ?
I get this error on a new server that I configure :
<type 'exceptions.RuntimeError'> Failure to connect, tried 5 times:
Traceback (most recent call last): File
"/home/www-data/web2py/gluon/dal.py", line 6853, in __init__ self._adapter
= ADAPTERS[self._dbname](**kwargs) File
"/home/www-data/web2py/gluon/dal.py", line 2493, in __init__ if do_connect:
self.find_driver(adapter_args,uri) File
"/home/www-data/web2py/gluon/dal.py", line 704, in find_driver raise
RuntimeError("driver %s not available" % request_driver) RuntimeError:
driver psycopg2 not available
python-psycopg2 is installed
For some reason I had to add apdater to my connection string like this :
db=DAL('postgres:psycopg2:...)
Because if I didn't not precise it, web2py seems to use pg8000 and I get
this error with pg8000 :
<type 'exceptions.ValueError'> invalid literal for int() with base 10:
'SELECT'
Traceback (most recent call last):
File "/home/www-data/web2py/gluon/restricted.py", line 212, in restricted
exec ccode in environment
File "/home/www-data/web2py/applications/sgddms/models/dict.py", line
121, in <module>
for r in db().select(db.dict_database.table_name,
db.dict_database.column_name, db.dict_database.column_name_en_ui)])
File "/home/www-data/web2py/gluon/dal.py", line 8905, in select
return adapter.select(self.query,fields,attributes)
File "/home/www-data/web2py/gluon/dal.py", line 1631, in select
return self._select_aux(sql,fields,attributes)
File "/home/www-data/web2py/gluon/dal.py", line 1597, in _select_aux
rows = self._fetchall()
File "/home/www-data/web2py/gluon/dal.py", line 1590, in _fetchall
return self.cursor.fetchall()
File "/home/www-data/web2py/gluon/contrib/pg8000/dbapi.py", line 246, in
_fn
return fn(self, *args, **kwargs)
File "/home/www-data/web2py/gluon/contrib/pg8000/dbapi.py", line 414, in
fetchall
return tuple(self.cursor.iterate_tuple())
File "/home/www-data/web2py/gluon/contrib/pg8000/interface.py", line 76,
in next
retval = self.func(self.obj)
File "/home/www-data/web2py/gluon/contrib/pg8000/interface.py", line 270,
in read_tuple
return self._fetch()
File "/home/www-data/web2py/gluon/contrib/pg8000/interface.py", line 205,
in _fetch
self._fill_cache()
File "/home/www-data/web2py/gluon/contrib/pg8000/interface.py", line 190,
in _fill_cache
end_of_data, rows = self.c.fetch_rows(self._portal_name,
self.row_cache_size, self._row_desc)
File "/home/www-data/web2py/gluon/contrib/pg8000/protocol.py", line 943,
in _fn
return fn(self, *args, **kwargs)
File "/home/www-data/web2py/gluon/contrib/pg8000/protocol.py", line 1249,
in fetch_rows
retval = reader.handle_messages()
File "/home/www-data/web2py/gluon/contrib/pg8000/protocol.py", line 906,
in handle_messages
msg = self._conn._read_message()
File "/home/www-data/web2py/gluon/contrib/pg8000/protocol.py", line 1038,
in _read_message
msg = message_types[message_code].createFromData(bytes)
File "/home/www-data/web2py/gluon/contrib/pg8000/protocol.py", line 783,
in createFromData
args['rows'] = int(values[-1])
ValueError: invalid literal for int() with base 10: 'SELECT'
I never really use pg8000, because it didn't works for me, maybe because of
my app code or issue with pg8000 in web2py, but I am more inclined in the
former (my app code).
I use ubuntu 12.10 and a custom Nginx installation with uwsgi emperor mode.
Could it be only because web2py is missing a dependance?
Thanks
Richard
On Tue, Dec 18, 2012 at 5:23 AM, Niphlod <[email protected]> wrote:
> totally unrelated.... epydoc folder in examples/static is 22mb. Leaving
> that one out and artwork.tar.gz (that seems to be a compressed version of
> examples/static/images) takes the compressed binary down to ~10 MB
> compressed/25MB uncompressed.
> Maybe a little cleanup in the next release will save everyone a few MB ?
>
>
> On Tuesday, December 18, 2012 9:20:54 AM UTC+1, apps in tables wrote:
>>
>> sorry, both are 45 mb after unzipping, (examples application 25 mb).
>>
>> On Tuesday, December 18, 2012 7:34:22 AM UTC+3, Massimo Di Pierro wrote:
>>>
>>> Are you sure about this? I cannot explain it. What's in the extra +30MB?
>>>
>>> On Monday, 17 December 2012 21:27:44 UTC-6, apps in tables wrote:
>>>>
>>>>
>>>> another advantage:
>>>>
>>>> 2.3.1 is 45 mb
>>>> 2.3.2 is 15 mb
>>>>
>>>> smaller is nicer...:)
>>>>
>>>>
>>>> On Monday, December 17, 2012 6:11:19 PM UTC+3, Massimo Di Pierro wrote:
>>>>>
>>>>> It is the same as 2.3.2 but fixed a major bug with NEWINSTALL being
>>>>> ignored and therefore not creating the welcome.w2p for the new scaffolding
>>>>> app.
>>>>>
>>>>> If you are using 2.3.1 you may still be using an older welcome instead
>>>>> of the cool new one. Upgrade to 2.3.2 to fix this.
>>>>>
>>>>> Massimo
>>>>>
>>>> --
>
>
>
>
--
