From bastiaaw@dds.nl Thu Sep 11 14:00:12 2003 X-Original-To: pgsql-php-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id 63DD7D1B576 for ; Thu, 11 Sep 2003 14:00:12 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024) with ESMTP id 41463-04 for ; Thu, 11 Sep 2003 10:59:43 -0300 (ADT) Received: from nebula.skynet.be (nebula.skynet.be [195.238.2.112]) by svr1.postgresql.org (Postfix) with ESMTP id 50896D1B4EC for ; Thu, 11 Sep 2003 10:59:39 -0300 (ADT) Received: from 95.8-136-217.adsl.skynet.be (95.8-136-217.adsl.skynet.be [217.136.8.95]) by nebula.skynet.be (8.12.9/8.12.9/Skynet-OUT-2.21) with ESMTP id h8BDxXPF024923 for ; Thu, 11 Sep 2003 15:59:33 +0200 (envelope-from ) Subject: Re: Help me From: Bastiaan Wakkie Reply-To: bwakkie@syrphidae.com To: pgsql-php@postgresql.org In-Reply-To: References: Content-Type: multipart/alternative; boundary="=-W9Awy4hjsbvT1u9cW0T2" Organization: www.syrphidae.com Message-Id: <1063201894.4596.3.camel@localhost.localdomain> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.2.4-1.1mdk Date: 10 Sep 2003 15:51:34 +0200 X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200309/43 X-Sequence-Number: 2320 --=-W9Awy4hjsbvT1u9cW0T2 Content-Type: text/plain Content-Transfer-Encoding: 7bit Hi, This message you will get when you use the command as root. login as the postgres user: su - postgres then start: postmaster -D /var/pgsql/data -i >logfile 2>&1 & regards, Bastiaan On Thu, 2003-09-11 at 12:22, Tran Anh Tu wrote: > Hi all! > I have installed Mandr > ake 9.0. and postgresql is installed automatically. > When I start postgresql by the command: > postmaster -i > have a error message: > > The server must be started under an unprivileged user id to prevent > a possible system security compromise. See the documentation for > more information on how to properly start the server. > > With Mandrake 8.0, I do nothing to config postgresql. So what I can do to > config it now? Please help me! thank you very much. > ******************************************************* > Tran Anh Tu > Vien CNTT - DHQG Ha Noi > Phone: 047680417-25 Email trantu@vnu.edu.vn > ******************************************************* > > > ---------------------------(end of broadcast)--------------------------- > TIP 9: the planner will ignore your desire to choose an index scan if your > joining column's datatypes do not match -- Bastiaan Wakkie www.syrphidae.com --=-W9Awy4hjsbvT1u9cW0T2 Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: 7bit Hi,

This message you will get when you use the command as root.

login as the postgres user:

   su - postgres

then start:

   postmaster -D /var/pgsql/data -i >logfile 2>&1 &

regards,
    Bastiaan

On Thu, 2003-09-11 at 12:22, Tran Anh Tu wrote:
Hi all!
I have installed Mandr
ake 9.0. and postgresql is installed automatically. 
When I start postgresql by the command: 
postmaster -i
have a error message:

The server must be started under an unprivileged user id to prevent
a possible system security compromise.  See the documentation for
more information on how to properly start the server.   

With Mandrake 8.0, I do nothing to config postgresql. So what I can do to 
config it now? Please help me! thank you very much.
*******************************************************
Tran Anh Tu
Vien CNTT - DHQG Ha Noi
Phone: 047680417-25   Email trantu@vnu.edu.vn
*******************************************************


---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
      joining column's datatypes do not match
--
Bastiaan Wakkie <bastiaaw@dds.nl>
www.syrphidae.com
--=-W9Awy4hjsbvT1u9cW0T2-- From trantu@vnu.edu.vn Thu Sep 11 10:24:16 2003 X-Original-To: pgsql-php-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id 2FF91D1B4F9 for ; Thu, 11 Sep 2003 10:24:16 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024) with ESMTP id 12083-02 for ; Thu, 11 Sep 2003 07:24:07 -0300 (ADT) Received: from vnu.edu.vn (mail.vnu.edu.vn [203.113.130.199]) by svr1.postgresql.org (Postfix) with ESMTP id 23A87D1B4F0 for ; Thu, 11 Sep 2003 07:24:02 -0300 (ADT) Received: from WorldClient ([127.0.0.1]) (authenticated user trantu@vnu.edu.vn) by vnu.edu.vn (vnu.edu.vn [203.113.130.199]) (MDaemon.PRO.v6.8.4.R) with ESMTP id 18-md50000000138.tmp for ; Thu, 11 Sep 2003 17:22:08 +0700 Received: from [10.6.1.63] via WorldClient with HTTP; Thu, 11 Sep 2003 17:22:07 +0700 Date: Thu, 11 Sep 2003 17:22:07 +0700 From: "Tran Anh Tu" To: pgsql-php@postgresql.org Subject: Help me Message-ID: X-Mailer: WorldClient 6.8.4 X-Authenticated-Sender: trantu@vnu.edu.vn X-Spam-Processed: vnu.edu.vn, Thu, 11 Sep 2003 17:22:08 +0700 (not processed: message from valid local sender) X-MDRemoteIP: 127.0.0.1 X-Return-Path: trantu@vnu.edu.vn X-MDaemon-Deliver-To: pgsql-php@postgresql.org X-Virus-Scanned: by amavisd-new at postgresql.org X-Spam-Status: No, hits=1.6 tagged_above=0.0 required=5.0 tests=BAYES_30, RCVD_IN_NJABL, RCVD_IN_OSIRUSOFT_COM, X_NJABL_OPEN_PROXY X-Spam-Level: * X-Archive-Number: 200309/26 X-Sequence-Number: 2303 Hi all! I have installed Mandrake 9.0. and postgresql is installed automatically. When I start postgresql by the command: postmaster -i have a error message: The server must be started under an unprivileged user id to prevent a possible system security compromise. See the documentation for more information on how to properly start the server. With Mandrake 8.0, I do nothing to config postgresql. So what I can do to config it now? Please help me! thank you very much. ******************************************************* Tran Anh Tu Vien CNTT - DHQG Ha Noi Phone: 047680417-25 Email trantu@vnu.edu.vn ******************************************************* From martin@bugs.unl.edu.ar Thu Sep 11 12:49:39 2003 X-Original-To: pgsql-php-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id CAF9CD1B544 for ; Thu, 11 Sep 2003 12:49:39 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024) with ESMTP id 21111-08 for ; Thu, 11 Sep 2003 09:49:12 -0300 (ADT) Received: from smtp1.gigared.com (unknown [200.68.216.5]) by svr1.postgresql.org (Postfix) with ESMTP id 3F852D1B51A for ; Thu, 11 Sep 2003 09:49:07 -0300 (ADT) Received: from 10.41.130.123 (unknown [10.41.130.123]) by smtp1.gigared.com (Postfix) with SMTP id 219C632A09; Thu, 11 Sep 2003 09:46:23 -0300 (GMT) From: Martin Marques To: "Tran Anh Tu" , pgsql-php@postgresql.org Subject: Re: Help me Date: Thu, 11 Sep 2003 09:46:29 -0300 User-Agent: KMail/1.5 References: In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Message-Id: <200309110946.29217.martin@bugs.unl.edu.ar> X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200309/27 X-Sequence-Number: 2304 El Jue 11 Sep 2003 07:22, Tran Anh Tu escribi=F3: > Hi all! > I have installed Mandrake 9.0. and postgresql is installed automatically. > When I start postgresql by the command: > postmaster -i > have a error message: > > The server must be started under an unprivileged user id to prevent > a possible system security compromise. See the documentation for > more information on how to properly start the server. How about executing: # /etc/init.d/postgresql start What happens then? --=20 Porqu=E9 usar una base de datos relacional cualquiera, si pod=E9s usar PostgreSQL? ----------------------------------------------------------------- Mart=EDn Marqu=E9s | mmarques@unl.edu.ar Programador, Administrador, DBA | Centro de Telematica Universidad Nacional del Litoral ----------------------------------------------------------------- From mueller@inf.ufsc.br Thu Sep 11 14:37:27 2003 X-Original-To: pgsql-php-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id C94ADD1B56B for ; Thu, 11 Sep 2003 14:37:27 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024) with ESMTP id 51431-02 for ; Thu, 11 Sep 2003 11:36:59 -0300 (ADT) Received: from terra.inf.ufsc.br (terra.inf.ufsc.br [150.162.60.10]) by svr1.postgresql.org (Postfix) with ESMTP id AF3B7D1B4E7 for ; Thu, 11 Sep 2003 11:36:50 -0300 (ADT) Received: from localhost (localhost [127.0.0.1]) by terra.inf.ufsc.br (Departamento de Informatica e Estatistica (INE/CTC/UFSC)) with ESMTP id 240311A709 for ; Thu, 11 Sep 2003 11:35:50 -0300 (BRT) Received: from juno (juno.inf.ufsc.br [150.162.60.3]) by terra.inf.ufsc.br (Departamento de Informatica e Estatistica (INE/CTC/UFSC)) with ESMTP id 51BDA18AE3 for ; Thu, 11 Sep 2003 11:35:47 -0300 (BRT) Date: Thu, 11 Sep 2003 11:36:43 -0300 (EST) From: Rafael Mueller X-X-Sender: mueller@juno To: pgsql-php@postgresql.org Subject: Re: Help me In-Reply-To: Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=ISO-8859-1 Content-Transfer-Encoding: QUOTED-PRINTABLE X-Virus-Scanned: by AMaViS 0.3.12pre5 X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200309/28 X-Sequence-Number: 2305 > When I start postgresql by the command: > postmaster -i > have a error message: $su postgres $pg_ctl -D /path/to/data/dir -o "-i" > a possible system security compromise. See the documentation for > more information on how to properly start the server. ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ +---------------------------------+ |Rafael Mueller | |CCO012 - Computa=E7=E3o - UFSC | |GNU/Linux User #271799 | |UIN #97699276 | |Dividir para conquistar! | +---------------------------------+ From scott.marlowe@ihs.com Thu Sep 11 19:20:15 2003 X-Original-To: pgsql-php-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id 67C73D1B54E for ; Thu, 11 Sep 2003 19:20:15 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024) with ESMTP id 92440-09 for ; Thu, 11 Sep 2003 16:19:44 -0300 (ADT) Received: from mail1.ihs.com (mail1.ihs.com [170.207.70.222]) by svr1.postgresql.org (Postfix) with ESMTP id 6350ED1B511 for ; Thu, 11 Sep 2003 16:19:42 -0300 (ADT) Received: from css120.ihs.com (css120.ihs.com [170.207.105.120]) by mail1.ihs.com (8.12.9/8.12.9) with ESMTP id h8BJIHMc002047; Thu, 11 Sep 2003 13:18:18 -0600 (MDT) Date: Thu, 11 Sep 2003 13:15:29 -0600 (MDT) From: "scott.marlowe" To: Tran Anh Tu Cc: Subject: Re: Help me In-Reply-To: Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-IHS-MailScanner: Found to be clean X-IHS-MailScanner-SpamCheck: X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200309/29 X-Sequence-Number: 2306 On Thu, 11 Sep 2003, Tran Anh Tu wrote: > Hi all! > I have installed Mandrake 9.0. and postgresql is installed automatically. > When I start postgresql by the command: > postmaster -i > have a error message: > > The server must be started under an unprivileged user id to prevent > a possible system security compromise. See the documentation for > more information on how to properly start the server. > > With Mandrake 8.0, I do nothing to config postgresql. So what I can do to > config it now? Please help me! thank you very much. Is this an RPM install or a .tar.gz install? If an RPM install, try, as root: service pgsql start Note that pgsql may not be the name, it could be something else. look for a file in /etc/rc.d/init.d with a name that seems like postgresql and substitute it for pgsql above. If it is a tar.gz install, you'll have to create an account (or use one that already exists) to 'initdb', set PGDATA and 'pg_ctl start' or 'postmaster -i -D datadir' From trantu@vnu.edu.vn Fri Sep 12 00:38:17 2003 X-Original-To: pgsql-php-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id 37C48D1B546 for ; Fri, 12 Sep 2003 00:38:17 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024) with ESMTP id 45141-08 for ; Thu, 11 Sep 2003 21:37:48 -0300 (ADT) Received: from vnu.edu.vn (mail.vnu.edu.vn [203.113.130.199]) by svr1.postgresql.org (Postfix) with ESMTP id 6A38FD1B50D for ; Thu, 11 Sep 2003 21:37:43 -0300 (ADT) Received: from WorldClient ([127.0.0.1]) (authenticated user trantu@vnu.edu.vn) by vnu.edu.vn (vnu.edu.vn [203.113.130.199]) (MDaemon.PRO.v6.8.4.R) with ESMTP id 37-md50000000145.tmp for ; Fri, 12 Sep 2003 07:35:45 +0700 Received: from [10.6.1.63] via WorldClient with HTTP; Fri, 12 Sep 2003 07:35:45 +0700 Date: Fri, 12 Sep 2003 07:35:45 +0700 From: "Tran Anh Tu" To: Subject: Re: Help me Message-ID: X-Mailer: WorldClient 6.8.4 X-Authenticated-Sender: trantu@vnu.edu.vn X-Spam-Processed: vnu.edu.vn, Fri, 12 Sep 2003 07:35:45 +0700 (not processed: message from valid local sender) X-MDRemoteIP: 127.0.0.1 X-Return-Path: trantu@vnu.edu.vn X-MDaemon-Deliver-To: pgsql-php@postgresql.org X-Virus-Scanned: by amavisd-new at postgresql.org X-Spam-Status: No, hits=0.7 tagged_above=0.0 required=5.0 tests=BAYES_30, RCVD_IN_NJABL, X_NJABL_OPEN_PROXY X-Spam-Level: X-Archive-Number: 200309/30 X-Sequence-Number: 2307 Hi all! Postgresql is installed automatically with rpm packets, It run perfectly with command : /etc/init.d/postgresql start But when I stop it and switch to user: postgres, and start it with command: postmaster -i then it does not working because It don't know where the database is placed. Please help me. ******************************************************* Tran Anh Tu Vien CNTT - DHQG Ha Noi Phone: 047680417-25 Email trantu@vnu.edu.vn ******************************************************* From trantu@vnu.edu.vn Fri Sep 12 00:41:55 2003 X-Original-To: pgsql-php-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id 38734D1B558 for ; Fri, 12 Sep 2003 00:41:55 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024) with ESMTP id 39853-10 for ; Thu, 11 Sep 2003 21:41:48 -0300 (ADT) Received: from vnu.edu.vn (mail.vnu.edu.vn [203.113.130.199]) by svr1.postgresql.org (Postfix) with ESMTP id A4097D1B500 for ; Thu, 11 Sep 2003 21:41:43 -0300 (ADT) Received: from WorldClient ([127.0.0.1]) (authenticated user trantu@vnu.edu.vn) by vnu.edu.vn (vnu.edu.vn [203.113.130.199]) (MDaemon.PRO.v6.8.4.R) with ESMTP id 42-md50000000145.tmp for ; Fri, 12 Sep 2003 07:40:20 +0700 Received: from [10.6.1.63] via WorldClient with HTTP; Fri, 12 Sep 2003 07:40:20 +0700 Date: Fri, 12 Sep 2003 07:40:20 +0700 From: "Tran Anh Tu" To: Subject: Re: Help me Message-ID: X-Mailer: WorldClient 6.8.4 X-Authenticated-Sender: trantu@vnu.edu.vn X-Spam-Processed: vnu.edu.vn, Fri, 12 Sep 2003 07:40:20 +0700 (not processed: message from valid local sender) X-MDRemoteIP: 127.0.0.1 X-Return-Path: trantu@vnu.edu.vn X-MDaemon-Deliver-To: pgsql-php@postgresql.org X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200309/31 X-Sequence-Number: 2308 Hi all! Postgresql is installed automatically with rpm packets, It run perfectly with command : /etc/init.d/postgresql start But when I stop it and switch to user: postgres, and start it with command: postmaster -i then it does not working because It don't know where the database is placed. A error message: postmaster does not know where to find the database system data. You must specify the directory that contains the database system either by specifying the -D invocation option or by setting the PGDATA environment variable. Please help me! ******************************************************* Tran Anh Tu Vien CNTT - DHQG Ha Noi Phone: 047680417-25 Email trantu@vnu.edu.vn ******************************************************* From gerd@MplusB.de Fri Sep 12 07:04:08 2003 X-Original-To: pgsql-php-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id F0921D1B4F0 for ; Fri, 12 Sep 2003 07:04:08 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024) with ESMTP id 11519-09 for ; Fri, 12 Sep 2003 04:03:39 -0300 (ADT) Received: from lighthouse.MplusB.de (lighthouse.MplusB.de [193.102.49.10]) by svr1.postgresql.org (Postfix) with ESMTP id E8A69D1B522 for ; Fri, 12 Sep 2003 04:03:36 -0300 (ADT) Received: from [193.102.49.130] (helo=compass.MplusB.de) by lighthouse.MplusB.de with esmtp (Exim 3.35 #1 (Debian)) id 19xhxt-0004s1-00; Fri, 12 Sep 2003 09:03:33 +0200 Received: from MplusB.de (gerd@sloop.MplusB.de [193.102.49.177]) by compass.MplusB.de (8.9.3p2/8.9.3/Debian 8.9.3-21) with ESMTP id JAA30692; Fri, 12 Sep 2003 09:03:33 +0200 X-Authentication-Warning: compass.MplusB.de: Host gerd@sloop.MplusB.de [193.102.49.177] claimed to be MplusB.de Message-ID: <3F616FC5.8010805@MplusB.de> Date: Fri, 12 Sep 2003 09:03:33 +0200 From: Gerd Terlutter User-Agent: Mozilla/5.0 (X11; U; Linux i586; en-US; rv:1.0.2) Gecko/20030401 Debian/1.0.2-2 X-Accept-Language: de-de MIME-Version: 1.0 To: Tran Anh Tu Cc: pgsql-php@postgresql.org Subject: Re: Help me References: Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200309/32 X-Sequence-Number: 2309 Tran Anh Tu wrote: > Hi all! ... > But when I stop it and switch to user: postgres, and start it with > command: postmaster -i then it does not working because It don't know > where the database is placed. A error message: > > postmaster does not know where to find the database system data. > Please help me! tran@tux$su - password:xxx root#su postgres tux:/root$ whoami postgres tux:/root$ cd tux$pwd /var/lib/postgres tux$ls -al does this help? greetings, Gerd -- -------------------------------------------------------- # Gerd Terlutter | Mueller+Blanck Software GmbH # # gerd@MplusB.de | Gutenbergring 38 # # gerd.terlutter@web.de | D-22848 Noderstedt # # tel:0171/6992579 | tel:+49 40 500 171-1 # # Buero:040/500171-17 | fax:+49 40 500 171-71 # -------------------------------------------------------- From trantu@vnu.edu.vn Fri Sep 12 07:29:30 2003 X-Original-To: pgsql-php-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id 30945D1B4E5 for ; Fri, 12 Sep 2003 07:29:30 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024) with ESMTP id 17663-07 for ; Fri, 12 Sep 2003 04:29:21 -0300 (ADT) Received: from vnu.edu.vn (mail.vnu.edu.vn [203.113.130.199]) by svr1.postgresql.org (Postfix) with ESMTP id BAAE7D1B50C for ; Fri, 12 Sep 2003 04:29:17 -0300 (ADT) Received: from WorldClient ([127.0.0.1]) (authenticated user trantu@vnu.edu.vn) by vnu.edu.vn (vnu.edu.vn [203.113.130.199]) (MDaemon.PRO.v6.8.4.R) with ESMTP id 50-md50000000153.tmp for ; Fri, 12 Sep 2003 14:27:44 +0700 Received: from [10.6.1.63] via WorldClient with HTTP; Fri, 12 Sep 2003 14:27:44 +0700 Date: Fri, 12 Sep 2003 14:27:44 +0700 From: "Tran Anh Tu" To: "Gerd Terlutter" , Subject: Re: Help me Message-ID: X-Mailer: WorldClient 6.8.4 In-Reply-To: <3F616FC5.8010805@MplusB.de> References: <3F616FC5.8010805@MplusB.de> X-Authenticated-Sender: trantu@vnu.edu.vn X-Spam-Processed: vnu.edu.vn, Fri, 12 Sep 2003 14:27:44 +0700 (not processed: message from valid local sender) X-MDRemoteIP: 127.0.0.1 X-Return-Path: trantu@vnu.edu.vn X-MDaemon-Deliver-To: pgsql-php@postgresql.org X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200309/33 X-Sequence-Number: 2310 I had checked the directory: /var/lib/pgsql (not postgres) It has some files but I can't do with it. I thought I had a prolems when install mandrake 9.0 and I installed it again but there is nothing to be change. When I start postgresql by the command: /etc/init.d/postgresql start then I type with user root: createdb demo Have a error message: user "root" does not exist What does this mean? please help me, thank you very much. ******************************************************* Tran Anh Tu Vien CNTT - DHQG Ha Noi Phone: 047680417-25 Email trantu@vnu.edu.vn ******************************************************* -----Original Message----- From: Gerd Terlutter To: Tran Anh Tu Cc: pgsql-php@postgresql.org Date: Fri, 12 Sep 2003 09:03:33 +0200 Subject: Re: [PHP] Help me > Tran Anh Tu wrote: > > Hi all! > > ... > > But when I stop it and switch to user: postgres, and start it with > > command: postmaster -i then it does not working because It don't know > > where the database is placed. A error message: > > > > postmaster does not know where to find the database system data. > > Please help me! > tran@tux$su - > password:xxx > root#su postgres > tux:/root$ whoami > postgres > tux:/root$ cd > tux$pwd > /var/lib/postgres > tux$ls -al > does this help? > > greetings, > Gerd > > -- > -------------------------------------------------------- > # Gerd Terlutter | Mueller+Blanck Software GmbH # > # gerd@MplusB.de | Gutenbergring 38 # > # gerd.terlutter@web.de | D-22848 Noderstedt # > # tel:0171/6992579 | tel:+49 40 500 171-1 # > # Buero:040/500171-17 | fax:+49 40 500 171-71 # > -------------------------------------------------------- > > > > ---------------------------(end of > broadcast)--------------------------- > TIP 7: don't forget to increase your free space map settings From trantu@vnu.edu.vn Fri Sep 12 09:10:06 2003 X-Original-To: pgsql-php-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id 6EF12D1B52F for ; Fri, 12 Sep 2003 09:10:06 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024) with ESMTP id 39090-01 for ; Fri, 12 Sep 2003 06:09:57 -0300 (ADT) Received: from vnu.edu.vn (mail.vnu.edu.vn [203.113.130.199]) by svr1.postgresql.org (Postfix) with ESMTP id 8C30AD1B50A for ; Fri, 12 Sep 2003 06:09:53 -0300 (ADT) Received: from WorldClient ([127.0.0.1]) (authenticated user trantu@vnu.edu.vn) by vnu.edu.vn (vnu.edu.vn [203.113.130.199]) (MDaemon.PRO.v6.8.4.R) with ESMTP id 52-md50000000156.tmp for ; Fri, 12 Sep 2003 16:08:18 +0700 Received: from [10.6.1.63] via WorldClient with HTTP; Fri, 12 Sep 2003 16:08:18 +0700 Date: Fri, 12 Sep 2003 16:08:18 +0700 From: "Tran Anh Tu" To: "andhie adam" , Subject: Re: Help me Message-ID: X-Mailer: WorldClient 6.8.4 In-Reply-To: <20030912073621.32029.qmail@linuxmail.org> References: <20030912073621.32029.qmail@linuxmail.org> X-Authenticated-Sender: trantu@vnu.edu.vn X-Spam-Processed: vnu.edu.vn, Fri, 12 Sep 2003 16:08:18 +0700 (not processed: message from valid local sender) X-MDRemoteIP: 127.0.0.1 X-Return-Path: trantu@vnu.edu.vn X-MDaemon-Deliver-To: pgsql-php@postgresql.org X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200309/35 X-Sequence-Number: 2312 It's OK.Thank you for your help. Best wishes to you. ******************************************************* Tran Anh Tu Vien CNTT - DHQG Ha Noi Phone: 047680417-25 Email trantu@vnu.edu.vn ******************************************************* -----Original Message----- From: "andhie adam" To: "Tran Anh Tu" Date: Fri, 12 Sep 2003 15:36:21 +0800 Subject: Re: [PHP] Help me > > >Hi all! > >Postgresql is installed automatically with rpm packets, It run > perfectly > >with command : /etc/init.d/postgresql start > >But when I stop it and switch to user: postgres, and start it with > >command: postmaster -i then it does not working because It don't know > >where the database is placed. A error message: > > >postmaster does not know where to find the database system data. > >You must specify the directory that contains the database system > >either by specifying the -D invocation option or by setting the > >PGDATA environment variable. > > >Please help me! > > if your postgresql is installed automatically with rpm packets. > before you start the postmaster, you must do it some steps like this... > 1. from root, you must login as postgres superuser with command " su > postgres" > # su postgres > 2. the next steps you must create database cluster, the command like > this... > $ initdb -D /var/lib/pgsql/data > 3. the finally steps, now you can start the postmaster (from postgres > super user) > like this... > $ postmaster -i -D /var/lib/pgsql/data > > I hope, my answer can help you > > regards > Andhie > > -- > ______________________________________________ > http://www.linuxmail.org/ > Now with e-mail forwarding for only US$5.95/yr > > Powered by Outblaze From trantu@vnu.edu.vn Fri Sep 12 09:51:13 2003 X-Original-To: pgsql-php-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id AEE19D1B504 for ; Fri, 12 Sep 2003 09:51:13 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024) with ESMTP id 47049-03 for ; Fri, 12 Sep 2003 06:51:05 -0300 (ADT) Received: from vnu.edu.vn (mail.vnu.edu.vn [203.113.130.199]) by svr1.postgresql.org (Postfix) with ESMTP id 4E133D1B4EB for ; Fri, 12 Sep 2003 06:51:01 -0300 (ADT) Received: from WorldClient ([127.0.0.1]) (authenticated user trantu@vnu.edu.vn) by vnu.edu.vn (vnu.edu.vn [203.113.130.199]) (MDaemon.PRO.v6.8.4.R) with ESMTP id 63-md50000000157.tmp for ; Fri, 12 Sep 2003 16:49:38 +0700 Received: from [10.6.1.63] via WorldClient with HTTP; Fri, 12 Sep 2003 16:49:38 +0700 Date: Fri, 12 Sep 2003 16:49:38 +0700 From: "Tran Anh Tu" To: "Kent L. Nasveschuk" , Subject: Re: Help me Message-ID: X-Mailer: WorldClient 6.8.4 In-Reply-To: <1063358556.2039.7.camel@1134> References: <3F616FC5.8010805@MplusB.de> <1063358556.2039.7.camel@1134> X-Authenticated-Sender: trantu@vnu.edu.vn X-Spam-Processed: vnu.edu.vn, Fri, 12 Sep 2003 16:49:38 +0700 (not processed: message from valid local sender) X-MDRemoteIP: 127.0.0.1 X-Return-Path: trantu@vnu.edu.vn X-MDaemon-Deliver-To: pgsql-php@postgresql.org X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200309/36 X-Sequence-Number: 2313 Yes, because I begin at learning Posgresql so have lots thing that I don't understand for. I hope I will receive your help. Thank you very much. ******************************************************* Tran Anh Tu Vien CNTT - DHQG Ha Noi Phone: 047680417-25 Email trantu@vnu.edu.vn ******************************************************* -----Original Message----- From: "Kent L. Nasveschuk" To: Tran Anh Tu Date: 12 Sep 2003 05:22:37 -0400 Subject: Re: [PHP] Help me > I believe that root user is not in the system catalog as a user. The > default user that Postgres installs is postgres. If you log in as that > user or change your user context to postgres you should have full > rights > from the local machine by default. As the user "postgres" you can > create > additional users with the command /{install path}/pgsql/bin/createuser. > Also you can alter user from the psql prompt. > > > Kent N > > On Fri, 2003-09-12 at 03:27, Tran Anh Tu wrote: > > I had checked the directory: > > /var/lib/pgsql (not postgres) > > It has some files but I can't do with it. I thought I had a prolems > when > > install mandrake 9.0 and I installed it again but there is nothing to > be > > change. > > When I start postgresql by the command: > > /etc/init.d/postgresql start > > then I type with user root: > > createdb demo > > Have a error message: > > user "root" does not exist > > What does this mean? please help me, thank you very much. > > ******************************************************* > > Tran Anh Tu > > Vien CNTT - DHQG Ha Noi > > Phone: 047680417-25 Email trantu@vnu.edu.vn > > ******************************************************* > > > > > > -----Original Message----- > > From: Gerd Terlutter > > To: Tran Anh Tu > > Cc: pgsql-php@postgresql.org > > Date: Fri, 12 Sep 2003 09:03:33 +0200 > > Subject: Re: [PHP] Help me > > > > > Tran Anh Tu wrote: > > > > Hi all! > > > > > > ... > > > > But when I stop it and switch to user: postgres, and start it > with > > > > command: postmaster -i then it does not working because It don't > know > > > > where the database is placed. A error message: > > > > > > > > postmaster does not know where to find the database system data. > > > > Please help me! > > > tran@tux$su - > > > password:xxx > > > root#su postgres > > > tux:/root$ whoami > > > postgres > > > tux:/root$ cd > > > tux$pwd > > > /var/lib/postgres > > > tux$ls -al > > > does this help? > > > > > > greetings, > > > Gerd > > > > > > -- > > > -------------------------------------------------------- > > > # Gerd Terlutter | Mueller+Blanck Software GmbH # > > > # gerd@MplusB.de | Gutenbergring 38 # > > > # gerd.terlutter@web.de | D-22848 Noderstedt # > > > # tel:0171/6992579 | tel:+49 40 500 171-1 # > > > # Buero:040/500171-17 | fax:+49 40 500 171-71 # > > > -------------------------------------------------------- > > > > > > > > > > > > ---------------------------(end of > > > broadcast)--------------------------- > > > TIP 7: don't forget to increase your free space map settings > > > > > > ---------------------------(end of > broadcast)--------------------------- > > TIP 7: don't forget to increase your free space map settings > -- > Kent L. Nasveschuk From trantu@vnu.edu.vn Sat Sep 13 02:00:04 2003 X-Original-To: pgsql-php-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id 824D3D1B51A for ; Sat, 13 Sep 2003 02:00:04 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024) with ESMTP id 92717-09 for ; Fri, 12 Sep 2003 22:59:37 -0300 (ADT) Received: from vnu.edu.vn (mail.vnu.edu.vn [203.113.130.199]) by svr1.postgresql.org (Postfix) with ESMTP id 74658D1B505 for ; Fri, 12 Sep 2003 22:59:31 -0300 (ADT) Received: from WorldClient ([127.0.0.1]) (authenticated user trantu@vnu.edu.vn) by vnu.edu.vn (vnu.edu.vn [203.113.130.199]) (MDaemon.PRO.v6.8.4.R) with ESMTP id 9-md50000000166.tmp for ; Sat, 13 Sep 2003 08:58:19 +0700 Received: from [10.6.1.63] via WorldClient with HTTP; Sat, 13 Sep 2003 08:58:18 +0700 Date: Sat, 13 Sep 2003 08:58:18 +0700 From: "Tran Anh Tu" To: "scott.marlowe" , Subject: Re: Help me Message-ID: X-Mailer: WorldClient 6.8.4 In-Reply-To: References: X-Authenticated-Sender: trantu@vnu.edu.vn X-Spam-Processed: vnu.edu.vn, Sat, 13 Sep 2003 08:58:19 +0700 (not processed: message from valid local sender) X-MDRemoteIP: 127.0.0.1 X-Return-Path: trantu@vnu.edu.vn X-MDaemon-Deliver-To: pgsql-php@postgresql.org X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200309/37 X-Sequence-Number: 2314 Hi all! I had started postgresql perfecly, thank you very much. After I start postgresql with command: /etc/init.d/postgresql start and I created a database: "waterdb" and a user: "trantu" with password "xxxx".Then I installed phpPgAdmin 3.0.1 with following lines in config.inc.php: $conf['servers'][0]['desc'] = 'gis-iti'; $conf['servers'][0]['host'] = '10.6.1.61'; // or '' $conf['servers'][0]['port'] = 5432; $conf['servers'][0]['defaultdb'] = 'waterdb'; When I run phpPgAdmin and login with the user "postgres" or "trantu", all are failed. I had try to start postgres with command: postmaster -i and run phpPgAdmin but there is no change. Please hepl me! ******************************************************* Tran Anh Tu Vien CNTT - DHQG Ha Noi Phone: 047680417-25 Email trantu@vnu.edu.vn ******************************************************* -----Original Message----- From: "scott.marlowe" To: Tran Anh Tu Date: Fri, 12 Sep 2003 09:09:19 -0600 (MDT) Subject: Re: [PHP] Help me > P.s. you should be able to get it so start as root with: > > service pgsql start > From martin@bugs.unl.edu.ar Sat Sep 13 13:57:26 2003 X-Original-To: pgsql-php-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id 7E237D1B4F9 for ; Sat, 13 Sep 2003 13:57:26 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024) with ESMTP id 18062-05 for ; Sat, 13 Sep 2003 10:56:59 -0300 (ADT) Received: from mail.unl.edu.ar (mail.unl.edu.ar [168.96.132.10]) by svr1.postgresql.org (Postfix) with SMTP id 689B2D1B4FE for ; Sat, 13 Sep 2003 10:56:54 -0300 (ADT) Received: (qmail 23881 invoked by uid 505); 13 Sep 2003 13:57:07 -0000 Received: from martin@bugs.unl.edu.ar by mail by uid 502 with qmail-scanner-1.16 (sophie: 2.14/3.70. Clear:. Processed in 0.028988 secs); 13 Sep 2003 13:57:07 -0000 Received: from bugs.unl.edu.ar (168.96.132.208) by mail.unl.edu.ar with SMTP; 13 Sep 2003 13:57:07 -0000 From: Martin Marques To: "Tran Anh Tu" Subject: Re: Help me Date: Sat, 13 Sep 2003 10:50:22 -0300 User-Agent: KMail/1.5.3 References: In-Reply-To: Cc: MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Message-Id: <200309131050.22440.martin@bugs.unl.edu.ar> X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200309/38 X-Sequence-Number: 2315 El Vie 12 Sep 2003 22:58, escribi=F3: > Hi all! > I had started postgresql perfecly, thank you very much. > After I start postgresql with command: > /etc/init.d/postgresql start > and I created a database: "waterdb" and a user: "trantu" with > password "xxxx".Then I installed phpPgAdmin 3.0.1 with following lines in > config.inc.php: > $conf['servers'][0]['desc'] =3D 'gis-iti'; > $conf['servers'][0]['host'] =3D '10.6.1.61'; // or '' > $conf['servers'][0]['port'] =3D 5432; > $conf['servers'][0]['defaultdb'] =3D 'waterdb'; > > When I run phpPgAdmin and login with the user "postgres" or "trantu", all > are failed. I had try to start postgres with command: > postmaster -i > and run phpPgAdmin but there is no change. Error messages? PostgreSQL logs? Apache, or PHP logs? Did you check your pg_hba.conf file to see if you have access to that datab= ase=20 from the IP you have the Apache running? --=20 10:48:01 up 22 days, 2:38, 3 users, load average: 0.15, 0.26, 0.27 ----------------------------------------------------------------- Mart=EDn Marqu=E9s | mmarques@unl.edu.ar Programador, Administrador, DBA | Centro de Telematica Universidad Nacional del Litoral ----------------------------------------------------------------- From trantu@vnu.edu.vn Sun Sep 14 01:24:57 2003 X-Original-To: pgsql-php-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id B8BDDD1B52B for ; Sun, 14 Sep 2003 01:24:57 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024) with ESMTP id 23255-04 for ; Sat, 13 Sep 2003 22:24:50 -0300 (ADT) Received: from vnu.edu.vn (mail.vnu.edu.vn [203.113.130.199]) by svr1.postgresql.org (Postfix) with ESMTP id EA6CBD1B526 for ; Sat, 13 Sep 2003 22:24:44 -0300 (ADT) Received: from WorldClient ([127.0.0.1]) (authenticated user trantu@vnu.edu.vn) by vnu.edu.vn (vnu.edu.vn [203.113.130.199]) (MDaemon.PRO.v6.8.4.R) with ESMTP id 30-md50000000176.tmp for ; Sun, 14 Sep 2003 08:23:28 +0700 Received: from [10.6.1.63] via WorldClient with HTTP; Sun, 14 Sep 2003 08:23:28 +0700 Date: Sun, 14 Sep 2003 08:23:28 +0700 From: "Tran Anh Tu" To: "Martin Marques" , Subject: Re: Help me Message-ID: X-Mailer: WorldClient 6.8.4 In-Reply-To: <200309131050.22440.martin@bugs.unl.edu.ar> References: <200309131050.22440.martin@bugs.unl.edu.ar> X-Authenticated-Sender: trantu@vnu.edu.vn X-Spam-Processed: vnu.edu.vn, Sun, 14 Sep 2003 08:23:28 +0700 (not processed: message from valid local sender) X-MDRemoteIP: 127.0.0.1 X-Return-Path: trantu@vnu.edu.vn X-MDaemon-Deliver-To: pgsql-php@postgresql.org X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200309/39 X-Sequence-Number: 2316 I started postgresql with command: /etc/init.d/postgresql start I created user 'trantu' with password 'hanoi' and this user have privileges fully to create database and create user. when I type a command: psql -U trantu -p hanoi or psql -U trantu -p hanoi waterdb have a same error: psql: could not connect to server: No such file or directory Is the server running locally and accepting connections on Unix domain socket "/tmp/.s.PGSQL.0"? With phpPgAdmin, apache and php are configured perfecly. Please help me to debug it. Thank you very much. ******************************************************* Tran Anh Tu Vien CNTT - DHQG Ha Noi Phone: 047680417-25 Email trantu@vnu.edu.vn ******************************************************* From kent@wareham.k12.ma.us Sun Sep 14 01:42:55 2003 X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id E1C65D1B528 for ; Sun, 14 Sep 2003 01:42:55 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024) with ESMTP id 32730-01 for ; Sat, 13 Sep 2003 22:42:47 -0300 (ADT) Received: from rwcrmhc12.comcast.net (rwcrmhc12.comcast.net [216.148.227.85]) by svr1.postgresql.org (Postfix) with ESMTP id C2EB0D1B526 for ; Sat, 13 Sep 2003 22:42:43 -0300 (ADT) Received: from [172.16.0.30] (h00508bcfaaed.ne.client2.attbi.com[65.96.103.108](untrusted sender)) by comcast.net (rwcrmhc12) with SMTP id <20030914014247014008ptu6e>; Sun, 14 Sep 2003 01:42:47 +0000 Subject: Re: [PHP] Help me From: "Kent L. Nasveschuk" To: Tran Anh Tu Cc: Postgres-Admin list In-Reply-To: References: <200309131050.22440.martin@bugs.unl.edu.ar> Content-Type: text/plain Organization: Message-Id: <1063502858.2747.3.camel@1134> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.2.2 (1.2.2-5) Date: 13 Sep 2003 21:27:39 -0400 Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200309/244 X-Sequence-Number: 10332 Are you connecting on the local machine? If so try without the -U and -p ex.: psql waterdb You can also use telnet or ssh and connect from a remote machine and do the same. Kent N On Sat, 2003-09-13 at 21:23, Tran Anh Tu wrote: > I started postgresql with command: > /etc/init.d/postgresql start > I created user 'trantu' with password 'hanoi' and this user have > privileges fully to create database and create user. > when I type a command: > psql -U trantu -p hanoi > or > psql -U trantu -p hanoi waterdb > have a same error: > psql: could not connect to server: No such file or directory > Is the server running locally and accepting > connections on Unix domain socket "/tmp/.s.PGSQL.0"? > > With phpPgAdmin, apache and php are configured perfecly. > Please help me to debug it. Thank you very much. > ******************************************************* > Tran Anh Tu > Vien CNTT - DHQG Ha Noi > Phone: 047680417-25 Email trantu@vnu.edu.vn > ******************************************************* > > > ---------------------------(end of broadcast)--------------------------- > TIP 5: Have you checked our extensive FAQ? > > http://www.postgresql.org/docs/faqs/FAQ.html -- Kent L. Nasveschuk . From trantu@vnu.edu.vn Sun Sep 14 02:21:10 2003 X-Original-To: pgsql-php-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id 19874D1B52B for ; Sun, 14 Sep 2003 02:21:10 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024) with ESMTP id 40101-01 for ; Sat, 13 Sep 2003 23:21:03 -0300 (ADT) Received: from vnu.edu.vn (mail.vnu.edu.vn [203.113.130.199]) by svr1.postgresql.org (Postfix) with ESMTP id 5EA93D1B526 for ; Sat, 13 Sep 2003 23:20:58 -0300 (ADT) Received: from WorldClient ([127.0.0.1]) (authenticated user trantu@vnu.edu.vn) by vnu.edu.vn (vnu.edu.vn [203.113.130.199]) (MDaemon.PRO.v6.8.4.R) with ESMTP id 54-md50000000176.tmp for ; Sun, 14 Sep 2003 09:19:02 +0700 Received: from [10.6.1.63] via WorldClient with HTTP; Sun, 14 Sep 2003 09:19:01 +0700 Date: Sun, 14 Sep 2003 09:19:01 +0700 From: "Tran Anh Tu" To: "Kent L. Nasveschuk" , Subject: Re: Help me Message-ID: X-Mailer: WorldClient 6.8.4 In-Reply-To: <1063502858.2747.3.camel@1134> References: <200309131050.22440.martin@bugs.unl.edu.ar> <1063502858.2747.3.camel@1134> X-Authenticated-Sender: trantu@vnu.edu.vn X-Spam-Processed: vnu.edu.vn, Sun, 14 Sep 2003 09:19:02 +0700 (not processed: message from valid local sender) X-MDRemoteIP: 127.0.0.1 X-Return-Path: trantu@vnu.edu.vn X-MDaemon-Deliver-To: pgsql-php@postgresql.org X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200309/40 X-Sequence-Number: 2317 If I type: psql waterdb I must login as postgres user. So what can I do to login using phpPgAdmin 3.0.1? ******************************************************* Tran Anh Tu Vien CNTT - DHQG Ha Noi Phone: 047680417-25 Email trantu@vnu.edu.vn ******************************************************* -----Original Message----- From: "Kent L. Nasveschuk" To: Tran Anh Tu Cc: Postgres-Admin list Date: 13 Sep 2003 21:27:39 -0400 Subject: Re: [PHP] Help me > Are you connecting on the local machine? If so try without the -U and > -p > > ex.: psql waterdb > > You can also use telnet or ssh and connect from a remote machine and do > the same. > > Kent N > > On Sat, 2003-09-13 at 21:23, Tran Anh Tu wrote: > > I started postgresql with command: > > /etc/init.d/postgresql start > > I created user 'trantu' with password 'hanoi' and this user have > > privileges fully to create database and create user. > > when I type a command: > > psql -U trantu -p hanoi > > or > > psql -U trantu -p hanoi waterdb > > have a same error: > > psql: could not connect to server: No such file or directory > > Is the server running locally and accepting > > connections on Unix domain socket "/tmp/.s.PGSQL.0"? > > > > With phpPgAdmin, apache and php are configured perfecly. > > Please help me to debug it. Thank you very much. > > ******************************************************* > > Tran Anh Tu > > Vien CNTT - DHQG Ha Noi > > Phone: 047680417-25 Email trantu@vnu.edu.vn > > ******************************************************* > > > > > > ---------------------------(end of > broadcast)--------------------------- > > TIP 5: Have you checked our extensive FAQ? > > > > http://www.postgresql.org/docs/faqs/FAQ.html > -- > Kent L. Nasveschuk > . From chriskl@familyhealth.com.au Sun Sep 14 04:58:11 2003 X-Original-To: pgsql-php-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id B8D7FD1B504 for ; Sun, 14 Sep 2003 04:58:11 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024) with ESMTP id 60953-03 for ; Sun, 14 Sep 2003 01:58:01 -0300 (ADT) Received: from houston.familyhealth.com.au (unknown [203.59.48.253]) by svr1.postgresql.org (Postfix) with ESMTP id 69739D1B4F5 for ; Sun, 14 Sep 2003 01:57:59 -0300 (ADT) Received: from houston.familyhealth.com.au (chriskl@localhost [127.0.0.1]) by houston.familyhealth.com.au (8.12.9/8.12.9) with ESMTP id h8E4vwO0089966; Sun, 14 Sep 2003 12:57:58 +0800 (WST) (envelope-from chriskl@familyhealth.com.au) Received: from localhost (chriskl@localhost) by houston.familyhealth.com.au (8.12.9/8.12.9/Submit) with ESMTP id h8E4vtMq089963; Sun, 14 Sep 2003 12:57:56 +0800 (WST) X-Authentication-Warning: houston.familyhealth.com.au: chriskl owned process doing -bs Date: Sun, 14 Sep 2003 12:57:55 +0800 (WST) From: Christopher Kings-Lynne To: Tran Anh Tu Cc: "Kent L. Nasveschuk" , Subject: Re: Help me In-Reply-To: Message-ID: <20030914125707.K89934-100000@houston.familyhealth.com.au> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200309/41 X-Sequence-Number: 2318 Login as the postgres user to phpPgAdmin user, and create a new user for yourself. Also, set a password for the postgres user. Then, edit your pg_hba.conf and set password access to 'md5', not 'trust'. Chris On Sun, 14 Sep 2003, Tran Anh Tu wrote: > If I type: psql waterdb I must login as postgres user. > So what can I do to login using phpPgAdmin 3.0.1? > ******************************************************* > Tran Anh Tu > Vien CNTT - DHQG Ha Noi > Phone: 047680417-25 Email trantu@vnu.edu.vn > ******************************************************* > > > -----Original Message----- > From: "Kent L. Nasveschuk" > To: Tran Anh Tu > Cc: Postgres-Admin list > Date: 13 Sep 2003 21:27:39 -0400 > Subject: Re: [PHP] Help me > > > Are you connecting on the local machine? If so try without the -U and > > -p > > > > ex.: psql waterdb > > > > You can also use telnet or ssh and connect from a remote machine and do > > the same. > > > > Kent N > > > > On Sat, 2003-09-13 at 21:23, Tran Anh Tu wrote: > > > I started postgresql with command: > > > /etc/init.d/postgresql start > > > I created user 'trantu' with password 'hanoi' and this user have > > > privileges fully to create database and create user. > > > when I type a command: > > > psql -U trantu -p hanoi > > > or > > > psql -U trantu -p hanoi waterdb > > > have a same error: > > > psql: could not connect to server: No such file or directory > > > Is the server running locally and accepting > > > connections on Unix domain socket "/tmp/.s.PGSQL.0"? > > > > > > With phpPgAdmin, apache and php are configured perfecly. > > > Please help me to debug it. Thank you very much. > > > ******************************************************* > > > Tran Anh Tu > > > Vien CNTT - DHQG Ha Noi > > > Phone: 047680417-25 Email trantu@vnu.edu.vn > > > ******************************************************* > > > > > > > > > ---------------------------(end of > > broadcast)--------------------------- > > > TIP 5: Have you checked our extensive FAQ? > > > > > > http://www.postgresql.org/docs/faqs/FAQ.html > > -- > > Kent L. Nasveschuk > > . > > > ---------------------------(end of broadcast)--------------------------- > TIP 6: Have you searched our list archives? > > http://archives.postgresql.org > From trantu@vnu.edu.vn Sun Sep 14 05:12:25 2003 X-Original-To: pgsql-php-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id C307BD1B514 for ; Sun, 14 Sep 2003 05:12:25 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024) with ESMTP id 52604-05 for ; Sun, 14 Sep 2003 02:12:15 -0300 (ADT) Received: from vnu.edu.vn (mail.vnu.edu.vn [203.113.130.199]) by svr1.postgresql.org (Postfix) with ESMTP id EA8A7D1B504 for ; Sun, 14 Sep 2003 02:12:12 -0300 (ADT) Received: from WorldClient ([127.0.0.1]) (authenticated user trantu@vnu.edu.vn) by vnu.edu.vn (vnu.edu.vn [203.113.130.199]) (MDaemon.PRO.v6.8.4.R) with ESMTP id 12-md50000000178.tmp for ; Sun, 14 Sep 2003 12:10:21 +0700 Received: from [10.6.1.63] via WorldClient with HTTP; Sun, 14 Sep 2003 12:10:20 +0700 Date: Sun, 14 Sep 2003 12:10:20 +0700 From: "Tran Anh Tu" To: Subject: Re: Help me Message-ID: X-Mailer: WorldClient 6.8.4 X-Authenticated-Sender: trantu@vnu.edu.vn X-Spam-Processed: vnu.edu.vn, Sun, 14 Sep 2003 12:10:21 +0700 (not processed: message from valid local sender) X-MDRemoteIP: 127.0.0.1 X-Return-Path: trantu@vnu.edu.vn X-MDaemon-Deliver-To: pgsql-php@postgresql.org X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200309/42 X-Sequence-Number: 2319 I can't login to phpPgAdmin with the user: postgres. It is display a error :Login failed. ******************************************************* Tran Anh Tu Vien CNTT - DHQG Ha Noi Phone: 047680417-25 Email trantu@vnu.edu.vn ******************************************************* -----Original Message----- From: Christopher Kings-Lynne To: Tran Anh Tu Cc: "Kent L. Nasveschuk" , Date: Sun, 14 Sep 2003 12:57:55 +0800 (WST) Subject: Re: [PHP] Help me > Login as the postgres user to phpPgAdmin user, and create a new user > for > yourself. > > Also, set a password for the postgres user. > > Then, edit your pg_hba.conf and set password access to 'md5', not > 'trust'. > > Chris > > > On Sun, 14 Sep 2003, Tran Anh Tu wrote: > > > If I type: psql waterdb I must login as postgres user. > > So what can I do to login using phpPgAdmin 3.0.1? > > ******************************************************* > > Tran Anh Tu > > Vien CNTT - DHQG Ha Noi > > Phone: 047680417-25 Email trantu@vnu.edu.vn > > ******************************************************* > > > > > > -----Original Message----- > > From: "Kent L. Nasveschuk" > > To: Tran Anh Tu > > Cc: Postgres-Admin list > > Date: 13 Sep 2003 21:27:39 -0400 > > Subject: Re: [PHP] Help me > > > > > Are you connecting on the local machine? If so try without the -U > and > > > -p > > > > > > ex.: psql waterdb > > > > > > You can also use telnet or ssh and connect from a remote machine > and do > > > the same. > > > > > > Kent N > > > > > > On Sat, 2003-09-13 at 21:23, Tran Anh Tu wrote: > > > > I started postgresql with command: > > > > /etc/init.d/postgresql start > > > > I created user 'trantu' with password 'hanoi' and this user have > > > > privileges fully to create database and create user. > > > > when I type a command: > > > > psql -U trantu -p hanoi > > > > or > > > > psql -U trantu -p hanoi waterdb > > > > have a same error: > > > > psql: could not connect to server: No such file or directory > > > > Is the server running locally and accepting > > > > connections on Unix domain socket "/tmp/.s.PGSQL.0"? > > > > > > > > With phpPgAdmin, apache and php are configured perfecly. > > > > Please help me to debug it. Thank you very much. > > > > ******************************************************* > > > > Tran Anh Tu > > > > Vien CNTT - DHQG Ha Noi > > > > Phone: 047680417-25 Email trantu@vnu.edu.vn > > > > ******************************************************* > > > > > > > > > > > > ---------------------------(end of > > > broadcast)--------------------------- > > > > TIP 5: Have you checked our extensive FAQ? > > > > > > > > http://www.postgresql.org/docs/faqs/FAQ.html > > > -- > > > Kent L. Nasveschuk > > > . > > > > > > ---------------------------(end of > broadcast)--------------------------- > > TIP 6: Have you searched our list archives? > > > > http://archives.postgresql.org > > > > > ---------------------------(end of > broadcast)--------------------------- > TIP 8: explain analyze is your friend From trantu@vnu.edu.vn Mon Sep 15 00:28:53 2003 X-Original-To: pgsql-php-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id F261AD1B501 for ; Mon, 15 Sep 2003 00:28:53 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024) with ESMTP id 32243-07 for ; Sun, 14 Sep 2003 21:28:46 -0300 (ADT) Received: from vnu.edu.vn (mail.vnu.edu.vn [203.113.130.199]) by svr1.postgresql.org (Postfix) with ESMTP id 50E86D1B4FF for ; Sun, 14 Sep 2003 21:28:41 -0300 (ADT) Received: from WorldClient ([127.0.0.1]) (authenticated user trantu@vnu.edu.vn) by vnu.edu.vn (vnu.edu.vn [203.113.130.199]) (MDaemon.PRO.v6.8.4.R) with ESMTP id 29-md50000000185.tmp for ; Mon, 15 Sep 2003 07:26:34 +0700 Received: from [10.6.1.63] via WorldClient with HTTP; Mon, 15 Sep 2003 07:26:34 +0700 Date: Mon, 15 Sep 2003 07:26:34 +0700 From: "Tran Anh Tu" To: "Christopher Kings-Lynne" , Subject: Re: Help me Message-ID: X-Mailer: WorldClient 6.8.4 In-Reply-To: <20030914181036.X90704-100000@houston.familyhealth.com.au> References: <20030914181036.X90704-100000@houston.familyhealth.com.au> X-Authenticated-Sender: trantu@vnu.edu.vn X-Spam-Processed: vnu.edu.vn, Mon, 15 Sep 2003 07:26:34 +0700 (not processed: message from valid local sender) X-MDRemoteIP: 127.0.0.1 X-Return-Path: trantu@vnu.edu.vn X-MDaemon-Deliver-To: pgsql-php@postgresql.org X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200309/44 X-Sequence-Number: 2321 Hi all. I edited pg_hba.conf and I had loged-in successfully from phpPgAdmin 3.0.1 but at the left frame of its have a warning and a error: Warning: Failed opening 'classes/HTML_TreeMenu/TreeMenu.php' for inclusion (include_path='.:/usr/lib/php/:/usr/lib/php/pear/') in /var/www/html/phpPgAdmin/browser.php on line 15 Fatal error: Cannot instantiate non-existent class: html_treemenu in /var/www/html/phpPgAdmin/browser.php on line 22 I try to install phpPgAdmin 2.4.2 and there is no error. What can I do next? ******************************************************* Tran Anh Tu Vien CNTT - DHQG Ha Noi Phone: 047680417-25 Email trantu@vnu.edu.vn ******************************************************* From chriskl@familyhealth.com.au Mon Sep 15 02:24:15 2003 X-Original-To: pgsql-php-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id A647CD1B50E for ; Mon, 15 Sep 2003 02:24:15 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024) with ESMTP id 51276-09 for ; Sun, 14 Sep 2003 23:23:47 -0300 (ADT) Received: from houston.familyhealth.com.au (unknown [203.59.48.253]) by svr1.postgresql.org (Postfix) with ESMTP id 969F6D1B4E2 for ; Sun, 14 Sep 2003 23:23:42 -0300 (ADT) Received: from mars (work-40.internal [192.168.0.40]) by houston.familyhealth.com.au (8.12.9/8.12.9) with SMTP id h8F2NhO0094513; Mon, 15 Sep 2003 10:23:44 +0800 (WST) (envelope-from chriskl@familyhealth.com.au) Message-ID: <013201c37b30$651d1fc0$2800a8c0@mars> From: "Christopher Kings-Lynne" To: "Tran Anh Tu" , References: <20030914181036.X90704-100000@houston.familyhealth.com.au> Subject: Re: Help me Date: Mon, 15 Sep 2003 10:23:46 +0800 MIME-Version: 1.0 Content-Type: text/plain; charset="Windows-1252" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1158 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165 X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200309/45 X-Sequence-Number: 2322 > Warning: Failed opening 'classes/HTML_TreeMenu/TreeMenu.php' for > inclusion (include_path='.:/usr/lib/php/:/usr/lib/php/pear/') > in /var/www/html/phpPgAdmin/browser.php on line 15 > > Fatal error: Cannot instantiate non-existent class: html_treemenu > in /var/www/html/phpPgAdmin/browser.php on line 22 Now that is very weird. '.' is in your include path, so it shouldn't have any problem including the files ??? Does the classes/HTML_TreeMenu/TreeMenu.php directory exist for you? What is your PHP version? Chris From trantu@vnu.edu.vn Mon Sep 15 03:10:41 2003 X-Original-To: pgsql-php-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id 23323D1B4ED for ; Mon, 15 Sep 2003 03:10:41 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024) with ESMTP id 61404-04 for ; Mon, 15 Sep 2003 00:10:10 -0300 (ADT) Received: from vnu.edu.vn (mail.vnu.edu.vn [203.113.130.199]) by svr1.postgresql.org (Postfix) with ESMTP id 5DFFED1B50F for ; Mon, 15 Sep 2003 00:10:08 -0300 (ADT) Received: from WorldClient ([127.0.0.1]) (authenticated user trantu@vnu.edu.vn) by vnu.edu.vn (vnu.edu.vn [203.113.130.199]) (MDaemon.PRO.v6.8.4.R) with ESMTP id 27-md50000000187.tmp for ; Mon, 15 Sep 2003 10:09:02 +0700 Received: from [10.6.1.63] via WorldClient with HTTP; Mon, 15 Sep 2003 10:09:02 +0700 Date: Mon, 15 Sep 2003 10:09:02 +0700 From: "Tran Anh Tu" To: "Christopher Kings-Lynne" , Subject: Re: Help me Message-ID: X-Mailer: WorldClient 6.8.4 In-Reply-To: <013201c37b30$651d1fc0$2800a8c0@mars> References: <20030914181036.X90704-100000@houston.familyhealth.com.au> <013201c37b30$651d1fc0$2800a8c0@mars> X-Authenticated-Sender: trantu@vnu.edu.vn X-Spam-Processed: vnu.edu.vn, Mon, 15 Sep 2003 10:09:02 +0700 (not processed: message from valid local sender) X-MDRemoteIP: 127.0.0.1 X-Return-Path: trantu@vnu.edu.vn X-MDaemon-Deliver-To: pgsql-php@postgresql.org X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200309/46 X-Sequence-Number: 2323 I list the packages have been installed in my system: mod_php-4.2.3-1mdk php-ldap-4.2.3-1mdk php-4.2.3-1mdk php-imap-4.2.3-1mdk php-pgsql-4.2.3-1mdk php-common-4.2.3-1mdk php-gd-4.2.3-1mdk php-mysql-4.2.3-1mdk php-readline-4.2.3-1mdk I checked the path access to php-libs: /usr/lib/php/extensions so I have added it to path_include of php.ini file but there is same error. It must have something wrong with php-lib but I don't know. Please help me. ******************************************************* Tran Anh Tu Vien CNTT - DHQG Ha Noi Phone: 047680417-25 Email trantu@vnu.edu.vn ******************************************************* -----Original Message----- From: "Christopher Kings-Lynne" To: "Tran Anh Tu" , Date: Mon, 15 Sep 2003 10:23:46 +0800 Subject: Re: [PHP] Help me > > Warning: Failed opening 'classes/HTML_TreeMenu/TreeMenu.php' for > > inclusion (include_path='.:/usr/lib/php/:/usr/lib/php/pear/') > > in /var/www/html/phpPgAdmin/browser.php on line 15 > > > > Fatal error: Cannot instantiate non-existent class: html_treemenu > > in /var/www/html/phpPgAdmin/browser.php on line 22 > > Now that is very weird. > > '.' is in your include path, so it shouldn't have any problem including > the > files ??? > > Does the classes/HTML_TreeMenu/TreeMenu.php directory exist for you? > What > is your PHP version? > > Chris > > > ---------------------------(end of > broadcast)--------------------------- > TIP 5: Have you checked our extensive FAQ? > > http://www.postgresql.org/docs/faqs/FAQ.html From chriskl@familyhealth.com.au Mon Sep 15 04:45:36 2003 X-Original-To: pgsql-php-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id 47F82D1B50E for ; Mon, 15 Sep 2003 04:45:36 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024) with ESMTP id 82405-02 for ; Mon, 15 Sep 2003 01:45:04 -0300 (ADT) Received: from houston.familyhealth.com.au (fhnet.arach.net.au [203.22.197.21]) by svr1.postgresql.org (Postfix) with ESMTP id 0BDF5D1B4F5 for ; Mon, 15 Sep 2003 01:45:03 -0300 (ADT) Received: from mars (work-40.internal [192.168.0.40]) by houston.familyhealth.com.au (8.12.9/8.12.9) with SMTP id h8F4ira3000629; Mon, 15 Sep 2003 12:44:57 +0800 (WST) (envelope-from chriskl@familyhealth.com.au) Message-ID: <004401c37b44$2034f540$2800a8c0@mars> From: "Christopher Kings-Lynne" To: "Tran Anh Tu" , References: <20030914181036.X90704-100000@houston.familyhealth.com.au> <013201c37b30$651d1fc0$2800a8c0@mars> Subject: Re: Help me Date: Mon, 15 Sep 2003 12:44:58 +0800 MIME-Version: 1.0 Content-Type: text/plain; charset="Windows-1252" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1158 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165 X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200309/48 X-Sequence-Number: 2325 I mean, do you have the classes/... directory in the directory where you installed phpPgAdmin? Chris ----- Original Message ----- From: "Tran Anh Tu" To: "Christopher Kings-Lynne" ; Sent: Monday, September 15, 2003 11:09 AM Subject: Re: [PHP] Help me > I list the packages have been installed in my system: > > mod_php-4.2.3-1mdk > php-ldap-4.2.3-1mdk > php-4.2.3-1mdk > php-imap-4.2.3-1mdk > php-pgsql-4.2.3-1mdk > php-common-4.2.3-1mdk > php-gd-4.2.3-1mdk > php-mysql-4.2.3-1mdk > php-readline-4.2.3-1mdk > > I checked the path access to php-libs: > /usr/lib/php/extensions > so I have added it to path_include of php.ini file but there is same > error. It must have something wrong with php-lib but I don't know. Please > help me. > ******************************************************* > Tran Anh Tu > Vien CNTT - DHQG Ha Noi > Phone: 047680417-25 Email trantu@vnu.edu.vn > ******************************************************* > > > -----Original Message----- > From: "Christopher Kings-Lynne" > To: "Tran Anh Tu" , > Date: Mon, 15 Sep 2003 10:23:46 +0800 > Subject: Re: [PHP] Help me > > > > Warning: Failed opening 'classes/HTML_TreeMenu/TreeMenu.php' for > > > inclusion (include_path='.:/usr/lib/php/:/usr/lib/php/pear/') > > > in /var/www/html/phpPgAdmin/browser.php on line 15 > > > > > > Fatal error: Cannot instantiate non-existent class: html_treemenu > > > in /var/www/html/phpPgAdmin/browser.php on line 22 > > > > Now that is very weird. > > > > '.' is in your include path, so it shouldn't have any problem including > > the > > files ??? > > > > Does the classes/HTML_TreeMenu/TreeMenu.php directory exist for you? > > What > > is your PHP version? > > > > Chris > > > > > > ---------------------------(end of > > broadcast)--------------------------- > > TIP 5: Have you checked our extensive FAQ? > > > > http://www.postgresql.org/docs/faqs/FAQ.html > From trantu@vnu.edu.vn Mon Sep 15 05:19:29 2003 X-Original-To: pgsql-php-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id 86FDFD1B509 for ; Mon, 15 Sep 2003 05:19:29 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024) with ESMTP id 81674-08 for ; Mon, 15 Sep 2003 02:18:58 -0300 (ADT) Received: from vnu.edu.vn (mail.vnu.edu.vn [203.113.130.199]) by svr1.postgresql.org (Postfix) with ESMTP id B5DD0D1B504 for ; Mon, 15 Sep 2003 02:18:53 -0300 (ADT) Received: from WorldClient ([127.0.0.1]) (authenticated user trantu@vnu.edu.vn) by vnu.edu.vn (vnu.edu.vn [203.113.130.199]) (MDaemon.PRO.v6.8.4.R) with ESMTP id 17-md50000000190.tmp for ; Mon, 15 Sep 2003 12:17:42 +0700 Received: from [10.6.1.63] via WorldClient with HTTP; Mon, 15 Sep 2003 12:17:42 +0700 Date: Mon, 15 Sep 2003 12:17:42 +0700 From: "Tran Anh Tu" To: "Christopher Kings-Lynne" , Subject: Re: Help me Message-ID: X-Mailer: WorldClient 6.8.4 In-Reply-To: <004401c37b44$2034f540$2800a8c0@mars> References: <20030914181036.X90704-100000@houston.familyhealth.com.au> <013201c37b30$651d1fc0$2800a8c0@mars> <004401c37b44$2034f540$2800a8c0@mars> X-Authenticated-Sender: trantu@vnu.edu.vn X-Spam-Processed: vnu.edu.vn, Mon, 15 Sep 2003 12:17:42 +0700 (not processed: message from valid local sender) X-MDRemoteIP: 127.0.0.1 X-Return-Path: trantu@vnu.edu.vn X-MDaemon-Deliver-To: pgsql-php@postgresql.org X-Virus-Scanned: by amavisd-new at postgresql.org X-Spam-Status: No, hits=0.3 tagged_above=0.0 required=5.0 tests=BAYES_30, IN_REP_TO, RCVD_IN_NJABL, REFERENCES, X_NJABL_OPEN_PROXY X-Spam-Level: X-Archive-Number: 200309/49 X-Sequence-Number: 2326 I'm sorry for my silly. I used SSH service to connect the host and it has changed the name of HTML_TreeMenu into html_treemenu so system could not open the TreeMenu.php. It's OK now. Thanh you for your help. Best wishes to you. ******************************************************* Tran Anh Tu Vien CNTT - DHQG Ha Noi Phone: 047680417-25 Email trantu@vnu.edu.vn *******************************************************