Bug#595600: Cannot install sympa: No Database Driver installed

2010-09-07 Thread Jonas Smedegaard

On Tue, Sep 07, 2010 at 02:20:34PM +0200, Olivier Berger wrote:

Le mardi 07 septembre 2010 à 13:37 +0200, Jonas Smedegaard a écrit :

Pleas comment my proposal posted here earlier.

If your proposal is somehow different, please elaborate, so we can 
better compare them.




Oops, too bad I didn't read through the whole of previous mails. Sorry.

So, yes, fully agree with what you've proposed in 
http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=595600#10


Sorry about the noise.


No problem.  Great that we agree :-)

 - Jonas

--
 * Jonas Smedegaard - idealist & Internet-arkitekt
 * Tlf.: +45 40843136  Website: http://dr.jones.dk/

 [x] quote me freely  [ ] ask before reusing  [ ] keep private


signature.asc
Description: Digital signature


Bug#595600: Cannot install sympa: No Database Driver installed

2010-09-07 Thread Olivier Berger
Le mardi 07 septembre 2010 à 13:37 +0200, Jonas Smedegaard a écrit :
> Pleas comment my proposal posted here earlier.
> 
> If your proposal is somehow different, please elaborate, so we can 
> better compare them.
> 

Oops, too bad I didn't read through the whole of previous mails. Sorry.

So, yes, fully agree with what you've proposed in
http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=595600#10

Sorry about the noise.

Best regards,
-- 
Olivier BERGER 
http://www-public.it-sudparis.eu/~berger_o/ - OpenPGP-Id: 2048R/5819D7E8
Ingénieur Recherche - Dept INF
Institut TELECOM, SudParis (http://www.it-sudparis.eu/), Evry (France)




--
To UNSUBSCRIBE, email to debian-bugs-dist-requ...@lists.debian.org
with a subject of "unsubscribe". Trouble? Contact listmas...@lists.debian.org



Bug#595600: Cannot install sympa: No Database Driver installed

2010-09-07 Thread Jonas Smedegaard

On Tue, Sep 07, 2010 at 09:02:55AM +0200, Olivier Berger wrote:

Le lundi 06 septembre 2010 à 12:07 +0200, Stefan Hornburg (Racke) a
écrit :

>
> On the other hand, why cannot sympa depend on all the libdbd-*-perl 
> packages? If I select postgres I should have it installed, but not 
> necessarily the libdbd-*perl package. All of them should be at 
> least a suggestion if not a recommendation or dependency of sympa.

>

In general, package dependencies should be reduced to the minimum 
required. This saves diskspace, download time and makes your system 
more maintainable.


Why not provide some "sympa-mysql" or "sympa-postgresql" pseudo 
packages to implement such dependencies and necessary scripting in 
addition to sympa ?


Pleas comment my proposal posted here earlier.

If your proposal is somehow different, please elaborate, so we can 
better compare them.



Kind regards,

 - Jonas

--
 * Jonas Smedegaard - idealist & Internet-arkitekt
 * Tlf.: +45 40843136  Website: http://dr.jones.dk/

 [x] quote me freely  [ ] ask before reusing  [ ] keep private


signature.asc
Description: Digital signature


Bug#595600: Cannot install sympa: No Database Driver installed

2010-09-07 Thread Olivier Berger
Le lundi 06 septembre 2010 à 12:07 +0200, Stefan Hornburg (Racke) a
écrit :
> >
> > On the other hand, why cannot sympa depend on all the libdbd-*-perl
> > packages? If I select postgres I should have it installed, but not
> > necessarily the libdbd-*perl package. All of them should be at least a
> > suggestion if not a recommendation or dependency of sympa.
> >
> 
> In general, package dependencies should be reduced to the minimum required.
> This saves diskspace, download time and makes your system more maintainable.

Why not provide some "sympa-mysql" or "sympa-postgresql" pseudo packages
to implement such dependencies and necessary scripting in addition to
sympa ?

My 2 cents,
-- 
Olivier BERGER 
http://www-public.it-sudparis.eu/~berger_o/ - OpenPGP-Id: 2048R/5819D7E8
Ingénieur Recherche - Dept INF
Institut TELECOM, SudParis (http://www.it-sudparis.eu/), Evry (France)




--
To UNSUBSCRIBE, email to debian-bugs-dist-requ...@lists.debian.org
with a subject of "unsubscribe". Trouble? Contact listmas...@lists.debian.org



Bug#595600: Cannot install sympa: No Database Driver installed

2010-09-06 Thread Stefan Hornburg (Racke)

On 09/06/2010 11:58 AM, Felix Koop wrote:

Am Sonntag, den 05.09.2010, 13:51 +0200 schrieb Jonas Smedegaard:


Hi Felix,

You should install libdbd-pg-perl, which is the Debian package providing
DBD::Pg.

In principle sympa already provides this dependency, but only as a
fallback for libdbd-mysql-perl which is not ideal.

I suggest we keep this bugreport open (but maybe lower the severity)
until we offer a more reliable grouping of database-related
dependencies.

Concrete idea of approach:

* provide metapackages sympa-mysql, sympa-postgres etc. which each
  depend on the needed DBD::* package and recommends the
  possibly-remote database daemons.
* have sympa depend on either of those metapackages instead of
  directly on either of the libs + daemons

What do others feel about this?

Do you imagine that would have helped you at your level of expertise in
juggling with packages, Felix?


Regards,

   - Jonas




OK, I should have looked closer to the dependencies of sympa. Then I
would have seen this myself. I am ok with either closing or lowering the
severity of this bug.

On the other hand, why cannot sympa depend on all the libdbd-*-perl
packages? If I select postgres I should have it installed, but not
necessarily the libdbd-*perl package. All of them should be at least a
suggestion if not a recommendation or dependency of sympa.



In general, package dependencies should be reduced to the minimum required.
This saves diskspace, download time and makes your system more maintainable.

Regards
  Racke

--
LinuXia Systems => http://www.linuxia.de/
Expert Interchange Consulting and System Administration
ICDEVGROUP => http://www.icdevgroup.org/
Interchange Development Team




--
To UNSUBSCRIBE, email to debian-bugs-dist-requ...@lists.debian.org
with a subject of "unsubscribe". Trouble? Contact listmas...@lists.debian.org



Bug#595600: Cannot install sympa: No Database Driver installed

2010-09-06 Thread Felix Koop
Am Sonntag, den 05.09.2010, 13:51 +0200 schrieb Jonas Smedegaard: 

> Hi Felix,
> 
> You should install libdbd-pg-perl, which is the Debian package providing 
> DBD::Pg.
> 
> In principle sympa already provides this dependency, but only as a 
> fallback for libdbd-mysql-perl which is not ideal.
> 
> I suggest we keep this bugreport open (but maybe lower the severity) 
> until we offer a more reliable grouping of database-related 
> dependencies.
> 
> Concrete idea of approach:
> 
>* provide metapackages sympa-mysql, sympa-postgres etc. which each 
>  depend on the needed DBD::* package and recommends the 
>  possibly-remote database daemons.
>* have sympa depend on either of those metapackages instead of 
>  directly on either of the libs + daemons
> 
> What do others feel about this?
> 
> Do you imagine that would have helped you at your level of expertise in 
> juggling with packages, Felix?
> 
> 
> Regards,
> 
>   - Jonas
> 


OK, I should have looked closer to the dependencies of sympa. Then I
would have seen this myself. I am ok with either closing or lowering the
severity of this bug.

On the other hand, why cannot sympa depend on all the libdbd-*-perl
packages? If I select postgres I should have it installed, but not
necessarily the libdbd-*perl package. All of them should be at least a
suggestion if not a recommendation or dependency of sympa.

-- 
Mit freundlichen Grüßen

Felix Koop


Bug#595600: Cannot install sympa: No Database Driver installed

2010-09-05 Thread Jonas Smedegaard

Hi Felix,

On Sun, Sep 05, 2010 at 12:59:26PM +0200, Felix Koop wrote:
When installing sympa with a postgresql database and using 
dbconfig-common to configure the database, I get the following error:



apache2: installation seems OK ...
Reloading web server config: apache2err SQLSource::connect() No Database Driver 
installed for Pg ; you should download and install DBD::Pg from CPAN
err List::check_db_connect() Failed to connect to database
err SQLSource::create_db() Cannot create Pg DB



Which package(s) do I need to add manually to be able to install sympa?


You should install libdbd-pg-perl, which is the Debian package providing 
DBD::Pg.


In principle sympa already provides this dependency, but only as a 
fallback for libdbd-mysql-perl which is not ideal.


I suggest we keep this bugreport open (but maybe lower the severity) 
until we offer a more reliable grouping of database-related 
dependencies.


Concrete idea of approach:

  * provide metapackages sympa-mysql, sympa-postgres etc. which each 
depend on the needed DBD::* package and recommends the 
possibly-remote database daemons.
  * have sympa depend on either of those metapackages instead of 
directly on either of the libs + daemons


What do others feel about this?

Do you imagine that would have helped you at your level of expertise in 
juggling with packages, Felix?



Regards,

 - Jonas

--
 * Jonas Smedegaard - idealist & Internet-arkitekt
 * Tlf.: +45 40843136  Website: http://dr.jones.dk/

 [x] quote me freely  [ ] ask before reusing  [ ] keep private


signature.asc
Description: Digital signature


Bug#595600: Cannot install sympa: No Database Driver installed

2010-09-05 Thread Felix Koop
Package: sympa
Version: 6.1~beta4~dfsg-1
Severity: important


When installing sympa with a postgresql database and using dbconfig-common to 
configure the database,
I get the following error:

Reading package lists...
Building dependency tree...
Reading state information...
Suggested packages:
  libauthcas-perl libdbd-oracle-perl libtext-linefold-perl libtext-wrap-perl
The following NEW packages will be installed:
  sympa
Preconfiguring packages ...
Configuring sympa
-

The sympa package must have a database installed and configured before it can 
be used.  This can be optionally handled with dbconfig-common.

If you are an advanced database administrator and know that you want to perform 
this configuration manually, or if your database has already been installed 
and configured, you should refuse this option.  Details on what needs to be 
done should most likely be provided in /usr/share/doc/sympa.

Otherwise, you should probably choose this option.



The sympa package can be configured to use one of several database types. 
Below, you will be presented with the available choices.

  1. mysql  2. pgsql  3. sqlite3  4. sqlite



Please provide a password for sympa to register with the database server.  If 
left blank, a random password will be generated. . If you are using "ident" 
based authentication, the supplied password will not be used and can be left 
blank.  Otherwise, PostgreSQL access may need to be reconfigured to allow 
password-authenticated access.









  1. Apache 2  2. Other



If you don't want the webserver to be restarted, please make sure that wwsympa 
and the Sympa SOAP server are not running or the database may contain 
duplicates.



0 upgraded, 1 newly installed, 0 to remove and 0 not upgraded.
Need to get 0B/2641kB of archives.
After this operation, 9454kB of additional disk space will be used.
Selecting previously deselected package sympa.
(Reading database ... 
(Reading database ... 5%
(Reading database ... 10%
(Reading database ... 15%
(Reading database ... 20%
(Reading database ... 25%
(Reading database ... 30%
(Reading database ... 35%
(Reading database ... 40%
(Reading database ... 45%
(Reading database ... 50%
(Reading database ... 55%
(Reading database ... 60%
(Reading database ... 65%
(Reading database ... 70%
(Reading database ... 75%
(Reading database ... 80%
(Reading database ... 85%
(Reading database ... 90%
(Reading database ... 95%
(Reading database ... 100%
(Reading database ... 458990 files and directories currently installed.)
Unpacking sympa (from .../sympa_6.1~beta4~dfsg-1_amd64.deb) ...
Processing triggers for man-db ...
Setting up sympa (6.1~beta4~dfsg-1) ...
/etc/sympa/sympa.conf file has been created
/etc/sympa/wwsympa.conf file has been created
dbconfig-common: writing config to /etc/dbconfig-common/sympa.conf

Creating config file /etc/dbconfig-common/sympa.conf with new version
creating postgres user sympa:  already exists.
resetting password:  success.
creating database sympa: already exists.
dbconfig-common: flushing administrative password
apache2: installation seems OK ...
apache2: installation seems OK ...
Reloading web server config: apache2err SQLSource::connect() No Database Driver 
installed for Pg ; you should download and install DBD::Pg from CPAN
err List::check_db_connect() Failed to connect to database
err SQLSource::create_db() Cannot create Pg DB
Database sympa defined in sympa.conf has not the right structure or is 
unreachable. verify db_xxx parameters in sympa.conf
dpkg: error processing sympa (--configure):
 subprocess installed post-installation script returned error exit status 1
configured to not write apport reports
Errors were encountered while processing:
 sympa
E: Sub-process /usr/bin/dpkg returned an error code (1)

Which package(s) do I need to add manually to be able to install sympa?


-- System Information:
Debian Release: squeeze/sid
  APT prefers unstable
  APT policy: (500, 'unstable')
Architecture: amd64 (x86_64)

Kernel: Linux 2.6.32-5-amd64 (SMP w/8 CPU cores)
Locale: LANG=de_DE.UTF-8, LC_CTYPE=de_DE.UTF-8 (charmap=UTF-8)
Shell: /bin/sh linked to /bin/dash

Versions of packages sympa depends on:
ii  adduser 3.112add and remove users and groups
ii  cdebconf [debconf-2.0]  0.150Debian Configuration Management Sy
ii  dbconfig-common 1.8.46   common framework for packaging dat
ii  debconf [debconf-2.0]   1.5.35   Debian configuration management sy
ii  exim4-daemon-light [mail-tr 4.72-1   lightweight Exim MTA (v4) daemon
ii  libarchive-zip-perl 1.30-3   Perl module for manipulation of ZI
ii  libc6   2.11.2-5 Embedded GNU C Library: Shared lib
ii  libcgi-fast-perl5.10.1-14CGI::Fast Perl module
ii  libdbd-mysql-perl   4.016-1  Perl5 database interface to the My
ii  libdbi-perl 1.612-1  Perl Database Interface (DBI)
ii  libfcgi-perl0.71-1