Received: from localhost (wm.hub.org [200.46.204.128]) by postgresql.org (Postfix) with ESMTP id F19919FB4CD for ; Tue, 17 Oct 2006 23:36:11 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.128]) (amavisd-new, port 10024) with ESMTP id 22377-05 for ; Wed, 18 Oct 2006 02:36:07 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey- Received: from news.hub.org (news.hub.org [200.46.204.72]) by postgresql.org (Postfix) with ESMTP id 5D1CB9FA5F7 for ; Tue, 17 Oct 2006 23:36:07 -0300 (ADT) Received: from news.hub.org (news.hub.org [200.46.204.72]) by news.hub.org (8.13.1/8.13.1) with ESMTP id k9I2ZvZc058350 for ; Tue, 17 Oct 2006 23:35:57 -0300 (ADT) (envelope-from news@news.hub.org) Received: (from news@localhost) by news.hub.org (8.13.1/8.13.1/Submit) id k9I2ZFTk058258 for pgsql-admin@postgresql.org; Tue, 17 Oct 2006 23:35:15 -0300 (ADT) (envelope-from news) From: "binberati" X-Newsgroups: pgsql.admin Subject: FastCgi / PostgreSQL: FATAL: Ident authentication failed for user "user_name" Date: 17 Oct 2006 19:35:17 -0700 Organization: http://groups.google.com Lines: 83 Message-ID: <1161138917.877386.269390@f16g2000cwb.googlegroups.com> Mime-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" X-Complaints-To: groups-abuse@google.com User-Agent: G2/1.0 X-HTTP-UserAgent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.0.7) Gecko/20060909 Firefox/1.5.0.7,gzip(gfe),gzip(gfe) Complaints-To: groups-abuse@google.com Injection-Info: f16g2000cwb.googlegroups.com; posting-host=80.126.241.99; posting-account=DsjHDw0AAAATRLWzyqj6J5-0igst9Q4V To: pgsql-admin@postgresql.org X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.001 tagged_above=0 required=5 tests=UNPARSEABLE_RELAY X-Spam-Level: X-Archive-Number: 200610/129 X-Sequence-Number: 23432 Hi, I have a strange problem running Django on a GrokThis.net shared hosting account: Environment: ------------------------------------------------------ Apache/2.0.59 (Unix) mod_fastcgi/2.4.2 PostgreSQL 8.1.3 ------------------------------------------------------ settings.py: ------------------------------------------------------ DATABASE_ENGINE = 'postgresql' DATABASE_USER = 'user_name' DATABASE_PASSWORD = '***' ------------------------------------------------------ or ------------------------------------------------------ DATABASE_ENGINE = 'postgresql_psycopg2' DATABASE_USER = 'user_name' DATABASE_PASSWORD = '***' ------------------------------------------------------ Django on FastCgi renders this error: ------------------------------------------------------ Traceback (most recent call last): File "/home/shared/user_name/django_src/django/template/__init__.py" in render_node 706. result = node.render(context) File "/home/shared/user_name/django_src/django/template/__init__.py" in render 757. return self.encode_output(output) File "/home/shared/user_name/django_src/django/template/__init__.py" in encode_output 739. return str(output) File "/home/shared/user_name/django_src/django/db/models/query.py" in __repr__ 97. return repr(self._get_data()) File "/home/shared/user_name/django_src/django/db/models/query.py" in _get_data 430. self._result_cache = list(self.iterator()) File "/home/shared/user_name/django_src/django/db/models/query.py" in iterator 170. cursor = connection.cursor() File "/home/shared/user_name/django_src/django/db/backends/postgresql/base.py" in cursor 43. self.connection = Database.connect(conn_string) OperationalError at / FATAL: Ident authentication failed for user "user_name" ------------------------------------------------------ Surprisingly, I can succesfully connect to the db using either: - psql - PostgreSQL interactive terminal - django-admin.py shell - django-admin.py dbshell - django development server - Navicat PostgreSQL from my own pc using ssh-tunnel The only circumstance in which I cannot seem to connect to the db is using the FastCgi instance, although it is configured to use the same settings file as above... [1] Can anybody shed a light on the difference between the FastCgi context and the ones mentioned above? I suspect it must have something to do with pg_hba.conf... but I can't see the difference between the contexts. [2] How do I resolve this issue? :) Thanks very much in advance! Best regards, bin