Your message dated Sun, 06 Feb 2011 01:09:33 +0000
with message-id <[email protected]>
and subject line Closing
has caused the Debian Bug report #406387,
regarding error: database connection failed after installation
to be marked as done.
This means that you claim that the problem has been dealt with.
If this is not the case it is now your responsibility to reopen the
Bug report if necessary, and/or fix the problem forthwith.
(NB: If you are a system administrator and have no idea what this
message is talking about, this may indicate a serious mail system
misconfiguration somewhere. Please contact [email protected]
immediately.)
--
406387: http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=406387
Debian Bug Tracking System
Contact [email protected] with problems
--- Begin Message ---
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: LANG=es_ES@euro, LC_CTYPE=es_ES@euro (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
--- End Message ---
--- Begin Message ---
Old bug that I can not reproduce, closing.
--- End Message ---