Community Forums
Connect with us on LinkedIn
Community Notice
+ Reply to Thread
Page 2 of 3 FirstFirst 1 2 3 LastLast
Results 16 to 30 of 43
  1. #16
    ozzi4648
    Guest

    Default

    [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!

  2. #17
    Member
    Join Date
    Dec 2001
    Posts
    1,558

    Default

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

  3. #18
    ozzi4648
    Guest

    Default

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

  4. #19
    ozzi4648
    Guest

    Default

    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!

  5. #20
    Member
    Join Date
    Dec 2001
    Posts
    1,558

    Default

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

  6. #21
    ozzi4648
    Guest

    Default

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

  7. #22
    Member
    Join Date
    Dec 2001
    Posts
    1,558

    Default

    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!
    Beau Henderson

  8. #23
    ozzi4648
    Guest

    Default

    [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?

  9. #24
    Moderator cPanel Partner NOC Badge dgbaker's Avatar
    Join Date
    Sep 2002
    Location
    Toronto, Ontario Canada
    Posts
    2,773

    Default

    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?
    Regards,
    David
    Forum Moderator

  10. #25
    Moderator cPanel Partner NOC Badge dgbaker's Avatar
    Join Date
    Sep 2002
    Location
    Toronto, Ontario Canada
    Posts
    2,773

    Default

    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.

    Last edited by dgbaker; 04-11-2003 at 02:21 PM.
    Regards,
    David
    Forum Moderator

  11. #26
    ozzi4648
    Guest

    Default

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

  12. #27
    ozzi4648
    Guest

    Default

    [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!

  13. #28
    Moderator cPanel Partner NOC Badge dgbaker's Avatar
    Join Date
    Sep 2002
    Location
    Toronto, Ontario Canada
    Posts
    2,773

    Default

    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.
    Regards,
    David
    Forum Moderator

  14. #29
    Moderator cPanel Partner NOC Badge dgbaker's Avatar
    Join Date
    Sep 2002
    Location
    Toronto, Ontario Canada
    Posts
    2,773

    Default

    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
    Regards,
    David
    Forum Moderator

  15. #30
    ozzi4648
    Guest

    Default

    [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!

Similar Threads & Tags
Similar threads

  1. PostgreSQL problem...where is phppgadmin?
    By Annibal in forum cPanel and WHM Discussions
    Replies: 4
    Last Post: 06-24-2009, 06:09 PM
  2. PostgreSQL/phpPgAdmin Permission Question
    By mixx941 in forum cPanel and WHM Discussions
    Replies: 2
    Last Post: 05-22-2007, 03:12 PM
  3. Can I create PostgreSQL DBs from phpPgAdmin?
    By calande2 in forum cPanel and WHM Discussions
    Replies: 0
    Last Post: 04-29-2007, 11:44 AM
  4. Replies: 1
    Last Post: 06-15-2005, 04:44 AM
Linkedin       Facebook       Twitter       RSS       Flickr       YouTube