package moodle 1.8.2-1.2ubuntu2 failed to install/upgrade: CREATE ROLE fails with hyphen

[miquel]

Binary package hint: moodle

E: moodle: el subproceso post-installation script devolvió el código de salida de error 1
E: moodle-book: problemas de dependencias - se deja sin configurar

ProblemType: Package
Architecture: i386
DistroRelease: Ubuntu 8.10
ErrorMessage: el subproceso post-installation script devolvió el código de salida de error 1
Package: moodle 1.8.2-1.2ubuntu2
PackageArchitecture: all
SourcePackage: moodle
Title: package moodle 1.8.2-1.2ubuntu2 failed to install/upgrade: el subproceso post-installation script devolvió el código de salida de error 1
Uname: Linux 2.6.27-9-generic i686

[Jean-Baptiste Lallement (jibel)]

Thanks for your report

The error is
=====
Configurando moodle (1.8.2-1.2ubuntu2) ...
 * Reloading web server config apache2
apache2: Could not reliably determine the server's fully qualified domain name, using 127.0.1.1 for ServerName
   ...done.
uid=113(moodle-miquel) gid=65534(nogroup) grupos=65534(nogroup)
ERROR: error de sintaxis en o cerca de «-»
LINE 1: CREATE ROLE moodle-miquel PASSWORD 'murphyaiken' NOSUPERUSER...
                          ^
dpkg: error al procesar moodle (--configure):
 el subproceso post-installation script devolvió el código de salida de error 1
=====

It looks like the role "moodle-miquel" is invalid. Could you please retry with a role name without the "-"

Thanks.

[LaserJock (laserjock)]

Looks like we need to quote DB usernames in postinst. See also bug #303070

[LaserJock (laserjock)]

I think I've got this bug figured out but please do respond to Jean-Baptiste's request as that should confirm the problem.