user autentication failed..why ? - Mailing list pgsql-general

From ZioBudda
Subject user autentication failed..why ?
Date
Msg-id Pine.LNX.4.03.9812031751060.13952-100000@michel.enter.it
Whole thread Raw
List pgsql-general
Hi, i have
*create the user michel with createuser (GID=501)
*start httpd/apache like michel/michel
*create the database esame with "michel" account
*insert a table in the database

and when i try to access via web/php to the database, but the dabase reply
me :

Warning: Unable to connect to PostgresSQL server: User authentication
failed in BaseSQL.php3 on line 24

and this is my piece of code:

 14   Function ConnectSQL () {
     15                        $hostname="esame.enter.it";
     16                        $username="postgres";
     17                        $password="l1mb0";
     18                        $dbName="esame";
     19                        $admin_email="";
     20                        $port = "5432";
     21
     22                        print("Connessione al server...");
     23                        /* Mi connetto al server */
     24                        $socket =
pg_connect($hostname,$port,"","",$dbName);
     25
     26                        if ($socket)
     27                          { print ("collegato");
     28                          }
     29                        else { print("connessione non
possibile...");
     30                               exit;
     31                             }

note that $password and $username are not used.

any help ?
now i have see that my httpd run on the port 801 and not on the port 80
(on the port 80 there is another apache/httpd). How can I see to connect
to server esame.enter.it:801.

Now, i have tried to change the master httpd/apache from nobody/nobody to
michel/michel but nothing happen

plz help

 "Il divertimento e' giusto se la scimmia ci prende gusto"
--
Italian Linux Press: http://ziobudda.enter.it/ILP/
--
Morelli 'ZioBudda' Davide Michel - Member of Pluto Linux User Group
michel@michel.enter.it - http://ziobudda.enter.it/
Linux Problem? Ask to linux@media.dsi.unimi.it
"/dev/ziobudda: access to /var/tmp/beer denied, use /var/adm/pineapple"


pgsql-general by date:

Previous
From: Nicholas Humfrey
Date:
Subject: Re: [GENERAL] Text Databases
Next
From: "David"
Date:
Subject: Can PostgreSQL handle this?