X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 4B99BD1B187 for ; Mon, 21 Jun 2004 13:15:15 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 90086-02 for ; Mon, 21 Jun 2004 16:15:02 +0000 (GMT) Received: from webmail-outgoing.us4.outblaze.com (webmail-outgoing.us4.outblaze.com [205.158.62.67]) by svr1.postgresql.org (Postfix) with ESMTP id AFE80D1B262 for ; Mon, 21 Jun 2004 13:15:00 -0300 (ADT) Received: from wfilter.us4.outblaze.com (wfilter.us4.outblaze.com [205.158.62.180]) by webmail-outgoing.us4.outblaze.com (Postfix) with QMQP id 6B32A1800E2F for ; Mon, 21 Jun 2004 16:14:56 +0000 (GMT) X-OB-Received: from unknown (205.158.62.49) by 205.158.62.180; 21 Jun 2004 16:13:51 -0000 Received: by ws1-1.us4.outblaze.com (Postfix, from userid 1001) id C3DA24BDAC; Mon, 21 Jun 2004 16:14:43 +0000 (GMT) Content-Type: text/plain; charset="iso-8859-1" Content-Disposition: inline Content-Transfer-Encoding: 7bit MIME-Version: 1.0 X-Mailer: MIME-tools 5.41 (Entity 5.404) Received: from [134.157.46.135] by ws1-1.us4.outblaze.com with http for lise.chhay@mail.com; Mon, 21 Jun 2004 11:14:43 -0500 From: "lise chhay" To: pgsql-admin@postgresql.org Date: Mon, 21 Jun 2004 11:14:43 -0500 X-Originating-Ip: 134.157.46.135 X-Originating-Server: ws1-1.us4.outblaze.com Message-Id: <20040621161443.C3DA24BDAC@ws1-1.us4.outblaze.com> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200406/283 X-Sequence-Number: 13943 J have created the user auth under Unix and I did : # su - postgres postgres$ createuser auth User auth created postgres$ psql auth auth=# INSERT INTO groupes (groupe, descr) VALUES ('auth', 'Administrateurs de la base Auth') ; auth=# INSERT INTO utilisateurs (login, password, nom, prenom) VALUES ('auth', 'tnnxiPQeNdFYs', 'auth', 'auth') ; auth=# INSERT INTO membres (login, groupe) VALUES ('auth', 'auth') ; auth=# select * from groupes; groupe | descr --------+--------------------------------- auth | Administrateurs de la base Auth (1 row) auth=# select * from utilisateurs; login | password | nom | prenom | mel | tel | mobile | fax | adr | phnom | phprenom -------+---------------+------+--------+-----+-----+--------+-----+-----+-------+---------- auth | tnnxiPQeNdFYs | auth | auth | | | | | | A300 | A300 (1 row) auth=# select * from membres; login | groupe -------+-------- auth | auth (1 row) ------------------------------------------------------------------------------------------------------------- The content of my file pg_hba.conf is : local all all 127.0.0.1 255.255.255.255 password # IPv4-style local connections: host all all 127.0.0.1 255.255.255.255 password # IPv6-style local connections: host all all ::1 ffff:ffff:ffff:ffff:ffff:ffff:ffff:ffff trust ------------------------------------------------------------------------------------------------------------- The half of my config file httpd.conf : ScriptAlias "/applis/auth/bin/" "/local/services/www/applis/auth/bin/" AllowOverride None Options ExecCGI Order allow,deny Allow from localhost Allow from all AuthName "Intranet CRC" Auth_PG_host localhost Auth_PG_port 5432 Auth_PG_database auth Auth_PG_user auth # Auth_PG_pwd mot-de-passe-en-clair-de-auth Auth_PG_pwd auth Auth_PG_pwd_table utilisateurs Auth_PG_uid_field login Auth_PG_pwd_field password Auth_PG_grp_table membres Auth_PG_grp_group_field groupe Auth_PG_grp_user_field login AuthType Basic # require group authadmin require group auth # si vous avez une page prévue pour signaler les erreurs, mettez-la ici # ErrorDocument 401 /errauth/erreur.html # ErrorDocument 401 /local/services/www/applis/auth/lib/erreur.html AllowOverride None Options ExecCGI Order allow,deny Allow from localhost Allow from all order deny,allow deny from all Alias "/applis/auth" "/local/services/www/applis/auth" ---------------------------------------------------------------------------------------------------- When I launched http://localhost/applis/auth, I had an error : Internal Server Error The server encountered an internal error or misconfiguration and was unable to complete your request. Please contact the server administrator, you@example.com and inform them of the time the error occurred, and anything you might have done that may have caused the error. More information about this error may be available in the server error log. Apache/2.0.49 (Unix) mod_auth_pgsql/2.0.2b1 Server at localhost Port 80 ---------------------------------------------------------------------------------------- In my file /usr/local/apache2/logs/error_log, J have an error message : [Mon Jun 21 19:52:54 2004] [error] [client 127.0.0.1] mod_auth_pgsql database connection error reset failed FATAL: Password authentication failed for user "auth"\n [Mon Jun 21 19:53:02 2004] [error] [client 127.0.0.1] mod_auth_pgsql database connection error reset failed FATAL: Password authentication failed for user "auth"\n --------------------------------------------------------------------------------------- In my file /usr/local/apache2/logs/error_log, J have a message : localhost - auth [21/Jun/2004:19:52:54 +0200] "GET /applis/auth HTTP/1.1" 500 633 localhost - auth [21/Jun/2004:19:53:02 +0200] "GET /applis/auth HTTP/1.1" 500 633 --------------------------------------------------------------------------------------- I didn't manage to reach the database auth with the user auth. Can you help me, plese. thanks. -- ___________________________________________________________ Sign-up for Ads Free at Mail.com http://promo.mail.com/adsfreejump.htm