HOWTO: Install phpPgAdmin to support Postgresql db's using C

[ozzi4648]

[quote:3a4e0e16ae][i:3a4e0e16ae]Originally posted by iminteractive[/i:3a4e0e16ae]

I've got the latest apache, but buildapache doesn't come with postgre.. and its not there at all, ive looked and looked again.[/quote:3a4e0e16ae]

It should be locate here:

/usr/share/doc/postgresql-7.1.3

do a locate postgresql

If not, you will have to install it!

[haze]

I've already done that, and I've already come to that conclusion, thats why im wondering what the best ./configure would be

[ozzi4648]

[quote:c51d178c8a][i:c51d178c8a]Originally posted by iminteractive[/i:c51d178c8a]

I've already done that, and I've already come to that conclusion, thats why im wondering what the best ./configure would be [/quote:c51d178c8a]

Check webhosting manger select RPM Package installer the scroll down to postgresql. It should say the following:

postgresql(reinstall)
postgresql-devel(resinstall)
postgresql-libs(resinstall)
postgresql-server(resinstall)

If those options are installed then select the options above and force and install. After that compile php-4.2.3 using the example in my tutorial with postgresql support. It seems we should take this to private.

[ozzi4648]

Your best config for php would be --with-pgsql=/usr. You need to add that to the ./config if its not already there. I think thats what your asking but im not sure. WOW!

[haze]

I'll try the rpm method, tho I would have preffered to do it from source. I already have the --with-pgsql=/usr as per the tutorial in the URL you gave me.. I was reffering to the ./config when you compile postgre from source, but I suppose I won't need that with the RPM install. Anyways.. here I go.

[ozzi4648]

[quote:10015b0c2a][i:10015b0c2a]Originally posted by iminteractive[/i:10015b0c2a]

I'll try the rpm method, tho I would have preffered to do it from source. I already have the --with-pgsql=/usr as per the tutorial in the URL you gave me.. I was reffering to the ./config when you compile postgre from source, but I suppose I won't need that with the RPM install. Anyways.. here I go.[/quote:10015b0c2a]

Or from source

./configure
gmake
su
gmake install
adduser postgres
mkdir /usr/local/pgsql/data
chown postgres /usr/local/pgsql/data
su - postgres
/usr/local/pgsql/bin/initdb -D /usr/local/pgsql/data
/usr/local/pgsql/bin/postmaster -D /usr/local/pgsql/data &logfile 2&&1 &
/usr/local/pgsql/bin/createdb test
/usr/local/pgsql/bin/psql test

If its not installed on your server.

[haze]

Lol, I had the install fine, its just the customer ./configure.. forget it.. its installed now!

Anyways, everything is running fine now, thank for all the info!

[ozzi4648]

[quote:d47f846fdb][i:d47f846fdb]Originally posted by iminteractive[/i:d47f846fdb]

Lol, I had the install fine, its just the customer ./configure.. forget it.. its installed now!

Anyways, everything is running fine now, thank for all the info![/quote:d47f846fdb]

Great, so you can get into phppgadmin from all sites?

[dgbaker]

The installs seemed to have gone fine (Great instructions) although I'm getting the following in the browser

&You do not have postgresql support built into your PHP Web Server.
phpPgAdmin requires postgresql support to function properly!
Please check the PHP documentation for corrective action.&

I did follow the instructions to the letter (I thought) what am I missing?

[dgbaker]

Okay, I've got past that error and am now getting the following when trying to run psql at the command line

psql: FATAL 1: Missing or erroneous pg_hba.conf file, see postmaster log for details

But it does exist. /var/lib/pgsql/data/pg_hba.conf

It looks correct. In the browser phppgadmin does give the login screen but cannot login probably due to the fatal error with psql.

Any help is appreciated. Installs where mostly done through whm rpm installer except for phppgadmin.

[ozzi4648]

[quote:56975c3d06][i:56975c3d06]Originally posted by dgbaker[/i:56975c3d06]

The installs seemed to have gone fine (Great instructions) although I'm getting the following in the browser

&You do not have postgresql support built into your PHP Web Server.
phpPgAdmin requires postgresql support to function properly!
Please check the PHP documentation for corrective action.&

I did follow the instructions to the letter (I thought) what am I missing?[/quote:56975c3d06]

What your missing is this!

A working version of php, 4.x.x compiled '--with-pgsql=shared' or '--with-pgsql=/usr'

Your php is not compile using '--with-pgsql=/usr'. Go back to my site, at the top of the tutorial you will find information on how to compile php using the above options.

[ozzi4648]

[quote:c8d28d0daa][i:c8d28d0daa]Originally posted by dgbaker[/i:c8d28d0daa]

Okay, I've got past that error and am now getting the following when trying to run psql at the command line

psql: FATAL 1: Missing or erroneous pg_hba.conf file, see postmaster log for details

But it does exist. /var/lib/pgsql/data/pg_hba.conf

It looks correct. In the browser phppgadmin does give the login screen but cannot login probably due to the fatal error with psql.

Any help is appreciated. Installs where mostly done through whm rpm installer except for phppgadmin.

Thanks
David
Virtual-Hosting dot CA
http://www.virtual-hosting.ca
[/quote:c8d28d0daa]

I know what you did: Here look this is what i said:

Change the follow statement from:

local all trust
host all 127.0.0.1 255.255.255.255 trust

to

local all crypt
host all 127.0.0.1 255.255.255.255 crypt

BE CAREFUL WITH NEWLINES!!!! IF YOU ADD THEM YOU COULD RENDER THIS FILE IN-OPERABLE!

Reload the file using vi or pico and place your cursor to the end of the lines, crypt. Make sure that you dont have an extra space after the two crypt words above. You just added an extra space or something. Save the file and see if that works. See my warning above!

[dgbaker]

ozzi4648 - I did have it -

Build Date Oct 26 2002 13:16:30
Configure Command './configure' '--with-gettext' '--with-xml' '--enable-sockets' '--with-mysql' '--with-config-file-path=/usr/local/cpanel/3rdparty/etc' '--prefix=/usr/local/cpanel/3rdparty' '--with-pgsql=/usr/local/pgsql'

I got around that part but still have the &fatal error& - Missing or erroneous pg_hba.conf file, see postmaster log for details

I cannot though find a postmaster log file.

[dgbaker]

Okay I redid and rechecked the pg_hba.conf file, no extra spaces and it is word for word space by space as listed in your comments.

Still- no go same fatal error. It seems like psql does not know where the file is.
Mine is located in /var/lib/psql/data

[ozzi4648]

[quote:ae727c18a8][i:ae727c18a8]Originally posted by dgbaker[/i:ae727c18a8]

ozzi4648 - I did have it -

Build Date Oct 26 2002 13:16:30
Configure Command './configure' '--with-gettext' '--with-xml' '--enable-sockets' '--with-mysql' '--with-config-file-path=/usr/local/cpanel/3rdparty/etc' '--prefix=/usr/local/cpanel/3rdparty' '--with-pgsql=/usr/local/pgsql'

I got around that part but still have the &fatal error& - Missing or erroneous pg_hba.conf file, see postmaster log for details

I cannot though find a postmaster log file.
[/quote:ae727c18a8]

See these two statements that you changed

local all crypt
host all 127.0.0.1 255.255.255.255 crypt

Make sure there are no extra spaces after the words CRYPT

So your cursor should be here when saving that file

local all crypt|&--- HERE
host all 127.0.0.1 255.255.255.255 crypt|&----- HERE

Got it!