... - Mailing list pgsql-admin

From lise chhay
Subject ...
Date
Msg-id 20040621161443.C3DA24BDAC@ws1-1.us4.outblaze.com
Whole thread Raw
Responses Re:
List pgsql-admin
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


pgsql-admin by date:

Previous
From: Carlos Benkendorf
Date:
Subject: UNDO
Next
From: "Lee Wu"
Date:
Subject: Re: bad data with Foreign Key constraint