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
tagg...@debian.org





-- 
To UNSUBSCRIBE, email to debian-bugs-dist-requ...@lists.debian.org
with a subject of "unsubscribe". Trouble? Contact listmas...@lists.debian.org

Reply via email to