Your message dated Tue, 05 Jun 2007 23:32:04 +0000 with message-id <[EMAIL PROTECTED]> and subject line Bug#427001: fixed in drupal5 5.1-2 has caused the attached Bug report 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 I am talking about this indicates a serious mail system misconfiguration somewhere. Please contact me immediately.) Debian bug tracking system administrator (administrator, Debian Bugs database)
--- Begin Message ---Package: drupal5 Version: 5.1-1 The README.Debian.gz file does not explain how to create database tables for drupal. My suggestion is to add documentation, to avoid the process I went through: After installing drupal5, I tried to access my new site, and got errors such as: Warning: pg_query() [function.pg-query]: Query failed: ERROR: relation "access" does not exist in /usr/share/drupal5/includes/database.pgsql.inc on line 125 Warning: ERROR: relation "access" does not exist query: SELECT CASE WHEN status=1 THEN 0 ELSE 1 END FROM access WHERE type = 'host' AND LOWER('10.5.5.7') LIKE LOWER(mask) ORDER BY status DESC LIMIT 1 OFFSET 0 in /usr/share/drupal5/includes/database.pgsql.inc on line 144 Looking closer, I found that the drupal5 database has no tables. I can log in with "psql -U drupal5 -h localhost drupal5", using the password in /etc/drupal/5/sites/default/dbconfig.php , so it appears that the database exists and user access is configured correctly. I checked /usr/share/doc/drupal5/INSTALL.pgsql.txt for hints on setting up the DB, but it only explained the parts I had already verified as working. It does not mention loading a schema. So, I checked upstream sources. The INSTALL.txt in the upstream source says to create DB tables simply by loading the site's front page in a web browser, then clicking "Database Configuration". I just get errors on the front page, so there is no link to follow. Asking on #drupal-support, I found that the correct URL is http://mysite/install.php So, I tried that URL, and got a different error: Fatal error: Allowed memory size of 8388608 bytes exhausted (tried to allocate 23040 bytes) in /usr/share/drupal5/modules/node/node.module on line 1692 Oops, I had the default PHP settings, which apparently are too restrictive. So, I changed the limit to 40M, reloaded the page, and got a "drupal is already installed" error. Fair enough; the previous attempt got killed. So, I dropped/recreated the DB and tried install.php again, and it worked. Anyway, a bit of text added to README.Debian.gz would help improve this process. :) -- System Information: Debian Release: 4.0 APT prefers unstable APT policy: (500, 'unstable') Architecture: ia64 Kernel: Linux 2.6.18-4-mckinley (SMP w/1 CPU core) Locale: LANG=en_US.UTF-8, LC_CTYPE=en_US.UTF-8 (charmap=UTF-8) Shell: /bin/sh linked to /bin/bash Versions of packages drupal5 depends on: ii apache2-mpm-prefork [httpd] 2.2.3-4 Traditional model for Apache HTTPD ii curl 7.16.2-4 Get a file from an HTTP, HTTPS or ii dbconfig-common 1.8.34 common framework for packaging dat ii debconf 1.5.13 Debian configuration management sy ii php4 6:4.4.4-9 server-side, HTML-embedded scripti ii php4-gd 6:4.4.6-2+b2 GD module for php4 ii php4-mysql 6:4.4.6-2+b2 MySQL module for php4 ii php4-pgsql 6:4.4.6-2+b2 PostgreSQL module for php4 ii postfix [mail-transport-age 2.4.0-2 A high-performance mail transport ii postgresql-client-8.1 8.1.8-1 front-end programs for PostgreSQL ii wwwconfig-common 0.0.48 Debian web auto configuration Versions of packages drupal5 recommends: pn mysql-server | postgresql-ser <none> (no description available) -- debconf information: drupal5/pgsql/app-pass: (password omitted) drupal5/pgsql/admin-pass: (password omitted) drupal5/mysql/app-pass: (password omitted) drupal5/password-confirm: (password omitted) drupal5/app-password-confirm: (password omitted) drupal5/mysql/admin-pass: (password omitted) drupal5/internal/skip-preseed: false drupal5/pgsql/changeconf: false drupal5/db/app-user: drupal5 drupal5/pgsql/manualconf: drupal5/pgsql/no-empty-passwords: drupal5/pgsql/authmethod-admin: ident drupal5/mysql/admin-user: root drupal5/pgsql/authmethod-user: ident * drupal5/webserver: apache2 drupal5/mysql/method: unix socket drupal5/install-error: abort drupal5/passwords-do-not-match: drupal5/remote/newhost: drupal5/dbconfig-upgrade: true * drupal5/database-type: pgsql drupal5/pgsql/method: unix socket drupal5/remove-error: abort drupal5/upgrade-backup: true drupal5/purge: false drupal5/dbconfig-reinstall: false drupal5/db/dbname: drupal5 drupal5/pgsql/admin-user: postgres drupal5/upgrade-error: abort drupal5/internal/reconfiguring: false drupal5/dbconfig-remove: drupal5/remote/host: drupal5/db/basepath: drupal5/remote/port: * drupal5/dbconfig-install: true
--- End Message ---
--- Begin Message ---Source: drupal5 Source-Version: 5.1-2 We believe that the bug you reported is fixed in the latest version of drupal5, which is due to be installed in the Debian FTP archive: drupal5_5.1-2.diff.gz to pool/main/d/drupal5/drupal5_5.1-2.diff.gz drupal5_5.1-2.dsc to pool/main/d/drupal5/drupal5_5.1-2.dsc drupal5_5.1-2_all.deb to pool/main/d/drupal5/drupal5_5.1-2_all.deb A summary of the changes between this version and the previous one is attached. Thank you for reporting the bug, which will now be closed. If you have further comments please address them to [EMAIL PROTECTED], and the maintainer will reopen the bug report if appropriate. Debian distribution maintenance software pp. Luigi Gangitano <[EMAIL PROTECTED]> (supplier of updated drupal5 package) (This message was generated automatically at their request; if you believe that there is a problem with it please contact the archive administrators by mailing [EMAIL PROTECTED]) -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Format: 1.7 Date: Tue, 13 Mar 2007 00:21:14 +0100 Source: drupal5 Binary: drupal5 Architecture: source all Version: 5.1-2 Distribution: unstable Urgency: low Maintainer: Luigi Gangitano <[EMAIL PROTECTED]> Changed-By: Luigi Gangitano <[EMAIL PROTECTED]> Description: drupal5 - a fully-featured content management framework Closes: 427001 Changes: drupal5 (5.1-2) unstable; urgency=low . [ Luigi Gangitano ] - debian/control * Added Xs-Vcs-{Svn,Browser} tags . - debian/README.Debian * Added istructions on Postgres database install and PHP memory limit (Closes: #427001) . [ Bart Cornelis (cobaco) ] - New Norwegian Bokmael translation by Hans Fredrik Nordhaug Files: 189c9bca0c5ff237389f69cc825abef1 706 web extra drupal5_5.1-2.dsc 4111a289190322ea5631faa7471a6bdc 24453 web extra drupal5_5.1-2.diff.gz d50013ba01cdefbdb49605bf1b9cad9a 763780 web extra drupal5_5.1-2_all.deb -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.6 (GNU/Linux) iD8DBQFGZe8k8ZumGJJMDCYRAgyIAKCBTfEVyUczN+dq9MOOLv4BRFTE6gCfZe9n 2Lh8AgIxEQxZM7RU75qzkeM= =BDcj -----END PGP SIGNATURE-----
--- End Message ---
