Bug#340459: postgresql-7.4: unable to install

2005-12-06 Thread Jonathan Ballet
Hi Martin,

So I have deleted the postgres user : (sorry, french output ;) )

jon-debian:/# deluser postgres
Suppression de l'utilisateur « postgres »...
userdel : erreur lors de la suppression de l'entrée dans /etc/shadow
Fait.
jon-debian:/#

It says that there is an error while deleting the user entry from /etc/shadow 
...
I don't know where this user came from, but it seems there's something special 
about it ...

Now :
jon-debian:/# id postgres
uid=116(postgres) gid=116(postgres) groupes=116(postgres)
jon-debian:/#

So everythings looks Ok. I try to purge postgresql-7.4 packages and reinstall 
them, and it seems OK.
Anyway, I think you can close this bug report now, since it was a problem on my 
side ...


Thanks a lot,
Jonathan


Martin Pitt a écrit :
 Hi Jonathan!
 
 Jonathan Ballet [2005-12-05  9:46 +0100]:
 
Sorry for late reply. Here is the output of 'id postgresql' :

[EMAIL PROTECTED]:~$ id postgres
uid=12966(postgres) gid=0(root) groupes=0(root)
[EMAIL PROTECTED]:~$

I hope it can help ...
 
 
 It indeed does. It should actually look like
 
   uid=116(postgres) gid=116(postgres) Gruppen=116(postgres)
 
 i. e. there are several things wrong about your user:
 
   * The user ID should be smaller than 1000 to make postgres a system
 user.
   * postgres should have its own system group instead of being in
 group 'root'. This is the cause for your failure.
 
 Since I do not believe that adduser --system created this user, I
 strongly suspect that it existed before installing postgresql-common
 already. It does not look like a regular user either, though - they
 must not be in group 'root'. 
 
 Thus, a quickfix for you would be to do
 
   deluser postgres
 
 and reinstall postgresql-common and postgresql-7.4. However, please
 make double sure that you don't need that user for anything else.
 
 I can add a check to the postgresql-common package that will make the
 installation fail with a meaningful message if an invalid postgres
 user already exists. However, there is not much more I could do about
 that.
 
 Thanks,
 
 Martin
 




Bug#340459: postgresql-7.4: unable to install

2005-12-05 Thread Jonathan Ballet
Martin Pitt a écrit :
 severity 340459 normal
 retitle 340459 postgresql-common: unspecified problem with postgres user
 thanks
 
 Hi Jonathan!
 
 Jonathan Ballet [2005-11-23 16:32 +0100]:
 
Error: clusters must not be owned by root
dpkg: error processing postgresql-7.4 (--configure):
 subprocess post-installation script returned error exit status 1
 
 
 I still need the output of 'id postgresql', as I asked in my previous
 reply.
 
 Thanks,
 
 Martin

Hi Martin,
Sorry for late reply. Here is the output of 'id postgresql' :

[EMAIL PROTECTED]:~$ id postgres
uid=12966(postgres) gid=0(root) groupes=0(root)
[EMAIL PROTECTED]:~$


I hope it can help ...

Thanks,
Jonathan



Bug#340459: postgresql-7.4: unable to install

2005-12-05 Thread Martin Pitt
Hi Jonathan!

Jonathan Ballet [2005-12-05  9:46 +0100]:
 Sorry for late reply. Here is the output of 'id postgresql' :
 
 [EMAIL PROTECTED]:~$ id postgres
 uid=12966(postgres) gid=0(root) groupes=0(root)
 [EMAIL PROTECTED]:~$
 
 I hope it can help ...

It indeed does. It should actually look like

  uid=116(postgres) gid=116(postgres) Gruppen=116(postgres)

i. e. there are several things wrong about your user:

  * The user ID should be smaller than 1000 to make postgres a system
user.
  * postgres should have its own system group instead of being in
group 'root'. This is the cause for your failure.

Since I do not believe that adduser --system created this user, I
strongly suspect that it existed before installing postgresql-common
already. It does not look like a regular user either, though - they
must not be in group 'root'. 

Thus, a quickfix for you would be to do

  deluser postgres

and reinstall postgresql-common and postgresql-7.4. However, please
make double sure that you don't need that user for anything else.

I can add a check to the postgresql-common package that will make the
installation fail with a meaningful message if an invalid postgres
user already exists. However, there is not much more I could do about
that.

Thanks,

Martin

-- 
Martin Pitthttp://www.piware.de
Ubuntu Developer   http://www.ubuntu.com
Debian Developer   http://www.debian.org

In a world without walls and fences, who needs Windows and Gates?


signature.asc
Description: Digital signature


Bug#340459: postgresql-7.4: unable to install

2005-12-04 Thread Martin Pitt
severity 340459 normal
retitle 340459 postgresql-common: unspecified problem with postgres user
thanks

Hi Jonathan!

Jonathan Ballet [2005-11-23 16:32 +0100]:
 Error: clusters must not be owned by root
 dpkg: error processing postgresql-7.4 (--configure):
  subprocess post-installation script returned error exit status 1

I still need the output of 'id postgresql', as I asked in my previous
reply.

Thanks,

Martin
-- 
Martin Pitthttp://www.piware.de
Ubuntu Developer   http://www.ubuntu.com
Debian Developer   http://www.debian.org

In a world without walls and fences, who needs Windows and Gates?


signature.asc
Description: Digital signature


Bug#340459: postgresql-7.4: unable to install

2005-11-24 Thread Martin Pitt
Hi Jonathan!

Jonathan Ballet [2005-11-23 17:00 +0100]:
 Error: clusters must not be owned by root
  
^
  
  Could you explain how that happened? 
  
  Thanks,
  Anand
  
 
 Unfortunely, I don't know ...
 What are these clusters is it talking about ?

A cluster is a set of databases that are managed by one server
(postmater). You can have several of them installed.


-- 
Martin Pitthttp://www.piware.de
Ubuntu Developer   http://www.ubuntu.com
Debian Developer   http://www.debian.org

In a world without walls and fences, who needs Windows and Gates?


-- 
To UNSUBSCRIBE, email to [EMAIL PROTECTED]
with a subject of unsubscribe. Trouble? Contact [EMAIL PROTECTED]



Bug#340459: postgresql-7.4: unable to install

2005-11-24 Thread Martin Pitt
Hi Jonathan!

Jonathan Ballet [2005-11-23 16:32 +0100]:
 Error: clusters must not be owned by root
 dpkg: error processing postgresql-7.4 (--configure):
  subprocess post-installation script returned error exit status 1
 Errors were encountered while processing:
  postgresql-7.4

There seems to be something wrong with your 'postgres' user. What is
the output of

  id postgres
  
?

Martin
-- 
Martin Pitthttp://www.piware.de
Ubuntu Developer   http://www.ubuntu.com
Debian Developer   http://www.debian.org

In a world without walls and fences, who needs Windows and Gates?


signature.asc
Description: Digital signature


Bug#340459: postgresql-7.4: unable to install

2005-11-23 Thread Jonathan Ballet
Package: postgresql-7.4
Version: 1:7.4.9-2
Severity: grave
Justification: renders package unusable

I could not install postgresql-7.4 :

===
jon-debian:/home/jon# LANGUAGE=en aptitude install postgresql-7.4
Reading package lists... Done
Building dependency tree... Done
Reading extended state information
Initializing package states... Done
Building tag database... Done
The following NEW packages will be installed:
  postgresql-7.4
0 packages upgraded, 1 newly installed, 0 to remove and 1 not upgraded.
Need to get 3193kB of archives. After unpacking 8049kB will be used.
Writing extended state information... Done
Get:1 http://ftp.fr.debian.org unstable/main postgresql-7.4 1:7.4.9-2
[3193kB]
Fetched 3193kB in 4s (699kB/s)
Reading package fields... Done
Reading package status... Done
Retrieving bug reports... Done
Selecting previously deselected package postgresql-7.4.
(Reading database ... 189203 files and directories currently installed.)
Unpacking postgresql-7.4 (from .../postgresql-7.4_1%3a7.4.9-2_i386.deb)
...
Setting up postgresql-7.4 (7.4.9-2) ...
Error: clusters must not be owned by root
dpkg: error processing postgresql-7.4 (--configure):
 subprocess post-installation script returned error exit status 1
Errors were encountered while processing:
 postgresql-7.4
E: Sub-process /usr/bin/dpkg returned an error code (1)
A package failed to install.  Trying to recover:
Setting up postgresql-7.4 (7.4.9-2) ...
Error: clusters must not be owned by root
dpkg: error processing postgresql-7.4 (--configure):
 subprocess post-installation script returned error exit status 1
Errors were encountered while processing:
 postgresql-7.4
jon-debian:/home/jon#
===

Others postgresql packages are ok to install (-common and -client-7.4)


-- System Information:
Debian Release: testing/unstable
  APT prefers unstable
  APT policy: (500, 'unstable'), (500, 'testing')
Architecture: i386 (i686)
Shell:  /bin/sh linked to /bin/bash
Kernel: Linux 2.6.14-2-k7
Locale: [EMAIL PROTECTED], [EMAIL PROTECTED] (charmap=ISO-8859-15)

Versions of packages postgresql-7.4 depends on:
ii  libc6 2.3.5-8GNU C Library: Shared libraries an
ii  libcomerr21.38-2 common error description library
ii  libkrb53  1.3.6-5MIT Kerberos runtime libraries
ii  libpam0g  0.79-3 Pluggable Authentication Modules l
ii  libpq31:7.4.9-2  PostgreSQL C client library
ii  libreadline5  5.0-11 GNU readline and history libraries
ii  libssl0.9.8   0.9.8a-4   SSL shared libraries
ii  postgresql-client-7.4 1:7.4.9-2  front-end programs for PostgreSQL
ii  postgresql-common 34 manager for PostgreSQL database cl
ii  zlib1g1:1.2.3-8  compression library - runtime

postgresql-7.4 recommends no packages.

-- no debconf information


-- 
To UNSUBSCRIBE, email to [EMAIL PROTECTED]
with a subject of unsubscribe. Trouble? Contact [EMAIL PROTECTED]



Bug#340459: postgresql-7.4: unable to install

2005-11-23 Thread Jonathan Ballet
Anand Kumria a écrit :
 On Wed, Nov 23, 2005 at 04:32:26PM +0100, Jonathan Ballet wrote:
 
Package: postgresql-7.4
Version: 1:7.4.9-2
Severity: grave
Justification: renders package unusable

I could not install postgresql-7.4 :

===
jon-debian:/home/jon# LANGUAGE=en aptitude install postgresql-7.4
Setting up postgresql-7.4 (7.4.9-2) ...
Error: clusters must not be owned by root
 
   ^
 
 Could you explain how that happened? 
 
 Thanks,
 Anand
 

Unfortunely, I don't know ...
What are these clusters is it talking about ?

Jonathan



Bug#340459: postgresql-7.4: unable to install

2005-11-23 Thread Anand Kumria
On Wed, Nov 23, 2005 at 04:32:26PM +0100, Jonathan Ballet wrote:
 Package: postgresql-7.4
 Version: 1:7.4.9-2
 Severity: grave
 Justification: renders package unusable
 
 I could not install postgresql-7.4 :
 
 ===
 jon-debian:/home/jon# LANGUAGE=en aptitude install postgresql-7.4
 Setting up postgresql-7.4 (7.4.9-2) ...
 Error: clusters must not be owned by root
  ^

Could you explain how that happened? 

Thanks,
Anand

-- 
 `When any government, or any church for that matter, undertakes to say to
  its subjects, This you may not read, this you must not see, this you are
  forbidden to know, the end result is tyranny and oppression no matter how
  holy the motives' -- Robert A Heinlein, If this goes on --


signature.asc
Description: Digital signature