Page 1 of 2 12 LastLast
Results 1 to 10 of 16

Thread: Error with Postgresql after recent dist-upgrade

  1. #1
    Just burned his ISO
    Join Date
    Dec 2006
    Posts
    8

    Default

    I just applied the latest batch of updates, as the twitter post announced.

    Everything went well apart from the Postgresql upgrade, the following error was given.

    Setting up postgresql-8.3 (8.3.8-0ubuntu8.10) ...
    Starting PostgreSQL 8.3 database server: main* The PostgreSQL server failed to start. Please check the log output:
    2009-09-29 12:21:43 BST FATAL: could not load server certificate file "server.crt": No such file or directory
    failed!
    invoke-rc.d: initscript postgresql-8.3, action "start" failed.
    dpkg: error processing postgresql-8.3 (--configure):
    subprocess post-installation script returned error exit status 1
    dpkg: dependency problems prevent configuration of postgresql:
    postgresql depends on postgresql-8.3; however:
    Package postgresql-8.3 is not configured yet.
    dpkg: error processing postgresql (--configure):
    dependency problems - leaving unconfigured
    No apport report written because the error message indicates its a followup error from a previous failure.
    Errors were encountered while processing:
    postgresql-8.3
    postgresql
    E: Sub-process /usr/bin/dpkg returned an error code (1)

    I'm not conversant with Postgresql and after a bit of google'ing around I cant find a fix.

    Anyone else got this problem or does anyone have any pointers or a fix??

    Regards
    Dave

    Done some more Google'ing and found a fix, maybe.

    Do we need ssl?, if not just turn off ssl in /etc/postgresql/8.3/main/postgresql.conf

    And then /etc/init.d/postrgresql start and it runs

    If we need ssl then we need a new certificate, the certs are linked to a snake-oil cert

    lrwxrwxrwx 1 root root 36 Jun 22 17:19 server.crt -> /etc/ssl/certs/ssl-cert-snakeoil.pem
    lrwxrwxrwx 1 root root 38 Jun 22 17:19 server.key -> /etc/ssl/private/ssl-cert-snakeoil.key

    which is not present in the /etc/ssl/certs.

    The new certificates can be created by :-

    cd /etc/ssl/certs
    make-ssl-cert generate-default-snakeoil --force-overwrite

    Now retstart postgresql

    /etc/init.d/postgresql restart

    This should be everything back to life.

  2. #2
    Just burned his ISO
    Join Date
    Jul 2006
    Posts
    6

    Default

    When you try to start postgres with ssl set to true it fails because Postgres can't find a server certificate file named server.cert. Should we just create with openssl? Just did it it works. Thanks for your posting!!!

    Mcugk

  3. #3

    Default

    Fixed my issue also. Thanks!
    "You can get more with a kind word and a gun than you can with a kind word alone."
    - Al Capone

  4. #4
    Just burned his ISO
    Join Date
    Jan 2010
    Posts
    13

    Default

    I got the same problem, after a dist-upgrade,
    and the trick done it well
    thank's davehardy20

  5. #5
    Just burned his ISO
    Join Date
    Feb 2010
    Posts
    4

    Default

    Same here. Searching for a fix last 2 days :-)
    thanks for fix.

  6. #6
    Just burned his ISO
    Join Date
    Sep 2009
    Posts
    7

    Default

    hello, I can not English so well, I have the same problem, I have made so

    backtrack new install

    now
    console

    cd /etc/ssl/certs

    ls -ld /etc/ssl/private
    sudo ls -l /etc/ssl/private/

    make-ssl-cert generate-default-snakeoil --force-overwrite

    BackTrack 4 Pre Final Kernel Update

    apt-get update
    apt-get install -d linux-image
    cd /var/cache/apt/archives/
    dpkg -i –force all linux-image-2.6.30.5_2.6.30.5-10.00.Custom_i386.deb
    apt-get dist-upgrade
    apt-get install madwifi-drivers
    apt-get install r8187-drivers

    After a reboot, you might want to run:

    fix-splash

    no error with Postgresql

  7. #7
    Just burned his ISO
    Join Date
    Oct 2009
    Posts
    3

    Default

    THX a lot DAVE..

  8. #8
    Just burned his ISO
    Join Date
    Oct 2009
    Posts
    4

    Default

    I had this problem too but this fixed me right up.


    Thank you!

  9. #9
    Junior Member Nirvana1289's Avatar
    Join Date
    Oct 2009
    Posts
    57

    Default

    dpkg -i –force all linux-image-2.6.30.5_2.6.30.5-10.00.Custom_i386.deb
    WARNING: this command cannot work, because it's wrong. For make it work you must enter:

    Code:
    dpkg -i --force-all linux-image-2.6.30.5_2.6.30.5-10.00.Custom_i386.deb
    bye!
    Ora che ho perso la vista, ci vedo di più.

  10. #10
    Just burned his ISO
    Join Date
    Aug 2009
    Posts
    15

    Default

    Same problem. Fix worked. I had spent a while learning how to make cert files, which was some righteous learning, but I couldn't figure out which directory they went in. Google searches all yielded advice that did not apply to BT4.

Page 1 of 2 12 LastLast

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •