Package: moodle Version: 1.6.3-2 Severity: grave Justification: renders package unusable
Whenever I tried to access http://localhost/moodle/admin/ I get same error over and over: Error: Database connection failed. It is possible that the database is overloaded or otherwise not running properly. The site administrator should also check that the database details have been correctly specified in config.php ;-¿? I don't know what to do. I have purged and reinstalled several times postgress and moodle. I have googled till I'm really tired. In fact, I have checked every little thing I have found in Google regarding this problem. And, of course, I have followed line by line /usr/share/doc/moodle/README.Debian. Executing from console: createdb -O moodle -e -U moodle prueba I get: Contraseña: CREATE DATABASE prueba OWNER moodle; createdb: falló la creación de la base de datos: ERROR: se ha denegado el permiso a crear la base de datos Why? User moodle exists, see it: $ createuser -A -d -P -e -U postgres moodle Ingrese la contraseña para el nuevo usuario: Ingrésela nuevamente: Contraseña: CREATE USER moodle PASSWORD 'xxxxxxxxx' CREATEDB NOCREATEUSER; createuser: falló la creación del nuevo usuario: ERROR: ya existe el usuario "moodle" So? The installation scrips has created a user moodle that has not been granted privileges for creating databases? Is it possible? Moreover: $ createdb -O moodle -e -U postgres moodle Contraseña: CREATE DATABASE moodle OWNER moodle; createdb: falló la creación de la base de datos: ERROR: la base de datos "moodle" ya existe So? Why moodle doesn't work if database moodle exists? Thanks a lot. Your time and efforts are greatly appreciated. -- System Information: Debian Release: 4.0 APT prefers testing APT policy: (500, 'testing') Architecture: i386 (i686) Shell: /bin/sh linked to /bin/bash Kernel: Linux 2.6.18-3-k7 Locale: [EMAIL PROTECTED], [EMAIL PROTECTED] (charmap=ISO-8859-15) Versions of packages moodle depends on: ii apache2-mpm-prefork [httpd] 2.2.3-3.2 Traditional model for Apache HTTPD ii debconf [debconf-2.0] 1.5.11 Debian configuration management sy ii libapache2-mod-php4 6:4.4.4-8 server-side, HTML-embedded scripti ii mimetex 1.50-1 LaTeX math expressions to anti-ali ii php4-cli 6:4.4.4-8 command-line interpreter for the p ii php4-gd 6:4.4.4-8 GD module for php4 ii php4-pgsql 6:4.4.4-8 PostgreSQL module for php4 ii ucf 2.0017 Update Configuration File: preserv ii wwwconfig-common 0.0.48 Debian web auto configuration Versions of packages moodle recommends: ii postgresql 7.5.22 object-relational SQL database man -- debconf information: * moodle/dbu_name: moodle * moodle/db_server: postgresql * moodle/db_host: localhost * moodle/create_tables: * moodle/webserver: apache2 moodle/notconfigured: moodle/mismatch: * moodle/dba_name: postgres