Обсуждение: Help me

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
*******************************************************

El Jue 11 Sep 2003 07:22, Tran Anh Tu escribió:
> 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?

--
Porqué usar una base de datos relacional cualquiera,
si podés usar PostgreSQL?
-----------------------------------------------------------------
Martín Marqués                  |        mmarques@unl.edu.ar
Programador, Administrador, DBA |       Centro de Telematica
                       Universidad Nacional
                            del Litoral
-----------------------------------------------------------------

> 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ção - UFSC       |
|GNU/Linux User #271799           |
|UIN #97699276                    |
|Dividir para conquistar!         |
+---------------------------------+

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'

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
*******************************************************

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
*******************************************************

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        #
--------------------------------------------------------

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 <gerd@MplusB.de>
To: Tran Anh Tu <trantu@vnu.edu.vn>
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

Tran Anh Tu wrote:

....
> 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.

After install PG and run it, you have to su postgres, and then
..$createuser xxxx
password: xxxx
best you choose your 'normal'user-account (name), pw can be another.
This PG-user has root-privilege on PG. Then you can adduser or create
DBs as normal user. To start/stop PG, use
root# /etc/init.d/postgresql [start/stop/restart...]

>>Tran Anh Tu wrote:
>>
>>>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        #
--------------------------------------------------------

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" <andhie@linuxmail.org>
To: "Tran Anh Tu" <trantu@vnu.edu.vn>
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 <ENTER>
> 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

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" <kent@wareham.k12.ma.us>
To: Tran Anh Tu <trantu@vnu.edu.vn>
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 <gerd@MplusB.de>
> > To: Tran Anh Tu <trantu@vnu.edu.vn>
> > 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 <kent@wareham.k12.ma.us>

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" <scott.marlowe@ihs.com>
To: Tran Anh Tu <trantu@vnu.edu.vn>
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
>

El Vie 12 Sep 2003 22:58, escribió:
> 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.

Error messages?
PostgreSQL logs?
Apache, or PHP logs?
Did you check your pg_hba.conf file to see if you have access to that database
from the IP you have the Apache running?

--
 10:48:01 up 22 days,  2:38,  3 users,  load average: 0.15, 0.26, 0.27
-----------------------------------------------------------------
Martín Marqués                  |        mmarques@unl.edu.ar
Programador, Administrador, DBA |       Centro de Telematica
                       Universidad Nacional
                            del Litoral
-----------------------------------------------------------------

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
*******************************************************

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" <kent@wareham.k12.ma.us>
To: Tran Anh Tu <trantu@vnu.edu.vn>
Cc: Postgres-Admin list <pgsql-admin@postgresql.org>
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 <kent@wareham.k12.ma.us>
> .

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" <kent@wareham.k12.ma.us>
> To: Tran Anh Tu <trantu@vnu.edu.vn>
> Cc: Postgres-Admin list <pgsql-admin@postgresql.org>
> 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 <kent@wareham.k12.ma.us>
> > .
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
>                http://archives.postgresql.org
>

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 <chriskl@familyhealth.com.au>
To: Tran Anh Tu <trantu@vnu.edu.vn>
Cc: "Kent L. Nasveschuk" <kent@wareham.k12.ma.us>, <pgsql-
php@postgresql.org>
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" <kent@wareham.k12.ma.us>
> > To: Tran Anh Tu <trantu@vnu.edu.vn>
> > Cc: Postgres-Admin list <pgsql-admin@postgresql.org>
> > 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 <kent@wareham.k12.ma.us>
> > > .
> >
> >
> > ---------------------------(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

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

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
*******************************************************

> 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

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" <chriskl@familyhealth.com.au>
To: "Tran Anh Tu" <trantu@vnu.edu.vn>, <pgsql-php@postgresql.org>
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

I mean, do you have the classes/... directory in the directory where you
installed phpPgAdmin?

Chris

----- Original Message -----
From: "Tran Anh Tu" <trantu@vnu.edu.vn>
To: "Christopher Kings-Lynne" <chriskl@familyhealth.com.au>;
<pgsql-php@postgresql.org>
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" <chriskl@familyhealth.com.au>
> To: "Tran Anh Tu" <trantu@vnu.edu.vn>, <pgsql-php@postgresql.org>
> 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
>

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
*******************************************************