user autentication failed..why ?

From: ZioBudda <michel(at)michel(dot)enter(dot)it>
To: pgsql-general(at)postgresql(dot)org
Subject: user autentication failed..why ?
Date: 1998-12-03 17:07:26
Message-ID: Pine.LNX.4.03.9812031751060.13952-100000@michel.enter.it
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)michel(dot)enter(dot)it - http://ziobudda.enter.it/
Linux Problem? Ask to linux(at)media(dot)dsi(dot)unimi(dot)it
"/dev/ziobudda: access to /var/tmp/beer denied, use /var/adm/pineapple"

Browse pgsql-general by date

  From Date Subject
Next Message Nicholas Humfrey 1998-12-03 17:08:59 Re: [GENERAL] Text Databases
Previous Message David 1998-12-03 15:18:10 Can PostgreSQL handle this?