[pkg-horde] Bug#508571: Bug#508571: horde3: pgsql create script fails

Ola Lundqvist opal at debian.org
Tue Dec 16 17:21:29 UTC 2008


Thanks for the report.
Will be fixed after lenny is out of the door.
Debian is currently in deep freeze before the release.

Best regards,

// Ola

On Fri, Dec 12, 2008 at 11:20:33AM -0600, Karl Nack wrote:
> Package: horde3
> Version: 3.2.2+debian0-1
> Severity: normal
> Tags: patch
> 
> The create.pgsql.sql script fails (running postgresql 8.3.5). After creating and switching to the horde database, it fails to create new relations with error 
> "permission denied for schema public".
> 
> The script erroneously grants CREATE on the database, which only allows creation of new schemas:
> 
> GRANT CREATE on DATABASE horde to horde;
> \c horde horde;
> 
> 
> The script should grant CREATE on the schema:
> 
> \c horde
> GRANT CREATE ON SCHEMA public TO horde;
> SET ROLE horde;
> 
> Also, the script should probably run inside a transaction. After the script fails, the user is left the horde user and an empty horde database.
> 
> 
> -- System Information:
> Debian Release: lenny/sid
>   APT prefers testing
>   APT policy: (990, 'testing'), (500, 'unstable')
> Architecture: amd64 (x86_64)
> 
> Kernel: Linux 2.6.26-1-amd64 (SMP w/2 CPU cores)
> 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 horde3 depends on:
> ii  apache2                       2.2.9-10   Apache HTTP Server metapackage
> ii  apache2-mpm-prefork [httpd]   2.2.9-10   Apache HTTP Server - traditional n
> ii  libapache2-mod-php5           5.2.6-5    server-side, HTML-embedded scripti
> ii  libjs-scriptaculous           1.8.1-5    JavaScript library for dynamic web
> ii  php-log                       1.10.0-1   Log module for PEAR
> ii  php-mail                      1.1.14-1   PHP PEAR module for sending email
> ii  php-mail-mime                 1.5.2-0.1  PHP PEAR module for creating MIME 
> ii  php5-gd                       5.2.6-5    GD module for php5
> ii  php5-mcrypt                   5.2.6-5    MCrypt module for php5
> 
> Versions of packages horde3 recommends:
> pn  fckeditor                     <none>     (no description available)
> ii  locales                       2.7-16     GNU C Library: National Language (
> ii  logrotate                     3.7.1-5    Log rotation utility
> pn  php-date                      <none>     (no description available)
> pn  php-db                        <none>     (no description available)
> pn  php-file                      <none>     (no description available)
> pn  php-services-weather          <none>     (no description available)
> ii  php5-cli                      5.2.6-5    command-line interpreter for the p
> ii  php5-pgsql                    5.2.6-5    PostgreSQL module for php5
> pn  tinymce2 | tinymce            <none>     (no description available)
> 
> Versions of packages horde3 suggests:
> pn  chora2                        <none>     (no description available)
> ii  enscript                      1.6.4-13   Converts ASCII text to Postscript,
> ii  gettext                       0.17-4     GNU Internationalization utilities
> pn  gollem                        <none>     (no description available)
> pn  imp4                          <none>     (no description available)
> pn  kronolith2                    <none>     (no description available)
> pn  libgeoip1                     <none>     (no description available)
> pn  libwpd-tools                  <none>     (no description available)
> pn  mnemo2                        <none>     (no description available)
> pn  php-net-imap                  <none>     (no description available)
> pn  php5-auth-pam                 <none>     (no description available)
> pn  php5-mhash                    <none>     (no description available)
> pn  ppthtml                       <none>     (no description available)
> pn  rpm                           <none>     (no description available)
> pn  source-highlight              <none>     (no description available)
> pn  turba2                        <none>     (no description available)
> pn  unrtf                         <none>     (no description available)
> pn  webcpp                        <none>     (no description available)
> pn  wv                            <none>     (no description available)
> pn  xlhtml                        <none>     (no description available)
> 
> -- no debconf information

> -- $Horde: horde/scripts/sql/create.pgsql.sql,v 1.1.10.17 2008/05/27 14:24:37 mrubinsk Exp $
> --
> -- Uncomment the ALTER line below and change the password.  Then run as:
> --
> -- $ psql -d template1 -f create.pgsql.sql
> 
> CREATE DATABASE horde;
> 
> CREATE USER horde;
> -- ALTER USER horde WITH PASSWORD 'pass';
> 
> \c horde
> GRANT CREATE ON SCHEMA public TO horde;
> SET ROLE horde;
> 
> CREATE TABLE horde_users (
>     user_uid                    VARCHAR(255) NOT NULL,
>     user_pass                   VARCHAR(255) NOT NULL,
>     user_soft_expiration_date   INTEGER,
>     user_hard_expiration_date   INTEGER,
> --
>     PRIMARY KEY (user_uid)
> );
> 
> CREATE TABLE horde_groups (
>     group_uid INTEGER NOT NULL,
>     group_name VARCHAR(255) NOT NULL UNIQUE,
>     group_parents VARCHAR(255) NOT NULL,
>     group_email VARCHAR(255),
>     PRIMARY KEY (group_uid)
> );
> 
> CREATE TABLE horde_groups_members (
>     group_uid INTEGER NOT NULL,
>     user_uid VARCHAR(255) NOT NULL
> );
> 
> CREATE INDEX group_uid_idx ON horde_groups_members (group_uid);
> CREATE INDEX user_uid_idx ON horde_groups_members (user_uid);
> 
> CREATE TABLE horde_perms (
>     perm_id INTEGER NOT NULL,
>     perm_name VARCHAR(255) NOT NULL UNIQUE,
>     perm_parents VARCHAR(255) NOT NULL,
>     perm_data TEXT,
>     PRIMARY KEY (perm_id)
> );
> 
> CREATE TABLE horde_prefs (
>     pref_uid        VARCHAR(255) NOT NULL,
>     pref_scope      VARCHAR(16) DEFAULT '' NOT NULL,
>     pref_name       VARCHAR(32) NOT NULL,
>     pref_value      TEXT,
> --
>     PRIMARY KEY (pref_uid, pref_scope, pref_name)
> );
> 
> CREATE INDEX pref_uid_idx ON horde_prefs (pref_uid);
> CREATE INDEX pref_scope_idx ON horde_prefs (pref_scope);
> 
> CREATE TABLE horde_datatree (
>     datatree_id INT NOT NULL,
>     group_uid VARCHAR(255) NOT NULL,
>     user_uid VARCHAR(255) NOT NULL,
>     datatree_name VARCHAR(255) NOT NULL,
>     datatree_parents VARCHAR(255) NOT NULL,
>     datatree_order INT,
>     datatree_data TEXT,
>     datatree_serialized SMALLINT DEFAULT 0 NOT NULL,
> 
>     PRIMARY KEY (datatree_id)
> );
> 
> CREATE INDEX datatree_datatree_name_idx ON horde_datatree (datatree_name);
> CREATE INDEX datatree_group_idx ON horde_datatree (group_uid);
> CREATE INDEX datatree_user_idx ON horde_datatree (user_uid);
> CREATE INDEX datatree_order_idx ON horde_datatree (datatree_order);
> CREATE INDEX datatree_serialized_idx ON horde_datatree (datatree_serialized);
> CREATE INDEX datatree_parents_idx ON horde_datatree (datatree_parents);
> 
> CREATE TABLE horde_datatree_attributes (
>     datatree_id INT NOT NULL,
>     attribute_name VARCHAR(255) NOT NULL,
>     attribute_key VARCHAR(255),
>     attribute_value TEXT
> );
> 
> CREATE INDEX datatree_attribute_idx ON horde_datatree_attributes USING HASH(datatree_id);
> CREATE INDEX datatree_attribute_name_idx ON horde_datatree_attributes (attribute_name);
> CREATE INDEX datatree_attribute_key_idx ON horde_datatree_attributes (attribute_key);
> CREATE INDEX datatree_attribute_value_idx ON horde_datatree_attributes (attribute_value);
> 
> CREATE TABLE horde_tokens (
>     token_address    VARCHAR(100) NOT NULL,
>     token_id         VARCHAR(32) NOT NULL,
>     token_timestamp  BIGINT NOT NULL,
> --
>     PRIMARY KEY (token_address, token_id)
> );
> 
> CREATE TABLE horde_vfs (
>     vfs_id        BIGINT NOT NULL,
>     vfs_type      SMALLINT NOT NULL,
>     vfs_path      VARCHAR(255) NOT NULL,
>     vfs_name      VARCHAR(255) NOT NULL,
>     vfs_modified  BIGINT NOT NULL,
>     vfs_owner     VARCHAR(255) NOT NULL,
>     vfs_data      TEXT,
> 
>     PRIMARY KEY   (vfs_id)
> );
> 
> CREATE INDEX vfs_path_idx ON horde_vfs (vfs_path);
> CREATE INDEX vfs_name_idx ON horde_vfs (vfs_name);
> 
> CREATE TABLE horde_histories (
>     history_id       BIGINT NOT NULL,
>     object_uid       VARCHAR(255) NOT NULL,
>     history_action   VARCHAR(32) NOT NULL,
>     history_ts       BIGINT NOT NULL,
>     history_desc     TEXT,
>     history_who      VARCHAR(255),
>     history_extra    TEXT,
> --
>     PRIMARY KEY (history_id)
> );
> 
> CREATE INDEX history_action_idx ON horde_histories (history_action);
> CREATE INDEX history_ts_idx ON horde_histories (history_ts);
> CREATE INDEX history_uid_idx ON horde_histories (object_uid);
> 
> CREATE TABLE horde_sessionhandler (
>     session_id             VARCHAR(32) NOT NULL,
>     session_lastmodified   BIGINT NOT NULL,
>     session_data           TEXT,
>     PRIMARY KEY (session_id)
> );
> 
> CREATE TABLE horde_syncml_map (
>     syncml_syncpartner VARCHAR(255) NOT NULL,
>     syncml_db          VARCHAR(255) NOT NULL,
>     syncml_uid         VARCHAR(255) NOT NULL,
>     syncml_cuid        VARCHAR(255),
>     syncml_suid        VARCHAR(255),
>     syncml_timestamp   BIGINT
> );
> 
> CREATE INDEX syncml_syncpartner_idx ON horde_syncml_map (syncml_syncpartner);
> CREATE INDEX syncml_db_idx ON horde_syncml_map (syncml_db);
> CREATE INDEX syncml_uid_idx ON horde_syncml_map (syncml_uid);
> CREATE INDEX syncml_cuid_idx ON horde_syncml_map (syncml_cuid);
> CREATE INDEX syncml_suid_idx ON horde_syncml_map (syncml_suid);
> 
> CREATE TABLE horde_syncml_anchors(
>     syncml_syncpartner  VARCHAR(255) NOT NULL,
>     syncml_db           VARCHAR(255) NOT NULL,
>     syncml_uid          VARCHAR(255) NOT NULL,
>     syncml_clientanchor VARCHAR(255),
>     syncml_serveranchor VARCHAR(255)
> );
> 
> CREATE INDEX syncml_anchors_syncpartner_idx ON horde_syncml_anchors (syncml_syncpartner);
> CREATE INDEX syncml_anchors_db_idx ON horde_syncml_anchors (syncml_db);
> CREATE INDEX syncml_anchors_uid_idx ON horde_syncml_anchors (syncml_uid);
> 
> CREATE TABLE horde_alarms (
>     alarm_id        VARCHAR(255) NOT NULL,
>     alarm_uid       VARCHAR(255),
>     alarm_start     TIMESTAMP NOT NULL,
>     alarm_end       TIMESTAMP,
>     alarm_methods   VARCHAR(255),
>     alarm_params    TEXT,
>     alarm_title     VARCHAR(255) NOT NULL,
>     alarm_text      TEXT,
>     alarm_snooze    TIMESTAMP,
>     alarm_dismissed SMALLINT DEFAULT 0 NOT NULL,
>     alarm_internal  TEXT
> );
> 
> CREATE INDEX alarm_id_idx ON horde_alarms (alarm_id);
> CREATE INDEX alarm_user_idx ON horde_alarms (alarm_uid);
> CREATE INDEX alarm_start_idx ON horde_alarms (alarm_start);
> CREATE INDEX alarm_end_idx ON horde_alarms (alarm_end);
> CREATE INDEX alarm_snooze_idx ON horde_alarms (alarm_snooze);
> CREATE INDEX alarm_dismissed_idx ON horde_alarms (alarm_dismissed);
> 
> CREATE TABLE horde_cache (
>     cache_id          VARCHAR(32) NOT NULL,
>     cache_timestamp   BIGINT NOT NULL,
>     cache_expiration  BIGINT NOT NULL,
>     cache_data        TEXT,
> --
>     PRIMARY KEY  (cache_id)
> );
> 
> CREATE TABLE horde_locks (
>     lock_id                  VARCHAR(36) NOT NULL,
>     lock_owner               VARCHAR(32) NOT NULL,
>     lock_principal           VARCHAR(255) NOT NULL,
>     lock_origin_timestamp    BIGINT NOT NULL,
>     lock_update_timestamp    BIGINT NOT NULL,
>     lock_expiry_timestamp    BIGINT NOT NULL,
>     lock_type                SMALLINT NOT NULL,
> 
>     PRIMARY KEY (lock_id)
> );

> _______________________________________________
> pkg-horde-hackers mailing list
> pkg-horde-hackers at lists.alioth.debian.org
> http://lists.alioth.debian.org/mailman/listinfo/pkg-horde-hackers

-- 
 --------------------- Ola Lundqvist ---------------------------
/  opal at debian.org                     Annebergsslingan 37      \
|  ola at inguza.com                      654 65 KARLSTAD          |
|  http://inguza.com/                  +46 (0)70-332 1551       |
\  gpg/f.p.: 7090 A92B 18FE 7994 0C36  4FE4 18A1 B1CF 0FE5 3DD9 /
 ---------------------------------------------------------------





More information about the pkg-horde-hackers mailing list