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
--
To UNSUBSCRIBE, email to [EMAIL PROTECTED]
with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
