Permission denied problem

Hello Everyone,

I'm having a strange problem for weeks in my FreeBSD server and I tried
everything I could.

I am developing with Django + Postgresql and I have two servers, one for app
and one for DB. At the beggining it was working fine, but few weeks ago I
started to get many many permission denied problem. And worst, it seems to
be quite random, because if I try to access the same page that I got the
error again, it works fine.

I looked at postgresql and pgbouncer log, apache log, and there's no clue,
so I believe it could be something related to psycopg2.I looked at 2.0.8
release date and it seemed to be about the time I started to get that error.

I tried to use solutions for many issues related to Permission denied
problem, but no luck and I finally saw this post:

http://lists.initd.org/pipermail/psycopg/2008-May/006075.html

Maybe it could be the reason, but I don't know if this is already fixed on
current version.

The two most common error's traceback are:

"""

 File
"/home/webmaster/requirements/django_1.0/django/db/models/sql/query.py",
line 206, in results_iter
  for rows in self.execute_sql(MULTI):

 File
"/home/webmaster/requirements/django_1.0/django/db/models/sql/query.py",
line 1724, in execute_sql
  cursor.execute(sql, params)

OperationalError: could not send data to server: Permission denied

"""

and

"""

{'/home/webmaster/projects/paranaonline/pronline/mailing/sendmail.py': True}
Traceback (most recent call last):
 File "/home/webmaster/projects/paranaonline/pronline/mailing/sendmail.py",
line 78, in <module>
  transaction.rollback()
 File "/home/webmaster/requirements/django_1.0/django/db/transaction.py",
line 172, in rollback
  connection._rollback()
 File
"/home/webmaster/requirements/django_1.0/django/db/backends/__init__.py",
line 32, in _rollback
  return self.connection.rollback()
psycopg2.OperationalError: could not send data to server: Permission denied

"""

any help about what could be the reasons or at least where I can start
looking?

Cheers,

Anderson


-- 
Anderson Santos
======================
Orangotoe - Paraná Online
tel: +55 41 3078-5264
[email protected]

_______________________________________________
Psycopg mailing list
Psycopg-IAPFreCvJWPBWskQ1e/[email protected]
http://lists.initd.org/mailman/listinfo/psycopg