pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feed From: lise chhay <lise.chhay@mail.com>
To: pgsql-admin@postgresql.org
Date: Mon, 21 Jun 2004 11:14:43 -0500
Message-ID: <20040621161443.C3DA24BDAC@ws1-1.us4.outblaze.com> (raw )
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/"
<Directory /local/services/www/applis/auth>
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
</Directory>
<Directory "/local/services/www/applis/auth/bin">
AllowOverride None
Options ExecCGI
Order allow,deny
Allow from localhost
Allow from all
</Directory>
<Directory /local/services/www/applis/auth/lib>
order deny,allow
deny from all
</Directory>
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
view thread (2+ messages) latest in thread
Message-ID: <20040621161443.C3DA24BDAC@ws1-1.us4.outblaze.com>
Permalink: ../20040621161443.C3DA24BDAC@ws1-1.us4.outblaze.com/
Also on: postgresql.org/message-id/20040621161443.C3DA24BDAC@ws1-1.us4.outblaze.com
copy link · copy postgr.es
reply Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: lise.chhay@mail.com
Subject: Re:
In-Reply-To: <20040621161443.C3DA24BDAC@ws1-1.us4.outblaze.com>
References: <20040621161443.C3DA24BDAC@ws1-1.us4.outblaze.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox