Re: [web2py] Re: Connection error standard_conforming_strings

2013-01-01 Thread Fernando Villarroel 
Yes psycopg2 is installed.

But i test the same aplication with another postgresql version (8.4)now my 
application running fine.

http://comments.gmane.org/gmane.comp.python.web2py/42824

I think the problem is the postgresql version 8.1. So i migrated my database to 
PostgreSQL 8.4 for solved my problem.

Regards.

Enviado desde mi iPhone

El 02-01-2013, a las 1:17, Massimo Di Pierro  
escribió:

>  you have psycopg2 installed?
> 
> On Tuesday, 1 January 2013 17:58:54 UTC-6, visuallinux wrote:
>> 
>> Dear All.
>> I am trying to migrate my web2py applications to the new version 2.3.2 and 
>> deploy with nginx + uwsgi but i am received the following error:
>> 
>> 
>> DEBUG: connect attempt 4, connection error:
>> Traceback (most recent call last):
>>   File "/home/www-data/web2py/gluon/dal.py", line 6771, in __init__
>> self._adapter = ADAPTERS[self._dbname](*args)
>>   File "/home/www-data/web2py/gluon/dal.py", line 2475, in __init__
>> self.after_connection()
>>   File "/home/www-data/web2py/gluon/dal.py", line 2479, in after_connection
>> self.execute("SET standard_conforming_strings=on;")
>>   File "/home/www-data/web2py/gluon/dal.py", line 1671, in execute
>> return self.log_execute(*a, **b)
>>   File "/home/www-data/web2py/gluon/dal.py", line 1665, in log_execute
>> ret = self.cursor.execute(*a, **b)
>> OperationalError: no se puede cambiar el parámetro 
>> «standard_conforming_strings»
>> 
>> I am using postgresql version 8.1.9
>> 
>> My db.py:
>> 
>> db = DAL('postgres://bla:foo@192.168.1.26:5432/cltes')
>> 
>> What i am doing wrong?
>> 
>> From the old web2py and apache apps running very well.
>> 
>> Regards.
>> 
> -- 
>  
>  
>  

--

[web2py] Re: Connection error standard_conforming_strings

2013-01-01 Thread Massimo Di Pierro 
 you have psycopg2 installed?

On Tuesday, 1 January 2013 17:58:54 UTC-6, visuallinux wrote:
>
> Dear All.
>
> I am trying to migrate my web2py applications to the new version 2.3.2 and 
> deploy with nginx + uwsgi but i am received the following error:
>
>
> DEBUG: connect attempt 4, connection error:
> Traceback (most recent call last):
>   File "/home/www-data/web2py/gluon/dal.py", line 6771, in __init__
> self._adapter = ADAPTERS[self._dbname](*args)
>   File "/home/www-data/web2py/gluon/dal.py", line 2475, in __init__
> self.after_connection()
>   File "/home/www-data/web2py/gluon/dal.py", line 2479, in after_connection
> self.execute("SET standard_conforming_strings=on;")
>   File "/home/www-data/web2py/gluon/dal.py", line 1671, in execute
> return self.log_execute(*a, **b)
>   File "/home/www-data/web2py/gluon/dal.py", line 1665, in log_execute
> ret = self.cursor.execute(*a, **b)
> OperationalError: no se puede cambiar el parámetro 
> «standard_conforming_strings»
>
> I am using postgresql version 8.1.9
>
> My db.py:
>
> db = DAL('postgres://bla:foo@192.168.1.26:5432/cltes')
>
> What i am doing wrong?
>
> From the old web2py and apache apps running very well.
>
> Regards.
>
>
>

--

[web2py] Re: Connection error standard_conforming_strings

2013-01-01 Thread Alan Etkin 
El martes, 1 de enero de 2013 20:58:54 UTC-3, visuallinux escribió:
>
> Dear All.
>
> I am trying to migrate my web2py applications to the new version 2.3.2 and 
> deploy with nginx + uwsgi but i am received the following error:
>

It seems that the adapter is failing to set a postgres parameter. I'd check 
there aren't any restrictions for the pg user connecting trough DAL that 
might prevent executing the command and also the db server access control 
settings.

--