Your message dated Fri, 18 Feb 2011 20:33:24 +0100
with message-id <[email protected]>
and subject line Re: Bug#597470: drupal6: INSTALL.pgsql.txt problems
has caused the Debian Bug report #597470,
regarding drupal6: INSTALL.pgsql.txt problems
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.)
--
597470: http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=597470
Debian Bug Tracking System
Contact [email protected] with problems
--- Begin Message ---
Package: drupal6
Version: 6.18-1
After running into #516026 where the package couldn't setup the database
properly, I decided to follow the option suggested in README.Debian of
setting up the database by hand. I am using postgresql so I followed
INSTALL.pgsql.txt. Here's a couple things I ran into.
1) It might be useful to mention that steps to create the user and database
must be done as a user that has the correct rights to do this, the root
user doesn't by default but the postgres user does. Minor, but might be
nice.
2) I had to install php5-pgsql by hand because the packages "php5-mysql |
php5-pgsql" dependency had failed to pull it in.
3) After creating the db user and database, there were no instuctions what
to do next. I edited /etc/drupal/6/sites/default/dbconfig.php and plugged
in the info I had provided when setting up the database. After doing that
when trying to load the default url http://site/drupal6/ I got a big php
error dump with a bunch of things similar to this
Warning: pg_query() [function.pg-query]: Query failed: ERROR: relation
"access" does not exist in /usr/share/drupal6/includes/database.pgsql.inc
on line 139
Warning: ERROR: relation "access" does not exist query: SELECT 1 FROM
access WHERE type = 'host' AND LOWER('127.0.1.1') LIKE LOWER(mask) AND
status = 0 LIMIT 1 OFFSET 0 in /usr/share/drupal6/includes/database.pgsql.in
c on line 160
It looks like the database schema needs to be setup somehow. Was I supposed
to have run something else to do that or is drupal supposed to take care of
that?
--
Matt Taggart
[email protected]
--- End Message ---
--- Begin Message ---
I'm closing this bug since all the information to get the database running is
available in the documentation (README.Debian).
Regards,
L
--
Luigi Gangitano -- <[email protected]> -- <[email protected]>
GPG: 1024D/924C0C26: 12F8 9C03 89D3 DB4A 9972 C24A F19B A618 924C 0C26
--- End Message ---
