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, [EMAIL PROTECTED] 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


---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
    (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])

Reply via email to