apt-get install postgresql fails

Bug #324302 reported by Marius Gedminas
4
Affects Status Importance Assigned to Milestone
postgresql-common (Ubuntu)
Incomplete
Undecided
Unassigned

Bug Description

Binary package hint: postgresql-common

sudo apt-get install postgresql fails in Intrepid, but completes successfully when you run dpkg --configure -a.

Here's a full command log (I apologize for the Lituahnian texts, but I didn't know in advance that it would fail and don't have the time right at this moment to uninstall and try reinstalling).

$ sudo apt-get install postgresql
Skaitomi paketų sąrašai... Baigta
Konstruojamas priklausomybių medis
Skaitoma būsenos informacija... Baigta
Bus įdiegti šie papildomi paketai:
  postgresql-8.3 postgresql-client-8.3 postgresql-client-common postgresql-common
Siūlomi paketai:
  oidentd ident-server postgresql-doc-8.3
Bus įdiegti šie NAUJI paketai:
  postgresql postgresql-8.3 postgresql-client-8.3 postgresql-client-common postgresql-common
0 atnaujinti, 5 naujai įdiegti, 0 bus pašalinta ir 0 neatnaujinta.
Reikia parsiųsti 4694kB/4740kB archyvų.
Po šios operacijos bus naudojama 19,8MB papildomos disko vietos.
Gauti:1 http://archive.ubuntu.com intrepid-updates/main postgresql-client-8.3 8.3.5-0ubuntu8.10 [726kB]
Gauti:2 http://archive.ubuntu.com intrepid/main postgresql-common 90 [86,1kB]
Gauti:3 http://archive.ubuntu.com intrepid-updates/main postgresql-8.3 8.3.5-0ubuntu8.10 [3658kB]
Gauti:4 http://archive.ubuntu.com intrepid-updates/main postgresql 8.3.5-0ubuntu8.10 [224kB]
Parsiųsta 4546kB iš 30s (151kB/s)
Prekonfigūruojami paketai ...
Pažymime anksčiau nepažymėtą paketą postgresql-client-common.
(Skaitoma duomenų bazė ... šiuo metu įdiegta 342438 failų ir aplankų.)
Išpakuojamas archyvas postgresql-client-common (iš .../postgresql-client-common_90_all.deb) ...
Pažymime anksčiau nepažymėtą paketą postgresql-client-8.3.
Išpakuojamas archyvas postgresql-client-8.3 (iš .../postgresql-client-8.3_8.3.5-0ubuntu8.10_i386.deb) ...
Pažymime anksčiau nepažymėtą paketą postgresql-common.
Išpakuojamas archyvas postgresql-common (iš .../postgresql-common_90_all.deb) ...
Pažymime anksčiau nepažymėtą paketą postgresql-8.3.
Išpakuojamas archyvas postgresql-8.3 (iš .../postgresql-8.3_8.3.5-0ubuntu8.10_i386.deb) ...
Pažymime anksčiau nepažymėtą paketą postgresql.
Išpakuojamas archyvas postgresql (iš .../postgresql_8.3.5-0ubuntu8.10_all.deb) ...
Processing triggers for man-db ...
Tvarkomas paketas postgresql-client-common (90) ...
Tvarkomas paketas postgresql-client-8.3 (8.3.5-0ubuntu8.10) ...

Tvarkomas paketas postgresql-common (90) ...
supported_versions: WARNING: Unknown Ubuntu release: 8.10
Your account has expired; please contact your system administrator
chfn: PAM authentication failed
adduser: `/usr/bin/chfn -f PostgreSQL administrator postgres' returned error code 1. Exiting.
dpkg: klaida apdorojant postgresql-common (--configure):
 vidinis procesas post-installation script nutrūko gražindamas reikšmę 1
dpkg: priklausomybių problemos neleidžia konfigūruoti postgresql-8.3:
 postgresql-8.3 priklauso nuo postgresql-common (>= 79); tačiau:
  Paketas postgresql-common dar nekonfigūruotas.
dpkg: klaida apdorojant postgresql-8.3 (--configure):
 priklausomybių problemos - paliekamas nekonfigūruotas
dpkg: priklausomybių problemos neleidžia konfigūruoti postgresql:
 postgresql priklauso nuo postgresql-8.3; tačiau:
  Paketas postgresql-8.3 dar nekonfigūruotas.
dpkg: klaida apdorojant postgresql (--configure):
 priklausomybių problemos - paliekamas nekonfigūruotas
No apport report written because the error message indicates its a followup error from a previous failure.
                                                                                                          No apport report written because the error message indicates its a followup error from a previous failure.
                                                       Apdorojant įvyko klaidų:
 postgresql-common
 postgresql-8.3
 postgresql
E: Sub-process /usr/bin/dpkg returned an error code (1)

$ LC_ALL=C sudo dpkg --configure -a
Setting up postgresql-common (90) ...
supported_versions: WARNING: Unknown Ubuntu release: 8.10
Adding user postgres to group ssl-cert

Setting up postgresql-8.3 (8.3.5-0ubuntu8.10) ...
Creating new cluster (configuration: /etc/postgresql/8.3/main, data: /var/lib/postgresql/8.3/main)...
Moving configuration file /var/lib/postgresql/8.3/main/postgresql.conf to /etc/postgresql/8.3/main...
Moving configuration file /var/lib/postgresql/8.3/main/pg_hba.conf to /etc/postgresql/8.3/main...
Moving configuration file /var/lib/postgresql/8.3/main/pg_ident.conf to /etc/postgresql/8.3/main...
Configuring postgresql.conf to use port 5432...
 * Starting PostgreSQL 8.3 database server [ OK ]

Setting up postgresql (8.3.5-0ubuntu8.10) ...

Revision history for this message
Andreas Olsson (andol) wrote :

I just installed postgresql on a very clean Intrepid system, without any problem.

When you got your "Your account has expired; please contact your system administrator", I got the "Adding user postgres to group ssl-cert" you got during "dpkg --configure -a".

Have you had postgresql installed earlier on that system? Do you keep a local userdatabase or do you use something like ldap alt. nis? Any special pam settings?

Changed in postgresql-common:
status: New → Incomplete
Revision history for this message
Andreas Olsson (andol) wrote :

This does kind of looks like the effects of Bug #238755. At least had it not been fixed already in Intrepid. I assume your system is fully upgraded?

Anyhow, dealing in that general direction; have you been doing anything creative with the status of your root account?

Revision history for this message
Marius Gedminas (mgedmin) wrote : Re: [Bug 324302] Re: apt-get install postgresql fails

> Have you had postgresql installed earlier on that system?

No.

> Do you keep a local userdatabase or do you use something like ldap
> alt. nis?

Nothing special.

> Any special pam settings?

Actually, yes. I use libpam-thinkfinger as well as ecryptfs-utils.
Both modify PAM settings (encryptfs-utils automatically via pam hooks,
libpam-thinkfinger has a shell script in /usr/lib/pam-thinkfinger that I
ran).

> This does kind of looks like the effects of Bug #238755. At least had it
> not been fixed already in Intrepid. I assume your system is fully
> upgraded?

Yes, including intrepid-updates and -backports.

> Anyhow, dealing in that general direction; have you been doing anything
> creative with the status of your root account?

No. I've never set a root password, and (as far as I can remember) I've
never used passwd -l root on this machine.

I can confirm that

  sudo chfn mg

gives me

  Your account has expired; please contact your system administrator
  chfn: PAM authentication failed

The /etc/shadow line for root is

  root:!:14111:0:99999:7::1:

so this is a duplicate of #238755.

Marius Gedminas
--
This host is a black hole at HTTP wavelengths. GETs go in, and nothing
comes out, not even Hawking radiation.
                -- Graaagh the Mighty on rec.games.roguelike.angband

To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.