[Pkg-roundcube-maintainers] Bug#476803: Debconf use is utterly broken

[Michael Tautschnig]

Hi Vincent,

Thanks for your really quick reply.

> 
> Thanks  for your report.  I have  used a  clean sid  chroot to  do those
> tests. Here is my preseed file:
> 
[...]

I'm missing one important answer in this preseeding: 

# Configure database for roundcube with dbconfig-common?
roundcube-core roundcube/dbconfig-install boolean

The answer must obviously be yes, because otherwise it doesn't put any useful
information into debian-db.php at all (only dbuser and dbname will be set).
Actually I would have guessed that I don't want to use dbconfig because I'd
prefer to set up the database myself, but anyway:

=================================================================
corn:/# debconf-get-selections | grep roundcube
corn:/# cat bla
roundcube-core  roundcube/mysql/method  select  tcp/ip
roundcube-core  roundcube/dbconfig-reinstall    boolean false
roundcube-core  roundcube/purge boolean false
roundcube-core  roundcube/language      select  de_DE
roundcube-core  roundcube/db/dbname     string  roundcube
roundcube-core  roundcube/remote/newhost        string  127.0.0.2
roundcube-core  roundcube/remote/port   string  3319
roundcube-core  roundcube/restart-webserver     boolean false
roundcube-core  roundcube/install-error select  ignore
roundcube-core  roundcube/mysql/admin-user      string  root
roundcube-core  roundcube/hosts string  ssl://dummy.test:993
roundcube-core  roundcube/database-type select  mysql
roundcube-core  roundcube/remote/host   select  127.0.0.2
roundcube-core  roundcube/db/app-user   string  roundcube

corn:/# debconf-set-selections < bla
corn:/# apt-get -y -q install roundcube-mysql roundcube-core roundcube
Reading package lists...
Building dependency tree...
Reading state information...
The following packages were automatically installed and are no longer required:
  libneon26 libace5.4.7ldbl python2.4-minimal libcwidget1 python2.4
Use 'apt-get autoremove' to remove them.
Suggested packages:
  mysql-server
The following NEW packages will be installed:
  roundcube roundcube-core roundcube-mysql
0 upgraded, 3 newly installed, 0 to remove and 0 not upgraded.
Need to get 0B/601kB of archives.
After this operation, 3449kB of additional disk space will be used.
Preconfiguring packages ...
Can not write log, openpty() failed (/dev/pts not mounted?)
Selecting previously deselected package roundcube-mysql.
(Reading database ... 69249 files and directories currently installed.)
Unpacking roundcube-mysql (from .../roundcube-mysql_0.1.1-1_all.deb) ...
Selecting previously deselected package roundcube-core.
Unpacking roundcube-core (from .../roundcube-core_0.1.1-1_all.deb) ...
Selecting previously deselected package roundcube.
Unpacking roundcube (from .../roundcube_0.1.1-1_all.deb) ...
Can not write log, openpty() failed (/dev/pts not mounted?)
Setting up roundcube-mysql (0.1.1-1) ...
Setting up roundcube-core (0.1.1-1) ...
dbconfig-common: writing config to /etc/dbconfig-common/roundcube.conf

Creating config file /etc/dbconfig-common/roundcube.conf with new version

Creating config file /etc/roundcube/debian-db.php with new version
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2).
unable to connect to mysql server.
error encountered creating user:
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
dbconfig-common: roundcube configure: ignoring errors from here forwards
populating database via sql...  done.
dbconfig-common: flushing administrative password

Creating config file /etc/roundcube/main.inc.php with new version
Lighttpd not installed, skipping
Setting up roundcube (0.1.1-1) ...
corn:/# cat /etc/roundcube/debian-db.php 
<?php
##
## database access settings in php format
## automatically generated from /etc/dbconfig-common/roundcube.conf
## by /usr/sbin/dbconfig-generate-include
## Sun, 20 Apr 2008 09:25:10 +0000
##
## by default this file is managed via ucf, so you shouldn't have to
## worry about manual changes being silently discarded.  *however*,
## you'll probably also want to edit the configuration file mentioned
## above too.
##
$dbuser='roundcube';
$dbpass='Wwb66E5nDGNx';
$basepath='';
$dbname='roundcube';
$dbserver='';
$dbport='';
$dbtype='mysql';
corn:/# 
=================================================================

> 
> This seems to work fine for me. What is your preseed file?
> 
So, even using your preseeding on an up-to-date sid system, it doesn't really
work. Of course I don't actually have a server named dummy.test and the like,
but dbconfig is not really making use of this, but rather attempts to connect to
the local socket, which doesn't exist (because I don't have a local mysqld
here).

> Because of  some black magic in config,  roundcube/language gets ignored
> when preseeded. I will try to fix this one.

So, well, let me try to refine my report:
- Preseeding does work, apart from the language, which you have fixed in SVN
  already.
- The configuration of a remote mysql server, however, seems not to work.

Then, this is not actually the work of roundcube, but rather dbconfig-common,
which is doing this work. I will thus clone and reassign this bug, leaving the
original bug for the locale-reconfiguration problem.

Thanks again for your quick response,
Michael

-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 194 bytes
Desc: not available
Url : http://lists.alioth.debian.org/pipermail/pkg-roundcube-maintainers/attachments/20080420/515adc25/attachment.pgp